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, Student Discipline and Student Biographical Data.

Deadlines

The 2023-2024 and the 2024-2025 Student Interchange files are open for uploads.

Student Interchange Timeline (PDF) (updated 7/12/2024)
- 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

2024-2025

2024-2025 Student Demographic File Layout (PDF) (posted 3/7/2024)
2024-2025 Student School Association File Layout (PDF) (updated 3/22/2024)
2024-2025 Graduation Guidelines File Layout (PDF) (posted 3/7/2024)
2024-2025 Adjustment File Layout (PDF) (posted 3/7/2024)
- Only used in specific circumstances during the Student End of Year Collection (opens in May with the start of the SEY Collection)

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 SEY Collection)

Business Rules

2024-2025

2024-2025 Student Demographic Business Rules (XLSX) (posted 7/8/2024)
2024-2025 Student School Association Business Rules (XLSX) (posted 7/8/2024)
2024-2025 Graduation Guidelines Business Rules (XLSX) (posted 7/8/2024)
2024-2025 Adjustment File Business Rules (XLSX) (posted 7/8/2024)

2023-2024

2023-2024 Student Demographic Business Rules (XLSX) (updated 8/9/2023)
2023-2024 Student School Association Business Rules (XLSX) (updated 4/10/2024)
2023-2024 Graduation Guidelines Business Rules (XLSX) (updated 8/9/2023)
2023-2024 Adjustment File Business Rules (XLSX) (updated 5/1/2024)

Templates

2024-2025

2024-2025 Student Demographic Template (XLSX)
2024-2025 Student School Association Template (XLSX)
2024-2025 Graduation Guidelines Template (XLSX)
2024-2025 Adjustment Template (XLSX)
- Adjustment File Instructions (PDF) (posted 3/11/2023)
2024-2025 Exception Request Template and Instructions (XLSX)
- July 2024 - December 2024, Contact StudentOctober@cde.state.co.us
- January 2025 - December 2025, Contact StudentEndOfYear@cde.state.co.us
Mid-Year EL Coding Changes Additional Documentation (DOCX)
- 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

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 StudentOctober@cde.state.co.us
- January 2024 - December 2024, Contact StudentEndOfYear@cde.state.co.us
Mid-Year EL Coding Changes Additional Documentation (DOCX)
- 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

2024-2025 Student Interchange Office Hours 1^st Session
- July 24^th, 10:00-11:30 a.m.
- Microsoft Teams Join Link
2024-2025 Student Interchange Office Hours 2^nd Session
- August 15^th, 1:00-2:30 p.m.
- Microsoft Teams Join Link
Graduation Guidelines: Reporting GG File Overview (PPTX) (Recording) (posted 4/6/2022)
2023-2024 Office Hours Presentation (PPTX) (Recording) (posted 8/9/2023)
Collaborative Monitoring of Graduation Guidelines (PPTX) (Recording) (posted 11/15/2022)

Short Bytes

CEDAR/COGNOS Introduction (Recording) (posted 6/16/2023)
English Learners: Overview & Progression (PPTX) (Recording) (updated 2/27/2024)
- English Learner Coding Guide (PDF)
English Learner Exceptions: July to October (PPTX) (Recording) (updated 2/27/2024)
- English Learner Coding Guide (PDF)
English Learner Exceptions: October to Student End of Year (PPTX) (Recording) (updated 2/27/2024)
- English Learner Coding Guide (PDF)
Entry & Exit Types/Dates (PPTX) (Recording) (posted 4/24/2023)
- Student Enrollment Record Guide (PDF)
Foster Care (PPTX) (Recording) (posted 5/26/2023)
Grade Level Checks: Retention Codes & Grade Reassignments (PPTX) (Recording) (posted 4/24/2023)
Postsecondary Programs: ASCENT (PPTX) (Recording) (updated 2/27/2024)
Postsecondary Programs: Other Programs (PPTX) (Recording) (posted 6/28/2023)
Postsecondary Programs: P-TECH (PPTX) (Recording) (posted 6/29/2023)
Postsecondary Programs: TREP (PPTX) (Recording) (updated 2/27/2024)

Additional Resources

Student Interchange Cognos Report Guide (PDF) (updated 4/22/2024)
Student Enrollment Record Guide (PDF) (posted 3/27/2024)
Graduation Guidelines Website
- Graduation Guidelines FAQ
- Graduation Guidelines Menu of Options
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)
Date First Enrolled in US: SSA data field (PDF) (posted 5/7/2024)
Guide to Keeping Leading Zeros in Excel (PDF) (updated 2/8/2022)
How to format cells in Excel (if you've lost your leading zeros) (PDF) (posted 8/15/2022)
English Learner Coding Guide (PDF) (posted 6/12/2024)
Preschool Student Data Reporting (PDF) (posted 3/11/2024)
Steps to upload files in Data Pipeline (PDF) (updated 5/24/2024)
Tagging Interchange Files (PDF) (updated 5/24/2024)
Troubleshooting File Uploads/Snapshots (PDF) (updated 5/24/2024)

For Student Demographic or Student School Association questions, contact: StudentOctober@cde.state.co.us
For Graduation Guidelines or Adjustment questions, contact: StudentEndofYear@cde.state.co.us