End of Year (EOY)

Overview

The student end of year snapshot collects the educational information for student for a school year.  This includes the student demographic information and the students entry and exit from within a district.  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. 

Training

New Submissions Staff
17-18 EOY Submissions Training - Module 1 - Data Collection/Review (24 min) [Recording] [Slides]
17-18 EOY Submissions Training - Module 2 - Submission to CSI (31 min) [Recording] [Slides]
17-18 EOY Submissions Training - Module 3 - Error Resolution (27 min) [Recording] [Slides]
17-18 EOY Submissions Training - Module 4 - Summary Reports (17 min) [Recording] [Slides]

Returning Submissions Staff
17-18 EOY Submissions Training - Module 1 - Data Collection/Review (19 min) [Recording] [Slides]
17-18 EOY Submissions Training - Module 2 - Submission to CSI (17 min) [Recording] [Slides]
17-18 EOY Submissions Training - Module 3 - Error Resolution (17 min) [Recording] [Slides]
17-18 EOY Submissions Training - Module 4 - Summary Reports (12 min) [Recording] [Slides]

Deadlines/Important Dates

1/31/2018 Recorded EOY Training Available
2/14/2018 Initial File Submissions Due
6/13/2018 Level 1 Errors Cleared
7/12/2018 Level 2 Errors Cleared
8/22/2018 Initial Summary Certification Due
11/2/2018 Final Summary Certification Due

File Layout and Definition Documents

The 17-18 End of Year submission requires all schools to submit a Student Demographic (SD) and a Student School Association (SSA) file.  Schools offering advanced placement and postsecondary courses must also submit an Advanced Course Completion (ACC) file. CSI designated Title I Targeted Assistance schools must also submit a Title I file.
2017-2018 Student Demographic File Layout - CSI Additions (last updated 08/15/2017)
2017-2018 Student School Association File Layout - CSI Additions (last updated 3/1/2018)
2017-2018 Advanced Course Completion File Layout - CSI Additions (last updated 12/22/2017)
2017-2018 Title I File Layout - CSI Additions (last updated 08/11/2017)

Business Rules (Troubleshooting Errors)

2017-18 Business Rules with CSI Troubleshooting Notes
The Google spreadsheet has a tab for troubleshooting Student Demographic (Level 1) Errors, Student School Association (Level 1) Errors, and End of Year (Level 2) Errors.

Additional Resources

2017-18 Data Validation Strategies Checklist - SD and SSA
Student End of Year Adequate Documentation - Please be sure you have adequate documentation on file before determining the appropriate exit code for students that exit your school.  Sample forms, including a Confirmation of Attendance form, are included as well.  


EL Resources

  English Learner Coding Scenarios
     CDE Language Instructional Program Options (LIP descriptions)         
    16-17 CSI EL Redesignation Training [recording] [slides]      

FRL Resources
 
General FRL information
 Infinite Campus Importing Meal Status
 Infinite Campus Assigning Access to Meal Status
 PowerSchool Quick Import Instructions
 PowerSchool Page Level Security for FRL Status

SIS Setup/Resources
PowerSchool CO State Reporting Online Documentation
Infinite Campus Gifted and Talented Instructions
PS Instructions on Finding New SD Fields 17-18
IC Instructions on Finding New SD Fields 17-18