A powerful, fully editable Excel tool designed to turn assessment marks into meaningful diagnostic information in seconds.
Simply configure your assessment, enter pupil marks at question level, and the spreadsheet automatically analyses performance across individual questions, topics, skills and assessment objectives.
Suitable for any subject, assessment or key stage, this resource is ideal for teachers, Heads of Department and intervention leads who want to understand not simply what score pupils achieved, but where learning gaps actually are and what needs to be taught next.
Features include:
Fully automated Excel workbook
Suitable for any subject or key stage
Up to 100 pupils
Up to 60 individual questions / question parts
Customisable question names and maximum marks
Assign each question to:
topic
skill
assessment objective
difficulty level
Automatic pupil totals and percentages
Editable attainment / performance bands
Automatic strongest and weakest areas
Automatic intervention priorities
Whole-class assessment dashboard
Question-by-question success rates
Automatic strongest and weakest question identification
Topic-level analysis
Assessment-objective analysis
Difficulty analysis
Individual pupil report generator
Automatic next-step targets
Intervention-group identification
SEND / Pupil Premium / EAL cohort analysis
Printable teacher summary
Clear colour-coded analysis
Fictional demonstration data included
No macros or external add-ins required
Ideal for
End-of-unit assessments
Baseline assessments
GCSE mock examinations
Departmental assessments
Intervention planning
Curriculum review
Question-level analysis meetings
Identifying misconceptions
Personalised pupil feedback
Department and whole-school data analysis
Rather than manually calculating percentages and searching through marks, the workbook automatically highlights which questions caused difficulty, which curriculum areas need reteaching and which pupils require targeted support.
All key settings are editable, allowing the workbook to be adapted to your own subject, assessment structure and school context.
© SharpeEducation 2026. For purchaser use only. Redistribution, resale or uploading to other platforms is not permitted.
Get this resource as part of a bundle and save up to 25%
A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.
Bundle
Whole-School Assessment, Feedback & Intervention Suite
A complete collection of five premium SharpeEducation resources designed to support assessment, reporting, intervention and feedback across any subject or key stage. This bundle brings together a full whole-school workflow in one professional package: Ultimate Automated Excel Teacher Markbook Universal Question-Level Analysis (QLA) Tracker Automated Student Report Generator Automated Intervention Tracker & Impact Dashboard Whole-School Feedback & Improvement Toolkit Together, these resources support the complete cycle: Track → Analyse → Report → Intervene → Improve The suite is designed to reduce teacher workload while making assessment and intervention data more meaningful and easier to act upon. Across the five resources, features include: Automated assessment tracking Class and pupil progress analysis Question-level analysis Strengths and gaps identification Automatic next-step targets Individual pupil reports Ready-to-paste report comments Intervention monitoring Progress-to-target calculations Impact analysis Review-date alerts Priority action flags Cohort analysis SEND, Pupil Premium and EAL monitoring Whole-class and individual feedback templates DIRT and pupil-response resources Automated feedback monitoring Editable dashboards and settings No macros or external add-ins required Suitable for: Classroom teachers Heads of Department SENDCos Heads of Year Pastoral teams Assessment leads Intervention coordinators Middle and senior leaders The resources are suitable for use across different subjects, year groups and key stages, making the bundle particularly useful for departments or schools looking for a consistent set of assessment and improvement tools. All Excel resources are fully editable. Word and PDF formats are included where applicable. Purchased separately: £32.95 Bundle price: £24.99 Save approximately 24% by purchasing the complete suite. © SharpeEducation 2026. For purchaser use only. Redistribution, resale or uploading to other platforms is not permitted.
£24.99
Bundle
Ultimate Assessment & Reporting Toolkit
A complete three-part automated Excel toolkit designed to help teachers record assessment data, analyse pupil performance and generate high-quality student reports with far less manual work. This bundle brings together three of the most useful SharpeEducation automated resources into one integrated assessment and reporting package. Included in this bundle 1. Ultimate Teacher Excel Markbook A fully automated markbook for recording and analysing pupil assessment data across the academic year. Includes: assessment tracking class averages progress monitoring target comparison attainment bands attendance and behaviour information individual pupil overview class dashboard automatic visual analysis 2. Automated Question-Level Analysis (QLA) Spreadsheet Analyse assessment performance in much greater depth by identifying exactly where pupils succeeded and where misconceptions remain. Includes: question-by-question analysis topic and skill breakdown assessment objective analysis strongest and weakest questions intervention priorities pupil-level analysis cohort comparison individual pupil reports automatic next-step identification 3. Automated Student Report Generator Turn assessment data into clear, personalised pupil reports and ready-to-paste reporting comments. Includes: automatic report comments strengths and development areas next-step targets individual printable pupil reports class dashboard attainment analysis report register for whole classes editable comment bank teacher override option Suitable for Any subject Any key stage Classroom teachers Heads of Department ECTs Assessment leads Intervention planning Parents’ evenings Report writing End-of-unit assessments Mock examinations Whole-class data analysis All three resources are fully editable and designed to work without macros or external add-ins. Simply enter your pupil information and assessment data, then allow the automated formulas and dashboards to handle much of the repetitive analysis. Why purchase the bundle? Purchased separately, these three resources cost £19.97. Bundle price: £14.99 That gives access to the complete assessment workflow: Record → Analyse → Identify Gaps → Set Targets → Report Rather than maintaining several disconnected spreadsheets, this toolkit gives teachers a professional set of reusable tools for managing assessment and reporting throughout the academic year. Please note: Fictional pupil data may be included within the files to demonstrate how the automated features work. This can simply be replaced with your own data. © SharpeEducation 2026. For purchaser use only. Redistribution, resale or uploading to other platforms is not permitted.
£14.99
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£5.99