CAA for Science Research File Layout
Note: This page may need to be printed in landscape view.
County-District-School (CDS) codes uniquely identify schools and are used for funding, assessment, accountability, grant applications, data reporting, and tracking purposes.
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 |
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 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 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 |