Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

5 Steps to do When Using Google Forms for Formative Assessment

Google Forms Quiz

5 Steps to do When Using Google Forms for Formative Assessment

Google Forms Quiz

5 Steps to Creating Using Google Forms for Formative Assessment

Before providing students with the Google Forms quiz, try these 5 tips to make the process easier. Formative assessment should allow you to quickly respond and change your instruction based on the results. Setting up the Google Form and spreadsheet in advance of students taking the assessment helps you be ready respond quickly.

1. Create the Google Forms Quiz

Create a Google Form with your formative assessment questions for your Google Forms quiz.

2. Create the Spreadsheet

While you’re in the edit screen of the Google Form create the spreadsheet for student responses to go to. Click on the “Responses” tab on the edit screen and click on the green spreadsheet icon.
create a spreadsheet in Google forms

3. Take the Formative Assessment

BEFORE the students fill out the Google Form, take the formative assessment yourself. For “name” put in “Answer Key.” This puts the answer key as row 2 of the spreadsheet.
click on eyeball to fill out the form.

4. Freeze the Answer Key

In the spreadsheet, row 2 is now the answer key. Move the freeze bar to freeze the first 2 rows instead of only the first row. This allows you to scroll through student responses and compare it to the answer key.
Freeze the answer key

Grab Freeze Bar

The freeze bar is located between the rows. In the spreadsheet from a Google Form it is defaulted to freeze the first row. You can find the freeze bar by hovering in between the 1st and 2nd row. The arrow should change to a hand. Click and hold down, dragging the freeze bar down one row. 
grab freeze bar

5. Set Conditional Formatting

Conditional formatting automatically color codes your cells based on the data in the cell. You can set up conditional formatting BEFORE the students take the formative assessment quiz.

Click on the column indicator for a question to highlight the entire column. A dropdown arrow will appear in the column indicator (or you can right click). Choose “Conditional formatting.”
google sheets conditional formatting in the menu

Check that the range covers the entire column.
google sheets format the cells conditional formatting

Under “Format cells if…” choose “Text is exactly.” Row 2 contains the answer for that question. Enter the answer in the box underneath the “Format cells if…” Choose your color you want to format the cells with by clicking on the paint can.
format the cell

Wrong Answers

Optionally, you can click on “Add another rule” to format the wrong answers. I usually choose red. I suggest you do each wrong answer a different shade of red so you can see the prevalence of each wrong answer.

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

3 thoughts on “5 Steps to do When Using Google Forms for Formative Assessment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.