Wednesday, June 3, 2015

Organizing Descriptive Feedback with Google Forms

This week I am hosting some guest bloggers. This is a guest post from Kim Pollishuke.

Providing quality descriptive feedback is a significant part of day-to-day assessment practice. It was only a few years ago when I wrote these comments by hand. When report card time came around, it was difficult to generate comments that reflected student improvement and achievement because once I handed back their work, I no longer had access to previously generated feedback.

Later, I began to type my feedback and print off copies for my students. This gave me a soft copy but I found it tedious jumping from one word document to another to find the right information for a report card comment.

This year I found the solution!

By creating a Google Form to record students’ descriptive feedback for each subject, every single comment is in one spreadsheet and I can simply sort the sheet or filter it by name to see only one child’s feedback. This is unbelievably helpful when generating strengths and next steps for report card comments.

This is a sample of a Google Form I fill out each time I give my students descriptive feedback in reading. I type comments in their assignment and then quickly copy and paste them into this form.

The data collected in the Google Form automatically filters into a Google Spreadsheet.
Click image to view full size.

NOTE: I do not give students a level each time I provide them with descriptive feedback but sometimes I appreciate seeing the level in my own notes for formative assessment purposes. I intentionally select the checkbox question type so that I can select more than one level to show a range of ability.

As I prepare to write my report cards, I simply sort the spreadsheet so all the feedback for each student is grouped together.

For step-by-step instructions, visit How To Organize Descriptive Feedback with Google Forms.

In this document, I also explain how you can filter the spreadsheet to only see one child’s feedback. This is ideal for parent-teacher conferences.

Below is a screencast that shows the process I go through using Google Forms to organize my students’ descriptive feedback.

TIP from the screencast: Go to the Chrome Store and add the Tab Resize and Tab Glue extensions. One click evenly splits your screen so you can copy comments and paste them into your forms easily. One more click puts the tabs back together. I love these extensions and my students love them too!

With a Google Form for each subject, you’ll still be visiting multiple spreadsheets though. You can make your life even easier by linking all the forms to different tabs in the same spreadsheet. Visit How to Link Descriptive Feedback Forms to One Master Spreadsheet for step-by-step instructions or you can watch the screencast below.

If you’d like a head start, visit Links to Make a Copy of Google Forms for Descriptive Feedback. Click on the links and you’ll be prompted to make a copy of the spreadsheet. Change the name of the spreadsheet. In the Form drop down menu, click on Edit form and you’ll have access to the Google Form. Adapt it as needed.

Before you know it, all of your descriptive feedback will be at your fingertips!

As an elementary teacher for the past 12 years in the York Region District School Board, Kim has found that using a wide range of technology has proven to be an exciting tool when working with all learners. She is a Certified Google Educator and an Authorized Google Education Trainer. She has led numerous workshops on the integration of GAFE, most recently at EdTech Team’s Ontario Summit featuring Google Apps for Education. She sincerely believes that the purposeful integration of technology is the key to increased student engagement and improved student achievement. Along with Trevor Krikst and Wahid Khan, Kim publishes the EdTech blog, an online hub exploring the vast potential in the nexus where technology and education converge. She can be reached at, @KimPollishuke and +KimPollishuke.