Year 7 Religious Education Baseline Assessment Tracker | Excel Data Analysis

A comprehensive Year 7 Religious Education Baseline Assessment Tracker designed to analyse results from the accompanying 50-mark RE baseline assessment.

Simply enter pupil names and question-level marks. The Excel workbook then calculates overall attainment, strand performance, diagnostic bands, areas for development and intervention priorities, giving teachers a clear picture of pupils’ starting points as they enter Year 7.

The tracker analyses five key areas:

Beliefs & Key Vocabulary /10
Traditions, Places & Practices /10
Sources, Teachings & Meaning /10
Lived Religion & Worldviews /10
Comparison & Reasoning /10

Includes
Teacher Dashboard
Question-level Data Entry
Class Analysis / QLA
Individual Pupil Report
Intervention Overview
Settings & Question Map
Capacity for up to 40 pupils
Automatic totals and percentages
Curriculum-strand analysis
Diagnostic performance bands
Primary gap identification
Intervention priority flags
Question-level success analysis
Class strengths and development priorities
Suggested teaching focuses
Individual pupil next steps
Editable diagnostic thresholds
No macros required

Performance bands are automatically assigned as:

Emerging → Developing → Strengthening → Securing → Excelling

The tracker supports a religion and worldviews approach, helping teachers identify whether pupils require further support with factual knowledge, vocabulary, interpreting sources, understanding diversity within traditions, comparing viewpoints or developing reasoned responses.

Designed to accompany the SharpeEducation Year 7 Religious Education Baseline Assessment & Mark Scheme.

Ideal for Year 7 transition, September baseline assessment, curriculum planning, intervention grouping and identifying gaps in prior learning.

Diagnostic bands are intended for internal assessment purposes and are not nationally standardised grades.

© SharpeEducation 2026