How to Track Student Attendance in Google Sheets - Google Sheets Tutorial For Teachers

My Twitter: twitter.com/PakistaniPepper
My Twitch: twitch.tv/pakistanipepper

Part 1 (How to Use Google Forms for Student Attendance): youtu.be/CUlg1Kpcs7A

In the first part of this tutorial (above), I showed you how to use Google Forms to capture which students were attending your class in Google Classroom remotely. Now, with this tutorial, I show you how to use Google Sheets to organize that attendance file and understand how many times each student attended. Google Sheets is a great tool that can organize so much student data for you, and this tutorial shows you how to do all those things without problem. The function being used in the video is the "COUNTIF" function, and it allows you to count just how many times a student has attended your class in any given month. The exact phrasing of the function is =COUNTIF(C2:C40, "Student"), where C2:C40 is your range and "Student" is the name of the student you are tracking.

I strongly recommend you watch the previous tutorial first, as some of the information in this is dependent on understanding how to arrive at this Attendance sheet (which you learn in the Google Forms tutorial)

Here are the key markers of what you can find in this video:

0:00 - Introduction and Credits
0:28 - Organizing Your Sheet
1:23 - Filter Attendance by Month
2:18 - Creating New Sheet with Just That Month
2:35 - Labeling and Filtering New Sheet
3:38 - The Long Way to Count Attendance
4:24 - The COUNTIF Function to Count Attendance
6:53 - Counting New Month's Attendance
8:08 - Using the COUNTIF Function Again
10:08 - Conclusion

If you have any questions, do leave them in the comments below and if you find the video helpful, consider liking and subscribing. Thanks for watching!