Google Docs - DOC by oxP7B05n


									                             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
  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
          Check your email to see your scores and feedback on your answer

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
   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
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 ( ) or the Google URL
           shortener ( ).

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 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
                 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

        You can also check out . There are several helps on the
site, including a video demonstration. There are several Google Docs tutorials
available in Youtube as well.

To top