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 28th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for a way to create dynamic and interactive digital lessons. The Desmos platform is completely free and allows for any topic to be created or customized.

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