DISCOMETER - ANALYSIS

The Discometer MUST be created using spreadsheet software and use formulae to generate results.

TASK 1  Create the Discometer.

It needs to:

  1. be easy to use without help
  2. allow users to answer the questions
  3. only show information the user needs to see (not the formulae)
  4. only allow users to select the cells where they need to enter data
  5. be formatted so that the results are very clear
  6. include results that can be used to search the database.

TASK 2  Test it using your own data.

TASK 3  Test it using your test partner.  Make any changes.

TASK 4  Ensure the quiz works using Excel Viewer 2003.


THE GUIDE GRID
 

Stuck?  Launch SPB Helper!
 
Microsoft Excel

DOWNLOAD:  Discometer.xls

Student login
Teacher login
 
  1. Save the final version so it can be viewed in Excel Viewer 2003.  There should be no data.
  2. Save the results of your test of the Discometer