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.
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 Nishan. That is really what my script does. The sheet starts with correct answers in column B, and incorrect distractors in C, D, E, and F. For each of the 50 MCQs, the script random shuffles the 5 options. It remembers where the correct answer landed, and marks the answer key in the form to match. Is there more to your comment? Regards Roger
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!
Hi Andrea, my script is meant to be simple, but that limits how flexible it can be. 1. As shown, it is limited to 5 options: 1 correct and 4 distractors. If you want some questions with 1 correct and 3 distractors, you could make another sheet with that format, and then edit a copy of my script to output a 4-option form. If you want a mix of 4 and 5-option MC questions, that's yet another challenge to face. Sorry not to be any help on those enhancements. 2. The script shuffles the 5 options for each question already. I'm not clear on what you are asking. Regards, Roger
@@rogerburrows7679 how to change script for question in column A, 4 option (one option with correct answer) in column B, C, D,E and again correct answer in column F. Thanks for sharing your great script ever i found in google.
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
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!
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.
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.
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")
Hi James, I started with a too simple method to populate columns C thru F with "distractors". The simple "index" formula allowed duplicates, and then those 4 formulas were clumsy de-duplicators. It is much better to put this formula in C1: =transpose(sortn(filter($B$1:$B$50,$B$1:$B$50B1),4,, randarray(49,1),false)) and then fill column C down with that through C50. Then, C thru F will have nice unique values for distractors, and just forget those messy formulas. Regards. Roger
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
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).
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!
I apologize that the video is hard to follow. To make the point that the whole process can be done in under 10 minutes, I had to really rush through the steps. To get more out of the video, you can follow along in the step-by-step instructions which are linked above in the Description.
![[BAEMON NEWS 7] NEW ALBUM COMING IN](http://i.ytimg.com/vi/wtVeAPimOyo/mqdefault.jpg)
Best video I could find so far. Thank you.
Thank you from Malaysia. Pick up a big useful time-saving tip.
Brilliant! Thank you.
Great video. For creating the sheet you might also be able to use google sheet macros.
Thanks a million, man. I should learn coding.
many many thanks. This is what i've been looking for.
Very Very Helpfulllllllll !!!! Tx from Brazil!
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.
Well explained, well documented, and thus easy to customize. Thank you!
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))
tks Bro from Vietnam.
Thank you, this really helped me approve of my students
This is soooo helpful!!! Please do keep uploading such great algorithms.
This works incredible! thank you so much
Is it possible to include an image with a question and have it included in the resulting Google Form?
Thank You😊
Hi i got one error inline 11. Cannot call method "getDataRange" of null. Can your rectify it.
HOW TO CLEAR THE ERROR
same problem... how can we solve it?
Amazing. Thanks. Instead of multiple choice, if we have to pick the short answers, how do we do? Can you pl guide? Thanks.
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 Nishan. That is really what my script does. The sheet starts with correct answers in column B, and incorrect distractors in C, D, E, and F. For each of the 50 MCQs, the script random shuffles the 5 options. It remembers where the correct answer landed, and marks the answer key in the form to match. Is there more to your comment? Regards Roger
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!
Hi Andrea, my script is meant to be simple, but that limits how flexible it can be.
1. As shown, it is limited to 5 options: 1 correct and 4 distractors. If you want some questions with 1 correct and 3 distractors, you could make another sheet with that format, and then edit a copy of my script to output a 4-option form. If you want a mix of 4 and 5-option MC questions, that's yet another challenge to face. Sorry not to be any help on those enhancements.
2. The script shuffles the 5 options for each question already. I'm not clear on what you are asking. Regards, Roger
@@rogerburrows7679 how to change script for question in column A, 4 option (one option with correct answer) in column B, C, D,E and again correct answer in column F. Thanks for sharing your great script ever i found in google.
Thanks, really you saved my lot of time.
Good work!!
VERY HELPFUL
Excellent Job in the meaning of "Just make it (fast and) simple" :-) Thanks a lot, Bro'
Simply marvelous
Excellent work. Thanks lot
Thank you sir, worked for me.
Please Sir can we have Google App Scripts popForm for four options. If possible
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
Sorry, I ended the project and no plans for enhancements. Regards Roger
This works but how can we set all questions to required automatically without going through each question?
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!
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.
Sorry, I ended the project and no plans for enhancements. Regards Roger
Thanks. Very useful!
Excellent
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.
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")
Hi James, I started with a too simple method to populate columns C thru F with "distractors". The simple "index" formula allowed duplicates, and then those 4 formulas were clumsy de-duplicators.
It is much better to put this formula in C1:
=transpose(sortn(filter($B$1:$B$50,$B$1:$B$50B1),4,, randarray(49,1),false))
and then fill column C down with that through C50. Then, C thru F will have nice unique values for distractors, and just forget those messy formulas. Regards. Roger
how about fill the blank?
Thank you
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
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).
Sorry, I ended the project and no plans for enhancements. Regards Roger
I can not creat the form with over 50 fieldd without money..so sad
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!
Sorry, I ended the project and no plans for enhancements. Regards Roger
Are you available for hire to take existing data to author a test?
🥰🥰🥰🥰🥰🥰🥰
Good job.
I apologize that the video is hard to follow. To make the point that the whole process can be done in under 10 minutes, I had to really rush through the steps. To get more out of the video, you can follow along in the step-by-step instructions which are linked above in the Description.
excellent works, very useful. how to write out 10 of 50 questions only ? Thank you
Thanks for the vid! Would appreciate if ya have time to add in this if possible (10 random questions from a question bank)
6:30 - Adding the appscript