Overview
The student interchange is a set of three files which contain student information for a school year. The student interchange contains student demographics, student enrollment records, post-secondary information and advanced course completion data. This information is used in the following collections: Pupil Enrollment (Student October) Count, Special Education December Count, Special Education Discipline, Student End of Year, and Student Biographical Data.
Deadlines
The 2016-2017 Student Interchange is now open in Data Pipeline for uploads.
File Layout and Definitions
2017-2018
Note: Changes for the 2017-2018 school year are highlighted in yellow within the documents.
- 2017-2018 Student Interchange File Layout and Definitions-Student Demographics (PDF) (Updated: 3/20/2017)
- 2017-2018 Student Interchange File Layout and Definitions-Student School Association (PDF) (Updated: 3/20/2017)
- 2017-2018 Student Interchange File Layout and Definitions-Advanced Course Completion (PDF) Not required for Student October (Updated: 3/20/2017)
- Summary of 2017-2018 Student Interchange File Changes (Updated: 3/20/2017)
2016-2017
Note: Changes for the 2016-2017 school year are highlighted in yellow within the documents.
- 2016-2017 Student Interchange File Layout and Definitions-Student Demographics (PDF) (Updated:9/6/2016)
- 2016-2017 Student Interchange File Layout and Definitions-Student School Association (PDF) (Updated:9/6/2016)
- 2016-2017 Student Interchange File Layout and Definitions-Advanced Course Completion (PDF) Not required for Student October (Updated: 9/6/2016)
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)
Business Rules
2017-2018
- The business rules for the 2017-2018 student collections are not currently available.
2016-2017
- 2016-2017 Student Interchange Business Rules-Student Demographics (XLSX) (Updated: 9/1/2016)
- 2016-2017 Student Interchange Business Rules-Student School Association (XLSX) (Updated: 9/1/2016)
- 2016-2017 Student Interchange Business Rules-Advanced Course Completion (XLS) (Updated: 7/14/2016)
Templates
2017-2018
- Templates for the 2017-2018 student collections are not currently available.
2016-2017
- 2016-2017 Student Demographics Template (XLS)
- 2016-2017 Student School Association Template (XLS)
- 2016-2017 Advanced Course Completion Template (XLS)
- Exception Request Template and Instructions (XLSX)
Trainings
- Steps to upload files in Data Pipeline (PDF)
- 2017-18 English Learner Changes Presentation (PDF) (Updated: 6/1/2017)
Additional Resources
- Student Profile FAQs (XLSX)
- Summary of Revised Guidance on Continuous Enrollments (Updated: 8/27/15)
- Definition of Continuous Enrollment (DOCX) (Updated: 2/14/2017)
Contact Morgan Holmgren at Holmgren_M@cde.state.co.us and Duncan Anderson at Anderson_D@cde.state.co.us
