[Year 12 IPM] U4O1 DETAILED EXAMPLE.xls

[Mark Kelly]

Attached is a sample solution for the U4O1 detailed example in the 
Information Technology Applications (ITA) study design for 2007.

Unfortunately the sample data supplied with the example does not truly 
exercise the solution (e.g. nearly everyone's in the same tax bracket!)

It uses multiple sheets, vlookup, if, countif, conditional formatting, 
named cells and ranges, macro buttons (which are safe to enable!), cell 
protection, charts, and there are no constants in any formulae (a 
personal bugbear of mine!)

Have fun.  I'll stick it on the VITTA resource site at some stage.

Mark

-- 
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: 8520 9085
School Phone +613 8520 9000 << new number!
School Fax   +613 9578 9253

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

We must pity one another, and be gentle.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: U4O1 DETAILED EXAMPLE.xls
Type: application/vnd.ms-excel
Size: 44032 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/ipm/attachments/20060615/ef74cd4a/U4O1DETAILEDEXAMPLE-0001.xls