This article covers how to export grades from Rouxbe and import them into another 3rd party service. For this tutorial we will be using Canvas as the example of our 3rd party service. Canvas is used quite extensively by schools and has many useful tools, such as the ability to import grades from a CSV file. This will allow you to integrate Rouxbe grades into your Canvas courses.
All 3rd party services have their own data structures and requirements. Most services will allow you to import data then map it accordingly. It is very likely that you will have to modify data exported from Rouxbe to be consumable by a given 3rd party service. This process is called 'Extract, Transform, and Load (ETL)'. Put simply, you may need to change, or add, column names to make the data 'digestible' by the consuming system. This process is rather simple — so let's dive in.
Pro-Tip: Some 3rd party services like Canvas are really good at importing data. However, the process will be simpler if you make your Canvas courses resemble Rouxbe's structure as much as possible. For instance, in the case of Canvas we will be using their "Assignments" feature and creating an assignment for each assessment on Rouxbe. We will use the exact name of the assessment for the Canvas assignment. So when we export from Rouxbe we get a column for each assessment. We'll create Assignments on Canvas to match these column names. By doing so Canvas will automatically match them for us.
Prepare your Export to be Imported
First we will want to export grade data from Rouxbe. See our article on How to Export Grades. This will give you a CSV file of the grades that you want to import to Canvas. Once you have the data exported from Rouxbe we will need to modify it so that Canvas can accept it.
As mentioned earlier, each 3rd party service will have their own data requirements. In the case of Canvas, they require a couple mandatory fields: Student Name, ID, Section, and the assignment names. Each 3rd party service will typically have info on this process — here are the Canvas docs on how to import grades.
1. Prepare the Rouxbe export so that it has the required columns for Canvas. In this case we just need to change one column: 'Custom ID' to simply 'ID'. Once done save the CSV so we can import it in the next step:
2. Set up Canvas Assignments to match Rouxbe assessments. In this case we are using the Rouxbe Knife Skills course. For each assignment on Canvas, use the Rouxbe assessment name. For example, here we're using Mid-Term Quiz for one of the Canvas Assignments, which matches the name of the assessment in our Rouxbe export:
3. Click on Grades and select 'Import' to start the import process:
4. Review the imported data and map any columns necessary. Canvas is really good at detecting which columns you are trying to import. However, if Canvas can't figure it out the assignment name, then it will provide you a list of choices. For any column that will not be needed, select 'Bogus, skip'. Otherwise, if you do intend on adding a new assignment from Rouxbe, then Canvas will allow you to do that as well. Once done mapping, click 'Continue'. This will show you a confirmation of the changes.
Quick note — Canvas will use the Student Name to match the student. However, you can add avoid this step by adding the Canvas Student ID to the student in Rouxbe via the Custom ID field on a student's profile. This will allow Canvas to precisely match the student.
5. Review the changes: Here you will see what will be changed in the Canvas Course Grades. Click 'Save Change' to complete the process.
6. Refresh the Grades page to see the updated grades: Often after importing, the grades won't be displayed. Simply refresh the page to see the imported grades.
Your grades are now imported. As your class continues through Rouxbe, you can continually sync their grades with Canvas using the steps above. As you can see, it really helps to keep the two courses structured as alike as possible, as that will mean less mapping.