Live Chat & Phone:(780) 492-9400 7:30am – 7:30pm Mon – Fri
New Services / Features | Rate Schedule | OMR Forms and Answer Sheets | TSQS Usage Statistics | Online Services
When you ask for class lists from GPSCOR/MRSCOR using the portion of the menu on the Request for Service Form illustrated to the left, you may request generation of additional files:
The eClass file will contain each student's last name, first name, id number, user id, and total score in the format expected by eClass (using comma delimiters).
The contents of the Excel file depends on which program is used to create it. If the Scansort program is used, the file will contain any biographical information that was read from the answer sheets (such as name, idnumber, special codes) plus all the scores derived from the keys that were used to process the job. If Examtab is used to create the Excel file, only 1 column will be created for the score which will be the score derived from the key for the appropriate test form. In this case, an option also exists to include a column indicating which key was applied to respective answer sheets. The first field in the Excel file contains the sheet number that was printed on the answer sheets when they were processed.
There are two optional text fields that may be included in these files. You may request either or both of these fields; the default is neither of them.
Normally, two files will be generated when you request an eClass file:
Please note that the first line in the *_w.csv file is a title line describing the data. It contains the text: Last Name,First Name,Student No,User 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):
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 eClass.
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.
Book a ClassroomClassroom Listing
Book a LabLab Listing