Select Test Results File

Matching Students

Update Test Tables


Here are specific instructions on how to load the Texas English Language Proficiency Assessments System (TELPAS) student results files, along with the TELPAS-Alternate (TELPASA) student results files. The process is identical for both tests. 


Navigate to School Info > Imports and Exports > Import Test Results


Select File Layout  

The Import Test Results process can import both the  TELPAS and TELPAS-Alternate student test results files. For best results, load test files at the district level when possible. The Import Test Results process will also add the new TELPAS test parts into the Testing Control (CTL) table. 


Select the proper TELPAS Test Results file layout to import the student results file. The data file must be in the format defined in the TELPAS/TELPAS-Alternate Student Data File Layout found on the Texas Education Agency Data File Formats website. Once the file is downloaded from the testing vendor, it should NOT be opened before importing into Aeries, as that sometimes breaks the format the import routine is expecting. When deciding which year file layout to use, select the file layout that was in effect when the data was downloaded. 


NOTE:  It is VERY important that the correct file layout be chosen to match the results file, as the TELPAS and TELPAS-Alternate file layouts are almost identical. Choosing the wrong layout for the file being imported will result in the test records being misidentified, and not aligning properly.


Import Test Results - Select File Layout


Select Test Results File  

Once the file layout is selected, click on the Select File(s) to Load button, select the proper data file, and click on Open. Then continue to load and match the records.


Import Test Results - Select data file


The Default Date for the TELPAS test results is the first day of the month/year contained in the data file. The Testing Administration for the test results is MMYY where MM is the month of the Testing Administration Date and YY is the year of the Testing Administration Date. NOTE: We do not recommend updating the Default Date or Testing Administration, especially when import test records from prior administrations. 

If desired, the test results may also be identified by the Source by choosing it from the drop-down menu, although the Source and Type fields are optional. If desired, additional values can be added by the Update Code Table process.


Import Test Results - Default Date and Testing Administration


Matching Students  


The Unique ID is the primary identification in the TELPAS Student Results data files. It should be the first method used for matching students. If there are still large numbers of students unmatched, you can also select other options for matching.


Import Test Results - Match Options


If students are still unmatched, you can print a report of the unmatched students by clicking on the button labeled Print Unmatched Students:


Import Test Results - Unmatched Student Report


The Edit button to the left of the test record can be used to manually match test records to students that may not have been matched during the match process or that may have been matched to an incorrect student. Please see the Import Test Results article for detailed instruction on how to do this.


Import Test Results - Manually match students


Update Test Tables  


The TELPAS Test Results import will add/update records to the Test Scores (TST),Testing Exclusions (TEX), and External Student IDs (ESI) tables. After the import process has completed an email with summary information will be sent to the user that initiated the import.


Import Test Results - Completion Email


Below is a chart of where the significant fields in the TELPAS and TELPAS Alternate data files are stored in the Test Scores (TST) and External Student ID's (ESI) tables: 


For the TELPAS test TST.ID = TELPAS

For the TELPAS Alternate test TST.ID = TELPASA


StartEndField LengthField TitleAeries TableNotes
144Administration DateTST.TD, TST.TAUsed to determine Test Date and Testing Administration
562Grade-Level-CodeTST.GR
486215
Last-Name
May be used during matching process
637210First-Name
May be used during matching process
84918Date-of-birth
May be used during matching process
1451539Local-Student-IDTST.PIDMay be used during matching process
1851906Student Portal Unique Access CodeESI.EID
19120010TX Unique Student-ID (TSDS ID)
May be used during matching process
2632631Listening Proficiency RatingTST.PL where TST.PT = 1
2642652
Listening Tested GradeTST.GR where TST.PT = 1TELPAS only - Grade level of Listening test if different than STU.GR
2732731Speaking Proficiency RatingTST.PL where TST.PT = 2
2742752Speaking Tested GradeTST.GR where TST.PT =2
TELPAS only - Grade level of Speaking test if different than STU.GR
2832831Reading Proficiency RatingTST.PL where TST.PT = 3
2842852Reading Tested GradeTST.GR where TST.PT =3
TELPAS only - Grade level of Reading test if different than STU.GR
2932931Writing Proficiency RatingTST.PL where TST.PT = 4
2942952Writing Tested Grade
TST.GR where TST.PT =4
TELPAS only - Grade level of Writing test if different than STU.GR
3073082Listening Raw ScoreTST.RS where TST.PT = 1
3093124Listening Scale ScoreTST.SS where TST.PT = 1
4354362Writing Raw ScoreTST.RS where TST.PT = 4TELPAS only
4374404Writing Scale ScoreTST.SS where TST.PT = 4TELPAS only
5055062Speaking Raw ScoreTST.RS where TST.PT = 2

5075104Speaking Scale ScoreTST.SS where TST.PT = 2

7077082Reading Raw ScoreTST.RS where TST.PT = 3

7097124Reading Scale ScoreTST.SS where TST.PT = 3

7577582Writing Raw Score
TST.RS where TST.PT =4
**TELPAS Alternate Data file only
7597624
Writing Scale Score
TST.SS where TST.PT =4
**TELPAS Alternate Data file only
9059073TELPAS Composite ScoreTST.PR where TST.PT = 0
9089081TELPAS Composite RatingTST.PL where TST.PT = 0