<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18975">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>At RMIT we will also be doing both spreadsheets and databases. From
our perspective, our students often have no or very little knowledge of
spreadsheets and no knowledge of databases.</DIV>
<DIV> </DIV>
<DIV>As Mark has found, our students in each year of the previous course have
disliked, no hated, no detested databases. We have run the database SAC
for the first SAC to get the hard work out of the way before they start SACs in
other subjects - then it's more or less downhill the rest of the way.</DIV>
<DIV> </DIV>
<DIV>While most of the students have no, or little skill, in using spreadsheets,
doing U4O1 with spreadsheets is more of a breeze and the students feel more
comfortable and enthusiastic about the subject. They also like it because
they can make mistakes that don't come round to bite them on the b#@&* later
on.</DIV>
<DIV> </DIV>
<DIV>Each year we have reflected on the running of the SACs and the unanimous
decision from the students is that we do do it the "right" way.</DIV>
<DIV> </DIV>
<DIV>Because of the social, cultural, economic and educational background
of many of our students, our attrition rate is high - it would be even higher if
I were to run two databases.</DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial>Regards</FONT></DIV>
<DIV><FONT size=2 face=Arial>Geoff Moss</FONT></DIV>
<DIV><FONT size=2 face=Arial>RMIT</FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=kel@mckinnonsc.vic.edu.au
href="mailto:kel@mckinnonsc.vic.edu.au">Mark KELLY</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=itapps@edulists.com.au
href="mailto:itapps@edulists.com.au">Year 12 IT Applications Teachers' Mailing
List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, November 11, 2010 3:39
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Year 12 IT Apps] Unit 4
2011: RDBMS Part 2 or Spreadsheets</DIV>
<DIV><BR></DIV>Hi all. <BR><BR>Spreadsheets and databases have a lot of common
content, to the point of having identical formulas at times. <BR><BR>I've just
finished writing a couple of practice exams for next year, and a question that
could be answered with either spreadsheet or database knowledge was easier
than I thought it would be to write.<BR><BR>I'll be doing spreadsheets and
databases as well as everyone else seems to be. While it's true that after
skilling up for U3O2 it's not hard to learn a few more skills for databases
again in U4O1, I think it's more of an issue of kids' attitudes.
<BR><BR>They dislike databases; <I>really </I>dislike databases. They really
<I>like</I> spreadsheets. Their marks this year in my class confirm that they
put far less energy and care into the database task. <BR><BR>Many of
them felt down after U3O1. Switching to Excel for U4O1 was a clean slate
for them mentally and they tackled it with renewed vigour. They really pulled
out all the stops for Excel and lifted their marks considerably.
<BR><BR>The prospect of doing two depressing database tasks in a row would not
make them happy munchkins next year. <BR><BR>Most kids have had quite a
bit of Excel experience upon entry to ITA, so training is not a big
hurdle. And, as I mentioned above, the similarities of the SS/dB content
makes the transition to spreadsheets pretty easy, leveraging existing dB
skills.<BR><BR>Sorry for rambling. Just finished marking year 11 IT
exams and time now seems plentiful
;-)<BR><BR>Regards<BR>Mark<BR><BR><BR><BR>
<DIV class=gmail_quote>On 11 November 2010 14:37, Christophersen, Paula P
<SPAN dir=ltr><<A
href="mailto:christophersen.paula.p@edumail.vic.gov.au">christophersen.paula.p@edumail.vic.gov.au</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV lang=EN-AU vlink="purple" link="blue">
<DIV>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Dear Paul and colleagues</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>In the examinations, two possible scenarios will exist regarding
questions about spreadsheets and RDBMS. These are:</SPAN></FONT></P>
<P style="MARGIN-LEFT: 18pt"><FONT size=1 face=Symbol><SPAN
style="FONT-FAMILY: Symbol; FONT-SIZE: 9pt" lang=EN-US><SPAN>·<FONT size=1
face="Times New Roman"><SPAN
style="FONT: 7pt 'Times New Roman'">
</SPAN></FONT></SPAN></SPAN></FONT><SPAN lang=EN-US>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.</SPAN></P>
<P style="MARGIN-LEFT: 18pt"><FONT size=1 face=Symbol><SPAN
style="FONT-FAMILY: Symbol; FONT-SIZE: 9pt" lang=EN-US><SPAN>·<FONT size=1
face="Times New Roman"><SPAN
style="FONT: 7pt 'Times New Roman'">
</SPAN></FONT></SPAN></SPAN></FONT><SPAN lang=EN-US>Questions that allow
students to answer from either a spreadsheet <B><SPAN
style="FONT-WEIGHT: bold">or</SPAN></B> 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
<B><SPAN style="FONT-WEIGHT: bold">one</SPAN></B> 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.</SPAN></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>No 'standalone' spreadsheet questions can be asked – as it is in
accordance with the <B><SPAN style="FONT-WEIGHT: bold">choice</SPAN></B>
aspect of Area of Study 1, Unit 4. </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>In Term 1 next year, a series of sample questions will be posted
on the VCAA website which will illustrate these different
scenarios.</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Regards</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Paula</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Paula Christophersen</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>ICT Curriculum Manager</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>VCAA</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>41 St Andrews Place</SPAN></FONT><SPAN lang=EN-US></SPAN></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>EAST MELBOURNE</SPAN></FONT><SPAN lang=EN-US> 3002</SPAN></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>(03) 9651 4378</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt" lang=EN-US>
<DIV class=im>-----Original Message-----<BR>From: <A
href="mailto:itapps-bounces@edulists.com.au"
target=_blank>itapps-bounces@edulists.com.au</A> [mailto:<A
href="mailto:itapps-bounces@edulists.com.au"
target=_blank>itapps-bounces@edulists.com.au</A>] On Behalf Of Paul
Golub<BR>Sent: Thursday, 11 November 2010 1:47 PM<BR>To: Year 12 IT
Applications Teachers' Mailing List<BR></DIV>
<DIV>
<DIV></DIV>
<DIV class=h5>Subject: Re: [Year 12 IT Apps] Unit 4 2011: RDBMS Part 2 or
Spreadsheets</DIV></DIV></SPAN></FONT>
<P></P>
<DIV>
<DIV></DIV>
<DIV class=h5>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>I was thinking of doing both as well. That way they can learn
spreadhseets as well.</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Lets say I didn't do spreadsheets, both were databases. What
happens in the exam? Can they ask spreadsheets questions?</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Paul Golub</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Santa Maria</SPAN></FONT><SPAN lang=EN-US> College</SPAN><SPAN
lang=EN-US></SPAN></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>50 Separation Street</SPAN></FONT><SPAN lang=EN-US></SPAN></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Northcote 3070</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Ph: 9488 1674</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>-----Original message-----</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>From: "Litsa Tzelepis" <A href="mailto:htzelepis@msj.vic.edu.au"
target=_blank>htzelepis@msj.vic.edu.au</A></SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Date: Thu, 11 Nov 2010 09:28:06 +1100</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>To: "Year 12 IT Applications Teachers' Mailing List" <A
href="mailto:itapps@edulists.com.au"
target=_blank>itapps@edulists.com.au</A></SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Subject: Re: [Year 12 IT Apps] Unit 4 2011: RDBMS Part 2 or
Spreadsheets</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>I agree - I'll be doing the same, besides its a good
balance.</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> ----- Original Message ----- </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> From: Elliot, Mitchell E </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> To: Year 12 IT Applications Teachers' Mailing List
</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> Sent: Thursday, November 11, 2010 10:14
AM</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> Subject: Re: [Year 12 IT Apps] Unit 4 2011: RDBMS Part 2
or Spreadsheets</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> I was thinking of doing the same, Database unit 3 and
spreadsheets unit 4 mostly in case they can put both on the
exam.</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> Mitch Elliot | Buckley Park College | Cooper St, Essendon
3040 | (03) 9331 9999 | <A
href="mailto:elliot.mitchell.e@edumail.vic.gov.au"
target=_blank>elliot.mitchell.e@edumail.vic.gov.au</A></SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> From: <A href="mailto:itapps-bounces@edulists.com.au"
target=_blank>itapps-bounces@edulists.com.au</A> [mailto:<A
href="mailto:itapps-bounces@edulists.com.au"
target=_blank>itapps-bounces@edulists.com.au</A>] On Behalf Of Jackson
Bates</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> Sent: Thursday, 11 November 2010 9:59 AM</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> To: '<A href="mailto:itapps@edulists.com.au"
target=_blank>itapps@edulists.com.au</A>'</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> Subject: [Year 12 IT Apps] Unit 4 2011: RDBMS Part 2 or
Spreadsheets</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> Hi All,</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> Just out of curiosity, what are you all doing for unit 4:
Databases or spreadsheets? And what is your rationale for
this?</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> --</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> A reminder from VCAA about the functions to be
demonstrated in both:</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> (taken from <A
href="http://www.vcaa.vic.edu.au/vcaa/correspondence/bulletins/2010/July/vce_study.html#2"
target=_blank>http://www.vcaa.vic.edu.au/vcaa/correspondence/bulletins/2010/July/vce_study.html#2</A>)</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> Relational database management system </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> The following functions apply to Unit 3:</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .create tables</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .create relationships between tables</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .use a range of data types</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .electronic validation</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .create, edit and use queries</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .use of calculated fields</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .sort records or index on different
fields.</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> If students use a relational database management system in
Unit 4, the following additional functions apply:</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .import/export of data</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .format data for display</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .create and edit a range of forms, including different
data types and controls</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .create and edit a range of formatted
reports.</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> Spreadsheets </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .conditional formatting</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .formulae including simple functions (SUM, average,
maximum, minimum, count), conditional statements and lookup
tables</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .cell protection</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .graphs</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .insert notes/comments</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .macros</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .relative and absolute cell references</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .naming a range</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .electronic validation</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .sheet referencing</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> .formatting/layout</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> --</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> FWIW I'll probably run with spreadsheets, just for the
sake of building wider usable skills, but I'm open to
ideas.</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> 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?</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> Regards,</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> Jackson Bates</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> VCE IT Applications</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> Waverley Christian College</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>------------------------------------------------------------------------------</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>
------------------------------------------</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> 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 <A
href="mailto:srvadm@wcc.vic.edu.au"
target=_blank>srvadm@wcc.vic.edu.au</A>.</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> 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.</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>
------------------------------------------</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> 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.</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>------------------------------------------------------------------------------</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>
_______________________________________________</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> <A href="http://www.edulists.com.au"
target=_blank>http://www.edulists.com.au</A> - FAQ, resources, subscribe,
unsubscribe</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> IT Applications Mailing List kindly supported
by</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> <A
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html"
target=_blank>http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</A>
- Victorian Curriculum and Assessment Authority and</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> <A href="http://www.vitta.org.au"
target=_blank>http://www.vitta.org.au</A> - VITTA Victorian
Information Technology Teachers Association Inc</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>_____________________________________________________________________________</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> This email and any attachments may be confidential.
You must not disclose </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> or use the information in this email if you are not the
intended recipient.</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> If you have received this email in error, please notify us
immediately and </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> delete the email and all copies. The College does not
guarantee that this </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> email is virus or error free. The attached files are
provided and may only</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> be used on the basis that the user assumes all
responsibility for any loss,</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> damage or consequence resulting directly or indirectly from
the use of the </SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> attached files, whether caused by the negligence of the
sender or not. The</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> content and opinions in this email are not necessarily
those of the College</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>____________________________________________________________________________</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US></SPAN></FONT> </P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>_______________________________________________</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US><A href="http://www.edulists.com.au"
target=_blank>http://www.edulists.com.au</A> - FAQ, resources, subscribe,
unsubscribe</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>IT Applications Mailing List kindly supported
by</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US><A
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html"
target=_blank>http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</A>
- Victorian Curriculum and Assessment Authority and</SPAN></FONT></P>
<P><FONT size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"
lang=EN-US><A href="http://www.vitta.org.au"
target=_blank>http://www.vitta.org.au</A> - VITTA Victorian
Information Technology Teachers Association
Inc</SPAN></FONT></P></DIV></DIV></DIV>
<DIV>
<DIV></DIV>
<DIV class=h5>
<P></P>
<P><B>Important - </B>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.</P></DIV></DIV></DIV><BR>_______________________________________________<BR><A
href="http://www.edulists.com.au"
target=_blank>http://www.edulists.com.au</A> - FAQ, resources, subscribe,
unsubscribe<BR>IT Applications Mailing List kindly supported by<BR><A
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html"
target=_blank>http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</A>
- Victorian Curriculum and Assessment Authority and<BR><A
href="http://www.vitta.org.au" target=_blank>http://www.vitta.org.au</A>
- VITTA Victorian Information Technology Teachers Association
Inc<BR></BLOCKQUOTE></DIV><BR><BR clear=all><BR>-- <BR>Mark Kelly<BR>Manager
Information Systems<BR>Reporting Manager<BR>IT Learning Area
Manager<BR><BR>McKinnon Secondary College<BR>McKinnon Rd McKinnon
3204<BR>Victoria, Australia<BR>Direct line / Voicemail: +613 8520 9085<BR>Fax
+613 9578 9253<BR><A href="mailto:kel@mckinnonsc.vic.edu.au"
target=_blank>kel@mckinnonsc.vic.edu.au</A><BR><BR>VCE IT Lecture Notes: <A
href="http://vceit.com" target=_blank>http://vceit.com</A><BR>Moderator: IT
Applications Edulist<BR><BR>My cow died on this day two years ago. I
know because I noted it in my dairy.<BR><BR><BR>
<P>
<HR>
<P></P>_______________________________________________<BR>http://www.edulists.com.au
- FAQ, resources, subscribe, unsubscribe<BR>IT Applications Mailing List
kindly supported
by<BR>http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority
and<BR>http://www.vitta.org.au - VITTA Victorian Information Technology
Teachers Association Inc</BLOCKQUOTE></BODY></HTML>