[Year 12 IT Apps] Some more Excel goodies

Fri May 30 15:15:12 EST 2008

I put one on the VITTA resources site last year.

Elliott, Brett T wrote:
> 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 loa ns 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 Sec! ondary 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.o rg.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 
> <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 at! tachments 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.
> 
> _______________________________________________
> 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/infotechindex.html 
> <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

-- 
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: 8520 9085
School Phone +613 8520 9000
School Fax +613 95789253
kel AT mckinnonsc.vic.edu.au

Webmaster - http://www.mckinnonsc.vic.edu.au
IT Lecture notes: http://vceit.com
Moderator: IT Applications Mailing List

A conclusion is the place where you got sick of thinking.
If you Declare War - is it integer or boolean?