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

Create online quizzes the easy way

Want to create an online, self-marking, multiple choice quiz the easy way? Here is how using Google Forms and the amazing Google Form Builder for Sheets add-on from Jivrus Technologies.

Faced with the sudden promotion to online education specialist as many educators were in the Coronavirus pandemic, I started to look for ways to quickly convert existing material into digital artifacts. One of my ideas was to convert all the multiple-choice questions from existing assessments in Microsoft Word format into self-marking Google Form Quizzes that the learners could use to test themselves while they studied their theory.

Creating the Google Form by copy-pasting is tedious and requires you to work in an unfamiliar environment. Doing the conversion in familiar tools made far more sense.

The initial set-up puts may off doing this, but trust me when I tell you once the initial set-up is complete you will thank yourself!

What do you need:

  • Chrome Browser
  • a Gmail account

Here is the process – click on each step for more information:

  1. Install the Google Form Builder for Sheets add-on from Jivrus Technologies
  2. Create the Excel template and “convert” it to a Google Sheet
  3. Import the questions into the Google Form from the Google Sheet template using the add-on
  4. Use the template to copy-paste and convert questions from existing assessment tools into quizzes

The process seems to be total over-kill the first time you do it, however once you have the first one done the second is far simpler and you will start to see the reward.

The plus side of this approach is:

  • You likely have existing Excel skills which make it easy to copy the data from existing documents (Microsoft Word, PDF or other) and manipulate it into the standard template
  • You can build up a massive database of multiple choice questions and easily mix and match them to create more quizzes
  • You can easily collaborate with other people, swapping questions that are in a standard format for easy import
  • You can easily collaborate with people less confident in their technical ability by having them complete the Excel part and you do the majick import part.

Here is the link to the official User Guide.

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