The following available state data imports for California State Assessments are listed below.
The 2014-2015 CAASPP import is the culmination of testing for the following tests:
CAPA - California Alternate Assessment Program
CMA - California Modified Assessment
CST - California Standardized Testing
SBA - Smarter Balanced Assessments
STS - Standards-based Tests in Spanish
In particular the 2014-2015 CAASPP Import contains the finalized data for the Smarter Balanced Assessments. The SBA's came in 3 stages:
- Interim Assessments (Interim Assessment Blocks / Interim Comprehensive) - http://www.smarterbalanced.org/interim-assessments/
- Summative (Preliminary)
- Summative (Final)
The Summative (Preliminary) data was available to allow stake holders quick access to results from the SBA until the final data was made available. However, the preliminary data should no longer be used once the final data is imported, so once users import data using the "2014-2015 CAASPP" dataset, the import will remove all data and references to Summative (Preliminary) results.

How do I import 14-15 CAASPP data?
Navigate to the Admin Gear > State/Known Data Imports and select the import titled "2014-2015 CAASPP". Ensure that the CAASPP file ends in ".dat" which is obtained from TOMS and matches the description before importing to ensure a successful import.
How does the CAASPP import match students in Illuminate?
Student's are matched using the SSID that originates in CALPADS. The CAASPP data file no longer includes the Local Student ID. Please ensure that SSIDs exist for students in Illuminate before importing results.
Why doesn't the Question Group Widget display any 2014-2015 CAASPP data?
This year no cluster data was provided for the CST, CMA and STS tests. The SBA assessment only includes 3 Achievement Level's for claims:
Above Standard
At or Near Standard
Below Standard
Currently, we are investigating how best to display achievement level data at the claim level where previously the measurement was percentage based.
Please reference the 14-15 CAASPP Post Test Guide (pg 9 -10 Chapter I.3 Interpreting Results) for more information.

