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