July 20, 2009

Import your Students’ Module Scores into WebCourses!

To see a captivate video to walk you through the steps, go to https://obojobo.ucf.edu/help/create/importing-obojobo-scores-into-webcourses.html You must log in to view the video.

Or follow these steps:

STEP 1: Exporting scores from Obojobo

1. In the Repository, navigate to the ‘Published Instances’ tab.
2. Select the instance you wish to collect scores from.
3. Click on the ‘Assessment Scores’ tab.
4. Click on the purple ‘Download Scores’ button.

STEP 2: Create a New Column in your WebCourses Course

1. Open the grade book for your course.
2. Create a new numeric column to hold the scores you will be importing. To do this, click on ‘Create Column’ and select Numeric.
3. This will bring up a form to create a new column. Complete the form by giving a column label and setting the decimals combo box to 0 and maximum field to 100.
4. Click Save.

STEP 3: Importing the Obojobo scores .csv file into WebCourses

1. In WebCourses, click on the “Import From Spreadsheet” button.
2. This will bring up the import page. Select the .csv file you exported from Obojobo in the first section.
3. Leave the other values as their defaults (‘Comma’ and ‘Unicode (UTF-8)’) and click ‘Upload’.
4. 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 -’.
5. Click on the combo-box next to ‘Score’ and select the name of the column you created.
6. Click on the Import button.