Quiz Publisher - A Sheet add-on for teachers to create Google Form quiz from Spreadsheet questions and then publish the quiz as an Assignment in Google Classroom, in seconds.
Listing updated:October 14, 2021
Works with:
10K+
Overview
An add-on to Google Sheets that helps classroom teachers to: 
- create a Google Form quiz or quizzes from a question database
- uses the Google Sheet spreadsheet to store multiple question types and answers 
- supports publish of the generated quiz as a Google Form in a G-Suite for Education Classroom assignment; to multiple classes at a time
Google Form Quiz settings are made once, and then applied to all subsequent generated quizzes.

The tool supports multiple question types (drop down, multiple choice, paragraph and checkboxes) with automatic calculation of question points.
A quiz can be created by selecting specific rows or by choosing one or more named groups of questions from the Spreadsheet data
For publishing, there is automatic calculation of Google Classroom classes that the user teachers, which can be multi selected as the target for quiz publishing as an assignment.
Unlimited numbers of correct or incorrect answers can be created for each question.
Randomisation of answer order (as well as question order.
Correct and incorrect feedback can be added for each Google Form question.
Questions can be set mandatory or optional in the quiz.

To support the teacher, an example question sheet can be generated as frequently as required.
Because the process can be completed in a few seconds, it enables Assessment of Learning, Assessment for Learning, Exit Tickets, Starter Quizzes.
Because the teacher can select specific rows of questions to generate the quiz from, retesting (in real classroom time) is possible based
Because the process leverages GSuite for Education standard tools (Google Sheets, Google Forms, Google Classroom) the process aligns with standard Google Classroom operations:
- Google Classroom Assignments
- Google Form auto marking and score calculation
- Progress strengths and weakness review and retest
- Exporting of results as CSV

Additional information
PricingNot available
Developer
Trader status unspecified
Privacy policy
Terms of service
Quiz Publisher will ask for the permissions shown below. Learn more
Quiz Publisher will need access to your Google account
This will allow Quiz Publisher to :
See, edit, create, and delete all of your Google Drive files
View and manage your forms in Google Drive
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See, edit, create, and permanently delete your Google Classroom classes
Manage course work and grades for students in the Google Classroom classes you teach and view the course work and grades for classes you administer
View the email addresses of people in your classes
Manage your Google Classroom class rosters
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Loading
Search
Clear search
Close search
Google apps
Main menu