Interim Assessment Tests - IAB and ICA

Downloading the Data File from the California Educator Reporting System (CERS)

The CAASPP Interim Assessment data file can be downloaded from the California Educator Reporting System (CERS).

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

Click on the California Educator Reporting System (CERS) button.

Log into the system

Click on the District/School Exports button.

Enter a Name for the export file

Select the School Year

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

Select the District or Schools to download. Remember to click on the Add to add the selection.

Click on the Create Report button

The system will navigate to the My Reports page. After the report has completed click on the 3 dots to the left of the report name 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.

NOTE:  Do not open the data 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  ↑

Navigate to School Info > Imports and Exports > Import Test Results

The 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. There are four IAB test subject areas:

• ELA    - TST.PT = 1 
• Math  - TST.PT = 2 
• CAST  - TST.PT = 3 
• ELPAC - TST.PT = 4 

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 or unknown Subject area records in the summary email. If the AssessentName or Subject appears to be valid but cannot be associated with a Part # please contact Aeries Support so that we can add the mapping into the system.

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