Use the Grade Finalisation Tool

When grades have been finalised in Brightspace, they need to be transferred to the Student Management System (Banner). To do this, you need to use the Grade Finalisation Tool.


The Grade Finalisation process:

  1. Academic finalises and loads grades
    The academic staff member responsible for the subject enters and finalises the student grades in Brightspace. They then load and validate the grades in the Grade Finalisation Tool.
  2. School Assessment Committee (SAC) review
    The SAC reviews the finalised grades to verify their accuracy and adherence to grading policies. If the grades are approved, the SAC forwards them to the Faculty Assessment Committee (FAC). Otherwise, they are returned to the academic for necessary corrections.
  3. Faculty Assessment Committee (FAC) review and transfer
    The FAC reviews the grades for final approval, ensuring they comply with university-wide standards. Once approved, the FAC Delegate uses the Grade Finalisation Tool to transfer the finalised grades to the Banner Student Management System. If any issues arise during the review process, the grades may be returned to the academic for further clarification or adjustment.

The Grade transfer tool takes data from the Brightspace Gradebook and transfers it to Banner

It is important that staff do not make changes to the Brightspace Gradebook (My Grades) after grades have been transferred. This will ensure that Brightspace remains an accurate record of student achievement.

Review My Grades in Brightspace

The Grade Finalisation Tool transfers grades from the Brightspace Gradebook (My Grades) on demand. Therefore, the first step is to review My Grades in Brightspace. A thorough review at this stage may reduce any grade transfer errors.

  1. Click My Subject in the subject navigation bar.
  2. Click My Grades
  3. Check that all students have a mark allocated for each assessment task.

    A zero mark should be allocated in two cases: when a student has made no submission, and when a submission is judged to merit a mark of zero. In the latter case, a submission icon will display next to the zero mark in the cell in My Grades, indicating that an assignment, quiz attempt, or assessed discussion post is present in Brightspace.

  4. If working with a multi cohort subject, ensure that under Grade Calculations, Drop ungraded items is selected. You can find this setting in Manage Grades, clicking on the Settings icon in the top right corner, then select the Calculation Options tab and scroll to the bottom of the page.

    This is the default setting.

    Correct grade field setting for a multi-cohort subject

  5. Ensure that all Final Calculated Grades are correct.
  6. Follow your faculty’s policies and procedures to ensure that any grade overrides are added to the Final Adjusted Grades or Administrative Override column (E.g. GP, TA etc). Please note that AW or LW should not be added to this column as they won’t transfer.

The Grade Finalisation Tool will import and load any grade populated from any of these 3 final grade fields in the Gradebook – Final Calculated Grade, Final Adjusted Grade, and Administrative Override.

The system prioritises the display of grades in the following order:

  1. Admin Override
  2. Final Adjusted Grade
  3. Final Calculated Grade

Load and validate grades

  1. Access the Grade Finalisation tool:
    1. Click on My Subject in the subject navigation bar.
    2. Click Grade Finalisation to access the Grade Finalisation Tool.
    3. Type in the Subject Code and select the Session you are transferring grades for. You can also filter by Transfer Status and Offering Status to narrow down the results. For more information on transfer status, please see the section on Transfer Status below.
  2. Click Load grades to load the grades for a subject offering.

    Load grades button in the Grade Finalisation tool

  3. Check Status and Validation messages. If you encounter a validation error when loading grades, click View Details to see the validation message. For more detail on the validation messages, please see the section on Grade Loading Errors below.

    View details button in the Grade Finalisation tool

    Fix in Brightspace if required.

  4. Click Grades Validated to submit to SAC for review and moderation. This will also send the grades to QUASAR.

    Grades validated button in the Grade Finalisation tool

  5. Review grades in QUASAR.

    Link to QUASAR in the Grade Finalisation tool

  1. Access the Grade Finalisation tool
    1. Click on My Subject in the subject navigation bar.
    2. Click Grade Finalisation to access the Grade Finalisation Tool.
    3. Type in the Subject Code and select the Session you want to view. You can also filter by Transfer Status and Offering Status to narrow down the results.
  2. You now have two choices:
    1. Return a subject offering to the academic for review and changes OR
    2. Approve at SAC level and forward a subject offering to FAC for ratification.

      The Return for Review and Pass for Ratification buttons in the Grade Finalisation tool
  1. Access the Grade Finalisation tool
    1. Click on My Subject in the subject navigation bar.
    2. Click Grade Finalisation to access the Grade Finalisation Tool.
    3. Type in the Subject Code and select the Session you want to view. You can also filter by Transfer Status and Offering Status to narrow down the results.
  2. You now have two choices:
    1. Return a subject offering for review and changes OR
    2. Approve grades and transfer to Banner

      The Return for Review and Approve & Transfer Grades buttons in the Grade Finalisation tool

  3. For information on errors you may receive when transferring grades, please see the section on Grade Transfer Errors below.

