MENU

Fun & Interesting

How to Create a QR Code Attendance System in 2023 for Teachers

Hash Ali 227,408 2 years ago
Video Not Working? Fix It Now

**ATTENTION! QR CODES HAVE NOW STOPPED WORKING GOOGLE SHEETS! **THIS METHOD IS NOW OUT OF DATE. USE THIS ONE INSTEAD: https://youtu.be/Hay_26HjPhA?si=wTzUFBBzKsuy3dnA If you still want to use this old method, this spreadsheet shows how to implement it: https://docs.google.com/spreadsheets/d/1UhchGNcIKf5IpoYoyXVzSKpOAL9_V2shWPhWT2H7tbY/copy Advance your analytics journey: Contribute here for expert consults and additional tools: https://ko-fi.com/hashalinz In this video, we'll show you how to create a QR code attendance system in 2023 using Google Sheets and Google Forms. With this system, you'll be able to track attendance and make sure that all students are following the instructions of the school. We've done it before, but this time we have more efficient, more user-friendly, and all-round better formulas and functions in Google Sheets. QR codes are becoming more and more popular, and this attendance system is a great way to use them to improve school compliance. With this system, you'll be able to make sure that all students are following the instructions of the school and that they're able to attend classes safely and on time. So be sure to watch this video and learn how to create a QR code attendance system in 2023! 📋To create the QR code, just copy and paste this formula: =ArrayFormula(if(B2:B="",,image("https://quickchart.io/qr?text="&B2:B))) You may need to adjust to the correct column if your spreadsheet is setup differently. ---------------------------------------------------------------------------------------------------- 💬 GOT A QUESTION? ↓↓↓ Leave a comment down below ↓↓↓

Comment