[Year 12 IT Apps] ITA exam Q12e

Laurie Savage sav at pvgc.vic.edu.au
Thu Nov 12 15:56:03 EST 2009 

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

More information about the itapps mailing list