Assessment Tracker Spreadsheet | Analyse Grades and Track Progress

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

Per assessment 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. A bubble graph helps to visualise if top scorers / low scorers had notable strengths or weaknesses in section A or B of the exam.

In the main table achieved grades are compared with target grades and class average deviation from targets are also computed. There is also a bubble chart that can cycle through the assessments which makes it easy for the teacher to click through the assessments and see if there are any notable trends - it is also simple to present the chart to a class to discuss exam performance (my students love this).

The Tracking Sheet imports results from the individual test Sheets. On this Sheet you can optionally use weighted percentages for the assessments (e.g. give more challenging assessments higher weighting to account for the difference or give more recent assessments higher weightings to emphasise recent progress).

Overall performance is illustrated on the Tracking Sheet with target grade comparisons and distribution graphs.

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