Download free attendance tracking forms for Excel, OpenOffice, or Google Sheets. The two class attendance record templates below are designed for classroom attendance, but they can be adapted for other attendance tracking needs by changing some of the labels. They are also useful for printing blank attendance forms that you complete by hand.

If you would like to track attendance for business meetings, clubs, or Sunday School classes, try the Attendance Record Template.

Advertisement
Watermark - Attendance Tracking

Using the Attendance Tracking Forms

The Monthly Class Attendance Form is designed so that the days of the week and the dates used for the column labels update based on the Month and Year that you specify. If you get errors in these dates, check the spelling of the Month. On a given day, you enter a T, U, E, or P in the column to indicate whether the student was Tardy, Unexcused, Excused, or Present. The totals are a count of the number of T's, U's, E's, or P's in each row (the formulas are not case-sensitive).

The Weekly Student Attendance Record does not depend on the month, year, or week, but you can enter a date in the Week Of field for reference. Track attendance by just adding an "x" or some other letter into the correct column. In the weekly form, it is possible to mark a student as both "Tardy" and "Present". Make sure you are consistent with your reporting requirements.

For both of these attendance spreadsheets, you'll probably want to save a copy of the form after the month or week is over. To do that, copy or duplicate the worksheet so that each week or month is a separate tab within the workbook. Rename the tabs according to the month or week. You can create these worksheets ahead of time for an entire year, or as you go. Add your students' names before creating copies of the worksheet. You also might want to print the completed forms in case of a computer failure.

If you have additional questions about using these forms, please Contact Us.

categories:

Monthly Class Attendance Form

for Excel and Google Sheets
Monthly Attendance Form
Screenshots: 1
Download
Version: Excel 2003 or later

Template Details

License: Private Use
View Agreement >
(not for distribution or resale)
Support
Visit Support Page >

Other Versions


Advertisement

Description

This monthly class attendance tracking form was designed to work for any year and month. To start tracking attendance for a new month, simply copy the worksheet, clear the info from the previous month, and change the month via the drop-down box.

"No installation, no macros - just a simple spreadsheet" - by

Weekly Student Attendance Record

for Excel and Google Sheets
Weekly Student Attendance Record
Download
Version: Excel 2003 or later

Template Details

License: Private Use
View Agreement >
(not for distribution or resale)
Support
Visit Support Page >

Other Versions

Description

This weekly student attendance tracking spreadsheet was designed to work for any year and month. The instructions are basically the same as for the monthly class attendance template listed above

Time and Attendance Tracking Forms

There are a number of free templates for time and attendance tracking at Microsoft.com. In addition to Student Attendance Records, you will find Word, InfoPath, PowerPoint, and Access templates for everything from basic attendance forms to employee time and billing systems.

Search for a attendance tracking at Microsoft

Share Our Attendance Tracking Forms

If you find these attendance templates useful, please share the link to this page with others who may be interested.

Like This Template?

Become a Fan

Vertex42's Facebook Page Vertex42's Google+ Page Vertex42's Pinterest Page
Excel training for your entire company