Core Maths Outcomes Guidance: guide to the data submission process
Updated 14 August 2023
Introduction
In order to fulfil our regulatory and accreditation functions as set out in the Apprenticeships, Skills, Children and Learning Act 2009, we require awarding organisations to provide exams delivery data for regulated qualifications.
What data will be collected?
Data should relate to Core Maths for learners in Centres in England only.
When will data be collected?
Data will be collected according to the reporting schedule which is agreed and maintained by Ofqual’s data services team.
Updates to formats and guidance
This guidance document will be updated regularly. Any changes to procedure will be incorporated into the guidance document.
How to submit your data
Your data should be submitted to us in CSV format. Please refer to the ‘Connecting to Ofqual’s data portal and uploading data’ document on our webpage to help you submit your files to us. If you need to ask us about a data submission please do contact the Data Services team by emailing [email protected], please do not send your data files via email to Data Services or to any other Ofqual email address, or via Contact the Regulator in the Portal.
Uploaded data
Once the files have been successfully uploaded, the data will be validated against a set of validation rules. These are detailed in the sections below. If validation is successful, the data is automatically transferred into our systems and you will receive email confirmation. If the file is unsuccessful at any stage of validation you will receive an email with details of the validation failure. Please correct your file and resubmit it.
Amendments to data
Ofqual staff will not alter data once it has been submitted. If you find an error or omission after you’ve had a successful upload, please notify us by emailing [email protected]. We need to reject the existing submission before you can upload a new file.
How your data will be used
This data will be used to undertake our regulatory activities and, where required, to produce Official Statistics to fulfil our responsibility as a government department.
General completion guidelines
Data should relate to the summer exam series and for learners in Centres in England only.
There is no need to submit registrations or entries - we are only asking for learners with grades awarded (please still provide a registration/entry date in the relevant field for those learners).
There is no need to submit linking information. Instead, please use summer exam series, for example, ‘June 2023’ for the MaxMarkAndBoundaryID field.
There is no need to return values for QualificationRawMark or QualificationScaledScore fields. ‘-2’ can instead be used (QualificationGrade will be required).
File format
The file must be CSV format and the first row must be headers as displayed in the ‘Name’ column of the table below. The subsequent rows must have the values of the data to be reported which must match the format and validation rules below.
Name | Description | Position | Validation Regular Expression | Description of Regular Expression |
---|---|---|---|---|
ReportingDate | Date the file was due to be submitted to Ofqual regardless of when it was actually uploaded (this date will be made available by Ofqual) | 1 | ^(20)\d\d[-](0[1-9]\|1[012])[-](0[1-9]\|[12][0-9]\|3[01])$ |
The date in the following format: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) |
AcademicYear | The exam series which this data submission relates to. For example, June 2023 | 2 | ^(June)([ ][0-9][0-9][0-9][0-9])$ |
Exam series and year For example, “June 2023” |
AwardingOrganisation | Name of the awarding organisation | 3 | ^.{1,100}$ |
1 to 100 characters accepted |
QualificationNumber | This should be the unique identifier for the qualification as it appears in Ofqual’s Register of Regulated qualifications, for example, 123/1234/1 | 4 | ^.{1,10}$ |
Valid Qualification Number - 1 to 10 characters accepted |
MaxMarkAndBoundaryID | Please use summer series name For example, June 2023 |
5 | ^.{1,50}$ |
1 to 50 characters accepted |
UniqueLearnerNumber | Unique Learner Number (ESFA code) provided by the Learning Records Service[footnote 1] Please provide this identifier wherever possible -2 accepted where the learner does not have a ULN |
6 | ^\d{1,10}$ |
1 to 10 digits accepted -2 accepted where the candidate does not have a ULN |
UniqueCandidateIdentifier | Unique Candidate Identifier (JCQ code), assigned to the candidate[footnote 1] -2 accepted where the learner does not have a UCI |
7 | ^.{1,13}$ |
A valid UCI - Alpha numeric 13 characters accepted -2 accepted where the candidate does not have a UCI |
CandidateIdentifierOther | Any other unique candidate number allocated by individual awarding organisation Must be provided where neither UCI or ULN are available [footnote 1] -2 accepted where at least one of UCI or ULN have been provided |
8 | ^.{1,20}$ |
1 to 20 characters accepted -2 permitted where at least one of UCI, ULN or UPN have been provided |
FirstName | Candidate’s forenames | 9 | ^.{1,150}$ |
1 to 150 characters accepted |
MiddleNames | Candidate’s middle name(s), if able to separate out from first names Can be left blank if not known or unavailable, or if middle names cannot be separated from first names |
10 | ^.{0,150}$ |
0 to 150 characters accepted |
Surname | Candidate’s surname or family name | 11 | ^.{1,150}$ |
1 to 150 characters accepted |
DOB | Candidate’s date of birth | 12 | ^(19\|20\|29)\d\d[-](0[1-9]\|1[012])[-](0[1-9]\|[12][0-9]\|3[01])$ |
Date in the following format: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) 2999-12-31 accepted if DOB unknown |
Gender | Candidate’s gender Accepted values: M, F, -2 accepted for other or not stated |
13 | ^(M\|F\|-2)$ |
Accepted values: M, F -2 accepted for other/unknown |
CentreURN | Centre’s Unique Reference Number as assigned by the Department for Education at the time of data submission -2 accepted where the centre does not have an URN[footnote 2] |
14 | ^\d{1,6}$ |
Valid Centre URN - up to 6-digit integer accepted -2 also accepted where centre does not have a URN |
CentreNCN | Centre’s National Centre Number as allocated by the Joint Council for Qualifications (JCQ) at the time of data submission[footnote 2] -2 accepted where the centre does not have an NCN |
15 | ^\d{1,5}$ |
Valid NCN code - up to 5-digit integer accepted -2 also accepted where centre does not have a NCN |
CentreIdentifierOther | Any other number allocated to the centre or assessment venue by individual awarding organisations at the time of data submission Must be provided if neither CentreURN nor CentreNCN are available[footnote 2] -2 permitted where at least one of NCN or URN have been provided or for candidates who are not registered to a centre |
16 | ^.{1,15}$ |
1 to 15 characters accepted -2 permitted where at least one of NCN or URN have been provided or for candidates who are not registered to a centre |
RegistrationDate | Date when the candidate originally registered/entered for the qualification For outcomes, this date must be on or before the first entry date and the award date For series-based awards, this should be the deadline date for registrations/entries |
17 | ^(20)\d\d[-](0[1-9]\|1[012])[-](0[1-9]\|[12][0-9]\|3[01])$ |
The date in the following format: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) |
QualificationCompletionStatus | Status of qualification at the time of submission Where possible, please indicate where learners have withdrawn from the course Accepted values: On programme, Completed, Withdrawn |
18 | ^(On programme\| Completed\| Withdrawn)$ |
Accepted values: On programme Completed Withdrawn |
AwardDate | The date that the result was issued, or is due to be issued to the centre (or candidate if result issued directly to candidate) Where used, this will be the date of the ‘results day’ for this qualification Future dates are accepted ‘2999-12-31’ accepted for registrations/entries |
19 | ^(20)\d\d[-](0[1-9]\|1[012])[-](0[1-9]\|[12][0-9]\|3[01])$ |
The date in the following format: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) |
QualificationRawMark | There is no need to return value - ‘-2’ can instead be used | 20 | ^\d{1,3}$ |
Three-digit integer. -2 accepted where not applicable |
QualificationScaledScore | There is no need to return value, ‘-2’ can instead be used | 21 | ^\d{1,3}$ |
Three-digit integer. -2 accepted where not applicable |
QualificationGrade | Final grade for the qualification, including fail | 22 | ^(A|B|C|D|E|U|X)$ |
A, B, C, D, E, U, X |
Annex A – Accepted Grade Values
The following are grades accepted for this collection. Please let us know via the Portal as soon as possible if any grades appear to be missing from this list. You will not be able to submit any grades which are not on this list without informing us first.
- A, B, C, D, E, U, X
Contacts
For all queries relating to the data collection process, amendments to data previously provided, or for general guidance. please contact:
-
To allow us to identify the learner please provide at least one of UniqueLearnerNumber, UniqueCandidateIdentifier, or CandidateIdentifierOther. If more than one is collected, please provide as many as are available. ↩ ↩2 ↩3
-
To allow us to identify the centre please provide at least one of CentreNCN, CentreURN or CentreIdentifierOther. If more than one is collected, please provide as many as are available. ↩ ↩2 ↩3