How do I transfer grades from Vantage to Moodle?

Modified on Thu, 3 Oct at 2:36 PM

TABLE OF CONTENTS

1. Navigate to the Gradebook area in your Vantage course.

2. Add Grade Columns to Your Moodle Gradebook

3. Export Your Moodle Gradebook

4. Combine Your Grades

4. Import Your Grades to Moodle

To transfer grades from Vantage to Moodle, you will first need to export your Vantage gradebook.

1. Navigate to the Gradebook area in your Vantage course.

Gradebook is on the bottom left of your course tile.

You can filter the gradebook to show only the grades you want to transfer to your Moodle course.

Start by selecting the Filter button near the top right of the page.

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

Choose Chapter Tests within Assignment Types and then Points within "show grades in."

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

Download is in the menu bar on the top left hand side of the screen.

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

Save the file to your computer.

2. Add Grade Columns to Your Moodle Gradebook

You need to create the gradebook columns in your Moodle course before you can import them. To create the gradebook columns, you will also need to know the total point value for each item you want to include in the gradebook. The default point value for a Chapter Test in Vantage is 15 points.

It is not necessary to create gradebook columns for Vantage assignments unless you have assigned them for a grade. If you have assigned any of these assignments for a grade, you can use the gradebook you exported from Vantage to get the maximum point value. The column names include the total point value in parentheses.

In the file, the column marked as "CT" are the Chapter Test grades, and the number 15 is shown in parentheses to indicate that is the total amount of points for the tests.

To add gradebook columns in your Moodle course, go to Grades in the left navigation panel to view the gradebook.

In the Gradebook, go to the Setup tab.

Select Add Grade Item at the bottom of the page to create a gradebook column.

Complete the information for the Grade Item.

A. In the "Item name" field enter the name of the activity or assessment you want to import from Vantage.

B. Enter the Maximum grade in that field. For Chapter Tests, the default maximum point value is 15 points.

C. Leave the Minimum Grade field set to the default value of 0.00.

In the same window you add the Chapter Test and review Maximum and Minimum grade values, select the Save Changes button at the bottom.

Save changes. Your new grade item will display in the list. Repeat this process to add all Vantage grade items that you want to import to Moodle.

3. Export Your Moodle Gradebook

Once you've added the grade columns, you can export the gradebook from Moodle. In your gradebook setup, go to the Export tab.

Export is the last option on the right in the menu.

Next, choose the Excel spreadsheet format.

If you do not see the list of gradebook items, open the Grade items to expand the list. All grade items are checked by default. Make sure all grade items you created for Vantage are checked. You can de-select the boxes for any other graded items you may have in your course.

Once you've made your selections, Download.

Depending on your browser's settings for file download management, the file may save directly to your computer or you may have the option to open directly in Excel.

4. Combine Your Grades

Open both your Vantage and Moodle export files. The Vantage export file will show:

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 Moodle.

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

B. Change the column title from the Vantage format so it matches the same item in the Moodle format. For example, in the Vantage gradebook, the title for Knowledge Check 1.1 worth 2 points, looks like this: KC 1.1 (2)

Change the column to title to match the same name of the grade item created. So if you created the gradebook column as "Knowledge Check 1.1," you would change the column in the Vantage gradebook export to match.

C. Grade columns exported from Moodle have metadata attached. If you already have the grade columns you need created in Moodle, then you will copy and paste the grades from the Vantage export into the correct columns in the Moodle export. If you need to add columns to your Moodle gradebook, you must first add those gradebook items to Moodle then create a new gradebook export. The Moodle export file does not allow any column changes.

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 Moodle export.

Save your changes as a .csv file (comma separated value). If you have the option to save as CSV UTF-8, choose that option. If you do not see the CSV UTF-8 option, the general Comma Delimited .csv is an okay substitute.

5. Import Your Grades to Moodle

In your Moodle gradebook setup, go to the Import tab.

Import is between Letters and Export in the menu.

You can drag and drop your file into the File box or click "Choose a file" to navigate to the spreadsheet you saved. Select Upload Grades to continue.

You will have the opportunity to preview the users and grades you are importing.

Students will be listed with their email addresses and each Chapter Test grade in columns to the right.

Complete the "Identify user by" section. "Map from" corresponds to a user identification column in the spreadsheet. "Map to" refers to user identification within the Moodle class roster. These options tell Moodle how to correctly pair user data in the spreadsheet to the respective students in the Moodle gradebook. The mapping type must be the same in both the "Map from" and "Map to" dropdowns.

In this example, we use the email address as the identifier.

In the "Grade item mappings" section map each grade item from the spreadsheet to its matching grade item in the Moodle gradebook. These mappings will be a one-to-one match since the spreadsheet values originally came from your Moodle gradebook. Choose "Ignore" next to the item to create the mapping.

You can leave all other values to "Ignore." Once you have mapped each grade item, Upload grades.

Once the import process completes, Moodle will let you know if it succeeded or encountered errors. If an error is encountered, Moodle will provide a message about what caused it. Once you adjust the item that caused the error, you can import the file again.

Return to the View tab to verify the grades imported successfully.