Year 7 Science Baseline Automated Tracker

A fully automated Excel tracker designed specifically for the SharpeEducation Year 7 Science Baseline Assessment. Enter pupil marks and the workbook automatically calculates scores, percentages, diagnostic bands, curriculum strengths, development priorities and intervention needs.

This tracker has been created specifically for the 50-mark Year 7 Science Baseline Assessment, covering:

• Working Scientifically – 10 marks
• Biology – 14 marks
• Chemistry – 13 marks
• Physics – 13 marks

The automated workbook includes:

• Teacher Dashboard
• Individual pupil data entry
• Automatic total score and percentage calculations
• Five diagnostic performance bands
• Working Scientifically analysis
• Biology analysis
• Chemistry analysis
• Physics analysis
• Identification of pupil strengths
• Automatic development priorities
• Class Analysis dashboard
• Individual Pupil Report generator
• Intervention identification
• Question-level analysis
• Editable diagnostic thresholds and question mapping

Simply enter pupil names and assessment marks. The workbook performs the analysis automatically, helping teachers quickly identify curriculum gaps and prioritise teaching and intervention.

Please note: This tracker is designed specifically to accompany the SharpeEducation Year 7 Science Baseline Assessment (50 marks). It is not intended as a generic Science assessment tracker.

The performance bands are provided for internal diagnostic purposes and are not nationally standardised grade boundaries.

The Year 7 Science Baseline Assessment and detailed Mark Scheme are available separately. A complete Assessment + Mark Scheme + Automated Tracker Toolkit is also available.

© SharpeEducation. All rights reserved.