Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Introduction

"Students who are chronically absent—meaning they miss at least 15 days of school in a year—are at serious risk of falling behind in school. Yet, for too long, this crisis in our nation's public elementary and secondary schools has not been fully understood."

From the introduction to CHRONIC ABSENTEEISM IN THE NATION'S SCHOOLS: A hidden educational crisis by the U.S. Department of Education.

Views in this Collection


Installation

Install using the option code "CHRAB"

...

For more information, see the AMT Deployment Guide.

Functional Vision

A new use case, Chronic Absenteeism or "chrab", will expand the Analytics Middle Tier by providing one or more views that facilitate exploration of chronic absenteeism across various demographic perspectives, as available from the Ed-Fi ODS database.

...

Although there are similarities with the Early Warning System views, this Chronic Absenteeism use case will provide different shapes to the data and may provide additional demographic information that were not relevant to the Balfanz-model of early warning for potential high school dropout.

Example Queries

Note

This sample query assumes the Texas model of counting attendance by home room, and it assumes that attendance is being handle "negatively": that is, a student is assumed present unless marked as absent.

Code Block
languagesql
titleAttendance Rate "Now"
with aggr as (
  select
    StudentKey,
    SchoolKey,
    count(1) as DaysEnrolled,
    sum(IsAbsentFromHomeRoom) as DaysAbsent,
  from
	analytics.chrab_AttendanceFact
  group by
    StudentKey,
    SchoolKey
)
select
  (DaysEnrolled - DaysAbsent) / DaysEnrolled as AttendanceRate
from
  aggr


Code Block
languagesql
titleHistoric Attendance Rate
select
  DateDim.DateKey,
  Attendance.StudentKey,
  Attendance.SchoolKey,
  (Attendance.DaysEnrolled - Attendance.DaysAbsent) / Attendance.DaysEnrolled as AttendanceRateToDate
from 
  analytics.DateDim
outer apply (
  select
    StudentKey,
    SchoolKey,
    count(1) as DaysEnrolled,
    sum(IsAbsentFromHomeRoom) as DaysAbsent
  from
    analytics.chrab_AttendanceFact
  where
    chrab_AttendanceFact.DateKey < DateDim.DateKey
  group by
    StudentKey,
    SchoolKey
) as Attendance


...