User Tools

Site Tools


student:sat_test_scores_import_mar2016_and_later

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

student:sat_test_scores_import_mar2016_and_later [2018/07/24 12:21] (current)
Line 1: Line 1:
 +======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 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.