ACT Template Guide
Below is the Element451 ACT Score Reporting Service (2025) Import Template layout and information.
The ACT College Score Report File Layout & Resources page with complete ACT documentation is located at https://help.encoura.org/article/ACT-Score-Reporting/act-college-score-report-file-layout-resources (opens in a new tab)
ACT Template Layout
392 rows
| Header Name | Description/Values | Element Slug | Field Name | Formula | Legacy Values | Max Length | Note |
|---|---|---|---|---|---|---|---|
| ELA | Range is 1-36. Score of (--) means student did not receive a score on English test, Reading test or Writing test. | English Language Arts (ELA) Score | 2 | ||||
| R_Earn_Ideas | Range is 00-99. If not attempted, '--'. If not available, blank. | Points Earned - Reading - Key Ideas & Details | 2 | ||||
| Sup_OthSci | "E24|R22|M18|S19|W8|C21" for full battery w/ writing or "E--|R25|M--|S30|W--|C--" in the case of section retest | Other Scores Earned on High Science Test Date | 25 | ||||
| Sup_Mth_Sc | ACT Scale Scores. Range for each score is 1-36. | user-official-tests-act-math-score | Superscore Math Score | 2 | Calculated Column: If the date is different than the full score reported date it will import. Scope: 3 | ||
| Composite | ACT Scale Scores. Range for each score is 1-36. A score of (--) means that test was omitted by student. If any score is (--), the Composite score is set to (--). Test score before 10/89 is in Hist_Comp. | user-official-tests-act-composite-score | Composite Score | 2 | Scope: Group 1 | ||
| HS_Yrs_Span | 0; .5; 1; 1.5; 2; 2.5; 3; 3.5; 4+ | Years Studied Spanish | ".5";1; "1";2; "1.5";3; "2";4; "2.5";5; "3";6; "3.5";7; "4+";8; "0";9 | 3 | |||
| HS_GPA_Calc | Numeric average (on 4-point scale) with implied decimal and two decimal places; if blank, field is set to (---). Average based on grades in G_Eng_9-G_Dram | High School Average | 3 | ||||
| M_PctC_Higher | Range is 000-100. If not attempted, '---'. If not available, blank. | % Correct - Math - Preparing for Higher Math | 3 | ||||
| CS_Grp5_Rnk | Institutional Ranks (cumulative %) - 001-100; three-digit numeric | Composite Score Group 5 | 3 | ||||
| M_PctC_Func | Range is 000-100. If not attempted, '---'. If not available, blank. | % Correct - Math - Functions | 3 | ||||
| FIPS | 5-digit FIPS County Code. See County Codes. | FIPS Code | 5 | ||||
| Country_Cde | 2 character alpha abbreviation. See Country Codes. | user-addresses-home-country | Country Alpha code | 2 | Interprets as Alpha 2 | ||
| Hons_Soc | Yes/No | Enrolled AP/Honors Social Studies | "Yes";1; "No";2 | 3 | |||
| Ethn_AlaskaNat | Y/N | Raw Race/Ethnicity American Ind/AK Nat | "American Ind/AK Nat";1 | 1 | |||
| EdLevel_Fthr | Less than high school; HS Grad/GED; Bus/Tech School or Certif; Some college; Associate's degree; Bachelor's degree; 1-2 years grad study; Doctorate or prof. | Level Father/Guardian Education | "Less than high school";1; "HS Grad/GED";2; "Bus/Tech School or Certif";3; "Some college";4; "Associate's degree";5; "Bachelor's degree";6; "1-2 years grad study";7; "Doctorate or prof.";8 | 25 | |||
| Prob_C_Group2 | Ranges 01-99 | Prob C or Higher Group 2 | 2 | ||||
| G_Germ | A; B; C; D; F | High School Grade German | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| USRnk_Sub_Math | Based on recent high school graduates who took the ACT in grades 10-12. Subscores Range is 001-100. If subscore is (---), norm for that score is set to (---). Reported as (---) for estimated scores. | US Rank Scale Score Mathematics | 3 | ||||
| Prob_B_Course4 | Ranges 01-99 | Prob B or Higher Course 4 | 2 | ||||
| G_AdvMth | A; B; C; D; F | High School Grade Other Advanced Math | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| Test_Loc | ST = State; DT = District; I = Residual scored by your institution; R = Residual scored by ACT; RP = Remote Proctor; Blank = All other test locations | Test Type | 2 | ||||
| W_Dom_Org | Range is 02-12. Domain core of (--) means Writing test could not be scored; student did not take the Writing test if blank. | Writing Domain Score: Organization | 2 | ||||
| Want_Honors | Yes/No | Want Honors Courses | "Yes";1; "No";2 | 3 | |||
| Voc_Certainty | Very sure; Fairly sure; Not sure | Certainty of Vocational Choice | "Very sure";1; "Fairly sure";2; "Not sure";3 | 11 | |||
| Rnks_Type | 0 = ACT-Tested Norms | Ranks Type | 1 | ||||
| R_PctC_Knlg | Range is 000-100. If not attempted, '---'. If not available, blank. | % Correct - Reading - Integration of Knowledge & Ideas | 3 | ||||
| M_Poss_Mod | Range is 00-99. If not available, blank. | Points Possible - Math - Modeling | 2 | ||||
| Sup_Mth_Type | Section; Full | Section Type | 7 | ||||
| R_PctC_Struc | Range is 000-100. If not attempted, '---'. If not available, blank. | % Correct - Reading - Craft & Structure | 3 | ||||
| Help_MathSk | Yes/No | Want Help with Math Skills | "Yes";1; "No";2 | 3 | |||
| Plan_ServOrg | Yes/No | Service Organizations College | "Yes";1; "No";2 | 3 | |||
| EOS_OptIn | Yes/No | Educational Opportunity Service (EOS) Release | 3 | ||||
| HS_GradYr | Intended year of H.S. graduation (e.g., 2018, 2019) | user-education-highschools-graduate-date | High School Graduation Year | 4 | Calculated Column: Since the import only provides a year, it changes it to May 01 for the year provided before importing. | ||
| Sub_Grp3_Rnk | Institutional Ranks (cumulative %) - 001-100; three-digit numeric | Subject Area Score Course 3 | 3 | ||||
| State | 2-character alpha abbreviation; may be blank. See State Codes. | user-addresses-home-state | State Abbreviation | 2 | Interprets as Alpha2 | ||
| C_AmGov | Took or taking; Will take; Will not take | High School Course American Government | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| Prob_C_Course4 | Ranges 01-99 | Prob C or Higher Course 4 | 2 | ||||
| Plan_VAthl | Yes/No | Varsity Athletics College | "Yes";1; "No";2 | 3 | |||
| Test_Dte | Reported as MMYYYY | user-official-tests-act-date | Test Date | 6 | Scope: Group 1 | ||
| IntInv_BusOpRnk | Interest Inventory Percentile Ranks. Range is 01-99. If Interest Inventory scores are (--), percentile rank is also (--). | Interest Inventory Pct Rank Business Operations | 2 | ||||
| SizePref_Rnk | First; Second; Third; Fourth; Fifth; Sixth; Seventh | Rank Size of Enrollment Preference | "First";1; "Second";2; "Third";3; "Fourth";4; "Fifth";5; "Sixth";6; "Seventh";7 | 7 | |||
| Plan_RadioTV | Yes/No | Radio TV College | "Yes";1; "No";2 | 3 | |||
| HS_Name | Name of attending high school | user-education-highschools-name | High School Name | 360 | Calculated Column: If HS code (above row) is not one of the numbers listed, it will import the high school name. | ||
| W_Dom_Supt | Range is 02-12. Domain core of (--) means Writing test could not be scored; student did not take the Writing test if blank. | Writing Domain Score: Development and Support | 2 | ||||
| Activ_Pubs | Yes/No | Publications High School | "Yes";1; "No";2 | 3 | |||
| M_Earn_Geom | Range is 00-99. If not attempted, '--'. If not available, blank. | Points Earned - Math - Geometry | 2 | ||||
| M_RdyRng_NumQ | Range is 000-100. If not available, blank. | Readiness Range - Math - Number & Quantity | 3 | ||||
| Superscore Reading Score | Superscore Reading Score | IF([C51]<>[C73]& [C73]<>"",[C75],"") | 0 | Scoped to Group 4. This will create an additional ACT evaluation on the record with only the english score. If main score date and reading super score date are different, sets reading super score and maps as new evaluation. | |||
| C_Bio | Took or taking; Will take; Will not take | High School Course Biology | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| G_Eng_9 | A; B; C; D; F | High School Grade English 9 | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| Address2 | House Number/Street; P.O. Box No., etc. Special characters are - ' . @ # % ( ) : ; / | user-addresses-home-street2 | Street Address 2 | 40 | |||
| C_Mus | Took or taking; Will take; Will not take | High School Course Music | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| G_Span | A; B; C; D; F | High School Grade Spanish | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| Major_Code | See Major and Occupation Codes. | Major Code | 3 | ||||
| F_Name | As provided by the student. Special characters are - ' . | user-first-name | Student First Name | 40 | |||
| USRnk_Sub_Sci | Based on recent high school graduates who took the ACT in grades 10-12. Subscores Range is 001-100. If subscore is (---), norm for that score is set to (---). Reported as (---) for estimated scores. | US Rank Scale Score Science | 3 | ||||
| Supescore Math Score | Supescore Math Score | IF([C51]<>[C68] & [C68] <>"",[C70],"") | 0 | Scoped to Group 3. This will create an additional ACT evaluation on the record with only the english score. If main score date and math super score date are different, sets math super score and maps as new evaluation. | |||
| HS_GPA_Range | 0.9 or lower; 1.0-1.4; 1.5-1.9; 2.0-2.4; 2.5-2.9; 3.0-3.4; 3.5 and above | High School GPA | "0.5-0.9"; 1; "1.0-1.4";2; "1.5-1.9";3; "2.0-2.4";4; "2.5-2.9";5; "3.0-3.4";6; "3.5-4.0";7 | 15 | |||
| Eng | ACT Scale Scores. Range for each score is 1-36. A score of (--) means that test was omitted by student. If any score is (--), the Composite score is set to (--). Test score before 10/89 is in Hist_Eng. | user-official-tests-act-english-score | English Score | 2 | Scope: Group 1 | ||
| MaleFemPref | Coed; All male; All fem; No pref | Male Female Preference | "Coed";1; "All male";2 ; "All fem";3; "No pref";4 | 8 | |||
| CS_Grp4_Rnk | Institutional Ranks (cumulative %) - 001-100; three-digit numeric | Composite Score Group 4 | 3 | ||||
| Pref_Dist | Less than 10 miles; 10-25 miles; 26-100 miles; More than 100 miles; No particular college in mind | Preferred Distance From Home to College | "Less than 10 miles";1; 10-25 miles";2; "26-100 miles";3; "More than 100 miles";4; "No particular college in mind";5 | 29 | |||
| CS_Grp1_Rnk | Institutional Ranks (cumulative %) - 001-100; three-digit numeric | Composite Score Group 1 | 3 | ||||
| USRnk_Sub_Engl | Based on recent high school graduates who took the ACT in grades 10-12. Subscores Range is 001-100. If subscore is (---), norm for that score is set to (---). Reported as (---) for estimated scores. | US Rank Scale Score English | 3 | ||||
| Activ_VAthl | Yes/No | Varsity Athletics High School | "Yes";1; "No";2 | 3 | |||
| USRnk_Comp | Based on recent high school graduates who took the ACT in grades 10-12. Subscores Range is 001-100. If subscore is (---), norm for that score is set to (---). Reported as (---) for estimated scores. | US Rank Scale Score Composite | 3 | ||||
| C_Readiness | 0 = Unlikely to obtain an NCRC; 1 = Likely to obtain a Bronze level NCRC; 2 = Likely to obtain a Silver level NCRC; 3 = Likely to obtain a Gold level NCRC; 4 = Likely to obtain a Platinum level NCRC (New Value); (-) = Unable to calculate (Student does not have a Composite score) | Progress Toward Career Readiness | 1 | ||||
| G_Mus | A; B; C; D; F | High School Grade Music | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| C_Art | Took or taking; Will take; Will not take | High School Course Art | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| Sup_Writ_Sc | For test events beginning in September 2016. Range is 2-12. Score of (--) means Writing test could not be scored; student did not take the Writing test if blank. | Superscore Writing Subject Score (2-12) | 2 | ||||
| Activ_InstMus | Yes/No | Instrumental Music High School | "Yes";1; "No";2 | 3 | |||
| S_Poss_Data | Range is 00-99. If not available, blank. | Points Possible - Science - Interpretation of Data | 2 | ||||
| Coll_ChoicNum | 1st; 2nd; 3rd; 4th; 5th; 6th; Sup; Res | College Choice Number | "1st";1; "2nd";2; "3rd";3; "4th";4; "5th";5; "6th";6; "Supplemental";S; "Module A: Full ACT Assessment";A; "4 Tests Only";C | 3 | |||
| Hist_NatSc | Range is 01-35. ACT Standard Scores Taken before 10/89 as Originally Reported. A score of (--) means that test was omitted by a student. If any score is (--), the Composite score is set to (--). | Natural Sciences Before 10/89 | 2 | ||||
| M_RdyRng_Higher | Range is 000-100. If not available, blank. | Readiness Range - Math - Preparing for Higher Math | 3 | ||||
| S_Earn_Data | Range is 00-99. If not attempted, '--'. If not available, blank. | Points Earned - Science - Interpretation of Data | 2 | ||||
| S_PctC_Data | Range is 000-100. If not attempted, '---'. If not available, blank. | % Correct - Science - Interpretation of Data | 3 | ||||
| Ethn_HispLat | Y/N/P | user-race-hispanic | Raw Race/Ethnicity Hispanic/Latino | "Hispanic/Latino";1; "Not Hispanic/Latino";2 "Prefer not to respond";3 | 1 | Calculated Column: Only pulls Y/N | |
| C_BegCalc | Took or taking; Will take; Will not take | High School Course Beg Calculus | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| C_USHist | Took or taking; Will take; Will not take | High School Course US History | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| M_Earn_Higher | Range is 00-99. If not attempted, '--'. If not available, blank. | Points Earned - Math - Preparing for Higher Math | 2 | ||||
| Hons_NatSc | Yes/No | Enrolled AP/Honors Natural Sciences | "Yes";1; "No";2 | 3 | |||
| HS_GradeLev | 6th or 7th Grad; 8th Grade; 9th Grade; 10th Grade; 11th Grade; 12th Grade; H.S. Graduate; College Student; Other | Grade Level at Time of Test | "6th or 7th Grade";07; "8th Grade";08; "9th Grade";09; "10th Grade";10; "11th Grade";11; "12th Grade";12; "H.S. Graduate";13; "College Student";14; "Other" | 15 | |||
| Prob_B_Group5 | Ranges 01-99 | Prob B or Higher Group 5 | 2 | ||||
| M_Initial | As provided by the student. Special characters are - ' . | user-middle-name | Student Middle Initial | 1 | |||
| HS_Curriculum | Business; Voc-tech; Coll prep; General | High School Curriculum | "Business";1; "Voc-tech";2; "Coll prep";3; "General";4 | 9 | |||
| Live_Pln | Resid hall; Off-campus; Parents; Married housing; Frat/Sor | Plan To Live Where | "Resid hall";1; "Off-campus";2; "Parents";3; "Married housing";4; "Frat/Sor";5 | 15 | |||
| Activ_RelOrg | Yes/No | Religious Organizations High School | "Yes";1; "No";2 | 3 | |||
| Sup_Composite | ACT Scale Scores. Range for each score is 1-36. | Super Composite Score | 2 | ||||
| EDIT: Gender | Gender | IF([C27]="Male","Male",IF([C27]="Female","Female","")) | 0 | Default formula controls for values that might not match your data source. Consider modifying the formula if your data source stores other values that are sent by ACT. | |||
| Highest_Ed_Exp | Business/technical/certificate; Associate's; Bachelor's; Grad study; Prof level; Other | Highest Level Education Expected to Complete | "Business/technical/certificate";1; "Associate's";2; "Bachelor's";3; "Grad study";4; "Prof level";5; "Other";6 | 30 | |||
| Ethn_FedValues | Black/African-Amer; Amer Ind/Alaskan Native; White; Hispanic/Latino; Asian; Native Hawaiian/Pacific Islander; Two or more races; Prefer not to respond | Racial Ethnic Background (Federal Values) | "Black/African-Amer";1; "Amer Ind, Alaskan Native";2; "White";3; "Hispanic/Latino";4; "Asian";5; "Native Hawaiian/Pacific Islander";6; "Two or more races";7; "Prefer not to respond";8 | 35 | |||
| Activ_PolOrg | Yes/No | Political Organizations High School | "Yes";1; "No";2 | 3 | |||
| AcadMajPref_Rnk | First; Second; Third; Fourth; Fifth; Sixth; Seventh | Rank Field of Study Preference | "First";1; "Second";2; "Third";3; "Fourth";4; "Fifth";5; "Sixth";6; "Seventh";7 | 7 | |||
| HS_Yrs_NatSc | 0; .5; 1; 1.5; 2; 2.5; 3; 3.5; 4+ | Years Studied Natural Sciences | ".5";1; "1";2; "1.5";3; "2";4; "2.5";5; "3";6; "3.5";7; "4+";8; "0";9 | 3 | |||
| Sup_Writ_Type | Section; Full | Section Type | 7 | ||||
| E_RdyRng_Conv | Range is 000-100. If not available, blank. | Readiness Range - English - Convention of Standard English | 3 | ||||
| CS_Grp3_Rnk | Institutional Ranks (cumulative %) - 001-100; three-digit numeric | Composite Score Group 3 | 3 | ||||
| M_RdyRng_Essen | Range is 000-100. If not available, blank. | Readiness Range - Math - Integrating Essential Skills | 3 | ||||
| Address1 | House Number/Street; P.O. Box No., etc. Special characters are - ' . @ # % ( ) : ; / | user-addresses-home-street1 | Street Address 1 | 40 | |||
| InstRnk_Math | Institutional Ranks (cumulative %) - 001-100; three-digit numeric | Institutional Rank Math | 3 | ||||
| StatePref2 | State Name Abbrevation | State Prefer to Attend 2 | 2 | ||||
| Plan_Pubs | Yes/No | Publications College | "Yes";1; "No";2 | 3 | |||
| S_RdyRng_Inv | Range is 000-100. If not available, blank. | Readiness Range - Science - Scientific Investigation | 3 | ||||
| G_Chem | A; B; C; D; F | High School Grade Chemistry | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| Sup_OthMth | "E24|R22|M18|S19|W8|C21" for full battery w/ writing or "E24|R--|M18|S--|W--|C--" in the case of section retest | Other Scores Earned on High Math Test Date | 25 | ||||
| MaleFemPref_Rnk | First; Second; Third; Fourth; Fifth; Sixth; Seventh | Rank Male Female Preference | "First";1; "Second";2; "Third";3; "Fourth";4; "Fifth";5; "Sixth";6; "Seventh";7 | 7 | |||
| R_Poss_Knlg | Range is 00-99. If not available, blank. | Points Possible - Reading - Integration of Knowledge & Ideas | 2 | ||||
| HS_Yrs_Germ | 0; .5; 1; 1.5; 2; 2.5; 3; 3.5; 4+ | Years Studied German | ".5";1; "1";2; "1.5";3; "2";4; "2.5";5; "3";6; "3.5";7; "4+";8; "0";9 | 3 | |||
| G_Lang | A; B; C; D; F | High School Grade Other Language | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| Activ_RadioTV | Yes/No | Radio TV High School | "Yes";1; "No";2 | 3 | |||
| Zip4 | 4-digit number (if available) | Zip Plus 4 | 4 | ||||
| Help_EdPlan | Yes/No | Want Help with Education/Occupational Plans | "Yes";1; "No";2 | 3 | |||
| Sup_Eng_Loc | ST=State; DT=District; RP=Remote Proctor; Blank=All other tests | Test Type | 2 | ||||
| InstRnk_Writ | Range is 001-100, score of (--) will result in this field value of (---). | Institutional Rank (Cumulative %) -Writing Subject Score | 3 | ||||
| Prob_B_Group4 | Ranges 01-99 | Prob B or Higher Group 4 | 2 | ||||
| Prob_C_Course3 | Ranges 01-99 | Prob C or Higher Course 3 | 2 | ||||
| Prob_B_Course1 | Ranges 01-99 | Prob B or Higher Course 1 | 2 | ||||
| G_AllEng | Numeric grades (on 4-point scale) with implied decimal and one decimal place. | High School Grade English | 2 | ||||
| Country_Txt | Country Text name. See Country Codes. | Country Text | 60 | ||||
| C_Eng_Oth | Took or taking; Will take; Will not take | High School Course Other English | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| Rep_Dte | Reported as MMDDYYYY | Report Date | 8 | ||||
| Sup_OthRdg | "E24|R22|M18|S19|W8|C21" for full battery w/ writing or "E24|R25|M--|S--|W--|C--" in the case of section retest | Other Scores Earned on High Reading Test Date | 25 | ||||
| M_Earn_Essen | Range is 00-99. If not attempted, '--'. If not available, blank. | Points Earned - Math - Integrating Essential Skills | 2 | ||||
| InstTypePref | Pub-4yr; Priv-4yr; Pub-2yr; Priv-2yr; Voc-tech; Nursing | Institution Type Preference | "Pub-4yr";1; "Priv-4yr";2; "Pub-2yr";3; "Priv-2yr";4; "Voc-tech";5; "Nursing";6 | 8 | |||
| Sup_Rdg_Loc | ST=State; DT=District; RP=Remote Proctor; Blank=All other tests | Test Type | 2 | ||||
| Sup_STEM | Range is 1-36. | STEM Supercore | 2 | ||||
| Prob_C_Course1 | Ranges 01-99 | Prob C or Higher Course 1 | 2 | ||||
| G_Frch | A; B; C; D; F | High School Grade French | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| C_AdvMth | Took or taking; Will take; Will not take | High School Course Other Adv Math | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| IntInv_TechRnk | Interest Inventory Percentile Ranks. Range is 01-99. If Interest Inventory scores are (--), percentile rank is also (--). | Interest Inventory Pct Rank Technical | 2 | ||||
| Sup_Eng_Dt | Reported as MMYYYY | user-official-tests-act-date | Superscore English Date | 6 | Calculated Column: If the date is different than the full score reported date it will import. Scope: 2 | ||
| Major | See Major and Occupation Codes. | Planned Educational Major | 70 | ||||
| M_Poss_Stat | Range is 00-99. If not available, blank. | Points Possible - Math - Statistics & Probability | 2 | ||||
| Home Phone Number | Home Phone Number | IF([C24] = "Cell", "",[C22]) | 0 | Check phone type and route accordingly. | |||
| Want_IndepSt | Yes/No | Want Independent Study | "Yes";1; "No";2 | 3 | |||
| M_PctC_Alg | Range is 000-100. If not attempted, '---'. If not available, blank. | % Correct - Math - Algebra | 3 | ||||
| E_PctC_Prod | Range is 000-100. If not attempted, '---'. If not available, blank. | % Correct - English - Production of Writing | 3 | ||||
| IntInv_BusCStd | Standard score range is 20 to 80 or (--). Absence of scores (--) means too few responses for valid score. | Interest Inventory Business Contact Standard Score | 2 | ||||
| Sup_Rdg_Type | Section; Full | Section Type | 7 | ||||
| ID_StateAssign | State issued ID used for some state issued tests. NULL for other tests. | State-Assigned Student ID Number | 13 | ||||
| IntInv_SciStd | Standard score range is 20 to 80 or (--). Absence of scores (--) means too few responses for valid score. | Interest Inventory Science Standard Score | 2 | ||||
| Plan_InstMus | Yes/No | Instrumental Music College | "Yes";1; "No";2 | 3 | |||
| Ph_Type | Home; Cell; Other | Type of Telephone | "Home";1; "Cell";2; "Other";3 | 5 | Used for phone number and country code. | ||
| IntInv_TechStd | Standard score range is 20 to 80 or (--). Absence of scores (--) means too few responses for valid score. | Interest Inventory Technical Standard Score | 2 | ||||
| CS_Grp2_Rnk | Institutional Ranks (cumulative %) - 001-100; three-digit numeric | Composite Score Group 2 | 3 | ||||
| C_Cmpt | Took or taking; Will take; Will not take | High School Course Computer | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| Prob_C_Group4 | Ranges 01-99 | Prob C or Higher Group 4 | 2 | ||||
| E_Poss_Prod | Range is 00-99. If not available, blank. | Points Possible - English - Production of Writing | 2 | ||||
| Sci | ACT Scale Scores. Range for each score is 1-36. A score of (--) means that test was omitted by student. If any score is (--), the Composite score is set to (--). Test score before 10/89 is in Hist_NatSc. | user-official-tests-act-science-score | Science Score | 2 | Scope: Group 1 | ||
| Sub_Grp1_Rnk | Institutional Ranks (cumulative %) - 001-100; three-digit numeric | Subject Area Score Course 1 | 3 | ||||
| Superscore Math Date | Superscore Math Date | IF([C51]<>[C68] & [C68]<>"",DATE_READ(CONCAT("01",PAD([C68],0,6)),"dmY"),"") | 0 | Scoped to Group 3. This will create an additional ACT evaluation on the record with only the english score. If main score date and math super score date are different, transforms math super score = and maps as new evaluation. | |||
| Hons_Mth | Yes/No | Enrolled AP/Honors Math | "Yes";1; "No";2 | 3 | |||
| Help_Writing | Yes/No | Want Help Writing | "Yes";1; "No";2 | 3 | |||
| G_WrldHist | A; B; C; D; F | High School Grade World History | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| C_Econ | Took or taking; Will take; Will not take | High School Course Economics | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| Activ_StuGov | Yes/No | Student Government High School | "Yes";1; "No";2 | 3 | |||
| C_Eng_10 | Took or taking; Will take; Will not take | High School Course English 10 | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| Voc_Code | See Major and Occupation Codes. | Vocational Code | 3 | ||||
| EdLevel_Mthr | Less than high school; HS Grad/GED; Bus/Tech School or Certif; Some college; Associate's degree; Bachelor's degree; 1-2 years grad study; Doctorate or prof. | Level Mother/Guardian Education | "Less than high school";1; "HS Grad/GED";2; "Bus/Tech School or Certif";3; "Some college";4; "Associate's degree";5; "Bachelor's degree";6; "1-2 years grad study";7; "Doctorate or prof.";8 | 25 | |||
| Ethn_White | Y/N | Raw Race/Ethnicity White | "White";5 | 1 | |||
| InstTypePref_Rnk | First; Second; Third; Fourth; Fifth; Sixth; Seventh | Rank Institution Type Preference | "First";1; "Second";2; "Third";3; "Fourth";4; "Fifth";5; "Sixth";6; "Seventh";7 | 7 | |||
| Sup_ELA | Range is 1-36. Score of (--) means student did not receive a score on Writing test. | English Language Arts (ELA) Superscore | 2 | ||||
| G_Psych | A; B; C; D; F | High School Grade Psychology | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| E_Earn_Conv | Range is 00-99. If not attempted, '--'. If not available, blank. | Points Earned - English - Convention of Standard English | 2 | ||||
| G_AllMth | Numeric grades (on 4-point scale) with implied decimal and one decimal place. | High School Grade Math | 2 | ||||
| G_Phys | A; B; C; D; F | High School Grade Physics | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| Hist_Eng | Range is 01-33. ACT Standard Scores Taken before 10/89 as Originally Reported. A score of (--) means that test was omitted by a student. If any score is (--), the Composite score is set to (--). | English Before 10/89 | 2 | ||||
| ID_ACT | Student Unique Identifier | user-identities-actid | ACT ID | 9 | |||
| InstRnk_Sci | Institutional Ranks (cumulative %) - 001-100; three-digit numeric | Institutional Rank Science | 3 | ||||
| G_Dram | A; B; C; D; F | High School Grade Drama | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| C_Eng_9 | Took or taking; Will take; Will not take | High School Course English 9 | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| C_OthHist | Took or taking; Will take; Will not take | High School Course Other History | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| C_Phys | Took or taking; Will take; Will not take | High School Course Physics | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| HS_Yrs_Soc | 0; .5; 1; 1.5; 2; 2.5; 3; 3.5; 4+ | Years Studied Social Studies | ".5";1; "1";2; "1.5";3; "2";4; "2.5";5; "3";6; "3.5";7; "4+";8; "0";9 | 3 | |||
| Ethn_Asian | Y/N | Raw Race/Ethnicity Asian | "Asian";2 | 1 | |||
| Plan_FratSor | Yes/No | Fraternity Sorority College | "Yes";1; "No";2 | 3 | |||
| IntInv_SocRnk | Interest Inventory Percentile Ranks. Range is 01-99. If Interest Inventory scores are (--), percentile rank is also (--). | Interest Inventory Pct Rank Social Service | 2 | ||||
| IntMaj_Fit | Interest-Major Fit score (range is 00-99). All data are numeric. If no predictions made, fields set to blank. | Interest-Major Fit Score | 2 | ||||
| Single_HighTest | Single_Full; Highest_Full | Score Type | 12 | ||||
| CostPref | 500; 1,000; 2,000; 3,000; 4,000; 5,000; 7,500; 10,000; No pref | Maximum Tuition Preference | "500";1; "1,000";2; "2,000";3; "3,000";4; "4,000";5; "5,000";6; "7,500";7; "10,000";8; "No pref";9 | 7 | |||
| Sup_Writ_Dt | Reported as MMYYYY | Superscore Writing Date | 6 | ||||
| Sup_Composite_Type | Superscore Composite Type | 0 | |||||
| Sub_Grp4_Rnk | Institutional Ranks (cumulative %) - 001-100; three-digit numeric | Subject Area Score Course 4 | 3 | ||||
| R_Poss_Ideas | Range is 00-99. If not available, blank. | Points Possible - Reading - Key Ideas & Details | 2 | ||||
| Plan_VocMus | Yes/No | Vocal Music College | "Yes";1; "No";2 | 3 | |||
| HS_ClassRnk | Top qtr; 2nd qtr; 3rd qtr; 4th qtr | High School Class Rank | "Top qtr";1; "2nd qtr";2; "3rd qtr";3; "4th qtr";4 | 7 | |||
| InstRnk_Read | Institutional Ranks (cumulative %) - 001-100; three-digit numeric | Institutional Rank Reading | 3 | ||||
| Provided by student; special characters are - _ . /@ | user-email-address | Student Email Address | 50 | ||||
| W_Dom_Ideas | Range is 02-12. Domain core of (--) means Writing test could not be scored; student did not take the Writing test if blank. | Writing Domain Score: Ideas and Analysis | 2 | ||||
| S_PctC_Inv | Range is 000-100. If not attempted, '---'. If not available, blank. | % Correct - Science - Scientific Investigation | 3 | ||||
| InstRnk_Engl | Institutional Ranks (cumulative %) - 001-100; three-digit numeric | Institutional Rank English | 3 | ||||
| Gender | Male; Female; Another Gender; Prefer not to respond | user-gender | Gender | "Male";M; "Female";F; "Another gender";A; "Prefer not to respond";P; [Blank = (--) ] | 21 | Calculated Column: Only pulls Male/Female. | |
| Superscore Reading Date | Superscore Reading Date | IF([C51]<>[C73] & [C73]<>"",DATE_READ(CONCAT("01",PAD([C73],0,6)),"dmY"),"") | 0 | Scoped to Group 4. This will create an additional ACT evaluation on the record with only the english score. If main score date and reading super score date are different, transforms reading super score date and maps as new evaluation. | |||
| C_Eng_12 | Took or taking; Will take; Will not take | High School Course English 12 | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| Sup_Rdg_Sc | ACT Scale Scores. Range for each score is 1-36. | user-official-tests-act-reading-score | Superscore Reading Score | 2 | Calculated Column: If the date is different than the full score reported date it will import. Scope: 4 | ||
| G_Geog | A; B; C; D; F | High School Grade Geography | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| M_Earn_Func | Range is 00-99. If not attempted, '--'. If not available, blank. | Points Earned - Math - Functions | 2 | ||||
| InstRnk_EnrComp | Range is 001-100, score of (--) will result in this field value of (---). | Institutional Rank (Cumulative %) -Enrollment Populations - Composite | 3 | ||||
| Cell Phone Country Code | Cell Phone Country Code | IF([C24] = "Cell", [C23], "") | 0 | Check phone type then route accordingly. | |||
| County_Name | Standard: USPS County names. See County Codes. | County Name | 40 | ||||
| C_Geom | Took or taking; Will take; Will not take | High School Course Geometry | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| Phone | Complete number including Area Code | user-phone-home-number OR user-phone-cell-number | Telephone Number | 14 | Calculated Column: Depends on “Ph_Type” | ||
| Plan_RacEthOrg | Yes/No | Racial Ethnic Organizations College | "Yes";1; "No";2 | 3 | |||
| Activ_SocialClb | Yes/No | Fraternity, Sorority, Social Club High School | "Yes";1; "No";2 | 3 | |||
| C_Lang | Took or taking; Will take; Will not take | High School Course Other Language | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| C_Alg1 | Took or taking; Will take; Will not take | High School Course Algebra 1 | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| L_Name | As provided by the student. Special characters are - ' . | user-last-name | Student Last Name | 40 | |||
| G_Bio | A; B; C; D; F | High School Grade Biology | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| G_BegCalc | A; B; C; D; F | High School Grade Beg Calculus | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| M_Poss_Func | Range is 00-99. If not available, blank. | Points Possible - Math - Functions | 2 | ||||
| Sup_Mth_Loc | ST=State; DT=District; RP=Remote Proctor; Blank=All other tests | Test Type | 2 | ||||
| Sup_Mth_Dt | Reported as MMYYYY | user-official-tests-act-date | Superscore Math Date | 6 | Calculated Column: If the date is different than the full score reported date it will import. Scope: 3 | ||
| S_RdyRng_Eval | Range is 000-100. If not available, blank. | Readiness Range - Science - Evaluation of Models, Inferences & Experimental Results | 3 | ||||
| S_Poss_Inv | Range is 00-99. If not available, blank. | Points Possible - Science - Scientific Investigation | 2 | ||||
| G_Alg1 | A; B; C; D; F | High School Grade Algebra 1 | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| IntInv_SciRnk | Interest Inventory Percentile Ranks. Range is 01-99. If Interest Inventory scores are (--), percentile rank is also (--). | Interest Inventory Pct Rank Science | 2 | ||||
| S_Earn_Eval | Range is 00-99. If not attempted, '--'. If not available, blank. | Points Earned - Science - Evaluation of Models, Inferences & Experimental Results | 2 | ||||
| M_PctC_Essen | Range is 000-100. If not attempted, '---'. If not available, blank. | % Correct - Math - Integrating Essential Skills | 3 | ||||
| Sup_Eng_Type | Section; Full | Section Type | 7 | ||||
| M_Earn_Stat | Range is 00-99. If not attempted, '--'. If not available, blank. | Points Earned - Math - Statistics & Probability | 2 | ||||
| Ethn_PrefNoRsp | Y/N | Raw Race/Ethnicity Prefer not to respond | "Prefer not to respond";6 | 1 | |||
| InstRnk_STEM | Range 001-100 '--' or Blank | Institutional Rank STEM | 3 | ||||
| Prob_C_Course2 | Ranges 01-99 | Prob C or Higher Course 2 | 2 | ||||
| M_Earn_Alg | Range is 00-99. If not attempted, '--'. If not available, blank. | Points Earned - Math - Algebra | 2 | ||||
| IntInv_MapReg3 | Up to 3 regions; based on Interest Inventory scores; range for each is 01-12, or 99 (scores inconclusive), or scores missing (--). | Interest Inventory Map Region 3 | 2 | ||||
| G_Eng_11 | A; B; C; D; F | High School Grade English 11 | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| Superscore English Score | Superscore English Score | IF([C51]<>[C63] & [C63]<>"",[C65],"") | 0 | Scoped to Group 2. This will create a second ACT evaluation on the record with only the english score. If main score date and english super score date are different, sets english super score and maps as new evaluation. | |||
| HS_Code | H.S. code list(s) available from ACT. 999999 indicates code given by student is invalid; 800000 indicates student is Not in High School; 969998 indicates student could not find his/her H.S. code; 969999 indicates Homeschool; 960000 indicates ‘Have or will earn GED’. | user-education-highschools-entry-type | High School Code | 6 | Calculated Column: Used to determine if homeschooled, high school, or GED. | ||
| Sub_Grp5_Rnk | Institutional Ranks (cumulative %) - 001-100; three-digit numeric | Subject Area Score Course 5 | 3 | ||||
| Zip | 5-digit zip | user-addresses-home-zip | Zip Code | 5 | |||
| R_Und_Comp_txt | Below Proficiency; Proficient; Above Proficiency; Unable to Calculate | Understanding Complex Text Indicator | 20 | ||||
| Prob_B_Group2 | Ranges 01-99 | Prob B or Higher Group 2 | 2 | ||||
| G_AllSocSc | Numeric grades (on 4-point scale) with implied decimal and one decimal place. | High School Grade Social Studies | 2 | ||||
| Superscore English Date | Superscore English Date | IF([C51]<>[C63] & [C63]<>"",DATE_READ(CONCAT("01",PAD([C63],0,6)),"dmY"),"") | 0 | Scoped to Group 2. This will create a second ACT evaluation on the record with only the english score. If main score date and english super score date are different, transforms english super score date and maps as new evaluation. | |||
| C_Alg2 | Took or taking; Will take; Will not take | High School Course Algebra 2 | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| E_RdyRng_Knlg | Range is 000-100. If not available, blank. | Readiness Range - English - Knowledge of Language | 3 | ||||
| M_Earn_Mod | Range is 00-99. If not attempted, '--'. If not available, blank. | Points Earned - Math - Modeling | 2 | ||||
| M_Poss_Essen | Range is 00-99. If not available, blank. | Points Possible - Math - Integrating Essential Skills | 2 | ||||
| HS_Type | Public; Catholic; Priv-ind; Priv-denom; Military; Other; Less than 3 yrs home school in HS; 3 or more yrs home school in HS | High School Type | "Public";1; "Catholic";2; "Priv-ind";3; "Priv-denom";4; "Military";5; "Other";6 "Less than 3 yrs home school in HS";7 "3 or more yrs home school in HS";8 | 35 | |||
| Help_Reading | Yes/No | Want Help Reading | "Yes";1; "No";2 | 3 | |||
| OtherFac_Rnk | First; Second; Third; Fourth; Fifth; Sixth; Seventh | Rank Other Factor | "First";1; "Second";2; "Third";3; "Fourth";4; "Fifth";5; "Sixth";6; "Seventh";7 | 7 | |||
| M_PctC_Geom | Range is 000-100. If not attempted, '---'. If not available, blank. | % Correct - Math - Geometry | 3 | ||||
| USRnk_Wri | Based on recent high school graduates who took the ACT in grades 10-12. Subscores Range is 001-100. If subscore is (---), norm for that score is set to (---). Reported as (---) for estimated scores. | US Rank Scale Score Writing | 3 | ||||
| Help_StudySk | Yes/No | Want Help with Study Skills | "Yes";1; "No";2 | 3 | |||
| G_Trig | A; B; C; D; F | High School Grade Trigonometry | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| Prob_B_Course2 | Ranges 01-99 | Prob B or Higher Course 2 | 2 | ||||
| Ethnicity Hispanic Latino | Ethnicity Hispanic Latino | IF([C28]="Y","Y",IF([C28]="N","N","")) | 0 | Conforms data to match Element451 boolean. | |||
| G_Econ | A; B; C; D; F | High School Grade Economics | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| USRnk_Sub_Rdg | Based on recent high school graduates who took the ACT in grades 10-12. Subscores Range is 001-100. If subscore is (---), norm for that score is set to (---). Reported as (---) for estimated scores. | US Rank Scale Score Reading | 3 | ||||
| CIP_Code | See Major and Occupation Codes. | CIP Code Mapped to Major | 7 | ||||
| Plan_Debate | Yes/No | Debate College | "Yes";1; "No";2 | 3 | |||
| State_Full | State Text name. See State Codes. | State_Full | 30 | ||||
| G_Geom | A; B; C; D; F | High School Grade Geometry | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| Prob_B_Course3 | Ranges 01-99 | Prob B or Higher Course 3 | 2 | ||||
| Mth | ACT Scale Scores. Range for each score is 1-36. A score of (--) means that test was omitted by student. If any score is (--), the Composite score is set to (--). Test score before 10/89 is in Hist_Math. | user-official-tests-act-math-score | Math Score | 2 | Scope: Group 1 | ||
| Major_Certainty | Very sure; Fairly sure; Not sure | Certainty of Planned Educational Major | "Very sure";1; "Fairly sure";2; "Not sure";3 | 11 | |||
| Prob_C_Group3 | Ranges 01-99 | Prob C or Higher Group 3 | 2 | ||||
| G_GenSc | A; B; C; D; F | High School Grade General Science | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| Full_Part | Full-time; Part-time | Attend Full or Part Time | "Full-time";1; "Part-time";2 | 9 | |||
| M_PctC_Mod | Range is 000-100. If not attempted, '---'. If not available, blank. | % Correct - Math - Modeling | 3 | ||||
| Rel_Int | See Religious Interest. Special characters are -' | Religious Interest | 46 | ||||
| Ethn_PacIsland | Y/N | Raw Race/Ethnicity Hawaiian/Pacific Isl | "Hawaiian/Pacific Isl";4 | 1 | |||
| Hist_Math | Range is 01-36. ACT Standard Scores Taken before 10/89 as Originally Reported. A score of (--) means that test was omitted by a student. If any score is (--), the Composite score is set to (--). | Math Before 10/89 | 2 | ||||
| Writing | For test events beginning in September 2016. Range is 2-12. Score of (--) means Writing test could not be scored; student did not take the Writing test if blank. | user-official-tests-act-writing-score | Writing Subject Score (2-12) | 2 | Scope: Group 1 | ||
| Activ_RacEthOrg | Yes/No | Racial Ethnic Organizations High School | "Yes";1; "No";2 | 3 | |||
| G_Eng_10 | A; B; C; D; F | High School Grade English 10 | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| Hons_Eng | Yes/No | Enrolled AP/Honors English | "Yes";1; "No";2 | 3 | |||
| Superscore Science Date | Superscore Science Date | IF([C51]<>[C78] & [C78]<>"",DATE_READ(CONCAT("01",PAD([C78],0,6)),"dmY"),"") | 0 | Scoped to Group 4. This will create an additional ACT evaluation on the record with only the english score. If main score date and science super score date are different, transforms science super score date and maps as new evaluation. | |||
| High School Type | High School Type | IF([C37]="96999","home_schooled",IF([C37]="960000","ged",IF([C37]<>"999999" & [C37]<> "800000"& [C37]<>"969998",IF([C38],"highschool",""),""))) | 0 | Conforms data to match Element451 school types. | |||
| Activ_ServOrg | Yes/No | Service Organizations High School | "Yes";1; "No";2 | 3 | |||
| IntInv_MapReg1 | Up to 3 regions; based on Interest Inventory scores; range for each is 01-12, or 99 (scores inconclusive), or scores missing (--). | Interest Inventory Map Region 1 | 2 | ||||
| Exp_FinAidApp | Yes/No | Expect to Apply for Financial Aid | "Yes";1; "No";2 | 3 | |||
| Sup_Sci_Type | Section; Full | Section Type | 7 | ||||
| IntInv_ArtRnk | Interest Inventory Percentile Ranks. Range is 01-99. If Interest Inventory scores are (--), percentile rank is also (--). | Interest Inventory Pct Rank Arts | 2 | ||||
| Sup_Sci_Sc | ACT Scale Scores. Range for each score is 1-36. | user-official-tests-act-science-score | Superscore Science Score | 2 | Calculated Column: If the date is different than the full score reported date it will import. Scope 5 | ||
| G_USHist | A; B; C; D; F | High School Grade US History | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| HS_Yrs_Eng | 0; .5; 1; 1.5; 2; 2.5; 3; 3.5; 4+ | Years Studied English | ".5";1; "1";2; "1.5";3; "2";4; "2.5";5; "3";6; "3.5";7; "4+";8; "0";9 | 3 | |||
| Plan_Theater | Yes/No | Theater College | "Yes";1; "No";2 | 3 | |||
| StatePref_Rnk | First; Second; Third; Fourth; Fifth; Sixth; Seventh | Rank Location Preference | "First";1; "Second";2; "Third";3; "Fourth";4; "Fifth";5; "Sixth";6; "Seventh";7 | 7 | |||
| Hist_Comp | Range is 01-35. ACT Standard Scores Taken before 10/89 as Originally Reported. A score of (--) means that test was omitted by a student. If any score is (--), the Composite score is set to (--). | Composite Score Before 10/89 | 2 | ||||
| G_Alg2 | A; B; C; D; F | High School Grade Algebra 2 | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| Cell Phone Number | Cell Phone Number | IF([C24] = "Cell", [C22], "") | 0 | Check phone type and route accordingly. | |||
| Ethn_AfricAmer | Y/N | Raw Race/Ethnicity Black/African Amer | "Black/African Amer";3 | 1 | |||
| STEM | Range is 01-36. Score of (--) means student did not receive a score on Math test or Science test. | STEM Score | 2 | ||||
| E_Earn_Prod | Range is 00-99. If not attempted, '--'. If not available, blank. | Points Earned - English - Production of Writing | 2 | ||||
| ROTC | Yes/No | Interested in ROTC, NROTC, AFROTC, etc. | "Yes";1; "No";2 | 3 | |||
| E_Poss_Knlg | Range is 00-99. If not available, blank. | Points Possible - English - Knowledge of Language | 2 | ||||
| USRnk_ELA | Range is 1-100, score of (--) will result in this field value of (---). | US Rank - (Cumulative %) - ELA | 3 | ||||
| InstRnk_ELA | Range 001-100 '--' or Blank | Institutional Rank ELA | 3 | ||||
| C_Frch | Took or taking; Will take; Will not take | High School Course French | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| C_Eng_11 | Took or taking; Will take; Will not take | High School Course English 11 | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| E_RdyRng_Prod | Range is 000-100. If not available, blank. | Readiness Range - English - Production of Writing | 3 | ||||
| C_WrldHist | Took or taking; Will take; Will not take | High School Course World History | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| Exp_Work | Yes/No | Expect to Work in College | "Yes";1; "No";2 | 3 | |||
| G_Eng_12 | A; B; C; D; F | High School Grade English 12 | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| C_Trig | Took or taking; Will take; Will not take | High School Course Trigonometry | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| M_Poss_Higher | Range is 00-99. If not available, blank. | Points Possible - Math - Preparing for Higher Math | 2 | ||||
| G_AllNatSc | Numeric grades (on 4-point scale) with implied decimal and one decimal place. | High School Grade Natural Sciences | 2 | ||||
| Sup_OthEng | "E24|R22|M18|S19|W8|C21" for full battery w/ writing or "E24|R--|M18|S--|W--|C--" in the case of section retest | Other Scores Earned on High English Test Date | 25 | ||||
| C_Germ | Took or taking; Will take; Will not take | High School Course German | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| Coll_Cde | 4-digit ACT College Code | College Code | 4 | ||||
| Fam_Income | Less than $24,000; $24,000-$36,000; $36,000-$50,000; $50,000-$60,000; $60,000-$80,000; $80,000-$100,000; $100,000-$120,000; $120,000-$150,000; More than $150,000 | Level Parents Income | "Less than $24,000";1; "$24,000-$36,000";2; "$36,000-$50,000";3; "$50,000-$60,000";4; "$60,000-$80,000";5; "$80,000-$100,000";6; "$100,000-$120,000";7; "$120,000-$150,000";8; "More than $150,000";9 | 18 | |||
| Home Phone Country Code | Home Phone Country Code | IF([C24] = "Cell", "",[C23]) | 0 | Check phone type and route accordinly. | |||
| CostPref_Rnk | First; Second; Third; Fourth; Fifth; Sixth; Seventh | Rank Cost Preference | "First";1; "Second";2; "Third";3; "Fourth";4; "Fifth";5; "Sixth";6; "Seventh";7 | 7 | |||
| C_Geog | Took or taking; Will take; Will not take | High School Course Geography | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| C_Span | Took or taking; Will take; Will not take | High School Course Spanish | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| C_Chem | Took or taking; Will take; Will not take | High School Course Chemistry | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| Voc | See Major and Occupation Codes. | Vocational Choice | 70 | ||||
| Plan_RelOrg | Yes/No | Religious Organizations College | "Yes";1; "No";2 | 3 | |||
| Sup_Rdg_Dt | Reported as MMYYYY | user-official-tests-act-date | Superscore Reading Date | 6 | Calculated Column: If the date is different than the full score reported date it will import. Scope: 4 | ||
| Sup_Writ_Loc | ST=State; DT=District; RP=Remote Proctor; Blank=All other tests | Test Type | 2 | ||||
| M_Earn_NumQ | Range is 00-99. If not attempted, '--'. If not available, blank. | Points Earned - Math - Number & Quantity | 2 | ||||
| City | Special characters are - ' . | user-addresses-home-city | City | 34 | |||
| W_Dom_LangUse | Range is 02-12. Domain core of (--) means Writing test could not be scored; student did not take the Writing test if blank. | Writing Domain Score: Language Use and Conventions | 2 | ||||
| Prob_B_Group3 | Ranges 01-99 | Prob B or Higher Group 3 | 2 | ||||
| Superscore Science Score | Superscore Science Score | IF([C51]<>[C78] &[C78]<>"",[C80],"") | 0 | Scoped to Group 5. This will create an additional ACT evaluation on the record with only the english score. If main score date and science super score date are different, sets science super score and maps as new evaluation. | |||
| M_Poss_Alg | Range is 00-99. If not available, blank. | Points Possible - Math - Algebra | 2 | ||||
| Sum_Scale | Numeric sum of the 4 scale scores. If any score is (--), the sum is set to (---). Reported as (---) for estimated scores. | Sum of Scale Scores | 3 | ||||
| Sub_Grp2_Rnk | Institutional Ranks (cumulative %) - 001-100; three-digit numeric | Subject Area Score Course 2 | 3 | ||||
| C_Dram | Took or taking; Will take; Will not take | High School Course Drama | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| IntInv_ArtStd | Standard score range is 20 to 80 or (--). Absence of scores (--) means too few responses for valid score. | Interest Inventory Art Standard Score | 2 | ||||
| M_PctC_NumQ | Range is 000-100. If not attempted, '---'. If not available, blank. | % Correct - Math - Number & Quantity | 3 | ||||
| S_PctC_Eval | Range is 000-100. If not attempted, '---'. If not available, blank. | % Correct - Science - Evaluation of Models, Inferences & Experimental Results | 3 | ||||
| Prob_C_Group1 | Ranges 01-99 | Prob C or Higher Group 1 | 2 | ||||
| Postal | Postal code specific to international mail | International Postal Code | 9 | ||||
| High School Graduation Year | High School Graduation Year | DATE_READ(CONCAT("01/05/",[C36]),"d/m/Y") | 0 | ACT only provides year. This formula appends May 1st to create a full date string. | |||
| Data_Src | Single;Super | Data Source | 10 | ||||
| R_PctC_Ideas | Range is 000-100. If not attempted, '---'. If not available, blank. | % Correct - Reading - Key Ideas & Details | 3 | ||||
| M_Poss_Geom | Range is 00-99. If not available, blank. | Points Possible - Math - Geometry | 2 | ||||
| Prov | 2-character alpha abbreviation; may be blank. See Province Codes. | user-addresses-home-province | Province | 2 | |||
| Hist_SocSt | Range is 01-34. ACT Standard Scores Taken before 10/89 as Originally Reported. A score of (--) means that test was omitted by a student. If any score is (--), the Composite score is set to (--). | Social Studies Before 10/89 | 2 | ||||
| IntInv_BusOpStd | Standard score range is 20 to 80 or (--). Absence of scores (--) means too few responses for valid score. | Interest Inventory Business Operations Standard Score | 2 | ||||
| E_PctC_Conv | Range is 000-100. If not attempted, '---'. If not available, blank. | % Correct - English - Convention of Standard English | 3 | ||||
| Activ_VocMus | Yes/No | Vocal Music High School | "Yes";1; "No";2 | 3 | |||
| Prob_C_Course5 | Ranges 01-99 | Prob C or Higher Course 5 | 2 | ||||
| S_RdyRng_Data | Range is 000-100. If not available, blank. | Readiness Range - Science - Interpretation of Data | 3 | ||||
| Want_StudyAb | Yes/No | Want Study Abroad | "Yes";1; "No";2 | 3 | |||
| IntInv_MapReg2 | Up to 3 regions; based on Interest Inventory scores; range for each is 01-12, or 99 (scores inconclusive), or scores missing (--). | Interest Inventory Map Region 2 | 2 | ||||
| SizePref | Under 1,000; 1-5,000; 5-10,000; 10-20,000; 20,000+ | College Size Preference | "Under 1,000";1; "1-5,000";2; "5-10,000";3; "10-20,000";4; "20,000+";5 | 15 | |||
| High School Name | High School Name | IF([C37]<>"999999" & [C37]<> "800000"& [C37]<>"969998" & [C37]<>"96999" & [C37]<>"960000" ,IF([C38],[C38],""),"") | 0 | Checks school type and routes name accordingly. | |||
| Activ_Theater | Yes/No | Theater High School | "Yes";1; "No";2 | 3 | |||
| DOB | Reported as MMDDYYYY. If invalid or blank, the field will be blank. | user-dob | Date of Birth | 8 | |||
| HS_Size | Under 25; 25-99; 100-199; 200-399; 400-599; 600-899; 900+ | High School Size | "Under 25";1; "25-99";2; "100-199";3; "200-399";4; "400-599";5; "600-899";6; "900+";7 | 8 | |||
| R_RdyRng_Knlg | Range is 000-100. If not available, blank. | Readiness Range - Reading - Integration of Knowledge & Ideas | 3 | ||||
| Prob_C_Group5 | Ranges 01-99 | Prob C or Higher Group 5 | 2 | ||||
| Sup_Sci_Dt | Reported as MMYYYY | user-official-tests-act-date | Superscore Science Date | 6 | Calculated Column: If the date is different than the full score reported date it will import. Scope: 5 | ||
| Plan_PolOrg | Yes/No | Political Organizations College | "Yes";1; "No";2 | 3 | |||
| M_RdyRng_Stat | Range is 000-100. If not available, blank. | Readiness Range - Math - Statistics & Probability | 3 | ||||
| R_Earn_Struc | Range is 00-99. If not attempted, '--'. If not available, blank. | Points Earned - Reading - Craft & Structure | 2 | ||||
| Plan_StuGov | Yes/No | Student Government College | "Yes";1; "No";2 | 3 | |||
| M_RdyRng_Alg | Range is 000-100. If not available, blank. | Readiness Range - Math - Algebra | 3 | ||||
| G_AmGov | A; B; C; D; F | High School Grade American Government | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| G_Eng_Oth | A; B; C; D; F | High School Grade Other English | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| HS_Yrs_Mth | 0; .5; 1; 1.5; 2; 2.5; 3; 3.5; 4+ | Years Studied Math | ".5";1; "1";2; "1.5";3; "2";4; "2.5";5; "3";6; "3.5";7; "4+";8; "0";9 | 3 | |||
| StatePref1 | State Name Abbrevation | State Prefer to Attend 1 | 2 | ||||
| G_Overall | Numeric average (on 4-point scale) with implied decimal and two decimal places; if blank, field is set to (---). Average based on G_AllEng through G_AllNatSc. | High School Average | 3 | ||||
| IntInv_BusCRank | Interest Inventory Percentile Ranks. Range is 01-99. If Interest Inventory scores are (--), percentile rank is also (--). | Interest Inventory Pct Rank Business Contact | 2 | ||||
| S_Earn_Inv | Range is 00-99. If not attempted, '--'. If not available, blank. | Points Earned - Science - Scientific Investigation | 2 | ||||
| Sup_Sci_Loc | ST=State; DT=District; RP=Remote Proctor; Blank=All other tests | Test Type | 2 | ||||
| R_Earn_Knlg | Range is 00-99. If not attempted, '--'. If not available, blank. | Points Earned - Reading - Integration of Knowledge & Ideas | 2 | ||||
| G_Art | A; B; C; D; F | High School Grade Art | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| Hons_Lang | Yes/No | Enrolled AP/Honors Foreign Language | "Yes";1; "No";2 | 3 | |||
| Activ_Debate | Yes/No | Debate High School | "Yes";1; "No";2 | 3 | |||
| E_PctC_Knlg | Range is 000-100. If not attempted, '---'. If not available, blank. | % Correct - English - Knowledge of Language | 3 | ||||
| E_Poss_Conv | Range is 00-99. If not available, blank. | Points Possible - English - Convention of Standard English | 2 | ||||
| C_GenSc | Took or taking; Will take; Will not take | High School Course General Science | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| Prob_B_Group1 | Ranges 01-99 | Prob B or Higher Group 1 | 2 | ||||
| G_OthHist | A; B; C; D; F | High School Grade Other History | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| S_Poss_Eval | Range is 00-99. If not available, blank. | Points Possible - Science - Evaluation of Models, Inferences & Experimental Results | 2 | ||||
| G_Cmpt | A; B; C; D; F | High School Grade Computer | "A";4; "B";3; "C";2; "D";1; "F";0 | 1 | |||
| R_RdyRng_Ideas | Range is 000-100. If not available, blank. | Readiness Range - Reading - Key Ideas & Details | 3 | ||||
| R_Poss_Struc | Range is 00-99. If not available, blank. | Points Possible - Reading - Craft & Structure | 2 | ||||
| Ph_CtryCde | Up to 3-digit Country Calling Code | user-phone-home-country-code OR user-phone-cell-country-code | Country Phone Code | 3 | Calculated Column: Depends on “Ph_Type” | ||
| Exp_WorkHrs | None; 1-10; 11-20; 21-30; 31+ | Hours to Work per Week in College | "None";1; "1-10";2; "11-20";3; "21-30";4; "31+";5 | 5 | |||
| E_Earn_Knlg | Range is 00-99. If not attempted, '--'. If not available, blank. | Points Earned - English - Knowledge of Language | 2 | ||||
| Country_ISO | 3 character ISO country code. See Country Codes. | Country ISO Code | 3 | ||||
| IntInv_SocStd | Standard score range is 20 to 80 or (--). Absence of scores (--) means too few responses for valid score. | Interest Inventory Social Service Standard Score | 2 | ||||
| M_PctC_Stat | Range is 000-100. If not attempted, '---'. If not available, blank. | % Correct - Math - Statistics & Probability | 3 | ||||
| M_RdyRng_Mod | Range is 000-100. If not available, blank. | Readiness Range - Math - Modeling | 3 | ||||
| Rdg | ACT Scale Scores. Range for each score is 1-36. A score of (--) means that test was omitted by student. If any score is (--), the Composite score is set to (--). | user-official-tests-act-reading-score | Reading Score | 2 | Scope: Group 1 | ||
| M_RdyRng_Geom | Range is 000-100. If not available, blank. | Readiness Range - Math - Geometry | 3 | ||||
| C_Psych | Took or taking; Will take; Will not take | High School Course Psychology | "Taken";1; "Plan to take";2; "Not taken; not plan to take";3 | 20 | |||
| HS_Yrs_Frch | 0; .5; 1; 1.5; 2; 2.5; 3; 3.5; 4+ | Years Studied French | ".5";1; "1";2; "1.5";3; "2";4; "2.5";5; "3";6; "3.5";7; "4+";8; "0";9 | 3 | |||
| Sup_Eng_Sc | ACT Scale Scores. Range for each score is 1-36. | user-official-tests-act-english-score | Superscore English Score | 2 | Calculated Column: If the date is different than the full score reported date it will import. Scope: 2 | ||
| USRnk_STEM | Range is 1-100, score of (--) will result in this field value of (---). | US Rank (Cumulative %) - STEM | 3 | ||||
| R_RdyRng_Struc | Range is 000-100. If not available, blank. | Readiness Range - Reading - Craft & Structure | 3 | ||||
| Prob_B_Course5 | Ranges 01-99 | Prob B or Higher Course 5 | 2 | ||||
| HS_Yrs_OthLang | 0; .5; 1; 1.5; 2; 2.5; 3; 3.5; 4+ | Years Studied Other Language | ".5";1; "1";2; "1.5";3; "2";4; "2.5";5; "3";6; "3.5";7; "4+";8; "0";9 | 3 | |||
| M_Poss_NumQ | Range is 00-99. If not available, blank. | Points Possible - Math - Number & Quantity | 2 | ||||
| ID_Local | Local ID Number. Normally blank; reports Local ID number if used by junior high academic talent search programs. | Local ID | 8 | ||||
| M_RdyRng_Func | Range is 000-100. If not available, blank. | Readiness Range - Math - Functions | 3 |
Was this page helpful?