Digital Hall Pass
So one of my biggest issues I have is keeping track of students coming/going from class. This isn't really a problem during the lecture, but after the lecture students leave to use the bathroom or go to their locker. I have been trying for years to come up with a good way to keep track of when they leave and how long. I tried the classic QR code, but found it took too long for students to scan in the code and click in the information. Plus the fear was, what if they changed the name or something else.
I decided that I could track who leaves from my computer with 3 clicks, no typing. And mark when they return with one click. This is all done through a Google Sheets I made.
Once you make a copy, follow the video on how to set it up and get your attendance/hall pass up and running. All you need to do is import you student rosters, modify reasons for students coming/going, and approve the script. Don't worry about that last one I will walk you through it.
There are also some step by step instructions down below after the video.
As you will see in the video, the best part about the Sheet is that you can search up any student you have and be able to see all the times the student has left your class, why they left, and the total number of minutes they have missed your class.
Please go to Teacher Pay Teachers, HERE, to get your copy. This is a one time purchase, then you are set forever.
Please contact me kwendland@wvusd.org if you have any questions.
Roster Tab
First tab to edit is your roster tab. All you will need to do is paste in your roster from Aeries. If you do not have a period, go ahead and delete the period in the top row. For the Sheet to work, you need to have the top row named with words. If you change them to numbers the Sheet won't work.
Reasons
The Reasons tab is next. On this tab go ahead and list all the reasons your students leave the class. You can always type in a reason, but the list is there to help speed up the process of checking students in & out. Remember anything you add will automatically be added to your list of reasons on the main Pass tab.
Run Script
To make the Sheet work, you will need to run the script. It isn't difficult and should take a few seconds.
First go to Tools -> Script Editor
The script code for the Sheet will open up. Don't worry about the code, you don't have to type anything in.
All you need to do is press the Play button. It will ask you which account will be using the script and that's it.
