You are here
Data Pipeline Interchanges - Student
Overview
The Student Interchange is a set of four files, Student Demographic, Student School Association, Graduation Guidelines and Adjustment files, which contain student information for a school year. This information is used in the following collections: Student October, Special Education December Count, Special Education Discipline, Student End of Year, and Student Biographical Data.
Deadlines
The 2022-2023 Student Interchange files are open for uploads. The 2023-2024 Student Interchange will open on July 17, 2023.
- Student Interchange Timeline (PDF) (posted 8/16/2022)
- This document provides a broad overview of the Student Interchange and how it is utilized throughout school year for data collections.
File Layout and Definitions
2023-2024
- 2023-2024 Student Demographic File Layout (PDF) (posted 3/28/2023)
- 2023-2024 Student School Association File Layout (PDF) (posted 3/28/2023)
- 2023-2024 Graduation Guidelines File Layout (PDF) (posted 3/28/2023)
- 2023-2024 Adjustment File Layout (PDF) (posted 3/28/2023)
- Only used in specific circumstances during the Student End of Year Collection
- Opens in May with the start of the Student End of Year Collection
2022-2023
- 2022-2023 Student Demographic File Layout (PDF) (updated 2/2/2023)
- 2022-2023 Student School Association File Layout (PDF) (posted 3/31/2022)
- 2022-2023 Graduation Guidelines File Layout (PDF) (posted 3/31/2022)
- 2022-2023 Adjustment File Layout (PDF) (posted 3/31/2022)
- Only used in specific circumstances during the Student End of Year Collection
- Opens in May with the start of the Student End of Year Collection
Business Rules
2023-2024
- 2023-2024 Student Demographic Business Rules (XLSX) (posted 5/1/2023)
- 2023-2024 Student School Association Business Rules (XLSX) (posted 5/1/2023)
- 2023-2024 Graduation Guidelines Business Rules (XLSX) (posted 5/1/2023)
- 2023-2024 Adjustment File Business Rules (XLSX) (posted 5/1/2023)
2022-2023
- 2022-2023 Student Demographic Business Rules (XLSX) (updated 3/29/2023)
- 2022-2023 Student School Association Business Rules (XLSX) (updated 3/29/2023)
- 2022-2023 Graduation Guidelines Business Rules (XLSX) (updated 3/29/2023)
- 2022-2023 Adjustment File Business Rules (XLSX) (posted 2/7/2023)
Templates
2023-2024
- 2023-2024 Student Demographic Template (XLSX)
- 2023-2024 Student School Association Template (XLSX)
- 2023-2024 Graduation Guidelines Template (XLSX)
- 2023-2024 Adjustment File Template (XLSX)
- Adjustment File Instructions (PDF) (posted 3/11/2023)
- 2023-2024 Exception Request Template and Instructions (XLSX)
- July 2023 - December 2023, Contact Brooke Wenzel
- January 2024 - December 2024, Contact Reagan Ward
- Mid-Year EL Coding Changes Additional Documentation
- This form is used when a student's EL coding is changing after October Count in the same school year and same district with an EL history > 2 years (3 Student October, 2 Student End of Year collections).
- Contact Reagan Ward
2022-2023
- 2022-2023 Student Demographic Template (XLSX)
- 2022-2023 Student School Association Template (XLSX)
- 2022-2023 Graduation Guidelines Template (XLSX)
- 2022-2023 Adjustment Template (XLSX)
- Adjustment File Instructions (PDF) (posted 3/11/2023)
- 2022-2023 Exception Request Template and Instructions (XLSX)
- July 2022 - December 2022, Contact Brooke Wenzel
- January 2023 - December 2023, Contact Reagan Ward
- Mid-Year EL Coding Changes Form (updated 3/30/2023)
- This form is used when a student's EL coding is changing after October Count in the same school year and same district with an EL history > 2 years (3 Student October, 2 Student End of Year collections).
- Contact Reagan Ward
Training
Webinars
- Graduation Guidelines: Reporting GG File Overview (PPT) (Recording) (posted 4/6/2022)
- Office Hours Presentation (PPT) (Recording) (posted 8/17/2022)
- 2022-2023 Collaborative Monitoring of Graduation Guidelines (PPT) (Recording) (posted 11/15/2022)
- EL Coding Training (PPT) Recording (posted 9/9/2022)
Short Bytes
- English Learners: Overview & Progression (Recording) (PPT) (posted 5/23/2023)
- English Learner Exceptions: October to Student End of Year (Recording) (PPT) (posted 3/31/2023)
- Student Interchange New Respondent Overview (Recording) (posted 4/3/2023)
- Entry & Exit Types/Dates (Recording) (PPT) (posted 4/24/2023)
- Foster Care (Recording) (PPT) (posted 5/26/2023)
- Grade Level Checks: Retention Codes & Grade Reassignments (Recording) (PPT) (posted 4/24/2023)
Additional Resources
- Cognos Report Guide (PDF) (posted 5/10/2022)
- Graduation Guidelines Website
- 2022-2023 Graduation Guidelines: Excel File Formatting Guide (PDF) (posted 8/23/2022)
- Graduation Guidelines File: General Information and District Considerations (PDF) (posted 4/7/2023)
- Guide to Keeping Leading Zeros in Excel (updated 2/8/2022)
- How to format cells in Excel (if you've lost your leading zeros) (PDF) (posted 8/15/2022)
- Language Instruction Program Descriptions (PDF) (updated 1/12/2022)
- Special Education Transition Students: Coding Guide (updated 4/26/2021)
- Steps to upload files in Data Pipeline (PDF) (updated 11/17/2020)
- Student End of Year: Entry/Exit Code Guide (PDF) (updated 3/29/2023)
- Tagging Interchange Files (PDF) (posted 6/1/2022)
- Troubleshooting File Uploads/Snapshots (PDF) (posted 3/16/2023)
For Student School Association or Student Demographic questions, contact: Brooke Wenzel, wenzel_b@cde.state.co.us
For Graduation Guidelines or Adjustment questions, contact: Reagan Ward, ward_r@cde.state.co.us
Connect With Us
