Record Layout for 2018 Math
Field names, types, and descriptions for the 2018 Academic Indicator (Mathematics) Data File.| Field # | Field Name | Description | Acceptable Values |
|---|---|---|---|
| 1 | cds | County-District-School Code | Text |
| 2 | rtype | Record Type | S=School 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 | dass_flag | Dashboard Alternative School Status (DASS) School Flag | Y or blank |
| 9 | studentgroup | Student Group | ALL=All Students |
| 10 | currdenom | Current year number of valid students who took the Smarter Balanced summative assessment in Math For Students With Disabilities (SWD) student group only, students who have a current disability code in California Longitudinal Pupil Achievement Data Systems (CALPADS) or was a student with disability who exited a special education program and did not receive services for up to two years (i.e., exited after April 15, 2016). These students’ scores are used to calculate the Distance from Standard. |
Integer |
| 11 | currdenom_swd | Current year number of valid students with disabilities who took the Smarter Balanced summative assessment in Math and have a current disability code in CALPADS. These students |
Integer |
| 12 | currstatus | Current Status - Average distance from Standard of students who took the Smarter Balanced summative assessment in Math |
Decimal |
| 13 | priordenom | Prior year number of valid students who took the Smarter Balanced summative assessment in Math | Integer |
| 14 | priordenom_swd | Prior year number of valid students with disabilities who took the Smarter Balanced summative assessment in Math and are included in the count to determine whether the SWD student group is assigned a performance level | Integer |
| 15 | priorstatus | Prior Status - Average distance from Standard of students who took the Smarter Balanced summative assessment in Math |
Decimal |
| 16 | change | CHANGE - Difference between current status and prior status (Rounded after calculations. For further information regarding this data field refer to the CA School Dashboard Technical Guide.) |
Decimal |
| 17 | statuslevel | Status Level |
1=Very Low 2=Low 3=Medium 4=High 5=Very High 0=No Data |
| 18 | changelevel | Change Level |
1=Decreased Significantly 2=Decreased 3=Maintained 4=Increased 5=Increased Significantly 0=No Data |
| 19 | color | Color | 1=Red 2=Orange 3=Yellow 4=Green 5=Blue 0=No Color |
| 20 | 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 |
| 21 | hscutpoints | Indicates if the school or district is held to the High School cut points | Y or blank |
| 22 | curradjustment | The number of points removed from the current year status due to the participation rate being below 95% | Decimal |
| 23 | prioradjustment | The number of points removed from the prior year status due to the participation rate being below 95% | Decimal |
| 24 | pairshare_method | Pair and Share School Method. This identifies schools that do not serve grade 3 or higher and were assigned a district average, county average, or weighted school average of up to three receiving schools for Distance From Standard. | DA=District Average, |
| 25 | 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 |
| 26 | 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 |
| 27 | 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 |
| 28 | 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 |
| 29 | 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 |
| 30 | caa_level3_num | 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 |
Integer |
| 31 | 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 |
| 32 | reportingyear | Reporting year | Text |