Import of marks to Canvas gradebook for manual entries or from outside of Canvas

Owned by Grace Ocos
Last updated: 02 Apr 2024 by KPVersion comment
2 min read

 

This guide assumes that you have the NUS-IDs of your students (e.g. e0123456).

It applies to the following situations:

  1. you have moderated grades for an assignment/quiz, and prefer a new gradebook item, or

  2. you have manually keyed in marks to a spreadsheet, or

  3. you have marks downloaded from ExamSoft or applications other than Canvas.

If you want to manually import marks for existing Canvas assignments, please refer to this guide.

  1. Download this template. You will add the user list and marks to this template.
    Note: As an example, the last column is titled CA1 where you can add the marks. Do rename it to the name of your assignment before adding in the marks. The title will be used to create the Assignment with the same name.

  2. Add the list of NUS-IDs - e.g., e0123456 - under the SIS User ID, column C. You may also add the list of Names under the column titled Student, Column A.  You can download the class roster to get the list of NUS-IDs of your students.

  3. Add the marks in column G that need to be added for a specific new assignment (or) an ExamSoft assignment. The header for column G can be the name of your assignment/assessment.

    1. The list of names and userIDs can be in any order; and need not contain the entire list of names.

    2. The fields are case sensitive. Ensure that the fields (Student, SIS userID, Integration ID) all match the downloaded gradebook (CSV file) from Canvas.

    3. When using student names, ensure that you do not have two students with the same. If you do have similar names, please include the SIS userID field along with student name field.

    4. For those names for whom marks have been not added, they will be blank when imported.

    5. Go to your course > Grades > Actions > Import > Choose the file, then click Upload data.

  4. Select the assignment for which the import applies.

    1. If the assignment is not created in Canvas already, choose New assignment.

    2. Add the total points possible, then click Continue.

    3. In Canvas, all gradebook columns must be linked with a respective assignment. If you choose new assignment, a no-submission online assignment will be created for you.

  5. The list of names with marks will be displayed. You will see two columns: From and To. This is a preview of the marks allocation. If it is a new assignment, there should be no entries in the From column.

  6. Click Save Changes to accept.