[Year 12 IT Apps] Unit 4 2011: RDBMS Part 2 or Spreadsheets

Thu Nov 11 15:33:45 EST 2010

Thank you for your response Paula. That clears it up and makes sense.

Paul Golub
Santa Maria College
50 Separation Street
Northcote 3070
Ph: 9488 1674

-----Original message-----
From: "Christophersen, Paula P" christophersen.paula.p at edumail.vic.gov.au
Date: Thu, 11 Nov 2010 13:37:49 +1100
To: "Year 12 IT Applications Teachers' Mailing List" itapps at edulists.com.au
Subject: Re: [Year 12 IT Apps] Unit 4 2011: RDBMS Part 2 or Spreadsheets

Dear Paul and colleagues

In the examinations, two possible scenarios will exist regarding
questions about spreadsheets and RDBMS. These are:

*          Questions focusing exclusively on RDBMS as stipulated in Unit
3, as all students will have studied this. The designated software
functions for this tool are stated in the July 2010 VCE Bulletin. This
means that multiple choice questions and short and extended-type
questions can be asked on RDBMS at the unit 3 level.

*          Questions that allow students to answer from either a
spreadsheet or RDBMS perspective. In this instance questions must relate
to the KK and KS of Unit 4, area of study 1. Typically in this situation
there could be a general question to which students indicate whether
they are going to respond from a spreadsheet of a RDBMS perspective OR
there will be a Part a. and a Part b. and students select one of them.
The software functions for SS and the functions for Unit 4 of RDBMS are
both listed in the July 2010 Bulletin. If a RDBMS is being studied in
both Units 3 and 4, then teachers must be aware of the different
software expectations in each unit.

No 'standalone' spreadsheet questions can be asked - as it is in
accordance with the choice aspect of Area of Study 1, Unit 4.

In Term 1 next year, a series of sample questions will be posted on the
VCAA website which will illustrate these different scenarios.

Regards

Paula

Paula Christophersen

ICT Curriculum Manager

VCAA

41 St Andrews Place

EAST MELBOURNE 3002

(03) 9651 4378

-----Original Message-----
From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Paul Golub
Sent: Thursday, 11 November 2010 1:47 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] Unit 4 2011: RDBMS Part 2 or Spreadsheets

I was thinking of doing both as well. That way they can learn
spreadhseets as well.

Lets say I didn't do spreadsheets, both were databases. What happens in
the exam? Can they ask spreadsheets questions?

Paul Golub

Santa Maria College

50 Separation Street

Northcote 3070

Ph: 9488 1674

-----Original message-----

From: "Litsa Tzelepis" htzelepis at msj.vic.edu.au

Date: Thu, 11 Nov 2010 09:28:06 +1100

To: "Year 12 IT Applications Teachers' Mailing List"
itapps at edulists.com.au

Subject: Re: [Year 12 IT Apps] Unit 4 2011: RDBMS Part 2 or Spreadsheets

I agree - I'll be doing the same, besides its a good balance.

  ----- Original Message -----

  From: Elliot, Mitchell E

  To: Year 12 IT Applications Teachers' Mailing List

  Sent: Thursday, November 11, 2010 10:14 AM

  Subject: Re: [Year 12 IT Apps] Unit 4 2011: RDBMS Part 2 or
Spreadsheets

  I was thinking of doing the same, Database unit 3 and spreadsheets
unit 4 mostly in case they can put both on the exam.

  Mitch Elliot | Buckley Park College | Cooper St, Essendon 3040 | (03)
9331 9999 | elliot.mitchell.e at edumail.vic.gov.au

  From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Jackson Bates

  Sent: Thursday, 11 November 2010 9:59 AM

  To: 'itapps at edulists.com.au'

  Subject: [Year 12 IT Apps] Unit 4 2011: RDBMS Part 2 or Spreadsheets

  Hi All,

  Just out of curiosity, what are you all doing for unit 4: Databases or
