Flashcards
validation and verification
Cards in this deck (7)
- 1The quality of data can often be improved by the use of validation techniques. Describe two distinct types of validation technique that can be used and for each technique you describe, give an example of the error it is designed to prevent. [4]Presence – requires that a value must be entered, the details of an order are
being input, the order cannot be processed unless an order number is entered
and the routine will return an error if the box is left empty.
Format – the data must conform to a prescribed layout, a NI number consists
of 2 letters 6 digits and then a letter. If the operator tries to enter a different
combination an error is returned. (Input mask)
Range – the data must be a value that falls between 2 prescribed values, the
date of birth of a pupil must lie between 01/09/83 and 31/08/95, any date that
falls out of the range is rejected.
Data type – data must be of a specified type i.e. numerical, text, Boolean,
image, data entered for the number in stock must be numerical, if a text item is
entered it must be rejected.
Fixed value (Lookup) – data must conform to one of the values in
a predefined list i.e. for gender only m or f is allowed, entering anything else
will result in an error message,
Check digit – numerical calculation on a code number and comparing it with
the final digit, - 2(a) Validation is very important in modern data processing systems. (i) Define what is meant by the term ‘validation’. [1]Validation is a (computer) check to ensure that data is sensible / reasonable / legal
(but NOT correct or accurate). - 3(ii) Using an example, name and describe, a validation method that could be used in a student record keeping system. [3]Name
1 mark
Explanation/definition
1 mark
Example related to
school
1 mark
Range checks Data is between stated ranges
or
Between 1 and 12
Or DoB is right for that Year
Month on Date of birth
Format checks /
Input mask
Must be in the correct pre-defined
format
or
is in format e.g. 99/9999, 07/2009,
LLNN NLL
Or is sensible
Expiry date on
canteen card
Date of Birth
Postcode
OR Restricted choice of data entry Form Group
Presence checks There must be a character present
in a particular place
Data is required and must be
entered
an @ in an email
address
Postcode / Email
address
Fixed value /
drop down list /
option boxes /
cross-field check
Select only from a list Mr, Mrs, Ms, Miss, Dr,
Form Group
Length check Must have a certain number of
characters / numbers
Phone number must
have 11 digits
Data type Data must be of a specified type
i.e. numerical, text (alphanumeric)
School year
Check digit Doing some maths on a code
number to generate an extra
number on the end
Roll No
UPN - 4(b) Define the term verification. Name and describe one verification method used in online shopping systems. [3]Definition 1 mark, name of method 1 mark, description 1 mark
Verification is the use of checks to make sure data is consistent and has not been corrupted.
or
Verification is the checking that data has been copied accurately from one medium to another
(entered correctly but data might not itself be correct).
Proof reading / Read before you submit – being asked to check what you have entered is correct
before being allowed to move on, i.e. ordered the right amount of items
Double entry – having to re-input your account number, email address or the password ‘when
creating the account or changing a password’.
Description must be sensible and relevant to online shopping and can be awarded even if
name not there if it is clear which it is. - 55. Companies use validation and verification methods to reduce data entry errors in their online shopping systems. (a) Using an example, name and describe in detail one validation method used in online shopping systems. [3]Name
1 mark
Explanation/definition
1 mark
Example related to
online shopping
1 mark
Range checks Data is between stated ranges
or
Between 1 and 12
Month on Date of order
Format checks /
Input mask
Must be in the correct pre-defined
format
or
is in format e.g. 99/9999, 07/2009,
LLNN NLL
Expiry date on card
Postcode
OR Restricted choice of data entry
or
must be am or pm
Time of delivery
Presence checks There must be a character present in a
particular place
Data is required and must be entered
an @ in an email address
Postcode / Email address
Fixed value /
drop down list /
option boxes /
cross-field check
Select only from a list Mr, Mrs, Ms, Miss, Dr,
Size
Length check Must have a certain number of
characters / numbers
Credit card must have 16
numbers
Data type Data must be of a specified type i.e.
numerical, text, Boolean
Quantity required must be
a number
Check digit Doing some maths on a code number
to generate an extra number on the end
Product code
Customer account no - 63. (a) Explain the exact purpose of verification. [1]Verification is a check:
ensuring that data has been copied correctly from one medium to
another (entered correctly).
or
to make sure data is consistent and has not been corrupted.
or
to stop data entry/copying errors - 7(b) State a method of verification and illustrate your answer with an appropriate example. [2]One method and one example from
Proof Reading / read before submitting
Example
Or
Double Entry
Example
If they write ‘Read Username and type Password in twice’ only 1 mark as
they haven’t named the method
Information
- Description
- AS level ICT Flashcards on validation and verification, created by rlouise on 09/03/2015.
- Created by
- rlouise
- Views
- 3
- Rating