In the Fall of 2001, an option was added to the output available when you ask for sorted class lists from GPSCOR/MRSCOR using the portion of the menu on the Request for Service sheet illustrated to the left. In the Notes section, you may indicate that you would like a file generated which is suitable for uploading to WebCT. The WebCT file will contain each student's last name, id number, WebCT ID, and score in the format expected by WebCT (using comma delimiters).

Beginning in March, 2004 two additional (optional) text fields are available. You may request either or both of these fields; the default is neither of them.

1. The first option is a list of item numbers corresponding to incorrect responses by the student. The field begins with W= which is followed by the numbers of the items that were incorrect. If a student has no incorrect responses, the field contains W=NONE.
2. The second is a list of scored responses. This field begins with R= and is followed by alphabetic values corresponding to the student's responses. If a response is correct, the character will be in upper case; an incorrect response will be in lower case. If the responses were scanned as numeric values, the numbers will be replaced by their corresponding alphabetic characters. If a response was not given for an item, '-' will appear in the corresponding position while '*' will indicate that more than one response was given. If a correct response was not provided for an item (on the key), the corresponding character in the output will be '.'; 3 ... are used to indicate that 3 or more consecutive items were not keyed.

In order to create this file, you will need to provide us with the registrar's catalog number for the class. Two files will be generated. The first is a file with the suffix .log which contains a report of the matching process used to associate the data from the scanner file with the class list obtained from the registrar's database. The second file is the end product of the matching process. It will normally have the suffix _w.csv.

Please note that the first line in the *_w.csv file is a title line describing the data. It contains the text: Last Name,Student No,Login ID,OMR Score. You will usually find it helpful to replace "OMR Score" with a more meaningful title. If the list of incorrect responses is requested the column heading for this field will be "Items Wrong" while the column heading "Scored Responses" will appear if the scored (R/w) responses have been requested.

The matching process is an iterative one that should generally result in an accurate association of the data in the scanner file with the student identification information obtained from the registrar's database. The following steps are used (and may be proofed by examining the *.log file):

1. Answer sheets having Names and ID numbers on them which correspond exactly with the information in the database are identified, matched and eliminated from further consideration.
2. Answer sheets having ID numbers that are identical and Names which are reasonably similar to those in the database are identified, matched and eliminated from further consideration.
3. Answer sheets having ID numbers which match the last 6 digits and Names which are reasonably similar to those in the database are identified, matched and eliminated from further consideration.
4. Answer sheets having Names which are reasonably similar to those in the database are identified, matched and eliminated from further consideration.
5. Identification information on any remaining answer sheets is manually examined and associated with students remaining in the registrar's class list if such an association appears reasonable.
6. Answer sheets that, in the judgement of the TSQS operator, cannot be matched to the official class list are not included in the WebCT score file. These records, if any, will be identified in the *.log file under the heading "Number of remaining unmatched scanner records"

The final information appearing in the *.log file is a listing of any students in the registrar's class list who do not have an associated answer sheet identified in the scanner file. This list along with the list produced in step #6, in particular, should be reviewed before uploading the score file to WebCT.

N.B., A '?' appearing between the identification number and the name in the log file indicates that the operator was asked to confirm the match.

This page was last updated at