This guide assumes that you have the NUSNET IDs of your students (e.g. e0123456).
It applies to the following situations:
- you have moderated grades for an assignment/quiz, and prefer a new gradebook item, or
- you have manually keyed in marks to a spreadsheet, or
- 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.
- Download this template. You will add the user list and marks to this template.
- Add the list of NUSNET IDs - e.g., e0123456 - under the SIS User ID, column C.
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.
The list of names can be in any order; and need not contain the entire list of names. For those names for whom marks have been not added, they will be blank when imported.
- Go to your course > Grades > Actions > Import > Choose the file, then click Upload data.
Select the assignment for which the import applies.
If the assignment is not created in Canvas already, choose New assignment.
Add the total points possible, then click Continue.
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.
- 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.
- Click Save Changes to accept.