free weekly student attendance excel template

A user prompt is displayed:Ĭlick on the downward pointing arrow head and the selection list is displayed showing the two options: PR and AB. To mark attendance simply click in a cell corresponding to a student and a day of the week. Make sure you save it somewhere safe and accessible because you will need to open it each time you have a lesson for this group. Now that you have entered all student names let's just make sure that you have saved the weekly attendance sheet. This will allow you to sort the data in the Student Name column alphabetically by Surname.

It is really good practice to enter your student names by using the format.

It will be due to the Week Beginning date not corresponding to a Monday. If the date is incorrect for the day of the week The cell directly below the Weekīeginning date will display the day of the week for the date entered.īeginning date you will notice the cells under the days of the week are You will then need to enter the Week Beginning date. Simply click into the relevant cell and enter How to use the weekly attendance sheet templateĮnter the information at the top of the worksheet to identify the Statistics are calculated for each day, as a percentage of the total number of students attending each class.Ī total attendance figure is calculated, as a percentage of the total number of students attending each class over the whole week. Statistics are calculated for each student, as a percentage of the lessons attended for the week. The spread sheet allows for up to 30 student names to be entered. To be able to quickly identify what days of the week your lessons are well attended, allows you to better plan your classroom activities and resources. Not only is it great for recording weekly attendance but it will automatically apply some simple statistics on the attendance data and plot the results on a graph. If you want to analyze your students attendance record then this template is for you.

A4 - Landscape for Attendance Sheets and Charts

Free weekly student attendance excel template