The Initial ELPAC test results can only be imported from the Import Test Results page in the Aeries Web Version. It will not be able to be imported from Aeries Client Version.
The Import Test Results process will also add the new Initial ELPAC test parts into the Testing Control (CTL) table.
Select the Initial ELPAC Test Results - SY:2018-19 file layout to import the 2018-19 Initial ELPAC student results.
Districts can download a comma-delimited (.csv) file from the testing vendor. The Import Test Results page has been programmed to import only this type of file.
Click on the Select File(s) to Load button, select the Initial ELPAC data file, and click on Open. Then continue to load and match the records.
The Default Date for the Initial ELPAC test results is the oldest DateTesting 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.
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 Initial ELPAC Test Results import will add/update records to the Test Scores (TST), Testing Exclusions (TEX), and Language Assessment (LAC) tables. After the import process has completed an email with summary information will be sent to the user that initiated the import.
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.
Updating the TDB Language Fluency to EL or IFEP
As the Initial ELPAC scores are imported into the Test Scores (TST) table, the Language Assesment 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 Start 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 languge 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.
After the language fluency (STU.LF) and program start date (LAC.SD) or initial fluent proficient start date (LAC.IFD) have been updated with the Initial Fluency (LAC.ITF) and Initial Date (LAC.ITD) information a new SELA record should be sent to CALPADS with the updated information.
Please see the CALPADS SELA Import Process articles for detailed information on the SELA process.