Deluxe Spreadsheets

Most spreadsheets in the world are terrible (even if functional); below you will find some useful spreadsheets which have been formatted with attention to detail and visual appeal.

Child Measurement Tracker | UK Growth Charts | WHO Child Growth Standards

Many parents and health professionals track child growth (height, weight and BMI) on paper charts. I decided to digitise the child growth charts used in the UK as part of the NHS child measurement initiative to help make tracking more reliable and considerably easier for data entry. This spreadsheet includes height, weight and BMI centiles from the WHO in reference tables for children aged 2-18 years. One input table records static child information such as name and date of birth. A second input table is for recording measurements. Height and/or weight are recorded with the date of measurement. BMI is calculated for corresponding height and weight measurements or the nearest pairing for when height and weight are not measured on the same date.
Pairs of overlapping graphs (charts) display the centiles graphically in the background with the actual child measurements plotted in the foreground so their position relative to the centiles can be seen. One pair of charts is for height, another pair for weight and a final pair for BMI.

The measurement tracker includes one sheet for girls and one sheet for boys with their respective reference tables. In order to track multiple girls or boys duplicate the respective sheet.

More information about this UK Growth Charts:
Royal College of Paediatrics and Child Health information about UK Growth Charts

This is a Numbers Spreadsheet ¹


UMS Grade Boundary Spreadsheet | Raw Marking to Uniform Marking Scheme Calculator

This Numbers ¹ spreadsheet helps teachers grade students across multiple assessments. This is particularly useful for awarding centre assessed grades (CAGs).

The spreadsheet accomplishes the following tasks:

  1. Ensures consistency among multiple assessments each with unique numbers of raw marks and requiring their own unique grade boundaries.
  2. Very easy grade boundary adjustment by use of stepper cells.
  3. Automatically selects the top three UMS scores from across all assessments and calculates an average UMS score.
  4. Gives immediate feedback on the UMS and grade distributions to aid teachers adjusting grade boundaries for a specific distribution outcome (usually close to a normal distribution).
  5. Adding benchmark data is optional but enables the spreadsheet to give automatic statistical feedback using a t test and chi squared test to enable teachers to quickly compare their cohort’s performance to exam results of a previous cohort (to facilitate consistency if required).

There are some brief instructions written into the Overview sheet and Paper 1 sheet to enable you to get started quickly.

This version supports up to 50 students, six assessments (six papers), it selects the top three results. If you’re comfortable making changes to formulae you are welcome to do so. If you do make changes you are free to give away your changed version but not for sale.


Assessment Analysis Spreadsheet | Analyse Assessment Results in Detail

A Numbers ¹ spreadsheet that provides teachers with an attractive interface to record and analyse students’ grades. Capable of tracking results for up to three classes in the same subject (and can easily be edited to extend for more classes).

Scores can be recorded from two separate sections independently if desired. Grade boundaries are set per assessment in the designated table. Graphs show % scores in 5% range categories and the grade distribution.

In the main table achieved grades are compared with target grades and class average deviation from targets are also computed.


¹ Numbers is spreadsheet software made by Apple, it opens with the Numbers app available for free with most recent iPhone / iPad / Mac devices also available with a free Apple ID for use in most web browsers.