This guide covers how to take scores inside Obojobo and import them into your online Webcourses course.
Exporting scores from Obojobo
- In the Repository, navigate to the ‘Published Instances’ tab.
- Select the instance you wish to collect scores from.
- Click on the ‘Assessment Scores’ tab.
- Click on the purple ‘Download Scores’ button.
This will download a .csv (comma seperated value) file. This is simply a text file with the score information collected from Obojobo. If you open this file in a spreadsheet program such as Microsoft Excel or OpenOffice Calc you can see a formatted view of the data that was exported. You will need this file later, so save it in a location you will remember.
Create a new column in your Webcourses course
- Open the ‘Gradebook’ for your Webcourses course.
- Create a new numeric column to hold the scores you will be importing. To do this, click on Create Column and select Numeric.
- This action will bring up a form to create a new column.
- Supply a Column Label (in the example image we have simply used ‘Obojobo Scores’)
- Set the Decimals combo-box to ‘0’
- Set the Maximum value field to ‘100’ (All scores in Obojobo are simply 0-100)
- Click Save.
Importing the Obojobo scores .csv file into Webcourses
- Click on the Import From Spreadsheet button.
- This will bring up the import page. Select the .csv file you exported from Obojobo in the first section.
- Leave the other values as their defaults, ‘Comma’ and ‘Unicode (UTF-8),’ and click Upload.
- The next page will allow you to match information contained in the uploaded csv with your Webcourses gradebook. You should see that the User ID field has a green check graphic indicating that users contained in Webcourses and Obojobo have matched up. Leave the ‘First Name’ and ‘Last Name’ columns as their default value of Do not import.
- Click on the combo-box next to Score and select the name of the column you created in section 2.
In this example, that would be Obojobo Scores.
- Click on the Import button.
- The next page will inform you of any omitted columns and/or any additional users present in the uploaded .csv file that are not in your Webcourses course. You should see that the Last Name and First Name columns were not imported, which is expected and will not affect the import. Click OK to finish the procedure.
- Now you should see the Obojobo scores show up in the column you created.