File Structure: Staff Experience Data
File structure for downloadable data files containing Certificated Staff Experience disaggregated by academic year, staff type, school grade span, and gender.Files include state, county, district, and school level data. Please refer to the file structure for details for information about which data are included in the file. For more detailed examples about how to properly use these data, please refer to the Using the Staff Experience Data File examples below.
Note: The staff data may include small N-sizes. Therefore, the California Department of Education (CDE) urges caution when comparing percentages, ratios, or other calculations based on small N-sizes, which may negatively impact data reliability. Data are not included for districts and independently reporting charter schools (IRCs) that did not certify their California Longitudinal Pupil Achievement Data System (CALPADS) Fall 2 submission.
General Description of the Data File
Field | Description |
---|---|
Academic Year | The academic year corresponding to the Census Day from which official certificated staff counts are determined using data submitted as part of the annual Fall 2 submission to the California Longitudinal Pupil Achievement Data System (CALPADS) by local educational agencies (LEAs), which includes school districts, charter schools, and county offices of education. Census Day or Information Day is the first Wednesday in October. |
Aggregate Level | An indicator of the aggregation level.
Note: One of these values must be chosen to obtain an unduplicated count at the selected level. |
County Code | A unique two-digit code corresponding to the county. |
District Code | A unique five-digit code corresponding to the district. |
School Code | A unique seven-digit code corresponding to the school. |
County Name | County Name |
District Name | District or Administrative Authority Name |
School Name | School Name |
Charter School (ALL/Y/N) | An indicator of whether data for all schools, only charter schools, or only non-charter schools are included in the aggregate.
Note: One of these values must be chosen to obtain an unduplicated count at the selected level. Select ALL for aggregate totals without consideration of charter school status. |
Dashboard Alternative School Status (DASS) (ALL/Y/N) | An indicator of whether data for all schools, only schools participating in the Dashboard Alternative School Status Program (DASS), or only non-DASS schools are included in the aggregate.
Note: One of these values must be chosen to obtain an unduplicated count at the selected level. Select ALL for aggregate totals without consideration of DASS. |
Staff Type | A coded value corresponding to the certificated Staff Type with data are included in the aggregate.
Note: One of these options must be chosen to obtain the desired count at the selected level. Select ALL for aggregate totals without consideration of Staff Type. |
School Grade Span | A coded value corresponding to the School Grade Span of the schools for which data are included in the aggregate.
The School Grade Span is a summary of the lowest and highest K–12 grade levels offered by a school as reported to the CDE through the OPUS-CDS system and reported in the California School Directory. Please Note: Since transitional kindergarten (TK) is the first year of a two-year kindergarten (K) program (see Education Code section 48000(d)), all School Grade Spans inclusive of Grade K (i.e., K–6 and K–12), also include TK when offered. Note: One of these options must be chosen to obtain the desired count at the selected level. Select ALL for aggregate totals without consideration of School Grade Span. |
Staff Gender | A coded value corresponding to the Staff Gender for which data are included in the aggregate.
Note: One of these options must be chosen to obtain the desired count at the selected level. Select ALL for aggregate totals without consideration of Staff Gender. |
Total Staff Count | Total Staff Count (N) |
Average Total Years Experience | The average number of cumulative years that the selected staff have been providing educational services in any Educational Institution. |
Average District Years Experience | The average number of years that the selected staff have been providing educational service for any schools within the local educational agency (LEA) where they currently have a staff assignment. |
Experienced | A count (N) of the selected staff who have more than two years of total experience providing educational service in any Educational Institution. |
Inexperienced | A count of the selected staff who have two or less years of total experience providing educational services in any Educational Institution. |
First Year | A count of the selected staff who are in their first year providing educational services in any Educational Institution. |
Second year | A count of the selected staff who are in their second year providing educational services in any Educational Institution. |
General Description of the Data File
The certificated staff demographic and assignment data are submitted by local educational agencies (LEAs) and charter schools to the California Department of Education (CDE) as part of the annual Fall 2 data submission in the California Longitudinal Pupil Achievement Data System (CALPADS). Staff data submitted in the CALPADS Fall 2 submission include, but is not limited to, staff race/ethnicity, gender, highest education level, years of experience, and full-time equivalency (FTE) assignment-based information. These staff data are reviewed and certified in CALPADS as being accurate by authorized LEA or charter school personnel. In order to certify data in CALPADS, authorized LEA or charter school personnel are required to review the accuracy of all data associated with the applicable CALPADS submission, with final certification reserved for LEA superintendents, charter school administrators, or their designees. Please contact the LEA or charter school if you have any questions about their certified CALPADS data.
Source: California Longitudinal Pupil Achievement Data System (CALPADS) Fall 2 annual data submission. The CALPADS Fall 2 data are based on information as of Census Day, the first Wednesday in October.
Note: The staff data may include small N-sizes. Therefore, the CDE urges caution when comparing percentages, ratios, or other calculations based on small N-sizes, which may negatively impact data reliability.
Using the Staff Experience Data File
This file contains different subsets of data based on the values of different variables. If these sub-setting variables are not used properly, it is easy to end up with incorrect or duplicative data. Please refer to the following examples below as a guide for properly using these data:
- Get unduplicated school-level totals for all staff (Note: Staff may have multiple Staff Type assignments at an entity. Staff Type = ALL is an unduplicated staff count.)
- Aggregate Level = S (School)
- Charter School (Y/N) = Y and N
- DASS (Y/N) = Y and N
- Staff Type = ALL
- School Grade Span = ALL
- Staff Gender = ALL
- Get school-level data totals for Teachers and for all non-charter schools
- Aggregate Level = S (School)
- Charter School (Y/N) = N
- DASS (Y/N) = Y and N
- Staff Type = TCH
- School Grade Span = ALL
- Staff Gender = ALL
- Get school-level data totals for Male Teachers and for all Grade 9-12 DASS schools
- Aggregate Level = S (School)
- Charter School (Y/N) = Y and N
- DASS (Y/N) = Y
- Staff Type = TCH
- School Grade Span = GS_912
- Staff Gender = GM
- Get district-level data totals for Administrators by Staff Gender for non-charter schools
- Aggregate Level = D (District)
- Charter School (Y/N) = N
- DASS (Y/N) = ALL
- Staff Type = ADM
- School Grade Span = ALL
- Staff Gender Not Equal to ALL
- Get statewide-level data totals for Teachers and for charter schools that are DASS schools
- Aggregate Level = T (State)
- Charter School (Y/N) = Y
- DASS (Y/N) = Y
- Staff Type = TCH
- School Grade Span = ALL
- Staff Gender = ALL