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 and 2023-2024 Student Interchange files are open for uploads.

• Student Interchange Timeline (PDF) (updated 7/18/2023)
  • ​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) (updated 8/9/2023)
• 2023-2024 Student School Association Business Rules (XLSX) (updated 8/14/2023)
• 2023-2024 Graduation Guidelines Business Rules (XLSX) (updated 8/9/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 StudentOctober@cde.state.co.us
  • January 2024 - December 2024, Contact StudentEndOfYear@cde.state.co.us
• 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 StudentOctober@cde.state.co.us
  • January 2023 - December 2023, Contact StudentEndOfYear@cde.state.co.us
• 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/9/2023)
• Collaborative Monitoring of Graduation Guidelines (PPT) (Recording) (posted 11/15/2022)
• EL Coding Training (PPT) Recording (posted 9/9/2022)

Short Bytes

• CEDAR/COGNOS Introduction (Recording) (posted 6/16/2023)
• English Learners: Overview & Progression (Recording) (PPT) (posted 5/23/2023)
• English Learner Exceptions: July to October (Recording) (PPT) (posted 7/20/2023)
• English Learner Exceptions: October to Student End of Year (Recording) (PPT) (posted 3/31/2023)
• Entry & Exit Types/Dates (Recording) (PPT) (posted 4/24/2023)
  • ​SEY Entry/Exit Code Guide (PDF)
• Foster Care (Recording) (PPT) (posted 5/26/2023)
• Grade Level Checks: Retention Codes & Grade Reassignments (Recording) (PPT) (posted 4/24/2023)
• Postsecondary Programs - ASCENT (Recording) (PPT) (posted 7/21/2023)
• Postsecondary Programs - Other Programs (Recording) (PPT) (posted 6/28/2023)
• Postsecondary Programs - P-TECH (Recording) (PPT) (posted 6/29/2023)
• Postsecondary Programs - TREP (Recording) (PPT) (posted 7/21/2023)
• Student Interchange New Respondent Overview (Recording) (posted 4/3/2023)

Additional Resources

• Cognos Report Guide (PDF) (posted 5/10/2022)
• 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)
• 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)
• School 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: StudentOctober@cde.state.co.us
For Graduation Guidelines or Adjustment questions, contact: StudentEndofYear@cde.state.co.us