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

Mon Nov 14 16:02:26 EST 2011

Am marking this year - but have not yet seen the paper as I am not teaching at the moment. M/C section so we won't be marking it anyway :-)

There are numbers that we need to treat as text. Eg phone numbers - else the leading zero is not stored. So once that is done, you do need to sort on an A ->Z basis.

Look forward to seeing the actual question when I get access to a copy of the paper online.

Robert Hind (Semi-retired) OOF, GOM (Thanks Kent!)
Ashwood and Traralgon
robert at yinnar.com

  ----- Original Message ----- 
  From: Ben Hines 
  To: Year 12 IT Applications Teachers' Mailing List 
  Sent: Monday, November 14, 2011 2:36 PM
  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

  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

  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  

  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

------------------------------------------------------------------------------

  _______________________________________________
  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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20111114/5f590a8e/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 2035 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20111114/5f590a8e/attachment.png 