Track GCSE Design & Technology NEA progress, predict outcomes and identify exactly what students need from the written exam – all in one automated Excel tracker. Designed specifically for teachers delivering AQA GCSE Design & Technology (8552), this ready-to-use spreadsheet takes the headache out of manually calculating NEA progress, GCSE contributions and potential outcomes. Simply enter each student’s marks for NEA Sections A–F and the tracker automatically does the calculations for you. WHAT THE TRACKER DOES • Automatically totals NEA marks from Sections A–F • Calculates each student’s NEA percentage • Calculates the NEA’s 50% contribution to the overall GCSE • Generates an indicative NEA tracking grade • Allows you to enter individual student target grades • Calculates the written examination mark required to reach that target • Flags when the required exam mark is above the available marks • Provides an instant whole-class summary showing the number of students currently tracking at each grade • Uses editable grade thresholds so the tracker can be updated and reused in future examination series WHY IT’S USEFUL This isn’t simply a marksheet. It allows you to turn NEA assessment into useful intervention information. At a glance, you can see where every student currently sits, how much their NEA is contributing towards their final GCSE outcome and what performance they would need in the written examination to achieve their target grade. This makes it particularly useful for: • Year 11 progress tracking • NEA reviews and moderation • Identifying students requiring intervention • Departmental progress meetings • Target-setting conversations • Parents’ evenings • Exam preparation • Department and leadership data discussions EASY TO USE A dedicated START HERE page provides clear instructions, so the spreadsheet can be used immediately. The workbook is colour-coded to distinguish between teacher input cells and automatically calculated information. Simply add your class list, enter NEA marks and target grades, and the tracker does the rest. The separate Settings sheet allows teachers to enter the grade thresholds they wish to use for tracking. This means the resource is not tied to a single examination year and can be updated as required. INCLUDED ✓ Automated GCSE D&T NEA tracker ✓ Sections A–F mark entry ✓ NEA total and percentage calculations ✓ Indicative grade tracking ✓ 50% GCSE contribution calculation ✓ Target-grade tracking ✓ Required written-exam mark calculation ✓ Whole-class grade summary ✓ Editable grade-threshold settings ✓ Built-in instructions File format: Microsoft Excel (.xlsx) This is an independently created teacher resource designed to support delivery and tracking of AQA GCSE Design & Technology (8552). It is not produced, endorsed or approved by AQA. Grade thresholds entered into the workbook are for teacher tracking purposes and should not be treated as predictions of future official grade boundaries.