Navigate to School Info > Imports and Exports > Import Test Results
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 and Initial Alternate 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 2022-23 data files import the caret-delimited (.csv) files into Aeries.
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.
The Default Date for the Initial ELPAC and Initial Alternate 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. 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 Initial ELPAC Student Results data files. It should be the first method used for matching students.
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.
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 and Initial Alternate 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.
NOTE: Test Scores (TST) records will only be created for test parts that include either a Raw Score, Performance Level or Scale Score. Also, the Initial Alternate ELPAC only includes scores for the Overall and Listening test parts.
The Initial ELPAC and Initial Alternate 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.
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.