Instructional Web Development Center

Upload Scantron Grades to WebCT - Preview Release

This tool uses your WebCT gradebook to correctly link Scantron data to your students' User IDs, so that it may be imported into WebCT.

Why is this necessary? WebCT requires that any data you wish to import be linked to your students' User IDs -- it cannot import data linked only to their Student IDs. It can be tedious to manually enter this data into WebCT, or to try to manually line up data in Excel.

Is this secure? This tool does not communicate grade data with any other computer in any way; it will only be processed inside your web browser. This maintains the strictest privacy for student data. To accomplish this, you will need to copy data to and from some files yourself.

What do I need? You need 1) an exported copy of your WebCT gradebook, and 2) the text file containing student grades sent by the department that scores your scantrons.

This tool is under development. As such, be aware that it might make mistakes. Please contact IWDC with any comments about how the tool works, or to help us resolve any problems that might arise.

Follow the instructions for Using Excel to Manage Grades in WebCT to download your grades and open them in Excel. When you have reached Editing the Data in Microsoft Excel, select the entire spreadsheet by typing Control-A (Command-A on a Mac), then copy the data to the Clipboard by typing Control-C (Command-C on a Mac).

Copy your WebCT gradebook, and paste it below:



Review the table below, and make sure there are no obvious inaccuracies. To work properly, you only need the User ID and PID columns.

Copy the results from the file containing your test results, and paste them below:



Review the table below, and make sure there are no obvious inaccuracies.

For each column that you want to import into WebCT, give the column a name for WebCT to use by clicking on "Column#" and typing its name, and put a checkmark beneath it.

Merged Gradebook

Below you will see the merged data, containing User IDs and their scores on this test.

Click Copy Merged Data to Clipboard below to copy the data. Go to Microsoft Excel, create a new spreadsheet, and paste the data into the first row and column in the spreadsheet. Next, go to the File menu and select Save As. For the File Name, enter something unique, and be sure to remember where you are saving the file. Next to Save as type, select "CSV (Comma Delimited)", and click Save. Excel will warn you that not all features are supported (such as multiple workbooks and formatting). This is perfectly fine for our purposes, so click OK/Yes to the windows that pop up.

Once you have saved the file, continue using the instructions on Using Excel to Manage Grades in WebCT.

Scantron Grades not found in Gradebook

You will also see a list of scores that could not be matched to a student. You will need to add their scores to WebCT manually, if any. Many of these students may have simply filled out their scantron incorrectly.

If not, however, they may be students who either added to the class late, or who are wait-listed, auditing, or concurrently enrolled and need an 'Add Computing' slip. Please refer to your WebCT Class Setup notice or email iwdc@ucsd.edu for instructions on adding these students to WebCT.

Gradebook names not found in Scantron

Last is a list of students in the gradebook, for whom no grade was found in the scantron. These students either did not fill out the scantron correctly, or did not take the test (students who dropped, for instance).