Select File Layout  

Select Test Results File  

Matching Students  

Update Test Tables  

Test Scores  

Test Details  

Chart for Field Data Elements 


Overview 

Navigate to School Info > Imports and Exports


The Import Test Results process can import both the STAAR 3-8 and STAAR Alternate 2 3-8 student test results files. For best results, load test files at the district level when possible. The Import Test Results process will also add any new STAAR and STAAR Alternate test parts into the Testing Control (CTL) table and the Content Standard Names (CSN) table when the file layout is selected. 


Select File Layout  

Select the proper STAAR 3-8 Test Results file layout to import the STAAR 3-8 student results file. The data file must be in the format defined in the STAAR Grades 3-8 or STAAR Alternate 2 Grades 3-8 Student Data File Layouts 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 STAAR 3-8 and STAAR Alternate 2 3-8 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.





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


Import Test Results - select data file


The system will attempt to validate the data file against the file layout that was selected in Step 1 by looking for key words in the file layout name. If the key words do not exist a warning message will come up to check that the correct file layout and data file were selected. In the below example the STAAR Alt 2 3-8 file layout was selected, but the data file is the STAAR EOC. The warning message comes up alerting the customer to double-check that the correct data file was selected. After clicking on the OK to remove the warning the customer can click on the Clear button to remove the data file and then select a new file. 



Once the correct data file has been opened, click on the Upload file(s) and create temp data button to load the data file. A progress bar will display as the file is loaded.



The Default Date  and Testing Administration for the STAAR test results is derived from the Administration Date field contained in the data file (fields 1-4 of each record) . The Aeries Testing Administration (TST.TA, CST.TA, and TEX.TA) for the test results is SPRGXX where XX is the year of the month/year contained in the data file. 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 include an identification of the data source by choosing it from the Source drop-down menu, although the Source and Type fields are optional. Additional values can be added to both of these dropdowns through the Update Code Table process.




Matching Students  

Click on the Match Students button to match the students in the data file to the students in Aeries. The Unique ID is the primary identification in the STAAR 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:



Finally, students can be matched manually by searching by name, Student ID or Unique ID, or by entering the Student ID number directly into the matching field. For best results, please match as many students as possible before loading the test results.


Import Test Results - update Student ID manually


Update Test Tables  

The STAAR Test Results import will add/update records to the Test Scores (TST), Content Standard Scores (CST), Test 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.



The Test ID that is saved in the Test Scores (TST.ID), Content Standards Scores (CST.ID) and Test Exclusions (TEX.ID) tables depends on which test was imported and the Language Version that the student used for each test part:


  • STAAR Alternate 2 3-8 imports will have a test id of STR382
  • STAAR 3-8 imports where the Language Version is English for the test part will have a test id of STR38
  • STAAR 3-8 imports where the Language Version is Spanish for the test part will have a test id of STR38S


Test Scores  


In the below example the student took an English language version of the STAAR 3-8 Mathematics test, but a Spanish language version of the STAAR 3-8 Reading test. 



Test Details  


The Test Details will display with the Testing Administration date, Scale Score, Performance Level Indicator, and EL Performance Measure. If the Performance Level Indicator has a value of 0 or 99, this will translate to n/a for the test score.



Chart for Field Data Elements

Below are charts of where the significant fields in the STAAR 3-8 and STAAR Alt 2 3-8 data files are stored in the Test Scores (TST), Content Standards (CST), Testing Exclusions (TEX), and External Student ID's (ESI) tables: 


For the STAAR 3-8 test TST.ID = STR38

For the STAAR 3-8 Language Version Spanish test TST.ID = STR38S


StartEndField LengthField TitleAeries TableNotes
144Administration DateTST.TD, TST.TA
CST.TD, CST.TA
TEX.TD, TEX.TA
Used to determine Test Date and Testing Administration
562Grade-Level-TestedTST.GR
CST.GR
TEX.GR

