Certification: Edexcel Online BTEC/NVQ Bulk Claim Process

To access the bulk reporting tool, you will require the EOL profile option of 'BTEC Bulk Grade Reporting' added to your account by the main Exams Officer/ Centre Administrator. This is permitted in the following situations:

Where a user has one of the following job roles and has the profile 'Coursework & Portfolio':

• Head of Department/Course Leader
• Instructor/Teacher/Lecturer
• Quality Nominee
• Quality Officer
• Vocational Co-Ordinator
• Vice Principal

Once the 'BTEC Bulk Grade Reporting' access is granted, these users will have access to the BTEC Bulk Grade Reporting tool and be able to download the spreadsheets(s) and upload them for validation and submission by the examination/administration teams. 

Where a user has one of the following job roles and has the profile 'BTEC/NVQ Achievement Reporting':

• Examination Manager
• Examination Officer
• Examination Assistant
• Head of Centre
• Deputy Head of Centre
• Centre Co-Ordinator/Administrator

These users will have full access to the service (downloading/submitting spreadsheets).

Please note: if the user has no job role defined, then they do not see the profile option in the menu. 

When claiming for a learner using the Bulk Grade Reporting Tool, this will only process if you are reporting at least one new unit grade that is not already on the learner’s record. 

This means that if you are trying to submit only full award claims using the tool, and you are leaving all the unit grade columns blank, then this will not work. You will need to report new unit grades, or if they are all already on the learner’s record then make the full award claim on the learner’s individual record on Edexcel Online. 

Formatting advice

• Do not change the name of the template file. 
• Do not amend any of the cells that are highlighted in grey. 
• In the unit grade columns, please only enter 1 letter (and no ‘spaces’) to indicate the grade. This should be either U, P, M, D (signifying Unclassified, Pass, Merit, & Distinction respectively). Please avoid entering any ‘space’ keys into the cells, since this will result in a formatting error that our tool cannot recognise. 
• It is fine to leave a cell as its default ‘<Enter Grade>’ value, if you do not wish to report a unit grade for a learner this time. 
• In the claim type column, please only enter 1 letter to indicate the claim type. This should be either A, I, F (signifying Full award, Interim, & Fallback respectively). Please see Certification: BTEC/NVQ Claims for more information about claim types 
• In the award date column, please enter this in MM/YYYY format. This will then default to displaying as ‘Jun-25’ (for example), which is fine. This is a mandatory field for all claim types. 
  Please do not enter a date in the future as this will not be accepted and the claim rejected.
• In the print NOP column, you only need to complete this column if you are submitting an interim claim. Please change this to Y, if you would like for an updated Notification of Performance to be sent to you for the learner. This does not apply to full awards since NOPs are printed automatically for those, or to fallback awards since a Certificate of Unit Achievement is printed as opposed to an NOP.