Hi all. Attached is a revised version of my U1O1. <br><br>I wasn't happy with the limited spreadsheet skills required in version 1, so I beefed it up a bit with COUNTIF, VLOOKUP, IF, AND, conditional formatting. I had to fake this data because the original data was all aggregated.<br>
<br>I've also included a marking scheme (where $1 = 1%). <br><br>The data file has been updated too, so be sure to replace the old data.<br>Now I'm starting to worry that it has become too ambitious, but I'll give it a fling anyway.<br clear="all">
<br>-- <br>Mark Kelly<br>Manager of ICT, Reporting, IT Learning Area<br>McKinnon Secondary College<br>McKinnon Rd McKinnon 3204, Victoria, Australia<br>Direct line / Voicemail: +613 8520 9085, Fax +613 9578 9253<br><a href="mailto:kel@mckinnonsc.vic.edu.au" target="_blank">kel@mckinnonsc.vic.edu.au</a><br>
VCE IT Lecture Notes: <a href="http://vceit.com" target="_blank">http://vceit.com</a><br>Moderator: <a href="http://www.edulists.com.au/" target="_blank">IT Applications Edulist</a><br><br>--<br>Grammar for the 21st century...<br>
Infinitive: I sync my phone.<br>Past tense: I sanc my phone.<br>Past participle: I have sunc my phone.<br><br><br>