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. 



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.



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.



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.



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
510SSID
May be used during matching process
615LocalStudentIDTST.PIDMay be used during matching process
850StudentLastName
May be used during matching process
930StudentFirstName
May be used during matching process
1310DateofBirth
May be used during matching process
172GradeAssessedTST.GR
7010TestCompetedDate1TST.TD, TST.DT
Test date for Listening record (TST.PT = 3)
7910TestCompletedDate2 **TST.TD, TST.DTTest date for Speaking record (TST.PT = 4)
8810
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