NOTE: Before following the steps below, you should format your D2L gradebook with a Grade Scheme that converts your grades to a 4.0 scale. Here is an example:
From Grades, select Schemes and click on New Scheme to create a new grading scale.
NOTE: Reduce each minimum percent (Start % column) by 0.5 if you would like to allow for rounding.
From Manage Grades, edit the Final Calculated Grade and/or Final Adjusted Grade, and select the 4.0 Grade Scheme to display. You can also select items from the Manage Grades list and use Bulk Edit to change the displayed Grade Scheme for any given item. Most important is to display a 4.0 Grade Scheme for the final grade columns.
If you need to change any of the grades in D2L, you can transfer scores to the Adjusted Final Grade and make changes to the Numerator.
Note: You may select Export to CSV (comma separated value) or Export to Excel. Either file will open in Excel. The CSV file is preferred if you plan to make changes offline that can later be imported back to D2L Grades.
*Instructions for using VLOOKUP in Excel can be found here: Exporting Grades from D2L into the Registrar Using VLOOKUP