[Year 12 IT Apps] Some more Excel goodies

[Geoff Moss]

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