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
Жыл бұрын
can you please do a video on QR codes for dummies, so I can understand
@dvibes4971
10 ай бұрын
Really helpful, i do wish it was possible to automate the system with qr codes or some way for individuals to clock in
@HashAliNZ
9 ай бұрын
Check out this video right here to do exactly that: kzitem.info/news/bejne/qZevxWZsgZyBm3Y&lc=UgwDU6yGASJwARYnZdp4AaABAg
@nicolaszanin202
8 ай бұрын
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!
@abdullahharounbenramdane1144
6 ай бұрын
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?
@lvnaris955
10 ай бұрын
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 ?
@user-qg7mj5vf3r
6 ай бұрын
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?
@M.Johani
11 ай бұрын
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
9 ай бұрын
I've got exactly what you need right here: kzitem.info/news/bejne/qZevxWZsgZyBm3Y&lc=UgwDU6yGASJwARYnZdp4AaABAg
@juddyandbella2240
Жыл бұрын
How do you attach a QR code to this and then prevent another student from scanning or taking attendance for another student
@HashAliNZ
9 ай бұрын
Like this: kzitem.info/news/bejne/qZevxWZsgZyBm3Y&lc=UgwDU6yGASJwARYnZdp4AaABAg
@henryeffiom7610
9 ай бұрын
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
9 ай бұрын
Have you seen the features of the new method? Check it out here: kzitem.info/news/bejne/qZevxWZsgZyBm3Y&lc=Ugyy1Vt43_HEAIY3_iF4AaABAg
@henryeffiom7610
8 ай бұрын
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?
@abbasdhila6057
4 ай бұрын
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
3 ай бұрын
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
3 ай бұрын
Thanks a lot. You are right, it was actually because the dates did not match. When I changed the dates, it became right.
@abbasdhila6057
3 ай бұрын
@@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
3 ай бұрын
@@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
3 ай бұрын
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
@RahA202
Жыл бұрын
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
Жыл бұрын
Great question! I have this video here for how to implement QR codes for teachers, for events planners, for community meetings: kzitem.info/news/bejne/wGxjwHh9h6aUhZw 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!
Пікірлер: 24