Exam Scoring
Table of Contents

3. Computer File Output

  • Computer Files
  • Columnar and CSV Computer Files
  • RAW (.dat) Computer File Format Description
  • File Characteristics
  • Computer File handling

    Computer Files

    Both exam scoring and course evaluation/data analysis data are available as computer files. This option enables clients to analyze the data according to their specific needs. There are 3 file types provided:
    • Columnar Data.
    • Comma Separated Values (CSV) Data.
    • Raw (.dat) Data - produced by the NCS scanner.

    Computer Files (both columnar and CSV)

    The files for an exam contain:

    • The student/sheet ID.
    • The sheet serial number (assigned by the OMR reader).
    • The student name (where applicable).
    • The score obtained for each section of the exam.
    • The total score.
    • The number of correct and incorrect responses for each section of the exam.
    • The total correct and incorrect responses.
    • The individual responses to each question.

    The files for a course evaluation/data analysis contain:

    • The student/sheet ID (if used).
    • The sheet serial number.
    • The individual responses to each question.

    Columnar and CSV Computer File Format Description

    The columnar record layout for both exam and course evaluation/data analysis files is the same and is outlined below:

     001 - 001  1  Record Type
     002 - 013  12  Student/Sheet ID
     014 - 025  12  Sheet Serial Number
     026 - 056  31  Student Name
     057 - 110  9X6  Score per Section (format - 9 scores given as 9999.99)
     111 - 116  6  Total Score (format - 9999.99)
     117 - 170  18x3  Correct/Incorrect Totals per
     (Section (C1,I1,C2,I2...C9,I9)
     171 - 173  3  Total Correct Responses
     174 - 176  3  Total Incorrect Responses
     177 - 192  16  Gobsrid Sourced Id
     193 - 196  4  Not used
     197 - 1156  960  Responses (1-960)

    The exam and course evaluation/data analysis CSV files contain the same information as the above columnar definition, in the same order. The difference between columnar and CSV files are that each field is separated by a comma in a CSV file, and is not dependent on its position.

    NOTE: opening the CSV files in Microsoft Excel will not display the responses correctly.

    RAW Computer File Format Description (.dat)

    These computer files contain the raw data that is produced by the optical mark reader.

    001 - 003 3 System Information
    004 - 009 6 Serial Number
    010 - 012 3 System Information
    013 - 018 6 Date Scanned
    019 - 030 12 System Information
    031 - 033 3 Total Invalid Response Count. These bytes contain the total number of omits and multiples. The first two contain the total omits. The third contain the total multiples.
    034 - 040 7 System Information
    041 - 052 12 Student/Sheet ID
    053 - 212 160 Responses

    File Characteristics

    There are certain characteristics of the file that should be noted before processing. These are:

    1. Files are kept for thirty days, after which time they are deleted. If the file is needed for a longer period of time, it is your responsibility to make a copy.

    2. There is only one record per student. If multiple sheets are used, the information for all sheets is combined into one record.

    3. Responses are one character in length for each question. The value for each response corresponds to the column selected. For example, selection of column A1 is represented by a '1', column B2 with a '2', etc. If the questions have a possibility of ten choices, the tenth choice is represented with a '0'. Multiple responses are denoted with an 'M'. A blank indicates no response was given for the question.

    4. A record for the key sheet is also provided on the computer file and has the same layout as the individual records. It is the first line of the file. The only difference between a student record and the key will be in the length of the answers. If the questions had a single answer, the value is one character in length for each question. Questions with multiple answers are two characters in length for five-choice questions and three characters in length for ten-choice questions. It should be noted that multiple answer key sheets are impossible to read and process due their representation.

      Course evaluations/data analysis also have a record for the key sheet on the computer file. However, it contains no pertinent information other than a comment to identify the evaluation.

    5. All data records have a record type of 'N'. (Record type is the first position of the record). Key or answer sheets have a record type of 'A' for single response/five or ten-choice questions, 'B' for multiple response/five-choice questions, and 'C' for multiple response/ten-choice questions.

    6. If requested, records for multiple exams or evaluations can be placed in one file. The maximum is 99 exams or evaluations per file. Each exam or evaluation can be identified by the key record which precedes its data records.

    Computer File Handling

    It is the client's responsibility to process the information provided on the computer files.

    < previous  1 2 3 4 5 6  next >        

    bubble sheet

    Form Examples