D2L - Export Grade Book for Web Grading

Last Updated: 05/06/2014
Back to: D2L - Grades
Layout:
One Column
Two Column

Overview

The following documentation demonstrates how to export your final grade book and format the .CSV file for upload into the Registrar's web grading system at the end of the semester. The Registrar's web grading system only accepts letter grades for students, so a change to the Letter Grades grading scheme may be necessary. To learn more about Grade Schemes please visit the Understanding Grade Schemes page.

This tutorial is operating system independent.

To change your courses grade scheme to Letter Grades:

  1. Click on Scheme from the Grades area.
  2. Click on the faded check mark in the Set as Default column of the Letter Grades row.

*NOTE: Be sure to double check that values for Letter Grades are consistent with the values you decide for your course (e.g. A = 94%-100%). To learn how to create your own custom grading scheme visit the Understanding Grades Schemes page.

Step 1

Log into your course and from the Assessments drop-down menu click on Grades.

Visual representation related to step 1

Step 2

Click on Enter Grades

Visual representation related to step 2

Step 3

Click on Export.

Visual representation related to step 3

Step 4

For the Export Options only select:

  • Org Defined ID
  • Grade Scheme
Visual representation related to step 4

Step 5

Choose either Final Calculated Grade or Final Adjusted Grade (if you have manually entered adjusted grades).

Visual for step 5

Step 6

Click on the Export to CSV button.

Visual for step 6

Step 7

A new window will appear and display a link. Click on the link to download the file and save in a location on your computer.

Visual representation related to step 7

Step 8

Open the .CSV in Excel.

Step 9

Select all of the End-of-Line Indicator column, right click and select Delete.

Visual representation related to step 9

Step 10

Select all of the first row, right click and select Delete. The file cannot contain a header row, only Student Ids in column A and a Roster Grade in column B.

Visual representation related to step  10

Step 11

Next the # sign must be deleted from the Student ID column. To do this for all IDs click on the Edit drop-down menu and select Replace.

*Note: For Windows users, with Office 2010, click on the Find & Select (binocular icon in Home tab) drop-down menu and select Replace.

Visual representation related to step 11

Step 12

In the Find what: text box type #

Visual representation related to step 12

Step 13

Do not put anything in the Replace with: column and click the Replace All button.

Visual representation related to step 13

Step 14

Save the file in the CSV (Windows Comma Separated) format. Give your file a short name (e.g. JOUR1001-100.csv), as upgrade (Web Grading) can occasionally produce an error message if a file name is too long. Once you have named your file you can upload it to upgrade (Web Grading)

*Notes:

  1. If you have Impersonatable Students in your D2L course, their corresponding row should be deleted as well. This will eliminate an error message that appears when attempting to upload course grades. Learn more by visiting OIT's End of Semester Best Practices page.
  2. Make sure that the file format of your saved file is in the Windows CSV format and not in the CSV Macintosh or CSV MS-DOS. Only a Windows CSV will be accepted by the upgrAde (Web Grading) system.

Was this helpful?

Back to top