Designated Agency Data Collection

Overview

Pursuant to Colorado Revised Statute 22-2-112(q), the Colorado Department of Education is directed to collaborate with the Colorado Department of Higher Education to prepare an annual report on the effectiveness of educator preparation programs, which include higher education institutions and alternative educator preparation programs. The Colorado Department of Education shall work cooperatively with each alternative educator preparation program to collect candidate data that are required to fulfill CRS 22-2-112(q).

This website contains resources concerning the data collection.

Notes: Before proceeding with the data upload, please carefully review the file layout requirements. Also, download and have handy the designated agency and endorsement code book.

Deadlines

The Designated Agency Data Collection for 2022-2023 opens December 1, 2022 and closes August 31, 2023.

File Layout and Definitions

Designated Agency and Endorsement Codes (updated 2/28/2023)
2022-2023 Designated Agency Data Collection File Layout (PDF) (updated 11/29/2022)

File Formatting

Pipeline only accepts file extensions of: csv txt xls xlsx
You need a header row (in first row)
Pipeline only accepts field delimiters of: , | ~
Include leading zeros (0) for required fields (for instance 01 or 02 for gender)
- Guide to keeping leading zeros in excel