[Year 12 IT Apps] Spreadsheet tasks

[Mark KELLY]

Hi all.  Hope you're all enjoying the break before the big
report-writing term...

In an effort to become a little more practically-minded on the VCEIT
Lecture Notes site, I've started a series of practice tasks for Excel
(in particular) and spreadsheets (in general) for ITA U4O1.  With any
luck we can raise the abysmal spreadsheet performance shown by kids in
last year's exam...

So far, I've done conditional formatting and basic VLOOKUP. More will follow.

http://www.mckinnonsc.vic.edu.au/vceit/exceltasks/exceltasks.htm

If you can think of particular skills you want kids to exercise,
please let me know.

-- 
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: 8520 9085
School Phone +613 8520 9000
School Fax +613 9578 9253
kel at mckinnonsc.vic.edu.au

Webmaster - http://www.mckinnonsc.vic.edu.au
IT Lecture notes: http://vceit.com
Moderator: IT Applications Mailing List

The early bird may get the worm, but the second mouse gets the cheese
in the trap.