Pupil Experience Tracking/Analysis Tool
A free, GDPR-compliant HTML tool for tracking pupil enrichment experiences. Import a CSV, instantly see participation rates, equity gaps, and Ofsted-ready analytics — no login, no server, no data stored.
Tracking pupil engagement in wider opportunities, enrichment and other experiences can be extremely difficult and it can be even more difficult to find useful and meaningful information about pupil groups. This tool allow you to complete a very basic spreadsheet which then does all of the analysis and tracking for you. It tells you information at pupil, class, and a whole-school level and breaks down attendance by pupil groups, giving you insight into engagement of vulnerable pupil groups.
This tool works entirely in the browser, covers PP, SEND, EAL and gender breakdowns across six tabs — individual pupil profiles, experience analytics with representation vs school average, whole-school overview, equity gap analysis, participation trends heatmap, and a watchlist flagging pupils with zero experiences and activities where disadvantaged groups are under-represented. No setup, no IT department needed — just a CSV and a browser.
To help you get started, two Excel spreadsheets (.xlsx) have been provided: a blank template for you to enter your own pupil data, and an example file pre-populated with fictional data so you can explore the app straight away. Before either file can be used by the app, it must first be saved in CSV format. To do this, open the spreadsheet in Excel, go to File > Save As, and choose CSV (Comma delimited) (*.csv) from the file type dropdown. Make sure to save the CSV to a location you can easily find, as you will need to select it when loading data into the app. Note that Excel may warn you that some features will be lost when saving as CSV — this is expected and you can safely click Yes to continue.



