Creating a Quiz in Google Documents

Creating a Quiz in Google Documents You must first create a Google account to utilize Google-Docs. 1. Creating/Accessing an Account: 1) Go to www.google.com 2) Along the top, left-hand side of the page, you will see the word "more" - click this 3) Upon clicking, this will open a drop-down menu. Click "Documents". 4) If you already have a Google log-in, enter your information. If you do not, create an account 5) Complete the required field and then submit your request. You will be brought to the Google Docs Homepage. 2. Creating a Quiz in Google Documents: 1) Under the Google Docs icon, you will see "Create New" -- click this 2) Upon clicking, you will see a drop-down menu. Click "Form". 3) Type the title of your quiz in the field "Untitled Form". 4) You may enter directions in the field "You can include any text..." 5) For your first question... 1) "Question Title" field, ALWAYS type "Student Name" as the first question 2) "Help Text" -- leave this field blank 3) "Question Type" --drop-down to "Text" 4) "Make this a required question" --Check this box 5) Click "Done" 6) Sample Question 2 will appear underneath "Student Name". Drag your mouse over this area until is becomes highlighted in gold. A pencil, 2-squares, and trashcan icon will appear. To edit, click the pencil icon. 7) To add a question... 1) "Question Title" field -- type your question 2) "Help Text" -- include further direction or leave blank 3) "Question Type"--drop-down to the type of question you would like 1) "Text" 2) "Paragraph Text" 3) "Multiple Choice" 4) "Checkboxes" 5) "Choose From a List" 6) "Scale" - Likert 7) "Grid" 4) "Make this a required question" --Check this box 5) Click "Done" 8) To add another question, click "Add Item" at the top, left-hand corner of the screen. 9) Repeat steps 7-8 until all questions are entered. 10) When finished, press "Save" (Note: Your quiz will automatically save from time to time.) 3. To Review Quiz Results/Spreadsheet: 1) On your quiz template, click "See Responses" and then "Spreadsheet" 2) At first, you will see a blank spreadsheet. Once student answer are logged, you will see results. 3) If you logout of Google-Docs after creating the test, upon re-login, you will go directly to the spreadsheet. It will automatically be entitled "null". 4. To Create an Answer Key: 1) While on the spreadsheet, click "Form" and then "Go to Live Form" 2) Your quiz will pop up in a new window. 3) In "Student Name", type "Key" 4) Take the test, inputting all correct answers. 5) Press "Submit" 6) A "Thanks!" window will appear. Simply close this window. 5. To Share the Quiz with Your Students: 1) On the spreadsheet, click "Form" and then "Go to Live Form". 2) Copy the URL and give it to your students ( the URL is MIGHTY LONG...) 3) OR....click "Form" and then "Send Form" and you may send the quiz via e-mail. 1) *I find it works best to post the URL to your homework site, blog, delicious, etc.* 6. Return to Spreadsheet to Review Results: 1) Upon returning to the spreadsheet, any results will appear. 2) You may either grade the results from this screen or format the spreadsheet to "selfgrade" (Open-ended questions can not be self-graded). Making a Self-Grading Quiz in Google Documents: 1) On your quiz spreadsheet you will see "Sheet 1" toward the bottom, left-hand side of the page. Click "Sheet 1" and rename it as "Intake" 2) Then, on the right-hand side of this button, you will see a drop-down arrow. Click it and choose "Duplicate" 3) Your duplicated sheet will appear under the name "Copy of Intake". Click the drop-down arrow on this sheet and rename the sheet "Graded" 4) Return to the "Intake" sheet by simply clicking "Intake" 5) Click on row 1 so that the entire row is highlighted. Then, right-click and copy the entire row. 6) Return to the "Graded" sheet. 7) Click on row 1 so that the entire row is highlighted. Then, right-click and PASTE. 8) You should see all information from "Intake Row 1" appear in "Graded Row 1". 9) Now...the fun begins.... 10) On your "Graded" sheet, 1) click in cell A2. 2) Type the following " =Intake!A2 " 3) press ENTER. 4) At this point, your timestamp results from "Intake" Cell A2 should appear in the cell. 11) On your "Graded" sheet, 1) 2) 3) 4) click in cell B2. Type the following " =Intake!B2 " press ENTER. At this point, your student name results from "Intake" Cell B2 should appear in the cell. This should be your ANSWER KEY row. 12) Now, cell formatting becomes a bit trickier. 1) Return to your "Intake" sheet 2) write down the correct answers for every question exactly as shown -- one slight difference will skew your results. (You may also print this page or copy it into a Word Document for quick reference). 13) On your "Graded" sheet, 1) click in cell C2 (This should be your first actual question cell). 2) Type the following " =if(Intake!C2="TYPE ANSWER HERE",1,0) ". 3) Then press Enter. A "1" should appear in your cell. If it does not, your formatting is off. Check for spelling differences, formatting errors, etc. 14) Continue to input the formula into each question cell. Each time you must input the individual, matching cell number and correct answer response." 1) For example, if the answer to my next question (Question Column D, Answer in row 2) is "Lindenwold Lions" I would return to my "Graded" sheet, click in cell D2 and type the following " =if(Intake!D2="Lindenwold Lions",1,0) ". After I press ENTER, a "1" should appear in the cell. If it does not, my formatting is off. 15) Once all of cells in row 2 are formatted correctly, 1) go to the next available column on the "Graded" sheet. 2) Type "Student Name" once again. 16) In row 2 of the same column, 1) input the following formula: " =Intake!B2 ". 2) "Answer Key" should appear in this cell 17) In the NEXT available column, 1) type "Raw Score". 2) In row 2 of the same column, input the following formula: " =Sum(C2:L2) " Where C2 represents the column of your FIRST graded question and L2 represents the column of your last graded question. 3) If you questions begin in column D and end in column G, your cell will read "=Sum(D2:G2). 4) After pressing enter, since this is the Raw Score of your ANSWER KEY, the total number of questions should appear in this column. 18) In the NEXT available column, 1) type "Student Average". 2) In row 2 of the same column, input the following formula: " =sum(H2/2)*100 " where H2=the Raw Score column and 2=the total number of questions. 3) If done correctly, your answer key column should average to 100. 19) Now, to be sure your cell formatting applies to all answer responses, you must copy the code to the rest of your spreadsheet. To do this, 1) on your "Graded' sheet, highlight all used cells in row 2. When you do this, a small square will appear in the bottom, right-hand corner of the last cell column. 2) Move your cursor over this small square until it turns to a large plus sign. THen click the square and drag it down to accommodate for the number of students taking the quiz. For example, if 20 students will take the quiz, drag down to at least row 25. You want to allow for accidental, additional responses. 3) After doing so, you will see a ton of zeroes pop up in your spreadsheet. These will automatically chage when student responses come in. 20) Finally, in your student average column on the "Graded" sheet, you can format cells so that passing and failing grades are highlighted. To do so, 1) click the "Student Average" column header (A letter). 2) Then, in the toolbar, you will see a four-square, colored icon. Click it. 3) You will see various color options and "Change with rules". Click "Change with rules". 4) Drop down to choose "greater than", 5) input the cut off score, 6) choose a background color to appear when this rule is true. 7) Add another rule for the "less than" option. 21) Congrats! You have created your first Self-Grading Quiz via Google-Docs!