<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 class="" 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="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;background-color:rgb(253,253,255)"><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>