GoalSay what makes a data capture form user-friendly, and judge a form against a checklist.
New words
data capture form · a form designed to collect data for one job, so that it can be stored in a databaseuser-friendly · easy to understand and usemultiple-choice format · a question that gives a list of answers to choose fromevaluate · to judge how good something is, using clear points to check
Explanation
Data has to be collected before it can go into a database. A data capture form does this job. A good form is user-friendly, so that people give the right data in the right format. The field headings of the database table should match the questions on the form. This makes it easy to type the answers into the right fields. Boxes should be the right size, examples help people, and multiple-choice answers stop spelling mistakes. A form should also ask only for the data that is really needed. To evaluate a form, check it against a list of good features, one point at a time.
Feature of a good form
Why it helps
Title and purpose
people know why they are giving their data
Clear instructions
fewer mistakes
Boxes the right size
a short box shows a short answer
Examples
people write dates and numbers in the right format
Multiple-choice answers
only sensible answers; no spelling mistakes
A polite ending
people feel respected
Worked examples
Part of the form
Form A
Form B
Title and purpose
none
‘Pottery club sign-up – so we can plan the classes’
Instructions
none
‘Write in capital letters. Tick one box.’
Date of birth
one long empty line
three small boxes labelled Day, Month, Year, with an example
Which day?
a blank line
tick boxes: Monday, Wednesday, Saturday
Personal data asked
name, age, home address, parent’s job
name, age, parent’s contact email
Ending
none
‘Thank you for signing up!’
Two forms collect data for the same pottery club. Form B is much more user-friendly. Form A has no title, no instructions and no example of how to write a date, so the answers will arrive in many different formats.
Field in the table
Control on the form
Name (Text, 20)
a box about 20 characters wide
DateOfBirth (Date/Time)
three boxes labelled Day, Month, Year, with an example
Group (Red, Blue or Green)
circle one: Red / Blue / Green
Allergic (Yes/No)
two tick boxes: Yes No
Each question on a form fits a field in the table. A field with a data type of Yes/No becomes two tick boxes, and a date becomes labelled small boxes with an example. Choosing the right control for each field makes the data cleaner.
Question
Needed for pottery club?
Child’s name
yes: to know who is coming
Age
yes: to place children in the right class
Parent’s contact email
yes: to send news
Home address
no: not used by the club
Parent’s job
no: not used by the club
A form should ask only for the data that the club really needs. The more personal data you collect, the more must be protected, and people must agree to give it. A pottery club needs a way to contact a parent, but it does not need a home address or a parent’s job.
Class activity
Form detectives (no computer). Collect three real paper forms from home or school, such as a club leaflet, a library card form or a party reply slip. Use the six points in the table above as a checklist. Give each form one tick for each good feature it has, and write one improvement for each. Discuss with a partner: which form would you most like to fill in, and why? Remember that real forms may contain personal data, so only look at blank ones.
Practice
1
Evaluate Form C. List three problems and say how to fix each one.
Part of Form C
What it says
Title
Form
Purpose
(none)
Instructions
Fill in.
Favourite subject
Favourite subject: ____________
Date of birth
Date of birth: ____________
Home address
Address: ____________
There is no title or purpose, so add a title that says what the form is for. The instructions are not helpful, so write clear instructions such as ‘Write in capital letters’. The subject and date questions have no examples or options, so give a list of subjects to tick and show the date format with an example such as 05/09/2014. (Asking for the home address is also not needed for a survey.)
2
Choose the best control on the form for each question.
Question
Best control?
Age group: under 10, 10–12, over 12
?
Favourite colour (any colour)
?
Date of birth
?
Do you have a pet? (Yes/No)
?
Age group: tick boxes (multiple choice). Favourite colour: a text box. Date of birth: small boxes with an example. Do you have a pet? Two tick boxes, Yes and No.
3
A form for a lunch survey asks for home address, phone number, a photo and favourite food. Which questions are not needed? Give a reason.
Home address, phone number and photo are not needed, because the survey only has to know the favourite food. Collecting less data is safer, because there is less to protect, and people must agree to give personal data.
4
Write the top of a form for a school garden club: a title, its purpose and two instructions.
Model answer: Title: ‘Garden Club sign-up’. Purpose: ‘We use this form to plan the club days.’ Instructions: ‘Write in capital letters. Tick one box for the day you prefer.’ Any clear title, purpose and two instructions are correct.