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

The Import Test Results process will add any new ELPAC test parts into the Testing Control (CTL) table when the ELPAC data is uploaded into Aeries.

NOTE: The data file must be in the format defined in the ELPAC Student Data File Layout found on the ELPAC Test Administration Score Reporting website. Only the LEA ELPAC Coordinator has the necessary permissions in the TOMS site to download the Student Score Data Extract. Please note that the score reports available from the Online Reporting system are not in the correct format, the correct file (Summative Student Score Data Extract) can only be downloaded by the LEA ELPAC Coordinator from within TOMS. For more information on finding the correct ELPAC Student Score data file please see the Downloading ELPAC and IELPAC scores from TOMS article. 

Select the ELPAC Test Results file layout to import the ELPAC student results. When deciding which year file layout to use, select the file layout from the school year in which the results were downloaded, rather than the school year in which the test was taken. 

Import Test Results - Select the test/layout you want to import

Districts will download a .zip file that contains both a text (.dat) file and a caret-delimited (.csv) file from the testing vendor. The Import Test Results page has been programmed to import the caret-delimited (.csv) file.

Click on the Select File(s) to Load button, select the .csv file, and click on Open. Then continue to load and match the records.

Import Test Results - Select File(s) to Load

The Default Date for the ELPAC test results is not necessary as all records have testing dates. The Testing Administration for the test results is MMYY where MM is the month of the Testing Completed Date and YY is the year of the Testing Completed Date. They will be loaded into each student's TST record. NOTE: We do not recommend updating the Default Date or Testing Administration, especially when import test records from prior administrations.

Import Test Results - Default Date and Testing Administration

The Student State ID is the primary identification in the ELPAC Student Results data files. It should be the first method used for matching students.

Import Test Results - Match Options

Click on the Print Unmatched Students button to print a report listing any students that were not able to be matched.

Import Test Results - Unmatched Students 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 - Match a student manually

The ELPAC Test Results import will add/update records to the Test Scores (TST) and Testing Exclusions (TEX) 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 for ELPAC

Below is a chart of where the significant fields in the ELPAC data file are stored in the Test Scores (TST) and Testing Exclusions (TEX) tables:

For the Summative ELPAC test TST.ID = ELPAC

For the Alternate ELPAC test TST.ID = AELPAC

Field #LengthField NameAeries TableNotes
12RecordTypeTST.IDUsed to determine if the data is for the ELPAC or Alternate ELPAC
21 = ELPAC
23 = Alt ELPAC
May be used during matching process
615LocalStudentIDTST.PIDMay be used during matching process
May be used during matching process
May be used during matching process
May be used during matching process
7010TestCompetedDate1TST.TD, TST.DT
Test date for Listening record (TST.PT = 3)
7910TestCompletedDate2 **TST.TD, TST.DTTest date for Speaking record (TST.PT = 4)
TestCompletedDate3 **TST.TD, TST.DTTest date for Reading record (TST.PT = 5
9710TestCompletedDate4 **TST.TD, TST.DTTest date for Writing record (TST.PT = 6)
10510FinalTestCompletedDateTST.TD, TST.DT, TST.TATest date for Overall, Oral and Written records (TST.PT = 0, TST.PT = 1, TST.PT = 2)

Also, the Testing Administration (TST.TA) for all test parts is derived from this date.
1362RawScore1 **TST.RSFor Listening (TST.PT = 3)
1372RawScore2 **TST.RSFor Speaking (TST.PT = 4
1382RawScore3 **TST.RSFor Reading (TST.PT = 5)
1392RawScore4 **TST.RSFor Writing (TST.PT = 6)
1404OverallScaleScoreTST.SSFor Overall (TST.PT = 0)
1414OralLanguageScaleScore **TST.SSFor Oral Language (TST.PT = 1)
1424WrittenLanguageScaleScore **TST.SSFor Written Language (TST.PT = 2)
1432OverallPLTST.PLFor Overall (TST.PT = 0)
1442OralLanguagePL **TST.PLFor Oral Language (TST.PT = 1)
1452WrittenLanguagePL **TST.PLFor Written Language (TST.PT = 2
1492ListeningPL **TST.PLFor Listening (TST.PT = 3)
1502SpeakingPL **TST.PLFor Speaking (TST.PT = 4)
1512ReadingPL **TST.PLFor Reading (TST.PT = 5)
1522WritingPL**TST.PLFor Writing (TST.PT = 6)
1531DomainEx1 **
TEX.ERSFor Listening (TEX.PT = 3)
1541DomainEx2 **TEX.ERSFor Speaking (TEX.PT = 4)
1551DomainEx3 **TEX.ERSFor Reading (TEX.PT = 5)
1561DomainEx4 **TEX.ERSFor Writing (TEX.PT = 6)

** = Data provided for only the Summative ELPAC

*** = Data provided for only the Alternate ELPAC