[Yr11 Information Technology] U1O1 - R-U MAD - version 2

[Thomas, Gayle J]

Hi Mark

Are you able to delete me from the IT mailing list please. I have retired and no longer need this amazing resource.

Thanks for all the ideas etc over the past years.

Gayle Thomas
Previously - Horsham College

From: yr11it-bounces at edulists.com.au [mailto:yr11it-bounces at edulists.com.au] On Behalf Of Mark KELLY
Sent: Tuesday, 13 March 2012 11:09 AM
To: Year 11 Information Technology Teachers' Mailing List
Subject: [Yr11 Information Technology] U1O1 - R-U MAD - version 2

Hi all. Attached is a revised version of my U1O1.

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.

I've also included a marking scheme (where $1 = 1%).

The data file has been updated too, so be sure to replace the old data.
Now I'm starting to worry that it has become too ambitious, but I'll give it a fling anyway.

--
Mark Kelly
Manager of ICT, Reporting, IT Learning Area
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: +613 8520 9085, Fax +613 9578 9253
kel at mckinnonsc.vic.edu.au<mailto:kel at mckinnonsc.vic.edu.au>
VCE IT Lecture Notes: http://vceit.com
Moderator: IT Applications Edulist<http://www.edulists.com.au/>

--
Grammar for the 21st century...
Infinitive: I sync my phone.
Past tense: I sanc my phone.
Past participle: I have sunc my phone.


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/yr11it/attachments/20120314/e584883b/attachment.html