Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Forms: Alternating Colors for Response Answers

alternate colors
Google Forms: Alternating Colors for Response Answers

alternate colors

Alternate the Colors on the Spreadsheet of Responses

The answer is always a spreadsheet I like to say! One of my favorite things about Google Forms is it goes to a spreadsheet. Click on the Responses tab in the Google Form to click on the green Sheets icon to create the spreadsheet.
create a spreadsheet

Click the Eyeball

I suggest after you create a Google Form for formative assessment that the first thing you do is fill out the Form with the answer key. BEFORE students take it! This ensures that line 2 of the spreadsheet is the answer key.
eyeball icon to fill out the form

Format Menu

Click on the spreadsheet icon in the Google Form to launch the spreadsheet of responses. Go to the Format menu and choose “Alternating colors.”
alternating colors

A side panel comes up to allow you to choose the color you want to alternate.
alternate colors in the side panel

Super easy! Every other row is highlighted a different color.
alternating colors!

© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Mar 21st or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session as we learn how to revolutionize your assessment strategies. We will dive into the essentials of crafting high-quality rubrics that go beyond traditional scoring methods to offer rich, meaningful feedback. We’ll learn about the components of an effective rubric and how to mathematically ensure the accuracy of your assessments.

Exit this pop up by pressing escape or clicking anywhere off the pop up.