The SIMPLEST Way To Take Attendance

🎬In this video, we're going back to the basics to optimize attendance taking in classrooms using Google Sheets and forms📊. We've heard your 🗣️feedback and worked with you to provide solutions. If you remember how we revolutionized attendance during the pandemic with QR codes, then this new approach is a must-watch! This tutorial will guide you through creating a new attendance system from scratch. We'll start with a simple approach by just adding check boxes ✅ for each date and student. Then, we'll dive into a more complex but incredibly beneficial system to differentiate between those who are present👍🏽, late⏰, and absent ❌ using Google forms. But that's not all! We'll also demonstrate how to analyze your attendance data more effectively by adjusting the formatting in Google Sheets. Whether you're an educator 🧑🏽‍🏫 or an administrator🏫, this tutorial will significantly simplify your attendance tracking. Toward the end of the video, we'll tackle a more advanced method that includes utilizing formulas to automate the process. Don't worry if it gets complicated—we'll walk you through it step by step, and there will be a link to the file used in the video in the description below to guide you along. So, stick around till the end of the video to see how we can pull it all together in an easy-to-read format that will ease your reporting process. If you want to see my example to copy, check it out here ➡️ https://docs.google.com/spreadsheets/d/1yw5Rc9p-JEk6WViGnQ0A8RRqH6vbv0meF-hGP1FlJcI/copy 🎯If you're wanting to start your own YouTube channel, there's a lot to learn so click this link to learn the one YouTube strategy that generates 122k views per day here: https://courses.seancannell.com/a/2147510103/LtsTJr2J ---------------------------------------------------------------------------------------------------- ⏳ TIMESTAMPS ---------------------------------------------------------------------------------------------------- 0:00 Intro 0:22 The most basic system 0:45 A more dynamic system 3:43 How to build the attendance analysis 4:31 SEQUENCE() function with dates 6:05 MATCH() function with wildcards 8:44 VLOOKUP() with MATCH() 10:10 Fixing the N/A error 10:51 Midway Promo 11:31 How to make good looking Google Sheets 12:21 Dynamic calendar 13:30 Incorporating periods into attendance 13:45 Array Literal 15:36 Easy way to freeze rows and columns 16:51 How to use dropdown chips 16:48 Basic conditional formatting 18:50 Testing the data 19:50 Why this is better than the QR attendance system ---------------------------------------------------------------------------------------------------- 💬 GOT A QUESTION? ↓↓↓ Leave a comment down below ↓↓↓