Search results
- Recently Google announced that they added several methods to Google Apps Script Forms service to make it able to handle Google Forms quizzes programmatically. Thanks to this, now it's possible to use Google Apps Script to create quizzes from a Google Sheets question bank.
stackoverflow.com/questions/39435580/creating-a-multiple-choice-quiz-from-google-formsCreating a Multiple choice quiz from google forms - Stack ...
People also ask
How do I create a Google Form quiz?
How to create a question bank in Google Forms?
How do I import questions from Google Sheets to Google Forms?
How can I create dynamic quizzes in Google Forms?
This video shows how to set up a multiple choice quiz in a Google sheet, and then run an app script to create a new quiz in Google Forms.
- 10 min
- 37.9K
- Roger Burrows
- Google Sheets
- Look Up Formula
- Paste Formula
- Generic Google Form
- Pre-Filled URL
- Hyperlink in Spreadsheet
- =Hyperlink
- “&&”
- In Between The &&
- Copy The Formula
Go to Google Drive and create a new Google Spreadsheet. You will need 2 tabs. One tab to link to the quiz you create and one for the list of questions. Double click on the tabs to rename them. I named my tabs “quiz” and “questions.” This works for free response questions only. On the “questions” tab you will need to have a column for the question n...
To keep this simple we will ask the spreadsheet to choose a random question from your list of questions for each question. This will allow for the same question to be asked twice. A more complicated formula can solve this, but for the purposes of this tutorial we will not worry about that. On the “quiz” tab, create a column for the quiz hyperlink a...
You want this exact formula in all of the cells that will be choosing a random question. To obtain multiple versions of the quiz you will want to repeat this for multiple rows.
Create a generic Google Form to use as the quiz. For the first few questions ask the students name and other student information you need. For each question create TWO paragraph text boxes.
In the Form edit screen use the “Responses” menu to choose “Get pre-filled URL.” Choosing “Get pre-filled URL” will open up a screen that looks like the live form. This screen allows you to fill out the parts of the form you want to pre-fill. In the question boxes type in capital letters “QUESTIONONE”, “QUESTIONTWO”, “QUESTIONTHREE”, etc… Press the...
Back in the spreadsheet on the “quiz” tab you will want to modify the URL to grab the questions from the spreadsheet. In the hyperlink column next to the random quiz questions type the formula
Replace the pre-filled URL in the above formula with the URL you obtained from the Google Form. The URL does need to be in quotations. The “Click Here”, which also needs to be in quotations, can be any text you would like to be displayed in the spreadsheet.
The key to creating a pre-filled URL from a spreadsheet is quotation ampersand ampersand quotation. Go through the pre-filled URL and replace all of the “QUESTIONONE”, “QUESTIONTWO” etc… with “&&”
In between the ampersands you will want to write the name of the cell that contains that question. For example “&B2&” is where I will find question 1 and “&C2&” is where I will find question 2.
Copy the hyperlink formula down the column. This will give you multiple URL’s that each link to a unique quiz.
By following these steps, users can efficiently import questions from their Google Sheets question bank in Google Forms using the Form Builder add-on, saving time and ensuring a seamless transition from spreadsheet to form.
Jul 26, 2022 · FormMaker Question Bank allows you to create new forms in seconds (including self marking quizzes) using questions from a question bank you maintain in a Google Sheet. As well as using it to...
Create an answer key. To add a question, click Add question. Fill out your question and answers. In the bottom left of the question, click Answer key. Choose the answer or answers that are...
In this video, I have shown how to create Google Form Quiz from Google Sheets. Form Builder for Sheet is Add-on which helps you to build Google Form in a very simple and fast way by...
- 18 min
- 3.7K
- CS CORNER Sunita Rai
Create a quiz. Tip: The quickest way to create a quiz is to go to g.co/createaquiz . Open a form in Google Forms. At the top of the form, click Settings. Turn on Make this a quiz. Optional:...
