| Note |
|---|
|
...
The current bubble form system only has students' matriculation numbers. However, Canvas requires the NUSNET ID. As such, teachers will have to map the student numbers to NUSNET id in order to import marks to Canvas gradebook for manual entries or from outside of Canvas.
With this "Transform CSV For Import" functionality, teachers can modify and upload the
|
If you:
have graded work which only has student matriculation numbers or
use the bubble form system
You will need to map these matriculation numbers to NUS-IDs as Canvas requires the NUS-IDs to import marks to Grades.
Using Transform CSV For Import, teachers can upload a CSV with matriculation numbers and marks, and it will transform the file CSV into the format that Canvas needs. When using this functionality, please ensure that your imported CSV is in the below format. You may also download the template.
...
Steps
Go to Grades on the course navigation.
Download the template. Open it and add your students' matriculation numbers in column A and the respective points for the assignment in column B. Leave the headers as is. You may update CA1 to the title of your assignment.
If you are creating the CSV from scratch, please follow this format:Sample of imported CSV file into Grades
Code Block Student ID,CA1 A1234567B,90 A1111111C,89 A2323232E,92
Steps
...
Once you have filled in the CSV, click Transform CSV For Import
...
to upload it. Please wait for the transformation to be completed. This might take a while if there are many records.
There will be a message to say that it has downloaded the transformed CSV. The transformed CSV will have the original filename appended with transformed e.g.
Original: test.csv
Transformed: test-transformed.csv
Please verify the data before proceeding to import the transformed CSV into Grades.
...
Click
...
Import. Upload
...
the transformed CSV.
...
