Add this page to your book 
Remove this page from your book 
Manage book (
Help This is an old revision of the document!
ACT Test Scores Import
| Source | Target | |||||
|---|---|---|---|---|---|---|
| Field | Start | End | Length | Table | Column | Comments |
| Year ID | 1 | 2 | 2 | sr_st_enroll | sch_yr | Computed (e.g., 18=2018) |
| Last Name | 3 | 27 | 25 | sr_st_enroll | name_l | |
| First Name | 28 | 43 | 16 | sr_st_enroll | name_f | |
| Middle Initial | 44 | 44 | 1 | sr_st_enroll | name_m | Compare 1st char |
| SSN (Year ID < 15) | 91 | 99 | 9 | sr_st_enroll | state_stu_id | Target not necessarily SSN |
| blank or ACT ID (Year ID=15 and later) | 91 | 99 | 9 | Can be blank, or type a dash (-) in position 91 for ACT ID. | ||
| Date of Birth (expanded) | 155 | 162 | 8 | sr_st_demo | dob | YYYYMMDD |
| Date of Birth | 101 | 106 | 6 | sr_st_demo | dob | MMDDYY |
| Gender | 87 | 88 | 2 | sr_st_demo | sex | Year ID=15 and later:position 87: (4 for male, 6 for female); position 88: male or female |
| The following fields are imported into the ACT test scores table: | ||||||
| Field | Start | End | Length | Column | Length | Comments |
| Student ID | stu_id | 6 | Computed | |||
| Test Date | 227 | 232 | 6 | admin_dt | 6 | YYYYMM (e.g., 201709) |
| Composite Scale Score | 269 | 270 | 2 | comp_scr | 2 | 01-36 |
| Natl Norm Comp (Year ID < 16) | 781 | 782 | 2 | natl_perc_bnd_blw | 2 | 0-99 |
| Natl Norm Comp (Year ID=16 and later) | 1041 | 1043 | 3 | natl_perc_bnd_blw | 3 | 001-100 |
| Sum of Scale Scores | 272 | 274 | 3 | total | 4 | |
| Test Location | 249 | 249 | 1 | test | 1 | Blank, F, S, Z, D |
| Grade Level | 89 | 90 | 2 | grd_lvl | 2 | 07-12 |
| English Scale Score | 261 | 262 | 2 | eng_scr | 2 | 01-36 |
| Math Scale Score | 263 | 264 | 2 | math_scr | 2 | 01-36 |
| Reading Scale Score | 265 | 266 | 2 | read_scr | 2 | 01-36 |
| Science Scale Score | 267 | 268 | 2 | sci_scr | 2 | 01-36 |
| Combined English/Writing Score (Year ID < 2015) | 163 | 164 | 2 | comb_scr | 2 | 01-36 |
| Combined English/Writing Score (Year ID=15 and later) | 163 | 164 | 2 | blank | ||
Writing Subscore (Year ID < 15) 165 166 2 wrt_scr 2 02-12 Writing Subscore (Year ID=15)* 791 792 2 wrt_scr 2 01-36 Writing Subscore (Year ID=2016 and later) 804 805 2 wrt_scr 2 02-12 Natl Norm Eng (Year ID=15) 773 774 2 nat_norm_engl 2 01-99 Natl Norm Eng (Year ID=16 and later) 1029 1031 3 nat_norm_engl 3 001-100 Natl Norm Read (Year ID < 16) 777 778 2 nat_norm_read 2 01-99 Natl Norm Read (Year ID=16 and later) 1035 1037 3 nat_norm_read 3 001-100 Natl Norm Sci (Year ID < 16) 779 780 2 nat_norm_sci 2 01-99 Natl Norm Sci (Year ID=16 and later) 1038 1040 3 nat_norm_sci 3 001-100 Natl Norm Eng/ Wrt (Year ID < 15) 167 168 2 nat_norm_ comb 2 01-99 Natl Norm Eng/ Wrt (Year ID=15 and later) 167 168 2 blank Natl Norm Writing (Year ID < 15) 169 170 2 nat_norm_wrt 2 01-99 3 of 3 TxEIS Student - ACT Test Scores Import Source Target Natl Norm Writing (Year ID=15) 804 805 2 nat_norm_wrt 2 01-99 Natl Norm Writing (Year ID=16 and later) 793 795 3 nat_norm_wrt 3 001-100 Writing Domain - Ideas and Analysis (Year ID=15 and later) 796 797 2 wrt_domain_ idea 2 02-12 Writing Domain - Development and Support (Year ID=15 and later) 798 799 2 wrt_domain_ dev 2 02-12 Writing Domain - Organization (Year ID=15 and later) 800 801 2 wrt_domain_ org 2 02-12 Writing Domain - Language Use and Conventions (Year ID=15 and later) 802 803 2 wrt_domain_ lang 2 02-12 * The Writing Subscore (Year ID=15) is the scaled sum of the four Writing Domain scores (08-48) and reported on a 1-36 scale obtained through a scaling and equating process. NOTE: For Year ID=16, the file length must be 1050. For Year ID=15, the file length can be 821 or 1050. For Year ID < 15, the file length must be 783.