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:

  1. Go to _Grades _on CANVAS and click on Export

  2. Choose CSV File and download it

  3. Open the downloaded csv file with "notebook" (which is used for opening txt files)

  4. Without changing anything, click on "files" ->"save"

  5. Close the file and reopen it with EXCEL

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

results matching ""

    No results matching ""