Designing a Free Academic Early Alert System

  • Adam C Welch East Tennessee State University
  • Adam Greever East Tennessee State University
  • Carmen Linne East Tennessee State University
Keywords: academic progression, information dissemination, documentation, remediation


This manuscript describes the development and implementation of a cloud-based, academic early alert system using Google Sheets. It was written for a non-computer savvy person to be able to develop the early alert system. By creating a Master Sheet and using the syntax from the share function of Google Sheets, a unique sheet can be created for each advisor that limits information sharing of their specific advisees. By adding a Google Form to the sheet, advisor interventions can be captured that reflect interventions made as a result of the early alert sheet.

Approximately 52% of students were identified on the early alert sheet by having at least one non-passing score on an exam. There were 35-50% of faculty advisors who documented their interventions in the sheet. The template and coding used to develop this academic early alert sheet may be applied to other central documentation needs, such as professionalism early alert.

Conflict of Interest

Dr. Welch reports owning stock in Alphabet, Inc, however, was not involved in the selection of Google as the preferred platform at this institution.


Type: Note


Download data is not yet available.
Received 2016-08-17
Published 2016-10-17