User Tools

Site Tools


student:sat_test_scores_import_mar2016_and_later

SAT Test Scores Import (March 2016 and later)

The import allows both a fixed-width positional and a comma-delimited (CSV) file import.

  • The Position column indicates the start and end in the positional import file. The program determines that the import is the positional layout if the file length is 2591 or greater, and position 59-62 contains a numeric four-digit year starting with 20.
  • The Column # column indicates the position in the comma-delimited file. The program determines that the import file is the comma delimited if it contains enough commas to be split into at least 449 columns, and the fourth column either contains a numeric four-digit year starting with 20 or the word YEAR to indicate it is a heading row.
FieldPositionColumn #Length and Valid Values
Stu Last Name113-147635
Stu First Name148-182735
Stu Middle Initial183-1838
Stu Gender184-1849
Stu DOB203-21223YYYY-MM-DD
Test Date659-66844YYYY-MM-DD
Education Level/Grade Level at Time of Test669-670451 = Not yet in 8th grade
2 = 8th grade
4 = 9th grade
5 = 10th grade
6 = 11th grade
7 = 12th grade
8 = No longer in high school
10 = No response
11 = Unknown
12 = 1st year of college
13 = 2nd year of college
Reading Score682-6835010-40
Math686-6895210.0-40.0 in .5 increments
Writing684-6855110-40
Essay Scoreblankblank
Multiple Choiceblankblank
Reading National Percentile791-792960-99
Writing National Percentile793-794970-99
Math National Percentile795-796980-99
Reading State Percentile749-750760-99
Nationally Representative Sample Percentile
Writing State Percentile751-752770-99
Nationally Representative Sample Percentile
Math State Percentile753-754780-99
Nationally Representative Sample Percentile

The following fields will be imported into the SAT test scores table:

FieldPositionColumn #Valid ValuesDescription
Evidence-Based Reading and Writing Section Score676-67848200-800
Math Section Score679-68149200-800
Total Section Score672-67547400-1600Total of Evidence-Based Reading and Writing section score and Math Section Score
Analysis in Science Cross-Test Scores690-6915310-40
Analysis in History/Social Studies Cross-test Scores692-6935410-40
Relevant Words in Context Subscore694-695551-15
Command of Evidence Subscore696-697561-15
Expression of Ideas Subscore698-699571-15
Standard English Conventions Subscore700-701581-15
Heart of Algebra Subscore702-703591-15
Passports to Advanced Mathematics Subscore704-705601-15
Problem Solving and Data Analysis Subscore706-707611-15
Essay Reading Subscore708-708620, 2-8
Essay Analysis Subscore709-709630, 2-8
Essay Writing Subscore710-710640, 2-8
Nationally Representative Sample Percentile Total Score743-744730-99Total of Evidence-Based Reading and Writing Section score and Math Section Score
Nationally Representative Sample Percentile Evidence-Based Reading and Writing Section Score745-746740-99
Nationally Representative Sample Percentile Math Section Score747-748750-99
Nationally Representative Sample Percentile Analysis in Science Cross-test Scores755-756790-99
Nationally Representative Sample Percentile Analysis in History/Social Studies Cross-test Scores757-758800-99
Nationally Representative Sample Percentile Relevant Words in Context Subscore759-760810-99
Nationally Representative Sample Percentile Command of Evidence Subscore761-762820-99
Nationally Representative Sample Percentile Expression of Ideas Subscore763-764830-99
Nationally Representative Sample Percentile Standard English Conventions Subscore765-766840-99
Nationally Representative Sample Percentile Heart of Algebra Subscore767-768850-99
Nationally Representative Sample Percentile Passports to Advanced Mathematics Subscore769-770860-99
Nationally Representative Sample Percentile Problem Solving and Data Analysis Subscore771-772870-99
National Percentile Total Score785-786930-99Total of Evidence-Based Reading and Writing Section score and Math Section Score
National Percentile Evidence-Based Reading and Writing Section Score787-788940-99
National Percentile Math Section Score789-790950-99
National Percentile Analysis in Science Cross-test Scores797-798990-99
National Percentile Analysis in History/Social Studies Cross-test Scores799-8001000-99
National Percentile Relevant Words in Context Subscore801-8021010-99
National Percentile Command of Evidence Subscore803-8041020-99
National Percentile Expression of Ideas Subscore805-8061030-99
National Percentile Standard English Conventions Subscore807-8081040-99
National Percentile Heart of Algebra Subscore809-8101050-99
National Percentile Passports to Advanced Mathematics Subscore811-8121060-99
National Percentile Problem Solving and Data Analysis Subscore813-8141070-99
student/sat_test_scores_import_mar2016_and_later.txt ยท Last modified: 2018/07/24 12:21 (external edit)

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.