[Year 12 IT Apps] Puts down the rifle...

[Mark KELLY]

Try forcing the numbers to be text (put an apostophe in front of the
digits) and try it again.  Excel has to ask you what you really want to
sort as text or as thinks that "look like numbers."


On 15 November 2011 09:37, Esko Lossi <elossi at chairo.vic.edu.au> wrote:

> ** ** ** ** ** ** ** **
>
> When I do question 13 (Section A) on a spreadsheet, the answer the
> spreadsheet gives is A.****
>
> ** **
>
> Regards****
>
> *Esko Lossi*
>
> *ICT/Reporting Coordinator*
>
> *Chairo Christian School, Drouin Campus*
>
> *Contact: 56254600 ext 101 *
>
> *elossi at chairo.vic.edu.au*****
>
>  **
>
> *Disclaimer: Whilst every attempt has been made to ensure that material
> contained in this email is free from computer viruses or other defects, the
> attached files are provided, and may only be used, on the basis that the
> user assumes all responsibility for use of the material transmitted. This
> email is intended only for the use of the individual or entity named above
> and may contain information that is confidential and privileged. If you are
> not the intended recipient, please note that any dissemination,
> distribution or copying of this email is strictly prohibited. If you have
> received this email in error, please notify us immediately by return email
> or telephone 03 5625 4600 and destroy the original message. The contents of
> this message are provided without responsibility in law for their accuracy
> or otherwise and without assumption of a duty of care by the Warragul
> District Parent Controlled Christian School Association Incorporated
> trading as Chairo Christian School.***
>   ------------------------------
>
> *From:* itapps-bounces at edulists.com.au [mailto:
> itapps-bounces at edulists.com.au] *On Behalf Of *Ken Tonkin
> *Sent:* Tuesday, November 15, 2011 9:29 AM
>
> *To:* Year 12 IT Applications Teachers' Mailing List
> *Subject:* Re: [Year 12 IT Apps] Puts down the rifle...
> ****
>
>  ** **
>
> David, I agree with most of your answers for the MC questions, except no.9
> I think the answer should be 9B as tactical decisions are more short term
> and specific.****
>
> Ken Tonkin****
>
> ** **
>
> *From:* itapps-bounces at edulists.com.au [mailto:
> itapps-bounces at edulists.com.au] *On Behalf Of *Howard, David
> *Sent:* Tuesday, 15 November 2011 8:31 AM
> *To:* Year 12 IT Applications Teachers' Mailing List
> *Subject:* Re: [Year 12 IT Apps] Puts down the rifle...****
>
> ** **
>
> I’m with Mark on this one. Definitely A.****
>
> ** **
>
> Validation can ensure that I input a date of birth for example that is
> reasonable, say 12/08/1981 but is it accurate, no!****
>
> ** **
>
> ** **
>
> Here are my multiple choice answers.****
>
> ** **
>
> 1 B****
>
> 2 A****
>
> 3 D****
>
> 4 D****
>
> 5 A****
>
> 6 A****
>
> 7 B****
>
> 8 A****
>
> 9 A – not so confident on that one****
>
> 10 A****
>
> 11 C ****
>
> 12 C****
>
> 13 B ****
>
> 14 B****
>
> 15 D****
>
> 16 C****
>
> 17 B****
>
> 18 B****
>
> 19 C****
>
> 20 C****
>
> ** **
>
> ** **
>
> ** **
>
> *David Howard*
> Head of IT & Learning Technologies
>
> [image: Description: https://www.stmichaels.vic.edu.au/layout/siglogo.jpg]
>
>
> 25 Chapel Street, St Kilda VIC 3182 Australia
>
> *Phone *+61 3 8530 3272
> *Fax *+61 3 9510 9392
> *Email *dhoward at stmichaels.vic.edu.au
> *Website *www.stmichaels.vic.edu.au
> *CRICOS Provider* 00345G
> [image: Description: https://www.stmichaels.vic.edu.au/layout/siglogo2.jpg]
>
>
> [image: Description: https://www.stmichaels.vic.edu.au/layout/siglogo3.jpg]
> Please consider the environment before printing this email.****
>
> ** **
>
> ** **
>
> ** **
>
> *From:* itapps-bounces at edulists.com.au [mailto:
> itapps-bounces at edulists.com.au] *On Behalf Of *Mark Scott
> *Sent:* Tuesday, 15 November 2011 8:14 AM
> *To:* Year 12 IT Applications Teachers' Mailing List
> *Subject:* Re: [Year 12 IT Apps] Puts down the rifle...****
>
> ** **
>
> ** **
>
> Validation deals with data entry.****
>
> ** **
>
> Options B, C and D are all testing to ensure data manipulation is
> correct/accurate etc.****
>
> ** **
>
> Only option A clearly deals with data entry (i.e. the most correct option)
> ****
>
> ** **
>
> thanks****
>
> Mark Scott****
>
> Luther College****
>
> ** **
>
> "The busier you get, the slower you walk" anon****
>
> ** **
>
> *From:* itapps-bounces at edulists.com.au [mailto:
> itapps-bounces at edulists.com.au] *On Behalf Of *Michael Torsello (Mr)
> *Sent:* Tuesday, 15 November 2011 8:03 AM
> *To:* Year 12 IT Applications Teachers' Mailing List
> *Subject:* Re: [Year 12 IT Apps] Puts down the rifle...****
>
> ** **
>
> Dear wiser colleagues****
>
> Can someone help me with MC question 8?****
>
> ** **
>
> An effective validation technique is evident when … all answers seem to
> support the presence of an effective validation technique.****
>
> ** **
>
> A – at first glance the answer but is reasonableness the best evidence of
> validation?****
>
> B- an accurate report suggests accurate input data, doesn’t it?****
>
> C- least likely but again “reasonably”? What does that mean? If data can
> be sorted is it valid?****
>
> D –calculated files gives correct answers! Is this evidence of GIGO – not
> garbage in, garbage out, but good in, good out?****
>
> ** **
>
> I’m confused!****
>
>
> --------------------------------------------------------------------------------------------------------------------
> ****
>
> With Thanks****
>
> Michael Torsello****
>
> Director of Computing****
>
> St Margaret's School, Berwick****
>
> Berwick Grammar School, Officer****
>
> Ph: (03) 9703 8111****
>
> ** **
>
> P Save paper and trees. Do you need to print this email?****
>
> ** **
>
> *From:* itapps-bounces at edulists.com.au
> [mailto:itapps-bounces at edulists.com.au] *On Behalf Of *Ben Hines
> *Sent:* Monday, 14 November 2011 4:32 PM
> *To:* Year 12 IT Applications Teachers' Mailing List
> *Subject:* Re: [Year 12 IT Apps] Puts down the rifle...****
>
> ** **
>
> Yeah I just found that, thanks****
>
> ** **
>
> *From:* itapps-bounces at edulists.com.au
> [mailto:itapps-bounces at edulists.com.au] *On Behalf Of *Howard, David
> *Sent:* Monday, 14 November 2011 3:39 PM
> *To:* Year 12 IT Applications Teachers' Mailing List
> *Subject:* Re: [Year 12 IT Apps] Puts down the rifle...****
>
> ** **
>
> A – Scope see page 17 of the study design.****
>
> ** **
>
> *From:* itapps-bounces at edulists.com.au
> [mailto:itapps-bounces at edulists.com.au] *On Behalf Of *Ben Hines
> *Sent:* Monday, 14 November 2011 2:37 PM
> *To:* Year 12 IT Applications Teachers' Mailing List
> *Subject:* Re: [Year 12 IT Apps] Puts down the rifle...****
>
> ** **
>
> I cannot believe that number question. No one would normally type numbers
> in as numerals, set the data type to text and then order from A -> Z.****
>
> ** **
>
> I doubt anyone would get the answer to that unless they have accidentally
> done it in the past. ****
>
> ** **
>
> Because you have entered them as text, the sort will only look at the left
> most number to order them (just like with normal ones).****
>
> ** **
>
> Answer according to Access is B….****
>
> ** **
>
> Question 5 in the Multiple Choice? What’s the consensus on that one?****
>
> ** **
>
> Ta****
>
> ** **
>
> ** **
>
> [image: Description: Description: ben_sig]****
>
> *Mr Ben Hines*
>
> ** **
>
> *VCE Maths/ICT Teacher*
>
> *Senior School Campus - Christian College Geelong*
>
> ((03) 52411577 (ext. 212)****
>
> ** **
>
> ** **
>
> ** **
>
> *From:* itapps-bounces at edulists.com.au
> [mailto:itapps-bounces at edulists.com.au] *On Behalf Of *Howard, David
> *Sent:* Monday, 14 November 2011 2:15 PM
> *To:* Year 12 IT Applications Teachers' Mailing List
> *Subject:* Re: [Year 12 IT Apps] Puts down the rifle...****
>
> ** **
>
> I don’t have the paper in front of me, but after a quick chat to my
> students, plain to see that they had differing opinions on the sorting of
> numbers as text question in the multiple choice.****
>
> ** **
>
> I’m not marking this year by the way.****
>
> ** **
>
> *From:* itapps-bounces at edulists.com.au
> [mailto:itapps-bounces at edulists.com.au] *On Behalf Of *Mark KELLY
> *Sent:* Monday, 14 November 2011 1:52 PM
> *To:* Year 12 IT Applications Teachers' Mailing List
> *Subject:* [Year 12 IT Apps] Puts down the rifle...****
>
> ** **
>
> I'm reading the paper now.
>
> Section A looks pretty free of rabies.
>
> I have put the gun down after reading the normalisation question...  Thank
> Dog sanity prevailed on that one!
>
> Damn that ERD question - three marks and they had to draw an entire
> diagram from scratch!  Grrr.
>
> The 8 mark question appeared, as we expected.  And it was approachable.
>
> Overall, I think I might give the dog a bone.
>
>
> --
> Mark Kelly
> Manager of ICT, Reporting, IT Learning Area
> McKinnon Secondary College
> McKinnon Rd McKinnon 3204, Victoria, Australia
> Direct line / Voicemail: +613 8520 9085, Fax +613 9578 9253
> kel at mckinnonsc.vic.edu.au
> VCE IT Lecture Notes: http://vceit.com
> Moderator: IT Applications Edulist <http://www.edulists.com.au/>
>
> Want a good time? Call 0112358. Ask for Mr Fibonacci.****
>
> ** **
>  ------------------------------
>
> Message protected by MailGuard: e-mail anti-virus, anti-spam and content
> filtering.
> http://www.mailguard.com.au
>
> Report this message as spam<https://login.mailguard.com.au/report/1DwtSCvVLg/3l3gMtKTlFjw3U6WDhW9WD/0.002>
>  ****
>
>
> This e-mail is intended for the use of the named individual or entity and
> may contain confidential and privileged information. Any dissemination,
> distribution or copying by anyone other than the intended recipient of this
> e-mail is strictly prohibited. If this e-mail has been received in error,
> then please notify Christian College or the author of this email
> immediately and destroy the original message. We have made every attempt to
> ensure this e-mail message is free from computer viruses however the
> attached files are provided on the basis that the user assumes all
> responsibility for use of the material transmitted. Views, opinions, etc.
> expressed reflect those of the author and not Christian College nor its
> associated companies and campuses which includes Eden Quality Services Pty
> Ltd.****
>  ------------------------------
>
> Message protected by MailGuard: e-mail anti-virus, anti-spam and content
> filtering.
> http://www.mailguard.com.au
>
>  ****
>
> ** **
>  ------------------------------
>
> Message protected by MailGuard: e-mail anti-virus, anti-spam and content
> filtering.
> http://www.mailguard.com.au
>
> Report this message as spam<https://login.mailguard.com.au/report/1DwvnwjLRM/qPkWQK7xjKwKxXL4nIV62/0.002>
>  ****
>
>
> This e-mail is intended for the use of the named individual or entity and
> may contain confidential and privileged information. Any dissemination,
> distribution or copying by anyone other than the intended recipient of this
> e-mail is strictly prohibited. If this e-mail has been received in error,
> then please notify Christian College or the author of this email
> immediately and destroy the original message. We have made every attempt to
> ensure this e-mail message is free from computer viruses however the
> attached files are provided on the basis that the user assumes all
> responsibility for use of the material transmitted. Views, opinions, etc.
> expressed reflect those of the author and not Christian College nor its
> associated companies and campuses which includes Eden Quality Services Pty
> Ltd.****
>  ------------------------------
>
> Message protected by MailGuard: e-mail anti-virus, anti-spam and content
> filtering.
> http://www.mailguard.com.au
>
>  ****
>
> ** **
>  ------------------------------
>
> Disclaimer
> This message, including any attachments, is provided without
> responsibility in law for its accuracy or otherwise and without assumption
> of a duty of care by the School - Assumption College Kilmore. Whilst every
> attempt has been made to ensure material in this e-mail message is free
> from computer viruses or other defects, the attached files are provided,
> and may only be used, on the basis that the user assumes all responsibility
> for use of the material transmitted. Assumption College Kilmore accepts no
> liability for any direct or indirect damage or loss resulting from the use
> of any attachments to this e-mail.
> This e-mail is private and confidential. This e-mail is intended for the
> use of the named individual or entity and may contain confidential and
> privileged information. Any dissemination, distribution or copying by
> anyone other than the intended recipient of this e-mail is strictly
> prohibited. If this e-mail has been received in error, then please notify
> the sender immediately and destroy the original message. The views
> expressed in this e-mail are those of the author, and do not represent
> those of Assumption College Kilmore unless this is clearly indicated.****
>
> _______________________________________________
> 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 of ICT, Reporting, IT Learning Area
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: +613 8520 9085, Fax +613 9578 9253
kel at mckinnonsc.vic.edu.au
VCE IT Lecture Notes: http://vceit.com
Moderator: IT Applications Edulist <http://www.edulists.com.au/>

Want a good time? Call 0112358. Ask for Mr Fibonacci.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20111115/92e0fc3b/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 4785 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20111115/92e0fc3b/attachment-0003.jpe 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 2206 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20111115/92e0fc3b/attachment-0001.gif 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 1960 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20111115/92e0fc3b/attachment-0004.jpe 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 21466 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20111115/92e0fc3b/attachment-0005.jpe