Record Layout for 2018 ELA
Field names, types, and descriptions for the 2018 Academic Indicator (English Language Arts/Literacy) Data File.| Field # | Field Name | Description | Acceptable Values |
|---|---|---|---|
| 1 | cds | County-District-School Code | 14-character string |
| 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 English Language Arts (ELA) For Students With Disabilities (SWD) student group only, students who have a current disability code in California Longitudinal Pupil Achievement Data System (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 ELA 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 ELA (Rounded after calculations. For further information regarding this data field refer to the CA School Dashboard Technical Guide.) |
Decimal |
| 13 | priordenom | Prior year number of valid students who took the Smarter Balanced summative assessment in ELA | Integer |
| 14 | priordenom_swd | Prior year number of valid students with disabilities who took the Smarter Balanced summative assessment in ELA 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 ELA (Rounded after calculations. For further information regarding this data field refer to the CA School Dashboard Technical Guide.) |
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 (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 |
| 18 | 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 |
| 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, Maintained 40=Very High, Increased 50=Very High, Increased Significantly 60=High, Declined Significantly 70=High, Declined 80=High, Maintained 90=High, Increased 100=High, Increased Significantly 110=Medium, Declined Significantly 120=Medium, Declined 130=Medium, Maintained 140=Medium, Increased 150=Medium, Increased Significantly 160=Low, Declined Significantly 170=Low, Declined 180=Low, Maintained 190=Low, Increased 200=Low, Increased Significantly 210=Very Low, Declined Significantly 220=Very Low, Declined 230=Very Low, Maintained 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 ELA 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 ELA 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 ELA 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 ELA 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 ELA 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 ELA 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 ELA and scored achievement level 3 Only populated for records where studentgroup=ALL and caa_denom>=11 |
Decimal |
| 32 | reportingyear | Reporting year. | Text |