Skip to main content
California Department of Education Logo

DataQuest Update, Issue #13

DataQuest is an online data reporting resource that provides access to a wide variety of data reports and downloadable data files.

image of DataQuest and California Department of Education

July 20, 2022

DataQuest is the California Department of Education’s (CDE) public data reporting web site that provides meaningful data and statistics about California’s K-12 public education system that supports a wide variety of informational, research, and policy needs. The purpose of the DataQuest Update is to provide: (1) announcements regarding public data releases and availability; (2) general information and analysis on various data reporting topics; and (3) practical tips on how to effectively use DataQuest to obtain information. For questions regarding DataQuest, please submit an email to dataquest@cde.ca.gov.

New Teaching Assignment Monitoring Outcome by Full-Time Equivalency Report on DataQuest

The CDE is pleased to announce the release of a new Teaching Assignment Monitoring (AMO) by Full-Time Equivalency (FTE) report on DataQuest and supporting the downloadable data file. The Teaching AMO report was developed in response to California Education Code (EC) Section 44258.9 and to meet federal reporting requirements under the Every Student Succeeds Act (ESSA). For summary information regarding the release of the Teaching AMO report, please refer to the California Department of Education News Release, California Department of Education Announces First-Ever Interagency Release of Teacher Assignment Data.

Background and Overview

California Education Code (EC) Section 44258.9 requires the California Commission on Teacher Credentialing (CTC) and the California Department of Education (CDE) to share data in order to facilitate the annual monitoring of teaching assignments. Pursuant to EC Section 44258.9, the CDE provides the CTC with certificated staff assignment and course data submitted to the CDE by local educational agencies (LEAs) through the annual California Longitudinal Pupil Achievement Data System (CALPADS) Fall 2 data submission, which are necessary for the CTC to conduct the annual assignment monitoring process through the California State Assignment Accountability System (CalSAAS).

In return, the CTC provides the CDE with annual teacher credential and assignment monitoring outcome data consistent with the California Consolidated State Plan approved by the State Board of Education (SBE) to comply with the federal Every Student Succeeds Act (ESSA). Additionally, as part of the California ESSA State Plan, the SBE approved updated definitions for "ineffective" and "out-of-field" teachers for reporting purposes, which can be found on the CDE Updated Teacher Equity Definitions webpage. As a result of this data-sharing agreement, for the first time, California is able to meet the federal reporting requirements established by ESSA, in part, through the release of the 2020–21 Teaching AMO reports on DataQuest.

Teaching AMO and FTE Data

The DataQuest Teaching AMO report shows the proportion of FTE for all classroom-based teaching assignments by the associated AMO for each assignment. For the purposes of this report, the following definitions apply:

  • Teaching Assignment: A "teaching assignment" is defined as a classroom-based assignment (course section) wherein a unique section of course content is being taught by one or more teachers to a specific group of students.
  • Assignment Monitoring Outcome: An "assignment monitoring outcome" or AMO is the result(s) or finding(s) from the assignment monitoring process conducted by the CTC. For reporting purposes, the FTE data for each teaching assignment is displayed for the following DataQuest AMOs: Clear, Out-of-Field, Ineffective, Intern, Incomplete, Unknown, and Not Applicable (N/A).
  • Full-Time Equivalency: The "full-time equivalency" or FTE is defined as the percentage of time spent working in a job classification in relation to a full-time position (100 percent or 1.0 FTE). Since CALPADS FTE data are collected at the staff level, not the assignment-level, the FTE for each teacher is proportionally distributed across their assignments for DataQuest reporting purposes.)

Each teaching assignment is evaluated along the applicable monitoring dimensions (i.e., course content, English learner, language of instruction, and special education) to determine if or how the teacher is authorized to teach the assigned course and students enrolled in the course. The outcomes for each assignment are then consolidated into a single AMO for the purposes of reporting the associated FTE for the assignment. Detailed information about these reports is available on the CDE Information about the Teaching Assignment Monitoring Outcome Report webpage, including data sources and timelines, definitions, data uses, and a description of the methodology and business rules for processing the data.

Important Information About the Teaching AMO Reports

