<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML dir=ltr><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16544" name=GENERATOR>
<STYLE>font-face {
FONT-FAMILY: Wingdings
}
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.EmailStyle19 {
COLOR: navy; FONT-FAMILY: Arial
}
DIV.Section1 {
page: Section1
}
OL {
MARGIN-BOTTOM: 0cm
}
UL {
MARGIN-BOTTOM: 0cm
}
</STYLE>
</HEAD>
<BODY lang=EN-AU vLink=blue link=blue bgColor=#ffffff>
<DIV><FONT face=Arial>Yes there is a discrepancy between the formula shown
and the written description! And I am sure that the examiners will have taken
that into consideration when marking the question.</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>Having said that</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>1. Your answers are based on the formula <SPAN
style="FONT-FAMILY: Arial"><STRONG>=If(B2><FONT color=red><SPAN
style="COLOR: red">=</SPAN></FONT>(B3+ l00),"ALERT"," ")</STRONG> and your first
answer is wrong as that data satisfies B2=(B3+100) and so would show an
alert.</SPAN></FONT></DIV>
<DIV><FONT face=Arial>2. The answers at </FONT><A
href="http://www.mckinnonsc.vic.edu.au/vceit/postmortems/2007ita/index.htm"><FONT
face=Arial
size=2>http://www.mckinnonsc.vic.edu.au/vceit/postmortems/2007ita/index.htm</FONT></A><FONT
face=Arial> make no comment about the discrepancy between the formula
shown and then show an alert being displayed when B2=(B3+100), ie they
have read the written description and assumed as you did that the formula should
have read <SPAN style="FONT-FAMILY: Arial"><STRONG>=If(B2><FONT
color=red><SPAN style="COLOR: red">=</SPAN></FONT>(B3+ l00),"ALERT","
")</STRONG></SPAN></FONT></DIV>
<DIV><FONT face=Arial>3. The answers at <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><FONT
size=2>http://infonet.cheltsec.vic.edu.au/file.php/1/ITA4-Exam-2007-VCAA-Answers-DIGv1.pdf</FONT></A> mix
up B2 and B3 as This Bill and Last Bill but do then base their test data on the
formula shown in the question. But the answers as shown are wrong.</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>Happy end of yearing!</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>Robert Hind (Semi-retired)<BR>Ex Traralgon and
Ashwood<BR></FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=MITCHELLS@milsen.vic.edu.au
href="mailto:MITCHELLS@milsen.vic.edu.au">SAMANTHA MITCHELL</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> Wednesday, November 28, 2007 1:49
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Year 12 IT Apps] Exam Q B
11e</DIV>
<DIV><BR></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</BLOCKQUOTE></BODY></HTML>