[Year 12 IT Apps] ITA exam
Hewett, W G
Hewett.W.G at edumail.vic.gov.au
Thu Nov 12 21:56:11 EST 2009
Greetings all
I wonder how much discussion/debate was entered into at the markers' meeting immediately after the exam?
Wayne Hewett
Acting Learning Technologies Coordinator.... and counting.
ROSEBUD SECONDARY COLLEGE
-----Original Message-----
From: itapps-bounces at edulists.com.au on behalf of Laurie Savage
Sent: Thu 12/11/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.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
_______________________________________________
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
Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 6459 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20091112/d3d0d26d/attachment.bin
More information about the itapps
mailing list