The 2015-16 through 2017-18 CAASPP Student 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. 


NOTE: The data file must be in the format defined in the CAASPP Student Data File Layout found on the CAASPP Test Administration Score Reporting website. Only the LEA CAASPP 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 CAASPP Online Reporting system are not in the correct format, the correct file (Student Score Data Extract) can only be downloaded by the LEA CAASPP Coordinator from within TOMS. For more information on finding the correct CAASPP Student Score data file please see the Finding the CAASPP Caret Delimited File article.



Select the appropriate file layout to import the CAASPP Student Results. In the below example the CAASPP Test Results - SY:2017-18 file layout was selected in order to import the 2017-18 CAASPP score data.



Districts can download 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 only the caret-delimited (.csv) file. If the text (.dat) file is selected to load, a message will appear explaining that files with a .dat extension are not supported.



If this message displays, click OK, click on the Select File(s) to Load button, select the file with the .csv extension, and click on Open. Then continue to load and match the records.



The Default Date for the CAASPP Test Results is the oldest date in the data file. The Testing Administration for the Test Results is SPRGXX where XX is the end of the school year for the data being imported (ex. 2017-18 test results would have a SPRG18 Testing Administration).



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



The CAASPP Student Results import will add/update records to the Test Scores (TST), Content Standards Scores (CST), Testing Exclusions (TEX), and Authorizations (AUT) tables. After the import process has completed an email with summary information will be sent to the user that initiated the import.