Validation rules on an online survey form

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. A survey asks 'How many hours did you sleep last night?' and students type anything. Which form setting blocks 'banana' as an answer?

A A number response validation rule

B Making the question title longer

2. You must have every respondent's year level to analyse results. What should you do to the question?

A Leave it optional and hope people answer

B Mark it as required

3. Which number range rule is best for 'How many hours of sleep did you get last night?'

A Number greater than 100

B Number between 0 and 24

4. Which question format stops spelling variations like 'Yr 9', 'year nine' and '9th'?

A Multiple choice with Year 9 and Year 10 options

B A short answer text box

5. True or false: response validation on a form blocks bad data at collection, before it reaches your spreadsheet.

A True

B False

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1Required: ON		ARequired: ON
2Number between 1 and 10		BA free text answer creates spelling variations of the same choice. It should be a multiple choice or drop-down question.
3Use multiple choice instead of free text so every answer is spelled the same way and only listed options can be chosen		CThe respondent cannot submit the form until this question has an answer, so no blanks are collected.
4Make sure a respondent cannot skip a question that you need an answer to		DOnly numbers from 1 to 10 are accepted, so an answer such as 99 or -4 is blocked.
5Hours of sleep (short answer, no rules): 'lots', '-5', '200'		EFree text with no validation lets in words and impossible numbers. It should use a number rule, such as a number between 0 and 24.
6Favourite subject (short answer): Maths, maths, Math, mathz		FQuestion type: Multiple choice (Year 9, Year 10)

Definitions

response validation

Fill in the Blanks

Complete each line of code by filling in the missing parts.

Question: What is your age? Required: ____

Question: Rate the canteen (1-5) Type: Number Rule: _______ 1 and 5

Question: Favourite subject? Type: _______________ Options: Maths, English, Science

Question: Hours of sleep Type: Number Rule: between 0 and __

Question: How old are you? Type: ______ Rule: between 10 and 20

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A question "Age in years"

B type = number

C min = 12

D max = 8

Question 2

A question "Year level"

B required = true

C type = free text

D options = 9, 10

Question 3

A type = text

B question "Hours of sleep"

C min = 0

D max = 24

Question 4

A question "Consent to take part"

B type = multiple choice

C required = false

D options = Yes, No

Question 5

A options = Yes No Unsure

B question "Do you use a VPN?"

C type = dropdown

D required = true

Answer Key

Validation rules on an online survey form

Section A: Quick Questions

A — A number response validation rule

B — Mark it as required

B — Number between 0 and 24

A — Multiple choice with Year 9 and Year 10 options

A — True

Section B: Match the Pairs

Required: ON → The respondent cannot submit the form until this question has an answer, so no blanks are collected.

Number between 1 and 10 → Only numbers from 1 to 10 are accepted, so an answer such as 99 or -4 is blocked.

Use multiple choice instead of free text so every answer is spelled the same way and only listed options can be chosen → Question type: Multiple choice (Year 9, Year 10)

Make sure a respondent cannot skip a question that you need an answer to → Required: ON

Hours of sleep (short answer, no rules): 'lots', '-5', '200' → Free text with no validation lets in words and impossible numbers. It should use a number rule, such as a number between 0 and 24.

Favourite subject (short answer): Maths, maths, Math, mathz → A free text answer creates spelling variations of the same choice. It should be a multiple choice or drop-down question.

Section C: Definitions

response validation — A rule set on an online form question, such as required, a number range or multiple choice instead of free text, that blocks bad answers so only valid data is collected.

Section D: Fill in the Blanks

Question: What is your age?
Required: true

Question: Rate the canteen (1-5)
Type: Number
Rule: between 1 and 5

Question: Favourite subject?
Type: Multiple choice
Options: Maths, English, Science

Question: Hours of sleep
Type: Number
Rule: between 0 and 24

Question: How old are you?
Type: Number
Rule: between 10 and 20

Section E: Spot the Error

D — The maximum (8) is lower than the minimum (12), so no answer could ever pass the number range rule. It should be max = 18.

C — Free text lets people type typos or odd answers such as 'nine'. A drop-down list limits answers to the listed choices, so it should be type = dropdown.

A — A number range rule (min and max) only works on a number question. With type = text, any words could be entered. It should be type = number.

C — If the question is not required, people can skip it and leave the consent answer blank. It should be required = true so a response is always collected.

A — Without commas the form sees one single choice, 'Yes No Unsure'. The options must be separated by commas: options = Yes, No, Unsure.