(last updated on 22 March 2024)

• Part 1: Export Grades from Canvas
• Part 2: Modify exported Grades in Microsoft Excel
• About i-Assessment

Part 1: Export Grades from Canvas

1. Click the Grades link from the course navigation;
   
2. Click the Export button (select "Export Entire Gradebook" or "Export Current Gradebook View") to download the CSV file to your computer.
   

Note: Please download two copies of the CSV files, one for modification and the other as a backup.

Part 2: Modify exported Grades in Microsoft Excel

You can Edit Scores on the exported CSV file in Microsoft Excel, then Upload Scores to Gradebook of the Canvas course. Please read the below Canvas instructions.

• How do I export grades in the Gradebook?
  • Edit Scores
• How do I import grades in the Gradebook?

If you are preparing to upload scores to i-Assessment, please follow the next steps.

3. On the exported CSV file in Microsoft Excel, input the calculated CA (Continuous Assessment) and/or Exam scores if necessary;
   
   
   
4. To change the CSV file to the acceptable format for i-Assessment,
   
   • remove unnecessary columns, keep "SIS User ID" and the score columns to be imported;
   • remove two rows which have no student record (between the header row and the first student record row);
   Note: If auditing students exist in the CSV file, please remove their records before importing the file to i-Assessment.
   
   
   
5. Rename the header cell variables,
   
   • change [SIS User ID] → [Student ID];
   • confirm the scores to be imported as [CA] and/or [Exam];
   
   Below is the result example:

   Student ID	CA	Exam
   5XXXXXXX	92.7	91.5
   5XXXXXXX	89	87.91
   5XXXXXXX	75.28	62.25

   (remark about scores: up to 2 decimal places are allowed when importing to i-Assessment)
   
   
   
6. Save the CSV file [Save as type: CSV (Comma delimited) (*.csv)].
   

About i-Assessment

• To upload the modified CSV file, please click the Import icon button from the top menu navigation in i-Assessment.
  Note: Only the CA and Exam grades can be imported to i-Assessment. Other columns (i.e. Online Exam, Final Mark, Final Grade) are unavailable for the grade import using CSV files.
• To access the user guides in i-Assessment, please click the Help icon button from the top menu navigation.
• If you have questions about i-Assessment, please contact the following offices.
  • ARRO for undergraduate programmes/degrees/courses
  • SGS for postgraduate programmes/degrees/courses
• More information about i-Assessment is located on the Information Technology Services website.
  • Grade Reporting (i-Assessment)