[Year 12 IPM] U4O1 DETAILED EXAMPLE.xls

[Christophersen, Paula P]

Thanks Mark. I will have a look at the work next week. Please don't publish anything on the VITTA website yet - this work has to be edited and as stated at the beginning of the process, copyright does belong with VCAA, although we will be very happy for it to 'appear' elsewhere, with permission.
 
Regards
Paula

________________________________

From: ipm-bounces at edulists.com.au on behalf of Mark Kelly
Sent: Thu 15/06/2006 1:51 PM
To: Year 12 Information Technology Processing and Management Teachers'Mailing List
Subject: [Year 12 IPM] U4O1 DETAILED EXAMPLE.xls



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.
_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
IPM Mailing List kindly supported by
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc 



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 & Training.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 5140 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/ipm/attachments/20060615/0334047e/attachment.bin