student:sat_test_scores_import_mar2016_and_later
Book Creator
Add this page to your book
Add this page to your book Book Creator
Remove this page from your book
Remove this page from your book 
Manage book (
Help 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.
| Field | Position | Column # | Length and Valid Values |
|---|---|---|---|
| Stu Last Name | 113-147 | 6 | 35 |
| Stu First Name | 148-182 | 7 | 35 |
| Stu Middle Initial | 183-183 | 8 | |
| Stu Gender | 184-184 | 9 | |
| Stu DOB | 203-212 | 23 | YYYY-MM-DD |
| Test Date | 659-668 | 44 | YYYY-MM-DD |
| Education Level/Grade Level at Time of Test | 669-670 | 45 | 1 = 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 Score | 682-683 | 50 | 10-40 |
| Math | 686-689 | 52 | 10.0-40.0 in .5 increments |
| Writing | 684-685 | 51 | 10-40 |
| Essay Score | blank | blank | |
| Multiple Choice | blank | blank | |
| Reading National Percentile | 791-792 | 96 | 0-99 |
| Writing National Percentile | 793-794 | 97 | 0-99 |
| Math National Percentile | 795-796 | 98 | 0-99 |
| Reading State Percentile | 749-750 | 76 | 0-99 Nationally Representative Sample Percentile |
| Writing State Percentile | 751-752 | 77 | 0-99 Nationally Representative Sample Percentile |
| Math State Percentile | 753-754 | 78 | 0-99 Nationally Representative Sample Percentile |
The following fields will be imported into the SAT test scores table:
| Field | Position | Column # | Valid Values | Description |
|---|---|---|---|---|
| Evidence-Based Reading and Writing Section Score | 676-678 | 48 | 200-800 | |
| Math Section Score | 679-681 | 49 | 200-800 | |
| Total Section Score | 672-675 | 47 | 400-1600 | Total of Evidence-Based Reading and Writing section score and Math Section Score |
| Analysis in Science Cross-Test Scores | 690-691 | 53 | 10-40 | |
| Analysis in History/Social Studies Cross-test Scores | 692-693 | 54 | 10-40 | |
| Relevant Words in Context Subscore | 694-695 | 55 | 1-15 | |
| Command of Evidence Subscore | 696-697 | 56 | 1-15 | |
| Expression of Ideas Subscore | 698-699 | 57 | 1-15 | |
| Standard English Conventions Subscore | 700-701 | 58 | 1-15 | |
| Heart of Algebra Subscore | 702-703 | 59 | 1-15 | |
| Passports to Advanced Mathematics Subscore | 704-705 | 60 | 1-15 | |
| Problem Solving and Data Analysis Subscore | 706-707 | 61 | 1-15 | |
| Essay Reading Subscore | 708-708 | 62 | 0, 2-8 | |
| Essay Analysis Subscore | 709-709 | 63 | 0, 2-8 | |
| Essay Writing Subscore | 710-710 | 64 | 0, 2-8 | |
| Nationally Representative Sample Percentile Total Score | 743-744 | 73 | 0-99 | Total of Evidence-Based Reading and Writing Section score and Math Section Score |
| Nationally Representative Sample Percentile Evidence-Based Reading and Writing Section Score | 745-746 | 74 | 0-99 | |
| Nationally Representative Sample Percentile Math Section Score | 747-748 | 75 | 0-99 | |
| Nationally Representative Sample Percentile Analysis in Science Cross-test Scores | 755-756 | 79 | 0-99 | |
| Nationally Representative Sample Percentile Analysis in History/Social Studies Cross-test Scores | 757-758 | 80 | 0-99 | |
| Nationally Representative Sample Percentile Relevant Words in Context Subscore | 759-760 | 81 | 0-99 | |
| Nationally Representative Sample Percentile Command of Evidence Subscore | 761-762 | 82 | 0-99 | |
| Nationally Representative Sample Percentile Expression of Ideas Subscore | 763-764 | 83 | 0-99 | |
| Nationally Representative Sample Percentile Standard English Conventions Subscore | 765-766 | 84 | 0-99 | |
| Nationally Representative Sample Percentile Heart of Algebra Subscore | 767-768 | 85 | 0-99 | |
| Nationally Representative Sample Percentile Passports to Advanced Mathematics Subscore | 769-770 | 86 | 0-99 | |
| Nationally Representative Sample Percentile Problem Solving and Data Analysis Subscore | 771-772 | 87 | 0-99 | |
| National Percentile Total Score | 785-786 | 93 | 0-99 | Total of Evidence-Based Reading and Writing Section score and Math Section Score |
| National Percentile Evidence-Based Reading and Writing Section Score | 787-788 | 94 | 0-99 | |
| National Percentile Math Section Score | 789-790 | 95 | 0-99 | |
| National Percentile Analysis in Science Cross-test Scores | 797-798 | 99 | 0-99 | |
| National Percentile Analysis in History/Social Studies Cross-test Scores | 799-800 | 100 | 0-99 | |
| National Percentile Relevant Words in Context Subscore | 801-802 | 101 | 0-99 | |
| National Percentile Command of Evidence Subscore | 803-804 | 102 | 0-99 | |
| National Percentile Expression of Ideas Subscore | 805-806 | 103 | 0-99 | |
| National Percentile Standard English Conventions Subscore | 807-808 | 104 | 0-99 | |
| National Percentile Heart of Algebra Subscore | 809-810 | 105 | 0-99 | |
| National Percentile Passports to Advanced Mathematics Subscore | 811-812 | 106 | 0-99 | |
| National Percentile Problem Solving and Data Analysis Subscore | 813-814 | 107 | 0-99 |
student/sat_test_scores_import_mar2016_and_later.txt · Last modified: 2018/07/24 13:21 by 127.0.0.1