Pupil Progress Data Analysis Template (Automatic percentage formulas and pie charts!)

This neat, compact, and visually-engaging data analysis template is an invaluable tool for school leaders, teaching and learning leaders, curriculum leaders, or any other school-based staff responsible for the inputting and analysis of pupil progress data.

All that the resource requires is for users to input raw pupil progress data, and it will automatically calculate percentages, and create colourful pie-charts to provide detailed yet easily-readable headline figures. Each excel sheet has been designed to fit onto one A4 page, for easy reading, and this includes space for users to input analysis of the data and plot interventions.

5 sheets have been pre-populated with example data, but the user can create as many extra sheets as they want by simply right-clicking the tabs, selecting 'move or copy', and then ticking the 'create copy' box. The sheets that are created will contain all of the same formulas and pie-charts, to enable you to create page after page of detailed progress analysis!

All of the columns and row names in the tables can be edited to suit the language used by your school, but please avoid altering the percentages rows, as you may lose the formulas.

If you have any further questions after purchasing this product, please contact me at tandlguru@yahoo.co.uk

Thanks!