Why is claim order not consistent between the Summative (Preliminary) and Summative (Final)?
On August 27th, caaspp.org released a new student data file layout that has changed the order of the claims. We do not know why this occurred but the pre-built reports in Illuminate will reflect the order of the most current specification provided. Above is a table that shows this change.
I imported my CAASPP data, why are my Summative (Preliminary) results gone?
The Summative (Preliminary) data was available to allow stake holders quick access to results from the SBA until the final data was made available. However, the preliminary data should no longer be used once the final data is imported, so once users import data using the "2014-2015 CAASPP" dataset, the import will remove all data and references to Summative (Preliminary) results.
Where do I find my EAP results?
Currently, there are no EAP results in the final CAASPP data file. The only EAP related info is whether or not the student released their EAP results for ELA/Math. These fields are located in the "2014-2015 SBA Summative (Final) English Language Arts" and " 2014-2015 SBA Summative (Final) Mathematics" assessments respectively. EAP documentation can be found here: http://www.cde.ca.gov/ta/tg/ai/documents/ns15eapflowchart.pdf
How are records matched to students in Illuminate?
2017-2018
- 1st: Statewide Student Identifier (SSID) (column 2, position 3-12) to State Student ID
- 2nd: Statewide Student Identifier (SSID) (column 2, position 3-12) to Local Student ID
2016-2017
- 1st: Smarter Student ID (column 3, position 19-28) to State Student ID
- 2nd: Smarter Student ID (column 3, position 19-28) to Local Student ID
2015-2016
- 1st: Smarter Student ID (column 8, position 169-208) to State Student ID
- 2nd: Smarter Student ID (column 8, position 169-208) to Local Student ID
2014-2015
- 1st: Statewide Student Identifier (column 5, position 159-168) to State Student ID
How are unique records identified?
2017-2018: All tables still use UIN (column 247 or position 2428-2443)
2016-2017 and 2014-2015: All tables use UIN (column 2) only
How are records matched to students in Illuminate?
Out of District Format: Student ID (1) to State Student ID
2015-2016 through 2012-2013
- 1st: SSID Student Number (153) to State Student ID
- 2nd: Student's Local District Identification Number (10) to Local Student ID
2012-Prior: Data Layouts not available.
How are unique records identified?
Out of District Format:
- Student ID (1)
- SSID (2)
- Test Date (4)
2015-2016 through 2012-2013:
- Student's Local District Identification Number (10)
- SSID Student Number (153)
- Math Test date (106)
- ELA Test date (120)
2011-2012 and Prior: Data Layouts not available.
How are records matched to students in Illuminate?
2017-2018 Retest
- 1st: Statewide Student Identifier (column 23, position 187-196) to State Student ID
- 2nd: Student ID Number (column 22, position 177-186) to Local Student ID
2017-2018 through 2012-2013
- 1st: Statewide Student Identifier (column 24, position 187-196) to State Student ID
- 2nd: Student ID Number (column 23, position 177-186) to Local Student ID
2011-2012 to Prior: Data Layouts not available.
How are unique records identified?
2017-2018 through 2012-2013:
- Student ID Number (column 23, position 177-186)
- Statewide Student Identifier (column 24, position 187-196)
- Test Purpose (column 26, position 199-199)
- Date Testing Completed (column 29, position 203-210)
2011-2012 to Prior: Data Layouts not available.
How are records matched to students in Illuminate?
2017-2018:
1st: Statewide Student Identifier (column 5, position 51-60) to Statewide Student Identifier (SSID)
2nd: Student ID Number (column 6, position 61-75) to Student ID Number (Local ID)
How are unique records identified?
2017-2018:
UIN (Unique Identification Number) (column 2, position 3-18)
How are records matched to students in Illuminate?
2016-2017 and 2015-2016 (LEA):
- 1st: StuID (9) to State Student ID
- 2nd: StuID (9) to Local Student ID
2015-2016 (EDS):
- 1st: District Student ID (148-157) to Local Student ID
- 2nd: State Assigned Student ID (53-62) to State Student ID
- 3rd: District Student ID (148-157) to State Student ID
- 4th: State Assigned Student ID (53-62) Local Student ID
2016-2017 and 2015-2016 CA Submission
- 1st: Statewide Student Identifier (SSID) (13) to State Student ID
- 2nd: Statewide Student Identifier (SSID) (13) to Local Student ID
2014-2015 through 2011-2012
- LEA:
- 1st: District ID (78) to Local Student ID
- 2nd: StuID (9) to State Student ID
- EDS
- 1st: District Student ID (148-157) to Local Student ID
- 2nd: State Assigned Student ID (53-62) to State Student ID
- CA Submission
- 1st: Statewide Student Identifier (SSID) (13) to State Student ID
- 2nd: Statewide Student Identifier (SSID) (13) to Local Student ID
2010-2011 through Prior: Data Layouts not Available.
How are unique records identified?
2016-2017 and 2015-2016 (LEA):
- StuID (9)
- TestDate (12)
2015-2016 (EDS):
- State Assigned Student ID (53-62)
- District Student ID (148-157)
- Test Date (85-92)
2016-2017 and 2015-2016 CA Submission:
- Statewide Student Identifier (SSID) (13)
- PFT Start Date (Month-35, Day-36, Year-37)
2014-2015 through 2011-2012
- LEA:
- StuID (9)
- TestDate (12)
- EDS:
- State Assigned Student ID (53-62)
- District Student ID (148-157)
- Test Date (85-92)
- CA Submission:
- Statewide Student Identifier (SSID) (13)
- PFT Start Date (Month-35, Day-36, Year-37)
2010-2011 to Prior:Data Layouts not Available.
See all info related to SBA here.
How are records matched to students in Illuminate?
2017-2018 Smarter Balanced Assessment Interim:
- 1st: Student ID (1) to State Student ID
- 2nd: Student ID (1) to Local Student ID
2016-2017, 2015-2016, and 2014-2015 Smarter Balanced Assessment Interim:
- 1st: StudentIdentifier (10) to State Student ID
- 2nd. ExternalSSID (16) to Local Student ID
2017-2018 through 2014-2015 Summative (Preliminary)
- 1st: Student ID (3) to State Student ID
- 2nd: Student ID (3) to Local Student ID
ORS Out of District Format (2016-2017 through 2014-2015)
- 1st: Student ID (3) to State Student ID
How are unique records identified?
2017-2018 Smarter Balanced Assessment Interim:
- Student ID (1)
- Session (5)
- Date (4)
- Assessment (7)
2016-2017, 2015-2016, and 2014-2015 Smarter Balanced Assessment Interim:
- AssessmentGuid (1)
- StudentIdentifier (10)
- AssessmentAdministrationFinishDate (38)
2014-2015 Summative (Preliminary)
-
"Math" Table
- Student ID (3)
- Mathematics OppNumber (20)
-
"ELA" Table
- Student ID (3)
- ELA/Literacy OppNumber (12)
-
"Other" Table
- Student ID (3)
2017-2018 through 2015-2016 Summative (Preliminary)
-
"Math" Table
- Student ID (3)
- Mathematics OppNumber (31)
-
"ELA" Table
- Student ID (3)
- ELA/Literacy OppNumber (23)
-
"Other" Table
- Student ID (3)
ORS Out of District Format (2016-2017 through 2014-2015)
- Student ID (3)
How are records matched to students in Illuminate?
STAR/CAASPP 2013-2014 and STAR 2012-2013 QTA Fixed Width
- 1st: SSID (position 68-77) to State Student ID
- 2nd: LocalStudentID (position 58-67) to Local Student ID
- 3rd: unique combination of LastName (position 37-47) to Last Name, FirstName (position 48-56) to First Name, and BirthDate (position 78-85) to Birth Date
STAR/CAASPP 2013-2014 and STAR 2012-2013 QTA Tab-Delimited
- 1st: SSID (9) to State Student ID
- 2nd: LocalStudentID (8) to Local Student ID
- 3rd: unique combination of LastName (5) to Last Name, FirstName (6) to First Name, and BirthDate (10) to Birth Date
STAR 2013-2014 and 2012-2013
- 1st: SSID (column 7, position 68-77) to State Student ID
- 2nd: LocalStudentID (column 6, position 58-67) to Local Student ID
- 3rd: unique combination of Last Name (column 5, position 37–47) to Last Name, First Name (column 5, 48–56) to First Name, and Date of Birth (columns 8-10, positions 78-85) to Birth Date
STAR 2011-2012
- 1st: LocalStudentID (column 6, position 58-67) to Local Student ID
- 2nd: SSID (column 7, position 68-77) to State Student ID
STAR 2010-2011 through Prior: Data Layouts not available.
How are unique records identified?
STAR/CAASPP 2013-2014 through 2011-2012: all use UIN (column 2, position 3-22, depending on format) only
STAR 2010-2011 through Prior: Data Layouts not available.
Next Steps
Now that you have reviewed the available state assessments for import, learn how to use the Upload State Assessment Data.
Comments
0 comments
Please sign in to leave a comment.