Spreadsheet Validation practical

A new experimental trial is being carried out with a new drug that treats arthritis. Half of the patients will be treated with the drug and half with a placebo.

Data will be recorded as follows:

• Patients first & last name (text)

• ID number(Alphanumeric)

• Placebo (Y/N)

• Movement score(Physician assessed on scale 1-5)

• Pain score (patient assessed on scale 0-5)

• Inflammation (None/Low/Medium/High)

Task

Create a new spreadsheet with the following columns:

Firstname

Lastname

IDno

Placebo

Movescore

Painscore

Inflammation

Use the data validation feature to ensure that all fields are filled in with the correct range/type of data.

• Is it possible to ensure that cells are not left blank?

• Try out Date validation, just add another column for an Assessment date.

• Give helpful feedback messages if data is input incorrectly.

Test your sheet by entering some made-up data ; can you break your sheet?