[Year 12 IT Apps] RE: answer to ITA Exam Que B12e
Lumsden, Richard G
lumsden.richard.g at edumail.vic.gov.au
Wed Nov 18 08:20:39 EST 2009
No, all the data is drawn from the delivery table to produce the
customer's data in the delivery docket table using Vlookups.
The only additional operations for the delivery table data entry would
be a macro that sorts on Cust_id and fill series for the row counter I
have used. (in that order)
However, if this is something like what the examiners were looking for
then I believe it is unrealistic to get all but the most ardent software
application type students to come up with the 'goods' in an exam
setting. It took me about 40-60 minutes to plan the solution which I
could not have done without the use of some good old 'trial and error'
testing and Help screens to point me in the right direction. That is
the nature of practical software solutions using computers and is the
very reason this type of activity should have been confined to the
practical component of the course, as I have expressed in an earlier
email.
-----Original Message-----
From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Mark Kelly
Sent: Wednesday, 18 November 2009 8:03 AM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] RE: answer to ITA Exam Que B12e
Hmmm! Clever. The item's weight is entered manually, but this could
also be VLOOKUP'd. And the customer IDs must always be in alphabetical
order...
Just goes to show how many hoops one needs to jump through to compensate
for using the wrong tool in the first place.
Lumsden, Richard G wrote:
> Here's my attempt at Q12be
>
>
>
>
>
>
>
>
------------------------------------------------------------------------
>
> *From:* itapps-bounces at edulists.com.au
> [mailto:itapps-bounces at edulists.com.au] *On Behalf Of *Chattrath,
> Divinderjit S
> *Sent:* Tuesday, 17 November 2009 1:05 PM
> *To:* itapps at edulists.com.au
> *Subject:* answer to ITA Exam Que B12e
>
>
>
> Hi Everyone
>
> /G'Day/
>
> /Ok! Now it is time to talk again since Mark have mentioned and I
quote/
>
> /"//It's been a week since the ITA exam and not one wise and erudite
ITA
> teacher across the entire state has managed to suggest a way that B12e
> could be answered."/
>
> / /
>
> /I was not saying anything about this question because I was thinking
> from students' point of view./
>
> /I can do this. Process is as follows and if anyone has doubts, please
> feel free to ask for the actual demonstration. which will be done on
> this weekend as I need time (fair enough?)/
>
> /I will use some buttons with VBA coding/
>
> /Steps/
>
> /Arranging the customers' names in order (no need if they are already
in
> order as in this case. It looks that delivery cost worksheet is
already
> made to bring them in order. This can be possible if the entry form is
> on a different sheet and then the data is stored in this sheet)/
>
> / /
>
> /Now we are to read the customer's id which is starting from a fixed
> cell number and write it on a new sheet say "recepitForCustId_1" along
> with all the related data from "DeliveryCost" sheet and the customers'
> info from "CustomerInfo" sheet . It is not any problem but now we will
> have to check through coding whether the customer id code is repeating
> in the next row. If it is repeating then the info of this line goes to
> the same sheet. This part can be put in a LOOP. Once the Cust_id
changes
> then we can create a new sheet with the new cust id and repeat the
> process again using LOOP until the cell with the ID is blank./
>
> / /
>
> /So this way we have all the receipts produced on the separate sheets.
/
>
> / /
>
> /We can now have a print button which can print all the new produced
sheets/
>
> / /
>
> /Now we can have another button "DELETE receipts sheets" which will
> delete all the receipts produced./
>
> / /
>
> /Regards/
>
> /Bobby/
>
> IT & Maths Teacher, Craigieburn Secondary College
>
>
>
>
------------------------------------------------------------------------
>
> *From:* itapps-bounces at edulists.com.au on behalf of
> itapps-request at edulists.com.au
> *Sent:* Tue 17/11/2009 12:02 PM
> *To:* itapps at edulists.com.au
> *Subject:* itapps Digest, Vol 57, Issue 41
>
> Send itapps mailing list submissions to
> itapps at edulists.com.au
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://www.edulists.com.au/mailman/listinfo/itapps
> or, via email, send a message with subject or body 'help' to
> itapps-request at edulists.com.au
>
> You can reach the person managing the list at
> itapps-owner at edulists.com.au
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of itapps digest..."
>
>
> Today's Topics:
>
> 1. Re: ITA Exam B12e challenge (Mark Kelly)
> 2. RE: ITA Exam B12e challenge (Bane, Janet A)
> 3. Re: ITA Exam B12e challenge (Mark Kelly)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 17 Nov 2009 10:45:22 +1100
> From: Mark Kelly <kel at mckinnonsc.vic.edu.au>
> Subject: Re: [Year 12 IT Apps] ITA Exam B12e challenge
> To: "Year 12 IT Applications Teachers' Mailing List"
> <itapps at edulists.com.au>
> Message-ID: <4B01E412.40007 at mckinnonsc.vic.edu.au>
> Content-Type: text/plain; charset=windows-1252; format=flowed
>
> From http://www.wsu.edu/~brians/errors/stricken.html...
>
> "Most of the time the past participle of "strike" is "struck." The
> exceptions are that you can be stricken with guilt, a misfortune, a
> wound or a disease; and a passage in a document can be stricken out.
The
> rest of the time, stick with "struck." "
>
> ;-)
>
> Bane, Janet A wrote:
>> stricken or struck?
>>
>> Janet Bane
>> Patterson River SC
>>
>> ________________________________
>>
>> From: itapps-bounces at edulists.com.au on behalf of Mark Kelly
>> Sent: Tue 17-Nov-09 8:58 AM
>> To: Year 12 IT Applications Teachers' Mailing List
>> Subject: [Year 12 IT Apps] ITA Exam B12e challenge
>>
>>
>>
>> Hi all.
>>
>> OK. It's been a week since the ITA exam and not one wise and
erudite
>> ITA teacher across the entire state has managed to suggest a way
that
>> B12e could be answered.
>>
>> In my mind that makes it a fatally flawed question, and I will write
to
>> VCAA to have it stricken from the exam.
>>
>> Regards
>> Mark
>>
>> --
>> Mark Kelly
>> Manager - Information Systems
>> McKinnon Secondary College
>> kel AT mckinnonsc.vic.edu.au
>> McKinnon Rd, McKinnon 3204, Victoria, Australia
>> Direct line / Voicemail: 8520 9085 Fax +613 9578 9253
>>
>> Webmaster - http://www.mckinnonsc.vic.edu.au
> <http://www.mckinnonsc.vic.edu.au/>
<http://www.mckinnonsc.vic.edu.au/>
>> IT Lecture notes: http://vceit.com <http://vceit.com/>
<http://vceit.com/>
>> Moderator: IT Applications Mailing List
>>
>> Why do people mis-spell 'grammar' and mispronounce 'pronuniciation'?
>> _______________________________________________
>
>
> --
> 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
> <http://www.mckinnonsc.vic.edu.au/>
> IT Lecture notes: http://vceit.com <http://vceit.com/>
> Moderator: IT Applications Mailing List
>
> RealMenDon'tNeedSpacebars.
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 17 Nov 2009 10:51:28 +1100
> From: "Bane, Janet A" <bane.janet.a at edumail.vic.gov.au>
> Subject: RE: [Year 12 IT Apps] ITA Exam B12e challenge
> To: "Year 12 IT Applications Teachers' Mailing List"
> <itapps at edulists.com.au>
> Message-ID:
>
>
<BFAB4F58A236B04189B6F277FD3333D4034F1CCD at edusm05.education.vic.gov.au>
>
> Content-Type: text/plain; charset="iso-8859-1"
>
> geez Mark, you would give the bird on Can we help a run for her money.
> I am now enlightened :)
>
> regards
>
> Janet Bane
> Patterson River SC
>
> ________________________________
>
> From: itapps-bounces at edulists.com.au on behalf of Mark Kelly
> Sent: Tue 17-Nov-09 10:45 AM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: Re: [Year 12 IT Apps] ITA Exam B12e challenge
>
>
>
>
> From http://www.wsu.edu/~brians/errors/stricken.html...
>
> "Most of the time the past participle of "strike" is "struck." The
> exceptions are that you can be stricken with guilt, a misfortune, a
> wound or a disease; and a passage in a document can be stricken out.
The
> rest of the time, stick with "struck." "
>
> ;-)
>
> Bane, Janet A wrote:
>> stricken or struck?
>>
>> Janet Bane
>> Patterson River SC
>>
>> ________________________________
>>
>> From: itapps-bounces at edulists.com.au on behalf of Mark Kelly
>> Sent: Tue 17-Nov-09 8:58 AM
>> To: Year 12 IT Applications Teachers' Mailing List
>> Subject: [Year 12 IT Apps] ITA Exam B12e challenge
>>
>>
>>
>> Hi all.
>>
>> OK. It's been a week since the ITA exam and not one wise and
erudite
>> ITA teacher across the entire state has managed to suggest a way
that
>> B12e could be answered.
>>
>> In my mind that makes it a fatally flawed question, and I will write
to
>> VCAA to have it stricken from the exam.
>>
>> Regards
>> Mark
>>
>> --
>> Mark Kelly
>> Manager - Information Systems
>> McKinnon Secondary College
>> kel AT mckinnonsc.vic.edu.au
>> McKinnon Rd, McKinnon 3204, Victoria, Australia
>> Direct line / Voicemail: 8520 9085 Fax +613 9578 9253
>>
>> Webmaster - http://www.mckinnonsc.vic.edu.au
> <http://www.mckinnonsc.vic.edu.au/>
<http://www.mckinnonsc.vic.edu.au/>
> <http://www.mckinnonsc.vic.edu.au/>
>> IT Lecture notes: http://vceit.com <http://vceit.com/>
> <http://vceit.com/> <http://vceit.com/>
>> Moderator: IT Applications Mailing List
>>
>> Why do people mis-spell 'grammar' and mispronounce 'pronuniciation'?
>> _______________________________________________
>
>
> --
> 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
> <http://www.mckinnonsc.vic.edu.au/>
<http://www.mckinnonsc.vic.edu.au/>
> IT Lecture notes: http://vceit.com <http://vceit.com/>
<http://vceit.com/>
> Moderator: IT Applications Mailing List
>
> RealMenDon'tNeedSpacebars.
> _______________________________________________
> http://www.edulists.com.au <http://www.edulists.com.au/>
> <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 <http://www.vitta.org.au/>
> <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: 6354 bytes
> Desc: not available
> Url :
>
http://www.edulists.com.au/pipermail/itapps/attachments/20091117/4ecd6ff
c/attachment-0001.bin
>
> ------------------------------
>
> Message: 3
> Date: Tue, 17 Nov 2009 11:36:35 +1100
> From: Mark Kelly <kel at mckinnonsc.vic.edu.au>
> Subject: Re: [Year 12 IT Apps] ITA Exam B12e challenge
> To: "Year 12 IT Applications Teachers' Mailing List"
> <itapps at edulists.com.au>
> Message-ID: <4B01F013.4070008 at mckinnonsc.vic.edu.au>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> The bird on Can?
>
> Bane, Janet A wrote:
>> geez Mark, you would give the bird on Can we help a run for her
> money. I am now enlightened :)
>>
>> regards
>>
>> Janet Bane
>> Patterson River SC
>>
>> ________________________________
>>
>> From: itapps-bounces at edulists.com.au on behalf of Mark Kelly
>> Sent: Tue 17-Nov-09 10:45 AM
>> To: Year 12 IT Applications Teachers' Mailing List
>> Subject: Re: [Year 12 IT Apps] ITA Exam B12e challenge
>>
>>
>>
>>
>> From http://www.wsu.edu/~brians/errors/stricken.html...
>>
>> "Most of the time the past participle of "strike" is "struck." The
>> exceptions are that you can be stricken with guilt, a misfortune, a
>> wound or a disease; and a passage in a document can be stricken out.
The
>> rest of the time, stick with "struck." "
>>
>> ;-)
>>
>> Bane, Janet A wrote:
>> > stricken or struck?
>> >
>> > Janet Bane
>> > Patterson River SC
>> >
>> > ________________________________
>> >
>> > From: itapps-bounces at edulists.com.au on behalf of Mark Kelly
>> > Sent: Tue 17-Nov-09 8:58 AM
>> > To: Year 12 IT Applications Teachers' Mailing List
>> > Subject: [Year 12 IT Apps] ITA Exam B12e challenge
>> >
>> >
>> >
>> > Hi all.
>> >
>> > OK. It's been a week since the ITA exam and not one wise and
erudite
>> > ITA teacher across the entire state has managed to suggest a way
that
>> > B12e could be answered.
>> >
>> > In my mind that makes it a fatally flawed question, and I will
write to
>> > VCAA to have it stricken from the exam.
>> >
>> > Regards
>> > Mark
>> >
>> > --
>> > Mark Kelly
>> > Manager - Information Systems
>> > McKinnon Secondary College
>> > kel AT mckinnonsc.vic.edu.au
>> > McKinnon Rd, McKinnon 3204, Victoria, Australia
>> > Direct line / Voicemail: 8520 9085 Fax +613 9578 9253
>> >
>> > Webmaster - http://www.mckinnonsc.vic.edu.au
> <http://www.mckinnonsc.vic.edu.au/>
<http://www.mckinnonsc.vic.edu.au/>
> <http://www.mckinnonsc.vic.edu.au/>
>> > IT Lecture notes: http://vceit.com <http://vceit.com/>
> <http://vceit.com/> <http://vceit.com/>
>> > Moderator: IT Applications Mailing List
>> >
>> > Why do people mis-spell 'grammar' and mispronounce
'pronuniciation'?
>> > _______________________________________________
>>
>>
>> --
>> 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
> <http://www.mckinnonsc.vic.edu.au/>
<http://www.mckinnonsc.vic.edu.au/>
>> IT Lecture notes: http://vceit.com <http://vceit.com/>
<http://vceit.com/>
>> Moderator: IT Applications Mailing List
>>
>> RealMenDon'tNeedSpacebars.
>> _______________________________________________
>> http://www.edulists.com.au <http://www.edulists.com.au/>
> <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 <http://www.vitta.org.au/>
> <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.
>> _______________________________________________
>> http://www.edulists.com.au <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 <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
> <http://www.mckinnonsc.vic.edu.au/>
> IT Lecture notes: http://vceit.com <http://vceit.com/>
> Moderator: IT Applications Mailing List
>
> RealMenDon'tNeedSpacebars.
>
>
> ------------------------------
>
> _______________________________________________
> itapps mailing list
> itapps at edulists.com.au
> http://www.edulists.com.au/mailman/listinfo/itapps
>
>
> End of itapps Digest, Vol 57, Issue 41
> **************************************
>
> *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.
>
> _______________________________________________
> http://www.edulists.com.au <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/infotechindex.html
>
<http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html
> > - Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au <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
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.
More information about the itapps
mailing list