EYFS Early Learning Goals Tracker with Automatic Cohort Gap Analysis

Make Reception assessment more manageable with this formula-driven Early Learning Goals tracker.

Created for Reception teachers and EYFS leaders, this editable Excel resource helps you organise assessment information across all seven areas of learning and identify where additional teaching may be needed.

With 17 Early Learning Goals and space to record assessment information for up to 45 children, the tracker brings individual attainment and whole-cohort analysis together in one practical resource.

What’s included?

All 17 Early Learning Goals across the seven EYFS areas of learning.

Prime areas presented first to support a clear overview of the curriculum.

Space to record assessment information for up to 45 children.

Automatic calculations using spreadsheet formulas.

Cohort achievement figures and percentage calculations.

Automatic gap analysis to highlight areas where further teaching may be beneficial.

High, medium and low priority indicators to help organise next steps.

Teaching-response and review-date fields to connect assessment with planning.

A reference sheet to support consistent use of the tracker.

Why choose this resource?

Rather than simply recording individual children’s attainment, this tracker helps you look at the bigger picture. Identify patterns across the cohort, decide which areas need additional focus and use the information to support curriculum discussions, targeted teaching and review of progress.

It can also support preparation for assessment discussions, pupil progress meetings and school improvement planning.

Ideal for: Reception teachers, EYFS leaders, phase leaders and senior leaders who want a structured, efficient way to review attainment against the Early Learning Goals.

Format: Editable Excel spreadsheet with automatic formulas and cohort gap analysis.

Please note: This resource supports teacher assessment and planning. It does not replace the statutory EYFS Profile assessment, official guidance or professional judgement.