Manually Upload Scores to Sakai

Document created by Digital Support on May 19, 2017Last modified by Digital Support on May 19, 2017
Version 2Show Document
  • View in full screen mode

You can manually integrate iClicker Cloud with Sakai by exporting Reef scores and uploading the scores to the Sakai gradebook.

IMPORTANT: Manual integration requires your students to enter their Sakai student ID in the Student ID field.

1. Export a Sakai-formatted .csv from Reef.

1.1. Review the exported Student IDs.

Students with blank or unrecognized Student IDs will generate an error in Sakai and must be corrected or removed before the file can be imported. Correcting obvious problem entries now will save you time later.

1.2. Delete unwanted grade items.

The exported file contains a grade item for the cumulative scores as well as grade items for the individual session scores. You should delete either the total or the individual session columns to avoid counting scores twice.

2. Sign into Sakai.

3. Navigate to your course's Gradebook.


Select your course then click the Gradebook option in the side Tool Menu.

4. Click the Import Grades button in the Gradebook header.

5. Choose your exported Reef file and import.

  • Use the Choose File button to browse and attach your exported Reef file.

  • Click the Import Spreadsheet button once the file is chosen.

6. Correct or verify the imported data.

If any student ID is blank or unrecognized, Sakai will show an error page with a list of problem student IDs. Correct or remove these entries and repeat the import process.

If all the student IDs in the file are recognized, Sakai will show a summary of the data that will be imported into the Gradebook. Review the information and click the OK button to complete the process. You should see a confirmation message that the import is successful.