No More Red Pens: Using Online Assessments via Google Docs and Flubaroo Presented by Jenifer Willis, GCMS Getting Started: Sign in to your Google Account. (You should have one if you have a Blogger, gmail, or YouTube account. Otherwise, go to www.google.com and create a free account.) Complete the sample assessment No More Red Pens. It has been emailed to you. It can also be accessed from the blog www.willisssgraves.blogspot.com. Check your email to see your scores and feedback on your answer choices. To Create an Assessment or Survey: 1. On your Google Account screen, select Documents from the menu bar. (If you don’t see Documents displayed, click the More option and select Documents from the drop menu.) 2. Select Create from the top of list on left side of screen. 3. Select Form. 4. In the text box where the words “Untitled Form” appear, enter your assessment/survey title. (I entered “No More Red Pens.”) 5. If desired, in the next text box, which includes “You can include any text…” add instructions or comments. (I entered instructions for completing the quiz.) 6. Locate “Sample Question 1.” a. In the box “Question Title,” enter, “Please type your name into the space provided.” (Or any other identifying information you desire.) b. Select, “Required Question.” This option will ensure that student cannot submit the finished assessment without including their name. c. Select “Done.” 7. Double click on the words “Sample Question 2.” a. If you wish to email students’ scores/feedback to them, enter a prompt like, “Please enter your email address into the following text box to receive your scores.” b. Select, “Required Question.” This option will ensure that student cannot submit the finished assessment without including their email address. (or any other goofy text they might choose!) c. OR, if the email address is optional, (or not an option you will use) do not select “required.” d. Select “Done.” 8. For the rest of the assessment, select the “+Add Item” option at the top left of screen. a. Select the desired question type. (text, multiple choice, grid, etc.) b. Enter the question or prompt into the field labeled “Question Title.” c. Add answer or response choices, if appropriate, in the spaces provided. (Don’t mark correct answers yet; that comes after you finish the form.) d. You can use TAB to move quickly to next option. e. When you are finished with the question and answer choices, choose “Required Question” if desired and “Done.” 9. If you need to edit a question / prompt after selecting done, simply click on the question and select the edit option to the right of the question. (You can also “drag” whole questions up and down to reorder them if you want to.) 10. Additional “pointers” for specific question types: a. Checkboxes will offer the student a drop down menu of answer options. More than one option can be selected. (Good for surveys or “modified multiple choice” where you want students to know multiple part answers.) b. Grid will create a rows/columns answer box. Could use for matching items, (I used the animals/habitats prompt). Other ideas??? I entered my prompt into the question title space, labeled the columns with habitat names, and labeled rows with animal names. c. Scale will offer students a rating scale type response. (Surveys, self- evaluation, opinions, other ideas?) The form allows you to label the range any way you wish. I used the unimaginative Strongly Disagree to Strongly Agree, but I’m sure there are many more creative options out there! d. To Score or Not to Score! When you set up your grading options, you will be able to select whether or not to score an item (I only scored multiple choice and grid), and how many points to assign each question (from 1-5). 11. When you are finished with your assessment, (or out of time for the moment) select SAVE. It will then appear in your documents list on your Google account page. You can return to it at any time to edit, revise, add to, laugh at, or otherwise admire your handiwork. To Publish your Assessment/Survey: 1. Before you can grade your assessment, someone has to “take” your assessment. There are several basic ways that I’ve discovered to get the quiz to the kids (or teachers attending this presentation!) a. Email it to them. i. From Documents on the Google page, select the assessment you wish to send. ii. When you are viewing a spreadsheet version of your assessment, select “Form” from the menu bar. iii. Select “Send Form.” iv. Enter email addresses you wish to send the form to (I usually send to myself first, just to make sure it looks right). b. Embed the link on your blog. i. From Documents on the Google page, select the assessment you wish to send. ii. When you are viewing a spreadsheet version of your assessment, select “Form” from the menu bar. iii. Select “Edit Form.” iv. At the bottom of the page you will find the shortcut link to your assessment. Copy and paste the link onto a blog post or link to classroom resources. c. A final option is to simply provide students the link to the assessment. The web address is rather lengthy, so you might want to “shorten” it by using TinyURL (http://tinyurl.com ) or the Google URL shortener (http://goo.gl/ ). Assessing your Assessment: Now for the part we’ve all been waiting for: how do we let the computer grade this thing for us? (Refer to www.flubaroo.com for video and other information.) 1. Be sure that you have “taken” your assessment, providing all correct answers to any responses that will be graded. You can email the form to yourself, access it from your links, or simply (from the spreadsheet view of the assessment) Select “Form,” then “Go to Live Form.” Submit your answers when finished. 2. Note: At least two responses (including the one you are using for your answer key) must be submitted before you can run the grading script. If you plan to use the script to email students’ scores to them, and you don’t want them to see scores (especially if you want to include the answer key for feedback with the scores) until after all students have completed the assessment, wait until then to run the script I’m getting ready to tell you about. If you prefer to send scores immediately (almost) after the assessment is submitted, simply take it yourself a second time under a different name. (Of course, that will skew data if you are interested in overall class performance, averages, trends, etc.) 3. Installing the grading script: a. From the menu bar at top of the spreadsheet view of your assessment, select “Tools.” b. Select “Script Gallery.” c. Select “Education.” d. Search and Select “Flubaroo.” e. Install f. Authorize. g. Close, and close again. h. Flubaroo should now be included in the menu bar at the top of the spreadsheet. i. When you are ready to grade responses (after you have answered the questions yourself in a live form—NOT IN THE EDIT VIEW) select “Flubaroo” from menu. j. Select “Grade Assignment.” k. In Grading Step 1, you will see grading options for each item. For the Name and Email text prompts, choose, “Identifies Student.” l. Any item you do now wish the computer to score (short answer, survey items, etc.) select “Skip Grading.” m. Graded items can be assigned a point value from 1 to 5. n. Select “Continue.” o. Select the response you want to use for your answer key. (Yours, probably, unless you have a great deal more faith in your best whiz kid.) “Continue.” p. View Grades will show class data, percent correct, highlighted incorrect responses, etc. q. At bottom of the spreadsheet view, you can switch back to “student responses” to view the unscored items. To Email Scores to Students: (This can be done before or after students actually take the assessment.) 1. Select Flubaroo from menu bar. 2. Select “Email Grades” 3. Select the “Enter your email address” prompt. 4. You will have the option of including the answer key (or not) and comments with “your” email to the students. Final Remarks: Whew! All this is really not that complicated; I just have a passion for explicit instructions. Take some time to explore the Flubaroo data options—some pretty cool stuff there! Let me (or Amanda, who put me up to this) know if you have any questions! You can also check out www.flubaroo.com . There are several helps on the site, including a video demonstration. There are several Google Docs tutorials available in Youtube as well.
Pages to are hidden for
"Google Docs - DOC"Please download to view full document