How do I export grades from Gradebook?

Instructors can obtain a file in the proper import format by exporting from Gradebook and using that file as a template.  By exporting directly from Gradebook, the file will contain all of the student information in your site, as well as any existing gradebook item information.  

Use the exported file for offline management of grades OR for quickly creating several gradebook items at once.   For more information on importing, please see How do I format my file for importing grades into Gradebook?

Go to Gradebook.

Select the Gradebook tool from the Tool Menu of your site.

Click Import/Export.

Click Export Gradebook.

The exported file will download to your local computer.

Sample spreadsheet.

The spreadsheet contains columns for:

  1. Student ID
  2. Student Name
  3. Two columns for each item added:
    • Grades: Total point value is in square brackets after the item title, e.g., Mid-Term Exam [100]
    • Comments: Item title is preceded by an asterisk (*), e.g., * Mid-Term Exam.

Select Custom Export. (Optional)

Select Custom Export. (Optional)

Click the Custom Export to create a formatted spreadsheet which includes columns to be used for the Final Letter Grade Import.  

Choose the items you would like to include in your export.

Choose the items you would like to include in your export.

From the list, select the items you would like to include in the spreadsheet.  Student Name, Student ID, Gradebook Item Scores and Gradebook Item Comments are selected by default.

Grade Override(s) has to be selected if the spreadsheet will be used for Final Letter Grade Import.

Click Download Custom Export.

Click Download Custom Export.

Sample custom spreadsheet.

With all options selected, the custom spreadsheet contains columns for:

  1. Student ID
  2. Student Name
  3. Two columns for each item added:
    • Grades: Total point value is in square brackets after the item title, e.g., Week 1 Quiz [100]
    • Comments: Item title is preceded by an asterisk (*), e.g., * Week 1 Quiz.
  4. Calculated Course Grade - numeric
  5. Course Grade - letter grade
  6. Grade Override(s) - The heading for the Grade Override(s) column will have the Grading Type for the roster added to the site.  In this example, it is UG-GRD which represents an undergraduate graded roster.  UG = Undergraduate and GRD = graded.  
  7. Last Log Date - last date Grade Override information was modified.

A Grade Override(s) column will be created for each different Grading Type added to the site.  For example, if you have added an undergraduate roster and a graduate level roster to the same site, two Grade Override(s) columns will be exported, UG (Undergraduate) and GRA (Graduate).