Many schools are likely reviewing their dismissal plans for next year ensuring they comply with social distancing guidelines. I’ve been thinking a lot about how our existing communication tools can help ensure a safe and efficient process for all students and families.
This approach uses Google Forms and Google Sheets seamlessly linked with some Apps Script to digitize a scalable and flexible workflow. The process begins at the car line. Each student is assigned a pin number, preferably visible from outside the car. Dismissal staff equipped with smart phones or other mobile device submits the pin number into a Google Form. The data is timestamped and logged in a Google Sheet, and further distributed to class specific sheets. Assuming students will be called from their classroom, the teacher or staff member supervising the students could be monitoring their class specific Google Sheet. Once the student’s name appears in the Google Sheet, they will know to send them down. The Google Sheets can be automatically cleared each night to be ready for the next day and there is little need for use of walkie-talkies or PA system.
This add-on is available for purchase as a Google Sheets add-on.
Hi, How did you get the information to populate into the Google sheet (i.e. other info besides their PIN number?). It appears to populate the name in addition to the PIN number. Is that some type of code or formula? Thanks!
Yes, there’s another sheet containing all of the data. A formula looks up the rest of the data based on the pin number submission.
Could you share the formula that you used to assign the number to populate with the students name?