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