[Year 12 IT Apps] IT applications 2007 exam: assessor's report

[Allan Barnes]

I would suggest that examples of mis-spelling are actually cases of data
integrity rather than data validation. Data can be regarded as valid if it
is of the correct data type, data length, etc., but if it is in the correct
format but mis-spelt, then it would be an issue of data integrity, I would
have thought.

It is very hard to validate spelling of names, for example - if it is
entered as text we can validate for that, but how do we know if 'Tim' is
valid data or not? Unless we enter every name into the program and then
check the bank of names against the input box, it can't be validated by the
program, but it can be manually validated by the user. Similar to using
spell checker in Word - if the word is in the dictionary it can be checked,
but if the word doesn't exist in the dictionary then Word won't pick up the
mis-spelling, all it will point out is that it doesn't exist. 



Kind regards
 
Allan Barnes, CEO
Australian Institute of Education and Training
P.O. Box 171
Brunswick West 3055
Ph: (03) 9387 2051
FAX: (03) 9387 3470
Mobile: 0409 428 221
 
-----Original Message-----
From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au]
On Behalf Of Timmer-Arends
Sent: Sunday, 20 April 2008 4:50 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] IT applications 2007 exam: assessor's report

Hello Mark

>Checking the spelling of a suburb is surely data validation?
interesting question.

if a person types Balwin instead of Balwyn does that make the data 
incorrect? If there is such a place as Balwin I guess at the very least 
their entry is misleading, and therefore having some sort of scan through a 
list of existing place names would be a useful validation technique. But is 
it the spelling that's being validated or the existence of a place with that

spelling?

...and anyway, does an old CRT monitor falling in the forest make a sound if

there's no one there to hear it....????

Two weeks in and mania is already starting to hit

Regards
Robert T-A 

_______________________________________________
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
-- 
Message  protected by MailGuard: e-mail anti-virus, anti-spam and content
filtering.
http://www.mailguard.com.au/mg

Click here to report this message as spam:
https://login.mailguard.com.au/report/1uScV5X6Jk/7MnILHZT5WnE86AMpqINzp/0


No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.524 / Virus Database: 269.23.2/1388 - Release Date: 20/04/2008
3:01 PM
 

No virus found in this outgoing message.
Checked by AVG. 
Version: 7.5.524 / Virus Database: 269.23.2/1388 - Release Date: 20/04/2008
3:01 PM