<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Times New Roman","serif";
color:windowtext;
font-weight:normal;
font-style:normal;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-AU link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt'>You need to loose an “o” in your “lose”s<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p><div><p class=MsoNormal><span style='font-size:11.0pt'>:-)<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'>Mark Scott<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'>Luther College<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt'>“Don’t water the rocks” Gerry Smith, River Oaks Public School<o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal style='margin-left:36.0pt'><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au] <b>On Behalf Of </b>Brendyn Hancock<br><b>Sent:</b> Thursday, 28 July 2011 1:47 PM<br><b>To:</b> Year 12 IT Applications Teachers' Mailing List<br><b>Subject:</b> Re: [Year 12 IT Apps] VLOOKUP practice for U4O1 (spreadsheet)<o:p></o:p></span></p></div></div><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>This of course will need to be updated to include the carbon tax and the tax reform changes.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:Wingdings;color:#1F497D'>J</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Nice reality check with the kids when they realise that some people loose 48% of their income to tax and most loose 35%.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><p class=MsoNormal style='margin-left:36.0pt'><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#274E37'>Mr Brendyn Hancock | ICT Director | Nagle College<o:p></o:p></span></b></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#274E37'>PO Box 507 (Lindenow Road) Bairnsdale 3875<o:p></o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#274E37'>D:</span></b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#274E37'> 03 5152 9954 | <b>T:</b> 03 5152 6122 | <b>F:</b> 03 5152 6220<o:p></o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#274E37'>E:</span></b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#274E37'> <a href="mailto:bhancock@nagle.vic.edu.au"><span style='color:#274E37'>bhancock@nagle.vic.edu.au</span></a> | <a href="http://www.nagle.vicedu.au">www.nagle.vicedu.au</a><o:p></o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#274E37'><img border=0 width=453 height=113 id="_x0000_i1025" src="cid:image001.jpg@01CC4D2CD3D197D0" alt="Email Banner"><o:p></o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#76923C'>Disclaimer: 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 Nagle College. < <a href="http://www.nagle.vic.edu.au">http://www.nagle.vic.edu.au</a>></span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#274E37'><o:p></o:p></span></p></div><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal style='margin-left:36.0pt'><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au] <b>On Behalf Of </b>Ben Hines<br><b>Sent:</b> Thursday, 28 July 2011 12:38 PM<br><b>To:</b> Year 12 IT Applications Teachers' Mailing List<br><b>Subject:</b> Re: [Year 12 IT Apps] VLOOKUP practice for U4O1 (spreadsheet)<o:p></o:p></span></p></div></div><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Nice and thanks Mark,<o:p></o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Question, is this just a simpler version of tax? Since you applied the tax rate to the whole income (instead of the first 8000 being @ 0% the next 7000 @ whatever % and so on…<o:p></o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I remember last year I attempted to explain how the real aussie income tax works and lost half of the class pretty quickly.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Ta<o:p></o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><img border=0 width=216 height=92 id="Picture_x0020_1" src="cid:image001.png@01CC4D2E.17D52220" alt="Description: ben_sig"><o:p></o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><b><span style='font-family:"Calibri","sans-serif";color:#1F497D'>Mr Ben Hines<o:p></o:p></span></b></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><i><span style='font-family:"Calibri","sans-serif";color:#1F497D'>Maths/ICT Teacher<o:p></o:p></span></i></p><p class=MsoNormal style='margin-left:36.0pt'><i><span style='font-family:"Calibri","sans-serif";color:#1F497D'>Senior School Campus - Christian College Geelong<o:p></o:p></span></i></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-family:Wingdings;color:#1F497D'>(</span><span style='font-family:"Calibri","sans-serif";color:#1F497D'>(03) 52411577 (ext. 212)</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><a name="_MailEndCompose"></a><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au] <b>On Behalf Of </b>Mark KELLY<br><b>Sent:</b> Thursday, 28 July 2011 11:39 AM<br><b>To:</b> Year 12 IT Applications Teachers' Mailing List<br><b>Subject:</b> [Year 12 IT Apps] VLOOKUP practice for U4O1 (spreadsheet)<o:p></o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p><p class=MsoNormal style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:36.0pt'>Hi all. Attached is a couple of tasks to hone VLOOKUP skills. Solutions provided.<br><br>Cheers<br>Mark<br clear=all><br>-- <br>Mark Kelly<br>Manager of ICT, Reporting, IT Learning Area<br>McKinnon Secondary College<br>McKinnon Rd McKinnon 3204, Victoria, Australia<br>Direct line / Voicemail: +613 8520 9085, Fax +613 9578 9253<br><a href="mailto:kel@mckinnonscvic.edu.au" target="_blank">kel@mckinnonsc.vic.edu.au</a><br>VCE IT Lecture Notes: <a href="http://vceit.com" target="_blank">http://vceit.com</a><br>Moderator: <a href="http://www.edulists.com.au/" target="_blank">IT Applications Edulist</a><br><br>Want a good time? Call 0112358. Ask for Mr Fibonacci.<o:p></o:p></p><div class=MsoNormal align=center style='margin-left:36.0pt;text-align:center'><hr size=1 width="100%" align=center></div><p class=MsoNormal style='margin-left:36.0pt'>Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.<br><a href="http://www.mailguard.com.au">http://www.mailguard.com.au</a><br><br><a href="https://login.mailguard.com.au/report/1CNAxRaZ6p/7jPJ09vS0XAB3oLAPirt3e/0.002">Report this message as spam</a> <br> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:36.0pt'><br>This e-mail is intended for the use of the named individual or entity and may contain confidential and privileged information. Any dissemination, distribution or copying by anyone other than the intended recipient of this e-mail is strictly prohibited. If this e-mail has been received in error, then please notify Christian College or the author of this email immediately and destroy the original message. We have made every attempt to ensure this e-mail message is free from computer viruses however the attached files are provided on the basis that the user assumes all responsibility for use of the material transmitted. Views, opinions, etc. expressed reflect those of the author and not Christian College nor its associated companies and campuses which includes Eden Quality Services Pty Ltd.<o:p></o:p></p><div class=MsoNormal align=center style='margin-left:36.0pt;text-align:center'><hr size=1 width="100%" align=center></div><p class=MsoNormal style='margin-left:36.0pt'>Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.<br><a href="http://www.mailguard.com.au">http://www.mailguard.com.au</a><br> <br> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:36.0pt'><br><br>Scanned by Sonar. <br>Date: 2011-07-28 13:47:02.303<br>From: <a href="mailto:bhancock@nagle.vic.edu.au">bhancock@nagle.vic.edu.au</a><br>To: <a href="mailto:itapps@edulists.com.au">itapps@edulists.com.au</a><br>Profile: default_out<br>Mail id: challenge-1824821985dmu-0 <o:p></o:p></p></div></body></html>