This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
student:act_test_scores_import [2017/09/04 00:57] – jstanford | student:act_test_scores_import [2018/07/24 13:21] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
======ACT Test Scores Import====== | ======ACT Test Scores Import====== | ||
- | ^Source^^^^Target^^^ | + | ^Source^^^^Target^^Comments^ |
- | ^Field^Start^End^Length^Table^Column^Comments^ | + | ^Field^Start |
|**Year ID**|1|2|2|sr_st_enroll|sch_yr|Computed (e.g., 18=2018)| | |**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| | | + | |**Last Name**|3|27|25|sr_st_enroll|name_l| | |
- | |First Name|28|43|16|sr_st_enroll|name_f| | | + | |**First Name**|28|43|16|sr_st_enroll|name_f| | |
- | |Middle | + | |**Middle |
- | |SSN (Year ID < 15)|91|99|9|sr_st_enroll|state_stu_id|Target not necessarily SSN| | + | |**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.| | + | |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** (expanded)|155|162|8|sr_st_demo|dob|YYYYMMDD| |
- | |Date of Birth|101|106|6|sr_st_demo|dob|MMDDYY| | + | |**Date of Birth**|101|106|6|sr_st_demo|dob|MMDDYY| |
- | |Gender|87|88|2|sr_st_demo|sex|Year ID=15 and later: | + | |**Gender**|87|88|2|sr_st_demo|sex|Year ID=15 and later: |
|The following fields are imported into the ACT test scores table: | |The following fields are imported into the ACT test scores table: | ||
- | ^Field^Start^End^Length^Column^Length^Comments^ | + | ^Field^Start |
- | |Student ID| | | |stu_id|6|Computed| | + | |**Student ID**| | | |stu_id|6|Computed| |
- | |Test Date|227|232|6|admin_dt|6|YYYYMM (e.g., 201709)| | + | |**Test Date**|227|232|6|admin_dt|6|YYYYMM (e.g., 201709)| |
- | |Composite Scale Score|269|270|2|comp_scr|2|01-36| | + | |**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)|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| | + | |**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| | | + | |**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/ | ||
+ | |**Combined English/ | ||
+ | |**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| | ||
+ | |**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|01-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. | |
- | Test Location 249 249 1 test 1 Blank, F, S, Z, D | + | |
- | Grade Level 89 90 2 grd_lvl 2 07-12 | + | <WRAP box> |
- | 2 of 3 | + | * For **Year ID**=16, the file length must be 1050. |
- | TxEIS Student - ACT Test Scores Import | + | |
- | Source Target | + | |
- | 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. | + |