Downloading the Data File from CAASPP


The CAASPP Interim Assessment data file must be the district level data file. To download the file from TOMS follow these steps;


From the CAASPP site (www.caaspp.org) click on the Resources tab and the Interim Assessments link.



Click on the Interim Assessment Reporting System button.



Log into the Smarter Balanced Reporting System



Click on the District/School Exports button on the Export data for analysis in another application card.



Enter a Name for the export file

Select the School Year

Select to Show or Hide results from other schools for New Students

Click on the Select All checkbox to include all schools

Click on the Export Results button



The Interim Assessment extract can be downloaded from the My Reports page.



Click on the 3-dot icon to open up a menu.



Click on the Download Report Data link.



This should create a CSV file with all district and/or school assessment results. Do not open up the CSV file in Excel. Doing this could alter the data.


If you wish to review the data in Excel then download a second copy for that purpose. The file that is used to import into Aeries must be in the original csv format and not potentially altered by Excel.



Interim Assessment Tests - IAB and ICA


The CAASPP Interim Assessments are comprised of two different types of test. The Interim Comprehensive Assessment (ICA) mirrors the summative assessments in scope and format. ICA tests can be taken up to 3 times in a school year. The Interim Assessment Block (IAB) includes a smaller, focused set of items that measure several assessment targets. IAB tests can be taken many times in a school year.


Since these tests can be taken multiple times in the same school year the Testing Administration dates will be in a YYMMDD format, derived from the date the student took the test.


ICA results usually include the overall subject area scaled score and performance level as well as performance levels for the associated claims. ICA results will produce test records in both the Test Scores (TST) and Content Standard Scores (CST) tables.


The TST.ID for the ICA tests is SBICA, TST.PT of 1 will be the ELA test and 2 will be the Math test:



The CST.ID for the ICA will be either ICAELA or ICAMATH depending upon the test that was taken:



IAB results only include claim performance levels. IAB results will produce a “blank” holding record in the Test Scores (TST) table and scored records in the Content Standard Scores (CST) table.


The TST.ID for the IAB tests is SBIAB, TST.PT of 1 will be the ELA test and 2 will be the Math test:



The CST.ID for the IAB tests is dependent upon the test that was taken:



NOTE: The IAB test parts are derived from the AssessmentName field in the Interim Assessment data file. Since the vendor may create new test parts during the year, it is possible that a new AssessmentName value may not be mapped to a test part in Aeries. The Import Test Results process will report any invalid or unknown AssessmentName records in the summary email. If the AssessentName appears to be valid but cannot be associated with a Part # please contact Aeries Support with the AssessmentName so that we can add the mapping into the system.



The TST.ID descriptions for the ICA and IAB tests were initially imported into the Testing Control (CTL) table during the AdminCS update process. The initial CST.ID descriptions for the ICA and IAB tests were also imported into the Content Standard Names (CSN) table during the same AdminCS update. Future updates to the IAB and ICA test names and parts in the CTL and CSN tables occur when the CAASPP Interim Assessment 2017/18 - 2018/19 and later file layout is selected on the Import Test Results page in Aeries Web.


The CAASPP Interim Assessment test results do not include the students’ Perm ID, Student Number or Birth Date. This is important to note when matching records as these would not be good Match Options to select.