• Scenario
• Know your stuff! Planning
• Keeping track
• Gathering information
• Five a day database
• Reality Check
  • Introduction
  • Data Collection Form
  • Analysis
• 
• Information Pack
• Snack attack
• 
• eportfolio
• Review

REALITY CHECK (Page 3 of 3) ANALYSIS

The Reality Check MUST be created using spreadsheet software and use formulae to generate results. Quiz wizards are not acceptable!

It should have a user-friendly interface so you will need to use formatting techniques. This simple example, for another project, uses conditional formatting.

Create the Reality Check.

It must:

• allow users to enter the figures from their data collection form
• only show information the user needs to see
• only allow users to select the cells where they need to enter data

Test it thoroughly using your own data.

Make sure that it works by asking your test buddy to enter their data.

Are they happy with the results? What do they think of the way it works?

Check that the results section will be clear when printed for the Information Pack.

Save your Reality Check spreadsheet so that the moderator can see both the values and the formulae.