11.2 Validation and Verification
| Specification Content/Learning Outcomes |
Validation and verification looks at sources of error in data processing and methods of reducing these errors.
|
Resources - Validation and Verification
| Key to resources: |
|
PowerPoint presentation | |
Word file | |
Acrobat file |
|
Internet resource | Video |
| Resource |
Type |
Size |
Notes |
| Verification |
|
n/a | Alcester Grammar School links covering this topic |
| Data Validation |
|
354KB | PowerPoint presentation from the KJS |
| Review of Data Capture |
|
261KB | PowerPoint presentation from Chris Brown. |
| IS Controls |
|
n/a | Good Internet source. Scroll down to the part that begins "Applications Controls" |
| Verification & Validation |
|
n/a | Greenwood School's 'ICT2 Textbook' |
Add/suggest new resources - Click here to suggest new resources relevant to this topic. Do NOT add attachments e.g. Word documents to your suggestions as these will be discarded.
Reading - Validation
and Verification
Texts other than Heathcote can be found in the ICT section of the Library
Resource Centre.
| Key to reading: |  |
Heathcote - Core Text | |
Internet resource |  |
Other book |
 |
Handout/worksheet |
| Reading |
Type |
Size |
Notes |
| Verification & Validation |
|
n/a | Heathcote Ch.16 Pages 85 - 90 |
| Error Checking |
|
n/a | Doyle Ch.6 Pages 91 - 93 |
| Verification & Validation |
|
n/a | Mott & Leeming Ch.8 Pages 66 - 69 |
| Verification & Validation OCR |
|
73KB | Handout from OCR ICT. |
| Verification & Validation |
|
n/a | Steve Longley's excellent Flash notes. |
Practice questions/homework - Validation and Verification
| Key to questions: |  |
Past exam question |  |
Heathcote question |
|
Other question |
 |
FatMax assignment |  |
Smokin' Dog assignment | |||
| Reference |
Type |
Size |
Question | ||||||||||||||||||||||||||||||
| 1. Spring 2002 ICT2 Question 6 |
|
n/a | 1. A company stores its staff
records in a computer file. Examples of records from the file are shown
below.
(a). The records in this file have been input with the validation checking turned off. Referring to the records above, state four problems that have occurred. (4) (b). Name and describe three different
validation checks that would have prevented these problems (6) |
||||||||||||||||||||||||||||||
| 2. Summer 2001 ICT2 Question 6 |
|
n/a | Explain the difference between
the terms verification and validation when applied to data.
Illustrate your answer with an example of each. (4 marks) |
||||||||||||||||||||||||||||||
| 3. Spring 2001 ICT2 Question 7 |
|
n/a | A video and games rental shop
uses a database package to record membership details of customers who wish
to borrow videos or games. The following details must be entered for each
new member; full name, address, postcode and date of birth.
(a) Name and describe a validation check that could be used when data is first entered into the following fields for a new member. Your validation check must be different in each case.
(b) The database package automatically
generates a membership number. Explain why this is required. (2) |
||||||||||||||||||||||||||||||
| 4. NEAB 1996 IT02 Question 5 |
|
n/a | A school uses an information
system to store details of students' examination entries and results. As
part of this system a program is used to check the validity of data such as
candidate number, candidate names and the subjects entered. (a) Suggest three possible validation tests, which might be carried out on this data. (3) (b) Explain, with an example, why data
which is found to be valid by this program may still need to be verified.
(2) |
||||||||||||||||||||||||||||||
| 5. AEB 1997 Computing Question 2 |
|
n/a | Name and describe two
validation checks that could be used when a product code number is input. (4 marks) |
| AS Modules | ICT2 | Links | Top | Home | FatMax1 |
Copyright/Disclaimer - I think everyone whose work appears on this site has been properly credited. If not, get in touch and I'll make the necessary amendments. FatMax2 is not an official AQA site (in case you hadn't guessed!) For official AQA documents the only 'reliable' source is the Official AQA website FatMax 2002/2003.
