[Year 12 IT Apps] ITA exam Q12e
Mark Scott
msc at luther.vic.edu.au
Thu Nov 12 16:16:15 EST 2009
I didn't say it was a good solution or one that I liked.
Just the most efficient way to create a solution to a dog of a question.
arf arf
Mark Scott
Luther College
-----Original Message-----
From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au] On Behalf Of Laurie Savage
Sent: Thursday, 12 November 2009 3:56 PM
To: 'Year 12 IT Applications Teachers' Mailing List'
Subject: RE: [Year 12 IT Apps] ITA exam Q12e
I don't like your point 2, certainly not in a real organisation. Your Macro would need to be extended to make this idiot-proof. Never underestimate the ability of the average user to nobble a bespoke application.
In fact I don't like the idea of using Excel to generate commercial invoices at all. It is great for ephemeral uses like a quotation system where permanent records are less important, but an invoicing, warehousing and dispatch system should be database driven. Data in excel can be too easily damaged. See, for example, item II in http://www.daheiser.info/excel/frontpage.html which discusses organisational misuse of Excel.
BTW I've been enjoying the nested IF v VLOOKUP debate with relish. I discovered VLOOKUP long after I had created Grade sheets full of nested IFs
- using the old MS Works and Claris Works templates as a model! What a waste.
Laurie Savage
PVGC
-----Original Message-----
From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au]
On Behalf Of Mark Scott
Sent: Thursday, 12 November 2009 1:32 PM
To: 'Year 12 IT Applications Teachers' Mailing List'
Subject: RE: [Year 12 IT Apps] ITA exam Q12e
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.ht
>>> ml -
>>> 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.htm
>> l - 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
_______________________________________________
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
More information about the itapps
mailing list