<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML dir=ltr><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16441" name=GENERATOR>
<STYLE>
<!--
font-face
{font-family:Wingdings;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
span.EmailStyle19
{
font-family:Arial;
color:navy;}
div.Section1
{page:Section1;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</STYLE>
</HEAD>
<BODY lang=EN-AU vLink=blue link=blue>
<DIV dir=ltr align=left><SPAN class=501480503-28112007><FONT face=Arial
color=#0000ff size=2>True.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=501480503-28112007><FONT face=Arial
color=#0000ff size=2>Well Done</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=501480503-28112007><FONT face=tahoma
size=2>====================================================<BR>Stephen Digby,
Learning Technology Manager<BR>mailto: <A
href="mailto:admin@cheltsec.vic.edu.au">admin@cheltsec.vic.edu.au</A>
<BR>Cheltenham Secondary College <A
href="http://www.cheltsec.vic.edu.au/">www.cheltsec.vic.edu.au</A><BR>Ph: 613
955 55 955 Fx: 9555 8617 Mb:
0431-701-028<BR>====================================================<BR>Don't be
humble, you're not that great. Golda Meir <BR></FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> itapps-bounces@edulists.com.au
[mailto:itapps-bounces@edulists.com.au] <B>On Behalf Of </B>SAMANTHA
MITCHELL<BR><B>Sent:</B> Wednesday, 28 November 2007 1:50 PM<BR><B>To:</B> Year
12 IT Applications Teachers' Mailing List<BR><B>Subject:</B> [Year 12 IT Apps]
Exam Q B 11e<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV id=idOWAReplyText3147 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Sorry if this has
posted multiple times, I’ve been having trouble sending
it…</SPAN></FONT></DIV></DIV>
<DIV dir=ltr>
<DIV>
<DIV class=Section1>
<DIV id=idOWAReplyText11931>
<DIV>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">Hi,</SPAN></FONT></P></DIV></DIV>
<DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">A student of mine has been mulling
over the exam questions and has noticed a problem with the formula in
short answer Q11e (Keith has already mentioned it on the
wiki).</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">If they want <EM><I><FONT
face=Arial><SPAN style="FONT-FAMILY: Arial">"to alert customers when their new
bill is </SPAN></FONT></I></EM><STRONG><B><I><FONT face=Arial color=red><SPAN
style="COLOR: red; FONT-STYLE: italic; FONT-FAMILY: Arial">$100 or
more</SPAN></FONT></I></B></STRONG><EM><I><FONT face=Arial><SPAN
style="FONT-FAMILY: Arial"> than their previous
bill"</SPAN></FONT></I></EM> the formula should be <STRONG><B><FONT
face=Arial><SPAN style="FONT-FAMILY: Arial">=If(B2><FONT color=red><SPAN
style="COLOR: red">=</SPAN></FONT>(B3+ l00),"ALERT","
")</SPAN></FONT></B></STRONG>.</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I think the test data should
be:</SPAN></FONT></P></DIV>
<UL type=disc>
<LI class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">B2 (new bill)=300, B3 (previous
bill)=200, C5=Nothing</SPAN></FONT>
<LI class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">B2 (new bill)=301, B3 (previous
bill)=200, C5=ALERT</SPAN></FONT> </LI></UL>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I could be wrong but it seems to me
that the test data suggested on <A
href="http://www.mckinnonsc.vic.edu.au/vceit/postmortems/2007ita/index.htm">http://www.mckinnonsc.vic.edu.au/vceit/postmortems/2007ita/index.htm</A> and
<A
href="http://webmail.milsen.vic.edu.au/exchweb/bin/redir.asp?URL=http://infonet.cheltsec.vic.edu.au/file.php/1/ITA4-Exam-2007-VCAA-Answers-DIGv1.pdf"
target=_blank>http://infonet.cheltsec.vic.edu.au/file.php/1/ITA4-Exam-2007-VCAA-Answers-DIGv1.pdf</A> is
wrong, maybe they should have swapped the cell references B2 & B3 in their
suggested answers??? (apologies in to Mark & Stephen - I really
appreciate you both putting yourselves out there)</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">What so you think? My student spent
some time pondering whether this was a sneaky question challenging him to notice
the discrepancy between the formula provided and the statement <EM><I><FONT
face=Arial><SPAN style="FONT-FAMILY: Arial">"to alert customers when their new
bill is </SPAN></FONT></I></EM><STRONG><B><I><FONT face=Arial color=red><SPAN
style="COLOR: red; FONT-STYLE: italic; FONT-FAMILY: Arial">$100 or
more</SPAN></FONT></I></B></STRONG><EM><I><FONT face=Arial><SPAN
style="FONT-FAMILY: Arial"> than their previous bill"</SPAN></FONT></I></EM>
</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Samantha
Mitchell</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Mildura</SPAN></FONT><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> Senior
College</SPAN></FONT></P></DIV></DIV></DIV></DIV></DIV>_______________________________________________
<BR><A href="http://www.edulists.com.au">http://www.edulists.com.au </A>- FAQ,
resources, subscribe, unsubscribe <BR>IT Applications Mailing List kindly
supported by <BR><A
href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html ">http://www.vcaa.vic.edu.auvce/studies/infotech/infotechindex.html
</A>- Victorian Curriculum and Assessment Authority and <BR><A
href="http://www.vitta.org.au">http://www.vitta.org.au </A>- VITTA Victorian
Information Technology Teachers Association Inc<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>