High Level Design
Overview
School principals and other senior officials want and need to view indicators measuring student attendance and detentions. Poor attendance and detentions are strongly correlated to higher dropouts and low student success. Regular attendance, on the other hand, increases a student’s chance of graduation, grades, school performance and improves a student’s relationship with the community while helping them develop important social skills and friendships.Goals
Improve & track Student Attendance and Suspension Rates
Objectives
- Track Student Overall Enrollment Numbers
- Improve Student Attendance
- Decrease Detentions
KPIs Architecture
| Objectives | KPIs | Measures | Data Source |
| Identify Current Enrollment and Monthly Trend | Current Enrollment
(Students at end of latest week) |
# Students with EnrollmentFlag = 1 and EndOfWeekFlag = 1 | StudentDailyStatus,
Students, SchoolWorkingCalendar |
| Enrollment by Month
|
# Students with EnrollmentFlag = 1
At YearBeg, MonEnd and YearEnd |
StudentDailyStatus,
Students, SchoolWorkingCalendar |
|
| Track, Identify and Improve Student Attendance
|
Attendance % YTD | Number of Present Status /
Number of Present + Absent Statuses |
StudentDailyStatus |
| Attendance % By Month | Number of Present Status /
Number of Present + Absent Statuses
By WorkingDate |
StudentDailyStatus,
SchoolWorkingCalendar |
|
| Attendance % – Current Week vs Last Week | Number of Present Status /
Number of Present + Absent Statuses
For CWPWFlag = Current Week and CWPWFlag = Past Week |
StudentDailyStatus,
SchoolWorkingCalendar
|
|
| Attendance % By Grade
By Current Week, Past Week and YTD |
Number of Present Status /
Number of Present + Absent Statuses
For CWPWFlag = 1 (Current Week) and CWPWFlag = 1 (Past Week) |
StudentDailyStatus,
SchoolWorkingCalendar |
|
| % Students Absent YTD | #Students
By AbsenceRange |
Students | |
| Attendance % by Day of the Week | Number of Present Status /
Number of Present + Absent Statuses
By DayOfTheWeek |
StudentDailyStatus,
SchoolWorkingCalendar |
|
| Students with Frequent Absence
Track Students > .14% attendance % ytd with recent frequent ansence |
Number of Present Status /
Number of Present + Absent Statuses
For CurrentWeek =1; For CurrentWeek= 1 and PastWeek = 1
By Grade, StudentID, Name |
StudentDailyStatus,
SchoolWorkingCalendar, Students |
|
| Track and Decrease Suspensions | Suspension Rate
|
# Enrolled Students with Suspensions/# Current Enrolled Students
# Enrolled Students = Count of Students with enrolled flag of 1 |
StudentDailyStatus |
| Suspension Rate By Month
|
# Enrolled Students with Suspensions/# Current Enrolled Students
By Working Date |
StudentDailyStatus,
SchoolWorkingCalendar |
|
| Number of Suspensions – Current vs Past Week | # Students with Suspensions
For CWPWFlag = Current Week and CWPWFlag = Past Week |
StudentDailyStatus,
Students SchoolWorkingCalendar |
|
| Suspensions By Grade | CountAll( SuspensionStatus)
By Grade By SuspensionStatus |
StudentDailyStatus,
Students |
|
| Suspension Details | CountAll( SuspensionStatus)
By Grade, StudentID, StudentName |
StudentDailyStatus,
Students |
Entities Relationship Diagram
Data Connectors
