Importing PRS Response data into eLC or WebCT

Please be sure to follow the steps in Exporting PRS Response gradebook data first.

WebCT ONLY - Renaming data columns

Before you may import gradebook data in WebCT, you will need to ensure the names of the gradebook columns match the names in WebCT.  (eLC allows you to manually match up columns during the importing process without having to modify your CSV file first.)

1. Open your exported gradebook data CSV file (this should be located on your desktop)
2. Verify your gradebook columns match your columns in eLC or WebCT
   • If the MyID is entered for the Student ID on the clicker, then the gradebook column needs to be renamed the following:
     • Student ID (MyID in Response) = User ID (in eLC and WebCT)
   • If the 810# is entered for the Student ID on the clicker, then the columns need to be renamed the following:
     • Student ID (810# in Response) = Student ID Num (in WebCT only - eLC does not have an 810# column)
     • Username (MyID in Response) = User ID (in eLC and WebCT)
3. Save and close your gradebook data CSV file

Importing data in eLC

1. Log into eLC and open your course
2. Select the "Teach" tab
3. Select "Grade Book" from the instructor tools menu in the left hand column
4. Click on the "Import from Spreadsheet" button from the grade book menu
5. Browse for the CSV file on your desktop
6. eLC should validate your CSV file against the Last name, First name, but you will need to select "User ID" from the dropdown menu to the right of "Username" so that the MyID columns match. You may choose "Add as new column", "Do not import", or match with an existing eLC grade book column for any other columns in your CSV file.

Importing data in WebCT

1. Log into WebCT and open your course
2. Select "Manage Course"
3. Select "Manage Students"
4. From the "Options: Records" dropdown menu, select "Add/Import Students"
5. Browse for the CSV file on your desktop, click "Upload" (to My-Files), then click "Add Selected"
6. Click Import
7. It will validate your CSV file against the Last name, First name and User ID. It will ask if you want to add new, ignore, or match with an existing WebCT grade book column for any other columns in your CSV file.