You are here

Data Pipeline Snapshots - Student End of Year

Overview

The purpose of the Student End of Year Snapshot is to collect enrollment and outcome information for students during a school year. This includes demographic information and student’s entry and exit from public schools within a district. The data from this collection is used to derive the graduation, dropout, mobility, and stability rates. Additional information about the rates generated by this collection is provided in the rate and report information section below.

The Student End of Year (SEY) collection is broken into three phases. Please see the relevant sections below for more specific instructions for that phase.


Deadlines

The 2022-2023 Student End of Year collection opens on Thursday, May 4, 2023 and closes Thursday, November 30, 2023.


 File Layout and Definitions

Business Rules 

Templates


Training

SEY Training Schedule (PDF) (updated 6/16/2023)

Student End of Year Training

Office Hours 

  • May 16, 2023 (PPT) (Recording)
    • SE234/SE235 Students categorically eligible for free lunch
    • SE240 Exceptions when students receiving 18-21 transition services transfer between districts 
    • SE301 Anticipating/preventing missing graduation guidelines errors
    • Monitoring potential summer graduates
  • June 20, 2023 (PPT) (Recording)
    • Critical components of SEY Records
    • Missing Record - SE400 series errors
    • Students attending BOCES Schools/Programs
    • International Exchange Students
    • Homebased Education Students + AYG
  • July 18, 2023 (PPT) (Recording)
    • Retention Codes
    • SE060
    • SE050
    • HSED Recipients
    • Data Validation
  • August 15, 2023 (PPT) (Recording)
    • School Exit Type/Entry Type Partners
    • Exit Types that Comprise the AYG Cohort
      • Following up with students in Facility Schools
    • Using snapshot records to review/compare OCT & SEY subgroup counts
  • September 19, 2023 (PPT) (Recording)
    • Cross LEA Phase
      • Overview
      • Steps
      • Business Rules
      • Adjustment File
      • Data Validation
  • October 17, 2023 (PPT) (Recording)
    • Post-Cross LEA Phase
      • Overview & Mechanics
      • Errors & Warnings
      • Exceptions & Data Change Requests
      • Final Data Validation, Superintendent Verification (Sign-Off), Public Data Release
  • November 14, 2023 (PPT) (Recording)
    • Post-Cross: Exceptions & Data Change Requests
    • AYG Overview & Assignment Logic
      • SE186 Errors
    • Superintendent Verification
    • January Data Release
    • SEY Privacy Guidelines

 


 Student End of Year Data Collection Phases

 Regular Phase

The Regular Phase is the primary data collection and clean-up phase for the Student End of Year (SEY) snapshot. During the regular phase, districts must upload the Student Demographic, Student School Association, and the Graduation Guidelines files for the Student End of Year Snapshot. Please see the Student Interchange page for more file layouts and additional information.

 Cross LEA Phase

The Cross LEA phase is the first of two post-collection phases. During this phase, an initial process is run to validate if a student previously enrolled in a district has been recovered by another Colorado school district or completed a High School Equivalency Diploma (HSED) after exiting the prior district. Districts then address SE700 level warnings/errors to clean up data discrepancies. 

 Post-Cross LEA Phase

The Post-Cross LEA phase is the second post-collection phase. During this phase districts complete a final validation of student data. SE900 level warnings/errors are addressed to ensure data accuracy.

Adjustment File

The Adjustment File is typically loaded to address Cross LEA errors, but can be loaded anytime in the collection. It is used to provide additional information about students who were previously enrolled in a district and did not enroll in the current school years. Adjustment codes should only be used for 7th-12th grade students for whom the district has received notification that a student previously reported as not exiting, dropout, expulsion, or HSED transfer during a previous reporting period completed their education through another education agency.

Adequate Documentation of Transfer

Districts are required to have adequate documentation of transfer when coding students as transferring out of their district to avoid incorrectly coding students as dropouts. During the Post-Cross LEA phase, SE903 errors require districts to submit adequate documentation for students who are reported as transferring out of district who were not subsequently reported in another district. Please see the Adequate Documentation website for more information and templates.


Additional Resources


 Rate and Report Information

The End of Year collection provides the data used to calculate graduation, completion, dropout and mobility rates for districts on our Educational Statistics page. This information is published online in January the following year in compliance with state and federal law. Districts have access to advanced reports that provide tentative calculations through the COGNOS system in Data Pipeline.


Contact: StudentEndofYear@cde.state.co.us