Before you begin, for a reminder on the file structure notes and automating subsequent exports, check out Build data export files
Build the ACT test score files by following the format indicated below.
TestScore_ACT(.txt or.csv)
This file contains the ACT test scores.
| Column Name | Type | Description |
|---|---|---|
| Student ID | char(15) | The unique student ID for the student. |
| Test date | Date | Date when test was taken. Valid date in mm/dd/yyyy format. |
| Grade when tested | Numeric | Student's grade when test was taken. |
| Composite | Numeric | Composite score. Valid values are between 1 and 36 |
| English | Numeric | English score. Valid values are between 1 and 36 |
| Math | Numeric | Math score. Valid values are between 1 and 36 |
| Reading | Numeric | Reading score. Valid values are between 1 and 36 |
| Science (optional) | Numeric | Science score. Valid values are between 1 and 36 |
| Writing (optional) | Numeric | Writing score is optional. Valid values are between 1 and 36 |
Example:
Student ID|Test date|Grade when tested|Composite|English|Math|Reading|Writing
123456789|01/01/2023|9|34|32|28|36