Mobile Menu

  • Home
    • About Lindsay
  • Blog
    • English Language Arts
    • Effective Teaching Strategies
    • Technology in the Classroom
    • Self Care for Teachers
  • Free Grading Guide
  • Grading Reset Course
  • Resources
    • Web Store
    • TpT Store
  • Menu
  • Skip to right header navigation
  • Skip to main content
  • Skip to primary sidebar

Before Header

  • Facebook
  • Instagram
  • Pinterest
  • Twitter
  • YouTube

Lindsay Ann Learning English Teacher Blog

Erasing the English Teacher Status Quo

  • Home
    • About Lindsay
  • Blog
    • English Language Arts
    • Effective Teaching Strategies
    • Technology in the Classroom
    • Self Care for Teachers
  • Free Grading Guide
  • Grading Reset Course
  • Resources
    • Web Store
    • TpT Store

The Secret to Google Forms Spreadsheet Grading

Home » Blog » English Language Arts » The Secret to Google Forms Spreadsheet Grading
Google Sheets Add-On Saves You Time

June 19, 2016 //  by Lindsay Ann//  1 Comment

Sharing is caring!

  • Share
  • Tweet

Let’s say that you’re a rockstar teacher and have created a Google Form to quiz your students or create a meaningful assessment. How can you use a Google Forms Spreadsheet to grade smarter, not harder.

Does the spreadsheet generated for student responses have you scratching your head in frustration or going cross-eyed as you scroll through all of those little boxes on the computer screen?

I recently discovered an “add on” for Google Sheets that makes the grading/reading of your students’ responses so much easier.  

Here’s what you do.

Google Forms Spreadsheet Add-On: “Save As Doc”

  1.  Go to the “Add-ons” tab in the Google Sheets toolbar.google-forms-spreadsheet-grading
  2.  Select “Get add-ons.”
  3.  Become distracted with all of the great options for customizing your experience.
  4.  Search for “Save As Doc.”
  5.  Click on the blue “+ Free” button to install and “Allow” it access to your data.  As the description says, you will soon be able to save your students’ responses as a Google Document to make the reading of lengthy entries a lot easier.
  6.  Before you run the Add-on, hide any columns that you don’t want to appear on the Google Document (i.e. questions that you don’t want to see). Next, alphabetize the rows according to student name. Choose the down arrow on the column you want to alphabetize and select “sort sheet A-Z.”  This will help you tremendously when you generate your Google Doc because you will not be searching randomly for student responses.  On that note, I always include instructions on my Google Form name response question that students should put last name first so that when I alphabetize they are in the same order as my grade book – saves time later.
  7.  You will now see Save As Doc installed in your Add-ons dropdown menu.  Click “start” and type a memorable title in “Save Doc As” field.
  8.  If you want the headings from each column to appear (i.e. the questions from your Google Form) click “Include Headings.”
  9.  I prefer to select “Add a pagebreak after each row.” Pagebreaks ensures that the Google Document will start a new page after each student’s responses have been recorded.
  10.  “Select all data” and click the “Save As Doc” button.  Now, your Google Document will appear in your Google Drive. You can save it where you will be sure to find it later.  Then, scroll through and grade/read with ease!

Use Conditional Formatting

Conditional formatting in a Google Forms spreadsheet can help you to sort student responses. This can be helpful if you’re looking for a specific answer to a question. 

  1. Go to the format tab and choose “conditional formatting.”
  2. Select the cell range you wish to format. To do this, click on the row number or column number. 
  3. For “format rules,” there are several options. I usually use “text contains” or “text is exactly.” Type in the word you want the answer to contain if you’ve chosen “text contains” or the specific answer if you’ve chosen “text is exactly.” 
  4. Choose a color. This will turn different cells different colors, depending on the conditions you’ve set-up. I use this to quickly sort students into high/medium/low for differentiation purposes!

I hope these tips have been helpful to you.  Have you found any other add-ons that have been helpful?  I’d love to hear your thoughts!


Hey, if you loved this post, I want to be sure you’ve had the chance to grab a FREE copy of my guide to streamlined grading. I know how hard it is to do all the things as an English teacher, so I’m over the moon to be able to share with you some of my best strategies for reducing the grading overwhelm. 

Click on the link above or the image below to get started!

grading-papers

Sharing is caring!

  • Share
  • Tweet

Category: English Language Arts, Technology in the ClassroomTag: 21st century learning, Data Collection, Google Sheets, technology

About Lindsay Ann

Lindsay has been teaching high school English in the burbs of Chicago for 18 years. She is passionate about helping English teachers find balance in their lives and teaching practice through practical feedback strategies and student-led learning strategies. She also geeks out about literary analysis, inquiry-based learning, and classroom technology integration. When Lindsay is not teaching, she enjoys playing with her two kids, running, and getting lost in a good book.

Related Posts

You may be interested in these posts from the same category.

writing-process

The Writing Process Explained: From Outline to Final Draft

writing-narratives

The Art of Storytelling: Techniques for Writing Engaging Narratives

writing-topics

Writing Topics for Student Writer’s Block

The Art of Argumentation: How to Write a Convincing Argumentative Essay

5 Strategies for Improving Reading Comprehension Skills

active-reading

The Importance of Active Reading and How to Do It

presentation-skills

Teaching Effective Presentation Skills in English Language Arts Classrooms

poetic-devices

Understanding Poetic Devices: Personification, Alliteration, and More

top-classic-novels

20 Must-Read Classic Novels for High School Students

writing-prompts-for

101 Writing Prompts for all Levels of ELA

student-blogging

Everything You Wanted to Know About Student Blogging

chatgpt

Teachers, Open Your Eyes to OpenAI’s ChatGPT

Previous Post: «Sharing Google Forms for Classroom Use Sharing Google Forms: A Digital Teaching Hack
Next Post: How to Make High School Reading Memorable & Magical high-school-reading-instruction»

Reader Interactions

Trackbacks

  1. The Ultimate Guide to Grading in High School | Lindsay Ann Learning says:
    May 16, 2020 at 11:49 pm

    […] The Secret to Google Forms Spreadsheet Grading […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Join me in the pursuit of engaged, dynamic classroom learning!

I’ve created a FREE guide with 20 of my best strategies for streamlined grading to help English teachers like you have more time to do what you love.

Get the Guide!

Categories

Latest Products

  • Late Work Submission Google Form $3.00
  • Rhetorical Devices Activities for Google Drive & Print $4.00
  • Distance Learning Google Form Student Survey $3.00
  • Creative Writing Prompts Choice Boards $3.00
  • Slam Poetry Condensed Unit for Distance Learning $7.00

Site Footer

  • Facebook
  • Instagram
  • Pinterest
  • Twitter
  • YouTube

Copyright © 2023 Lindsay Ann Learning English Teacher Blog · Privacy · All Rights Reserved

311 shares