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 2024-2025 opens December 2, 2024 and closes August 29, 2025.

File Layout and Definitions

• 2024-2025 Designated Agency and Endorsement Codes (XLS) (posted 10/31/2024)
• 2024-2025 Designated Agency Data Collection File Layout (PDF) (posted 10/31/2024)

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, 02, 03, or 04 for gender)
  • Guide to keeping leading zeros in excel

Business Rules

• Designated Agency Collection Business Rules (XLSX) (posted 10/30/2024)

Templates

Use the following template to facilitate data upload.

• Designated Agency Data Upload Template (XLSX) (posted 10/30/2024)

Trainings

• DADC Data Submission Instructions (PDF) (posted 10/30/2024)

Additional Resources

Login Requests

• Please contact Research and Impact to get set up with a login credential.

Contact: Research and Impact for any questions concerning the data collection or issues with data upload.