Make Paperless Assessment with Google Forms – Part 1 of 2

Published by

on

Are you teaching in a school that recently went 1:1 or is about to go 1:1? Do you hate stacks of paper burying your desk after you give students a test? Do you want students to take tests on their devices? Do you hate it when your school’s photocopier jams? Do you want to reduce cheating on assessments?

If you answered “yes” to any of the above, read on. This is a visual tutorial for making an assessment with Google Forms. By the end of this post, you should be able to create an assessment and add questions from assessments you have in Microsoft Word and Google Doc formats. In part 2, I show you how to automatically grade paperless assessments in Google Forms.

To get started creating a Google Form, go to the Google Drive folder where you want to store the form and:

Screenshot 2015-05-08 at 12.25.33 PM

Screenshot 2015-05-08 at 12.26.49 PM

Checking “Shuffle question order” means the questions will appear in a different order for each student taking the test. This makes cheating during the test very difficult.

Screenshot 2015-05-08 at 12.29.43 PM

Screenshot 2015-05-08 at 12.30.38 PM

My students use HP Chromebooks. The touchpads are sensitive. This causes students to accidentally submit forms before they have answered all questions. Making each question required prevents forms from being submitted until all questions have been answered.

Screenshot 2015-05-08 at 1.16.55 PM

Screenshot 2015-05-08 at 1.18.30 PM

Screenshot 2015-05-08 at 1.20.26 PM

Screenshot 2015-05-08 at 1.21.07 PM

Screenshot 2015-05-08 at 1.22.04 PM

Screenshot 2015-05-08 at 1.22.55 PM

Screenshot 2015-05-08 at 1.23.57 PM

Now that you have started entering questions into your form, here’s a suggestion: get rid of all numbers for the questions and letters for the answer choices. Those are relics of the Scantron era. In part 2, I will show you how to automatically grade your assessment. You won’t need numbers or letters. The absence of letters and numbers makes cheating harder. Additionally, to tell another student an answer, a cheater would have to state the question and the answer. Instead of saying “2 is b,” a cheating student is re-teaching content!

Once you have entered your questions, get your form ready for students’ eyes:

Screenshot 2015-05-08 at 1.33.23 PM

Screenshot 2015-05-08 at 1.34.14 PM

Screenshot 2015-05-08 at 1.35.05 PM

Screenshot 2015-05-08 at 1.38.00 PM

Your form will open in a new tab.

Screenshot 2015-05-08 at 1.39.03 PM

After students have taken the assessment:

Screenshot 2015-05-08 at 1.40.42 PM

The answers, on a Google Sheet, appear in a new tab:

Screenshot 2015-05-08 at 1.42.54 PM

This is where I will end this post. Now you should be able to create a form and view answers. In the second post, I demonstrate how to use Flubaroo to easily grade the assessment and give students fast feedback. If you have any questions about Google Forms for assessment, please comment below or send me a tweet at @tmullaney23.

