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.
Log into your course and from the Assessments drop-down menu, click on Grades.
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.
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.
Click the Calculation Options tab.
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.
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.
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 Entering Adjusted Final Grades). Otherwise, proceed to the next step.
If your course has more than one section, then under Export Grade Items For choose Sections and click Apply. Otherwise, skip to step 11.
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.
Select Org Defined ID and Grade Scheme. Uncheck all other options.
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.
Open the .CSV in Excel. Select all of the End-of-Line Indicator column, right click and select Delete.
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.
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.
In the Find what: text box type #
Do not put anything in the Replace with: column and click the Replace All button.
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.
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.