[Year 12 IT Apps] Some more Excel goodies

[Elliott, Brett T]

Hey guys,
 
I was wondering if anyone could help me out with a Unit 1 Exam. Thanks for all your excellent resources so far. 
 
Regards,
 
Brett Elliott
Grovedale College

________________________________

From: itapps-bounces at edulists.com.au on behalf of Geoff Moss
Sent: Thu 29/05/2008 12:10 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: RE: [Year 12 IT Apps] Some more Excel goodies



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 <http://www.mckinnonsc.vic.edu.au/> 
> > IT Lecture notes: http://vceit.com <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 <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 <http://www.vitta.org.au/>   - VITTA Victorian Information Technology
> > Teachers Association Inc
> _______________________________________________
> http://www.edulists.com.au <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 <http://www.vitta.org.au/>   - VITTA Victorian Information Technology
> Teachers
> Association Inc
> _______________________________________________
> http://www.edulists.com.au <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 <http://www.vitta.org.au/>   - VITTA Victorian Information Technology
> Teachers Association Inc

_______________________________________________
http://www.edulists.com.au <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 <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 and Early Childhood Development.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20080530/a357fb4f/attachment.html