NOTE:  Recently TOMS released 2021-22 file layouts for the ELPAC Test Settings and the ELPAC Student Test Assignment. We will be reviewing these file layouts to see if there are any changes.


Navigate to School Info > Imports and Exports > State Testing Export Files


The ELPAC Student Test Settings (Accomodations) option allows the user to extract data from the Test Settings (STS) table which can then be copied into the ELPAC-Online-Student-Test-Settings-Template.2020-21.xlsx provided by ELPAC. Once the template file has been populated with the Test Settings data it can be uploaded into TOMS to update the students’ test settings/ accommodations/ modifications for the ELPAC assessment.


The ELPAC-Online-Student-Test-Settings-Template.2020-21.xlsx file must be downloaded from the ELPAC website (https://www.elpac.org/test-administration/instructions/) and saved on the computer that will create the extract.


NOTE:  The ELPAC-Online-Student-Test-Settings-Template.2020-21.xlsx file must be the original file downloaded from the ELPAC website, with no student information in it. 


On the State Testing Export Files screen enter a date in the Include active settings with a start date on or before this date field. The date is used to determine which Test Settings records will be included in the extract. To be included in the extract the Test Settings Start Date (STS.SD) must be less than or equal to the entered date and the Test Settings End Date (STS.ED) must either be greater than the entered date or must be Null.  If you wish to limit the extracted records to certain students click on the Aeries QUERY button and run a query to limit to the desired students. Checkboxes to Include Inactive Students and to Limit to English Learners are also available to further limit the students in the extract file.


State Testing Export Files - ELPAC Student Test Settings option



Once all selections have been made click on the Download File button. A file called ELPACTestSettings20yymmdd.csv will be created (where yymmdd are the year, month and day that the file was created for). This file may open immediately on your computer, or it may download as shown below.


State Testing Export Files - downloaded file


Open the file to view the extracted records.


State Testing Export Files - ELPAC Student Test Settings example



These records need to be copied from the file and pasted into the ELPAC-Online-Student-Test-Settings-Template.2020-21.xlsx  template file. Copy the results by selecting the records, right click and select Copy.


Open up the ELPAC-Online-Student-Test-Settings-Template.2020-21.xlsx file provided by ELPAC, right-click in the A2 cell of the Test Settings Template worksheet and select Paste. Be sure to leave the first row intact. This row must not be modified.


Excel - Paste


State Testing Export Files - ELPAC Student Test Settings template with data


The template file will now have the provided header records followed by the student records. Save the file. Import this file into TOMS.