486215Last-Name
May be used during matching process
637210First-Name
May be used during matching process
84918Date-of-birth
May be used during matching process
1231319Local-Student-IDTST.PID
CST.PID
TEX.PID
May be used during matching process
1571626Student Portal Unique Access CodeESI.EID
19120010TX Unique Student-ID (TSDS ID)
May be used during matching process
252263multiple single character fieldsReading AccommodationsTEX.PRB where TEX.PT = 1
273283multiple single character fieldsMathematics AccommodationsTEX.PRB where TEX.PT = 2
2862861Auto Text-to-Speech - ReadingTEX.PRB where TEX.PT = 1
2872871Auto Text-to-Speech - MathematicsTEX.PRB where TEX.PT = 2
2882881Auto Text-to-Speech - Social StudiesTEX.PRB where TEX.PT = 4
2892891Auto Text-to-Speech - ScienceTEX.PRB where TEX.PT = 5
312323multiple single character fieldsSocial Studies AccommodationsTEX.PRB where TEX.PT = 4
332343multiple single character fieldsScience AccommodationsTEX.PRB where TEX.PT = 4
3513511Score Code - ReadingTEX.SRC where TEX.PT = 1If not 'S', then will create a TEX record
3523521Score Code - MathematicsTEX.SRC where TEX.PT = 2If not 'S', then will create a TEX record
3543541Score Code Social StudiesTEX.SRC where TEX.PT = 4If not 'S', then will create a TEX record
3553551Score Code ScienceTEX.SRC where TEX.PT = 5If not 'S', then will create a TEX record
4014022Reading Reporting Category 1 ScoresCST.RS where CST.PT = 7CST.ID = READ38 or READ38S
4034042Reading Reporting Category 2 ScoresCST.RS where CST.PT = 8CST.ID = READ38 or READ38S
4054062Performance Level Indicator - ReadingTST.PI where TST.PT = 1used to determine Performance Indicator
4074082Reading Raw ScoreTST.RS where TST.PT = 1
4094124Reading Scale ScoreTST.SS where TST.PT = 1
4134131Reading Language VersionTST.IDUsed to determine TST.ID
E -TST.ID = STR38
S -TST.ID = STR38S
423425multiple single character fieldsMeets
/Approaches
/Masters Grade Level
TST.PL where TST.PT =1Used to determine Performance Level
4454451

EL Performance Measure – Reading

Language Arts

TST.ELP where TST.PT = 1Used to determine EL Performance Measure
6076115Lexile MeasureTST.LX where TST.PT = 1Stored as a numeric value
6126143PercentileTST.PC where TST.PT = 1
7517522Mathematics Reporting Category 1 ScoresCST.RS where CST.PT = 1
or CST.PT = 5 for grade 7
CST.ID = MATH38 or MATH38S
7537542Mathematics Reporting Category 2 ScoresCST.RS where CST.PT = 2CST.ID = MATH38 or MATH38S 
7557562Mathematics Reporting Category 3 ScoresCST.RS where CST.PT = 3CST.ID = MATH38 or MATH38S
7577582Mathematics Reporting Category 4 ScoresCST.RS where CST.PT = 4CST.ID = MATH38 or MATH38S
7597602Performance Level Indicator - MathematicsTST.PI where TST.PT = 2used to determine Performance Indicator
7617622Mathematics Raw ScoreTST.RS where TST.PT = 2
7637664Mathematics Scale ScoreTST.SS where TST.PT = 2
7677671Mathematics Language VersionTST.IDUsed to determine TST.ID
E -TST.ID = STR38
S -TST.ID = STR38S
777779multiple single character fieldsMeets
/Approaches
/Masters Grade Level
TST.PL where TST.PT =2used to determine  Performance Level
7987981

EL Performance Measure –

Mathematics

TST.ELP where TST.PT = 2
Used to determine EL Performance Measure
9699713Percentile - MathematicsTST.PC where TST.PT = 2
9729765Quantile MeasureTST.QT where TST.PT = 2stored as a numeric value
150115022Social Studies Reporting Category 1 ScoresCST.RS where CST.PT = 1CST.ID = SOCS38
150315042Social Studies Reporting Category 2 ScoresCST.RS where CST.PT = 2CST.ID = SOCS38
150515062Social Studies Reporting Category 3 ScoresCST.RS where CST.PT = 3CST.ID = SOCS38
150715082Social Studies Reporting Category 4 ScoresCST.RS where CST.PT = 4CST.ID = SOCS38
150915102Social Studies Raw ScoreTST.RS where TST.PT = 4
151115144Social Studies Scale ScoreTST.SS where TST.PT = 4
151515151Social Studies Language VersionTST.IDUsed to determine TST.ID
E -TST.ID = STR38
151915202

Performance Level Indicator – Social

Studies

TST.PI
15251527multiple single character fieldsMeets
/Approaches
/Masters Grade Level
TST.PL where TST.PT =4used to determine  Performance Level
152815281

EL Performance Measure – Social

Studies

TST.ELP where TST.PT = 4
Used to determine EL Performance Measure
175117593Percentile - Social StudiesTST.PC where TST.PT = 4
190119022Science Reporting Category 1 ScoresCST.RS where CST.PT = 1CST.ID = SCI38 or SCI38S
190319042Science Reporting Category 2 ScoresCST.RS where CST.PT = 2CST.ID = SCI38 or SCI38S
190519062Science Reporting Category 3 ScoresCST.RS where CST.PT = 3CST.ID = SCI38 or SCI38S
190719082Science Reporting Category 4 ScoresCST.RS where CST.PT = 4CST.ID = SCI38 or SCI38S
190919102Science Raw ScoreTST.RS where TST.PT = 5
191119144Science Scale ScoreTST.SS where TST.PT = 5
191519151Science Language VersionTST.IDUsed to determine TST.ID
E -TST.ID = STR38
S - TST.ID = STR38S
191919202

Performance Level Indicator –

Science

