Data Import for ACT Results From .txt File
This page describes the process for importing ACT result files via the Student Assessment (FA) Import function. Because ACT Result files do not always contain the PowerSchool student number, there is a need to determine to which PowerSchool student the ACT Result file belongs. Student matching is based on the percentage of text that matches between the results file and PowerSchool fields. When a user clicks the Validate File button, the Ohio Student Matching function reviews the file and determines the percentage of matching data. A comparison is done between these fields:
- State_StudentNumber
- First_name
- Middle_name
- Last_name
- Gender
- Date of Birth
When validation is complete, Student Matching displays the following categories with counts of students and a Show link that, when clicked, displays the data for each student in each category:
Exact: 0 (show) Close: 0 (show) Partial: 1 (show) Poor: 12 (show) Duplicate: 0 (show)
After selecting the Show link, the page displays each student in the list with a View link. When selected, the View link provides a list of possible matches for the selected student. Users can determine which PowerSchool student record the ACT Results file should be associated with and edit the ACT Results file to improve the match results. When the source file has been edited, it can be uploaded and validated again.
Data Map for ACT as of FY2018
File format is fixed width
Position | Length | Field Name | Field Content | FA Import Use | |
---|---|---|---|---|---|
Start | End | ||||
1 | 2 | 2 | Reporting Year Identifier | 17 = 2017-2018 | Not used |
3 | 154 | 152 | Student Identifying Information | ||
3 | 27 | 25 | Student Last Name | Special characters are - ' . | Used for matching |
28 | 43 | 16 | Student First Name | Special characters are - ' . | Used for matching |
44 | 44 | 1 | Student Middle Initial | Used for matching | |
45 | 84 | 40 | Street Address | Special characters are - ' . @ # % & ( ) : ; " / | Not used |
85 | 86 | 2 | Filler | Not used | |
87 | 87 | 1 | Gender (Numeric) | 4 = Male; 6 = Female; ' - ' = Blank | Not used |
88 | 88 | 1 | Gender (Alpha) | M = Male; F = Female; ' - ' = Blank | Used for matching |
89 | 90 | 2 | Grade Level | 11 (default) 12 | Used for matching |
91 | 99 | 9 | ACT ID (if available) | ACT ID has a dash (-) in position 91. ACT ID will not be available for all records. If no ACT ID is available, this field will be blank. | Not Used |
100 | 100 | 1 | Telephone Type | 1 = Home; 2 = Cell; 3 = Other | Not Used |
101 | 106 | 6 | Date of Birth | Formatted as MMDDYY. | Used for matching |
107 | 116 | 10 | Telephone Number | 3-digit area code; 7-digit phone number | Not Used |
117 | 141 | 25 | Mail City | Special characters are - ' . | Not Used |
142 | 143 | 2 | Mail State (Numeric) | 36 = Ohio | Not Used |
144 | 145 | 2 | Mail State (Alpha) | OH = Ohio | Not Used |
146 | 154 | 9 | ZIP Code | ZIP (ZIP + 4 if available) | Not Used |
155 | 191 | 37 | Filler | Not Used | |
192 | 204 | 13 | State-Assigned Student ID | The first 13 characters of the state or district supplied value. | Used for matching |
205 | 226 | 22 | High School Information | ||
205 | 210 | 6 | ACT H.S. Code | Will be a valid code. | Not Used |
211 | 218 | 8 | H.S. Grades | Numeric grades (on 4-point scale) with implied decimal and one decimal place. Numeric grades are based on High School Course/Grade Information (positions 661-683). | Not Used |
211 | 212 | 2 | English | Not Used | |
213 | 214 | 2 | Mathematics | Not Used | |
215 | 216 | 2 | Social Studies | Not Used | |
217 | 218 | 2 | Natural Sciences | Not Used | |
219 | 219 | 1 | Filler | Not Used | |
220 | 222 | 3 | H.S. Average | Numeric average (on 4-point scale) with implied decimal and two decimal places. Average based on High School Course/Grade Information (positions 661-683); '---' means too few H.S. Grades to calculate. | Not Used |
223 | 226 | 4 | Year of H.S. Graduation | 2019 (default) 2020 | Not Used |
227 | 232 | 6 | Test Date (Month and Year) | Formatted as CCMMYY | Imported as Test_Date format YYYYMM if a test date is present in both locations (227 to 232 and 233 to 236) the date in 227 to 232 is used. |
233 | 236 | 4 | Test Date (Month and Year) | Formatted as MMYY (e.g., 0218 for February 2018, 0318 for March 2018, 0418 for April 2018) | Imported as Test_Date format YYYYMM |
237 | 248 | 12 | Filler | Not Used | |
249 | 249 | 1 | Test Location | S = State M = Non-college reportable accommodations Test location 'S' identifies college-reportable scores, unless a mis-administration or prohibited behavior is indicated (State Use Question 10 = 'H' or 'L'). | Not Used |
250 | 260 | 11 | Filler | Not Used | |
261 | 270 | 10 | ACT Scale Scores | The range for each score is 01-36. A score of '--' means that test was omitted by student or was not scored. If any score is '--', the Composite score is set to '--'. | |
261 | 262 | 2 | English | Imported Assessment_Area = ENG; Score = three digit | |
263 | 264 | 2 | Mathematics | Imported Assessment_Area = M; Score = three digit | |
265 | 266 | 2 | Reading | Imported Assessment_Area = R; Score = three digit | |
267 | 268 | 2 | Science | Imported Assessment_Area = S; Score = three digit | |
269 | 1050 | Not used by the FA Import |