SCOREPAK® score and item FILES

ScorePak® score and item files are available by request to assist in further analyses or for submission to Catalyst Online GradeBook. Each score and item file includes information for all students. Files are generally output as an Excel spreadsheet. Other format options are Fixed Length Text and Comma Delimited Text.

Score Files

Score files include students' names, IDs, and scores for each exam specified.

The order of scores is alphabetical, unless they are requested to be listed in a different order under Selected Scores on the ScorePak® Service Request form. For missing scores, value and version are blank.

Record length is determined by the number of scores.

See instructions at Catalyst Online GradeBook for importing Excel Score Files into GradeBook. For UW Canvas, we provide a CSV file; from Canvas Gradebook, select "Upload Scores (from .csv)" and your score file will be populated.

Item Files

Item files include students' names, IDs, and responses to each question.

The content of the "Extra" field  varies according to the answer sheet used. For Standard Answer Sheets this field will be blank. For the General Purpose NCS, five-choice answer sheet (blue), this field will contain: Sex, Birth (month, day, year), Identification J, Special Codes K-P, and one blank column.

Record length is determined by the number of questions. Unmarked fields are output as blanks. Multimarked fields are output as asterisks (*).

Format Options

File Type Excel Fixed
Length Text
Comma
Delimited Text
Score check
Item  

  • Excel Spreadsheet
  • We will use this format unless you request one of the options below.
  • Fixed Length Text

    Specify Fixed Length Text in the Score and Item Files section on the ScorePak® Service Request form.

    Score File  (Fixed Length Format):

    Columns Bytes Field Name
    01-14 14 Student key
    (Unique to each case. Matches key in Item file.)
    15-23 9 ID number
    24-45 22 Student name
    46-47 2 Section
    48-62 15 First Score: name (8), value (6), version (1)
    63-77 15 Second Score: name (8), value (6), version (1), etc.

    Item File  (Fixed Length Format):

    Columns Bytes Field Name
    01-14 14 Student key
    (Unique to each case. Matches key in Score file.)
    15-23 9 ID number
    24-45 22 Student name
    46-47 2 Section
    48 1 Version
    49-52 4 Bonus
    53-67 15 Extra
    68-667 600 Item responses
    (A-J, *, or blank -- number of bytes depends on number of items.)

  • Comma Delimited Text
  • This format does not contain score name or version. Specify Comma Delimited format in the Score & Item Files section on the ScorePak® Service Request form.

File Transfer Methods

We will send student item responses and/or test scores to you as an e-mail attachment.