Student names are entered into the annual attendance worksheet, and this information is carried over into each of the monthly attendance worksheets through formulas. These can be changed should the ones that come as standard not be suited to your needs. The letters represent the letters that you will enter in the monthly attendance worksheets to record attendance, while the words will also appear on these worksheets as the key. The section at the bottom of the page, listed under 'other' refers to the attendance types that may be recorded. The year, teacher name, room number and subject appear at the top of every other sheet, and filling these in should be self-explanatory. The information entered in the settings worksheet is used to populate much of the rest of the workbook. Should the codes provided not be suitable for your requirements, they can be amended on the settings worksheet. Simply use the one letter code displayed above the dates to record attendance. Weekends have been greyed out for ease of display, however, it is still possible to enter data for the weekends should this be required. The course information and student names are populated by data provided in the settings and yearly attendance worksheets, while the totals are added up as data is entered, so it is just the attendance itself that needs to be filled in.

If the worksheets are printed, information filled out by hand will need to be entered on screen at a later date in order to see the annual summary. The monthly attendance worksheets have been formatted so that they can be either filled in on screen, or printed out to serve as attendance forms be filled in by hand. The summary shown on this page is ideal for either printing for future reference, or for saving as a PDF for emailing to heads of schools, years or departments.

The only information that needs entering on this page is student names, as the rest of the data is populated by data given in the monthly attendance and settings worksheets.

The yearly attendance worksheet provides a summary of attendance (as entered in the monthly attendance worksheets) over the whole year, or year to date, if not all months have yet been filled in. Data entered in the monthly attendance and setting sheet is used to populate the annual attendance sheet, which shows how many times students have attended or been absent over the 12-month period. This template consists of an annual summary sheet, along with 12 monthly attendance sheets and a settings page.

Student attendance excel template