Do you have that one student who always has to go to the restroom? Do you often catch yourself wondering if they eat a diet high in fiber or if they are just practicing good old task avoidance? You are often thinking, “How can I log all of my students’ restroom trips efficiently?”
There is a way by making a…
1. Begin by signing into your Gmail account. If you don’t have Gmail you can sign up here.
2. Once you are signed in, look at the top right corner of your screen. You will see a box that looks like a grid. Click the grid for a drop down menu.
3. Click the Forms icon. If you don’t see it you may have to click More at the bottom to give you access to more icons.
4. Now you will have a choice of what type of form to create. You will want to click Blank for this project.
5. Give your form a name, in my case Restroom Pass, and a form description if you would like. I added Mrs. Mayville’s 2nd grade for my form description.
6. Now decide on what type of question or response information you want gathered from your students. I wanted my students to begin by adding their name. For the Untitled question I typed Type your name. In the drop down box on the right I chose “short answer”. Now my students will have their name and a time-stamp logged into an Excel spreadsheet (more on that in a bit) each time they use the digital restroom pass.
7. I decided I also wanted a log of what particular subject the student was in so that I could look for trends in the data and have valid evidence to support my concerns. I clicked the plus sign and added a “new question” and added my multiple choice answers below it. Make sure and toggle on the button that says Required at the bottom.
8. If you would like to change the background color of the form click the paint palate at the top right corner of your screen. You have the option of changing colors or using any of the images available.
Click the gear icon to personalize a message on the confirmation page. Hit save at the bottom when you are done with your personalized message.
7. Click the eye icon at the top right corner for a preview of your newly created Form.
Now about that Excel spreadsheet and accessing all this useful data…
Click the Responses tab and then the green Excel icon. It will then want you to select a response destination. It sets it up for you so all you have to do is hit create. Yes, it is that easy! When you need to generate and print a new spreadsheet all you have to do is click the icon with three descending dots.
Now I can have all my data in one place and have all the information I need with the click of a button. It can be done on any device that has access to your Gmail account. I plan to use our classroom iPad and an easy to scan QR code for manageable student access. Make sure you tune back in to my next blog post on QR codes.
Thanks for dropping by!