Attendance Tracker // Automated Attendance Tracker using Google Form and QR Code 2022

Рет қаралды 58,647

Күн бұрын

If you would like to help support my channel please buy me a tea. I truly appreciate you. Thank you!
🍵 buymeacoffee.com/mahalo
* 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

Пікірлер: 52

@lisandrariveraramos5889 9 ай бұрын

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!!!! :)

@MrsPTarleton 9 ай бұрын

@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.

@brayan8346 6 ай бұрын

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.

@MrsPTarleton 5 ай бұрын

@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.

@SanjayKapoorDelhi 8 ай бұрын

Brilliant!! Thank you

@MrsPTarleton 8 ай бұрын

@Sanjay Thank you. So glad you enjoyed.

@oceanphang7494 2 жыл бұрын

thank you so much.. you have made my difficult stuff become easy

@MrsPTarleton 2 жыл бұрын

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?

@muhdfurqan7157 11 ай бұрын

Thanks a lot, this is super helpful,

@MrsPTarleton 11 ай бұрын

You are so welcome. I'm so glad I could help.

@Niknou11 Жыл бұрын

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 >

@MrsPTarleton Жыл бұрын

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?

@AvelaDudula 2 ай бұрын

thank you, this is very helpful

@MrsPTarleton 2 ай бұрын

@AvelaDudula Thank you for watching and commenting. Put a smile on my face. Glad it's helpful.

@lisadunni8892 Жыл бұрын

tqvm.

@MrsPTarleton Жыл бұрын

@lisadunni8892 you are welcome, glad I could help.

@jenniferlewis3895 11 ай бұрын

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.

@MrsPTarleton 11 ай бұрын

@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.

@cristinaiftode9421 10 ай бұрын

@@MrsPTarleton Sharing QR images with absent students concerns me too. Hopefully, not too many present students are helping their pals cheat like this.

@KristofferFrey Жыл бұрын

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🙏

@MrsPTarleton Жыл бұрын

@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.

@PescesKitchen 11 ай бұрын

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

@PescesKitchen 11 ай бұрын

@@MrsPTarletonhow do you do this?

@MrsPTarleton 11 ай бұрын

@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.

@mohamedali-tx4sb Жыл бұрын

Please tell me if I setup in mobile fake gps program This form will read which location ?

@MrsPTarleton Жыл бұрын

@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.

@candicefreedman1249 Жыл бұрын

Also, if I'm already using GSheets for our existing rosters can I use those instead of creating a new form?

@MrsPTarleton Жыл бұрын

Yes, when you create your sheet you can choose to gather data in new sheet or existing sheet.

@PescesKitchen 11 ай бұрын

What about tracking students that aren’t in class? How do you go about that. I have 43 kids per class.

@MrsPTarleton 11 ай бұрын

@PescesKitchen You can do a Vlookup which would probably be the best way to mark absent students.

@ariahkali7392 11 ай бұрын

Does this work even if for example we do not have internet connection for that specific day?

@MrsPTarleton 11 ай бұрын

@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.

@candicefreedman1249 Жыл бұрын

Is there a way for the teachers to have the QR code on their mobile device as well as printed out in the classroom?

@MrsPTarleton Жыл бұрын

Yes, you could easily have a screenshot of QR code on your mobile device.

@thefandomrealm 11 ай бұрын

So you just log the entire year of attendance in the same sheet.?

@MrsPTarleton 11 ай бұрын

@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.

@user-rp3jk3pv5b Жыл бұрын

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.

@MrsPTarleton Жыл бұрын

allow multiple responses should fix that

@cristinaiftode9421 10 ай бұрын

@@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?

@cristinaiftode9421 10 ай бұрын

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.

@MrsPTarleton 10 ай бұрын

@@cristinaiftode9421 Thank you for checking into that.

@danielducken2843 11 ай бұрын

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.

@MrsPTarleton 11 ай бұрын

@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.

@MrsPTarleton 11 ай бұрын

@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.

@alexaraya2018 10 ай бұрын

I tried it but It didn´t save a google sheets spread sheet, does anyone know why?

@MrsPTarleton 10 ай бұрын

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.

@katgillang 9 ай бұрын

Do you create a new form every day? Then is there a new QR for each one?

@MrsPTarleton 9 ай бұрын

@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.

@dons0308 5 ай бұрын

How to include time in and time out?

@MrsPTarleton 5 ай бұрын

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.

@dons0308 5 ай бұрын

Can i use this for everyday attendance or i should create everyday?

@MrsPTarleton 5 ай бұрын

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.