Categories
e-Learning

Using the Google Form Builder for Sheets add-on to create a multiple-choice quiz

This is part of a series of posts aimed at explaining how to create online, self-marking Google Form Quizzes using the Google Form Builder for Sheets add-on to import quiz data from a spreadsheet. The aim is to quickly digitize multiple-choice questions from existing assessment tools, allowing Educators to build a bank of questions easily in spreadsheet format so that collaboration is possible.

Your Google Sheet template is ready and you have created a new, blank Google Form (if you are a Google Suite for Education user then create do this from within Google Classroom by creating a Quiz Task). You have also installed the Google Form Builder for Sheets add-on.

This is part of the series: Want to create an online, self-marking, multiple choice quiz the easy way? Here is how using Google Forms

Categories
e-Learning

Creating an Excel template for the Google Form Builder for Sheets add-on

Creating an Excel template for the Google Form Builder for Sheets add-on from Jivrus Technologies.

Do not change the template in any way until you have done your first test import. The column headings in the first row map automatically to the fields in the Google Form add-on. Simply copy the below two rows and paste them into a worksheet in a new Excel workbook. For this exercise ensure you only have one sheet in the workbook.

Questions Description Type Answer Start Answer 2 Answer 3 Answer End Required Points Correct Answer Correct Feedback Incorrect Feedback
Who wrote “To Kill a Mockingbird”? Select the correct answer from the following list. MULTIPLE CHOICE Miss Maudie Harper Lee Boo Radley Mr Ewell TRUE 1 Harper Lee Well done – Harper Lee is the correct answer! The correct answer is “Harper Lee”. The other options are the names of characters in the book.

The value in the Correct Answer field must be identical to the way it is in the corresponding option – be wary of leading, trailing or any other extra spaces for instance. Remember that if your learners are suing this for revision, a lot of value can be added in the “Incorrect Feedback” field.

Save the workbook and either upload it to your Google Drive and open it and save it as a Google Sheet, or create a new Google Sheet and simply copy-paste the data into the new Google Sheet. I already have the original Word documents in my Google Drive Stream folders so I keep the Excel workbook sync’ed in the same folder with the same name as the assessment from which it originated.

This Excel workbook is vital if you are collaborating with others – more about that later!

This is step 2 of a forthcoming article: Want to create an online, self-marking, multiple choice quiz the easy way? Here is how using Google Forms

Categories
e-Learning

Installing the Google Form Builder for Sheets add-on

Installing the Google Form Builder for Sheets add-on from Jivrus Technologies is pretty straight forward.

This awesome add-on allows you to create a Google Form from a Google Sheet template.

Please remember that if you are working within a Google Suite for Education domain you will likely need Admin access, or the help of the Administrator. You need to be using the Chrome browser.

  1. Click the link to get to Google Form Builder for Sheets
  2. Install the add-on – Domain Install for a Google Suite for Education domain or Individual Install if you are working outside of one
  3. You will most likely need to shut down and restart Chrome entirely to complete the add-on installation
  4. Create a blank, new Google Form
  5. The Add-ons option (puzzle piece icon) appears top left
  6. Click on it and select the Form Builder option, then select Start from the pop-up menu

This is part of the series: Want to create an online, self-marking, multiple choice quiz the easy way? Here is how using Google Forms