Engage in Civil Discourse. Find Common Ground. Learn more at TheLineK12.com

National Employee Absence & Substitute Data

2017-2018 School Year

About the Report

This report analyzes data from over 5,000 K-12 organizations using Frontline’s absence and substitute management tool. The available data is so comprehensive that the Center for Research and Reform in Education at Johns Hopkins University has declared it to be representative of national trends.

The report addresses the following objectives:

  • Increase awareness regarding the number of absences that are professionally related
  • Provide data regarding actual trends in professionally related absences
  • Analyze the degree of common understanding between Human Resources and Curriculum and Instruction personnel regarding the incidence and impact of professionally related absences
  • Suggest strategies for reducing these professionally related absences

Interactive Charts: Where applicable, you can filter data by selecting/un-selecting the axis categories. Hover over charts for more details and click the plus sign for a breakdown of the data.

 

 
Absence & Fill Rates

Average Number of Absences1 per Employee

Insight: With the school year coming to an end, school employees (other than administrative staff) took fewer absences in June.


1 "Absence” refers to an absence event, where any individual absence counts as one absence, regardless of duration.

Administrative Staff: Administrative Staff | Certified – Teacher Staff: Teacher Staff | Certified – Non Teacher Staff: Nursing Staff and Professional Services Staff | Classified Staff: Administrative Office Support Staff, Facilities Staff, Food Services Staff, Security Staff, Substitutes Staff, Support Staff, Technology Services Staff, Transportation Staff and Extracurricular Activities Staff | Other Staff: All others


Percentage of Absences by Reason

Insight: In June, vacation and personal days (combined) overtook illness as the leading cause of absences. This was driven primarily by administrative staff absences.

 
Categories marked with an * above are prof. related absences.

*The "Other" category for absences may include bereavement, jury duty, military leave, unexcused absences and workers compensation, as well as absences not associated with any reason.


Professionally related absences: Absences related to an employee’s regular responsibilities that are directed or approved by the organization (district) or school. Unlike personal absences (illness, bereavement, etc.), the individual’s reasons and dates for being absent are directly controlled or approved by organization or school-level leaders.

- What they include: professional development, field trips, association/ bargaining unit work, school business

- What they do not include: illness, vacation, personal time off, bereavement, jury duty, military leave, unexcused absences, workers’ compensation.


Average Teacher Fill Rate*

Insight: Despite fewer teacher absences, the fill rate decreased in June, as substitutes worked fewer days.

View Breakdown

Average Teacher Fill Rate - By Institution Type

 

 

Average Teacher Fill Rate - All Buildings

*Fill rate indicates the percentage of teacher absences requiring a substitute that were in fact filled by a substitute. The percentage is calculated by dividing the number of filled absences by the number of absences that required a substitute.


Teacher Fill Rate by Absence Lead Time*

Insight: Low fill rates could be avoided by increasing lead time — especially for professionally related absences, which are typically planned weeks in advance.

*Based on data from teacher absences only. Absence lead time refers to the number of days between when an absence occurs and when it is entered into Frontline Absence & Time. An absence with zero days of lead time is entered on the same day it occurs.


Teacher Fill Rate by Day of Week*

Insight: A full quarter of teacher absences in June fell on Fridays, which likely contributed to particularly low fill rates.

  • 21%
  • 18%
  • 20%
  • 20%
  • 21%
 
  • 19%
  • 18%
  • 19%
  • 20%
  • 23%
 
  • 22%
  • 18%
  • 18%
  • 19%
  • 23%
 
  • 19%
  • 20%
  • 18%
  • 24%
  • 19%
 
  • 25%
  • 18%
  • 18%
  • 17%
  • 21%
 
  • 22%
  • 18%
  • 19%
  • 19%
  • 22%
 
  • 21%
  • 19%
  • 18%
  • 21%
  • 22%
 
  • 22%
  • 16%
  • 15%
  • 23%
  • 24%
 
  • 18%
  • 17%
  • 18%
  • 20%
  • 26%
 
  • 20%
  • 17%
  • 18%
  • 19%
  • 26%
 
  • 21%
  • 19%
  • 17%
  • 17%
  • 25%
 

*Based on data from teacher absences only.

 
Substitutes

Percentage of Non-Working Substitutes

Insight: In June, extra-large rural districts saw the lowest percentage of non-working substitutes — as well as the highest fill rates.


Average Number of Days Worked 3 per Substitute*

Insight: Although teachers took fewer absences in June, substitutes worked half as many days as they did in May. This led to low fill rates.

3 “Days worked” represents absences substitutes filled at one district, even if they work at multiple districts.

*Based on average number of days worked per substitute for teacher absences only


Average Teacher to Sub Ratio


Insight: Generally, lower teacher/substitute ratios correlate with higher fill rates. In June, however, this was not the case.
 

Average teacher/sub Ratio


Average teacher/sub ratio by fill rate (counting all subs)


Average teacher/sub ratio by fill rate (counting all subs)


Average teacher/sub ratio by fill rate (counting all subs)


Average teacher/sub ratio by fill rate (counting all subs)


Average teacher/sub ratio by fill rate (counting all subs)


Average teacher/sub ratio by fill rate (counting all subs)
Average Teacher to Sub Ratio - Feb 2018

Average teacher/sub ratio by fill rate (counting all subs)
Average Teacher to Sub Ratio - March 2018

Average teacher/sub ratio by fill rate (counting all subs)
Average Teacher to Sub Ratio - April 2018

Average teacher/sub ratio by fill rate (counting all subs) April 2018 - Average teacher/sub ratio by fill rate (counting all subs)
Average Teacher to Sub Ratio - May 2018

Average teacher/sub ratio by fill rate (counting all subs) May 2018 - Average teacher/sub ratio by fill rate (counting all subs)
Average Teacher to Sub Ratio - June 2018

Average teacher/sub ratio by fill rate (counting all subs) June 2018 - Average teacher/sub ratio by fill rate (counting all subs)

Average Illness Related Absences

Insight: Overall, illness-related absences correlate loosely with influenza-like illness activity as reported by the Centers for Disease Control and Prevention. However, the weeks around the holidays tend to be an exception, with fewer employees being absent.

Note: Influenza activity, determined by the percent of visits to outpatient healthcare facilities for influenza-like illness, is reported on a weekly basis by the CDC. The national baseline for this metric is 2.2%.

Source for % flu related outpatient visits: “Weekly U.S. Influenza Report”, Centers for Disease Control and Prevention (CDC)

*Significant dips in the avg # of illnesses corresponds to school vacation times (Thanksgiving and December holiday breaks). 

Data Validation

Data includes public school districts, educational service agencies and charter and private schools.

Month/Year8/179/1710/1711/1712/171/182/183/184/185/186/18
Total # of Organizations5,5655,5935,5995,6025,7055,7145,7115,7335,7375,8115,795
 


In this report, district size definitions are as follows:

  • Small: 1 to 100 employees
  • Medium: 101 to 1000 employees
  • Large: 1,001 to 2,500 employees
  • Extra large: 2,501 employees or more

In this report, locale (rural, suburban, town, city) is defined based on definitions from NCES.