Google Forms - Collect Quiz Answers and Grade Student Responses

Поділитися
Вставка
  • Опубліковано 22 сер 2024

КОМЕНТАРІ • 96

  • @jennydomincel09
    @jennydomincel09 3 роки тому +7

    Exactly what I needed. Thank u

  • @brianhalvorsen8113
    @brianhalvorsen8113 3 роки тому +6

    This is starting Exactly wher I am, Thanks

  • @susangaffoor2429
    @susangaffoor2429 4 роки тому +2

    Thank you for this video at this time of Emergency Remote Learning. I find it very comprehensive. Thank you for creating a Goggle Forms playlist. - - I hope you are doing well at this time.

  • @jj8755
    @jj8755 3 роки тому +1

    Thanks for the video, very helpful. One quesiton tho,
    How do you make a quiz so that I can tell them the result right after they take the exam?

    • @ProlificOaktree
      @ProlificOaktree  3 роки тому

      Using Forms will give you the answers right away.

  • @amitbhattcharjee5493
    @amitbhattcharjee5493 4 роки тому +2

    Really it's cool and informativeir helps to learn backend stuffs of a quiz. I'm a teacher this one really requires me lot. Thanks to you

  • @ligayagregana5393
    @ligayagregana5393 2 роки тому

    I love your tutorial videos, they're easy to understand, appreciate you doing this for us =)

  • @StuffedBox
    @StuffedBox 4 роки тому +3

    Nice and simple, easy to follow. We've been using Google Forms on our video call themes, games day themes and more. I can see this being useful in a classroom setting

  • @mr.herewardanderson3115
    @mr.herewardanderson3115 3 роки тому

    Love that you left in the 's' mistake hahaha. Excellent video. Clear and concise. Great teaching!

    • @ProlificOaktree
      @ProlificOaktree  3 роки тому

      Oh yeah, thanks! I just found another spelling error front and center in a video yesterday. Oh well!

    • @mr.herewardanderson3115
      @mr.herewardanderson3115 3 роки тому

      @@ProlificOaktree I was referring to how you set up a shortcut key with your s then accidentally stopped the recording. If there was a spelling mistake too, I certainly didn't catch it. You are too honest hahaha

  • @q.j.36
    @q.j.36 3 роки тому

    Thanks a lot!

  • @zScrotumify
    @zScrotumify 2 роки тому

    Thank you sir!

  • @marie2mil
    @marie2mil 3 роки тому

    Thanks so much for doing this, just what I need.

  • @adipuplampu7878
    @adipuplampu7878 3 роки тому

    Nice tutorials. Is there a way to upload questions from maybe spreadsheet unto google forms?

  • @mariamonicaestebanquiapo7291
    @mariamonicaestebanquiapo7291 4 роки тому +4

    thank you po.

  • @sweeyeokfoong3744
    @sweeyeokfoong3744 4 роки тому

    Thank you for your great effort. Very precise and straight to the point. Well done!

  • @tajikdude7519
    @tajikdude7519 3 роки тому

    Thanks a lot. Your video was very useful for me to create my own.

  • @leilanivillanueva2805
    @leilanivillanueva2805 3 роки тому

    hello sir, is there a possibility to add scores for each option in a multiple choice question in Microsoft Forms ? Example: option A - 3 pts, option B - 2 pts, option C - 1 pt.

  • @truckerdaddy-akajohninqueb4793
    @truckerdaddy-akajohninqueb4793 3 роки тому

    Here's my favorite piece of excel/GoogleSheets code.
    Good for vocabulary or spelling quizzes.
    1 point for survey
    0.8 for survay
    0.5 servay
    The ESL student knew the correct word but had difficulty spelling it.
    =IFS(SEARCH("survey",F2),"1",SEARCH("survay",F2),".8",SEARCH("servay",F2),".5",TRUE,"0")
    The students entered their answers using Google forms. I emailed them the link to the form. They answered using their cellphones. I turned off the form after everyone present said they were finished. Google forms exported everything to a spreadsheet.
    Then I used the cell code to evaluate their answers. The code is looking for one word in each answer. If the answer contains "survey" then a point is given. The search is case-insensitive. The student could have written "The answer is survey." and the code will still find the answer correct as long as the answer contains the word "survey". If the student misspelled the word, I expanded the code to give partial points.

  • @ybangsarap205
    @ybangsarap205 4 роки тому

    This is really helpful for me. May I just ask if I allow my student to answer this Google form quiz using Google classroom will it be graded automatically in that platform also? Thank you Dude.

    • @ProlificOaktree
      @ProlificOaktree  4 роки тому

      Yeah, just make sure the Form is associated with the Classroom. Make start it as a quiz from inside of Classroom.

  • @nelynoersofwati125
    @nelynoersofwati125 Рік тому

    Hello sir, I want to asking you about the google form, previously on google form I released the score, but when I refreshed the score was gone.
    Please help me sir. Thank you

  • @miss.hiraiqbal6837
    @miss.hiraiqbal6837 3 роки тому

    Thank you

  • @MEMORIA1316
    @MEMORIA1316 4 роки тому

    Extremely helpful! I forwarded to my colleagues!

  • @ohnmarlinshwe1603
    @ohnmarlinshwe1603 3 роки тому

    I've a problem like that. The answer is correct and it gives "1" point, but show "the red cross sign". How should I do?

  • @timosnieder4637
    @timosnieder4637 2 роки тому

    If it takes almost 8 minutes to explain then it's too complicated. I've given this a try, it only caused headaches. Back to printing quizzes the old fashioned way for me.

  • @Lucy-cl4gi
    @Lucy-cl4gi 4 роки тому

    How do you make this video with yourself talking while showing the instruction board? Can you make a tutorial video on that? Thank you!

    • @ProlificOaktree
      @ProlificOaktree  4 роки тому

      I bought a green screen that I recorduself in front of and then I "key" out the green with video editing software. I have to record me talking and my screen at the same time then lay one video on top of the other.

    • @Lucy-cl4gi
      @Lucy-cl4gi 4 роки тому

      Prolific Oaktree Thank you for sharing! Do you need two cameras to do both recordings at the same time?

  • @auroralopez7362
    @auroralopez7362 3 роки тому

    Hi !! Is it possible to download the Quiz, to be printed. Questions with all optional answers.

  • @odessarosario023
    @odessarosario023 3 роки тому

    My students took the exam last Friday (October 23, 2020) and now that I'm checking their answers in the responses tab, I don't see anything. I mean, no content at all. What do you think is the problem? Thank you very much and I hope you could help me!

  • @fraudkid975
    @fraudkid975 3 роки тому

    Can you see the responses that your student editted and before the student editted?
    U know.. right after they submitted sometimes they could have edit.

    • @ProlificOaktree
      @ProlificOaktree  3 роки тому +1

      Don't know but you can turn off the option to edit after submit in the Settings when you are designing the form.

  • @aclone7194
    @aclone7194 3 роки тому

    thank you, helped me so much

  • @lilyroma2086
    @lilyroma2086 3 роки тому

    Hello, how can I release scores if I did not get the students' email address. Can I do any manual sending of the responses form to the students with scores in it? Thank you and Hope to hear from you..God bless us.

    • @ProlificOaktree
      @ProlificOaktree  3 роки тому

      If the students were signed into the same school domain from which the quiz was created, you should be able to see who returned which answers. All of you would have needed to be signed into your google accounts.

  • @kelliestark3838
    @kelliestark3838 4 роки тому

    Very helpful. What video software or app. where you using for the screencast image?

    • @ProlificOaktree
      @ProlificOaktree  4 роки тому

      I use two instances of OBS Studio to record. To get it to look relatively clear, you need a green screen and good lighting. I then combine the two video tracks in Adobe Premiere Pro.

  • @chemtea7030
    @chemtea7030 4 роки тому

    Thank you so much sir !

  • @craigblanchard872
    @craigblanchard872 3 роки тому

    I have released the scores but a student says they can't view anything when they click view. It says they are not allowed to do that. What is going on? I want students to be able to view the right answers and their answers! I guess I can print it out...

    • @ProlificOaktree
      @ProlificOaktree  3 роки тому

      My advice would be to contact the school's IT department. Something may not be setup right for that student.

  • @dizzamaeipio987
    @dizzamaeipio987 3 роки тому

    It's late when i found out that i should collect the email to see who answered the forms, now idk who's score i recieve? Is there anything i can do to view my students score?

    • @ProlificOaktree
      @ProlificOaktree  3 роки тому

      I don't think so at this point unless there are any other fields in the quiz that off a unique identifier. The best solution that I know of is to enable the setting that makes the users be signed in to answer the quiz. That way you can know who they are.

  • @sakhivivekkumar9845
    @sakhivivekkumar9845 4 роки тому

    Sir I want only score after exam finished but there are showing question sheet with answer but I want only score card without answer sheet can we change the final score card setting and what can i send score without view (answer sheet) option.
    Sir please Answer.

    • @ProlificOaktree
      @ProlificOaktree  4 роки тому

      All of the setting that you can control for something like this are shown when you click the gear icon and then choose Quiz.

  • @forgetuitions2177
    @forgetuitions2177 4 роки тому

    Thank you.

  • @Mobybick123
    @Mobybick123 2 роки тому

    Does google forms allow you to see the emails of the people. Anyway thanks for the video

    • @ProlificOaktree
      @ProlificOaktree  2 роки тому

      I'm putting this question in the que to answer tomorrow during the live stream at 11 am. Hope to see you there. Look at my channel page for the link.

  • @dollarmahmud1134
    @dollarmahmud1134 4 роки тому

    When I give incorrect answer then view score show me correct answer but when i do not give any answer, correct or incorrect of that question then view score do not show me correct answer, plz help to solve this problem. I want view score show me correct answer all time. Is it possible?

  • @trendsettersinternationalc4691
    @trendsettersinternationalc4691 4 роки тому

    HELLO PLEASE HELP..... I originally created 3 quizes/test for our class and of course not realizing what all I should have done BEFORE I SHARED IT under google classroom.... Well now that they have turned in their test, I am noticing that it only says "response 1", "response 2" ETC .... NO names or emails attached to the test.... how can I correct this without asking the students to take the test again .... (crying)

    • @liskl5982
      @liskl5982 4 роки тому

      Next time you create a Google form select preferences and set collect emails. At least that way it will not happen again.

  • @barbierimando8133
    @barbierimando8133 4 роки тому

    my student answered the quiz and click submit..but it shows zero response on my end...is there a way to fix this?thank you for your help..

  • @lauratravis9980
    @lauratravis9980 4 роки тому

    Thanks, that was really clear.

  • @shslecture8365
    @shslecture8365 3 роки тому

    Im looking at the response sheet for the quiz I have given to my students but their emails are not showing

    • @ProlificOaktree
      @ProlificOaktree  3 роки тому +1

      You may need to make some changes to the settings like requiring them to sign in.

    • @shslecture8365
      @shslecture8365 3 роки тому

      @@ProlificOaktree thanks I got it already

  • @coastal399
    @coastal399 4 роки тому +1

    Cool Vid!

  • @sawhtoowar4524
    @sawhtoowar4524 3 роки тому

    Thanks you.

  • @kimberleykoekstat8914
    @kimberleykoekstat8914 4 роки тому

    I am wondering, when I created a short answer/paragraph question, the answer appears in red even though I manually graded it as correct, when I look at the student's individual quiz?

    • @ProlificOaktree
      @ProlificOaktree  4 роки тому

      I think it's a bug. I had the same problem when I was making the video so I switched to long answer to work around it.

    • @kimberleykoekstat8914
      @kimberleykoekstat8914 4 роки тому

      @@ProlificOaktree thanks for the reply. It did it for my long answer too. I will just instruct students to look at each individual answer for comments!

    • @liskl5982
      @liskl5982 4 роки тому

      Maybe have the test not return scores until you have reviewed - setting before you assign

  • @kassinyakhlef5376
    @kassinyakhlef5376 3 роки тому

    What did you use to record this video? zoom?

    • @ProlificOaktree
      @ProlificOaktree  3 роки тому

      OBS Screen Recorder. That's the only way I could figure out how to record two streams at once. One for the webcam, one for the screen. That allowed me to assemble them later.

    • @kassinyakhlef5376
      @kassinyakhlef5376 3 роки тому

      @@ProlificOaktree Thank you!

  • @mr.saurabhbhutani5609
    @mr.saurabhbhutani5609 4 роки тому

    Thankyou sir...
    Sir when I manually released the score later , students got an email with score and when they clicked the icon below their score "VIEW" icon then correct responses page didn't open. It showed that you need permission.Is there any setting that I need to change ???
    Why students are not able to see the correct answer after they viewed their scores.

    • @ProlificOaktree
      @ProlificOaktree  4 роки тому

      Yes, go to the gear icon, go to Quiz, and look at the settings under Respondents can see.

    • @mr.saurabhbhutani5609
      @mr.saurabhbhutani5609 4 роки тому

      @@ProlificOaktree
      Thankyou for your response sir,
      Sir in gear icon under settings tab in option of respondents can see
      all the options are already ticked
      1. missed questions
      2. correct answers
      3. point values.
      I will try once again...
      Sir, could you please elaborate the use of RETURN option in google classroom after importing the marks from google form.
      Thankyou Sir.

  • @rhondagamboa5376
    @rhondagamboa5376 3 роки тому

    I need to assign 12.5 per question in Google form is this an option?

    • @ProlificOaktree
      @ProlificOaktree  3 роки тому

      You can assign whatever points you would like.

    • @rhondagamboa5376
      @rhondagamboa5376 3 роки тому

      @@ProlificOaktree every time I add a decimal it reverts to the whole number. Example 12.5 turns to 12. Is there something in settings I need at adjust?

    • @ProlificOaktree
      @ProlificOaktree  3 роки тому

      @@rhondagamboa5376 Oh sorry, not sure.

  • @vedranvukusic6873
    @vedranvukusic6873 3 роки тому

    Can students see the answer key when i send out the form???

  • @stephaniebellville5456
    @stephaniebellville5456 4 роки тому

    Napoleon was from Corsica originally.

    • @ProlificOaktree
      @ProlificOaktree  4 роки тому

      Why you gotta be calling me out like that?! I'm not going to bother looking it up. I just have a feeling you're right.

  • @timosnieder4637
    @timosnieder4637 2 роки тому

    My kids are telling me they can't access the feedback...

  • @duckie1343
    @duckie1343 3 роки тому

    me relizing all of yall are teachers and im a 11 year old runing a lgbqt class 👁️👄👁️

    • @ProlificOaktree
      @ProlificOaktree  3 роки тому

      There's some unwritten rule on this video that everyone that's not a teacher comments in the third person said Prolific Oaktree.

  • @mattyfaber2841
    @mattyfaber2841 3 роки тому

    You are old. lol. No offense. I love u :)