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

Rules, forms and projects

Week 20 · 2.2 Data and databases · 3 lessons
2

Forms that collect well

Computing 8: Topic 2.2, pp. 212–229
GoalEvaluate a data collection form and improve it using five checks.
New words
data collection form · a paper or screen form that people fill in so the data can be stored in a databaseinstruction · words that tell the user how to answer a questionanswer option · a choice offered on the form, such as a tick box
Explanation

A data collection form gathers data from people, on paper or on a screen. A good form makes it easy to give correct data. To evaluate a form, run through five checks. Do the instructions make sense? Do related questions sit together in a sensible order? Does the form show the layout of an answer, so that everybody writes it alike? Is each answer box big enough? Does a choice question list every choice? An electronic form can also use the validation rules of its database, so wrong data is rejected at once. A form should ask only for the data that is needed. If it does not, people are tired of filling it in, and the data may be rushed or wrong.

Question to askWhy it matters
Do the instructions make sense?people know what to write
Is the order sensible?related questions sit together
Is the layout of an answer shown?answers look alike
Is the box big enough?answers are not cut short
Is every choice listed?nobody is left without a choice
Worked examples
Question on the formAnswer space
Namea very short line
Item?a short line
Wherea short line
Datea short line
Colour or size or what it looks likea very small box
A poor lost-property form. It has no instructions, the questions are vague, no date format is given, and the space for the description is tiny. Different people would write the same answer in different ways.
Question on the formHow to answer
1 Your first namewrite it in capitals, one letter in each box
2 What did you lose?tick one: bag / coat / book / other
3 Where did you lose it?write the room or place
4 Date it was lostwrite it as DD/MM/YYYY
5 Describe itwrite up to three lines
An improved form. It gives instructions, an answer option for the item, a date format, and enough space. The questions are in a logical order, from who, to what, to where, to when, to a description.
QuestionPoor formImproved form
Instructions make sense?noyes
Sensible order?noyes
Layout of answer shown?noyes, for the date
Boxes big enough?noyes
Every choice listed?not applicableyes, with other
Evaluating the first form against the five checks. The improved form can then be tested by a few invented users.
Class activity

Form makeover (no computer). Draw a poor form for a school lunch survey: vague questions, no date format, tiny space. Swap with a partner. Your partner evaluates it with the five questions, writes the answers in a table, and then draws an improved form. Include a tick-box question with an “other” option, and a date format such as DD/MM/YYYY. Fill in the improved form with invented answers from three classmates, and check whether the answers are all in the same format. If you have a computer or tablet, ask an adult to help you make your improved form in a word processor.

Practice
1
A form asks “Are you in Year 7, 8 or 9?” with only two tick boxes, for Year 7 and Year 8. Which of the five checks does it fail, and how can it be fixed?
Are you in Year 7, 8 or 9?Tick boxes
Year 7 / Year 8
2
A form asks for a birth date with a box that says only “Date”. Rewrite the instruction so that every user answers in the same way.
3
Put these questions in a logical order for a bike-repair booking form: (a) day you can come; (b) your first name; (c) what is wrong with the bike; (d) type of bike.
4
Why is it better for an electronic form to use the same validation rules as the database?