Load Grades from a CSV File

On the Import Grades page, there are two options to enter grades into the DukeHub grade roster: Import Grades from Canvas and Loading Grades from a CSV file. This guide shows how to Load Grades from a CSV file.

Navigate to the Import Grades page.

Arrow Pointing to Import Grades
Import Grades with numbered icons 1 to 4
  1. Grades Template: Download an Excel file of the DukeHub grade roster
  2. Load Grades: Accepts a CSV file of the grades template and enters the grades onto the DukeHub grade roster
  3. Status: Grade roster’s submission status
  4. Grade Roster: Navigate to the Grade Roster page in DukeHub 

Select the Grades Template icon. 

Import Grades with Grade Template Icon Highlighted with a box

An Excel file will download from the web browser. The file contains student ID numbers, names, admit term, expected graduation term, grading basis for the class and a column for their course grades. Instructors only need to enter grades into the COURSE_GRADE column. Once all grades have been entered, save the file in a .CSV format. 

CSV with Course Grade Highlighted by Box. Column is Empty.
CSV file with Course Grade Highlighted
File Saved as CSV

 

Select the Load Grades icon. Next, select the CSV file of the grades template that has been saved with grades entered. 

Import Grades Load Grades Icon Highlighted with a Box
Saving File as CSV

When the loading process is complete, a Loading Grades Results* window will appear with a summary of the transaction. Review the message and continue. 

Load Grade Results

Next, from the left-hand menu, navigate to the Grade Roster page. Expand the row for the class for which you are entering final grades, and select “View Details” by the appropriate grade roster type. 

Grade roster with arrow towards view details

Verify that grades were loaded as expected. From this page, you can enter missing grades and correct mis-entered grades, if needed. 

Grade Roster page with a box highlighting the filled in grades

The loading grades process will only enter grades onto the DukeHub grade roster. 

Select “Submit Grades (1 Of 2)” to submit the partial or full grade roster. Click “Continue” in the Submit Grades message window. 

Submit Grade Finalize Roster 1 of 2 with Cancel and Continue Buttons

Select “FINALIZE ROSTER (2 Of 2)” once all grades are entered to submit the completed grade roster for posting. Select “Continue” in the Finalize Roster message window. The grade roster Approval Status will change to All Grades Submitted. Grades will be posted to student records within one hour. The Edit/Enter grades button will no longer be available once grades have been submitted for posting.

Submit Grade Finalize Roster 2 of 2 with Cancel and Continue Buttons

 

Loading Grades Results Example with numbers 1 to 6
  1. Grade roster count from import file: Number of students on the CSV file
  2. Student grades successfully transferred: Number of grades loaded to the DukeHub grade roster
  3. Students not found in DukeHub: Number of students on the CSV file but not on the DukeHub grade roster and they do not exist within DukeHub
  4. Students not found on DukeHub grade roster: Number of students listed on the CSV file but not on the DukeHub grade roster, though the students exist within DukeHub
  5. Student grades failed to transfer: Number of grades that were not loaded to the DukeHub grade roster
  6. Students with blank grades in the import file: Number of students with no grade entry in the CSV file

When using the Loading Grades function, the final grade template will only contain information for students enrolled under one class title and will not display all students enrolled across all cross-listed titles. You will need to download a template for each class.