1.3 - Design

Question 1

What types of validation are there?

Answer 1

• 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)

Question 2

Describe verification

Answer 2

It is performed to ensure that the data entered exactly matches the original source

Question 3

Describe the 2 types of verification

Answer 3

Double entry: entering the data twice and comparing the 2 copies

Proof reading: involves someone checking the data entered against the original document

Question 4

Describe the main 2 types of data capture forms

Answer 4

• 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

Question 5

Describe validation

Answer 5

• 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

Question 6

What needs to be thought about when designing a computer-based data-entry form?

Answer 6

• 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

Question 7

What needs to be thought about when designing a user interface?

Answer 7

• what input&output devices will be used
• visually impaired people- voice output?
• colour scheme- clear and suitable
• logical navigation
• minimum number of mouse clicks

Question 8

What to think about when designing a spreadsheet?

Answer 8

• 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

Question 9

What to consider when designing a database

Answer 9

• 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

Question 10

What to consider when designing a webpage/presentation

Answer 10

• file names and size
• file structure
• any effects
• transitions
• details of sound effects
• details of animated objects

Question 11

How should outputs be designed?

Answer 11

• decide what training users will need
• make sure the client is happy
• screen or paper based