I don't have a SAC I can distribute, unfortunately, but in terms of level of difficulty, my kids should be able to demonstrate knowledge of:<br><br>- basic arithmetic and calculation of percentages<br>- basic Excel functions (including SUM, AVERAGE, MAX, MIN, ROUND)<br>
- conditional testing (IF, AND, OR)<br>- VLOOKUP and HLOOKUP<br>- conditional formatting<br>- cell and range naming<br>- cell formatting<br>- sheet protection<br>- the wise use of multiple worksheets<br>- charting<br>- knowing when to use a database instead of a spreadsheet (which the author of the last question in last year's VCAA exam obviously did <b>not</b> know!) Yes. I'm still annoyed about that debacle.<br>
<br>Remember that U4O1 is a 3-task outcome, so give yourself enough time to train kids up on visualisation of thinking (I use <i>Inspiration</i>) and writing user documentation.<br> <br><br><div class="gmail_quote">On 15 July 2010 11:45, Michelle Lazarow <span dir="ltr"><<a href="mailto:lazarm@bialik.vic.edu.au">lazarm@bialik.vic.edu.au</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>
<font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size: 11pt;">Hi!<br>
<br>
I am new to the world of IT Apps and have come into teaching it this term! As I have not taught this before I am a little confused as to the level of detail that is required for Outcome 1. I was wondering whether anyone would be willing to share a completed Assessment Task for Outcome 1?<br>
<br>
Thanks,<br>
Michelle<br>
<br>
-- <br>
<b>Michelle Lazarow<br>
</b>Bialik College<br>
Email: <a href="http://lazarm@bialik.vic.edu.au" target="_blank">lazarm@bialik.vic.edu.au</a><br>
PH: (03) 9822 7981<br>
</span></font>
</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; Reporting Manager<br>
McKinnon Secondary College<br>McKinnon Rd McKinnon 3204, Victoria, Australia<br>Direct line / Voicemail: 8520 9085<br>School Phone +613 8520 9000, Fax +613 9578 9253<br><a href="mailto:kel@mckinnonsc.vic.edu.au" target="_blank">kel@mckinnonsc.vic.edu.au</a><br>
<br>Webmaster - <a href="http://www.mckinnonsc.vic.edu.au" target="_blank">http://www.mckinnonsc.vic.edu.au</a><br>Author - VCE IT Lecture notes: <a href="http://vceit.com" target="_blank">http://vceit.com</a><br>Moderator: IT Applications Mailing List<br>
<br>Korma: the philosophy that what you get out of a curry depends on what you put into it.<br>