[Year 12 IT Apps] ITA exam Q12e

Fri Nov 13 07:53:32 EST 2009

But the question said "automatically"... cutting and pasting ain't 
exactly automatic...

Mark Scott wrote:
>  
> 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
> 
> _______________________________________________
> 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.