Year 7 Maths Baseline Automated Tracker

Automated Excel tracker designed specifically for the Year 7 Maths Baseline Assessment. Enter question-level marks and the workbook instantly produces class analysis, pupil reports and intervention priorities.

This editable Excel tracker has been created to accompany the Sharpe Education Year 7 Maths Baseline Assessment and Mark Scheme, available separately.

Teachers enter each pupil’s question-level marks once. The spreadsheet then automatically calculates totals, percentages, curriculum-strand performance, diagnostic bands and suggested intervention priorities.

Included features
Data-entry space for up to 40 pupils
Question-level mark entry
Automatic total score out of 50
Automatic overall percentage
Editable diagnostic performance bands
Curriculum-strand scores and percentages
Number analysis
Fractions, decimals and percentages analysis
Geometry and measures analysis
Algebra and ratio analysis
Reasoning and problem-solving analysis
Automatic identification of each pupil’s primary area for development
High, medium and routine intervention flags
Whole-class dashboard
Question-level class analysis
Performance-band distribution
Individual pupil reports
Suggested next steps
Filterable intervention overview
Editable thresholds and question mapping
Suitable for
Year 6 to Year 7 transition
September baseline assessment
Class and cohort analysis
Intervention planning
Pupil progress meetings
Mathematics subject leaders
Tutors and home educators
Important information

This tracker is designed specifically for the corresponding Year 7 Maths Baseline Assessment. The assessment paper and mark scheme are not included with this tracker and must be purchased separately.

The workbook uses standard Excel formulas and does not require macros or external add-ins.

Performance bands are diagnostic categories rather than nationally standardised thresholds and can be edited to match a school’s assessment approach.