[Year 12 IT Apps] ITA exam Q12e

[Mark Kelly]

Hi Litsa.  Do you mean you were just referring to a value on a different 
sheet, like "employees!A6" ?

Last century I gave up using tasks that involved spreadsheets producing 
bulk pay cheques, certificates, receipts etc. It results in awful, truly 
awful solutions because it's not what spreadsheets are supposed to do.

That's why we have databases.  But try telling that to the examiners.

Cheers
Mark

Litsa Tzelepis wrote:
> 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
>>
> 
> _______________________________________________
> 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
> 
> 


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