Office of Educational Assessment

Data Exports

ScorePak® score and item files are available by request to assist in further analyses or for submission to Catalyst Online GradeBook and Canvas 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 (please see below for more details).

Score Files

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

The order of scores, when use Bookkeeping account, is alphabetical, unless they are requested to be listed in a different order under Selected Scores on the Step 5 of General 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.(See the link of Import ScorePaks into Canvas for more details.)

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.