[Year 12 IT Apps] Some more Excel goodies

[Phillip Pike]

Geoff- did you mean to have an attachment?
Thanks

Phil Pike
Director of ICT
Bacchus Marsh Grammar
P (03) 5366 4800
F (03) 53664850
 

-----Original Message-----
From: Geoff Moss [mailto:geoffmoss37 at optusnet.com.au] 
Sent: Wednesday, 28 May 2008 5:02 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] Some more Excel goodies

In preparation for Excel I have attached the Excel Functions workbook in
which students can observe the application of a renge of functions.

I have updated the Tax Calculator to include the Tax schedules for 2008-9
and 2009-10 as provided in the last Federal Budget.

I have also added an extra worksheet: Loan calculator, using a PMT function.
Students will be interested in calculating the repayments for loans and the
total interest cost for loans.

Students (and teachers) can view prevailing formulas by hovering mouse over
the respective cells.

The password (pw) is provided on all worksheets if you want to unprotect
worksheets.

As in past years, I acknowledge that some of the worksheets are derived from
Greg Bowden's textbook:  Learning Microsoft Excel 2000.

Geoff Moss
RMIT



> Mark Kelly <kel at mckinnonsc.vic.edu.au> wrote:
> 
> For those starting U4O1, here are some Excel tasks and challenges for 
> the kidliwinkles to play with. They vary in level of difficulty.
> The IF AND OR document is new.
> 
> Have fun.
> Mark
> 
> -- 
> Mark Kelly
> Manager - Information Systems
> McKinnon Secondary College
> kel AT mckinnonsc.vic.edu.au
> McKinnon Rd, McKinnon 3204, Victoria, Australia
> Direct line / Voicemail: 8520 9085 Fax +613 9578 9253
> 
> Webmaster - http://www.mckinnonsc.vic.edu.au
> IT Lecture notes: http://vceit.com
> Moderator: IT Applications Mailing List
> 
> Only those who swim against the current know the current is there.
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - 
> Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology 
> Teachers Association Inc
_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
IT Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers
Association Inc