Before you begin, for a reminder on the file structure notes and automating subsequent exports, check out Build Data Export Files
Build the SAT test score files by following the format indicated below.
TestScore_SAT(.txt or.csv)
This file contains the SAT 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. |
Total score | Numeric | Total score. Valid values are between 400 and 1600 |
Reading and writing | Numeric | Reading and writing score. Valid values are between 200 and 800 |
Math | Numeric | Math score. Valid values are between 200 and 800 |
Example:
Student ID|Test date|Grade when tested|Total score|Reading and writing|Math
123456789|01/01/2023|9|600|300|300