Exporting Grades into eTAC

Teachers can download student grades from the Canvas Gradebook as a CSV file.

While in the selected course click on “Grades” from the Course Navigation.

Click on “Export” and from the drop down select “Export Current Gradebook view” or ”Export Entire Gradebook” this will generate an editable CSV file, save this file.

If you navigate away from the page during the export, the CSV file should appear as a previous download in the Gradebook export drop-down menu so it can be downloaded again.

CSV File

Open the saved CSV file:

Right click on the “Student” column to delete it.

If this column is not deleted then you will not be able to upload scores to eTAC.

There are only two columns you will need, the SIS User ID and the assignment scores (yellow):

SIS User ID in Canvas=Student ID in eTAC

Unit Four Lecture is the assignment in Canvas

I went ahead and did “Save As” to my desktop. Make sure the file type is “CSV (Comma delimited):

Import Scores to eTAC

Login to eTAC and click on the Gradebook icon for the course you will be working on.

Select “Add Assignment” icon and fill in all applicable fields and “Save”:

You will see the assignment as a column, click on paper icon with an arrow (highlighted), this is

the “Mass Update Scores” feature:

Next click on “Import Scores From File”

File: Click on “Choose File” and find the CSV file you saved

File Format: Select “CSV”

Student ID Column Number: 2 (SIS User ID, Column B)

Score Column Number: 5 (Assignment Column E)

Select “File has Header Row”

Click on “Import”

You will see the grade’s that were imported listed under the assignment: