High Level Design
Overview
School Principals and other senior officials want and need to view indicators measuring student attendance & detentions. Poor attendance and detentions are strongly correlated to higher dropouts and low student success. Regular attendance, on the other hand, increases the 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.Dashboard Example (sample data)
Click on the image to open and interact with the dashboard:
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
