CIITS Help Docs

Exporting Grades From eCourses to Panthertracks

Updated on

The process to move grades from Canvas to Panthertracks requires four steps,

  1. Export gradebook from eCourses
  2. Export gradebook template from Panthertracks
  3. Copy grades manually between the spreadsheets
  4. Import the grade template into Panthertracks

STEP 1: EXPORT GRADEBOOK FROM eCOURSES

  1. Click on Grades in the Canvas Menu
Grades on Cavas Menu Screenshot
  1. Click 3 Vertical Dots next to Name
  2. Sort by Name
  3. Order A-Z
eCourses Gradebook Sort by Name Screenshot
  1. Click Export
  2. Select desired Export Type
Gradebook - Fall2024_PSYC2316P01-2510-12282 - Google Chrome
  1. Save Export File
Gradebook - Fall2024_PSYC2316P01-2510-12282 - Google Chrome
  1. Open Spreadsheet
2025-04-14T1642_Grades-PSYC2316P01-2510-12282 - Excel

Final Grade is the student view of the final grade if assignments are graded but still hidden from students.

Unposted final grade is the grade calculation with hidden grades used in the final calculation.

If adjusted grades are used, an adjusted grade column will be included in the export.  To enter adjusted grades refer to the Canvas Guide on Adjusted Grades.

If all grades have been released to students, Final Grade and Unposted Final Grade will match.

STEP 2: EXPORT GRADEBOOK FROM PANTHERTRACKS for FACULTY

  1. From Panthertracks for Faculty, Click Enter Midterm and Final Grades
Faculty Services Dashboard - Google Chrome
  1. Click on button next to class desired for import (Not Started or In Progress)
  2. Scroll down to verify names are present and match expected class

Maximize browser to see student names when scrolling down.

  1. Click the Gear icon next to your name at the top right of the screen
  2. Click on Export Template
Export template Screenshot
  1. Select file format desired
  2. Click Export
Faculty Grade Entry - Google Chrome

Final Grade and Last Attended Date Columns need additions.  All other column should be left as exported.  Last Attended Date only needs a value for FN grades.

202520_Criminal Justice_2345_Z01_Template  -  Compatibility Mode - Excel

STEP 3: MANUALLY COPY GRADES BETWEEN SPREADSHEETS

Grades can be copied from the correct final grade column (final, unposted or adjusted) in the eCourses Spreadsheet to the Panthertracks export template.

  • Provided sorting is done from A--Z in eCourses
  • Remove any withdrawn students rows from the Panthertracks documents.  Withdrawn students are not present in eCourses gradebook.
  • Spot check grades to verify no issues with grade alignment between both spreadsheets
  • Occasionally names may not be sorted the same way in both spreadsheets, check to verify before copying grades over.
    • This is common with students who have more than 1 first or last name.

STEP 4: IMPORT GRADE TEMPLATE INTO PANTHERTRACKS

  1. Click on Gear
  2. Click on Import

If Export Template and Import are grayed out, a course is not currently selected.

Faculty Grade Entry - Google Chrome
  1. Click Browse and locate file (not shown below - file is present in image)
  2. Click Upload
  3. Click Continue
Import Screenshot
  1. Preview File to confirm correct sheet was uploaded
  2. Click Continue
Preview Screenshot

Import Mapping will not be necessary if no spreadsheet modifications have been made since

  1. Click Continue
Improt Screenshot

Read the validation summary at the top of the screen.

Validate Screenstep

Even if no errors it is good practice to download and review the validation report.

Faculty Grade Entry - Google Chrome

Validation report shows which rows were not imported due to errors or if no data was in the row.

202520_Criminal Justice_2345_Z01_Template_Validation_Report  -  Compatibility Mode - Excel

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Previous Article Adding Outcomes to Rubrics
Next Article Setting Up Group Weights in eCourses (as opposed to points system)
Want Help from a Human? Contact Us