How do I upload my final grades?

Woman filling in a form on a computer

Last updated: August 23, 2024

On this page:

Troubleshooting


Prepare your roster for upload

Make sure:

  • You have an up-to-date class roster at your disposal. View instructions to download your class roster.
  • Grades are assigned to the correct student. The names on a LEARN class roster may be displayed in a different order than the Quest roster used to upload grades.
  • There are no blank grades.
  • The header row is removed.
  • Numeric grade values are 0 to 100, without decimals.
  • Entered grades match the course's grading basis, i.e., a grading basis of NUM must have a grade entry of 0 to 100; a grading basis of CNC must have a grade entry of CR or NCR.
  • You have entered only allowed non-numeric (alpha) grades, and in upper-case characters: CR, DNW, INC, IP, NCR, NMR.
    • Note: You may NOT submit the following grades: AEG, AUD, FTC, MM, NG, UR, WD, WF.
      • Grades of WD or WF: If you see these on your roster, no action is required and no grade change will be permitted. They are assigned if a student withdrew from the class after specific drop deadlines.
      • Grade of UR: Leave the grade blank and disregard the subsequent error stating that "this grade is not a valid entry". It is assigned by the Registrar's Office or Graduate Studies and Postdoctoral Affairs following directions of the Associate Dean.
      • Grade of AUD: Leave the grade blank and disregard the subsequent error stating that "this grade is not a valid entry". It is assigned by the Registrar's Office or Graduate Studies and Postdoctoral Affairs following directions of the instructor. If you wish to submit a grade of AUD, or if a student has failed this audited course, please submit a support request (for an undergraduate course) or email gso.grades@uwaterloo.ca (for a graduate course) with the following information:
        • Student name and ID number.
        • Course details: subject, catalog number, and section number.
        • Indicate that the student should receive an AUD, or indicate that the student failed the audit.

Instructions 

  1. Sign in to Quest.
  2. Select theUpload Grades tile.
    Upload grades
  3. Select the Step 1 of 4 link - Select a Grades File to upload.
    Upload My Final Grades screen in Quest.
  4. Search for the appropriate .csv file using Choose File and then selectUpload.
    Image of attach fiel box in Quest.
  5. An Upload Successful note should appear at the bottom of the page.
    Upload successful message in Quest.
  6. Select the Step 2 of 4 link - Process the Grades file.
    Process grade file in Quest.
  7. The "Pre-Edits" page is used for reviewing your uploaded grades file. You can review transactions by type (accepted, failed, all) by selecting the desired filter using the Filter Results By drop-down list.
  8. When you're ready to submit the grades, select Submit this Grades file.You'll receive the first of two automatic notification of grade submission email messages. You'll also see a "Submission Complete" screen, with a batch number, letting you know that the submission is complete. You can select Upload My Final Grades to upload another grade roster.

  9. Once your grades have been posted on Quest, you'll receive a second "notification of grade action" email message. With this second email message, a class roster will be attached with the grades that you've submitted. Open the attachment to verify your submission.

Transaction results

Accepted transactions

A checkmark in the "Accepted" column on the left indicates that the grade has been accepted. An unmarked checkbox indicates an error (see Failed transactions below).

Accepted transactions in Quest.

Failed transactions

An unmarked checkbox indicates an error. Refer to the "Messages" column to review the error and click on the link to identify a solution.

Failed transactions in Quest.

Error messages

Select Return to return to the "Pre-Edits" page. Then select Submit this Grades file(will submit all successful transactions) or select Cancel and Re-Submit(will not post successful transactions). You can upload your final gradesuntil you're able to submit your grades file successfully.

Resolving error messages
Go back to your original saved data file to adjust your grades (current grading system). If you have error(s) that you can't resolve, submit a support request.

Possible reasons for errors and the solutions

Error Solution
You are trying to submit a grade for a student that is not properly registered in your course. Generate a new class roster to verify that the student is no longer registered in your course.
The grade is blank. Enter a grade.
The grade contains a decimal point. Remove the decimal. For example, change 67.8 to 68.
The grade value is greater than 100. Choose a grade between 0 and 100.
The grading basis for this student does not match the entry; it is found on your downloaded Class Roster. A grading basis of NUM must have a grade entry of 0 to 100.
A grading basis of CNC must have a grade entry of CR or NCR. Note: All alpha characters must be upper case.
You may not submit the following grades: AUD, AEG, FTC, MM, NG, UR, WD, WF Leave the grade blank and disregard the subsequent error stating that "this grade is not a valid entry."

If you are trying to submit a grade for a student and your file has a header row, you are receiving this error:

Invalid Catalog format. Format should be in the form of 'nnnnxxxxxx' where nnnn is zero to 4 leading numeric positions. The PeopleCode program executed an Error statement, which has produced this message.

Remove the header row from your Excel file.