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

Thu Nov 7 11:09:36 EST 2013

That's how I interpreted the question at first - some automated system was
required, because the question was about data management.
But the question does ask how the *manager* would do it, so the examiners
can say it could be a manual task.
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.
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.

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.

Either way, the answer was going to be too easy or too hard...

On 7 November 2013 10:31, Savage, John L
<savage.john.l at edumail.vic.gov.au>wrote:

>  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> 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
>
>
>
> *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
>

-- 
--
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/651a4794/attachment-0001.html 