<HTML dir=ltr><HEAD>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.16544" 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 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></BODY></HTML>