[Year 12 IT Apps] ITA exam Q12e

Thu Nov 12 13:57:37 EST 2009

The dialogue I am hearing here suggests to me the very reasons this type
of question on the ITA exam should have been avoided.
A part of an individual's (examiners) solution has been presented in
isolation in a problem solving context for the student to respond to.
I believe that type of cognitative learning experience should have been
confined to the practical hands-on component of the course which has
been dealt with in the coursework. 
There will be an enormous range of preferences and constraints for how
different individuals could see the solution proceeding and various
levels of effectiveness and suitabilities will result which would all be
considered worthy if they achieve the overall aim of the analysis of
problem and stand up to the evaluation. That is why we have prac. work
to cover this type learning.  There would be many equivalent theoretical
responses that could have been sought, around the discussion that we are
having about the nature of the possible solutions without having
questions that are too specifically contrived and incomplete in a
practical context as has happened here. 

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

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.