[Year 12 IT Apps] ITA exam Q12e

[Mark Kelly]

Litsa Tzelepis wrote:
> hello.
> given the question, i may have used sheet referencing to create the 
> delivery slips from the "customerinfo" and "deliverycost" sheets.

How do you do that, though?  Is there some arcane feature in Excel of 
which I have not heard that allows multiple individualised outputs?  I'd 
love to hear about it if it's there...

>  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.
>> _______________________________________________


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