[Year 12 IT Apps] ITA exam Q12e

[Litsa Tzelepis]

hello.
given the question, i may have used sheet referencing to create the delivery 
slips from the "customerinfo" and "deliverycost" sheets. we've done 
thabefore in an outcome with sample data? granted it would create a massive 
sheet with delivery slips but i certainly didn't think mail merge.


----- Original Message ----- 
From: "Mark Kelly" <kel at mckinnonsc.vic.edu.au>
To: "Year 12 IT Applications Teachers' Mailing List" 
<itapps at edulists.com.au>
Sent: Thursday, November 12, 2009 10:37 AM
Subject: [Year 12 IT Apps] ITA exam Q12e


> I've given B12e a SHMACKO award because I believe it is fishing for a 
> 'mail merge' answer to producing individualised output from a spreadsheet.
>
> It's the only conclusion I can come to. But no profession would be so 
> silly as to use a spreadsheet for storing customer data and producing 
> output like delivery slips.
>
> Did anyone think of an answer that did NOT involve mail merge?
>
> Overall, B12 was a complete disaster in terms of realistic IT practices...
>
> - its VLOOKUP table was just wrong
> - IF was examined for the third time - A9, B11c(i), B12b(i)
> - test data was examined for the second time B11c(ii) and B12b(iii)
> - it seems to want students to use clumsy $ notation instead of elegant 
> cell naming
> - it's using an inappropriate software tool and forcing clumsy kludges 
> like mail merge.
>
>
> -- 
> Mark Kelly
> Manager - Information Systems
> McKinnon Secondary College
> McKinnon Rd McKinnon 3204, Victoria, Australia
> Direct line / Voicemail: 8520 9085
> School Phone +613 8520 9000
> School Fax +613 9578 9253
> kel at mckinnonsc.vic.edu.au
>
> Webmaster - http://www.mckinnonsc.vic.edu.au
> IT Lecture notes: http://vceit.com
> Moderator: IT Applications Mailing List
>
> RealMenDon'tNeedSpacebars.
> _______________________________________________
> 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 and
> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers 
> Association Inc
>