<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16514">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>Another Bex and another lie down! Now!</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Robert Hind<BR>Retired<BR>Ex Traralgon and
Ashwood</FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=mark@vceit.com href="mailto:mark@vceit.com">Mark</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 06, 2013 5:26
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Year 12 IT Apps] ITA exam -
B10b (i)</DIV>
<DIV><BR></DIV>
<DIV dir=ltr>
<DIV>Hi all. I'm nearing the end of the post mortem, but this is turning into
one of the dodgiest ITA exams I've seen in some time. </DIV>
<DIV><BR></DIV>
<DIV>Take this delight hiding in section B, Q10b part (i)...</DIV>
<DIV><BR></DIV>"i.<SPAN style="WHITE-SPACE: pre"> </SPAN>Describe how the
manager can identify and display on a web page the cheapest fruit
available."<BR clear=all>
<DIV><BR></DIV>
<DIV>I'd like you all to pause for a moment and plan an answer to that in your
heads. I'll wait. </DIV>
<DIV><BR></DIV>
<DIV>Finished? Are you sure? </DIV>
<DIV><BR></DIV>
<DIV>"Yes, a quick =MIN(C2:C5) formula," you say.</DIV>
<DIV><BR></DIV>
<DIV>But have you noticed the words "<B>and display on a web page</B>"?</DIV>
<DIV><BR></DIV>
<DIV>Try answering it <B>now</B>. </DIV>
<DIV><BR></DIV>
<DIV>Assuming that someone doesn't just <B>look</B> at the price onscreen and
<B>type</B> it into a webpage manually with a webpage editor, do the examiners
want kids to explain some ColdFusion, DDE link, SQL, or PHP code to magically
extract a value from a spreadsheet/database and inject it into a dynamic web
page?</DIV>
<DIV> </DIV>
<DIV>And even if we <B>did</B> just use the MIN function, it would only
display the <B>value</B> of the lowest price, not the <B>name</B> of the
cheapest fruit... that's an achievable, but very different kettle of
fish.<BR></DIV>
<DIV><BR></DIV>
<DIV>And it's worth all of <B>2 marks</B>!<BR></DIV>
<DIV><BR></DIV>
<DIV>
<DIV>Beyond belief. </DIV>
<DIV><BR></DIV>
<DIV>I'm dying to see what the examiner's report gives as a model
answer...</DIV></DIV>
<DIV><BR></DIV>
<DIV>--<BR></DIV>
<DIV dir=ltr>
<DIV>Mark Kelly</DIV>
<DIV>mark AT vceit DOT com</DIV>
<DIV><A href="http://vceit.com" target=_blank>http://vceit.com</A></DIV>
<DIV><BR></DIV>
<DIV><SPAN
style="BACKGROUND-COLOR: rgb(253,253,255); FONT-FAMILY: verdana,arial,helvetica,sans-serif; COLOR: rgb(0,0,0)"><FONT
size=1>Day 19, I have successfully conditioned my master to smile and write in
his book every time I drool.- Pavlov's Dog</FONT></SPAN><BR></DIV>
<DIV><BR></DIV></DIV></DIV>
<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
<br><BR>http://www.vitta.org.au - VITTA Victorian Information
Technology Teachers Association Inc
<br><BR>http://www.swinburne.edu.au/ict/schools - Swinburne University
<P>
<HR>
<P></P><A></A>
<P align=left color="#000000" avgcert??>No virus found in this
message.<BR>Checked by AVG - <A
href="http://www.avg.com">www.avg.com</A><BR>Version: 2014.0.4158 / Virus
Database: 3629/6811 - Release Date: 11/05/13</P></BLOCKQUOTE></BODY></HTML>