Skip to content

Latest commit

 

History

History
44 lines (23 loc) · 997 Bytes

excel.md

File metadata and controls

44 lines (23 loc) · 997 Bytes
Raw

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?