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:
- Ensures consistency among multiple assessments each with unique numbers of raw marks and requiring their own unique grade boundaries.
- Very easy grade boundary adjustment by use of stepper cells.
- Automatically selects the top three UMS scores from across all assessments and calculates an average UMS score.
- 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).
- 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.
If you need to take your assessment analysis to the next level and track student progress over time I recommend my Assessment Tracker Spreadsheet. This enables you to track progress across up to six assessments, you can add custom weighting to the overall score to give added weight to recent scores reflecting improvement with time. Additionally bubble charts can help shed light on gaps in knowledge. Assessment Tracker Spreadsheet is a paid for item available on TES (TES account required).
A-Level Physics Quiz Generator Spreadsheet | Makes Scoring a Breeze
I use this generator extensively for continual revision throughout the school year. Each lesson we have a 5-10 minute quiz on past topics to keep them fresh in students’ minds. This is one of Rosenshine’s key principles.
Generate a recap / review quiz on a subject in physics with ease. Comes with a database of questions categorised into topic areas (physics subjects), you just select the topic area you want a quiz for and you’ll immediately get a mini quiz of five questions. When the class has finished attempting the questions click once to reveal the solutions. Want to cycle the questions for a new quiz? Check a checkbox and boom you’ve got a new quiz on the same topic area.
This is an entirely offline solution meaning you can use this even when your school’s internet connection drops out. The supplied questions are categorised as literacy or numeracy (where applicable). And those linked skills are displayed to the class to reinforce that the mini quiz includes those skills.
The master sheet has a single database of questions to make question maintenance a breeze – one place to input / edit questions. All lookup formulae are dynamic so that you don’t have to worry about which order the questions are in – so feel free to change the order of questions or add/remove questions as you see fit. The master database also harnesses Numbers’ built in categorisation on the subject so you can expand and collapse collections of questions easily – once again maintaining the database is made super easy.
The quiz generator is designed to randomly select five questions from the database. But note that for subjects with a small number of questions in the database duplicate questions may occasionally be shown. If you can try to keep numbers of questions above 15 to reduce the likelihood of this.
This is a Numbers ¹ spreadsheet.
Monopoly Scorer Spreadsheet | Makes Scoring a Breeze
Track property purchases and house and hotel building and see player value at a glance. Optionally use the Scoring & Rental sheet to see the rent payable on any property.
This is a Numbers ¹ spreadsheet. It has property values and rental amounts for the original UK version. If playing a different version of the game update the Property Details table and the property names in the scoring sheet.
¹ 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.