Solution Detail

Question

How do I transfer grades from Sage Vantage to Blackboard?

Solution

Export Your Vantage Gradebook

Navigate to the Gradebook area in your Vantage course.

This image highlights the location of the Gradebook in your Vantage course.

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

This image shows the location of the gradebook Filter option in Vantage.

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

In this example, the checkboxes for "Chapter Tests" and "Points" are ticked.

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

The location of the Download button is highlighted.

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

The download options are shown with the option to "Download only grades currently filtered in gradebook (.csv)" highlighted.

Save the file to your computer.

Export Your Blackboard Gradebook

The method to upload or download grades depends on which version of Blackboard you are using. Follow the link for your version of Blackboard to see the instructions.

· Original Blackboard Learn https://help.blackboard.com/Learn/Instructor/Grade/Grading_Tasks/Work_Offline_With_Grade_Data

· Blackboard Ultra
https://help.blackboard.com/Learn/Instructor/Grade/Grading_Tasks/Work_Offline_With_Grade_Data#ultra_download

Combine Your Grades

Open both your Vantage and Blackboard export files.

Your Vantage export file will show:

This image highlights information in the export file: A. Student first and last names, B. Exported assignment columns, C. Student grades.

A. Your list of students in columns A and B

B. Your exported Assignments, starting in Column D. The points possible is the number next to the assignment name.

C. Student Grades

Next, match up your Vantage Gradebook with what you exported from Blackboard.

Here is information to match up between your Vantage and Blackboard gradebooks: A. Number of students, B. Column titles, C. Grade columns, D. Paste the grades from the Vantage to the Blackboard gradebook.

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

B. Change the column title from the Vantage format to the required Blackboard format. You can leave the item name the same, or edit it, if you wish. The points possible in Vantage is listed in parenthesis.

For example, if Knowledge Check 1.1 is worth 2 points, it looks like this:

Knowledge Check 1.1 (2)

In Blackboard, this title becomes:

Knowledge Check 1.1 [Total Pts: 2 Score]

C. Grade columns exported from Blackboard have metadata attached. If you already have the grade columns you need created in Blackboard, then you will copy and paste the grades from the Vantage export into the correct columns in the Blackboard export. If you need to add columns to your Blackboard gradebook, you can add them by typing or pasting in the name of the grade in row 1, as well as the points possible in row 2. You do not need to worry about adding metadata.

D. Once you have organized the columns and rows to match between the two spreadsheets, you can copy and paste all the grades from the Vantage export into the Blackboard export.

Save your changes.