1
Q
What types of validation are there?
A
- presence
- range (checks data is in range of letters and numbers)
- format (checks data follows correct pattern)
- look up list (makes sure data is on a list of acceptable values)
- cross field check- (makes sure two fields are always entered correctly each time)
- check digit (makes sure long numbers are entered correctly)
2
Q
Describe verification
A
It is performed to ensure that the data entered exactly matches the original source
3
Q
Describe the 2 types of verification
A
Double entry: entering the data twice and comparing the 2 copies
Proof reading: involves someone checking the data entered against the original document
4
Q
Describe the main 2 types of data capture forms
A
- computer-based: can have built in validation, and can be quicker than writing out data and entering it manually
- paper-based: can be filled in anywhere but errors can occur if it is written wrong
5
Q
Describe validation
A
- a method of checking data to reduce the number of errors in the data entered
- tests the data against the validation rule and gives the user an error message if it fails the test
6
Q
What needs to be thought about when designing a computer-based data-entry form?
A
- colour boxes to make it obvious
- varied size of textboxes
- use features with limited choices like drop-down boxes
- emails twice for verification
- order you want the data to be entered
7
Q
What needs to be thought about when designing a user interface?
A
- what input&output devices will be used
- visually impaired people- voice output?
- colour scheme- clear and suitable
- logical navigation
- minimum number of mouse clicks
8
Q
What to think about when designing a spreadsheet?
A
- name and function of each worksheet you will use
- what cells will be used
- how they will be formatted
- formulae that will be used
- which cells&worksheets will be protected
- what macros will be needed and the function of each one
- how the worksheets will be linked
9
Q
What to consider when designing a database
A
- what fields will be needed
- what tables need to be linked
- formats&validation for each field
- what queries will be needed
- what forms&reports
- how the user will navigate
10
Q
What to consider when designing a webpage/presentation
A
- file names and size
- file structure
- any effects
- transitions
- details of sound effects
- details of animated objects
11
Q
How should outputs be designed?
A
- decide what training users will need
- make sure the client is happy
- screen or paper based
