Export Your Vantage Gradebook

Navigate to the Gradebook area in your Vantage course.

You can filter the gradebook to show only the grades you want to transfer to your D2L course. Start by clicking on the Filter button near the top right of the page.

Choose the Assignment Types you want to have grades for in D2L. Most courses are set up so only the Chapter Tests have grades. Under "Show grades in," tick the checkbox for Points, then click Apply.

Once the gradebook is filtered to the grades you want to export, click the Download button.

Select the option to Download only grades filtered in gradebook (.csv).

Save the file to your computer.

Export Your D2L Gradebook

The information provided here on D2L functionality is current as of the time of this writing. For additional information on exporting and importing grades in D2L, the following resources may be helpful:

Export Grades

Import Grades

In the top navigation menu of your course, go to Grades. Next click Export.

Make the following selections:

·       Under Grade Values, select Points grade.

·       Under User Details, include at least the Last Name and First Name.

·       If you have already created grade columns for your Vantage grades, you can choose to export them. Otherwise, do not export any grades.

Once your selections are made, click the Export to CSV button.

Combine Your Grades

Open both your Vantage and D2L export files.

1.      Make sure you have the same number of students in both courses. If you have more students in Vantage than in D2L, you can delete the rows with extra students from the Vantage export file. If you have more students in D2L than in Vantage, you can add empty rows in the Vantage export to where the extra students are in D2L.

2.      Copy the grade columns you want to import to the D2L file.

3.      Change the column title from the Vantage format to the required D2L format. You can leave the item name the same (or edit it, if you wish), but replace the points value from Vantage (in parentheses) with "Points Grade."

4.      Add a column at the end that says "End-of-Line Indicator." Add a hashtag (#) in each row of this column.

Save the file in a comma separated values format (.csv).

Note: Excel offers a variety of files with the .csv extension. Be sure to choose the one that says "comma separated values."

Upload Your Grades to D2L

To upload the new grades, in the top navigation menu of your course, go to Grades. Next click Import.

In Step 1, make the following selections:

·       Click Choose File to navigate to your file.

·       Under "Item Creation," tick the checkbox to Create new grade item when an unrecognized item is referenced.

·       Click Continue.

In Step 2, set all new grade items to Numeric, then click Continue.

In Step 3, update the Maximum Points for each item. By default, Chapter Tests are always worth 15 points in Vantage. Once you have entered the points for each item, click Next to continue through the confirmation screen. Your Vantage grades should now appear in D2L.