Template 1ab - Grade boundary information for units and components
Updated 16 April 2024
Download CSV 2.62 KB
Name | Description | Position | Validation Regular Expression | Description of Regular Expression |
---|---|---|---|---|
ExamSeries | Exam series data relates to | 1 | ^(June)([ ][0- 9][0-9][0- 9][0-9])$ | Full month name of exam series and year. |
ReportingDate | Date the file was due to be submitted regardless of when it was actually uploaded. Format accepted 120 ODBC canonical yyyy-mm-dd. | 2 | ^(20)\d\d[- ](0[1- 9]|1[012])[- ](0[1- 9]|[12][0- 9]|3[01])$ | The date in the following format: year (four digits), a dash, month (two digits), a dash, day (two digits). |
AwardingOrganisation | Name of the awarding organisation | 3 | ^.{1,100}$ | One, to one hundred characters accepted |
QualificationLevel | Level of qualification, for example GCSE | 4 | ^(GCSE|AS|A level)$ | One of the following list: GCSE, AS, A level. |
UnitOrComponentCode | Unit or component code as designated in the specification. | 5 | ^.{1,10}$ | One, to ten characters accepted |
SpecificationCode | Specification code also known as Subject Award Code and Cash-in Code | 6 | ^.{1,7}$ | One, to seven characters accepted |
SpecificationTitle | Specification title also | 7 | ^.{1,150}$ | One, to one hundred and fifty characters accepted |
Tier | To indicate the tier if applicable. F for Foundation H for Higher | 8 | ^(F|H|-2)$ | One of the following list: F, H. -2 accepted where not applicable. |
MaxUniformMark | Maximum uniform mark available for the unit. In unitised specifications where units may contain multiple components, only provide the unit maximum mark. | 9 | ^\d{1,3}$ | A numeric value between 0 and 999 accepted. -2 accepted for nonUMS specifications |
MaxRawUnweightedMark | Maximum raw unweighted mark available for the unit or component. | 10 | ^\d{1,3}$ | A numeric value between 0 and 999 accepted. |
WeightingFactor | Multiplier applied to the component mark to determine the contribution to the subject mark. To three decimal places. | 11 | ^\d{1,3}\.\d{0 ,3}$|^\d{1,3}$ | A numeric value between 0 and 999 with up to three decimal places accepted. -2 accepted if not applicable. |
Grade | Unit or component grade | 12 | ^(A*|A|B|C|D|E |7|4|1||7-7|4- 4|1-1|-2)$ | One of the following list: A*, A, B, C, D, E, 7, 4, 1, 7-7, 4-4, 1-1. -2 also accepted for unknown value. |
Boundary | Raw mark boundary (or A level A* conversion point). | 13 | ^\d{1,3}$ | A numeric value between 0 and 999 accepted. -2 accepted where not applicable. |
CarryForward | To indicate if the row of data relates to a carry forward option | 14 | ^(1|0)$ | For OCR and Pearson: one of the following list: 1, 0 For all other awarding organisations, please submit a blank column with just the column name. |