<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" 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"><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19154"><!--[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.EmailStyle17
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
span.EmailStyle18
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
span.BalloonTextChar
        {mso-style-name:"Balloon Text Char";
        mso-style-priority:99;
        mso-style-link:"Balloon Text";
        font-family:"Tahoma","sans-serif";}
.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 bgColor=#ffffff vLink=purple>
<DIV><FONT size=2 face=Arial>Am marking this year - but have not yet seen the
paper as I am not teaching at the moment. M/C section so we won't be
marking it anyway :-)</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>There are numbers that we need to treat as text. Eg
phone numbers - else the leading zero is not stored. So once that is done,
you do need to sort on an A ->Z basis.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Look forward to seeing the actual question when I
get access to a copy of the paper online.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Robert Hind (Semi-retired) OOF, GOM (Thanks
Kent!)<BR>Ashwood and Traralgon<BR><A
href="mailto:robert@yinnar.com">robert@yinnar.com</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=b.hines@ccg.vic.edu.au href="mailto:b.hines@ccg.vic.edu.au">Ben
Hines</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=itapps@edulists.com.au
href="mailto:itapps@edulists.com.au">Year 12 IT Applications Teachers' Mailing
List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, November 14, 2011 2:36
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Year 12 IT Apps] Puts down
the rifle...</DIV>
<DIV><BR></DIV>
<DIV class=WordSection1>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">I
cannot believe that number question. No one would normally type numbers in as
numerals, set the data type to text and then order from A ->
Z.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">I
doubt anyone would get the answer to that unless they have accidentally done
it in the past. <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Because
you have entered them as text, the sort will only look at the left most number
to order them (just like with normal ones).<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Answer
according to Access is B….<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Question
5 in the Multiple Choice? What’s the consensus on that
one?<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Ta<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><IMG
id=Picture_x0020_1 alt="Description: Description: ben_sig"
src="cid:E7DDD106E0624F9CB9084AFA712C61A2@RobertPC" width=216
height=92><o:p></o:p></SPAN></P>
<P class=MsoNormal><B><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d">Mr Ben
Hines<o:p></o:p></SPAN></B></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><I><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d">VCE Maths/ICT
Teacher<o:p></o:p></SPAN></I></P>
<P class=MsoNormal><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><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-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><A name=_MailEndCompose><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></A></P>
<DIV>
<DIV
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<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>
itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au] <B>On
Behalf Of </B>Howard, David<BR><B>Sent:</B> Monday, 14 November 2011 2:15
PM<BR><B>To:</B> Year 12 IT Applications Teachers' Mailing
List<BR><B>Subject:</B> Re: [Year 12 IT Apps] Puts down the
rifle...<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">I
don’t have the paper in front of me, but after a quick chat to my students,
plain to see that they had differing opinions on the sorting of numbers as
text question in the multiple choice.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">I’m
not marking this year by the way.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<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
href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</A>
<A
href="mailto:[mailto:itapps-bounces@edulists.com.au]">[mailto:itapps-bounces@edulists.com.au]</A>
<B>On Behalf Of </B>Mark KELLY<BR><B>Sent:</B> Monday, 14 November 2011 1:52
PM<BR><B>To:</B> Year 12 IT Applications Teachers' Mailing
List<BR><B>Subject:</B> [Year 12 IT Apps] Puts down the
rifle...<o:p></o:p></SPAN></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>I'm reading the paper now. <BR><BR>Section A looks pretty
free of rabies.<BR><BR>I have put the gun down after reading the normalisation
question... Thank Dog sanity prevailed on that one!<BR><BR>Damn that ERD
question - three marks and they had to draw an entire diagram from
scratch! Grrr.<BR><BR>The 8 mark question appeared, as we
expected. And it was approachable.<BR><BR>Overall, I think I might give
the dog a bone.<BR><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@mckinnonsc.vic.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>
<P class=MsoNormal><o:p> </o:p></P>
<DIV style="TEXT-ALIGN: center" class=MsoNormal align=center>
<HR align=center SIZE=1 width="100%">
</DIV>
<P class=MsoNormal>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/1DwtSCvVLg/3l3gMtKTlFjw3U6WDhW9WD/0.002">Report
this message as spam</A> <BR> <o:p></o:p></P></DIV><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.<BR><BR>
<HR SIZE=1>
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><!-- MailGuard Message ID: 4ec08cdc4f0424 - use this number for reporting --> <BR> <BR>
<P>
<HR>
<P></P>_______________________________________________<BR>http://www.edulists.com.au
- FAQ, resources, subscribe, unsubscribe<BR>IT Applications Mailing List
kindly supported
by<BR>http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority
and<BR>http://www.vitta.org.au - VITTA Victorian Information Technology
Teachers Association Inc</BLOCKQUOTE></BODY></HTML>