Conditional Formatting in Google Sheets to Bring Your Google Forms Data to Life!

by Randy Fairfield, 10/27/17

The summary view in Google Forms is helpful in getting a view of how your whole class did on a forms assessment, and the individual view is nice to check on the specific results for individual results—but it really takes a spreadsheet view to see both whole class and individual results all at once. Getting a spreadsheet from your Google Forms results is quite simple!

Once you’re in the spreadsheet, using conditional formatting in Google Sheets can be a really helpful way to have that data jump out at you and can be useful in helping you guide instruction and differentiate for struggling students! Here’s a visual of some pre-assessment data that Caitlin Smith (@IcedTearex) collected from one of her classes as we went through a coaching cycle together. Pretty cool, huh?

So how does one go about applying conditional formats in Google Sheets? If you click on the area circled in the red below and select conditional formatting, the rest is pretty intuitive! You can set all kinds of formatting rules based on the content of the cells in the column. In the case pictured below, I chose to have the column fill with green when the content of cells in the column were equal to “3”. I could apply additional rules to have the cells fill with yellow when the content of cells was equal to “2” and red when equal to “1”.

With simple tips and tricks like these, you can begin using formative assessments in ways that truly drive your instruction and meet the needs of your students!

Randy Fairfield, MEd and MBA, is a teacher and consultant in the Richland School District in Eastern Washington. He is also a Google for Education Certified Trainer, Edmodo Certified Trainer and Hapara Champion Trainer and Consultant.

Sign up for our bimonthly newsletter to stay up-to-date on training events, online courses, and new blog posts!

Share this post: