<HTML>
<HEAD>
<TITLE>Re: [Year 12 IT Apps] Unit 4 2011: RDBMS Part 2 or Spreadsheets</TITLE>
</HEAD>
<BODY>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Good idea, also make sure you cover ‘swipe cards’. <BR>
<BR>
Zach Alexakos<BR>
<BR>
<BR>
<BR>
<BR>
On 11/11/10 10:14 AM, "Elliot, Mitchell E" <<a href="elliot.mitchell.e@edumail.vic.gov.au">elliot.mitchell.e@edumail.vic.gov.au</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><FONT COLOR="#1F497D">I was thinking of doing the same, Database unit 3 and spreadsheets unit 4 mostly in case they can put both on the exam.<BR>
<BR>
</FONT><BR>
</SPAN></FONT><FONT COLOR="#800080"><FONT SIZE="2"><FONT FACE="Arial Narrow"><SPAN STYLE='font-size:10pt'><B>Mitch Elliot</B></SPAN></FONT></FONT></FONT><FONT SIZE="2"><SPAN STYLE='font-size:10pt'><FONT COLOR="#008080"><FONT FACE="Lucida Calligraphy"> </FONT></FONT><FONT COLOR="#808080"><FONT FACE="Arial">| Buckley Park College | Cooper St, Essendon 3040 | (03) 9331 9999 | <a href="elliot.mitchell.e@edumail.vic.gov.au">elliot.mitchell.e@edumail.vic.gov.au</a></FONT></FONT><FONT FACE="Arial"><FONT COLOR="#008080"> <<a href="mailto:%7Celliot.mitchell.e@edumail.vic.gov.au">mailto:%7Celliot.mitchell.e@edumail.vic.gov.au</a>> <BR>
</FONT></FONT></SPAN></FONT><FONT COLOR="#1F497D"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'> <BR>
</SPAN></FONT></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
</SPAN></FONT><FONT SIZE="2"><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'><B>From:</B> <a href="itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a> [<a href="mailto:itapps-bounces@edulists.com.au">mailto:itapps-bounces@edulists.com.au</a>] <B>On Behalf Of </B>Jackson Bates<BR>
<B>Sent:</B> Thursday, 11 November 2010 9:59 AM<BR>
<B>To:</B> <a href="'itapps@edulists.com.au">'itapps@edulists.com.au</a>'<BR>
<B>Subject:</B> [Year 12 IT Apps] Unit 4 2011: RDBMS Part 2 or Spreadsheets<BR>
</SPAN></FONT></FONT><FONT FACE="Times New Roman"><SPAN STYLE='font-size:12pt'> <BR>
</SPAN></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
</SPAN></FONT><FONT SIZE="2"><FONT FACE="Courier New"><SPAN STYLE='font-size:10pt'>Hi All,<BR>
<BR>
Just out of curiosity, what are you all doing for unit 4: Databases or spreadsheets? And what is your rationale for this?<BR>
<BR>
--<BR>
<BR>
A reminder from VCAA about the functions to be demonstrated in both:<BR>
(taken from <a href="http://www.vcaa.vic.edu.au/vcaa/correspondence/bulletins/2010/July/vce_study.html#2">http://www.vcaa.vic.edu.au/vcaa/correspondence/bulletins/2010/July/vce_study.html#2</a>)<BR>
<BR>
<BR>
<B>Relational database management system <BR>
</B>The following functions apply to Unit 3:<BR>
<BR>
•create tables<BR>
•create relationships between tables<BR>
•use a range of data types<BR>
•electronic validation<BR>
•create, edit and use queries<BR>
•use of calculated fields<BR>
•sort records or index on different fields.<BR>
<BR>
<B>If students use a relational database management system in Unit 4, the following additional functions apply:<BR>
</B> <BR>
•import/export of data<BR>
•format data for display<BR>
•create and edit a range of forms, including different data types and controls<BR>
•create and edit a range of formatted reports.<BR>
<BR>
<B>Spreadsheets <BR>
</B> <BR>
•conditional formatting<BR>
•formulae including simple functions (SUM, average, maximum, minimum, count), conditional statements and lookup tables<BR>
•cell protection<BR>
•graphs<BR>
•insert notes/comments<BR>
•macros<BR>
•relative and absolute cell references<BR>
•naming a range<BR>
•electronic validation<BR>
•sheet referencing<BR>
•formatting/layout<BR>
<BR>
--<BR>
<BR>
FWIW I'll probably run with spreadsheets, just for the sake of building wider usable skills, but I'm open to ideas.<BR>
<BR>
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?<BR>
</SPAN></FONT><SPAN STYLE='font-size:10pt'><FONT FACE="Arial"> <BR>
Regards,<BR>
<BR>
Jackson Bates<BR>
VCE IT Applications<BR>
Waverley Christian College<BR>
</FONT></SPAN></FONT><FONT FACE="Times New Roman"><SPAN STYLE='font-size:12pt'>
</SPAN></FONT>
<P ALIGN=CENTER>
<FONT FACE="Times New Roman"><SPAN STYLE='font-size:12pt'><HR ALIGN=CENTER SIZE="2" WIDTH="100%"></SPAN></FONT>
<P>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
</SPAN></FONT><FONT FACE="Times New Roman"><SPAN STYLE='font-size:12pt'> <BR>
</SPAN></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
</SPAN></FONT><FONT FACE="Times New Roman"><SPAN STYLE='font-size:12pt'><BR>
</SPAN></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
</SPAN></FONT><FONT SIZE="1"><FONT FACE="Arial"><SPAN STYLE='font-size:8pt'>------------------------------------------<BR>
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="srvadm@wcc.vic.edu.au">srvadm@wcc.vic.edu.au</a>.<BR>
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.<BR>
------------------------------------------<BR>
</SPAN></FONT></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
</SPAN></FONT><FONT FACE="Times New Roman"><SPAN STYLE='font-size:12pt'><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.<BR>
</SPAN></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"></SPAN></FONT><FONT SIZE="2"><FONT FACE="Consolas, Courier New, Courier"><SPAN STYLE='font-size:10pt'>_______________________________________________<BR>
<a href="http://www.edulists.com.au">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">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">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc<BR>
</SPAN></FONT></FONT></BLOCKQUOTE>
<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>
</BODY>
</HTML>