How To Create QR Attendance for Teachers in 2020 !! (Google Sheets and Google Forms)

The digital age calls for contactless solutions, and QR codes are a fantastic answer. In this video, we're back with an updated, secure method for creating QR codes for attendance in 2020, leveraging the power of BeaconStac. Whether for school, work, or events, this system offers a more secure and user-friendly approach to attendance tracking. Dive in and learn how to modernize your attendance system with increased security.

If you want to see the completed Google Sheet from this video click here

----------------------------------------------------------------------------------------------------------------
📼CHECK OUT THE OTHER VIDEOS IN THIS SERIES
----------------------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

💬 GOT A QUESTION?
↓↓↓ Leave a comment down below ↓↓↓

[krollb]

This is fabulous! So well conceived, so clearly explained, so on point for a specific need for the times we are in. I just implemented your technique to print ID cards with QR codes for 800+ students after testing. Flawless. We already were using google forms on a shared Chromebook to take attendance prior to COVID, and were 100% remote last year using the same form, but this year we needed a touchless alternative on site which could also be self-serve for remote students. This was perfect. Thank you so very much on behalf of our staff and students. Bravo.

[AlexanderMcGruder]

My boss gave me a task and was expecting me to spend $4000 to solve it. Your video was the answer. So well put together. Explained so perfectly. I think I love you

[ahmadrisesatriawicaksono]

Wow, It's an amazing system Man. Your explanation is so detail. Thanks a lot for the tutorial.

[Lootlamma]

This is exactly what I needed! I am using this to track my students office visits. My assistant can scan the code of the student coming to the office and we have instant timestamped documentation!

[allisonbarker]

Thank you!!! You just saved me so much time this evening. I wanted to create something like this for contract tracing with seats, followed the instructions, and they look perfect. Thank you again!

[marcblanco]

I used your "old" method for the 20th anniversary event of our highschool. It was quick and reliable. I see now that you have a better version of it. Can't wait to see how it works. Thanks a lot!

[RAHULKUMAR-xjhp]

Learnt a lot of things in very less time 👍
Please make more and more videos like this .

[ഷാജിപാപ്പന്-ഹങ]

i havent seen someone this thorough in google sheets & forms. Appreicated!

[ramonvictorviray]

The instructions are so clear and easy to understand. You helped me a lot, sir. Thank you so much!

[jonchalk]

Just used the "join" formula on MS excel. Works exactly the same. Thank you.

[Jasmine-lzyf]

Extremely clear in explanation, very detailed & helpful! Thank you so much

[Digital.Done.Right.]

this is such a great video! I did not know of the Google API we can use for this. I have been wanting a static code to print on my business cards and on stickers but didn't want to pay for it. Now with your tips and explanation I can code a QR code. Thanks for making this even if it was for a different audience.

[Lizellers]

I enjoy how the "student names" are characters from the Rugrats show. Awesome!

[eileenlai]

Great video! So easy to follow and so clearly explained. Thank you for sharing!

[evineiteljorge]

Really awesome video. Thank you for teaching me how to create bulk QR codes without going through a sketchy site!

[PaulsEnglishFukuoka]

Very clear instruction and a perfect result. Impressed. Following avidly from this point.

[nischalsubedi]

Awesome Man, never knew you could do such things with Google Sheets and Forms!
Thanks for the knowledge my man!!

[timteacher]

Excellent video. I'm surprised you don't have more followers. You explain everything in a concise and logical way.

I've followed your video and adapted it slightly. My students here in Seoul have both English and Korean characters in their 'name' field. This morning I tested QR attendance with the students and everything worked, except that only 3 (out of 10 or so) responses had names attached to them. The timestamps showed all of the students were able to submit their attendance using QR codes though. Is there anyway that Korean characters could be screwing something up, or is there another issue that I'm not aware of? I'd be happy to share the spreadsheet with you or anyone else who is willing to take a look.

From one Kiwi to another.

[bryanchristiansalvador]

Dude you are a genius! You deserve more subs than what you currently have. Keep it up.

[christinejelbert]

Thanks for this! It's absolutely brilliant and elegantly done. Can't wait to see how easy attendance is going to be:-)