Export grade
It is very obvious to see when entering into Grades,there’s a function called Export
, making it possible for TAs to export grades from Canvas. However,Canvas's Chinese characters decoding system is not well-constructed, therefore for Chinese names, they may not be displayed correctly if TAs just open the csv files downloaded from CANVAS directly.
To solve this problem, here is one approach to export grades from Canvas into Excel file with correct Chinese names:
Go to _Grades _on CANVAS and click on
Export
Choose CSV File and download it
Open the downloaded csv file with "notebook" (which is used for opening txt files)
Without changing anything, click on "files" ->"save"
Close the file and reopen it with EXCEL
In the EXCEL file, click on "files" ->"save as", choose xls or xlsx and then save it
Then the Chinese names may be seen being displayed correctly in the xls/xlsx EXCEL files (sometimes, the csv file becomes good as well).
However, these files cannot be imported back to Canvas again.