Record Layout for Fall 2017 Mathematics Grades 3-8
Field names, types, and descriptions for the Academic Indicator (Mathematics Grades 3-8) Data File.| Field # | Field Name | Description | Acceptable Values |
|---|---|---|---|
| 1 | cds | County-District-School Code | 14-character string |
| 2 | rtype | Record Type | S=School Record D=District/LEA Record |
| 3 | schoolname | School Name | Text |
| 4 | districtname | District Name | Text |
| 5 | countyname | County Name | Text |
| 6 | charter_flag | Charter School Flag | Y or blank |
| 7 | coe_flag | County Office of Education Flag | Y or blank |
| 8 | studentgroup | Student Group | ALL=All Students |
| 9 | currdenom | Current year number of valid students who took the Smarter Balanced summative assessment in Math | Integer |
| 10 | currstatus | Current Status - Average distance from level 3 of students who took the Smarter Balanced summative assessment in Math (Rounded after calculations. For further information regarding this data field refer to the CA School Dashboard Technical Guide.) |
Decimal |
| 11 | priordenom | Prior year number of valid students who took the Smarter Balanced summative assessment in Math | Integer |
| 12 | priorstatus | Prior Status - Average distance from level 3 of students who took the Smarter Balanced summative assessment in Math (Rounded after calculations. For further information regarding this data field refer to the CA School Dashboard Technical Guide.) |
Decimal |
| 13 | change | CHANGE - Difference between current status and prior status | Decimal |
| 14 | statuslevel | Status Level (Determined after calculations and rounding. For further information regarding this data field refer to the CA School Dashboard Technical Guide.) |
1=Very Low 2=Low 3=Medium 4=High 5=Very High 0=No Data |
| 15 | changelevel | Change Level (Determined after calculations and rounding. For further information regarding this data field refer to the CA School Dashboard Technical Guide.) |
1=Decreased Significantly 2=Decreased 3=Maintained 4=Increased 5=Increased Significantly 0=No Data |
| 16 | color | Color | 1=Red 2=Orange 3=Yellow 4=Green 5=Blue 0=No Color |
| 17 | box | If a color was assigned, this value represents the specific 5x5 grid location | 10=Very High, Declined Significantly 20=Very High, Declined 30=Very High, Mantained 40=Very High, Increased 50=Very High, Increased Significantly 60=High, Declined Significantly 70=High, Declined 80=High, Mantained 90=High, Increased 100=High, Increased Significantly 110=Medium, Declined Significantly 120=Medium, Declined 130=Medium, Mantained 140=Medium, Increased 150=Medium, Increased Significantly 160=Low, Declined Significantly 170=Low, Declined 180=Low, Mantained 190=Low, Increased 200=Low, Increased Significantly 210=Very Low, Declined Significantly 220=Very Low, Declined 230=Very Low, Mantained 240=Very Low, Increased 250=Very Low, Increased Significantly 0=No Color |
| 18 | caa_denom | Current year number of valid students who took the California Alternate Assessment in Math Only populated for records where studentgroup=ALL If the school or district did not test any students under the California Alternate Assessment, this value will be zero |
Integer |
| 19 | caa_level1_num | Current year number of valid students who took the California Alternate Assessment in Math and scored achievement level 1 Only populated for records where studentgroup=ALL and caa_denom>=11 |
Integer |
| 20 | caa_level1_pct | Current year percent of valid students who took the California Alternate Assessment in Math and scored achievement level 1 Only populated for records where studentgroup=ALL and caa_denom>=11 |
Decimal |
| 21 | caa_level2_num | Current year number of valid students who took the California Alternate Assessment in Math and scored achievement level 2 Only populated for records where studentgroup=ALL and caa_denom>=11 |
Integer |
| 22 | caa_level2_pct | Current year percent of valid students who took the California Alternate Assessment in Math and scored achievement level 2 Only populated for records where studentgroup=ALL and caa_denom>=11 |
Decimal |
| 23 | caa_level3_num | Current year number of valid students who took the California Alternate Assessment in Math and scored achievement level 3 Only populated for records where studentgroup=ALL and caa_denom>=11 |
Integer |
| 24 | caa_level3_pct | Current year percent of valid students who took the California Alternate Assessment in Math and scored achievement level 3 Only populated for records where studentgroup=ALL and caa_denom>=11 |
Decimal |
| 25 | reportingyear | Reporting year. | Text |