Skip to main content
California Department of Education Logo

CAA for Science Research File Layout

The California Alternate Assessments (CAA) research file layout consists of summary records of student data aggregated to the school, district, county, and state levels.

Note: This page may need to be printed in landscape view.

Field # Data Element Start Position End Position Length CAA Program Values Field Definition Research File Column Header (CSV)
1 County Code 1 2 2 NA Identifies the county by CDS code. County Code
2 District Code 3 7 5 NA Identifies the district (LEA) by CDS code. District Code
3 School Code 8 14 7 NA Identifies the school by CDS code. School Code
4 Filler 15 18 4 NA NA Filler
5 Test Year 19 22 4 2018 Year of the testing program associated with the file. Test Year
6 Subgroup ID 23 25 3 NA This field will be populated with referenced data. Subgroup ID
7 Test Type 26 26 1 X = Science X = Science Test Type
8

Total Number Tested at Entity Level for a particular subgroup ID

27 33 7 This field is subject to the suppression rules.

Total number of tested students at entity level (county, district, or school) for a particular demographic (subgroup ID). All grades are included in this total.

Total Tested At Entity Level
9

Total Number Tested with Valid Scores at Entity Level for a particular subgroup ID

34 40 7 This field is subject to the suppression rules.

Total number of tested students with valid scores at entity level (county, district, or school) for a particular demographic (subgroup ID). All grades are included in this total.

Total Tested with Scores
10 Grade 41 42 2

05 = Grade 5
08 = Grade 8
10 = Grade 10
11 = Grade 11
12 = Grade 12
13 = All Grades

Grade level this record represents. Grade 13 is all grades 5, 8, 10, 11, and 12. Grade
11 Test Id 43 44 2 16 = CAA for Science CAA for Science = 16 Test Id
12 Total Students at the Grade Level for a particular subgroup ID within entity 45 51 7 This field is subject to the suppression rules. Total number of students at the grade level for a particular demographic (subgroup ID) within entity. CAASPP Reported Enrollment
13 Total Number Tested at Grade Level for a particular subgroup ID within entity 52 58 7 This field is subject to the suppression rules. Total number of tested students at the grade level for a particular demographic (subgroup ID) within entity. Students Tested
14 Mean Percent Correct Score 59 64 6

Format 999.9

This field is subject to the suppression rules.

Mean Percent Score—The sum of percent scores for students with valid scores in the selected entity (i.e., state, county, district, school, or student group) divided by the Total Number Tested with Valid Scores from the selected entity (field #18).

Mean Percent Corrrect
15 Preliminary Indicator – Percent Category 1 65 70 6

Format 999.99

This field is subject to the suppression rules.

Total count of Category 1 students divided by the sum total of tested students at all levels * 100.

Category 1–Limited

Percentage Preliminary Indicator Category 1
16 Preliminary Indicator – Percent Category 2 71 76 6

Format 999.99

This field is subject to the suppression rules.

Total count of Category 2 students divided by the sum total of tested students at all levels * 100.

Category 2–Moderate

Percentage Preliminary Indicator Category 2
17 Preliminary Indicator – Percent Category 3 77 82 6

Format 999.99

This field is subject to the suppression rules.

Total count of Category 3 students divided by the sum total of tested students at all levels * 100.

Category 3–Considerable

Percentage Preliminary Indicator Category 3
18 Total Number Tested with Valid Scores at Grade Level for a particular subgroup ID within entity 83 89 7

This field is subject to the suppression rules.

Total number of tested students with valid scores at a particular grade for a particular demographic (subgroup ID) within entity. Students with Scores
Questions:   California Assessment of Student Performance and Progress Office | caaspp@cde.ca.gov | 916-445-8765
Last Reviewed: Thursday, December 6, 2018