<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style>
<!--
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New"}
span.EmailStyle17
{font-family:Arial;
color:windowtext}
@page Section1
{margin:72.0pt 69.6pt 72.0pt 69.6pt}
div.Section1
{}
-->
</style>
</head>
<body lang="EN-AU" link="blue" vlink="purple">
<div class="Section1">
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">Hi All,</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt"> </span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">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 class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt"> </span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">--</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt"> </span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">A reminder from VCAA about the functions to be demonstrated in both:</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">(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>)</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt"> </span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt"> </span></font></p>
<p class="MsoPlainText"><b><font size="2" face="Courier New"><span style="font-size:10.0pt; font-weight:bold">Relational database management system
</span></font></b></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">The following functions apply to Unit 3:</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt"> </span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•create tables</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•create relationships between tables</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•use a range of data types</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•electronic validation</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•create, edit and use queries</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•use of calculated fields</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•sort records or index on different fields.</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt"> </span></font></p>
<p class="MsoPlainText"><b><font size="2" face="Courier New"><span style="font-size:10.0pt; font-weight:bold">If students use a relational database management system in Unit 4, the following additional functions apply:</span></font></b></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt"> </span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•import/export of data</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•format data for display</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•create and edit a range of forms, including different data types and controls</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•create and edit a range of formatted reports.</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt"> </span></font></p>
<p class="MsoPlainText"><b><font size="2" face="Courier New"><span style="font-size:10.0pt; font-weight:bold">Spreadsheets
</span></font></b></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt"> </span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•conditional formatting</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•formulae including simple functions (SUM, average, maximum, minimum, count), conditional statements and lookup tables</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•cell protection</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•graphs</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•insert notes/comments</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•macros</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•relative and absolute cell references</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•naming a range</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•electronic validation</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•sheet referencing</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">•formatting/layout</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt"> </span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">--</span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt"> </span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">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 class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt"> </span></font></p>
<p class="MsoPlainText"><font size="2" face="Courier New"><span style="font-size:10.0pt">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 class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial"> </span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial">Regards,</span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial"> </span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial">Jackson Bates</span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial">VCE IT Applications</span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial">Waverley</span></font><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial"> Christian College</span></font><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial"></span></font></p>
</div>
<br>
<hr>
<div><img alt="WCCSIG" src="http://www.wcc.vic.edu.au/images/WCCSig.JPG"></div>
<div>
<p style="font-size:8pt; line-height:10pt; font-family:Arial,Helvetica,sans-serif">
------------------------------------------<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 srvadm@wcc.vic.edu.au.<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>
</p>
</div>
</body>
</html>