[Year 12 IT Apps] Some more Excel goodies

[Geoff Moss]

Thanks Phillip

I will attach copy and re-send message:

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




> Phillip Pike <pikep at bmg.vic.edu.au> wrote:
> 
> 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
> _______________________________________________
> 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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: Excel Functions 2008.xls
Type: application/vnd.ms-excel
Size: 222208 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20080529/47f6233a/ExcelFunctions2008-0001.xls