I’m coming up to my last full week before heading back to the classroom for a week of professional development. With so many ideas curated this summer through my online PLN, I am trying to get a few implemented this next week. Two recent Technology Tuesday Tools posts have been in regards to QR codes and Google tools; here I will show you how I combined the two for our homework check-in procedures.
Math homework is not graded by me, in our class. Students are responsible for checking all answers and continuing to work on corrections if mistakes were made. However, I still track homework completion in our online grading book. This helps when it comes to conversations with students and parents regarding success in the class; homework and practice is usually a big indicator of how they will be performing on their assessments.
Students will have a QR code that is permanently attached to their desk for the school year. They will scan this each day, following an assignment. It will take them to this Google Form, where they select Yes, No, or Other on the completion of homework. Based on their selection, it will take them to one of three different pages before they are finished and hit the submit button. Go ahead and test out the three options!
Then, comes the fun part in the Google Spreadsheet. You can click here to see the test data I entered (left columns E and F blank). Each column has a filter on it, so I can instantly filter down to just one name, a specific date, a certain class period, or just those who selected ‘No, HW is not complete’. Plus, any combination of those. The ones I will use the most are the filter by period w/date and also filter down to just who didn’t complete homework.
Click on the tab titled ‘Pivot Table 1‘, at the bottom of the spreadsheet, and you will see a nice summary broken down by student. The options for filtering and reporting here are also endless! I can instantly see the number of times students have completed HW, not finished HW, or worked on another task.
Did you see all the nice colors on the main tab of the spreadsheet? That is my favorite Google Form feature! Using the conditional formatting, under the Format Menu, you can customize how any kind of information is automatically shown as it gets submitted. I use this in the classroom to identify within seconds how many of the 30 students finished their homework or not. Green is good, red is not so good, and blue gets my follow up attention later to see what other activities they are working on.
Done! I can check one more thing off my to-do list, as this check-in form is good for the entire year. I will be able to make any changes/adjustments to the form throughout the year and not have to change the QR code label on student desks. That’s what I love about QR codes, they direct you to a permanent link, but many times you can change what that same link shows the students. A perfect way to save resources and printing.