The data provided in the 2020–21 Teaching AMO reports is from the prior academic year; however, they represent the most current data available. As indicated in the CDE news release mentioned above, these data represent a baseline that will "inform state and local decisions over the coming years as agencies work to address teacher shortages." The CDE recently provided CTC with the 2021–22 CALPADS Fall 2 assignment data, which will be used for the upcoming assignment monitoring cycle to be conducted from August to November 2022, after which the CTC will provide the results to the CDE for reporting purposes. The CDE anticipates releasing the 2021–22 Teaching AMO reports in early 2023.

Release of New Data Reports on DataQuest

2020–21 Teaching Assignment Monitoring Outcomes by Full-Time Equivalency (NEW)

  • Teaching Assignment Monitoring Outcomes by FTE
  • Teaching Assignment Monitoring Outcomes by FTE (with County Data)

Users may access these reports by performing the following steps:

  • Navigate to the DataQuest Homepage
  • Select the desired Level (State, County, District, or School)
  • Select the following Subject Level:
    • Staff Assignment Data
  • Select "Submit"
  • Select the desired Year (2020–21)
  • Select "Submit"
  • Select desired report from the menu
    • Teaching Assignment Monitoring Outcomes by FTE
    • Teaching Assignment Monitoring Outcomes by FTE (with County Data)
  • Select "Submit"

The reports listed above include Report Description, Report Glossary, and, where applicable, Report Filters and Options sections. To change the way the data are displayed in the report, open the expandable (+) Report Options and Filters section. Within this area, users can apply a variety of school type filters (i.e., charter/non-charter and alternative/regular schools), school grade span filters, teacher credential level filters, and teacher experience level filters. Additionally, users can apply one or more filters simultaneously to view data in a variety of configurations. Applied filters are viewable in the "Filtered Enabled" section above each report where the filters can also be reset. The CDE has incorporated a report "parameterization" feature into the Teaching AMO report, which will allow users to share a link to a filtered report.

Supporting Downloadable Data Files

As part of this public data release, the CDE is providing the following supporting downloadable data file, available here:

Teaching Assignment Monitoring Outcomes by FTE

Upcoming Data Releases

Later in 2022, the CDE anticipates the public release of the following data reports and downloadable file

  • 2021–22 Long-Term English Learner Data
  • 2018–19 and 2019–20 College-Going Rate Data
  • 2019–20, 2020–21, and 2021–22 New Staff Demographic, Experience, and Education Data
  • 2021–22 Four-Year Adjusted Cohort Graduation Rate and Outcome Data
  • 2021–22 Five-Year Cohort Graduation Rate and Outcome Data
  • 2021–22 Suspension Rate Data
  • 2021–22 Expulsion Rate Data
  • 2021–22 Chronic Absenteeism Data
  • 2021–22 Cumulative Enrollment Data (downloadable data file ONLY)
  • 2021–22 Restraint and Seclusion Data (downloadable data file ONLY)
  • 2021–22 Absenteeism by Reason Data
  • 2021–22 Transitional Kindergarten Participation Data
  • 2020–21 New Annual Reclassified Fluent English Proficient (RFEP) Counts and Rates

Additionally, in 2023, the CDE will be working on releasing new data reports and downloadable files regarding course and class enrollment, as well as updated reports for students with disabilities. 

Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Wednesday, July 12, 2023
Recently Posted in Accessing Educational Data
  • DataQuest Schedule (added 20-Jun-2024)
    An overview of the DataQuest reports expected to be released in the coming year.
  • DataQuest Update, Issue #20 (added 17-May-2024)
    DataQuest is an online data reporting resource that provides access to a wide variety of data reports and downloadable data files.
  • File Structure: CBEDS by Race/Ethnic & Gender 2023 (added 16-May-2024)
    File structure for CBEDS data by race/ethnicity, gender, and school for 2023-24. Data include classified staff and home-to-school transportation data.
  • File Structure: CBEDS Data About Schools/Districts (added 16-May-2024)
    File structure for California Basic Educational Data System (CBEDS) data about schools and districts for 2023.
  • File Structure: Census Day Enrollment Data (added 16-May-2024)
    File structure for downloadable files containing Census Day TK/K–12 enrollment data from the California Longitudinal Pupil Achievement Data System (CALPADS) disaggregated by grade, race/ethnicity, gender, and other student details.