<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
I would agree with the cohort, leave Macro's to Year 12 unless the
class is capable.<br>
In Year 12 the kids have so much more to contend with in a SAC than
just skills, they have to demonstrate and communicate key knowledge
points as well, so give them a head start and make sure that the
tasks that you give them in Year 12 are allow them to access those
higher order thinking skills that they need to score the top marks.<br>
<br>
2 cents<br>
<br>
Regards<br>
<br>
Margaret<br>
<br>
On 11/02/2011 3:48 PM, Geoff Moss wrote:
<blockquote cite="mid:4FB3E9F1268C41CDB54470519B8491DF@user32"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<meta name="GENERATOR" content="MSHTML 8.00.6001.19019">
<style>@font-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@page WordSection1 {size: 612.0pt 792.0pt; margin: 72.0pt 72.0pt 72.0pt 72.0pt; }
P.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
LI.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
DIV.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
P {
FONT-FAMILY: "Times New Roman","serif"; MARGIN-LEFT: 0cm; FONT-SIZE: 12pt; MARGIN-RIGHT: 0cm; mso-style-priority: 99; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle17 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: windowtext; mso-style-type: personal
}
SPAN.EmailStyle19 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: #1f497d; mso-style-type: personal-reply
}
.MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: export-only
}
DIV.WordSection1 {
page: WordSection1
}
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]-->
<div><font face="Arial" size="2">Hi Mike</font></div>
<div> </div>
<div><font face="Arial" size="2">While there is no precription to
do so, I would include lookups, cell protection and naming of
cell ranges in the Year 11 course. Some of your students may
not proceed to Year 12 and would miss learning some important
basic skills and functions of Excel, to their detriment in
using Excel effectively.</font></div>
<div> </div>
<div><font face="Arial" size="2">You could add drop down menus for
the Year 12 class and the insertion of images and hyperlinks
to enhance the Year 12 experience if all your students proceed
to Year 12 and have mastered the skills of Year 11.</font></div>
<div> </div>
<div><font face="Arial" size="2">My cents worth</font></div>
<div> </div>
<div><font face="Arial" size="2">Geoff Moss</font></div>
<div><font face="Arial" size="2">RMIT</font></div>
<div> </div>
<div> </div>
<div>----- Original Message ----- </div>
<blockquote style="border-left: 2px solid rgb(0, 0, 0);
padding-left: 5px; padding-right: 0px; margin-left: 5px;
margin-right: 0px;">
<div style="font: 10pt arial; background: none repeat scroll 0%
0% rgb(228, 228, 228);"><b>From:</b> <a
moz-do-not-send="true"
title="Jolly.Michael.D@edumail.vic.gov.au"
href="mailto:Jolly.Michael.D@edumail.vic.gov.au">Jolly,
Michael D</a> </div>
<div style="font: 10pt arial;"><b>To:</b> <a
moz-do-not-send="true" title="yr11it@edulists.com.au"
href="mailto:yr11it@edulists.com.au">Year 11 Information
Technology Teachers' Mailing List</a> </div>
<div style="font: 10pt arial;"><b>Sent:</b> Friday, February 11,
2011 11:41 AM</div>
<div style="font: 10pt arial;"><b>Subject:</b> Re: [Yr11
Information Technology] Excel skills @ Yr11</div>
<div><br>
</div>
<div class="WordSection1">
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">OK,
not deluged with responses, so…<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"> …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: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Mike
Jolly<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Year
9 Co-ordinator<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Kyneton
Secondary College<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><a
moz-do-not-send="true"
href="mailto:jolly.michael.d@edumail.vic.gov.au">jolly.michael.d@edumail.vic.gov.au</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">03
5421 1100<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">0412
75 1984<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<div>
<div style="border-width: 1pt medium medium; border-style:
solid none none; border-color: rgb(181, 196, 223)
-moz-use-text-color -moz-use-text-color; padding: 3pt 0cm
0cm;">
<p class="MsoNormal"><b><span style="font-family:
'Tahoma','sans-serif'; font-size: 10pt;"
lang="EN-US">From:</span></b><span
style="font-family: 'Tahoma','sans-serif'; font-size:
10pt;" lang="EN-US"> <a moz-do-not-send="true"
href="mailto:yr11it-bounces@edulists.com.au">yr11it-bounces@edulists.com.au</a>
[<a class="moz-txt-link-freetext" href="mailto:yr11it-bounces@edulists.com.au">mailto:yr11it-bounces@edulists.com.au</a>] <b>On Behalf
Of </b>Jolly, Michael D<br>
<b>Sent:</b> Friday, 11 February 2011 10:16 AM<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:yr11it@edulists.com.au">yr11it@edulists.com.au</a><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 style="" class="MsoNormal"><span style="font-family:
'Times New Roman','serif'; font-size: 12pt;">conditional
formatting<o:p></o:p></span> </li>
<li style="" class="MsoNormal"><span style="font-family:
'Times New Roman','serif'; font-size: 12pt;">formulae
including simple functions (SUM, average, maximum,
minimum, count), conditional statements and lookup
tables<o:p></o:p></span> </li>
<li style="" class="MsoNormal"><span style="font-family:
'Times New Roman','serif'; font-size: 12pt;">cell
protection<o:p></o:p></span> </li>
<li style="" class="MsoNormal"><span style="font-family:
'Times New Roman','serif'; font-size: 12pt;">graphs<o:p></o:p></span>
</li>
<li style="" class="MsoNormal"><span style="font-family:
'Times New Roman','serif'; font-size: 12pt;">insert
notes/comments<o:p></o:p></span> </li>
<li style="" class="MsoNormal"><span style="font-family:
'Times New Roman','serif'; font-size: 12pt;">macros<o:p></o:p></span>
</li>
<li style="" class="MsoNormal"><span style="font-family:
'Times New Roman','serif'; font-size: 12pt;">relative
and absolute cell references<o:p></o:p></span> </li>
<li style="" class="MsoNormal"><span style="font-family:
'Times New Roman','serif'; font-size: 12pt;">naming a
range<o:p></o:p></span> </li>
<li style="" class="MsoNormal"><span style="font-family:
'Times New Roman','serif'; font-size: 12pt;">electronic
validation<o:p></o:p></span> </li>
<li style="" class="MsoNormal"><span style="font-family:
'Times New Roman','serif'; font-size: 12pt;">sheet
referencing<o:p></o:p></span> </li>
<li style="" class="MsoNormal"><span style="font-family:
'Times New Roman','serif'; font-size: 12pt;">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"><a class="moz-txt-link-abbreviated" href="mailto:jolly.michael.d@edumail.vic.gov.au">jolly.michael.d@edumail.vic.gov.au</a><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><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>
<p> </p>
<hr> _______________________________________________<br>
<a class="moz-txt-link-freetext" href="http://www.edulists.com.au">http://www.edulists.com.au</a> - FAQ, resources, subscribe,
unsubscribe<br>
Year 11 It Mailing List kindly supported by<br>
<a class="moz-txt-link-freetext" href="http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html</a>
- Victorian Curriculum and Assessment Authority and<br>
<a class="moz-txt-link-freetext" href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian Information
Technology Teachers Association Inc</blockquote>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.edulists.com.au">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe
Year 11 It Mailing List kindly supported by
<a class="moz-txt-link-freetext" href="http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html</a> - Victorian Curriculum and Assessment Authority and
<a class="moz-txt-link-freetext" href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Margaret Lawson
Konstant Kaos Designs
ABN 50 523 597 927
26 Nash Street
Northcote 3070
Victoria Australia
M: 0407 896309
P: 9489 6309
<a class="moz-txt-link-abbreviated" href="mailto:margaret.lawson@konstantkaos.net">margaret.lawson@konstantkaos.net</a></pre>
</body>
</html>