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 ➡️ docs.google.com/spreadsheets/...
🎯If you're wanting to start your own KZread channel, there's a lot to learn so click this link to learn the one KZread strategy that generates 122k views per day here: courses.seancannell.com/a/214...
----------------------------------------------------------------------------------------------------
⏳ 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 ↓↓↓
Пікірлер: 24
Just traded your 📝 paper attendance lists for our digital tricks? Let us know how it's going! Got a Google Sheets secret of your own? Share your attendance wisdom down below! Remember, the comment section is the new staff room - let's learn from each other! 🎓📚
@RahA202
11 ай бұрын
can you please do a video on QR codes for dummies, so I can understand
Really helpful, i do wish it was possible to automate the system with qr codes or some way for individuals to clock in
@HashAliNZ
7 ай бұрын
Check out this video right here to do exactly that: kzread.info/dash/bejne/epWtwZRveM22mKQ.html&lc=UgwDU6yGASJwARYnZdp4AaABAg
What do i type in the date command when i only use the days wednesday and thursdays? so i start on wednesday? I dont understand it with the -weekday thing can someone help ?
It is very useful, thank you. Do I find it in QR CODE way, for example, by giving my students the QR CODE slip and I scan it with my phone?
Love the video man! I just want to know if it is possible to make the students data (names / IDs ) be drained from a another google sheets? If so, the students can be specific to a certain period ? An example would be, the teacher selecting a period (example: G1), than a specific group of students ( the G1 student group) shows up to register attendance. That would help me immensely, but even so, your video was amazing anyway!
How do I create an attendance table that looks like this one that draws data from the QR-Code-generated attendance data as you described in "How to a QR Code Attendance System in 2024 for Teachers" video?
I was watching your videos hoping to find a solution for the third downside. In the meantime I'm making one qr code and tracking attendance with the Email done the response. Thanks for info, wish to see more.
@HashAliNZ
7 ай бұрын
I've got exactly what you need right here: kzread.info/dash/bejne/epWtwZRveM22mKQ.html&lc=UgwDU6yGASJwARYnZdp4AaABAg
How do you attach a QR code to this and then prevent another student from scanning or taking attendance for another student
@HashAliNZ
7 ай бұрын
Like this: kzread.info/dash/bejne/epWtwZRveM22mKQ.html&lc=UgwDU6yGASJwARYnZdp4AaABAg
Hello Hash, please I have a URL generated Qrcodes which at scan shows up student’s Biodata screenshot with theIr registration number as the QRCode name. Please how can I use this for attendance?
@HashAliNZ
7 ай бұрын
Have you seen the features of the new method? Check it out here: kzread.info/dash/bejne/epWtwZRveM22mKQ.html&lc=Ugyy1Vt43_HEAIY3_iF4AaABAg
@henryeffiom7610
6 ай бұрын
Yes I have seen the video but I am asking since I have issued ID card with QRcode generated with google drive link to students already plead can the qrcode work for attendance in google sheet?
I love your videos, but unfortunately I skipped the day they were teaching QR codes and need help to understand. Could you possibly do a video on QR codes for dummies :)
@HashAliNZ
11 ай бұрын
Great question! I have this video here for how to implement QR codes for teachers, for events planners, for community meetings: kzread.info/dash/bejne/kWphvKaAftfJgso.html But over the next few weeks I have some alternatives that get away from QR codes because they worked great during the pandemic, but they have some flaws we need to avoid! These alternative (non-QR) methods are easier to set up and most teachers will be able to adapt very easy with them with little-to-no tech knowledge when things go wrong! Stay tuned!
hello hash, I am having a problem in 9:28 to 9:45 ...... first I didnt understand how did the dollar signs appear themselves in B2 and AC ..... second is when I do ,0 in the end .... for me the present/absent just disappears... they dont come... IDK whats the problem.... pls help me ASAP
@HashAliNZ
Ай бұрын
Hi, the dollar signs appear because I clicked the F4 key on my keyboard when the cursor was in that part of the formula. The F4 key toggles those dollar signs. I think on Mac it's Function + F4 but I'm not really sure. For the ,0 problem, the only reason it would do that is if the names don't match perfectly. The ,0 is required otherwise you'll get mismatched information, but you need to make sure that the name in both tabs are exactly the same.
@abbasdhila6057
Ай бұрын
Thanks a lot. You are right, it was actually because the dates did not match. When I changed the dates, it became right.
@abbasdhila6057
Ай бұрын
@@HashAliNZ sorry to trouble you again, but I am having another problem at 13:30, I am trying to do the &C3 function to incorporate periods, but when I press enter the whole P & As disappear. do you know why that could be? Thanks for your help
@HashAliNZ
Ай бұрын
@@abbasdhila6057 Hey again! Did you do the array literal part? The bit with the curly brackets and putting the three ranges together with the curly brackets? If you want to see the finished product, there is a copy of the spreadsheet in the description
@abbasdhila6057
Ай бұрын
Yes I saw the copy. You mean to say that after doing the array literal, the present absent will appear again? But thats not what happened in your video, Like for you after you did "&C3" the values didnt disappear in d7-j