Exporting and Importing the Gradebook

Instructors have the ability to export the gradebook to another application and also import the gradebook from that application back to eLC. 

 

Learn about:

 

Exporting the Gradebook 

D2L recommends that you set up your gradebook in eLC even if you want to enter grades in a .CSV or .XLSX file. You can then use the Export Grades option to create an appropriately structured file.

 

The following outlines the steps to export your completed Grade Book from eLC as either an .XLSX (MS Excel) file or a .CSV (Comma Separated Value) file that can be opened in Microsoft Excel or other spreadsheet programs.

 

First, navigate to the desired course and select Grades from the course navbar. 

 

exporting-the-gradebook-01

 

Select the Enter Grades tab from the grades navigation menu.

 

exporting-the-gradebook-02

 

Click the Export button.

 

exporting-the-gradebook-03

 

Select the items you wish to export. You may include Org Defined ID (CAN student identification number), Username (MyId), grade values, user details, and group membership. You may export grade items for all users or groups by selecting the desired option from the drop-down menu and clicking Apply.

 

exporting-the-gradebook-04

 

Choose the specific grade items you wish to export. To export all items, select the box above the list of grade items.

Export options for Athena: When exporting a gradebook for upload to Athena, select only the following: Org Defined ID, Grade Scheme, and either Final Calculated or Final Adjusted grade.

 

exporting-the-gradebook-05

 

Select the appropriate export file type by clicking either Export to CSV or Export to Excel.

 

exporting-the-gradebook-06

 

A pop up window will appear with a link to your exported Grade Book. Click the link to download the file to your computer, then click the Close button to return to your course.

 

exporting-the-gradebook-07

 

You can learn more about preparing and exporting your gradebook for Athena on the Calculating and Releasing Final Grades page.  

Back to Top

 

Importing the Gradebook

You can enter grades in another application and import them into eLC using a .CSV or .XLSX file. 

 

The following outlines the steps to import your completed Grade Book as either an .XLSX (MS Excel) file or a .CSV (Comma Separated Value) file that can be opened in Microsoft Excel or other spreadsheet programs to eLC.

 

First, navigate to the desired course and select Grades from the course navbar. 

 

exporting-the-gradebook-01

 

Select the Enter Grades tab from the grades navigation menu.

 

exporting-the-gradebook-02

  

Under Enter Grades, click Import.

 

Click Import.

 

Under Import Grades, click Choose File to choose .csv file. 

Note: If you are using a Mac, make sure you have saved your CSV file as a Windows CSV. Additionally, it is important to keep a backup copy of the file before importing anything. 

 

Click Choose File

 

Select file and click Open.

 

Click Choose File.

 

If you have already created grade item in eLC for the items on your import file, they will self populate. If you have not created Grade Items for these items, select Create new grade item when an unrecognized item is referenced.

Note: If you want to enter grade information using Excel, we recommend creating all of your grade items in eLC first, THEN exporting your gradebook to Excel and adding grade information. This ensures that all the appropriate header information is there when the CSV file is imported back into eLC.

 

Click Continue.

 

Click Continue

 

If no errors, click Continue. If errors occur, review sample import.

 

Click Continue

 

Preview imported grades and click Import.

 

Click Import.

 

When your grades have finished importing, an Imported Successfully message will then appear.

 

An Imported Successfully message will then appear.

 

Back to Top

 

Troubleshooting

What if I get an error message?

The following steps detail various options to pursue if you recieve an error message:

  • Create your grade items in eLC FIRST, and then export the CSV file. This will ensure that all appropriate header information is in the file.
  • Check all headings in Row 1 for accuracy including OrgDefinedID. Make sure all spaces, caps and symbols are accurate.
  • Check all grade item headers for Points Grade suffix.
  • Check last column for End-of-Line indicator and #.
  • Review the sample import on the import grades page. 

 

Back to Top