<html><body bgcolor="#FFFFFF"><div>Ah but I know lots if commercial programs that do this.</div><div>Sort numbers as text.</div><div>It's very annoying.</div><div>Plus you are falling into the teaching Microsoft only trap.</div><div>There are other possibilities.</div><div>I rather like the question as a descriminator for thinking students.</div><div><br><br>Royce Williams<div>Sent from my AppleBerry</div></div><div><br>On 15/11/2011, at 11:47 AM, Adric Gardner <<a href="mailto:gardner.adric.a@edumail.vic.gov.au">gardner.adric.a@edumail.vic.gov.au</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div><div>Actually in excel, if it is entered as </div><div><br></div><div>'6</div><div>'17 etc (don't have the exam in front of me)</div><div><br></div><div>It is sorted as text. But off memory, that's not what the question asked<br><br>Regards,<div><br></div><div>Adric Gardner</div></div><div><br>On 15/11/2011, at 11:19 AM, Robert Hind <<a href="mailto:robert@yinnar.com"><a href="mailto:robert@yinnar.com">robert@yinnar.com</a></a>> wrote:<br><br></div><div></div><blockquote type="cite"><div>
<!--[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;}
@font-face
{font-family:Webdings;
panose-1:5 3 1 2 1 5 9 6 7 3;}
/* 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
{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";}
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";
mso-fareast-language:EN-AU;}
span.EmailStyle20
{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-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@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]-->
<div><font size="2" face="Arial">So you do that in Excel and it totally ignores your
formatting as text and sorts as though the entries are numbers. Do the same in
Access and it does accept that the field is text and does sort as
text.</font></div>
<div><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial">Thank you Microsoft</font></div>
<div><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial">Robert Hind (Semi-retired) OOF, GOM, COF<br>Ashwood
and Traralgon<br><a href="mailto:robert@yinnar.com"><a href="mailto:robert@yinnar.com">robert@yinnar.com</a></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="msc@luther.vic.edu.au" href="mailto:msc@luther.vic.edu.au">Mark
Scott</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> Tuesday, November 15, 2011 11:02
AM</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-SIZE: 11pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt">Putting commas in front of
the numbers changes the question.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt">The only way to enter numbers
as text in by formatting the cells or the field as text.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt">WOOF<o:p></o:p></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt" lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt" lang="EN-US">thanks<o:p></o:p></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt" lang="EN-US">Mark
Scott<o:p></o:p></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt" lang="EN-US">Luther
College<o:p></o:p></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt" lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt" lang="EN-US">"The busier you
get, the slower you walk" anon<o:p></o:p></span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt"><o:p> </o:p></span></p>
<p style="MARGIN-LEFT: 36pt" 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"><a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a></a>
[mailto:itapps-bounces@edulists.com.au] <b>On Behalf Of </b>Mark
KELLY<br><b>Sent:</b> Tuesday, 15 November 2011 10:42 AM<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>
<p style="MARGIN-LEFT: 36pt" class="MsoNormal"><o:p> </o:p></p>
<p style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 36pt; MARGIN-RIGHT: 0cm; mso-margin-top-alt: 0cm" class="MsoNormal">Try forcing the numbers to be text (put an apostophe in front
of the digits) and try it again. Excel has to ask you what you really
want to sort as text or as thinks that "look like
numbers."<br><br><o:p></o:p></p>
<div>
<p style="MARGIN-LEFT: 36pt" class="MsoNormal">On 15 November 2011 09:37, Esko
Lossi <<a href="mailto:elossi@chairo.vic.edu.au"><a href="mailto:elossi@chairo.vic.edu.au">elossi@chairo.vic.edu.au</a></a>>
wrote:<o:p></o:p></p>
<div>
<div>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: navy; FONT-SIZE: 10pt">When I
do question 13 (Section A) on a spreadsheet, the answer the spreadsheet gives
is A.</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: navy; FONT-SIZE: 10pt"> </span><o:p></o:p></p>
<div>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="COLOR: black; FONT-SIZE: 10pt">Regards</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><b><span style="COLOR: black">Esko
Lossi</span></b><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><b><span style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 10pt">ICT/Reporting
Coordinator</span></b><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><b><span style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 10pt">Chairo
Christian School, Drouin Campus</span></b><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><b><span style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 10pt">Contact:
56254600 ext 101 </span></b><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><b><span style="COLOR: navy"><a href="mailto:elossi@chairo.vic.edu.au" target="_blank"><a href="mailto:elossi@chairo.vic.edu.au">elossi@chairo.vic.edu.au</a></a></span></b><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="COLOR: black"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><b><i><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 7.5pt">Disclaimer:
Whilst every attempt has been made to ensure that material contained in this
email is free from computer viruses or other defects, the attached files are
provided, and may only be used, on the basis that the user assumes all
responsibility for use of the material transmitted. This email is intended
only for the use of the individual or entity named above and may contain
information that is confidential and privileged. If you are not the intended
recipient, please note that any dissemination, distribution or copying of this
email is strictly prohibited. If you have received this email in error, please
notify us immediately by return email or telephone 03 5625 4600 and destroy
the original message. The contents of this message are provided without
responsibility in law for their accuracy or otherwise and without assumption
of a duty of care by the Warragul District Parent Controlled Christian School
Association Incorporated trading as Chairo Christian
School.</span></i></b><o:p></o:p></p></div>
<div>
<div style="TEXT-ALIGN: center; MARGIN-LEFT: 36pt" class="MsoNormal" align="center"><span lang="EN-US">
<hr align="center" size="2" width="100%">
</span></div>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" 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" target="_blank"><a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a></a> [mailto:<a href="mailto:itapps-bounces@edulists.com.au" target="_blank"><a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a></a>] <b>On Behalf Of </b>Ken
Tonkin<br><b>Sent:</b> Tuesday, November 15, 2011 9:29
AM</span><o:p></o:p></p>
<div>
<div>
<p style="MARGIN-LEFT: 36pt" class="MsoNormal"><span style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"><br><b>To:</b>
Year 12 IT Applications Teachers' Mailing List<br><b>Subject:</b> Re: [Year 12
IT Apps] Puts down the rifle...</span><o:p></o:p></p></div></div></div>
<div>
<div>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"> <o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">David,
I agree with most of your answers for the MC questions, except no.9 I think
the answer should be 9B as tactical decisions are more short term and
specific.</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Ken
Tonkin</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><a name="133a44543a3263a1__MailEndCompose"></a><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></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 style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" 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" target="_blank"><a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a></a> [mailto:<a href="mailto:itapps-bounces@edulists.com.au" target="_blank"><a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a></a>] <b>On Behalf Of </b>Howard,
David<br><b>Sent:</b> Tuesday, 15 November 2011 8:31 AM<br><b>To:</b> Year 12
IT Applications Teachers' Mailing List<br><b>Subject:</b> Re: [Year 12 IT
Apps] Puts down the rifle...</span><o:p></o:p></p></div></div>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"> <o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">I’m
with Mark on this one. Definitely A.</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Validation
can ensure that I input a date of birth for example that is reasonable, say
12/08/1981 but is it accurate, no!</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Here
are my multiple choice answers.</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">1
B</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">2
A</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">3
D</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">4
D</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">5
A</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">6
A</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">7
B</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">8
A</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">9
A – not so confident on that one</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">10
A</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">11
C </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">12
C</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">13
B </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">14
B</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">15
D</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">16
C</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">17
B</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">18
B</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">19
C</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">20
C</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 36pt; mso-margin-top-alt: auto" class="MsoNormal"><b><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #2d72a3; FONT-SIZE: 9pt">David
Howard</span></b><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #2d72a3; FONT-SIZE: 9pt"><br>Head
of IT & Learning Technologies <br><br><image001.jpg> <br><br>25 Chapel Street, St Kilda VIC 3182
Australia<br></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #2d72a3; FONT-SIZE: 6pt"><br></span><b><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #2d72a3; FONT-SIZE: 9pt">Phone </span></b><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #2d72a3; FONT-SIZE: 9pt"><a href="tel:%2B61%203%208530%203272" target="_blank">+61 3 8530
3272</a> <br><b>Fax </b><a href="tel:%2B61%203%209510%209392" target="_blank">+61 3 9510 9392</a> <br><b>Email </b><a href="mailto:dhoward@stmichaels.vic.edu.au" target="_blank"><a href="mailto:dhoward@stmichaels.vic.edu.au">dhoward@stmichaels.vic.edu.au</a></a> <br><b>Website </b><a href="http://www.stmichaels.vic.edu.au/" target="_blank"><a href="http://www.stmichaels.vic.edu.au">www.stmichaels.vic.edu.au</a></a><br><b>CRICOS
Provider</b> 00345G<br><image002.jpg> <br><br><image003.jpg><br></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #2d72a3; FONT-SIZE: 8.5pt">Please
consider the environment before printing this email.</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></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 style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" 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" target="_blank"><a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a></a> [mailto:<a href="mailto:itapps-bounces@edulists.com.au" target="_blank"><a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a></a>] <b>On Behalf Of </b>Mark
Scott<br><b>Sent:</b> Tuesday, 15 November 2011 8:14 AM<br><b>To:</b> Year 12
IT Applications Teachers' Mailing List<br><b>Subject:</b> Re: [Year 12 IT
Apps] Puts down the rifle...</span><o:p></o:p></p></div></div>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"> <o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-SIZE: 11pt">Validation deals with data
entry.</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-SIZE: 11pt">Options B, C and D are all
testing to ensure data manipulation is correct/accurate
etc.</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-SIZE: 11pt">Only option A clearly deals with
data entry (i.e. the most correct option)</span><o:p></o:p></p>
<div>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-SIZE: 11pt" lang="EN-US"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-SIZE: 11pt" lang="EN-US">thanks</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-SIZE: 11pt" lang="EN-US">Mark
Scott</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-SIZE: 11pt" lang="EN-US">Luther
College</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-SIZE: 11pt" lang="EN-US"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-SIZE: 11pt" lang="EN-US">"The busier you get,
the slower you walk" anon</span><o:p></o:p></p></div>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-SIZE: 11pt"> </span><o:p></o:p></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 style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" 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" target="_blank"><a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a></a> [mailto:<a href="mailto:itapps-bounces@edulists.com.au" target="_blank"><a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a></a>] <b>On Behalf Of </b>Michael
Torsello (Mr)<br><b>Sent:</b> Tuesday, 15 November 2011 8:03 AM<br><b>To:</b>
Year 12 IT Applications Teachers' Mailing List<br><b>Subject:</b> Re: [Year 12
IT Apps] Puts down the rifle...</span><o:p></o:p></p></div></div>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"> <o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Dear
wiser colleagues</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Can
someone help me with MC question 8?</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">An
effective validation technique is evident when … all answers seem to support
the presence of an effective validation technique.</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">A
– at first glance the answer but is reasonableness the best evidence of
validation?</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">B-
an accurate report suggests accurate input data, doesn’t
it?</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">C-
least likely but again “reasonably”? What does that mean? If data can be
sorted is it valid?</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">D
–calculated files gives correct answers! Is this evidence of GIGO – not
garbage in, garbage out, but good in, good out?</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">I’m
confused!</span><o:p></o:p></p>
<div>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">--------------------------------------------------------------------------------------------------------------------</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #1f497d; FONT-SIZE: 10pt">With
Thanks</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #1f497d; FONT-SIZE: 10pt">Michael
Torsello</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #1f497d; FONT-SIZE: 10pt">Director
of Computing</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #1f497d; FONT-SIZE: 10pt">St
Margaret's School, Berwick</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #1f497d; FONT-SIZE: 10pt">Berwick
Grammar School, Officer</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #1f497d; FONT-SIZE: 10pt">Ph:
<a href="tel:%2803%29%209703%208111" target="_blank">(03) 9703
8111</a></span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: Webdings; COLOR: #45834c; FONT-SIZE: 16pt">P</span><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #45834c; FONT-SIZE: 11pt">
Save paper and trees. Do you need to print this
email?</span><o:p></o:p></p></div>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></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 style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" 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" target="_blank"><a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a></a> <a href="mailto:%5bmailto:itapps-bounces@edulists.com.au%5d" target="_blank">[mailto:itapps-bounces@edulists.com.au]</a> <b>On Behalf Of
</b>Ben Hines<br><b>Sent:</b> Monday, 14 November 2011 4:32 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...</span><o:p></o:p></p></div></div>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"> <o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Yeah
I just found that, thanks</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></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 style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" 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" target="_blank"><a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a></a> <a href="mailto:%5bmailto:itapps-bounces@edulists.com.au%5d" target="_blank">[mailto:itapps-bounces@edulists.com.au]</a> <b>On Behalf Of
</b>Howard, David<br><b>Sent:</b> Monday, 14 November 2011 3:39
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...</span><o:p></o:p></p></div></div>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"> <o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">A
– Scope see page 17 of the study design.</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></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 style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" 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" target="_blank"><a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a></a> <a href="mailto:%5bmailto:itapps-bounces@edulists.com.au%5d" target="_blank">[mailto:itapps-bounces@edulists.com.au]</a> <b>On Behalf Of
</b>Ben Hines<br><b>Sent:</b> Monday, 14 November 2011 2:37 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...</span><o:p></o:p></p></div></div>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"> <o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" 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.</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" 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. </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" 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).</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Answer
according to Access is B….</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" 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?</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Ta</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><image004.gif></span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><b><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d">Mr Ben
Hines</span></b><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><i><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d">VCE Maths/ICT
Teacher</span></i><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><i><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d">Senior School
Campus - Christian College Geelong</span></i><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: Wingdings; COLOR: #1f497d">(</span><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d">(03) 52411577
(ext. 212)</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></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 style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" 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" target="_blank"><a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a></a> <a href="mailto:%5bmailto:itapps-bounces@edulists.com.au%5d" target="_blank">[mailto:itapps-bounces@edulists.com.au]</a> <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...</span><o:p></o:p></p></div></div>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"> <o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" 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.</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">I’m
not marking this year by the way.</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" 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" target="_blank"><a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a></a> <a href="mailto:%5bmailto:itapps-bounces@edulists.com.au%5d" target="_blank">[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...</span><o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"> <o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" 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: <a href="tel:%2B613%208520%209085" target="_blank">+613 8520 9085</a>, Fax <a href="tel:%2B613%209578%209253" target="_blank">+613 9578 9253</a><br><a href="mailto:kel@mckinnonsc.vic.edu.au" target="_blank"><a href="mailto:kel@mckinnonsc.vic.edu.au">kel@mckinnonsc.vic.edu.au</a></a><br>VCE IT Lecture Notes: <a href="http://vceit.com" target="_blank"><a href="http://vceit.com">http://vceit.com</a></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 style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"> <o:p></o:p></p>
<div style="MARGIN-LEFT: 36pt">
<div style="TEXT-ALIGN: center; MARGIN-LEFT: 36pt" class="MsoNormal" align="center">
<hr align="center" size="1" width="100%">
</div></div>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal">Message protected by MailGuard: e-mail anti-virus, anti-spam
and content filtering.<br><a href="http://www.mailguard.com.au" target="_blank"><a href="http://www.mailguard.com.au">http://www.mailguard.com.au</a></a><br><br><a href="https://login.mailguard.com.au/report/1DwtSCvVLg/3l3gMtKTlFjw3U6WDhW9WD/0.002" target="_blank">Report this message as spam</a> <br> <o:p></o:p></p>
<p style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 72pt; mso-margin-top-alt: auto" class="MsoNormal"><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 style="MARGIN-LEFT: 36pt">
<div style="TEXT-ALIGN: center; MARGIN-LEFT: 36pt" class="MsoNormal" align="center">
<hr align="center" size="1" width="100%">
</div></div>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal">Message protected by MailGuard: e-mail anti-virus, anti-spam
and content filtering.<br><a href="http://www.mailguard.com.au" target="_blank"><a href="http://www.mailguard.com.au">http://www.mailguard.com.au</a></a><br> <br> <o:p></o:p></p>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"> <o:p></o:p></p>
<div style="MARGIN-LEFT: 36pt">
<div style="TEXT-ALIGN: center; MARGIN-LEFT: 36pt" class="MsoNormal" align="center">
<hr align="center" size="1" width="100%">
</div></div>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal">Message protected by MailGuard: e-mail anti-virus, anti-spam
and content filtering.<br><a href="http://www.mailguard.com.au" target="_blank"><a href="http://www.mailguard.com.au">http://www.mailguard.com.au</a></a><br><br><a href="https://login.mailguard.com.au/report/1DwvnwjLRM/qPkWQK7xjKwKxXL4nIV62/0.002" target="_blank">Report this message as spam</a> <br> <o:p></o:p></p>
<p style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 72pt; mso-margin-top-alt: auto" class="MsoNormal"><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 style="MARGIN-LEFT: 36pt">
<div style="TEXT-ALIGN: center; MARGIN-LEFT: 36pt" class="MsoNormal" align="center">
<hr align="center" size="1" width="100%">
</div></div>
<p style="MARGIN-LEFT: 72pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal">Message protected by MailGuard: e-mail anti-virus, anti-spam
and content filtering.<br><a href="http://www.mailguard.com.au" target="_blank"><a href="http://www.mailguard.com.au">http://www.mailguard.com.au</a></a><br> <br> <o:p></o:p></p>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"> <o:p></o:p></p>
<div style="TEXT-ALIGN: center; MARGIN-LEFT: 36pt" class="MsoNormal" align="center">
<hr align="center" size="2" width="100%">
</div>
<p style="MARGIN-LEFT: 36pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class="MsoNormal"><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: gray; FONT-SIZE: 7.5pt">Disclaimer<br>This
message, including any attachments, is provided without responsibility in law
for its accuracy or otherwise and without assumption of a duty of care by the
School - Assumption College Kilmore. Whilst every attempt has been made to
ensure material in this e-mail message is free from computer viruses or other
defects, the attached files are provided, and may only be used, on the basis
that the user assumes all responsibility for use of the material transmitted.
Assumption College Kilmore accepts no liability for any direct or indirect
damage or loss resulting from the use of any attachments to this
e-mail.<br>This e-mail is private and confidential. 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 the sender
immediately and destroy the original message. The views expressed in this
e-mail are those of the author, and do not represent those of Assumption
College Kilmore unless this is clearly
indicated.</span><o:p></o:p></p></div></div></div></div>
<p style="MARGIN-LEFT: 36pt" class="MsoNormal"><br>_______________________________________________<br><a href="http://www.edulists.com.au" target="_blank"><a href="http://www.edulists.com.au">http://www.edulists.com.au</a></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" target="_blank"><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></a>
- Victorian Curriculum and Assessment Authority and<br><a href="http://www.vitta.org.au" target="_blank"><a href="http://www.vitta.org.au">http://www.vitta.org.au</a></a>
- VITTA Victorian Information Technology Teachers Association
Inc<o:p></o:p></p></div>
<p style="MARGIN-LEFT: 36pt" class="MsoNormal"><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"><a href="mailto:kel@mckinnonsc.vic.edu.au">kel@mckinnonsc.vic.edu.au</a></a><br>VCE IT Lecture Notes: <a href="http://vceit.com" target="_blank"><a href="http://vceit.com">http://vceit.com</a></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>
<p>
</p><hr>
<p></p>_______________________________________________<br><a href="http://www.edulists.com.au"><a href="http://www.edulists.com.au">http://www.edulists.com.au</a></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"><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></a> -
Victorian Curriculum and Assessment Authority
and<br><a href="http://www.vitta.org.au"><a href="http://www.vitta.org.au">http://www.vitta.org.au</a></a> - VITTA Victorian Information Technology
Teachers Association Inc</blockquote>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span><a href="http://www.edulists.com.au"><a href="http://www.edulists.com.au">http://www.edulists.com.au</a></a> - FAQ, resources, subscribe, unsubscribe</span><br><span>IT Applications Mailing List kindly supported by</span><br><span><a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html"><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></a> - Victorian Curriculum and Assessment Authority and</span><br><span><a href="http://www.vitta.org.au"><a href="http://www.vitta.org.au">http://www.vitta.org.au</a></a> - VITTA Victorian Information Technology Teachers Association Inc</span></div></blockquote><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>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span><a href="http://www.edulists.com.au">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe</span><br><span>IT Applications Mailing List kindly supported by</span><br><span><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</span><br><span><a href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc</span></div></blockquote></body></html>