[Year 12 IT Apps] ITA exam - B10b (i)

[Robert Hind]

Another Bex and another lie down! Now!

Robert Hind
Retired
Ex Traralgon and Ashwood
  ----- Original Message ----- 
  From: Mark 
  To: Year 12 IT Applications Teachers' Mailing List 
  Sent: Wednesday, November 06, 2013 5:26 PM
  Subject: [Year 12 IT Apps] ITA exam - B10b (i)


  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.  


  Take this delight hiding in section B, Q10b part (i)...


  "i. Describe how the manager can identify and display on a web page the cheapest fruit available."



  I'd like you all to pause for a moment and plan an answer to that in your heads. I'll wait. 


  Finished? Are you sure? 


  "Yes, a quick =MIN(C2:C5) formula," you say.


  But have you noticed the words "and display on a web page"?


  Try answering it now. 


  Assuming that someone doesn't just look at the price onscreen and type 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?

  And even if we did just use the MIN function, it would only display the value of the lowest price, not the name of the cheapest fruit... that's an achievable, but very different kettle of fish.



  And it's worth all of 2 marks!



  Beyond belief. 


  I'm dying to see what the examiner's report gives as a model answer...


  --

  Mark Kelly
  mark AT vceit DOT com
  http://vceit.com


  Day 19, I have successfully conditioned my master to smile and write in his book every time I drool.- Pavlov's Dog





------------------------------------------------------------------------------


  _______________________________________________
  http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
  IT Applications Mailing List kindly supported by
  http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - Victorian Curriculum and Assessment Authority <br>
  http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc <br>
  http://www.swinburne.edu.au/ict/schools - Swinburne University


------------------------------------------------------------------------------


  No virus found in this message.
  Checked by AVG - www.avg.com
  Version: 2014.0.4158 / Virus Database: 3629/6811 - Release Date: 11/05/13
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20131106/416ce2df/attachment.html