<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 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@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:11.0pt;
font-family:"Calibri","sans-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
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.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;}
/* List Definitions */
@list l0
{mso-list-id:909845857;
mso-list-template-ids:1128198462;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1
{mso-list-id:1589458772;
mso-list-template-ids:-970191984;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level3
{mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level4
{mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level5
{mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level6
{mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level7
{mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level8
{mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level9
{mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</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='color:#1F497D'>OK, not deluged with responses,
so…<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'> …I was thinking of omitting
lookup, cell protection, macros, and naming ranges until Year 12 – any comments?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><span style='color:#1F497D'>Mike Jolly<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Year 9 Co-ordinator<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Kyneton Secondary College<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>jolly.michael.d@edumail.vic.gov.au<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>03 5421 1100<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>0412 75 1984<o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='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><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"'> yr11it-bounces@edulists.com.au
[mailto:yr11it-bounces@edulists.com.au] <b>On Behalf Of </b>Jolly, Michael D<br>
<b>Sent:</b> Friday, 11 February 2011 10:16 AM<br>
<b>To:</b> yr11it@edulists.com.au<br>
<b>Subject:</b> [Yr11 Information Technology] Excel skills @ Yr11<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Reading last July’s VCAA bulletin, the following was listed
as required knowledge for IT Apps:<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<ul type=disc>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo3'><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>conditional
formatting<o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo3'><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>formulae
including simple functions (SUM, average, maximum, minimum, count),
conditional statements and lookup tables<o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo3'><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>cell
protection<o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo3'><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>graphs<o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo3'><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>insert
notes/comments<o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo3'><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>macros<o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo3'><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>relative
and absolute cell references<o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo3'><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>naming
a range<o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo3'><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>electronic
validation<o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo3'><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>sheet
referencing<o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo3'><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>formatting/layout<o:p></o:p></span></li>
</ul>
<p class=MsoNormal>I have Year 11’s this year and for U1O1 I was wondering if
the VCAA cares what I teach or what others have done. <o:p></o:p></p>
<p class=MsoNormal>I want to hold back some skills until Year 12. <o:p></o:p></p>
<p class=MsoNormal>Anyone care to share what works with them?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Mike Jolly<o:p></o:p></p>
<p class=MsoNormal>Year 9 Co-ordinator<o:p></o:p></p>
<p class=MsoNormal>Kyneton Secondary College<o:p></o:p></p>
<p class=MsoNormal>jolly.michael.d@edumail.vic.gov.au<o:p></o:p></p>
<p class=MsoNormal>03 5421 1100<o:p></o:p></p>
<p class=MsoNormal>0412 75 1984<o:p></o:p></p>
<p class=MsoNormal><o:p> </o: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.<o:p></o:p></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>