File Structure: Teaching AMO Data
File structure for data files containing teaching Assignment Monitoring Outcome (AMO) data disaggregated by subject, school type, school grade span, teacher credential level and experience level. Data reported in full-time equivalency (FTE) units.General Description of the File
The downloadable data files provide the Full-Time Equivalent (FTE) data for each classroom-based teaching assignment reported by local educational agencies (LEAs) to the California Department of Education (CDE) through the California Longitudinal Pupil Achievement Data System (CALPADS). The CDE provides the California Commission on Teacher Credential (CTC) with the CALPADS assignment data, which the CTC compares against their credential authorization data as part of the annual assignment monitoring process conducted through California Statewide Assignment Accountability System (CalSAAS). This process evaluates each assignment based on the Statewide Educator Identification (SEID) associated with the assignment to determine if or how the teacher is authorized to teach the assigned course and the students enrolled in the course. For more information about the Teaching Assignment Monitoring Outcome (AMO) data, including how the Teaching AMO data are calculated, please visit the Information about the Teaching AMO Report webpage.
Source
Classroom-based teaching assignments and FTE submitted and certified by LEAs and/or charter schools as part of the annual CALPADS Fall 2 submission and assignment monitoring outcome data determined during the annual assignment monitoring process conducted by the CTC through CalSAAS.
Note
These files include state, county, district, and school-level data. Please refer to the file structure for details on what data are contained in the file. These files also contain aggregate data with disaggregated data subsets at different levels and reporting categories to provide enhanced analytical flexibility. For more detailed examples about how to properly use these data, please refer to the Using the Teaching AMO Data File examples below. Data for classroom-based teaching assignments taught by teachers without a SEID are not included in the Teacher AMO report and downloadable data file. Data are not included for districts and independently reporting charter schools (IRCs) that did not certify their CALPADS Fall 2 submission. Due to rounding error, partial FTE counts by AMO may not sum exactly to the Total FTE displayed in the report or file for the selected reporting level and filters.
Field Name | Description |
---|---|
Academic Year | The academic year corresponding to the Census Day associated with the annual California Longitudinal Pupil Achievement Data System (CALPADS) Fall 2 submission through which local educational agencies (LEAs) submit and certify official staff demographic, staff assignments and full-time equivalency (FTE) information, course offerings, and student course enrollment data. LEAs include school districts, charter schools, and county offices of education. Census Day or Information Day is always the first Wednesday in October. Prior to CALPADS, these data were submitted to the CDE by LEAs as part of the Professional Assignment Information Form (PAIF) collected through the annual California Basic Educational Data System (CBEDS) submission. |
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 | An indicator of whether data for all schools, only charter schools, or only non-charter schools are included:
Note: One of these values must be chosen to obtain an unduplicated count at the selected level. |
DASS | 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:
Note: One of these values must be chosen to obtain an unduplicated count at the selected level. |
School Grade Span | An indication of the grade levels associated with the students enrolled at a school based on the lowest and highest K–12 grades offered at a school.
Note: One of these options must be chosen to obtain the desired count at the selected level. |
Teacher Experience Level | An indication of whether a teacher is considered to be “experienced” or "inexperienced" based on a count of the cumulative number of years a teacher has been providing educational services in a certificated position within any educational institution.
Note: One of these options must be chosen to obtain the desired count at the selected level. |
Teacher Credential Level | An indication of whether a teacher holds a "clear or preliminary teaching credential" or not. Teachers are defined as “fully credentialed” if they possess a clear or preliminary teaching credential. Teachers are defined as “not fully credentialed” if they do not possess a clear or preliminary teaching credential.
Note: One of these options must be chosen to obtain the desired count at the selected level. |
Subject Area | A high-level summary grouping of state course codes (formerly known as CBEDS assignment codes) that share similarities in subject content area covered in a specific course (e.g., English/Language Arts or Mathematics). Information about the state course codes is included in the CALPADS Code Set, under Course Group State, and information about the mapping of state course codes to subject content areas can be found in the CALPADS Valid Code Combinations document under the Course Group Master Combo tab. These CALPADS documents are publicly available on the CDE CALPADS System Documentation webpage.
Note: One of these options must be chosen to obtain the desired count at the selected level. Select Reporting Category = TA for aggregate totals without consideration of a Subject Area. |
Total FTE (count) | This count includes the total FTE for the classroom-based teaching assignments at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area). |
Clear FTE (count) | Where the assignment monitoring outcome is clear, this count includes the FTE for the associated classroom-based teaching assignments at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area). |
Out-of-Field FTE (count) | Where the assignment monitoring outcome is out-of-field, this count includes the FTE for the associated classroom-based teaching assignments at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area). |
Intern FTE (count) | Where the assignment monitoring outcome is intern, this count includes the FTE for the associated classroom-based teaching assignments at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area). |
Ineffective FTE (count) | Where the assignment monitoring outcome is ineffective, this count includes the FTE for the associated classroom-based teaching assignments at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area). |
Incomplete FTE (count) | Where the assignment monitoring outcome is incomplete, this count includes the FTE for the associated classroom-based teaching assignments at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area). |
Unknown FTE (count) | Where the assignment monitoring outcome is unknown, this count includes the FTE for the associated classroom-based teaching assignments at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area). |
N/A FTE (count) | Where the assignment monitoring outcome is N/A, this count includes the FTE for the associated classroom-based teaching assignments at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area). |
Clear FTE (percent) | The Clear FTE (percent) is calculated by taking the Clear FTE (count) divided by the Total FTE (count) at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area). |
Out-of-Field FTE (percent) | The Out-of-Field FTE (percent) is calculated by taking the Out-of-Field FTE (count) divided by the Total FTE (count) at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area). |
Intern FTE (percent) | The Intern FTE (percent) is calculated by taking the Intern FTE (count) divided by the Total FTE (count) at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area). |
Ineffective FTE (percent) | The Ineffective FTE (percent) is calculated by taking the Ineffective FTE (count) divided by the Total FTE (count) at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area). |
Incomplete FTE (percent) | The Incomplete FTE (percent) is calculated by taking the Incomplete FTE (count) divided by the Total FTE (count) at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area). |
Unknown FTE (percent) | The Unknown FTE (percent) is calculated by taking the Unknown FTE (count) divided by the Total FTE (count) at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area). |
N/A FTE (percent) | The N/A FTE (percent) is calculated by taking the N/A FTE (count) divided by the Total FTE (count) at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area). |
Using the Teaching AMO 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 data. Please refer to the following examples below as a guide for properly using these data:
- Get school-level teaching FTE data by assignment monitoring outcomes for all schools without further summary-level disaggregation:
- Aggregate Level = S (School)
- Charter = ALL
- DASS = ALL
- School Grade Span = ALL
- Teaching Experience Level = ALL
- Teaching Credential Level = ALL
- Subject Area = TA
- Get school-level teaching FTE data by assignment monitoring outcomes for all charter schools that are also DASS schools for Mathematics teaching assignments:
- Aggregate Level = S (School)
- Charter = Y
- DASS = Y
- School Grade Span = ALL
- Teaching Experience Level = ALL
- Teaching Credential Level = ALL
- Subject Area = MATH
- Get district-level teaching FTE data by assignment monitoring outcomes for all non-charter schools and for all Subject Areas with a district-level total:
- Aggregate Level = D (District)
- Charter School = N
- DASS = ALL
- School Grade Span = ALL
- Teaching Experience Level = ALL
- Teaching Credential Level = ALL
- Subject Area = AGRI, ARTS, BUSN, CTED, CPTE, DNCE, DRMT, ENLA, FRLG, GADM, HLTH, HISS, MATH, MDAR, MUSC, OTHR, PHYS, SCIE, SCCL, SDSU, and TA
- Get county-level teaching FTE data by assignment monitoring outcomes for all schools where the School Grade Span is 9–12 and where the Teaching Experience Level is inexperienced:
- Aggregate Level = C (County)
- Charter School = ALL
- DASS = ALL
- School Grade Span = GR912
- Teaching Experience Level = INEXP
- Teaching Credential Level = ALL
- Subject Area = TA
- Get state-level teaching FTE data by assignment monitoring outcomes for DASS schools where Teaching Credential Level is “not fully credentialed”:
- Aggregate Level = T (State)
- Charter School = ALL
- DASS = Y
- School Grade Span = ALL
- Teaching Experience Level = ALL
- Teaching Credential Level = NFC
- Subject Area = TA