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 |  |
|
|
| 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.) |
- 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.