spreadsheets? And what is your rationale for this?

  --

  A reminder from VCAA about the functions to be demonstrated in both:

  (taken from
http://www.vcaa.vic.edu.au/vcaa/correspondence/bulletins/2010/July/vce_s
tudy.html#2)

  Relational database management system

  The following functions apply to Unit 3:

  .create tables

  .create relationships between tables

  .use a range of data types

  .electronic validation

  .create, edit and use queries

  .use of calculated fields

  .sort records or index on different fields.

  If students use a relational database management system in Unit 4, the
following additional functions apply:

  .import/export of data

  .format data for display

  .create and edit a range of forms, including different data types and
controls

  .create and edit a range of formatted reports.

  Spreadsheets

  .conditional formatting

  .formulae including simple functions (SUM, average, maximum, minimum,
count), conditional statements and lookup tables

  .cell protection

  .graphs

  .insert notes/comments

  .macros

  .relative and absolute cell references

  .naming a range

  .electronic validation

  .sheet referencing

  .formatting/layout

  --

  FWIW I'll probably run with spreadsheets, just for the sake of
building wider usable skills, but I'm open to ideas.

  On a side note, I assume only the database knowledge from unit 3 can
be on the exam, since there is no way for the exam to differentiate
between those students that have done Databases Unit 4 or Spreadsheets.
Does my thinking seem sound on that?

  Regards,

  Jackson Bates

  VCE IT Applications

  Waverley Christian College

------------------------------------------------------------------------
------

  ------------------------------------------

  DISCLAIMER: This email and any files transmitted with it are
confidential and intended solely for the use of the individual or entity
to whom they are addressed. If you have received this email in error
please delete it immediately and notify the system administrator on
srvadm at wcc.vic.edu.au.

  WARNING: Although the college has taken reasonable precautions to
ensure no viruses are present in this email, the college cannot accept
responsibility for any loss or damage arising from the use of this email
or attachments.

  ------------------------------------------

  Important - This email and any attachments may be confidential. If
received in error, please contact us and delete all copies. Before
opening or using attachments check them for viruses and defects.
Regardless of any loss, damage or consequence, whether caused by the
negligence of the sender or not, resulting directly or indirectly from
the use of any attached files our liability is limited to resupplying
any affected attachments. Any representations or opinions expressed are
those of the individual sender, and not necessarily those of the
Department of Education and Early Childhood Development.

------------------------------------------------------------------------
------

  _______________________________________________

  http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe

  IT Applications Mailing List kindly supported by

  http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html
- Victorian Curriculum and Assessment Authority and

  http://www.vitta.org.au  - VITTA Victorian Information Technology
Teachers Association Inc

________________________________________________________________________
_____

 This email and any attachments may be confidential.  You must not
disclose

 or use the information in this email if you are not the intended
recipient.

 If you have received this email in error, please notify us immediately
and

 delete the email and all copies.  The College does not guarantee that
this

 email is virus or error free.  The attached files are provided and may
only

 be used on the basis that the user assumes all responsibility for any
loss,

 damage or consequence resulting directly or indirectly from the use of
the

 attached files, whether caused by the negligence of the sender or not.
The

 content and opinions in this email are not necessarily those of the
College

________________________________________________________________________
____

_______________________________________________

http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe

IT Applications Mailing List kindly supported by

http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority and

http://www.vitta.org.au  - VITTA Victorian Information Technology
Teachers Association Inc

Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.

_____________________________________________________________________________
 This email and any attachments may be confidential.  You must not disclose 
 or use the information in this email if you are not the intended recipient.
 If you have received this email in error, please notify us immediately and 
 delete the email and all copies.  The College does not guarantee that this  
 email is virus or error free.  The attached files are provided and may only
 be used on the basis that the user assumes all responsibility for any loss,
 damage or consequence resulting directly or indirectly from the use of the 
 attached files, whether caused by the negligence of the sender or not.  The
 content and opinions in this email are not necessarily those of the College
____________________________________________________________________________