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


NOTE: The data file must be in the format defined in the Initial ELPAC Local Scoring Tool Export 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 (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.



NOTE: As of January 2020 for the SPRG20 administration the Initial ELPAC test results provided by TOMS did not include results for the Listening, Speaking, Reading or Writing subtests. For the SPRG21 administration raw scores are once again included for these test parts.


Select the Initial ELPAC Test Results file layout to import the Initial ELPAC student results. When deciding which year file layout to use, select the file layout that was in effect when the data was downloaded. 


For the 2019-20 data files and forward the only file format that is available from the TOMS site is an Excel (.xlsx) file. This file will need to be converted to a Comma Delimited (.csv) file before it can be imported into Aeries. Once the Initial ELPAC file layout is selected a message will display explaining this.


Import Test Results - IELPAC convert to CSV information box



To convert the file open it in Excel and select Save As. Select the CSV (Comma delimited) (*.csv) file type and then click on the Save button.


Excel - Save as CSV example



After the data file has been converted to a Comma Delimited (.csv) file click on the Select File(s) to Load button on the Import Test Results page, select the Initial ELPAC data file, and click on Open. Then continue to load and match the records.


Import Test Results - select csv data file



The Default Date for the Initial ELPAC test results is the oldest Date Testing Completed date in the data file. The Testing Administration for the test results is MMYY where MM is the month of the Date Testing Completed date and YY is the year of the Date Testing Completed date.


Import Test Results - Default Date, Testing Administration



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


Import Test Results - Match Options - California


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.


The Print Unmatched Students report will list the unmatched students along with some identifying information and can be used as an aid in identifying the students.


Import Test Results - Unmatched Students Report



Once all of the students are matched click on the Update Test Tables button. The Initial ELPAC Test Results import will add/update records to the Test Scores (TST), Testing Exclusions (TEX), and Language Assessment (LAC) tables. The Import Test Results update process will also add the Initial ELPAC test parts into the Testing Control (CTL) table when necessary. 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



The Initial ELPAC test results also include the Initial Fluency level of the students based on their test performance. The Initial Fluency (ITF) value and Date of Initial Fluency (ITD) are updated in the Language Assessment page during the Import Test Results process. 


Language Assessment - General tab Initial ELPAC Result fields



Updating the TBD Language Fluency to EL or IFEP

As the Initial ELPAC scores are imported into the Test Scores (TST) table, the Language Assessment Initial Fluency (LAC.ITF) and Initial Fluency Date (LAC.ITD) fields are also populated with the ELAS and Date Testing Completed provided in the student results file. The LEA will need to update the student's Language Fluency (STU.LF) from TBD to the new Initial Fluency (LAC.ITF) value and the Language Assessment Program Start Date (LAC.SD) or the Language Assessment Initial Fluent English Proficient Date (LAC.IFD) to the Initial Fluency Date (LAC.ITD). The data can be updated by hand or through a change query.


The following query can be used to list all students with a language fluency of TBD and an Initial Fluency other than blank. In this example 'T' is the language fluency code for TBD. You will need to modify the query to use the language fluency codes used by your district.


LIST STU LAC STU.TG STU.ID STU.LN STU.FN STU.GR STU.LF LAC.SD LAC.IFD LAC.ITF LAC.ITD IF STU.LF = "T" AND LAC.ITF # " "


  • After the list of students is reviewed update the IFEP Start Date (LAC.IFD) for the students that have been designated as IFEP and the Program Start Date (LAC.SD) for the students that have been designated EL in the Initial Fluency (LAC.ITF):


CHANGE STU LAC LAC.IFD TO LAC.ITD IF STU.LF = "T" AND LAC.ITF = "IFEP" AND LAC.ITD # NULL AND LAC.IFD = NULL

CHANGE STU LAC LAC.SD TO LAC.ITD IF STU.LF = "T" AND LAC.ITF = "EL" AND LAC.ITD # NULL AND LAC.SD = NULL


  • Then update the language fluency codes (STU.LF) based on the Initial Fluency (LAC.ITF) value. In this example, 'L' is the district's language fluency code for EL and 'I' is the district's language fluency code for IFEP. You will need to modify the queries to use the language fluency codes used by your district. 


CHANGE STU LAC STU.LF TO "L" IF STU.LF = "T" AND LAC.ITF =  "EL" AND LAC.ITD # NULL

CHANGE STU LAC STU.LF TO "I" IF STU.LF = "T" AND LAC.ITF =  "IFEP" AND LAC.ITD # NULL



The following query can be used to review the results:

LIST STU LAC STU.TG STU.ID STU.LN STU.FN STU.GR STU.LF LAC.SD LAC.IFD LAC.ITF LAC.ITD IF LAC.ITF # " "



NOTE: When running the queries, you will need to substitute the language fluency (STU.LF) codes with those used by your district. Also, if inactive student data records need to be updated remember to select the Include Inactives option under the query statement.



Beginning with the 2020-21 school year new SELA records do not need to be sent to CALPADS immediately after importing IELPAC scores and updating the language fluency information for the new students. CALPADS will have already received the new language fluency information during a nightly upload with TOMS. 


Please see the CALPADS SELA Import Process articles for more information on the SELA process and maintaining the most current ELAS data in Aeries and CALPADS.