Attendance Tracker // Automated Attendance Tracker using Google Form and QR Code 2022
HTML-код
- Опубликовано: 8 июл 2024
- New FREE and EASY Google Form for Attendance Tracker Video Includes creating sections in Google forms and Conditional Formatting in Google Sheets
/ vhzfjn2h3v
If you would like to help support my channel please buy me a tea. I truly appreciate you. Thank you!
☕buymeacoffee.com/mahalo
#googleformstutorial #AttendanceTracker #socialemotional #MrsPTarleton
This video will show you how to create a Google Form for Attendance Tracker and add a QR code so students can quickly check in. You will also learn some tips and tricks to help eliminate students accidentally checking their friends into the class. The custom QR Code for this Google Form for attendance is an added element that will allow you to increase control over the form by changing the code daily if you choose.
Using this Google Form for Attendance tracker you will also be able to do a check in on your students Social Emotional Well Being. This is a great insight for teachers prior to the start of the lesson. When teachers check in with their students, they are able to increase engagement and motivation, support students’ wellbeing and lift their performance.
3 Design changes to improve Google Form for Attendance Tracker
• Improve Google Form Fo...
🎥Google Form for Behavior Tracking
• How to Use Google Form...
👀 Google Form for Digital Hall Pass
• Google Form Digital Ha...
ICE BREAKER/TEAM BUILDERS for EVERY SITUATION
• Ice Breakers Team Buil...
🔔🔔🔔For More Videos Like this Subscribe / @mrsptarleton
Check out my most recent video here
www.tubebuddy.com/quicknav/la...
Check out my most popular video
www.tubebuddy.com/quicknav/mo...
Watch this video next:
GOOGLE SLIDES
• Google Slides Advanced...
DIGITAL INTERACTIVE NOTEBOOKS
• Digital Interactive No...
GOOGLE FORMS
• Google Forms
QUIZIZZ GAMIFICATION
• Gamification
Follow me:
TikTok www.tiktok.com/@mrsptarleton?...
Pinterest / mrsptarleton
Facebook / mrsptarletonteachertro...
Instagram / teachertropics
Twitter / mrsptarleton
I AM A NEW TEACHER AND I AM SO THANKFUL TO GOD THAT I FOUND YOU!! BLESSINGS TO YOU AND YOUR FAMILY! I JUST DID MY FIRST GOOGLE FORM FOR ATTENDANCE! THANK YOU!!!! :)
@lisa welcome to the fun world of teaching. So glad you found this helpful. Thank you for the blessings. Blessings to you and yours also.
It’s a good method for single check-ins. One of my professors used it and automated it with Google sheets which made him incorrectly credit attendance. He gave three excuses absences but didn’t account for those or the days that he didn’t take attendance due to weather. Also it’s easy to game the system you can either forward the code to someone else, or the “word of the day” as my professor used. True attendance is best taken by the instructor or not taken at all.
@brayan8346 thank you for the feedback. The great thing about Google Forms is it generates the Google sheet automatically. Yes there is always a way to cheat the system...even when I physically take attendance and then count heads to be sure all accurate...on rare occasions I'll have students insist they were there and I made a mistake. Cheaters gonna Cheat.
thank you so much.. you have made my difficult stuff become easy
Thank you for watching. I am so happy that my video was selected to make difficult things easy. Will you be using this in a traditional classroom? Or for something else?
Brilliant!!
Thank you
@Sanjay Thank you. So glad you enjoyed.
Thanks a lot, this is super helpful,
You are so welcome. I'm so glad I could help.
tqvm.
@lisadunni8892 you are welcome, glad I could help.
thank you, this is very helpful
@AvelaDudula Thank you for watching and commenting. Put a smile on my face. Glad it's helpful.
I have a few questions was trying to do something like this for our bus monitors , to scan the kids school ID (which already has a barcode) when they get on the bus and scan it when they get off, and then look at the google sheet to show , well little johnny never sign out he must fell asleep on the bus... so more like a sign in/sign out google sheet?? any suggestions >
I'm not sure how you could scan the barcode. I'm wondering if the students can enter their student ID number as the entered and exited. Would that work?
Great tips! Anything to make attendance go more quickly! BUT - if I post it on Google Classroom, is there a way to keep them from completing the form if they're not actually in class? The QR code involves their phones, which we're trying to do away with.
@jenniferlewis3895 I've tried posting QR code in class, so they have to scan in person, but I still get the occasional slick one who has a picture of it that they scan from home. That's why I count to be sure the same number checking in are also in class. Cell phones are a constant battle. We have a no cell policy also, and I have them put away after they check in. Most comply.
I already had to use the behavior tracker because after multiple warnings about cell to class there was one who insisted on sneaking it out. Luckily I just made a copy of last year's and made a couple edits.
@@MrsPTarleton Sharing QR images with absent students concerns me too. Hopefully, not too many present students are helping their pals cheat like this.
great turtorial😊 Thanks! is their a easy way to see who is missing in class in Google sheets??. I have over 100 student in a week in different class’. I need a quick view who i have to follow up on- thx🙏
@kristoffer You could do conditional formatting to color code Google Sheets to help you see who is absent. Or another option is to sort the sheet based on who is absent.
I’m looking for the same. No response yet. I have 260 per day day. I think this is great; but not being able to track who isn’t in class will make this form incomplete
@@MrsPTarletonhow do you do this?
@PescesKitchen you need to set up conditional formatting which is ki d of clunky or a V look up and it will show you who is absent.
Please tell me if I setup in mobile fake gps program
This form will read which location ?
@mohamed not sure I completely understand your question. If you are asking if it will show person logging in location, I do not believe it would.
Also, if I'm already using GSheets for our existing rosters can I use those instead of creating a new form?
Yes, when you create your sheet you can choose to gather data in new sheet or existing sheet.
What about tracking students that aren’t in class? How do you go about that. I have 43 kids per class.
@PescesKitchen
You can do a Vlookup which would probably be the best way to mark absent students.
Does this work even if for example we do not have internet connection for that specific day?
@ariahkali7392 Unfortunately, Google Forms is cloud based and needs internet to work. My students all seem to have cells so I'd have them do that if ok with parents, and I'd log in the 1 or 2 who do not have cells.
So you just log the entire year of attendance in the same sheet.?
@thefandom I generally do it by month. Less data to sift through. I just make sure to name them so I can easily find them.
Is there a way for the teachers to have the QR code on their mobile device as well as printed out in the classroom?
Yes, you could easily have a screenshot of QR code on your mobile device.
Do you create a new form every day? Then is there a new QR for each one?
@KatGillang you could use a new QR code each day but you do not have to. The form allows for multiple responses and tracks them showing exact date and time student checked in.
Do I have to change the QR code daily? I tried using the QR code 2-3 times today and it said my attendance was already submitted.
allow multiple responses should fix that
@@MrsPTarleton I'd like to create a new QR code for each class meeting. Will they be able to use a previous QR code to sign in for the current day's attendance?
I verified and any of the previous QR codes can be used to sign in the same form used to generate the codes, if multiple answers are allowed. So there is really no justification to create one new QR code for each class meeting, unless the codes are linked to new forms (one per class meeting) with the requirement of 1 response only per form.
@@cristinaiftode9421 Thank you for checking into that.
I don't understand how this helps with attendance. It seems that with this system I will have a spreadsheet telling me who came to class at what time. But I need to know who did not come to class. So next I would have to check this spreadsheet against a full list of students to determine who did not come. Hence, I believe it would be simpler and faster simply to call roll and mark the absent students as I go. Is there something I have missed about this? If not, does anyone know of an app where I can enter the full class list, and then use a QR code in a similar way as described here, but whereby I can see who did not attend? Thanks in advance.
@daniel for me I sort students by name and period, so it's a quick glance down my roster to see who is missing. You've got me thinking of ways to get the absent students highlighted. I've got some ideas I'll need to try. Thank you for the feedback.
@daniel I've looked into this and the easiest way to do what you are asking is with a VLOOKUP it will be time consuming to set up for 180+ days of school but you'd be able to use it year after year.
Can i use this for everyday attendance or i should create everyday?
You can use it daily as there is a time stamp for each entry. You may want to make a separate one for each week or month depending on the size of your classes and label them with the date range to easily organize.
I tried it but It didn´t save a google sheets spread sheet, does anyone know why?
Under responses click the green icon (sheets) top right to create spreadsheet for data gathered. Hope that answered your question. If I misunderstood let me know and I'll definitely try to help figure it out.
How to include time in and time out?
Time in is listed on the spreadsheet on the far left. To get time out you'd have to enter a separate question for them to also sign out.