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.
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.
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.
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
Start | End | Field Length | Field Title | Aeries Table | Notes |
---|---|---|---|---|---|
1 | 4 | 4 | Administration Date | TST.TD, TST.TA CST.TD, CST.TA TEX.TD, TEX.TA | Used to determine Test Date and Testing Administration |
5 | 6 | 2 | Grade-Level-Tested | TST.GR CST.GR TEX.GR | |
48 | 62 | 15 | Last-Name | May be used during matching process | |
63 | 72 | 10 | First-Name | May be used during matching process | |
84 | 91 | 8 | Date-of-birth | May be used during matching process | |
123 | 131 | 9 | Local-Student-ID | TST.PID CST.PID TEX.PID | May be used during matching process |
157 | 162 | 6 | Student Portal Unique Access Code | ESI.EID | |
191 | 200 | 10 | TX Unique Student-ID (TSDS ID) | May be used during matching process | |
252 | 263 | multiple single character fields | Reading Accommodations | TEX.PRB where TEX.PT = 1 | |
273 | 283 | multiple single character fields | Mathematics Accommodations | TEX.PRB where TEX.PT = 2 | |
286 | 286 | 1 | Auto Text-to-Speech - Reading | TEX.PRB where TEX.PT = 1 | |
287 | 287 | 1 | Auto Text-to-Speech - Mathematics | TEX.PRB where TEX.PT = 2 | |
288 | 288 | 1 | Auto Text-to-Speech - Social Studies | TEX.PRB where TEX.PT = 4 | |
289 | 289 | 1 | Auto Text-to-Speech - Science | TEX.PRB where TEX.PT = 5 | |
312 | 323 | multiple single character fields | Social Studies Accommodations | TEX.PRB where TEX.PT = 4 | |
332 | 343 | multiple single character fields | Science Accommodations | TEX.PRB where TEX.PT = 4 | |
351 | 351 | 1 | Score Code - Reading | TEX.SRC where TEX.PT = 1 | If not 'S', then will create a TEX record |
352 | 352 | 1 | Score Code - Mathematics | TEX.SRC where TEX.PT = 2 | If not 'S', then will create a TEX record |
354 | 354 | 1 | Score Code Social Studies | TEX.SRC where TEX.PT = 4 | If not 'S', then will create a TEX record |
355 | 355 | 1 | Score Code Science | TEX.SRC where TEX.PT = 5 | If not 'S', then will create a TEX record |
401 | 402 | 2 | Reading Reporting Category 1 Scores | CST.RS where CST.PT = 7 | CST.ID = READ38 or READ38S |
403 | 404 | 2 | Reading Reporting Category 2 Scores | CST.RS where CST.PT = 8 | CST.ID = READ38 or READ38S |
405 | 406 | 2 | Performance Level Indicator - Reading | TST.PI where TST.PT = 1 | used to determine Performance Indicator |
407 | 408 | 2 | Reading Raw Score | TST.RS where TST.PT = 1 | |
409 | 412 | 4 | Reading Scale Score | TST.SS where TST.PT = 1 | |
413 | 413 | 1 | Reading Language Version | TST.ID | Used to determine TST.ID E -TST.ID = STR38 S -TST.ID = STR38S |
423 | 425 | multiple single character fields | Meets /Approaches /Masters Grade Level | TST.PL where TST.PT =1 | Used to determine Performance Level |
445 | 445 | 1 | EL Performance Measure – Reading Language Arts | TST.ELP where TST.PT = 1 | Used to determine EL Performance Measure |
607 | 611 | 5 | Lexile Measure | TST.LX where TST.PT = 1 | Stored as a numeric value |
612 | 614 | 3 | Percentile | TST.PC where TST.PT = 1 | |
751 | 752 | 2 | Mathematics Reporting Category 1 Scores | CST.RS where CST.PT = 1 or CST.PT = 5 for grade 7 | CST.ID = MATH38 or MATH38S |
753 | 754 | 2 | Mathematics Reporting Category 2 Scores | CST.RS where CST.PT = 2 | CST.ID = MATH38 or MATH38S |
755 | 756 | 2 | Mathematics Reporting Category 3 Scores | CST.RS where CST.PT = 3 | CST.ID = MATH38 or MATH38S |
757 | 758 | 2 | Mathematics Reporting Category 4 Scores | CST.RS where CST.PT = 4 | CST.ID = MATH38 or MATH38S |
759 | 760 | 2 | Performance Level Indicator - Mathematics | TST.PI where TST.PT = 2 | used to determine Performance Indicator |
761 | 762 | 2 | Mathematics Raw Score | TST.RS where TST.PT = 2 | |
763 | 766 | 4 | Mathematics Scale Score | TST.SS where TST.PT = 2 | |
767 | 767 | 1 | Mathematics Language Version | TST.ID | Used to determine TST.ID E -TST.ID = STR38 S -TST.ID = STR38S |
777 | 779 | multiple single character fields | Meets /Approaches /Masters Grade Level | TST.PL where TST.PT =2 | used to determine Performance Level |
798 | 798 | 1 | EL Performance Measure – Mathematics | TST.ELP where TST.PT = 2 | Used to determine EL Performance Measure |
969 | 971 | 3 | Percentile - Mathematics | TST.PC where TST.PT = 2 | |
972 | 976 | 5 | Quantile Measure | TST.QT where TST.PT = 2 | stored as a numeric value |
1501 | 1502 | 2 | Social Studies Reporting Category 1 Scores | CST.RS where CST.PT = 1 | CST.ID = SOCS38 |
1503 | 1504 | 2 | Social Studies Reporting Category 2 Scores | CST.RS where CST.PT = 2 | CST.ID = SOCS38 |
1505 | 1506 | 2 | Social Studies Reporting Category 3 Scores | CST.RS where CST.PT = 3 | CST.ID = SOCS38 |
1507 | 1508 | 2 | Social Studies Reporting Category 4 Scores | CST.RS where CST.PT = 4 | CST.ID = SOCS38 |
1509 | 1510 | 2 | Social Studies Raw Score | TST.RS where TST.PT = 4 | |
1511 | 1514 | 4 | Social Studies Scale Score | TST.SS where TST.PT = 4 | |
1515 | 1515 | 1 | Social Studies Language Version | TST.ID | Used to determine TST.ID E -TST.ID = STR38 |
1519 | 1520 | 2 | Performance Level Indicator – Social Studies | TST.PI | |
1525 | 1527 | multiple single character fields | Meets /Approaches /Masters Grade Level | TST.PL where TST.PT =4 | used to determine Performance Level |
1528 | 1528 | 1 | EL Performance Measure – Social Studies | TST.ELP where TST.PT = 4 | Used to determine EL Performance Measure |
1751 | 1759 | 3 | Percentile - Social Studies | TST.PC where TST.PT = 4 | |
1901 | 1902 | 2 | Science Reporting Category 1 Scores | CST.RS where CST.PT = 1 | CST.ID = SCI38 or SCI38S |
1903 | 1904 | 2 | Science Reporting Category 2 Scores | CST.RS where CST.PT = 2 | CST.ID = SCI38 or SCI38S |
1905 | 1906 | 2 | Science Reporting Category 3 Scores | CST.RS where CST.PT = 3 | CST.ID = SCI38 or SCI38S |
1907 | 1908 | 2 | Science Reporting Category 4 Scores | CST.RS where CST.PT = 4 | CST.ID = SCI38 or SCI38S |
1909 | 1910 | 2 | Science Raw Score | TST.RS where TST.PT = 5 | |
1911 | 1914 | 4 | Science Scale Score | TST.SS where TST.PT = 5 | |
1915 | 1915 | 1 | Science Language Version | TST.ID | Used to determine TST.ID E -TST.ID = STR38 S - TST.ID = STR38S |
1919 | 1920 | 2 | Performance Level Indicator – Science | TST.PI | |
1925 | 1927 | multiple single character fields | Meets /Approaches /Masters Grade Level | TST.PL where TST.PT =5 | used to determine Performance Level |
1928 | 1928 | 1 | EL Performance Measure – Science | TST.ELP where TST.PT = 5 | Used to determine EL Performance Measure |
2163 | 2165 | 3 | Percentile - Science | TST.PC where TST.PT = 5 |
For the STAAR Alt 2 3-8 test TST.ID = STR382
Start | End | Field Length | Field Title | Aeries Table | Notes |
---|---|---|---|---|---|
1 | 4 | 4 | Administration Date | TST.TD, TST.TA CST.TD, CST.TA TEX.TD, TEX.TA | Used to determine Test Date and Testing Administration |
5 | 6 | 2 | Grade-Level-Code | TST.GR CST.GR TEX.GR | |
48 | 62 | 15 | Last-Name | May be used during matching process | |
63 | 72 | 10 | First-Name | May be used during matching process | |
84 | 91 | 8 | Date-of-birth | May be used during matching process | |
123 | 131 | 9 | Local-Student-ID | TST.PID CST.PID TEX.PID | May be used during matching process |
157 | 162 | 6 | Student Portal Unique Access Code | ESI.EID | |
191 | 200 | 10 | TX Unique Student-ID (TSDS ID) | May be used during matching process | |
351 | 351 | 1 | Score Code - Reading | TEX.SRC where TEX.PT = 1 | If not 'S', then will create a TEX record |
352 | 352 | 1 | Score Code - Mathematics | TEX.SRC where TEX.PT = 2 | If not 'S', then will create a TEX record |
354 | 354 | 1 | Score Code Social Studies | TEX.SRC where TEX.PT = 4 | If not 'S', then will create a TEX record |
355 | 355 | 1 | Score Code Science | TEX.SRC where TEX.PT = 5 | If not 'S', then will create a TEX record |
401 | 402 | 2 | Reading Reporting Category 1 Scores | CST.RS where CST.PT = 4 | CST.ID = READ38 |
403 | 404 | 2 | Reading Reporting Category 2 Scores | CST.RS where CST.PT = 5 | CST.ID = READ38 |
405 | 406 | 2 | Performance Level Indicator | TST.PI where TST.PT = 1 | used to determine Performance Indicator |
407 | 408 | 2 | Reading Raw Score | TST.RS where TST.PT = 1 | |
409 | 412 | 4 | Reading Scale Score | TST.SS where TST.PT = 1 | |
424 | 425 | multiple single character fields | Satisfactory /Accomplished Academic Performance | TST.PL where TST.PT =1 | used to determine Performance Level |
651 | 666 | multiple single character fields | Reading Alt 2 Accommodations | TEX.PRB where TEX.PT = 1 | |
751 | 752 | 2 | Mathematics Reporting Category 1 Scores | CST.RS where CST.PT = 1 or CST.PT = 5 for grade 7 | CST.ID = MATH38 |
753 | 754 | 2 | Mathematics Reporting Category 2 Scores | CST.RS where CST.PT = 2 | CST.ID = MATH38 |
755 | 756 | 2 | Mathematics Reporting Category 3 Scores | CST.RS where CST.PT = 3 | CST.ID = MATH38 |
757 | 758 | 2 | Mathematics Reporting Category 4 Scores | CST.RS where CST.PT = 4 | CST.ID = MATH38 |
759 | 760 | 2 | Performance Level Indicator | TST.PI where TST.PT = 2 | used to determine Performance Indicator |
761 | 762 | 2 | Mathematics Raw Score | TST.RS where TST.PT = 2 | |
763 | 766 | 4 | Mathematics Scale Score | TST.SS where TST.PT = 2 | |
778 | 779 | multiple single character fields | Satisfactory /Accomplished Academic Performance | TST.PL where TST.PT =2 | used to determine Performance Level |
1001 | 1016 | multiple single character fields | Mathematics Alt 2 Accommodations | TEX.PRB where TEX.PT = 2 | |
1501 | 1502 | 2 | Social Studies Reporting Category 1 Scores | CST.RS where CST.PT = 1 | CST.ID = SOCS38 |
1503 | 1504 | 2 | Social Studies Reporting Category 2 Scores | CST.RS where CST.PT = 2 | CST.ID = SOCS38 |
1505 | 1506 | 2 | Social Studies Reporting Category 3 Scores | CST.RS where CST.PT = 3 | CST.ID = SOCS38 |
1507 | 1508 | 2 | Social Studies Reporting Category 4 Scores | CST.RS where CST.PT = 4 | CST.ID = SOCS38 |
1509 | 1510 | 2 | Social Studies Raw Score | TST.RS where TST.PT = 4 | |
1511 | 1514 | 4 | Social Studies Scale Score | TST.SS where TST.PT = 4 | |
1526 | 1527 | multiple single character fields | Satisfactory /Accomplished Academic Performance | TST.PL where TST.PT =4 | used to determine Performance Level |
1801 | 1816 | multiple single character fields | Social Studies Alt 2 Accommodations | TEX.PRB where TEX.PT = 4 | |
1901 | 1902 | 2 | Science Reporting Category 1 Scores | CST.RS where CST.PT = 1 | CST.ID = SCI38 |
1903 | 1904 | 2 | Science Reporting Category 2 Scores | CST.RS where CST.PT = 2 | CST.ID = SCI38 |
1905 | 1906 | 2 | Science Reporting Category 3 Scores | CST.RS where CST.PT = 3 | CST.ID = SCI38 |
1907 | 1908 | 2 | Science Reporting Category 4 Scores | CST.RS where CST.PT = 4 | CST.ID = SCI38 |
1909 | 1910 | 2 | Science Raw Score | TST.RS where TST.PT = 5 | |
1911 | 1914 | 4 | Science Scale Score | TST.SS where TST.PT = 5 | |
1926 | 1927 | multiple single character fields | Satisfactory /Accomplished Academic Performance | TST.PL where TST.PT =5 | used to determine Performance Level |
2201 | 2216 | multiple single character fields | Science Alt 2 Accommodations | TEX.PRB where TEX.PT = 5 |