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:

Attendance Dashboard - Education

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