Skip to main content
California Department of Education Logo

2020–21 CAA for Science Research File Layout

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

Field # Data Element Start Position End Position Length Program Values Field Definition Research File Column Header (CSV)
1 County Code 1 2 2 N/A Identifies the county by CDS code. County Code
2 District Code 3 7 5 N/A Identifies the district (LEA) by CDS code. District Code
3 School Code 8 14 7 N/A Identifies the school by CDS code. School Code
4 Filler 15 18 4 N/A N/A Filler
5 Test Year 19 22 4 2021 Year of the testing program associated with the file. Test Year
6 Student Group ID 23 25 3 N/A This field will be populated with referenced data. Student Group ID
7 Test Type 26 26 1 Y = CAA Science N/A 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 Reporting Level
9

Total Number Tested with Preliminary 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 preliminary indicators at entity level (county, district, or school) for a particular demographic (student group ID). All grades are included in this total.

Total Tested with Preliminary Indicators at Reporting Level
10 Grade 41 42 2

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

14 = All High School

This is the grade level this record represents.

Grade 13 is all grades 5, 8, 10, 11, and 12

Grade 14 is all high school grades 10, 11, and 12
Grade
11 Test ID 43 44 2 18 = CAA for Science 18 = CAA for Science Test ID
12 Total Students at the Grade Level for a particular student group 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 (student group ID) within entity. Students Enrolled
13 Total Number Tested at Grade Level for a particular student group 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 (student group 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 Correct—The sum of percent for students with preliminary indicators in the selected entity (i.e., state, county, district, school, or student group) divided by the Total Number Tested with preliminary indicators from the selected entity (field #18).

Mean Percent Correct
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 Preliminary Indicators at Grade Level for a particular student group ID within entity 83 89 7

This field is subject to the suppression rules.

Total number of tested students with Preliminary Indicators at a particular grade for a particular demographic (student group ID) within entity. Students with Preliminary Indicators
19 Type ID 90 91 2

04 = State
05 = County
06 = District
07 = School
09 = Direct Funded Charter School
10 = Locally Funded Charter School

N/A Type ID
Questions:   California Assessment of Student Performance and Progress Office | caaspp@cde.ca.gov | 916-445-8765
Last Reviewed: Friday, June 16, 2023