[Year 12 IT Apps] ITA exam Q12e
Laurie Savage
sav at pvgc.vic.edu.au
Thu Nov 12 16:33:26 EST 2009
Sorry, my mistake, woof.
Laurie
-----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 4:16 PM
To: 'Year 12 IT Applications Teachers' Mailing List'
Subject: RE: [Year 12 IT Apps] ITA exam Q12e
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
_______________________________________________
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