Got the Homework Blues?

It’s time for Back to School organization! One thing I absolutely hate doing is collecting homework. See my earlier post here: No HW assignments for 2016? Can it be done? Assuming you assign homework, what should be done with it? Collect, Grade, Every day? The paper piles up!

If your bag is stuffed with student work, you may want to check out BerryWing’s Scan to Spreadsheet smart phone app which sells for a few dollars. This could be your new workflow:

Walk around the class, verify assignment completion.

With your phone, scan a QR code taped to each student’s notebook to record credit.

Email the created excel spreadsheet to your work account.

To easily create the unique, student QR codes, go to the BerryWing.com and type each name into the QR code generator.

After each QR code is created, it can be copied (screenshot) into Word and printed for distribution to each student. Students can tape the code onto their notebooks. My example class has only 2 students.

Next, using your phone, set up your spreadsheet. My example covers assignments for three days in September. With September 5 checked, I am now ready to record that day’s homework compliance.

Now your ready to walk around the your classroom and scan the QR codes of students who completed the assignment. The app will make a pleasant noise verifying the data is collected. (If you are recording who didn’t do the assignment, you might want to turn the sound off!) When your done, email the Excel spreadsheet (XML file) to your work account or send it to cloud storage.

[…] Use your phone to record who did the homework. Don’t collect all that paper if you only have time to verify who completed the assignment. See our post on a scan to spreadsheet solution. Got the Homework Blues? […]

I have the link all set to distribute to conference attendees! One thing I’m struggling with in the app is….How to label the spreadsheet by date or assignment to retrieve so I can scan missing or absent students when they hand in the work. Do you have any insight? Many thanks!

I have never used comments. You might be able to give student 2 QR stickers (JaneDoe_fullcredit, JaneDoe_partial), and scan the first one for full credit and the second one for reduced credit. You would probably want to print them in different colors.

For $2.99, this is so worth a try. I love it. I was thinking of putting all their QR codes on a page based on class. I can walk around with a clip board with the QR and scan who has it or maybe who doesn’t. Thank you!

Thank you for recommending Scan to Spreadsheet.
We have updated the app with new features. Also the barcode generator on our web site has vastly improved.
Please email us anytime if you need any technical support.

I’m not having any luck generating different barcodes for each student in Google Sheets. I’ve spend hours trying to follow the video tutorial from Berry Wing, but it will only generate the same bar code. My engineer-husband who works with spreadsheets every day can’t figure it out either. Do you have any suggestions?

Don’t copy and paste. copy and drag it down. Check that the part of the code that says A1 matches the row you are in… if you copied A1 for each student ti will use the same data for each QR code/Barcode

Select + start a new spreadsheet. Highlight the default template and then select the arrow at the top of the page (right). You should see rows A through T. Click on the letter to change the heading. Hope that helps!

I really would like to use this idea as it would simplify my home documentation procedure. I am having troubles in trying to connect the qr code to a spreadsheet. I attempted to follow the video that Berry Wing has but because it has no written directions, it is hard for me to complete the task. I am learning how late in life lol. Would you be willing to email instructions to set up the spreadsheet? It would truly help. Thanks