Introduction and Background
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
- User runs the Ed-Fi ODS/API application and authorizes
...
2. StudentSchoolAssociation Posts (the names are fictitious)-
John Smith, Kelly Logan, Jennifer Hart getting enrolled in a school within a district. Choose different schools and its districts. John is going to be enrolled in one school only. Kelly will be enrolled in two schools with different FTEs. Jennifer will be enrolled in one school but entry date will be beyond Oct 1st.
a. Do a GET on schools to show that the school exists
b. Do a POST for John Smith. Make sure the Entry Date is within Oct 1st of the current year. Make sure his FTE is 1.0
c. Do a POST for Kelly Logan. Make sure the Entry Date is within OCT 1st of the current year. Make sure her FTE is 0.51
c. Do a POST for Kelly Logan. Make sure the entry date is within OCT 1st of the current year. Make sure her FTE is 0.49
d. Do a POST for Jennifer Hart. Make sure the entry date is beyond Oct 1st of the current year. Make sure her FTE is 1.0
...
...
Logic for calculating the Special Education Student Count:
...
The Special Education report displays the percent of students, ages 5-21 as of October 1st, who are receiving special education services divided by the number of all students in grades K-12 as reported in Fall membership.
Part B School Age - The report titled Special Education - Part B School Age includes students with a verified disability, ages 6 to 21. These students are reported under 13 primary disability categories and across 8 setting categories.
Part B Preschool - The report titled Special Education – Part B Preschool includes children with a verified disability, ages 3 to 5. These children are reported under 13 primary disability categories and across 9 setting categories.
Part C Infant/Toddler - The report titled Special Education – Infant/Toddler includes infants and toddlers with a verified disability, ages birth to 3.
...
- designed to meet the developmental needs of each eligible child and the needs of the family related to enhancing the child’s development;
- selected in collaboration with the parents;
- provided under public supervision by qualified personnel; in conformity with an individualized family service plan and at no cost to the family;
- required to meet the standards of the state.
Infants and toddlers with disabilities are reported under 13 by primary disability categories and across 3 setting categories.
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Report Generation Step-by-Step Guide
...
...
...
- reporting.LoadStudentFallMembership - inserts data into reporting.StudentFallMembership table.
- reporting.LoadSpedChildCount - inserts data into reporting.SpecialEducationChildCount table.
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Generate Reports
Now that the reporting tables have been populated using the above stored procedures you can use the provided SQL scripts to generate each report. These SQL scripts can be found under C:\Ed-Fi-Starter-Kit\ReportGenerationScripts folder. Look for your reports in the Reports folder on the desktop.
...
...
...
...
...
...