<div dir="ltr">That's how I interpreted the question at first - some automated system was required, because the question was about data management.<div>But the question does ask how the <b>manager</b> would do it, so the examiners can say it could be a manual task. </div>
<div>If so, suddenly the question stops being about data management and turns into a "How do you change a webpage?" question, which is different key knowledge.</div><div>Subquestions are certainly allowed to change topic (e.g. B12 turned from sorting text into database queries) but unless the change of direction is obvious, I assume the same key knowledge is being assessed: in this case, data management and access.</div>
<div><br></div><div>I guess most kids probably didn't think it to death like I did, and just gave the basic "Type the price into the webpage manually" answer.</div><div><br></div><div>Either way, the answer was going to be too easy or too hard...</div>
<div><br></div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 7 November 2013 10:31, Savage, John L <span dir="ltr"><<a href="mailto:savage.john.l@edumail.vic.gov.au" target="_blank">savage.john.l@edumail.vic.gov.au</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-AU" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">That really is more of a SD question isn’t it – it’s really asking for some backend script to interrogate a database (or csv file) and return a file name dependent
on a value.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Laurie Savage<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><a href="http://accelerus.pvgc.vic.edu.au" target="_blank">http://accelerus.pvgc.vic.edu.au</a><u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<div>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:itapps-bounces@edulists.com.au" target="_blank">itapps-bounces@edulists.com.au</a> [mailto:<a href="mailto:itapps-bounces@edulists.com.au" target="_blank">itapps-bounces@edulists.com.au</a>]
<b>On Behalf Of </b>Roland Gesthuizen<br>
<b>Sent:</b> Thursday, 7 November 2013 8:57 AM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> Re: [Year 12 IT Apps] ITA exam - B10b (i)<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">GoogleDocs spreadsheet with the security pegged at a public view setting?<u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:13.5pt;font-family:"Helvetica","sans-serif""><br>
Regards Roland<br>
<br>
<b>Roland Gesthuizen</b> | eLearning Leader <br>
Keysborough College DEECD<br>
<a href="http://about.me/rgesthuizen" target="_blank">http://about.me/rgesthuizen</a><u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="font-size:13.5pt;font-family:"Helvetica","sans-serif""><br>
"Never doubt that a small group of thoughtful, committed citizens can change the world; indeed it is the only thing that ever has." --Margaret Mead
<u></u><u></u></span></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On 7 Nov 2013, at 8:47 am, Savage, John L <<a href="mailto:savage.john.l@edumail.vic.gov.au" target="_blank">savage.john.l@edumail.vic.gov.au</a>> wrote:<u></u><u></u></p>
</div>
<p class="MsoNormal"><br>
<br>
<u></u><u></u></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Vlookup(value, products_list, picture_column)?</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Laurie Savage</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> </span></span><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""><a href="mailto:itapps-bounces@edulists.com.au" target="_blank"><span style="color:purple">itapps-bounces@edulists.com.au</span></a><span> </span>[<a href="mailto:itapps-bounces@edulists.com.au" target="_blank"><span style="color:purple">mailto:itapps-bounces@edulists.com.au</span></a>]<span> </span><b>On
Behalf Of</b>Mark<br>
<b>Sent:</b><span> </span>Wednesday, 6 November 2013 5:27 PM<br>
<b>To:</b><span> </span>Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b><span> </span>[Year 12 IT Apps] ITA exam - B10b (i)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<div>
<div>
<p class="MsoNormal">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. <u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal">Take this delight hiding in section B, Q10b part (i)...<u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal">"i. Describe how the manager can identify and display on a web page the cheapest fruit available."<br clear="all">
<u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal">I'd like you all to pause for a moment and plan an answer to that in your heads. I'll wait. <u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal">Finished? Are you sure? <u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal">"Yes, a quick =MIN(C2:C5) formula," you say.<u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal">But have you noticed the words "<b>and display on a web page</b>"?<u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal">Try answering it<span> </span><b>now</b>. <u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal">Assuming that someone doesn't just<span> </span><b>look</b><span> </span>at the price onscreen and<span> </span><b>type</b><span> </span>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?<u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal">And even if we<span> </span><b>did</b><span> </span>just use the MIN function, it would only display the<span> </span><b>value</b><span> </span>of
the lowest price, not the<span> </span><b>name</b><span> </span>of the cheapest fruit... that's an achievable, but very different kettle of fish.<u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal">And it's worth all of<span> </span><b>2 marks</b>!<u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal">Beyond belief. <u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal">I'm dying to see what the examiner's report gives as a model answer...<u></u><u></u></p>
</div>
</div>
</div>
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal">--<u></u><u></u></p>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal">Mark Kelly<u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal">mark AT vceit DOT com<u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"><a href="http://vceit.com/" target="_blank"><span style="color:purple">http://vceit.com</span></a><u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";background:#fdfdff">Day 19, I have successfully conditioned my master to smile and write in his book every time I drool.- Pavlov's Dog</span><u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Helvetica","sans-serif""><u></u> <u></u></span></p>
</div>
<p><b><span style="font-size:9.0pt;font-family:"Helvetica","sans-serif"">Important -<span> </span></span></b><span style="font-size:9.0pt;font-family:"Helvetica","sans-serif"">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.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Helvetica","sans-serif"">_______________________________________________<br>
<a href="http://www.edulists.com.au/" target="_blank"><span style="color:purple">http://www.edulists.com.au</span></a><span> </span>- FAQ, resources, subscribe, unsubscribe<br>
IT Applications Mailing List kindly supported by<br>
<a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html" target="_blank"><span style="color:purple">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</span></a><span> </span>- Victorian Curriculum and
Assessment Authority <br><br>
<a href="http://www.vitta.org.au/" target="_blank"><span style="color:purple">http://www.vitta.org.au</span></a><span> </span> - VITTA Victorian Information Technology Teachers Association Inc <br><br>
<a href="http://www.swinburne.edu.au/ict/schools" target="_blank"><span style="color:purple">http://www.swinburne.edu.au/ict/schools</span></a><span> </span>- Swinburne University<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<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>
</div>
<br>_______________________________________________<br>
<a href="http://www.edulists.com.au" target="_blank">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.au/vce/studies/infotech/itapplications3-4.html" target="_blank">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority <br><br>
<a href="http://www.vitta.org.au" target="_blank">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc <br><br>
<a href="http://www.swinburne.edu.au/ict/schools" target="_blank">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><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>