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 simply 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.
Note that this will only work for students accounts. (Thus, it’s not applicable for staff, visitors and non-NUS accounts.)
Sample of imported CSV file into Grades
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. It will download the transformed CSV.
- Click on Actions dropdown and click on Import. Upload your transformed CSV.