If there is a need to repeat the transfer process in the Grade Finalisation tool, you will need to log a DIT Cherwell request to have the subject reopened within the tool.

The Grade Finalisation Tool exceptions report has been developed to replicate the report that was generated by Banner post grade transfer.  To access the report, click Reports in the Grade Finalisation Tool. This report is only available to the Grade Sign-off officer, Head of School, and the Faculty Subjects Team.

Before generating the report, you can filter by:

  • Subject code
  • Grade Transfer Statuses
  • Student Grade Transfer Statuses
  • Validation Messages
  • Session
  • Faculty
  • School

Exception report screen

Once you have added your required filters, click Generate Report.

The Generate Report button will only be active once you have added the session as this field is mandatory.

Select Yes to Confirm

An email report will then be sent to you as a CSV file.

GRADE TRANSFER STATUS DESCRIPTIONACTION
GRADES NOT YET TRANSFERREDGrade transfer has not occurred for this subject offering.Click the Load Grade button
LOADING GRADES (QUEUED)Grades are being loaded (in queue to be processed).No action required
LOADING GRADESGrades are being loaded.No action required
LOADING GRADES (RETRYING)Grades are being loaded (retrying after transient error).No action required
VALIDATION ERRORGrades failed to be loaded due to Subject Site level validation error.Please recheck and adjust your subject site Gradebook and reload the grades
ERROR LOADING GRADESGrades failed to be loaded due to technical error.Please report to DIT via a Cherwell Ticket
PENDING RECOMMENDATION OF GRADESGrades are loaded, and ready to be recommended and transferred.No action required
TRANSFERRING GRADES (QUEUED)Grades are recommended and are being transferred (in queue to be processed).No action required
TRANSFERRING GRADESGrades are recommended and are being transferred.No action required
TRANSFER VALIDATION ERRORA validation error has occurred for a student grade with status of 'Ready to Transfer', the entire transfer is haltedCheck specific grades first and then re-transfer / re-load ((Grade sign-off officer only)
ERROR TRANSFERRING GRADESThere has been a technical fault preventing grade transfer from completingPlease report to DIT via a Cherwell Ticket
GRADES TRANSFERREDAll student grades that had a status of "Ready to Transfer" have transferred successfullyNo action required
GRADES TRANSFERRED WITH ERRORSAn unexpected error has occurred during the transfer of one or more students grades, please check and correct as necessaryStaff will need to check these errors and correct the Banner grade as appropriate via existing workflow outside grade transfer
REOPENEDGrade transfer has been reopened.No action required unless requested by Grade Sign-off officer
TRANSFER STATUS GRADE STATUS VALIDATION CHECK ERROR MESSAGE
Error loading grades Validation error No field named "Administrative Override" found. Administrative Override Grade column not found.
Error loading grades Validation error Multiple fields named "Administrative Override" Multiple Administrative Override Grade columns found, expected one.
Error loading grades Validation error "Administrative Override" field type is not "Numeric", "PassFail" or "SelectBox". Administrative Override Grade column type is invalid. Expected "Numeric", "PassFail" or "SelectBox".
Error loading grades Validation error Global Brightspace Grade Scheme not found for subject grade mode. Grade Scheme not found for Subject Offering.
Error loading grades Validation error Global Brightspace Grade Scheme not found for "Administrative Override". Grade Scheme not found for Administrative Override.
Error loading grades Validation error No active student enrolments in Subject Offering. No enrolled students to transfer grades for.
Error loading grades Validation error Grade Mode not supported (only N or S grade modes are supported). Grade Mode not allowed for grade transfer.
Error loading grades Validation error Subject offering is inactive Subject Offering is inactive.
Error loading grades Validation error Subject has no active enrolments (where enrolment RSTS_CODE not equal to 'DD') No enrolled students found.
TRANSFER STATUS GRADE STATUS ERROR MESSAGEREASON DESCRIPTION
GRADES TRANSFERRED (OR) GRADES TRANSFERRED WITH ERRORSVALIDATION ERROR inactiveEnrolmentGradeChange Student not enrolled in subject
GRADES TRANSFERRED (OR) GRADES TRANSFERRED WITH ERRORSFAILED TO TRANSFER gradeAlreadyRolled Enrolment grade has already been rolled to history
GRADES TRANSFERRED (OR) GRADES TRANSFERRED WITH ERRORSVALIDATION ERROR finalGradeApplied Cannot override a final grade
GRADES TRANSFERRED (OR) GRADES TRANSFERRED WITH ERRORSVALIDATION ERROR AWALOverrideGrade AW/LW cannot overwrite existing grade
GRADES TRANSFERRED (OR) GRADES TRANSFERRED WITH ERRORSVALIDATION ERROR WDOverrideGrade Cannot override existing WD grade
GRADES TRANSFERRED (OR) GRADES TRANSFERRED WITH ERRORSVALIDATION ERROR overrideGradeInvalid Grade of [grade] cannot be overridden
MESSAGEDESCRIPTIONACTION
Administrative Override Grade column not found.The Administrative Override column appears to be missing from the subject site.Please contact your Faculty’s Subject Admin team.
Administrative Override Grade column type is invalid. Expected "Numeric", "PassFail" or "SelectBox".The set up of the Administrative Override column in the subject site is incorrect.Please contact your Faculty’s Subject Admin team.
AW/LW grades not permitted to be transferred.AW and LW grades are not permitted to be transferred.Please refer to Special Considerations process.
Cannot overwrite existing grade.Grade transfer can't take place because a grade already exists in Banner.If you believe this is an error, please contact your Faculty’s Subject Admin team.
Cannot overwrite existing grade.Grade transfer cannot occur at this time as there is a WD (hold) grade for the student's subject at this time.If you believe this is an error, please contact your Faculty’s Subject Admin team.
Cannot overwrite existing substantive grade.Grade transfer can't take place because a grade (PS, CR, DI, HD, AW, LW or SY) already exists in Banner.If you believe this is an error, please contact your Faculty’s Subject Admin team.
Grade already in Banner.Grade transfer can't take place because a grade already exists in Banner.If you believe this is an error, please contact your Faculty’s Subject Admin team.
Grade Mode not allowed for grade transfer.Only N (normal scheme) or S (competency scheme) Grade modes are supported.Please check in CDAP that the correct Grading Schema has been selected for this subject. 

If the correct Grading Schema is not N or S, please contact your Faculty’s Subject Admin team.
Grade not provided.Student's grade in Gradebook is blank and no grade can be transferred to Banner.Please check the grade for the student or the selected Grade Scheme in the Grading Scale field for the Final Calculated Grade/Final Adjusted Grade/Administrative Override columns.
Grade Scheme not found for Administrative Override.The global Brightspace grade scheme is misconfigured.Please contact DIT service desk.
Grade Scheme not found for Subject Offering.The global Brightspace grade scheme is misconfigured.Please contact DIT service desk.
Invalid adjusted grade.Grades within the Final Adjusted Grade column are not as expected.Please check the selected Grade Scheme in the Grading Scale field of the Final Adjusted Grade column.
Invalid administrative override grade.Grades within the Final Adjusted Grade column are not as expected.Please check the selected Grade Scheme in the Grading Scale field of the Final Adjusted Grade column.
Invalid calculated grade.Grades within the Final Adjusted Grade column are not as expected.Please check the selected Grade Scheme in the Grading Scale field of the Final Adjusted Grade column.
Multiple Administrative Override Grade columns found, expected one.Duplicate columns exist for Administrative Override in the subject site Gradebook.
Please contact your Faculty’s Subject Admin team.
No enrolled students found. Please contact your Faculty’s Subject Admin team.
Student is not enrolled.Person in the student role is not enrolled in the subject offering in Banner.Please check if this person is a genuine student within the subject offering. If you believe this is an error, please contact your Faculty’s Subject Admin team.
Subject enrolment grade mode does not match subject offering grade mode.There is a grade mode mismatch within Banner.Please contact your Faculty’s Subject Admin team.
Subject Offering is inactive.This subject cannot be graded due to an error on the subject master file.Please contact DIT service desk.
Unexpected fault. Complete the process again and if the error still occurs, please contact DIT service desk.