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.
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.
Double check that Ungraded Items section 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.
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.