[Year 12 IT Apps] ITA exam Q12e

[Litsa Tzelepis]

hi mark,
it was just an idea. we've done payroll slips for about 6 employees using 
sheet referencing, individually, not in a batch system. by no means is it a 
glamorous solution.
litsa


----- 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 11:24 AM
Subject: Re: [Year 12 IT Apps] ITA exam Q12e


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