<HTML dir=ltr><HEAD><TITLE>Re: RE: [Year 12 IT Apps] Some more Excel goodies</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.2900.2604" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText22742 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Hey guys,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>I was wondering if anyone could help me out with a Unit 1 Exam. Thanks for all your excellent resources so far. </FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Regards,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Brett Elliott</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>Grovedale College</FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> itapps-bounces@edulists.com.au on behalf of Geoff Moss<BR><B>Sent:</B> Thu 29/05/2008 12:10 PM<BR><B>To:</B> Year 12 IT Applications Teachers' Mailing List<BR><B>Subject:</B> Re: RE: [Year 12 IT Apps] Some more Excel goodies<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>Thanks Phillip<BR><BR>I will attach copy and re-send message:<BR><BR>In preparation for Excel I have attached the Excel Functions workbook in<BR>which students can observe the application of a renge of functions.<BR><BR>I have updated the Tax Calculator to include the Tax schedules for 2008-9<BR>and 2009-10 as provided in the last Federal Budget.<BR><BR>I have also added an extra worksheet: Loan calculator, using a PMT function.<BR>Students will be interested in calculating the repayments for loans and the<BR>total interest cost for loans.<BR><BR>Students (and teachers) can view prevailing formulas by hovering mouse over<BR>the respective cells.<BR><BR>The password (pw) is provided on all worksheets if you want to unprotect<BR>worksheets.<BR><BR>As in past years, I acknowledge that some of the worksheets are derived from<BR>Greg Bowden's textbook: Learning Microsoft Excel 2000.<BR><BR>Geoff Moss<BR>RMIT<BR><BR><BR><BR><BR>> Phillip Pike <pikep@bmg.vic.edu.au> wrote:<BR>><BR>> Geoff- did you mean to have an attachment?<BR>> Thanks<BR>><BR>> Phil Pike<BR>> Director of ICT<BR>> Bacchus Marsh Grammar<BR>> P (03) 5366 4800<BR>> F (03) 53664850<BR>> <BR>><BR>> -----Original Message-----<BR>> From: Geoff Moss [<A href="mailto:geoffmoss37@optusnet.com.au">mailto:geoffmoss37@optusnet.com.au</A>]<BR>> Sent: Wednesday, 28 May 2008 5:02 PM<BR>> To: Year 12 IT Applications Teachers' Mailing List<BR>> Subject: Re: [Year 12 IT Apps] Some more Excel goodies<BR>><BR>> In preparation for Excel I have attached the Excel Functions workbook in<BR>> which students can observe the application of a renge of functions.<BR>><BR>> I have updated the Tax Calculator to include the Tax schedules for<BR>> 2008-9<BR>> and 2009-10 as provided in the last Federal Budget.<BR>><BR>> I have also added an extra worksheet: Loan calculator, using a PMT<BR>> function.<BR>> Students will be interested in calculating the repayments for loans and<BR>> the<BR>> total interest cost for loans.<BR>><BR>> Students (and teachers) can view prevailing formulas by hovering mouse<BR>> over<BR>> the respective cells.<BR>><BR>> The password (pw) is provided on all worksheets if you want to unprotect<BR>> worksheets.<BR>><BR>> As in past years, I acknowledge that some of the worksheets are derived<BR>> from<BR>> Greg Bowden's textbook: Learning Microsoft Excel 2000.<BR>><BR>> Geoff Moss<BR>> RMIT<BR>><BR>><BR>><BR>> > Mark Kelly <kel@mckinnonsc.vic.edu.au> wrote:<BR>> ><BR>> > For those starting U4O1, here are some Excel tasks and challenges for<BR>> > the kidliwinkles to play with. They vary in level of difficulty.<BR>> > The IF AND OR document is new.<BR>> ><BR>> > Have fun.<BR>> > Mark<BR>> ><BR>> > --<BR>> > Mark Kelly<BR>> > Manager - Information Systems<BR>> > McKinnon Secondary College<BR>> > kel AT mckinnonsc.vic.edu.au<BR>> > McKinnon Rd, McKinnon 3204, Victoria, Australia<BR>> > Direct line / Voicemail: 8520 9085 Fax +613 9578 9253<BR>> ><BR>> > Webmaster - <A href="http://www.mckinnonsc.vic.edu.au/">http://www.mckinnonsc.vic.edu.au</A><BR>> > IT Lecture notes: <A href="http://vceit.com/">http://vceit.com</A><BR>> > Moderator: IT Applications Mailing List<BR>> ><BR>> > Only those who swim against the current know the current is there.<BR>> > _______________________________________________<BR>> > <A href="http://www.edulists.com.au/">http://www.edulists.com.au</A> - FAQ, resources, subscribe, unsubscribe<BR>> > IT Applications Mailing List kindly supported by<BR>> > <A href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</A><BR>> -<BR>> > Victorian Curriculum and Assessment Authority and<BR>> > <A href="http://www.vitta.org.au/">http://www.vitta.org.au</A> - VITTA Victorian Information Technology<BR>> > Teachers Association Inc<BR>> _______________________________________________<BR>> <A href="http://www.edulists.com.au/">http://www.edulists.com.au</A> - FAQ, resources, subscribe, unsubscribe<BR>> IT Applications Mailing List kindly supported by<BR>> <A href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</A> -<BR>> Victorian Curriculum and Assessment Authority and<BR>> <A href="http://www.vitta.org.au/">http://www.vitta.org.au</A> - VITTA Victorian Information Technology<BR>> Teachers<BR>> Association Inc<BR>> _______________________________________________<BR>> <A href="http://www.edulists.com.au/">http://www.edulists.com.au</A> - FAQ, resources, subscribe, unsubscribe<BR>> IT Applications Mailing List kindly supported by<BR>> <A href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</A> -<BR>> Victorian Curriculum and Assessment Authority and<BR>> <A href="http://www.vitta.org.au/">http://www.vitta.org.au</A> - VITTA Victorian Information Technology<BR>> Teachers Association Inc<BR><BR>_______________________________________________<BR><A href="http://www.edulists.com.au/">http://www.edulists.com.au</A> - FAQ, resources, subscribe, unsubscribe<BR>IT Applications Mailing List kindly supported by<BR><A href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</A> - Victorian Curriculum and Assessment Authority and<BR><A href="http://www.vitta.org.au/">http://www.vitta.org.au</A> - VITTA Victorian Information Technology Teachers Association Inc</FONT> </P></DIV><p></p><p><b>Important - </b>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.</p>
</BODY></HTML>