Skip to main content
California Department of Education Logo

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 CDS 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
AA=Black/African American
AI=American Indian or Alaska Native
AS=Asian
FI=Filipino
HI=Hispanic
PI=Pacific Islander
WH=White
MR=Multiple Races/Two or More
EL=English Learner
ELO=English Learners Only
RFP=RFEPs Only
EO=English Only
SED=Socioeconomically Disadvantaged
SWD=Students with Disabilities
FOS=Foster Youth
HOM=Homeless Youth

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
Questions: Academic Accountability Team | aau@cde.ca.gov | 916-319-0863 
Last Reviewed: Thursday, December 7, 2017
Recently Posted in Accountability