17 responses to “Make Paperless Assessment with Google Forms – Part 1 of 2”

  1. Daniel Hoffman Avatar

    Does this work on an iPad? The + link only brings up documents, spreadsheet and presentations with no “more” button. Also, I don’t see any forms tab on the Spreadsheet.

    Like

    1. tommullaney Avatar

      Full disclosure: I make my Google Forms on my Chromebook. Before the Chromebook, I made them using a Windows machine. My students use Chromebooks. I imagine students could probably answer a Google Form on an iPad but I am not sure you can make a Google Form using an iPad.

      Like

  2. Irena Bielicka Avatar
    Irena Bielicka

    When I copy/paste answers into the the first field (Option 1), they just stay in that field for me. What am I doing wrong? Great tutorial and really looking forward to Part 2. I have been using Google Forms and Flubaroo for testing/marking all semester, but never used Shuffle Questions option because I didn’t know how would Flubaroo sort them out. Thanks!

    Like

    1. tommullaney Avatar

      Irena, Flubaroo doesn’t care about the shuffle questions option. When you look at the report Flubaroo generates, it will show the questions in the order you entered them into the form.

      I have not had that problem with copying and pasting answers. I use both the keyboard and right-click methods using a PC or Chromebook. Are you copying the question or a blank line of text as well? Maybe that causes a problem?

      Like

      1. Irena Bielicka Avatar
        Irena Bielicka

        Tom, thank you for a quick reply! I tested both and you are right! Multiple choice answers spread themselves nicely in separate fields on the Form! I don’t know what I was doing wrong before. Also, now I understand what you mean by questions in the order they are in the form. Thanks a lot!

        Liked by 1 person

  3. tommullaney Avatar

    Irena, I’m so happy it worked for you!

    Like

  4. Sustainable Teaching | Make Paperless Assessment with Google Forms – Part 2 of 2: Grading with Flubaroo Avatar

    […] part 1 of this post, I showed you how to create a Google Form, import questions from a Google Doc or Word Doc and […]

    Like

  5. Dave Basener Avatar
    Dave Basener

    Tom, don’t the demographic questions get shuffled as well?

    Like

    1. tommullaney Avatar

      They do. But it does not affect Flubaroo recognizing them.

      It is odd that the 19th question a student answers is “Write your first name.” I just tell students that those questions will be mixed in before the first test. It’s not a big deal after that.

      Like

  6. Gary Gresch Avatar

    When you add the demographic questions (name, period, etc.) how do you keep them from being scored when graded/scored by Flubaroo? Do you just mark these questions as “Not Required”…?

    Like

    1. tommullaney Avatar

      Gary, I cover this in part 2 of this post. See link below. When grading with Flubaroo, set demographic questions to “Identifies Student.”

      Make Paperless Assessment with Google Forms – Part 2 of 2: Grading with Flubaroo

      Like

  7. Sustainable Teaching | Ten Things You Can Do This Summer To Prepare For Teaching In A 1:1 Classroom With Chromebooks Avatar

    […] My visual tutorial will guide you through this process. Doing this during the summer will save you untold time at the photocopier and ScanTron machine during the school year. If you are curious about grading, read my tutorial about it, but it will not be necessary until you give your first multiple choice assessment. […]

    Like

  8. […] From Tom Mullaney (source: https://tommullaney.com/2015/05/08/make-paperless-assessment-with-google-forms-part-1-of-2/) […]

    Like

  9. Kimkoehler Avatar

    If you don’t care if your students are cheating, Google Forms and Flubaroo make a great combination. If you need your student’s email addresses so you can email grades back after Flubaroo grades them, be aware that your students are having the entire assessment and the answers emailed to them and are sharing those answers with other classes. Google has been aware of the problem at least since 2014 and still hasn’t corrected it.

    Like

    1. tommullaney Avatar

      Kim, thank you for your comment. I disagree. Here is some language I used to argue this is not a problem in another blog post:

      “Without pencils and ScanTron sheets, multiple choice questions no longer need numbers and letters. This means that post-test cheating becomes a discussion of content.

      Rather than a cheating student telling another, “Question 4 is C,” they would say, “You need to know the Democrats were the group most likely to oppose Henry Clay’s American System.” Students are simply conveying content in that scenario. All teachers want students discussing content with each other beyond the classroom walls.”

      Further, teachers should e-mail full answer keys for transparency and so that students can review. Teachers can always use File–>Make a Copy to easily make different versions of the same test. Question wording and choices can easily be changed for make-up tests and to vary the tests slightly from year-to-year and semester-to-semester.

      Link to the blog post I quoted: http://www.imagineeasy.com/blog/ed-tech-tools-for-multiple-choice/

      Like

  10. Maxwell Dziku (@MaxwellD2014) Avatar

    This is a nice tutorial. Do you know of any way to upload the entire questions and answers at once into the google forms though? Say I have a question bank of 100 questions and i’d like to import them all at once from excel or word without having to go through the question, then answers format as above. Any suggestions?

    Like

    1. tommullaney Avatar

      I don’t know of that capability. The best I can tell you is that when you copy all answer choices from a Google Doc or Microsoft Word and paste them in the first answer field, it automatically populates into separate answer fields. When I saw that, I was sold on Google Forms.

      Like

Leave a comment

Create a website or blog at WordPress.com