Run Don't Walk: Primary Pupil Progress Tracking Tool and Data Analysis - LITE
This is a class data tracking tool to assist teachers input, store, track and analyse their class data, including a vulnerable groups comparison and combined subject attainment diagram. This tool is written within MS Excel, so there is no need to purchase/ learn new software.
Main Features:
- Input up to 40 pupils and specify gender, pupil premium, and 3 customisable groupings (e.g. SEND, EAL, LAC)
- Input "Emerging, Expected, Exceeding" for reading, writing and maths starting with the previous year's end results, and continuing half termly (e.g. Autumn 1, Autumn 2, Spring 1, etc)
- Print off class data posters for each half term showing full breakdown of data within vulnerable groups as to how many pupils are on track to make expected or above attainment and indication of typical/ accelerated progress.
- Print off whole year data sheet giving overview of all data, colour coded to highlight weaker/ stronger areas (includes gap between disadvantaged and non-disadvantaged pupils).
- Select individual pupils to view progress charts in reading, writing and maths compared to class average and national average; ideal for parent's evenings/ reports.
- View 'windscreen' style charts in reading, writing and maths, showing at a glance children's progress throughout each term.
- View a 'combined' subject Venn Diagram, showing which children are on track to meet expected attainment in all three subjects, or two, or one, or none.

This tool will eliminate human error if you have previously been asked to gather data or calculate these percentages by hand. It also provides an excellent visual representation of children's learning across time.

This is designed for individual teacher use, however please do get in touch if you are interested in whole school training.

Please see the video tutorial for more information:
Save for later
  • RDW-Tracker-LITE.xlsm

About this resource


Created: May 4, 2017

Updated: Feb 22, 2018


xlsm, 1 MB


Report a problem

Tes Paid License

How can I re-use this?