This will only work for students' accounts. (It is not applicable for staff, visitors, and non-NUS accounts.)
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 CSV with matriculation numbers and marks, and it will transform the file 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.
Student ID,CA1 A1234567B,90 A1111111C,89 A2323232E,92
Steps
- Go to Grades on the course navigation.
- Download the template and amend the CSV.
Click on Transform CSV For Import button, and upload your CSV.
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. Please verify before proceeding to import the transformed CSV into Grades.- Click on Actions dropdown and click on Import. Upload your transformed CSV.