D2L - Export Grade Book for Web Grading

Last Updated: 05/04/2017
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.

This tutorial is operating system independent.

Step 1

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

Step 2

Because the Registrar’s Web Grading system only accepts letter grades, you’ll first need to ensure your grade book is using a letter grades scheme. Click Schemes

Step 3

Click the checkmark in the Set As Default column for Letter Grades if you wish to use the default letter grades scheme. If you wish to customize the scheme, please see the Grade Schemes help page. When the Schemes configurations are correct, click Settings.

Step 4

Click the Calculation Options tab.

Step 5

Double check that Ungraded Items is set the way you want it. For more information, visit the Calculation Options tutorial.

We recommend you check the Automatically keep final grades updated check box. If you leave this unchecked, you will need to update the final calculated grade manually. For more information, see Calculating and Releasing Final Grades.

Save your changes and click Close to return to your grade book. 

Step 6

Click Enter Grades.

Before proceeding, we recommend reviewing your gradebook to ensure all grades have been properly entered and that final grades are calculating the way you want them to. You can pick a student and use pen, paper, and a calculator to work out their final grade by hand based on their scores. If the grade you calculate differs from the grade in D2L, you may need to double check the settings of your grade items and categories to ensure D2L is calculating the grade the way you intend. You can also enter scores for the demo student in your course, !Student !Impersonate, to see how these affect its final grade and verify everything is set up the way you want.

Step 7

Next, decide if you want to export the Final Calculated Grade or enter adjustments and export the Final Adjusted Grade. If you wish to use the Final Adjusted Grade, enter those grades and adjustments now (for information on how to do this, see Calculating and Releasing Final Grades). Otherwise, proceed to the next step.

Step 8

Click Export.

Step 9

If your course has more than one section, then under Export Grade Items For choose Sections and click Apply. Otherwise, skip to step 11.

Step 10

Choose the appropriate section of your course and click Apply. You will need to export each section individually, since the Web Grading system only allows you to upload one section at a time.

Step 11

Select Org Defined ID and Grade Scheme. Uncheck all other options.

Step 12

Under Choose Grades to Export, check either Final Calculated Grade or Final Adjusted Grade. Uncheck all other boxes. 

Click Export to CSV. A pop-up will appear with a download link to the CSV file.

Step 13

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

Step 14

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.

Step 15

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.

Step 16

In the Find what: text box type #

Step 17

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

Step 18

Scroll to the bottom of the spreadsheet and look for a line with a student ID of 999999999. This is the demo student enrolled in your course. Delete this entire line from the spreadsheet.

Step 19

Save the file in the CSV (Windows Comma Separated) format. Give your file a short name (e.g. JOUR1001-100.csv), as Web Grading can occasionally produce an error message if a filename is too long. Be sure to save the file somewhere you can easily find it (such as your desktop). Once you have saved your file, you can upload it to Web Grading.

*Note: 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 Web Grading system.

Step 20

Once you have uploaded the final grades files for each section of your course, you may want to release final grades in D2L so students can see their grades in D2L as well as MyCUInfo.

Back to top