eClass and Canvas Support
Knowledgebase: Online Assessment > Online Assessment in eClass > Gradebook Import and Export
Importing Text Columns to the Gradebook
Last modified on 15 August 2025 11:28 AM
NOTICE: Please be advised that the content of this article may only be relevant for users concluding the final stages of course work on eClass or for users on the eClass External system. The eClass Learning Management System is currently in a read-only state that prohibits new courses, enrollments, and users from being added to the site. Credit courses and co-curricular courses at the UofA are now being delivered on Canvas, and full articles on how to use Canvas can be found here.

The eClass Gradebook does not directly allow the import of textual information into standard gradebook columns.

This article describes the workaround of importing the text into the Feedback location for a column. Common uses for this would be to import grouping information, the incorrect or scored items from a TSQS spreadsheet, or other text that you have stored in an Excel spreadsheet in CSV format. 

To import the text columns: 

  1. First, create a column in your eClass gradebook to contain this information:

    1. Clicking on the Grades tap at the top of your course page:



    2. Click the Grader report dropdown and select Import:




    3. Click 'Choose a file' and upload the CSV file with your feedback comments.

      Note: the file only needs to contain a column labelled 'CCID' and a column labelled 'Feedback'.



  2. Click Upload grades.

  3. At the Import preview, map the items from the file to your course gradebook following the instructions in the article - Importing Grades into The Grader Report.

  4. After mapping the user-identifiers (usually CCID to CCID), map the text column for import to the Feedbacks area for the correct column (under the heading 'Feedbacks' in the dropdown menu).

  5. In the 'Grade item mappings' area, match the text column on the left (the headers of columns from your imported file) to the Feedback for the grade column that you have just created. In the example below, "Feedback for Class presentation" is mapped to "Feedback for Class presentation".  



  6. Click Upload grades, then Continue to return to the Grader report.
 
Notes:
  • The text you have uploaded will not appear directly in the cells of the Grader report. With Edit mode turned on, you can click on the gear icon in the Grader report in front of the individual comment you wish to view:

You can also enter a grade here.

(163 vote(s))
Helpful
Not helpful
-->