Data Pipeline Snapshots - End of Year

Overview

The student end of year snapshot collects student enrollment information throughout the school year.  This includes student demographic information, codes identifying 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.  

Deadlines

• 2014-15 Student End of Year timeline (PDF)

File Layout and Definitions

• 2014-15 File Layout and Definitions for IPST Overwrite File (PDF)
• 2014-15 File Layout and Definitions for Adjustment File (PDF)
• 2014-15 File Layout and Definitions for Student End of Year Snapshot (PDF)

Known Defects

• 2014-15 Student End of Year known defects (XLSX) - Coming soon

Business Rules

• 2014-15 IPST Overwrite Business Rules (XLS)
• 2014-15 Adjustment File Business Rules (XLS)
• 2014-15 Student End of Year Snapshot Business Rules (XLS)

Templates

• EOY Adjustment Template (XLS)
• Exception Request Template and Instructions - Link (XLSX)

Cross LEA Validation Instructions

• Step by step instructions for Cross LEA process (PDF)
• SE801 Instructions (PDF)
• SE802 Instructions (PDF)
• SE803 Instructions (PDF)
• SE804 Instructions (PDF)
• SE805 Instructions (PDF)
• SE806 Instructions (PDF)
• SE807 & SE808 Instructions (PDF)
• SE809 Instructions (PDF)
• SE810 Instructions (PDF)

Post Cross LEA Validation Instructions

• Step by step instructions for Post Cross LEA process (PDF)
• SE901, SE902, and SE903 Instructions (PDF)

Reports

• Report description and layout (DOCX)

• Mobility Example (DOC)

Trainings

• 2013-2014 Student End of Year Cross LEA training (August) (PPTX) 
• 2013-2014 May Student End of Year Training (PPTX)
• 2013-2014 Fundamentals Training Session (PPTX)
• 2012-2013 Fundamentals Training Session (PPT)
• Steps to complete Student End of Year (PDF)
• Student End of Year checklist (DOCX)

Adequate Documentation of Transfer

• Adequate Documentation Page

Additional Links

• Frequently Asked Questions - Detailed responses to common EOY questions
• Four Year On-time graduation rate FAQ
• On-time graduation talking points
• Exit type codes that comprise the graduation cohort
• LAM steps to assign roles for End of Year collection (PDF)
• US Education Department Graduation rate regulation
• US Education Department Graduation rate non-regulatory guidance

Contact: Kevin Smith smith_kevin@cde.state.co.us