[Year 12 IT Apps] RE: answer to ITA Exam Que B12e

Mark Kelly kel at mckinnonsc.vic.edu.au
Wed Nov 18 08:03:10 EST 2009


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/4ecd6ffc/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.


More information about the itapps mailing list