Student Sign-In Sheet
- Version
- 1'858 Downloads
- 250 KB File Size
- January 3, 2022 Updated
- 0 Number of comments
- Rating
How do you keep track of attendance for school classes, independent study, or other educational events? This free printable template will help you document whether students are present, tardy, or absent. Using this student sign-in sheet will help you keep track of who is on campus, which students have completed specific assignments, or time logged for credit hours.
Student Sign-In Sheet Template Contents
This sign-in/sign-out sheet template contains seven unique worksheets, with six different formats for student sign-in sheets. That way you can choose the one that best meets your school’s needs.
The worksheets are designed to fit on standard US letter sized paper. Each of them is in portrait mode, so they will fit easily on a clipboard. Some of these forms are best completed digitally, to take advantage of our helpful formulas.
Here is a quick overview of each of the included worksheets.
School
A weekly sign-in log, this worksheet has space to track students over the course of seven days. This attendance log gives you an at-a-glance record of which students were present, tardy, or absent.
In order to customize this digital document, you must use the included Setup worksheet. Then you can easily pull up the file on your computer or tablet and update it at the start of each session.
This sign-in sheet is not designed to be printed before use. Otherwise you will have to manually record all of the information. This is a good option for a simple digital sign-in sheet.
College
A simple five-column sign-in sheet, this worksheet asks students to record their first and last names and provide some basic details.
Currently this asks students how many college applications they’ve submitted, and if they’ve sent in any scholarships. But you can easily customize this sign-in sheet to collect the information you need.
Lesson One Student
Are you looking for an individual sign-in sheet that allows a student to track hours? This form is not just for teachers. It can be adapted for independent study, research sessions, tracking graduated license driving hours, and more.
This worksheet has 13 rows for data entry. There are formulas built in to help track hours. Students enter the start and stop time, and the duration is automatically calculated. The total hours are also updated after each entry.
There is a space for the student signature in each row. This could be added electronically, or the form could be printed after it’s complete and the signatures added at that point.
Lesson Multiple Students
Does your class use small group instruction or study groups? This student sign-in sheet is the perfect option for groups that meet regularly.
Designed for up to five students, this sign-in template can track attendance at four different team meetings.
Setup
This simple worksheet is required to prepare the Student and University sign-in sheets. Directions for how to use it are provided below.
Student Attendance
If you need a simple student attendance log, this class sign-in sheet will work.
There’s room for a school logo and information about the course in the header. Students enter their name, student number, and signature.
At the bottom, there is space for Admin use to reflect the date received and entered into a different system. This worksheet would also be handy for lessons that occur outside of the regular classroom.
University
Need a quick way to track attendance on a tablet at the start of a college course or lecture? This sign-in sheet also uses the Setup worksheet and uses drop down options. It also asks students to sign next to their name.
Using this form in Excel on a tablet or other touch-screen device will allow you to have the simplicity of the drop-down menus, while still being able to collect signatures from the college kids. They can just click their status, and quickly sign next to their name.
How to Customize and Use the Student Sign-In Sheets
You can begin the customization of any worksheet by adding your school or academy name. You can select the color for your text. Using your school colors would be a fun way to build school spirit.
Remember to update the prepopulated text on the template to reflect your school’s class names and instructors.
Below, you will find directions for customizing each individual worksheet, so you can collect exactly what you need with each one.
School
To prepare this worksheet, you must use the Setup page of the template. You will be working in both “List1” and “List2” sections.
In List1, you want to populate the options for student attendance. Currently, there are four options:
- Present
- Absent
- Leave (typically a pre-arranged absence)
- Late
You can update this list to reflect the terminology your school uses.
List2 currently has seven days of the week listed. These correlate with the column headers on the worksheet:
You can change these to reflect class sessions, lecture titles, lab units, or any other event name. When you make the changes to List2, you will also need to change the column header text on the School Student Sign-In Sheet template. That way the language is the same.
You have the option of blacking out two different columns. This is helpful for some courses like weightlifting, when students will be resting on certain days.
When you have the two lists updated, you can go back to the School Sign-In Sheet tab in Excel. You can update the text to reflect what you need to capture. You can type in student names and enter your Roll Numbers.
Currently, the roll number is prepopulated by adding 1 to the previous number. You can simply change the number in the cell B7, and the rest will automatically update. You can also manually type these in if your school has preassigned roll numbers for students.
In the upper right-hand corner, you will see two entries, Rest Day 1 and Rest Day 2. Here is where you select which days need blacked out. If you don’t want to black out any days, just leave these blank.
You can change the wording as well, to meet the needs of your class.
When your sheet is customized, you can simply open it up on a tablet or computer when it’s time to take attendance. Mark each student’s attendance status for the day.
University
Since this is a daily form, you will need to add a new date each day that you use it.
In the first column, you will find student numbers (S#). If you change the entry in cell B7, each entry after that will add one. So, if you change it to a 1, the next row will say 2, and so on. If you wish to change the formula completely, you can follow the directions in this post:
Copy a formula by dragging the fill handle in Excel
In Row C of this Excel template, you need to type in your student names. If you have more than 13 students, you can insert additional rows. If you do this, you will need to drag down the formulas in each column (see the article linked above).
The Roll No. column is currently set up to pick a random number between 1000-2000. If a randomized number works for your university, you can leave it as is. Or you can type in the student’s actual roll number.
Columns E and F allow you to indicate the student’s attendance status for two different sessions. To create the options for the drop-down menu, you need to click over to the Setup tab. You will only use List1.
Once you update the options in List1, you will be able to select the correct attendance for each student by clicking on the arrow next to the cell.
Finally, this form has space for a signature. If you decide to turn it into a third session to track attendance instead, you can follow the directions in this article:
How to Fill a Formula Across Excel
To use this form after you prepare it, simply click on the drop-down arrow next to each student. Mark their attendance.
Then you can print it out and have each student sign. Or, you can keep your roster on a tablet or a touch-screen computer and let students digitally sign.
College
You can change the column headings to collect the information about your students that you need.
Once your sheet is ready, just hit print. As students arrive, they can note their arrival time, sign themselves in and provide the requested information.
Lesson One Student
This form is built for one student, so you will need to customize one for each student who will be using it.
If the student has any previous hours for this course that are not logged, you can add that to the “Previous Cumulative Hours” section.
Each day that the student signs in, they can log into this form and track their hours. Formulas make it automatically calculate duration time if you enter the starting and ending time.
At the bottom of the form, the total number of hours worked during this form are added together. Each time you make a change, this number will update.
There are two messages at the bottom. You can update these to reflect your school’s policies.
To take advantage of the automatic calculations in this spreadsheet, you can have the student add the date, start, and end time for each meeting. Then, the duration and total hours will automatically calculate.
When the form is full, or when the student has reached the number of approved hours, you can print it out.
Conversely, you can have the student sign with a digital signature each time they add a new entry.
Lesson Multiple Students
Meant to be used with small groups of students, this attendance tracker is simple to customize. Type in the names of the students in the group.
Print out the form. At the start of each group meeting, have a student or instructor fill out the date, start time, and end time. Then, have each person who is in attendance write their name and sign.
File the form away until the next meeting. Then, repeat the steps listed above. Do this up to four times, and then print a new sign-in sheet.
Student Attendance
You can add your logo to this worksheet, to add a personalized touch. The Logo placeholder is a rectangle. Follow the directions in this post to upload your logo.
To use this sign-in sheet, print it out before each class. Then, have your students sign-in when they arrive. They can write their name and student ID number. Then, they can sign the form.
Easily Keep Track of Your Students
With these student sign-in sheets, any teacher can easily keep track of where their students are and ensure everyone is accounted for.
