How to Create Google Forms for Assessment

1. Open Google Docs.
2. On the Google Docs menu bar, click on New and select Form.  You will now be able to begin designing your assessment using Google Forms.
   

3. In the Untitled Form text box, type the name of your quiz.
4. In the text box below your quiz/test title, add any additional information, such as “Take your time,” “Good luck,” or any other special notes or instructions.
5. Enter your first question.  It is recommended that you make your first question “First Name” and the second question “Last Name” so that when viewing results you can easily sort them alphabetically.
6. Add a new question by clicking on the Add Item button and select the type of question you would like to insert.  For a question such as “Name,” you would like to select Text.
7. If you would like to Edit, Copy, or Delete a question, use the appropriate button after you have selected the question (by clicking on it).
8. Make sure you mark each question as a required question, as this will ensure that students must answer that question before completing the quiz.
9. Press the Done button once you are done editing a question.
10. You may change the theme at any time if you wish.  The theme will change the appearance of your quiz, not any of the content.
11. You will now want to make your quiz available to your students.  You may either a link to the quiz or you can send a web link to it.  A web link is recommended so that you do not worry about e-mail issues students may have.

1. E-mail

1. When in viewing your form in Edit mode, click on the Email this Form button.
2. You can then add e-mail recipients.  Press the Send button.

1. Web Link

1. Open your quiz in spreadsheet view.
2. On the toolbar, click on Form and then Go to Live Form.
3. Copy the link in the address bar and paste it into an e-mail, post to web page, or any other place where people will be able to access it on the Internet.

12. Your students can now take the quiz and your spreadsheet will automatically record student responses.  After the testing period is complete and all students have completed the quiz, you will want to set the spreadsheet up for self grading.  It is recommended that you take the quiz yourself before students do, so that it will be easier in setting up the self-grading.

Setting Up the Spreadsheet for Self-Grading

1. The easiest way to set up your quiz to self-grading is to take the quiz yourself.  This will ensure that all answers are correct and will eliminate any typing or spelling errors.  If you are including fields for First Name and Last Name, you may want to enter a name such as “Correct Answer” to let you know that all entries for that name will be correct.

2. Follow the directions above for going to the web link and take the quiz.  If your quiz has paragraph text, you may want to list particular items you are looking for or maybe enter “Answers may vary.”  You will have to manually check these answers yourself at a later time.
3. Access your quiz in spreadsheet view.  In the row that contains all of the questions (this should be row 1), add a columns at the end for each answer as well as one at the very end titled, “Final Score.” (See screenshot below)
4. You will now need to set up your quiz to self check.  It may be better to do this after all of your students have taken the quiz.
5. Click in the first “Final Score” cell for the first student who took the test (this should be row 3, as row 2 contains the answers you selected as correct answers).
6. You will have to enter a formula that will check the student answer against your correct answer.  The spreadsheet below will be used for this example:
   
7. Click in cell F3 and type in the formula below (make sure you press the ENTER key on your keyboard when you are done typing the equation):
   =if($D$2=D3,100,0)
   In plain English, this function reads:
   If the contents of cell D3 is equal to the contents of cell D2 (Blue), then score that question as 100%.  If they do not equal each other, score that question as 0%.
8. It is important that you include the dollar signs, as they tell the spreadsheet that you will always be referencing that particular cell (as we will be using the fill down function for copying formulas).  In English, the formula reads:
   “If the student answer found in cell D3 (student 1’s answer) matches the correct answer found in cell D2 (teacher’s correct answer), then the answer is correct and the student receives 100% for that particular question.  If the two cells do not match, then the student receives a 0 for that particular question.”
9. Continue setting up formulas to check for correct answers for each question.  You will want to manually enter these formulas for the first student only.  The fill down feature will be used for the remainder of the students. Click in cell G3 and enter the next formula to check for correct answers.  In this example, the formula would be (make sure you press the ENTER key on your keyboard when you are done typing the equation):
   =if($E$2=E3,100,0)
   In plain English, this function reads:
   If the contents of cell E3 is equal to the contents of cell E2 (Yellow), then score that question as 100%.  If they do not equal each other, score that question as 0%.
10. You will notice when you select a cell, the cell highlights blue and there is a small blue square in the lower right-hand corner.  This blue square allows you to copy information into other adjacent cells.
    
11. Continuing with our example, click in cell F3.  Click on the blue square in the lower right-hand corner and drag straight down in the same column until you reach the very last student.  This will copy your equation to each student for that particular question.
12. Copy the formulas that you had entered for the first student down for all student answers in that column for each question (not the “Final Score” column).
13. You will now want to set up the spreadsheet to calculate the final score.
14. In this example, click in cell H3 to calculate the final score for first student.  Enter the formula to calculate the average selecting the cells you would like to calculate the average.  The formula for this example would be (the colon can be read as the word “to”):
    =average(F3:G3)
15. Copy the formula that you had entered for the first student in the “Final Score” column down for all student answers in that column.

Viewing Results

1. After you have set up your assessment and students have completed it, you can use the built in summary of responses to quickly see how students scored on individual questions.
2. When viewing the spreadsheet of responses, click on Form and choose Show summary of responses.
3. A window will open that contains graphs for each question.