Fw: [Year 12 IT Apps] Qu A 15

[Robert Hind]

Sdo the old foot in mouth problvem - and why am I having typing problems? Because I triesd to c ut the end off my finger last nigfht (cooking is so dangerous) and am typing these emails with a huge bloosdy lump of bandaid on the end of my left index finger.

Sorry I should have said

"So validation does not ensure that inaccurate data does not get into a system, it only tries to do so."

Robert Hind (Semi-retired)
Ex Traralgon and Ashwood

----- Original Message ----- 
From: Robert Hind 
To: Year 12 IT Applications Teachers' Mailing List 
Sent: Wednesday, November 14, 2007 3:54 PM
Subject: Re: [Year 12 IT Apps] Qu A 15


Now we have to add "claculations" to "refleact" as items that passed through a data validation system. So validation does not ensure that inaccurate data gets into a system, it only tries to do so.

J
Robert Hind (Semi-retired)
Ex Traralgon and Ashwood


----- Original Message ----- 
From: "Mark Scott" <msc at luther.vic.edu.au>
To: "Year 12 IT Applications Teachers' Mailing List" <itapps at edulists.com.au>
Sent: Wednesday, November 14, 2007 1:06 PM
Subject: RE: [Year 12 IT Apps] Qu A 15



It prevents them being used as a number in claculations etc. 


Mark Scott
Luther college 

-----Original Message-----
From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Maggie Iaquinto
Sent: Wednesday, 14 November 2007 12:47 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: RE: [Year 12 IT Apps] Qu A 15

When there are soft brackets and spaces, it must be text since text is
alphanumeric. 

Why no numbers for postcodes? 4 chars, limited range, all number.

-----Original Message-----
From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Keith Richardson
Sent: Wednesday, 14 November 2007 12:41 PM
To: List ITA
Subject: [Year 12 IT Apps] Qu A 15

I have a beef about this topic.
Some years ago I attended an advanced Access three day course to get my
head around this database program.
We were told in no uncertain way, that one should NOT use number as a
data type for phone numbers or postcodes etc. In fact it should only be
used when you intend doing mathematical calculations with it's contained
data further down the track.
Therefore, I choose A for Qu 15 (Part A), but in doing so remember one
or more of the VITTA practice ITA exams that indicated it should be
number.
What do others think?
Keith
Keith Richardson
ITA List Moderator
Head of ICT, Leibler Yavneh College
Elsternwick
Ph: 03.9528.4911
k.richardson at yavneh.vic.edu.au

_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe IT
Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.auvce/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.auvce/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.auvce/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.auvce/studies/infotech/infotechindex.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/20071114/a7760db1/attachment.html