Designing a Free Academic Early Alert System

Abstract

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

Keywords

• academic progression, information dissemination, documentation, remediation