UMS Grade Boundary Spreadsheet

**This is a free Numbers¹ spreadsheet to help teachers having to set multiple assessments for their students some of which are used to calculate a centre assessed grade. **

You can download this for free and without an account here

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. Selects the top three UMS scores from the 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. Gives 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). Adding benchmark data is optional.

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 (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.

If I can I will produce a tutorial video.

If you’d like to request a feature change or spot any errors contact me via my website wonkylogic.co.

Also available for free here

¹ Numbers is spreadsheet software made by Apple. It runs on Macs, iPads, iPhones and most web browsers (if you have a free Apple ID).
It may be possible to export this to an Excel workbook but I couldn’t guarantee a fully functioning output. If I have time I will export it and ensure it all works - but no guarantees on that I’m afraid.

Updated 28 April - additional guidance notes on use of t-test and Chi Squared test