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

แชร์
ฝัง
  • เผยแพร่เมื่อ 29 ต.ค. 2024

ความคิดเห็น • 60

  • @IbrohimMirgiyasov
    @IbrohimMirgiyasov 2 หลายเดือนก่อน +1

    Best video I could find so far. Thank you.

  • @tansuathongkpm-guru4141
    @tansuathongkpm-guru4141 3 ปีที่แล้ว

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

  • @surfviewgardens2396
    @surfviewgardens2396 ปีที่แล้ว +1

    Brilliant! Thank you.

  • @PhysicsGaunt
    @PhysicsGaunt 10 หลายเดือนก่อน

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

  • @gersonauguste4376
    @gersonauguste4376 2 ปีที่แล้ว

    Thanks a million, man. I should learn coding.

  • @KeyRetro
    @KeyRetro 3 ปีที่แล้ว

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

  • @edgardocavaco
    @edgardocavaco 4 ปีที่แล้ว +1

    Very Very Helpfulllllllll !!!! Tx from Brazil!

  • @daddyoh399
    @daddyoh399 4 ปีที่แล้ว +2

    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.

  • @surajitm001
    @surajitm001 3 ปีที่แล้ว

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

  • @nickelastic4990
    @nickelastic4990 7 หลายเดือนก่อน

    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))

  • @giodoc8x
    @giodoc8x 2 หลายเดือนก่อน

    tks Bro from Vietnam.

  • @smkmudajatinom5981
    @smkmudajatinom5981 4 ปีที่แล้ว +1

    Thank you, this really helped me approve of my students

  • @sharvarijoshi1547
    @sharvarijoshi1547 3 ปีที่แล้ว

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

  • @renderingrocks
    @renderingrocks 3 ปีที่แล้ว

    This works incredible! thank you so much

  • @randalter
    @randalter 10 หลายเดือนก่อน

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

  • @karunlalp
    @karunlalp ปีที่แล้ว

    Thank You😊

  • @CIVILENGINEERINGOBJECTIVE
    @CIVILENGINEERINGOBJECTIVE 5 ปีที่แล้ว +1

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

    • @arjun007
      @arjun007 4 ปีที่แล้ว +1

      HOW TO CLEAR THE ERROR

    • @olivebcx634
      @olivebcx634 6 หลายเดือนก่อน

      same problem... how can we solve it?

  • @amritag8805
    @amritag8805 3 ปีที่แล้ว +1

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

  • @nishanmostafa
    @nishanmostafa ปีที่แล้ว

    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?

    • @rogerburrows7679
      @rogerburrows7679  ปีที่แล้ว +1

      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

  • @andreac4569
    @andreac4569 ปีที่แล้ว +1

    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!

    • @rogerburrows7679
      @rogerburrows7679  ปีที่แล้ว

      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

    • @dulumok
      @dulumok 2 หลายเดือนก่อน

      @@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.

  • @surajkhawal
    @surajkhawal 4 ปีที่แล้ว

    Thanks, really you saved my lot of time.

  • @door6666
    @door6666 4 ปีที่แล้ว +1

    Good work!!

  • @pmuhammed3258
    @pmuhammed3258 4 ปีที่แล้ว +1

    VERY HELPFUL

  • @pepitoperez8924
    @pepitoperez8924 4 ปีที่แล้ว

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

  • @azonlinevlog4664
    @azonlinevlog4664 4 ปีที่แล้ว

    Simply marvelous

  • @CIVILENGINEERINGOBJECTIVE
    @CIVILENGINEERINGOBJECTIVE 5 ปีที่แล้ว

    Excellent work. Thanks lot

  • @npp9267
    @npp9267 4 ปีที่แล้ว +1

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

  • @gulten6684
    @gulten6684 2 ปีที่แล้ว

    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

    • @rogerburrows7679
      @rogerburrows7679  ปีที่แล้ว

      Sorry, I ended the project and no plans for enhancements. Regards Roger

  • @JeffersonAcaso
    @JeffersonAcaso 3 ปีที่แล้ว

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

  • @jbrondos
    @jbrondos 4 ปีที่แล้ว +2

    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!

  • @dionisioneto255
    @dionisioneto255 2 ปีที่แล้ว

    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.

    • @rogerburrows7679
      @rogerburrows7679  ปีที่แล้ว

      Sorry, I ended the project and no plans for enhancements. Regards Roger

  • @svdm007
    @svdm007 4 ปีที่แล้ว

    Thanks. Very useful!

  • @rb.001vchuouniversity7
    @rb.001vchuouniversity7 3 ปีที่แล้ว

    Excellent

  • @MarilynnOfficial
    @MarilynnOfficial 2 ปีที่แล้ว

    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.

  • @weichaochen1343
    @weichaochen1343 ปีที่แล้ว

    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")

    • @rogerburrows7679
      @rogerburrows7679  ปีที่แล้ว

      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

  • @HuanleMandarin
    @HuanleMandarin 3 วันที่ผ่านมา

    how about fill the blank?

  • @jimvjose
    @jimvjose 3 ปีที่แล้ว

    Thank you

  • @nhuanp.nguyen1199
    @nhuanp.nguyen1199 2 ปีที่แล้ว

    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

  • @selvamuthukumars683
    @selvamuthukumars683 3 ปีที่แล้ว

    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).

    • @rogerburrows7679
      @rogerburrows7679  ปีที่แล้ว

      Sorry, I ended the project and no plans for enhancements. Regards Roger

  • @huule6511
    @huule6511 3 ปีที่แล้ว

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

  • @taryn4080
    @taryn4080 2 ปีที่แล้ว

    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!

    • @rogerburrows7679
      @rogerburrows7679  ปีที่แล้ว

      Sorry, I ended the project and no plans for enhancements. Regards Roger

  • @johnossi4234
    @johnossi4234 4 ปีที่แล้ว

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

  • @malayalamautomobilechannel785
    @malayalamautomobilechannel785 11 หลายเดือนก่อน

    🥰🥰🥰🥰🥰🥰🥰

  • @maryburrows8244
    @maryburrows8244 5 ปีที่แล้ว

    Good job.

    • @rogerburrows7679
      @rogerburrows7679  5 ปีที่แล้ว

      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.

  • @togargultom7860
    @togargultom7860 4 ปีที่แล้ว

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

    • @edwintay3580
      @edwintay3580 ปีที่แล้ว

      Thanks for the vid! Would appreciate if ya have time to add in this if possible (10 random questions from a question bank)

  • @JeanPhilippeCunniet
    @JeanPhilippeCunniet ปีที่แล้ว

    6:30 - Adding the appscript