AdvertisementYour brand could be hereYour brand hereOn every Darslab page · students, parents and teachersinfo@darslab.comAsk for pricesPricesinfo@darslab.com
☰ Year plan · Computing

Keys, types and forms

Week 18 · Unit 7.4: The power of data · 3 lessons
3

Forms that collect well

Computing 7: Unit 7.4, pp. 112–149
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 formWhy it helps
Title and purposepeople know why they are giving their data
Clear instructionsfewer mistakes
Boxes the right sizea short box shows a short answer
Examplespeople write dates and numbers in the right format
Multiple-choice answersonly sensible answers; no spelling mistakes
A polite endingpeople feel respected
Worked examples
Part of the formForm AForm B
Title and purposenone‘Pottery club sign-up – so we can plan the classes’
Instructionsnone‘Write in capital letters. Tick one box.’
Date of birthone long empty linethree small boxes labelled Day, Month, Year, with an example
Which day?a blank linetick boxes: Monday, Wednesday, Saturday
Personal data askedname, age, home address, parent’s jobname, age, parent’s contact email
Endingnone‘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 tableControl 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.
QuestionNeeded for pottery club?
Child’s nameyes: to know who is coming
Ageyes: to place children in the right class
Parent’s contact emailyes: to send news
Home addressno: not used by the club
Parent’s jobno: 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 CWhat it says
TitleForm
Purpose(none)
InstructionsFill in.
Favourite subjectFavourite subject: ____________
Date of birthDate of birth: ____________
Home addressAddress: ____________
2
Choose the best control on the form for each question.
QuestionBest control?
Age group: under 10, 10–12, over 12?
Favourite colour (any colour)?
Date of birth?
Do you have a pet? (Yes/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.
4
Write the top of a form for a school garden club: a title, its purpose and two instructions.