User Tools

Site Tools


student:psat_test_scores_import_10

Differences

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

Link to this comparison view

Next revision
Previous revision
student:psat_test_scores_import_10 [2017/09/04 08:43]
jstanford created
student:psat_test_scores_import_10 [2018/07/24 12:21] (current)
Line 5: Line 5:
 ^Source^^^^Target^^Comments^ ^Source^^^^Target^^Comments^
 ^Field^Start Position^End Position^Length^Table^Column^ ^ ^Field^Start Position^End Position^Length^Table^Column^ ^
-|Assessment year|663|666|4| |sch_yr|YYYY| +|Assessment year|665|668|4| |sch_yr|YYYY| 
- +|Last Name|113|147|35| |name_l| | 
-|The following fields are imported into the PSAT test scores table for PSAT 8/9:|||||||+|First Name|148|182|35| |name_f| | 
 +|Middle Initial|183|183|1| |name_m|Compare first char| 
 +|Date of Birth|203|212|10|sr_stu_demo|dob|YYYY-MM-DD| 
 +|Sex|184|184|1| |sex| | 
 +|The following fields are imported into the PSAT test scores table for PSAT 10:|||||||
 ^Field^Start Position^End Position^Length^Column^Length^ ^ ^Field^Start Position^End Position^Length^Column^Length^ ^
-|Year|663|666|4|admin_dt|4| | +|Year|665|668|4|admin_dt|4| | 
-    ​+|Education Level Cd|675|676|1|ed_lvl|1|1-2,​ 4-7, blank| 
 +|Total for Evidence-Based Reading & Writing and Math Section Score|677|680|4|tot_sec_scr|4|320-1520| 
 +|Evidence-Based Reading & Writing Score|681|683|3|read_writ_sec_scr|3|160-760| 
 +|Math Section Score|684|686|3|math_sec_scr|3|160-760| 
 +|Reading Score|687|688|2|verbal_scr|2|8-38| 
 +|Writing Score|689|690|2|write_scr|2|8-38| 
 +|Math Score|691|694|4|math_scr|4|8.0-38.0 in .5 increments| 
 +|Analysis in Science Crosstest Score|695|696|2|sci_cross_scr|2|8-38| 
 +|Analysis in History/SS Cross-test Score|697|698|2|hist_cross_scr|2|8-38| 
 +|Relevant Words in Context Subscore|699|700|2|words_subscr|2|1-15| 
 +|Command of Evidence Subscore|701|702|2|comm_ev_subscr|2|1-15| 
 +|Expression of Idea Subscore|703|704|2|expr_idea_subscr|2|1-15| 
 +|Standard English Conventions Subscore|705|706|2|eng_conv_subscr|2|1-15| 
 +|Heart of Algebra Subscore|707|708|2|heart_alg_subscr|2|1-15| ​    
 +|Passport to Advanced Mathematics Subscore|709|710|2|adv_math_subscr|2|1-15| 
 +|Problem Solving and Data Analysis Subscore|711|712|2|prob_solv_subscr|2|1-15| 
 +|Selection Index|732|734|3|total|3|24-114| 
 +|Selection Index National Percentile|735|736|2|total_perc|2|0-99| 
 +|Total for Evidence-Based Reading & Writing and Math Section Score Representative Percentile|753|754|2|tot_sec_rep_perc|2|0-99| 
 +|Evidence-Based Reading & Writing Representative Percentile|755|756|2|read_writ_rep_perc|2|0-99| ​    
 +|Math Section Representative Percentile|757|758|2|math_sec_rep_perc|2|0-99| 
 +|Reading Representative Percentile|759|760|2|verbal_st_perc|2|0-99| 
 +|Writing Representative Percentile|761|762|2|write_st_perc|2|0-99| 
 +|Math Representative Percentile|763|764|2|math_st_perc|2|0-99| 
 +|Analysis in Science Crosstest Representative Percentile|765|766|2|sci_cross_rep_perc|2|0-99| 
 +|Analysis in History/SS Cross-test Representative Percentile|767|768|2|hist_cross_rep_perc|2|0-99| ​    
 +|Relevant Words in Context Subscore Representative Percentile|769|770|2|words_rep_perc|2|0-99| 
 +|Command of Evidence Subscore Representative Percentile|771|772|2|comm_ev_rep_perc|2|0-99| 
 +|Expression of Idea Subscore Representative Percentile|773|774|2|expr_idea_rep_perc|2|0-99| 
 +|Standard English Conventions Subscore Representative Percentile|775|776|2|eng_conv_rep_perc|2|0-99| ​   
 +|Heart of Algebra Subscore Representative Percentile|777|778|2|heart_alg_rep_perc|2|0-99| 
 +|Passport to Advanced Mathematic Subscore Representative Percentile|779|780|2|adv_math_rep_perc|2|0-99| 
 +|Problem Solving and Data Analysis Subscore Representative Percentile|781|782|2|prob_solv_rep_perc|2|0-99| 
 +|Total for Evidence-Based Reading & Writing and Math Section Score National Percentile|789|790|2|tot_sec_perc|2|0-99| ​     
 +|Evidence-Based Reading & Writing National Percentile|791|792|2|read_writ_sec_perc|2|0-99| 
 +|Math Section National Percentile|793|794|2|math_sec_perc|2|0-99| 
 +|Reading National Percentile|795|796|2|verbal_perc|2|0-99| ​     
 +|Writing National Percentile|797|798|2|write_perc|2|0-99| 
 +|Math National Percentile|799|800|2|math_perc|2|0-99| 
 +|Analysis in Science CrossTest National Percentile|801|802|2|sci_cross_perc|2|0-99| ​     
 +|Analysis in History/SS Cross-test National Percentile|803|804|2|hist_cross_perc|2|0-99| 
 +|Relevant Words in Context Subscore National Percentile|805|806|2|words_perc|2|0-99| 
 +|Command of Evidence National Representative Percentile|807|808|2|comm_ev_perc|2|0-99| ​     
 +|Expression of Idea Subscore National Percentile|809|810|2|expr_idea_perc|2|0-99| 
 +|Standard English Conventions Subscore National Percentile|811|812|2|eng_conv_perc|2|0-99| 
 +|Heart of Algebra Subscore National Percentile|813|814|2|heart_alg_perc|2|0-99| ​     
 +|Passport to Advanced Mathematic Subscore National Percentile|815|816|2|adv_math_perc|2|0-99| 
 +|Problem Solving and Data Analysis Subscore National Percentile|817|818|2|prob_solv_perc|2|0-99|
student/psat_test_scores_import_10.1504536233.txt.gz · Last modified: 2017/09/04 08:43 by jstanford

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.