Create a Google Forms quiz from Google Sheets in less than 10 minutes! 

Best video I could find so far. Thank you.

Thank you sir, worked for me. Please Sir can we have Google App Scripts popForm for four options. If possible

Wow. Awesome video demonstrating some techniques which are extremely helpful, but I knew nothing about! Is it possible to randomize the order of the questions -- AND randomize the order of the answers within the questions? If students retake this quiz, it would be nice if they didn't just rote memorize the questions and answers in order. Also, would it be possible to create a script / app for a quiz spreadsheet of, let's say, 50 questions, but that when the students take the quiz, only 10 of the questions are selected randomly from the spreadsheet data? This way, students would be asked different random questions each time they took the test and wouldn't have to retake all the 100 questions. This would be very helpful in learning paradigms from languages, e.g. Latin, where students need to practice the endings of verbs and nouns -- so that they don't just "memorize" the same words but really know how to add the various endings. Superb!

Amazing. Thanks. Instead of multiple choice, if we have to pick the short answers, how do we do? Can you pl guide? Thanks.

🥰🥰🥰🥰🥰🥰🥰

Brilliant! Thank you.

tks Bro from Vietnam.

Very Very Helpfulllllllll !!!! Tx from Brazil!

For anyone having trouble getting the formula to work for the distractors, if the Google sheet locale uses semicolons, as it does for France, you need to replace the commas with semicolons. Here's the semicolon version: =transpose(sortn(filter($B$1:$B$50;$B$1:$B$50B2);4;; randarray(49;1);false))

Hi i got one error inline 11. Cannot call method "getDataRange" of null. Can your rectify it.

The Tools> Script Text is not available, can you do an update video on how to do this, or where the Script Text can be found to complete the code. Or can someone help me find it, I've tired many different methods to finding it through the market, app, google. This was a good video, and would like to finish creating my version of this! :) Thank you.

Is it possible to include an image with a question and have it included in the resulting Google Form?

This is excellent. Thanks a lot! I have two quetions, if possible: 1. Is there a way to have some questions with 4 options and others with 5? 2. Is there a way to select the "shuffle option order" on each of the questions? Thanks again for sharing this great work!

VERY HELPFUL

Good work!!

Thank you, this really helped me approve of my students

This works but how can we set all questions to required automatically without going through each question?

I can not creat the form with over 50 fieldd without money..so sad

Great Project! Could you explain what the following formula is for? and why there are 4 cities' name used? Thank you? Formulas: =index($B$1:$b$50,randbetween(1,50)) =if(countif($B1:B1,C1)=0,C1,"Chicago") =if(countif($B1:C1,D1)=0,D1,"Omaha") =if(countif($B1:D1,E1)=0,E1,"Miami") =if(countif($B1:E1,F1)=0,F1,"Dallas")

It didn't work for me. I run the script but it did not create the form except the execution log which I couldn't use as a Form. Anyways, the way you generate the distractors is amazing. It removes the duplicate choices. Thank you very much

Great video. For creating the sheet you might also be able to use google sheet macros.

6:30 - Adding the appscript

HELLO thanks for your great video,i am wondering about create a feedback automaticly to users when they making fault with their answers. for example i could add 6. clomn to form and what writng there get to feedback. thanks for answers

Thanks a million, man. I should learn coding.

Hi is there any appscript code which will set the answer key of a google form MCQs by taking the answer key from google sheet?

Hi there, this is a marvellous project, thank you for sharing with us! Please could you look into writing code for generating feedback as well? This is will very aweseom, thank you!

First I would like to Thank you for the info provided. I have few Queries. My quiz contains chemical reactions. How to add images ? If i give All of the above and None of the Above, While shuffling the answers, options All of the above and none of the above also changed (but it should be the last option).

many many thanks. This is what i've been looking for.

Hi, I would like to know if there is a solution to assing images to the questions and anwser. For example, if I had 100, I would choose only 30 of them with the image of each of question and the images of their choices. I am trying to do it because I need to use images in my questions given that they use Math formulas.

Thank you from Malaysia. Pick up a big useful time-saving tip.

Are you available for hire to take existing data to author a test?

Excellent work. Thanks lot

This works incredible! thank you so much

Thank You😊

Excellent Job in the meaning of "Just make it (fast and) simple" :-) Thanks a lot, Bro'

This is soooo helpful!!! Please do keep uploading such great algorithms.

excellent works, very useful. how to write out 10 of 50 questions only ? Thank you

Well explained, well documented, and thus easy to customize. Thank you!

Thank you

Thanks, really you saved my lot of time.

Excellent

Simply marvelous

Thanks. Very useful!

Thanks! One thing that tripped me up was the code for filtering out duplicates. I wasn't sure why it included city names, but was able to figure it out.

Good job.