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

[Mark]

Good idea!


On 7 November 2013 08:56, Roland Gesthuizen <rgesthuizen at gmail.com> wrote:

> 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> wrote:
>
>  Vlookup(value, products_list, picture_column)?
>
> Laurie Savage
>
> *From:* itapps-bounces at edulists.com.au [
> mailto:itapps-bounces at edulists.com.au <itapps-bounces at edulists.com.au>] *On
> Behalf Of*Mark
> *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
>
> 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 - 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
>
>
>
> _______________________________________________
> 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
>



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