School Attendance Analysis

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.

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

Implementation
Kit

The following resources will enable you to design your dashboard and data model with sample data and then apply it to your own data. Note that you will need to have a previously installed version of Sisense (you can use the free trial version if you’re not a customer).

Sample data and dashboard examples (direct download)

Documentation