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

[Denny, Chris Z]

I believe the spelling of a suburb is data validation. We can use either
electronic validation (spell check) or manual validation (proof read).
One of these data validation techniques should be able to pick up a
misspelt name or suburb.

It also highlights the importance of the data acquisition step, making
sure that you do collect the correct and complete data. If the form is
being filled in by the person to whom the data refers, then complete and
explicit instructions are required to ensure that complete and correct
data is collected. Also having the fields on a manually completed form
to be exactly the same title and in exactly the same location and order
on the entry screen is important so that less data entry mistakes are
made.

Chris Denny
ICT Co-ordinator
Trafalgar High School
Phone:    56331733
Fax:        56332378
-----Original Message-----
From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Allan Barnes
Sent: Monday, 21 April 2008 9:45 AM
To: 'Year 12 IT Applications Teachers' Mailing List'
Subject: RE: [Year 12 IT Apps] IT applications 2007 exam: assessor's
report

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
 

_______________________________________________
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

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.