GOOGLE FORMS TUTORIAL PART 2: CREATE ONLINE
GOOGLE FORMS TUTORIAL PART 2:CREATE ONLINE QUIZ/TESTJune 2020
Google Forms to Create Online Quiz/Test In Part 1 of this Google Forms tutorial, we learn how to develop questionnaire,study parts of questionnaire, create titles, descriptions, selecting type of question touse, questionnaire setting etc. In form/questionnaire setting there is a feature that enables Google Form asQuiz/Test tool, that is point/scoring feature for each question based on itsanswer and the total score for each form/questionnaire. In this part 2 of Google Forms tutorial we will learn how to create online quiz/testusing Google Forms. The same case with Part 1 to Create Online Survey: We expect that most will use quiz/test on their smartphone However for quiz/test development and Grading, Laptop/PC is preferred. Grade for each quiz/test participant is also linked to spreadsheet. Google Forms is Free. This tutorial is developed by adhi.wikantyoso@maxiresearch.com fromwww.maxiresearch.com2
Making a Quiz To develop quiz we need to focus on completing the questions part of the quiz first(including correct-incorrect option answers) Only after it is finished then we move on to the point feature, making it a quizAfter your questions for quiz is completed (questions question answer choices)Go to QuizzesGo to SettingSlide right to Makethis a quizWhen to release grade: (1) Immediatelyafter submission (2) after manualreview . This tutorial is mainly dividedby these 2 Grade Release typesWhen viewing gradewhat other informationrespondent can also seeGrade total points forcorrect answers/maximumpointsIdentify Correct or Incorrect Answer foreach questionBy turning on this quizfeature, EVERYQUESTION will nowneed ANSWER KEY andthe POINTS for gettingright answer.Show the correct answer for questionanswered incorrectlyShow points for each question and thetotal pointsAll these three options are checked bydefault once you turn on the quiz feature.3
Turning On Quiz Feature By turning on the quiz feature every question now needs information on AnswerKey, which/what answer is correct and the points for getting right answer.Quiz Feature Turn OffNo Answer Key menuQuiz Feature Turn OnWith Answer Key menuEach question now needs info on Answer Key.If we don’t provide info on Answer key, the default point is 04
After Clicking Answer Key in a Question Two things that we need to do: (1) Indicate our correct answer and (2) Set pointsfor correct answer.Set the point forcorrect answerIndicate thecorrect answer5
Email as Quiz Id and Address to Send Grade Release If Quiz with Grading after review is selected, emailquestion is automatically added. Email is used as Quiz Id and as address to send to forGrade Release. If Grade Release immediately after submission isselected, email is optional. However generally advisableto add just in case later on we need to email GradeRelease for various reasons (for Grade scoreconfirmation, revised/edit Grade etc) Add email question using Google Forms default inSetting.Email questionadded usingSetting The add email using setting doesn’t count asquestion in quiz therefore no need for Answer KeyEmail questionadded manuallyas questionNeed Answer Keyif addedmanually6
RELEASE GRADEIMMEDIATELY AFTER QUIZSUBMISSION7
Quiz Example for Grade Release Immediately (1) If grade release immediately after submission is selected, it is much better to have quiz whichquestion type only consists of Multiple Choice or Checkboxes type, as there is no need to reviewpoint answer manually.True False questionis a Multiple ChoiceEmail AddressPoint forcorrect answerMultiple ChoiceQuestion type8
Quiz Example for Grade Release Immediately (2)Checkbox QuestiontypeSubmit button9
Set Answer Key : Multiple Choice (1) Multiple Choice question is among the most common question type for quiz. In Multiple Choicewe choose one correct answer from several option answers After a question is completed with its options answers (commonly 4 but can be any number ofoptions), indicate the correct answer and set the point for correct answer for the question.Set the point forcorrect answerIndicate the correctanswerOptional: To give comments, link towebsite or video as feedback forincorrect or correct answerBack to Question display10
Set Answer Key : Multiple Choice (2)True – False Question Another common question type for quiz is True – False. It is actually a Multiple choice with only 2option answers, True and False After question is completed with its True-False answers indicate the correct answer and set thepoint for correct answer for the question.Set the point forcorrect answerIndicate thecorrectanswerEdit feedbackDelete feedbackFeedback added for thisquestionBack to Question display11
Set Answer Key : Checkboxes Not as frequent is Checkboxes question, this question type can have one or more than onecorrect answers from several option answers.Respondent will get point when their choices are exactly like key answers. Partly correct answerdoesn’t count.Set the point forcorrect answerIndicate thecorrectanswer(s)Back to Question display12
Confirmation Page After Submit for Quiz with Grade Release ImmediatelyFor Grade Release Immediately, There is Button to View ScoreFor completed quiz, right afterquiz is submitted you will haveConfirmation Page with button toView Score13
Grade Release Page (1) Right after hitting View Score button you will have the following Grade Release page. Thecontent include (1) Point for each question and Grade result (2) Correct/Incorrect identification –checked and in green for correct answer, cross and in red for incorrect answer (3) Show correctanswer for question answered incorrectly and (4) Feedback if it is set soQuestion with wrong answerPoint for this question.0 for wrong answerHere is the gradefor this participantThe correct answer for this questionGrade format TotalPoints for CorrectAnswer/Total AvailablePoints.We set feedback forincorrect answer for thisquestionFeedback for correctanswer for this questionQuestion with correct answerPoint for this question.We set 1 point forcorrect answer14
Grade Release Page (2) No answer is considered incorrect answer and get 0 pointNo answer isconsidered wronganswer and get 0pointCorrect answer for checkboxQuestion type15
Grade Release Page (3) End of the Grade Release page16
Open Responses in Spreadsheet Go to Responses tab and click spreadsheet buttonClick this to open response spreadsheet17
Response Spreadsheet Record of answer for each question for every respondent is available in spreadsheet format.Two additional information in the spreadsheet : Timestamp, when quiz/test is submitted andTotal Scores/GradesIf quiz feature is turned on, column containing quiz scores/grades willautomatically be addedThese terms often used interchangeably Score Grade Total Points1st column has the time wheneach form (in this casequiz/test) is submitted: date,hour, minute, second.Each column contains answers for each question for every respondentPoint for each question and feedback (if any) is not available inspreadsheet.18
Responses – Summary (1) In Responses – Summary there are Summary for the quiz : Score distributionprofile, Frequently missed question, Scores for each participant and whatanswers are given for each question.Important: Not Releasedhere means ReleaseGrade by EmailScore for each participant,email is used as IdSummary tabScore DistributionAnswers given for Question 1Questions with 50% correctCorrect Answer for Question 119
Responses – Summary (2)Answers given for Question 2Correct Answerfor Question 2Answers given for Question 4Correct Answerfor Question 4Answers given for Question 5Answers given for Question 3Correct Answerfor Question 5Correct Answerfor Question 320
Responses – QuestionIn Question tab we can explore on question basis whoanswered an option answer, mark as correct or incorrectparticular answer and edit/revise its point, and add feedbackQuestion tabNow in 2nd question out of10 questions1stNow in question out of10 questionsMark the answer as incorrectPoint given at the momentMark the answer as correct1 response who answered plant and itcomes from this respondent idFeedback we have createdbefore for incorrect answers.All who answer incorrectlywill get this feedback.21
Responses – IndividualEmail of thisindividualNow in 1 st respondent out of20 respondents totalIn Individual tab we can explore on individual basis answerfor each question, edit point and add feedback specifically forthis individualIndividual tabTo release score for thisindividual by emailScore not released meaning scorefor this individual has not beenreleased by EmailExisting feedback for answering incorrectly. This isgeneral feedback, all who answered incorrectly willhave this feedback.To create individual feedback send only to thisindividual. This individual feedback will replacegeneral feedback22
Release Grade By Email : Although Quiz is using Grade ReleaseImmediately, Later You Can Still Release Grades by EmailNow say we want to send email score as confirmatory from earlier Grade ReleaseImmediately (via button View Score in Confirmation Page). Click this Release Scorebutton in Response-Summary tabMessage to say that this score is confirmationIn Response-Summary tabQuiz participants receivescore emailsAll participantsemails are selectedby defaultTime the emailscore is receivedSend emails andRelease scoresTime the email score isreleasedQuiz/TestscoreNow scores areemailed to allparticipantsClick view to openGrade ReleasePage23
Editing Grade – By Question (1)Now during review we may want to edit correct answer to certain question as incorrect, orconversely incorrect answer as correctIn Response-Question tabQuestion tabWe are in Question no 2The 10 participants who answeredthis will see their point up by 1 pointAfter editing the point foranswering this is 110 participants answered thisWe want to edit and mark thisanswer as correctTo save the editCurrently the point foranswering this is 024
Editing Grade – By Question(2)After editing, the score for each affected quiz/testparticipants will be updated.After EditingBefore EditingIn spreadsheet : Updated, the 10participants whose point up by 1 pointBefore EditingIn Response-Summary : Updated, 10participants whose point up by 1 pointOnly 5 shown here forillustration purposeNo changes in answer only the scoreAfter EditingIcon to tell that there is updateto this respondent data25
More Release Grades by EmailRelease Grades can be Sent Multiple TimesNow we want to release the updated grades, in thisexample only to affected participants only.Click here to Release ScoreQuiz participants receivescore emailsMessage to say that there isupdated Grades due to revisionSend ReleaseGrade, this timeto participantswith revised ScoreonlyRelease Time updatedUpdatedQuiz/TestscoreTime the updatedscore is releasedTo send emails andrelease scoresAll updated scores are released(updated icons are gone)26
Opening Grade Release PageGrade Release Page is Always Updated Following Edit/RevisionGrade ReleasePage openedUpdatedQuiz/Test score,previously 5/10Updated point forthis question. Answerremains the same,but now you have 1point instead of 0Click view to openGrade ReleasePage27
Editing Grade – By Individual (1)Now during further review we may want to edit pointfor certain individual, by adding point to a question.In Response-Individual tabIndividual tabCan Release Score fromIndividual tab (Can also fromSummary tab), Click hereWe are looking at participant no 1Score for this individual has been releasedUpdates made after release (due to the edit)Initially this individual for Question 1get 1 point for answering correctly.For sake of example we want to addanother 1 point, so will get 2 pointsAfter edit, 2 points for Question1 for this individualTo save the edit28
Editing Grade – By Individual (2)As also shown earlier, after editing the score for eachaffected quiz/test participants will be updated.After EditingBefore EditingIn spreadsheet : The 1 individualwhose point up by 1 pointBefore EditingIn Response-Summary : The 1individual whose point up by 1 pointNo changes in answer only the scoreAfter EditingIcon to tell that there is updateto this respondent data but hasnot been released.29
Another Release Grades by EmailNo Limit on Number of Release Grades To SendClick here to Release ScoreMessage to say that there isbonus point for having thefirst quiz submissionQuiz participant receivesscore emailSend to thisindividual onlyRelease Time updatedUpdatedQuiz/TestscoreUpdated score for thisindividual has beenreleased (updated iconis gone)To send email andrelease the score30
Opening Grade Release Page AgainGrade Release Page is Always Updated Following Edit/RevisionGrade ReleasePage openedUpdated Quiz/Testscore – last revision6/10Click view to openGrade ReleasePageUpdated point for thisquestion. Answer remains thesame, added 1 point now 2points for Question 131
Thesign next to Grade in Grade Response PageIt means Final Score for the Quiz is Pending, Reason : Questions with Empty Points Remember that when a form is set as quiz, we need to SET (1) ANSWER KEY and (2) POINTS FOR CORRECTANSWER for all questions so that each question can produce a score based on its answer, correct or incorrect. Non quiz Questions (such as Quiz Participants profile data : Name, Address etc) naturally doesn’t have AnswerKey. In this case the point for these questions are actually empty, with the default score of 0 for Point Calculation.Score for quiz for 1st participant, viewed usingGrade Release Immediately (via “View Score”button in Confirmation Page)2nd participant, viewed using Grade Release Immediately.Same answers same score but now with ? sign . Additionalquestions have 0 point so it doesn’t change total ScoreOn the quiz, Add question on Name(and/or other profile questions)When clicked it saysFinal Score Pending.Reason the additionalquestion(s) with emptypoints.Answer Key not provided since there is nocorrect/incorrect name. Therefore empty scorefor this question, with default score of 0 forGrade/Point calculation.32
Set/Give Points for Questions With Empty Points Go to Response - Individual tabClick here to Release ScoreSending ReleaseGrade to 2 ndparticipantWe are looking at participant no 2Currently empty point on NamequestionCurrently empty point on YearquestionSet 0 as point for the namequestionSet 0 as point for the yearquestion.Now no emptypoints for allquestionsTo save the edit33
Send Grade Release Email.On the Grade Release Page now thesign is gone.This 2nd participantreceives score emailGrade Release Page openedNow QuizscorewithoutsignClick here to Release ScoreClick view to openGrade ReleasePage34
Diagram Release Grade Immediately After SubmitRelease Grade ImmediatelyGrade ReleasePage OpenedOn ConfirmationPage after Submitthere is View Scorebutton. Click toopen GradeRelease PageCan Send Release Grade Later (Optional)Back In Google Forms File After Receiving SubmissionQuiz participants receiveReviewscore emailsSet Points RELEASE GRADEEdit PointsGive FeedbacksCreate MessageMake No ChangesGrade for this participant.Can have symbol ? next toGrade if there are questionswith empty pointsGrade ReleasePage Opened(with UpdatedGrade)Click the viewbutton to openGrade ReleasePage35
Now Diagram Release Grade Later After Manual Review The diagram below serves as an intro to next chapter on Release GradeLater After manual review. The difference with Release Immediately isdown to no view button score on confirmation page after submit.No Grade Release After SubmitRelease Grade Later After Manual ReviewBack In Quiz File After Receiving SubmissionAfter SubmitConfirmationPage with No‘View Score’ButtonOn ConfirmationPage after Submitthere is no ViewScore button.ReviewSEND EMAILSet PointsEdit PointsGive FeedbacksCreate MessageQuiz participants receivescore emailsGrade ReleasePage OpenedClick the viewbutton to openGrade Release Page36
RELEASE GRADELATER, AFTER MANUAL REVIEW37
Quiz Example for Grade Release Later After Manual Review (1) The quiz below contains not only closed end but also open end. As you will see, for open end questions,short answer and paragraph type, eventually manual review is necessary to be able to give score properlyShort AnswerShort Answer38
QuizExampleGradeRelease LaterAfter Manual Review (2)GoogleFormforQuiz– Example2 (1)Paragraph / essay question type39
Set Answer Key : Short AnswerExpecting Text Answer (1) Short Answer is an open end question that instead of choosing answer from available optionanswers, quiz participants write their own answer. The expected answer would be short. Short answer question type, actually make no difference between expecting text or numberas answer. We make this separation for illustration purpose for the quiz maker.We are now developing answer keys for short answer typeShort Answer question typeThis is the question, imagine that the answer will be something short in textClick Answer key40
Set Answer Key : Short AnswerExpecting Text Answer (2) Create list of correct answers for answer keys for the question.Add correct answer(s) as answer keys41
Set Answer Key : Short AnswerExpecting Text Answer (3) Imagine the more likely / expected ways respondent would write answer for the question. To be considered correct answer, the answer have to be exact match with any of key answersprovided. It is case sensitive and typo is not allowed.Point for correct answer, ie hasmatch in any of answer keysCan put in any number of answer keys.If this option is checked, answer do not match withany of answer keys would be considered incorrectthus 0 point. If unchecked the point for thisquestion would be empty.42
Set Answer Key : Short AnswerExpecting Text Answer (4) Setting answer keys and point for correct answer is completed, now back to question display43
Set Answer Key : Short AnswerExpecting Text Answer (5) Effect of ‘Mark all other answers incorrect’ in Answer Key on Point givenNot checked on “Mark all other answersincorrect”Answer do not match key answerEmpty pointChecked on “Mark all other answersincorrect”Answer do not match key answerIncorrect and get 0 pointAnother lesson from example above : For open question, afterapplying Answer Key, manual review to determinecorrect/incorrect in order to give point is still necessary.44
Set Answer Key : Short AnswerExpecting Numeric Answer (1) Now a question that expects numeric answer.Short Answer question typeDescription in the question that asks respondent to write theiranswer in number only without the unit.45
Set Answer Key : Short AnswerExpecting Numeric Answer (2) Key answers for this question is 1500 or 1,500 as we consider these are more likely waysrespondents would write for thousands.Point for correct answerAnswer keysFeedback is added for all answers46
Set Answer Key : Short AnswerExpecting Numeric Answer (3) Setting answer keys and point for correct answer is completed, now back to question display47
Set Answer Key : Short AnswerExpecting Numeric Answer (4) Illustration of respondents answerscenarios and their pointAnother example that shows importance of manualreview to determine correct/incorrect in order togive point1500 : CorrectAnswer Key Setting1,500 : CorrectEmpty point1.500 : Incorrectdue to using (.)Empty pointbecauseunchecked thispart[space]1500Typo error butstill get 2pointsSpaceEmpty point1500 Newton : Incorrectdoesn’t match answer keys.Empty point becauseunchecked48
Set Answer Key : Paragraph (1) Paragraph is an open end question that instead of choosing answer from available optionanswers, quiz participants write their own answer. Answer is expected longer than that of ShortAnswer question type. In case of quiz/test, the paragraph type is common for essay question.Paragraph question typeRespondent can write answer as long as they like hereClick Answer key49
Set Answer Key : Paragraph (2) With paragraph question type, there is no answer key to be set. We need however to set the maximum point for paragraph question. The point isnecessary to calculate total available points for Grading. Also serves as guide whengiving point during manual review.Maximum point forthis question50
Confirmation Page After Submit for Quiz with Grade Release LaterNo View Score ButtonIn case of Grade Release Later, onthe Confirmation Page right afterquiz is submitted there is nobutton to View Score.51
Open Submitted Data/Responses in Spreadsheet (1) Click spreadsheet icon to open responses in spreadsheet. This is an example for quizwith 1 data submittedClick this to open response spreadsheet1 means 1 submission so far52
Open Submitted Data/Responses in Spreadsheet (2) In spreadsheet, in addition to answer for each question for each respondent, there isinformation on the total score. If the quiz contains open end questions and before manual review/edit, the score is atemporary score, so far most likely comes from the closed end questions only, excludingopen end questions.Total Score for this participantEach column contains answer for each questionTime the quiz/test is submitted53
Responses – Summary Now we go to the Response – Summary (an example with only 1 submission).Score for this participanthas not been releasedScore each participant, email is usedas IdSummary tabQuiz/Test Score DistributionIf the quiz also have open endquestions, and we have notdone manual review, this scoreis temporary score, only fromclosed end questions excludingopen end.Answers given for Question 1Questions with 50% correct54
Review Individual Response to Set/ Edit Points and Give Feedback (1)In manual review, you go to individual response, focus moreon open end questions to set/give point/add feedback. Don’tforget to give point 0 on Non Quiz questions (such asparticipants profile)Individual tabWe are looking atindividual out of 11stThis individual has score of 9 beforemanual reviewSet point 0 for empty point, in thiscase for non quiz question – aboutname of participantSet point 0 for empty point, in thiscase for non quiz question – aboutyear of participantClick to save edit now, or can belater until all edits are done55
Review Individual Response to Set /Edit Points and Give Feedback (2)For Question 5 a short answer question type,initially the score was 0 for answer consideredincorrect using answer key, after manual reviewwe consider the answer is correct and this isdue to typo . The point was then edited to 1Example of editing point and adding feedbackon Short Answer questionFor Question no 5 we add feedback tothis individual onlyClick save to add feedbackFeedback added56
Review Individual Response to Set /Edit Points and Give Feedback (3)For Question 8 a paragraph question (or essay)type. During development we deemed 5 pointswas allotted for this question. There is noanswer key for essay question. The point is nowempty. After manual review reading the answerwe decided to give 4 points.Example of give point on essay questionJust type 4, and the point is given forthis question57
Review Individual Response to Set /Edit Points and Give Feedback (4)Save and Observe that Score is Now UpdatedBack to TopNow this individual has score of 14/17after manual review from previously 9/17End of quiz. Click Save to saveall edits.58
Before - After ManualReview (1)After manual review to edit/give points particularly for openend questions, changes in scores change summary of the quiz Update in Response – Summary pageBefore Manual ReviewScore distributionList of Individual Scores9After Manual ReviewScore distributionList of Individual Scores1459
Before - After ManualReview (2)If you open the response spreadsheet, the total score changes Update in Response SpreadsheetBefore Manual Review9 / 17After Manual Review/ 1714 14/ 17Only score changed,answer for each questionremain the same60
Before - After ManualReview (3)In Response – Individual, the total score changesincluding changes in point for each affected questions. Update in Response - IndividualBefore Manual Review9 of 17 pointsAfter Manual Review14 of 17 points61
Releasing Grade (1)After Release GradeBefore Release GradeIn Response – Summary : Not ReleasedIn Response – Summary : Time ReleasedRelease Grade button can beaccessed from Response-Summarytab (above) or Response –Individual tab (below)Both will go to the same Releasescores pop up window (right)Before Release GradeIn Response – Individual : Score NotRel easedRelease GradeSend Release Grade EmailsAfter Release GradeIn Response – Individual : Score ReleasedTi me62
Releasing Grade (2)Quiz participant receivesGrade Release emailRel ease TimeTi me ReceivedMessageMessageClick the view button toopen Grade Release Page63
Grade Release Page (1)In Grade Release Page after Manual Review, QuizParticipants will see the final total score, point for eachquestion and feedback if added.64
Grade Release Page (2)65
Grade Release Page (3) End of the Grade Release page66
APPENDIX:More Google FormsMaterials67
More Google Forms Materials GOOGLE FORMS TUTORIAL PART 1: CREATE ONLINE SURVEY Download pdf here. Link to the Google Forms questionnaire/quiz used in this tutorial Photosynthesis - Click here to view, Click here to copy to your Gdrive Motion - Click here to view, Click here to copy to your Gdrive68
THANK YOUMAXI researchPT. Mulia Karya InovasiOffice 8, Level 18-AJl. Jend Sudirman Kav. 52-53 SCBDJakarta Selatan .com
Google Forms to Create Online Quiz/Test 2 In Part 1 of this Google Forms tutorial, we learn how to develop questionnaire, study parts of questionnaire, create titles, descriptions, selecting ty pe of question to use, questionnaire setting etc. In form/questionnaire setting there
Grammar as a Foreign Language Oriol Vinyals Google vinyals@google.com Lukasz Kaiser Google lukaszkaiser@google.com Terry Koo Google terrykoo@google.com Slav Petrov Google slav@google.com Ilya Sutskever Google ilyasu@google.com Geoffrey Hinton Google geoffhinton@google.com Abstract Synta
Google Brain avaswani@google.com Noam Shazeer Google Brain noam@google.com Niki Parmar Google Research nikip@google.com Jakob Uszkoreit Google Research usz@google.com Llion Jones Google Research llion@google.com Aidan N. Gomezy University of Toronto aidan@cs.toronto.edu Łukasz Kaiser Google Brain lukaszkaiser@google.com Illia Polosukhinz illia .
Google Meet Classic Hangouts Google Chat Google Calendar Google Drive and Shared Drive Google Docs Google Sheets Google Slides Google Forms Google Sites Google Keep Apps Script D
More Google Forms Materials GOOGLE FORMS TUTORIAL PART 1: CREATE ONLINE SURVEYS Download pdf here . GOOGLE FORMS TUTORIAL PART 2: CREATE ONLINE QUIZ/TES T Download pdf here . Collection of Google Forms questionnaires that you can copy to your Gdrive for free. Click here .
Google Drive (Google Docs, Google Sheets, Google Slides) Employees are automatically issued a Kyrene Google account. Navigate to drive.google.com. Use Kyrene email address and network password to login. Launch in Chrome browser for best experience. Google Drive is a cloud storage sys
Google Forms 1. What is Google Forms? Google Forms is a simple way to gather data. You can use Google Forms to create a survey, gather information, class assignment or assessment. As the need grows for online tools, Google Forms is an excellent option to gather student responses in the same place at the same time.
2 Após o login acesse o Google Drive ou o Google Docs e selecione a ferramenta Google Forms (Formulários). Clique na caixa de Ferramentas do Google, localizada no canto direito superior da tela e selecione o Google Drive. Na tela do Google Drive clique em New , opção More e selecione Google Forms. OBS: É possível acessar o google
The Second way to open Google Forms into Google Quizzes: 1. Select the Waffle icon 2. select Forms from the drop down menu. (You may have to select “More” if you do not see the Forms icon.) 3. This will bring up all the Google Forms you have created and the templates for Google Forms.
