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.

Dashboard Example (sample data)

Click on the image to open and interact with the dashboard:

Explore 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