Please note that this is not a regular spreadsheet template. This is a pre-made Sheetgo spreadsheet-based workflow, which is basically a ready-to-use system based on Google Sheets and operated by Sheetgo.

Every teacher is aware of the fact that some of their students tend to skip a few classes where possible. If this teacher does not have an easy system to track each student’s attendance, it can get difficult to manage a big group. The Student attendance tracker template in Google Sheets makes it much easier because of its ease-of-use and automatic configuration. Take a look at the diagram below to see how it is designed in something so easy and common as spreadsheets.

Student Attendance Tracker in Google Sheets: Workflow Diagram

How the system works

The template consists of a master spreadsheet to easily monitor all of your students’ attendance levels. The information comes from separate spreadsheets per class (e.g. Math, History, Science) and is consolidated into this one master file. The template is provided with some dummy data for the teacher to overwrite with own student information. This information automatically flows into a dashboard and uses relevant metrics to analyze each student’s performance.

Let’s get you started

Step 1. Install the template

Install the Student attendance tracker template by clicking the button above. You will be asked to log in using your Google account. This will automatically create your Sheetgo account as well. After doing so, click on the ‘Use template’ button to install the template.

Student Attendance Tracker

Sheetgo has now automatically created the system by connecting the Google Drive folder “Classes” to the Master spreadsheet called “Attendance management”. Inside the “Classes” folder, you will find a spreadsheet for History, Science, and Math class. Expand this system to more classes as you like, simply by copy/pasting one of the spreadsheets and storing them in the same Drive folder.

Example

Student Attendance Tracker: Network View of  Workflow and Connections

Step 2. Open all spreadsheets

Click on the spreadsheet and folder icons to open both the “Classes” folder and the “Attendance management” spreadsheet that are stored inside your Google Drive. Inside the “Classes” folder you will find 3 Classes spreadsheets (Science, History, and Math), provided with dummy data.

Step 3. Fill out the information

Inside the “Math” spreadsheet, for example, you will find instructions on how to use the template. The system provides 12 tabs, each representing the month of the year. Inside these tabs, you can easily monitor each of your students’ attendance and the reason for absence.

Example

Student Attendance Tracker: Instructions

Step 4. Configure your student attendance tracker

After filling out all the absence information of each of your classes, update the consolidate connection. Go back to the Sheetgo Web Application and click on the play button ‘Run workflow’ to do so. This will automatically bring the data into the master spreadsheet, where you can monitor the following:

  • Attendance dashboard
  • Daily attendance checker (to see if you have filled out the attendance tracker on a daily basis)
  • Overview per student

Example

Student Attendance Tracker : Dashboard

Congrats! 🙂

You’ve successfully configured your Student attendance tracker template in Google Sheets. Never lose track of your students’ attendance records ever again.

Share This