Multiple Choice Quiz Maker with Google Sheets

TV - December 20, 2022

As a teacher, finding effective and efficient ways to assess student understanding can be a challenge. That's where the BrainSTEM Quizzes Google Sheets add-on comes in. With just a few clicks, this powerful tool allows you to make customized, multiple choice quizzes for your students, all within the familiar interface of Google Sheets.

There's no need to sign up to a new service or website. Everything can be done with your already existing Google and Gmail account.

In this post, we'll take a closer look at the features and benefits of BrainSTEM Quizzes and how it can help you save time and enhance your teaching practice.

The Interface

If you are familiar with Google Sheets, it is a great tool for storing data. BrainSTEM Quizzes uses the spreadsheet format to store all the questions, format, images, and equations necessary for making numerous versions of a quiz with automated answer keys.

Here is the main "controls" of the add-on where you can choose to edit a quiz or publish it:

Clicking "quiz editor" will show a pop up that allows you to create questions for your quiz and then save them to your spreadsheet.

Here you can select multiple choice and add up to 6 multiple choice options for the question. You can also set the number of points for each question. Clicking one of the radio buttons will indicate that choice as the correct answer.

Multiple Choice for Google Forms and for Google Docs

If you need a multiple choice quiz to be printed out OR to be taken from Google Forms, BrainSTEM Quizzes allows you to automatically produce multiple versions of the quiz. The questions will be taken from your "question bank" that you store within your Google Sheet.

Here is what a quiz would look like generated in Google Docs:

And here is what a quiz would look like in Google Forms:

The core features of this add-on include:

  • Writing math equations in multiple choice options and question prompts
  • Publishing quizzes to Google Forms w/ answer key for Google Classroom
  • Publishing quizzes to printable Google Docs w/ answer key
  • Publishing different quiz versions
  • Randomizing questions
  • Randomizing multiple choice options

The BrainSTEM Quizzes Google Sheets add-on is a must-have for any educator looking to save time and enhance their teaching practice. If you're interested in trying it for free, be sure to install it from the Google Workspace Marketplace to get started. Happy quizzing!