UC Santa CruzInstructional Computing
ITS Home About ITS IC Services News Tutorials Technologies About IC Help

How to import student data into WebCT

1) Data Preparation

  • Scantron Setup: Click here to learn about setting up your scantron results for import to WebCT Or click here to see a Flash movie that shows how to prepare scantron data for upload then proceed to step 2 below.
  • Data must be arranged in a comma or tab delimited file
  • You must include each student's CruzMail/WebCT id as an identifer to uniquely match each student's assessment data that you are uploading with their Student Record in WebCT gradebook.
  • Do not include @ucsc.edu in the CruzMail/WebCT identifier
  • File format must end with .txt or .csv
  • Watch out for the StudentID or SID field if you are using it. Excel will strip the leading 0's unless you format the SID column as text. (Excel changes 0123456 to 123456)
  • The import file should minimally have columns named First Name, Last Name, UserID(this is the CruzMail/WebCTID) and Results columns. The columns in your file need to have names that exactly match the columns in WebCT Gradebook. See the image below--


2) Access WebCT with designer account

1. Login to WebCT

2. Click Control Panel in the upper left.

3. Under Manage Course, click Manage Students


4. From the Actions menu, pull down Options: Records, then click Add/Import student data, click Go


5. Click Browse for your new .txt spreadsheet, then click Upload

6. Choose Tab or Comma Separator, depending on how your upload data is formatted.

7. Click Import.


8. Select the radio button next to the filename of your new spreadsheet.

9. Click Add Selected




10.. You will return to the Import from File screen. Click Import.

Import from file Screen

If you have named the columns in your Excel spreadsheet to match exactly the columns in WebCT you will see a screen indicating that the field names have been resolved. If you get error message, review setting up your scantron results for import to WebCT.

Field Names Resolved screen

After you click Continue, you will see another confirmation screen:

Field Names Resolved screen

3) Release data to students

From the Actions menu, pull down Organize, then click Manage Columns, click Go


Find the new column you uploaded and select the box above it.


See Actions on right side of screen, then select Release Columns: Yes, click Go. If you want to students to see how they did compared statistically with the other students (no names) click Show Statistics: All, click Go


Please use the form below to tell us what you think of this page.


USCS Faculty Instructional Technology Center
2006-2007
Last updated 4/19/2007