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

[Savage, John L]

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.

Laurie Savage
http://accelerus.pvgc.vic.edu.au

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au] On Behalf Of Roland Gesthuizen
Sent: Thursday, 7 November 2013 8:57 AM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] ITA exam - B10b (i)

GoogleDocs spreadsheet with the security pegged at a public view setting?

Regards Roland

Roland Gesthuizen | eLearning Leader
Keysborough College DEECD
http://about.me/rgesthuizen

"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

On 7 Nov 2013, at 8:47 am, Savage, John L <savage.john.l at edumail.vic.gov.au<mailto:savage.john.l at edumail.vic.gov.au>> wrote:


Vlookup(value, products_list, picture_column)?

Laurie Savage

From: itapps-bounces at edulists.com.au<mailto:itapps-bounces at edulists.com.au> [mailto:itapps-bounces at edulists.com.au] On Behalf OfMark
Sent: Wednesday, 6 November 2013 5:27 PM
To: Year 12 IT Applications Teachers' Mailing List
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<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



Important - 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.
_______________________________________________
http://www.edulists.com.au<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<http://www.vitta.org.au/>  - VITTA Victorian Information Technology Teachers Association Inc <br>
http://www.swinburne.edu.au/ict/schools - Swinburne University


Important - 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20131106/00a2e4b7/attachment.html