Overview
This article explains how to find the correct Attainment 8 points for your qualifications to help you create Grade Methods within KS3/4 of Sisra Analytics, ensuring that your qualifications will count correctly in Headlines figures.
Prerequisites
- You must be an administrator.
- You must have Microsoft Excel (or another spreadsheet that will open an ODS file)
- You will need a QN code for the qualification you want to check, for example, QN 60142923. Your school's Exams Officer will be able to provide this. Alternatively, speak to the appropriate Examinations Board.
Instructions
To find the correct Attainment 8 points for your qualification:
- Download a copy of the most recent performance points spreadsheet provided by the DfE. This is currently Performance points for qualifications counting in the 2025 key stage 4 performance tables (access from https://www.gov.uk/government/publications/key-stage-4-qualifications-discount-codes-and-point-scores).
- Open the spreadsheet in Microsoft Excel.
- Select Enable Editing.
- Select Home.
- Select Find & Select.
- Select Find...
- From the Find and Replace window, select Options to expand the window (if it's not already expanded):
- Select Workbook from Within.
- In Find What, enter your QN code (removing any forward slashes), for example, 60142923.
- Select Find Next.
Instructions video
This video features the old version of Sisra Analytics, therefore, what you see on your screen may differ, but the steps you need to take remain the same.
Outcome
The QN Code is located within the spreadsheet, along with the details for the qualification. For 60142923, this is AQA Level 1/Level 2 GCSE (9-1) in English Language. Use the Pass Points (Column F) and GCSE Equivalences (Column G) to set up the correct grade points and entries for your KS3/4 EAP grade method in Sisra Analytics:
Qualifications using the same grading structure will appear next to each other in the spreadsheet.
If your qualification is not found within the spreadsheet, it may not be eligible to count towards the performance measures for the given year. Contact the Examination Board or the DfE for clarification.
Related information
- Key stage 4 qualifications, discount codes and point scores (DfE) https://www.gov.uk/government/publications/key-stage-4-qualifications-discount-codes-and-point-scores
- If you have the grade structure for the qualification, the associated points can be found in the DfE’s Secondary Accountability Measures from page 64 onwards (See Sisra Analytics: KS4 - DfE's Secondary Accountability Measures Guide).
Updated