Versions Compared

Version Old Version 9 New Version 10
Changes made by

KP

CIT Webmaster

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Note
  1. 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.

...

  1. Matriculation numbers are in this format: A, seven digits and an alphabet e.g. A1234567Z.

If you:

  1. have graded work which only has student matriculation numbers or
  2. use the bubble form system

You will need to map these matriculation numbers to NUSNET IDs as Canvas requires the NUSNET 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

  1. Go to Grades on the course navigation.

  2. Download the template. Add the matriculation numbers in column A and the respective points in column B. Leave the headers as is.

    If you are creating the CSV from scratch, please follow this format:

    Code Block
    titleSample of imported CSV file into Grades
    Student ID,CA1
A1234567B,90
A1111111C,89
A2323232E,92

Steps

  1. Go to Grades on the course navigation.
    Download the template and amend the CSV.

    Click on Once you have filled in the CSV, click Transform CSV For Import button, and upload your CSV. 
    to upload it. Please wait for the transformation to be completed. This might take a while if there are many records.

    Image Added

  2. 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.

    1. Original: test.csv

    2. Transformed: test-transformed.csv

  3. Please verify the data before proceeding to import the transformed CSV into Grades.
    Image Removed

  4. Click on Actions dropdown and click on Import. Upload your the transformed CSV.
    Image RemovedImage Added