Primary Science Assessment Tracker Spreadsheets

Streamline your primary science data with two powerful, automated tracking Excel spreadsheets. Designed to reduce teacher workload, these tools provide instant analysis of student attainment across the National Curriculum, allowing for precise data-driven interventions.

Why Choose This Resource?
User-Friendly: Minimal data entry required—the formulas do the heavy lifting.

OFSTED Ready: Provides clear, visual evidence of attainment and progress for different cohorts.

Fully Customisable: Adaptable to your school’s specific class names and student lists.

Spreadsheet 1: Year 1–6 Curriculum Tracker

• Comprehensive Coverage: Tracks every science objective for Year 1 through Year 6.

• Automated Calculations: Instantly generates average attainment, overall standards, and effort grades.

• Targeted Demographic Analysis: Automatically breaks down data by gender to compare performance between boys and girls.

• Key Stage Summaries: Provides % breakdowns for each year group, KS1, and KS2, showing pupils working at each level and those at/above the expected standard.

• Simplified Grading: Uses an intuitive 1–4 grading system (1: Lowest, 4: Highest) for quick data entry.

Spreadsheet 2: Years 3–6 End-of-Unit Test Tracker

• Assessment Focused: Calculates attainment levels based on raw scores from end-of-unit tests.

• Granular Analysis: View and compare performance by individual classes within a year group.

• Progress Tracking: Easily identify gaps in knowledge across specific science topics for upper primary.