TST.PI
19251927multiple single character fieldsMeets
/Approaches
/Masters Grade Level
TST.PL where TST.PT =5used to determine  Performance Level
192819281EL Performance Measure – Science
TST.ELP where TST.PT = 5
Used to determine EL Performance Measure
216321653Percentile - ScienceTST.PC where TST.PT = 5



For the STAAR Alt 2 3-8 test TST.ID = STR382


StartEndField LengthField TitleAeries TableNotes
144Administration DateTST.TD, TST.TA
CST.TD, CST.TA
TEX.TD, TEX.TA
Used to determine Test Date and Testing Administration
562Grade-Level-CodeTST.GR
CST.GR
TEX.GR

486215Last-Name
May be used during matching process
637210First-Name
May be used during matching process
84918Date-of-birth
May be used during matching process
1231319Local-Student-IDTST.PID
CST.PID
TEX.PID
May be used during matching process
1571626Student Portal Unique Access CodeESI.EID
19120010TX Unique Student-ID (TSDS ID)
May be used during matching process
3513511Score Code - ReadingTEX.SRC where TEX.PT = 1If not 'S', then will create a TEX record
3523521Score Code - MathematicsTEX.SRC where TEX.PT = 2If not 'S', then will create a TEX record
3543541Score Code Social StudiesTEX.SRC where TEX.PT = 4If not 'S', then will create a TEX record
3553551Score Code ScienceTEX.SRC where TEX.PT = 5If not 'S', then will create a TEX record
4014022Reading Reporting Category 1 ScoresCST.RS where CST.PT = 4CST.ID = READ38 
4034042Reading Reporting Category 2 ScoresCST.RS where CST.PT = 5CST.ID = READ38 
4054062Performance Level IndicatorTST.PI where TST.PT = 1used to determine Performance Indicator
4074082Reading Raw ScoreTST.RS where TST.PT = 1
4094124Reading Scale ScoreTST.SS where TST.PT = 1
424425multiple single character fieldsSatisfactory
/Accomplished Academic Performance
TST.PL where TST.PT =1used to determine  Performance Level
651666multiple single character fieldsReading Alt 2 AccommodationsTEX.PRB where TEX.PT = 1
7517522Mathematics Reporting Category 1 ScoresCST.RS where CST.PT = 1
or CST.PT = 5 for grade 7
CST.ID = MATH38 
7537542Mathematics Reporting Category 2 ScoresCST.RS where CST.PT = 2CST.ID = MATH38
7557562Mathematics Reporting Category 3 ScoresCST.RS where CST.PT = 3CST.ID = MATH38 
7577582Mathematics Reporting Category 4 ScoresCST.RS where CST.PT = 4CST.ID = MATH38 
7597602Performance Level IndicatorTST.PI where TST.PT = 2used to determine Performance Indicator
7617622Mathematics Raw ScoreTST.RS where TST.PT = 2
7637664Mathematics Scale ScoreTST.SS where TST.PT = 2
778779multiple single character fieldsSatisfactory
/Accomplished Academic Performance
TST.PL where TST.PT =2used to determine  Performance Level
10011016multiple single character fieldsMathematics Alt 2 AccommodationsTEX.PRB where TEX.PT = 2
150115022Social Studies Reporting Category 1 ScoresCST.RS where CST.PT = 1CST.ID = SOCS38
150315042Social Studies Reporting Category 2 ScoresCST.RS where CST.PT = 2CST.ID = SOCS38
150515062Social Studies Reporting Category 3 ScoresCST.RS where CST.PT = 3CST.ID = SOCS38
150715082Social Studies Reporting Category 4 ScoresCST.RS where CST.PT = 4CST.ID = SOCS38
150915102Social Studies Raw ScoreTST.RS where TST.PT = 4
151115144Social Studies Scale ScoreTST.SS where TST.PT = 4
15261527multiple single character fieldsSatisfactory
/Accomplished Academic Performance
TST.PL where TST.PT =4used to determine  Performance Level
18011816multiple single character fieldsSocial Studies Alt 2 AccommodationsTEX.PRB where TEX.PT = 4
190119022Science Reporting Category 1 ScoresCST.RS where CST.PT = 1CST.ID = SCI38 
190319042Science Reporting Category 2 ScoresCST.RS where CST.PT = 2CST.ID = SCI38 
190519062Science Reporting Category 3 ScoresCST.RS where CST.PT = 3CST.ID = SCI38 
190719082Science Reporting Category 4 ScoresCST.RS where CST.PT = 4CST.ID = SCI38 
190919102Science Raw ScoreTST.RS where TST.PT = 5
191119144Science Scale ScoreTST.SS where TST.PT = 5
19261927multiple single character fieldsSatisfactory
/Accomplished Academic Performance
TST.PL where TST.PT =5used to determine  Performance Level
22012216multiple single character fieldsScience Alt 2 AccommodationsTEX.PRB where TEX.PT = 5