Incorrect data input (e.g. typo). Errors (transcription, transposition). Incorrect personal data
1 of 14
What are the consequences of incorrect data input?
Inaccurate decisions made, time wasting, loss of trust/goodwill, prosecution (DPA)
2 of 14
What is a transcription error?
An error which is caused by the data provided. Handwriting, or speech may lack clarity, and so maybe dependent upon the human operators own interpretation
3 of 14
What is a transposition error?
An error which is caused by incorrect sequence of characters, which is caused by high speed typing. It can be reduced by proof reading.
4 of 14
What is needed for batch validation?
Hash totals and control totals
5 of 14
What is a check digit?
This is used when you want to be sure that a range of numbers has been entered correctly for example a barcode or an ISBN number:
6 of 14
What is an input message?
A message that appears when a cell is selected for data entry. An input message indicates to the user the type of data that should be entered.
7 of 14
What is a validation rule?
A command that is given to a specific field to set up the validation.
8 of 14
Define validation method
A message box which appears if the data entered does not match the validation rule.
9 of 14
Name some ways that data can be processed
Calculations, producing a graph or chart, sorting, logical operations etc
10 of 14
What is a data type check?
Ensures data being entered is in the same data type is being entered
11 of 14
What is a length check?
Ensures data is of correct length
12 of 14
What is a cross-field check?
This is where the data entered into multiple fields are checked together, to check the data is correct.
13 of 14
What is a format check?
A check which is used to ensure the data being entered is of the correct format.
14 of 14
Other cards in this set
Card 2
Front
What are the consequences of incorrect data input?
Back
Inaccurate decisions made, time wasting, loss of trust/goodwill, prosecution (DPA)
Comments
No comments have yet been made