[Year 12 IT Apps] ITA exam Q12e

Thu Nov 12 13:31:40 EST 2009

I think you are over complicating the whole thing.

The most efficient way of create a delivery slip is to:

1. Have a macro that creates a blank delivery slip (with a button on the Delivery Cost sheet)

2. Cut and paste the relevant details from the DeliveryCost and CustomerInfo sheets onto the Delivery sheet

Too easy 

:-)

Mark Scott
Luther College

-----Original Message-----
From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au] On Behalf Of Litsa Tzelepis
Sent: Thursday, 12 November 2009 1:19 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] ITA exam Q12e

you make me laugh mark;
yes that's what i mean about sheet referencing and i agree with you.
it was all in the name of the question.
no problemo, 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 12:57 PM
Subject: Re: [Year 12 IT Apps] ITA exam Q12e

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