Interfaces

User Tools

Site Tools

Trace:
student:act_test_scores_import

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
student:act_test_scores_import [2017/09/04 01:30] – jstanfordstudent: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 Position^End Position^Length^Table^Column^ ^
 |**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| |     
Line 8: Line 8:
 |**Middle Initia**l|44|44|1|sr_st_enroll|name_m|Compare 1st char|       |**Middle Initia**l|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|       |**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:position 87: (4 for male, 6 for female); position 88: male or female| |**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:||||||| |The following fields are imported into the ACT test scores table:|||||||
-^Field^Start^End^Length^Column^Length^Comments^+^Field^Start Position^End Position^Length^Column^Length^Comments^
 |**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)|
Line 35: Line 35:
 |**Natl Norm Read** (**Year ID** < 16)|777|778|2|nat_norm_read|2|01-99| |**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 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)|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 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)|167|168|2|nat_norm_comb|2|01-99| 
-|**Natl Norm Eng/Wrt** (**Year ID**=15 and later)|167|168|2|blank|||      +|**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)|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**=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 +|**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 - 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 - 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 - 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 +|**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 +* 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. 
-on a 1-36 scale obtained through a scaling and equating process. + 
-NOTE: +<WRAP box> 
-„ For Year ID=16, the file length must be 1050. +  * 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 can be 821 or 1050. 
-„ For Year ID < 15, the file length must be 783.+  * For **Year ID** < 15, the file length must be 783. 
 +</WRAP>
student/act_test_scores_import.1504488646.txt.gz · Last modified: 2017/09/03 20:30 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

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.