Data Pipeline Snapshots - End of Year

Overview

The student end of year snapshot collects student enrollment information throughout the school year. This information includes student demographic identifiers, codes indicating the way students enroll and withdrawal from a district, and services students received. This information is used to calculate dropout, graduation, and completion rates. In addition to this, the student end of year snapshot collects high school student's post-secondary and AP course information. Additional information about the rates generated by this collection is provided in the rate and report information section below.

Deadlines

The 2017-18 Collection is currently open. The target date for having clean interchange files is Thursday June 28, 2018.

2017-18 Student End of Year Timeline (PDF) updated 5/15/2018
New ASCENT/PTECH guidance for 2017-18 updated 1/12/18

The EOY collection is broken into three phases. Please see the relevant sections below for more specific instructions for that phase.

Regular Process phase (Feb - Sept)
Cross LEA phase (Oct)
Post-Cross LEA phase (Nov)

File Layout and Definitions

2017-18 File Layout and Definitions for Student End of Year Snapshot (PDF) (Updated 5/15/2018)
2017-18 File Layout and Definitions for Adjustment File (PDF) (Updated 5/24/2018)

Business Rules and Exceptions

Student End of Year Snapshot Business Rules (XLS) (Updated 5/15/2018)
Exception Request Template and Instructions - Link (XLSX) (Updated 4/06/2016)

Regular Process

During the regular process, districts must upload the Student Demographic, Student School Association, and the Student Advanced Course Completion files for the Student End of Year Snapshot. More information about those interchange files can be found on the Student Interchange page (link).

Please see the Snapshot file layout for more information about which students are included in the EOY collection

Student End of Year Checklist (DOCX)
Step by Step Instructions to complete Student End of Year (PDF)
Frequently Asked Questions - Detailed responses to common EOY questions (updated 5/24/18)
LAM steps to assign roles for End of Year collection (PDF)

Training

2017-2018 - Training Schedule and Recordings

2017-2018 Student End of Year Training Schedule (updated 4/25/2018)
2017-2018 Fundamentals of Student End of Year (PPTX) Webinar Recording (updated 6/7/2018)
Student End of Year Office Hours
- Tuesday, June 12, 2018 - 9:30am-10:30am
- Wednesday, June 20, 2018 - 2:30pm-3:30pm
- Data Services Adobe Webinar Link
- Phone: 855.397.4421

2016-2017 - Training Slides and Recording

2016-2017 Student End of Year Fundamentals Training (PPTX) (updated 5/11/17)
2016-2017 Student End of Year Fundamentals Webinar (updated 5/11/17)

Cross LEA process

The Cross LEA process validates if a student previously enrolled in a district have been recovered by another Colorado School district or completed a High School Equivalency Diploma test after exiting the prior district. During this phase most SE700 level warnings are elevated to errors and require district attention.

Step by step instructions for Cross LEA process (PDF) (Updated 9/27/16)
Student End of Year Cross LEA Training (2017) Webinar (updated 10/5/17)

EOY Adjustment File - File Layout, Template, Business Rules

The EOY Adjustment file is used to provide additional information about students who were previously enrolled in a district and did not enroll in the current school year. It is typically loaded to address Cross LEA errors, although it can be loaded anytime in the collection.

2016-17 File Layout and Definitions for Adjustment File (PDF) (Updated 4/07/2017)
EOY Adjustment Template (XLS) (Updated 4/07/2017)
2015-16 Adjustment File Business Rules (XLS)

Templates

Adjustment File Instruction for SE700 and SE800 Errors

SE701/801 Instructions (PDF) (updated 9/26/2016)
SE702/802 Instructions (PDF) (updated 9/25/2015)
SE703/803 Instructions (PDF) (updated 9/25/2015)
SE704/804 Instructions (PDF) (updated 9/25/2015)
SE705/805 Instructions (PDF) (updated 9/26/2016)
SE706/806 Instructions (PDF) (updated 9/25/2015)
SE707/807 & SE708/808 Instructions (PDF) (updated 9/26/2016)
SE709/809 Instructions (PDF) (updated 9/25/2015)
SE710/810 Instructions (PDF) (updated 9/25/2015)
SE711/811 Instructions (PDF) (updated 9/25/2015)

Post-Cross LEA Validation Instructions

Step by step instructions for Post Cross LEA process (PDF)
Student End of Year Post Cross LEA Training (2017) Webinar (updated 10/31/17)
SE901, SE902, and SE903 Instructions (PDF)

Adequate Documentation of Transfer

Post Cross LEA SE903 Errors require districts to provide adequate documentation for students who are reported as transferring out of district who were not subsequently reported in another district. More information and templates are provided on the page below.

Adequate Documentation Page (Updated 4/7/2016)

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 the data pipeline.