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 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 programs 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

Due to the impact of COVID-19, the 2019-20 Designated Agency Data Collection deadline has been extended to September 30, 2020. Submitting the data earlier has benefits, however, because it will allow you to finish the 19-20 collection prior to beginning to collect the data you will need for the 20-21 collection as well as avoid adding to your tasks to complete during the busy beginning of the next school year.

File Layout and Definitions

2019-2020 Designated Agency Data Collection File Layout (PDF) (4/1/2019)
- Designated Agency and Endorsement Codes (XLSX) (updated 5/20/2020)
2020-2021 Designated Agency Data Collection File Layout (PDF) (3/23/2020)

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