Teacher Tech

Paperless Is Not A Pedagogy

Menu
  • Teacher
    • Blog Posts
    • Teacher Tech Facebook Group
  • Google Certified Innovator
    • CoffeeEDU
    • Tour of Google Classroom
    • Back to Classroom
  • Author
    • Alice Keeler Books on Amazon
    • Bulk Order Books
  • Developer
    • Schoolytics
    • Google Developer Expert
    • Add-ons By Alice Keeler
      • Doc to Slides by Alice Keeler
      • Roster Extras by Schoolytics
      • TemplateTab
      • toTabs
      • Form Printer
      • Quiz Helper
      • Dice Slides by Alice Keeler
      • Scheduler by Alice Keeler
      • Document Outline by Alice Keeler
      • Missing From (Google Forms™)
      • Randomize Slides by Alice Keeler
      • Speaker Notes by Alice Keeler
      • sheetPusher
      • Seating Chart Slides
      • Hyperlink Slides Choice Board
      • Add-a-Date
      • QuickShare Screenshot
      • Anyone Can View
      • Drive 20
    • Apps Script Tutorials
    • Templates
  • EdTech Coach
    • Premium Membership
    • Free Newsletter
  • Hire Alice
Menu

9 Google Forms Formative Assessment Tips

Posted on January 16, 2022January 15, 2022 by Alice Keeler

If you use Google Forms for formative assessment quizzes here are some tips for the Form and the linked spreadsheet. Go to forms.google.com and create a Quiz. You can also turn on Quiz capabilities in the Settings tab of your Form.

Responses Tab

One of the best ways to view student responses is by using the Responses tab in Google Forms. A Google Sheets spreadsheet is NOT created automatically for your Google Form. Click on the green spreadsheet icon to create the spreadsheet. Do this for EVERY Google Forms Quiz.

Responses Tab in Google Forms and the spreadsheet icon 
Google Forms Formative Assessment

Quiz Helper by Schoolytics

I had originally written this blog post in 2014. I am updating the post to reflect the current design of Google Forms. I took many of my tips from this post and used it to design Quiz Helper by Schoolytics.

Tip: If you are using Google Forms for Quizzes I have coded an Add-on to help you with all the settings. INCLUDING creating the Google Sheets spreadsheet for the Form. Install Quiz Helper by Schoolytics and use the puzzle piece icon at the top to show the sidebar and set Form defaults. Many of the tips in my post are done automatically by this Add-on.

Quiz Helper Add-on for Google Forms by Schoolytics.
CLICK HERE to install Quiz Helper by Schoolytics.
Free for teachers. Collects NO User Data.
Coded by Alice Keeler

1. Collect Email Address

It is important that you collect the student’s email address. This is how you will release feedback to the student. Without their email address, it will be challenging. Quiz Helper by Schoolytics will enable collecting email addresses so you do not forget, but I highly recommend that you go to the Settings tab of any Google Form and scroll to the bottom. Under Defaults toggle on “Collect email addresses by default.” This will guarantee you collect email addresses in all FUTURE Forms. Your past ones, you still need to enable the feature.

Collect email address by default is toggled on

Want More Help with This? Become a Premium Member

$12 per Month: Cancel Anytime

2. First Name

Rather than ask for “name” make 2 questions. One for “First Name” and one for “Last Name.” This way you can easily sort the linked spreadsheet by either first or last name. This is also very handy when putting the results in the gradebook. Be sure to make the question worth zero points and REQUIRED!

Tip: Quiz Helper by Schoolytics will add these 2 questions for you, make them required, and set them to zero points.

If you teach High School you may want to add a question “What period are you in?” Make this multiple choice.

3. View Responses

There are 3 tabs in your Google Form. Click on “Responses” to see how your students performed and to give feedback in the Form.

There are 3 tabs under Responses.

First view the Summary to see how your students did overall. This is a huge advantage when using Google Forms over paper. Seeing at a glance how students did on individual questions helps you to form what you do after the quiz.

To give feedback and adjust the points on the questions click on “Question” or “Individual.” You can review responses by question or you can review them student by student.

Tip: If you give feedback in Google Forms use Quiz Helper by Schoolytics to create a Google Doc for each students with a report of their performance and the feedback you left them.

4. Turn OFF Accepting Responses

If you do not want students to take the Quiz, click on the toggle on the Responses tab for “Accepting responses.”

Tip: Quiz Helper by Schoolytics has an option to set a timer where the Form will automatically stop accepting responses after the timer expires.

5. Answer Key

Before the students take the Quiz, YOU TAKE IT! Instead of using your name use “ANSWER” for the first name and “KEY” for the last name. Fill out the Form with the correct answers. This does NOT set your answer key in the Form. It simply makes it easier when viewing the responses in the spreadsheet.

google forms answer key

6. Freeze Bar

By default the first row of the spreadsheet is frozen. This allows you to scroll through all of the student answers and still see the questions. If you were the first person to answer the Google Form quiz and you used “Answer Key” for the name, then the second row contains the answers.

On the left hand side, between rows 1 and 2, hover over the freeze bar. You will notice the cursor turns into a hand. Click down on the freeze bar and drag it down to freeze the first 2 rows. This will freeze the answer key at the top of the spreadsheet. As you scroll through the student answers you can compare their answer to the answer key easily.
freeze bar

animation

7. Sort

Hovering over the column indicators will reveal a small drop-down arrow. Click on this to choose to sort the sheet. You can sort the results by Last Name, Period, etc…
sort sheet

Sort each question. This will allow you to cluster which students answered what. Since the results of a Google Form are instantly in the spreadsheet as students submit you are able to quickly identify which students answered each answer choice for a particular question. Divide up the students by who answered what to provide a differentiated activity.

8. Multi – Column Sort

You probably want to sort by multiple columns. Such as by Period, Last Name and then First Name. Click on the select all square to the left of the column indicator A and above the row indicator 1. This should select the entire spreadsheet. Use the Data menu and choose “Sort range.” Under this select “Advanced range sorting options.”

Spreadsheet is selected and using the Data menu Sort range is selected along with advanced range sorting options.

Be sure to checkbox the “Data has header row.” Then choose the questions you want to sort by.

Sort range from A1 to N103. Data has header row is checked. Says sort by class and sort by last name and sort by first name

9. Conditional Formatting

Conditional formatting allows you to color code the cells based on the answer. For example, if the student puts down the correct answer the cell background color will be green. If a score is less than 70% you can have the background color be red. This allows you to easily identify trouble areas and find selected answers quickly.

Click on the column indicator of a question to highlight the entire column. Right-click on the column indicator and choose “Conditional formatting.”

Conditional formatting in the menu

This will open a sidebar for you to indicate the correct answers.

There are a variety of ways you can test the data with conditional formatting. If you have an exact answer you are looking for choose “Text is exactly” from the drop down menu. If you are testing numbers you may want to choose something like “Greater than.”

Conditional Format rules sidebar. Set format rules to format cells if text is exactly. put the right answer in the box below it.

Example of Conditional Formatting

Conditional Formatting

  • How to Use Quiz Helper for Google Forms™
  • Google Forms: STOP Students From Going to Previous Section
  • Be Data Driven – Use Conditional Formatting
  • 8 Google Forms Formative Assessment Tips
  • “Did you grade it yet?” – Students Turning In Late Work
Add-Ons
Grab a Spreadsheet Cell from Each Student

on 26 May, 2022 by Alice Keeler

Finally! A way to grab a spreadsheet cell from individual student spreadsheets. This allows you to easily review all students responses to a question in one place.

Forms
Award Badges to Your Students with Certify’em

on 24 May, 2022 by Alice Keeler

Gamification works! Use Google Forms to award students badges using the Forms Add-on Certify’em

Drive
Help! I Am Moving Schools. How Do I Move Google Drive Files?

on 24 May, 2022 by Alice Keeler

How do you copy or move Google Drive files? If you are retiring or moving schools or simply want a backup of your school files here are 5 ways you can move Google Drive files.

Add-Ons
How to Update Student Spreadsheets

on 22 May, 2022 by Alice Keeler

You make a copy of a spreadsheet per student, but what if you have a typo or want to add to the spreadsheet? sheetPusher by Alice Keeler and Heather Lyon helps you update student spreadsheets. Here is…

Docs
Google Docs Google Play App Store Install

on 21 May, 2022 by Alice Keeler

If you use Google Docs you want to be sure to have the mobile version as well. Use google play app store install

Related

Related Alice Keeler Blog Posts:

  1. How To Make a Form from Google Sheets
  2. 8 Google Forms Formative Assessment Tips
  3. Easy! Google Forms: Automatically Sort on Submit
  4. Simple: Make a Pivot Table

Continue Reading

Next Post:
Google Forms: STOP Students From Going to Previous Section
Previous Post:
Canva Jamboard Background

You must log in to post a comment.

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

Alice Keeler is a mom of 5. Current High School math teacher. Developer for Schoolytics.com. Google Certified Innovator, Microsoft Innovative Educator, Google Cloud Innovator Champion, and Google Developer Expert. Founder of #coffeeEDU
Teaching with Google Jamboard
Developer Schoolytics
Schoolytics is FREE for teachers.

Find ALL My Blog Posts


Link to List

Google Classroom Books

Alice Keeler: Mom of 5. Current High School math teacher. Developer for Schoolytics. Founder #coffeeEDU. Google Certified Innovator. Microsoft Innovative Educator. Google Developer Expert. EdTech Specialist.

My Referral Links


Custom Stickers, Die Cut Stickers, Bumper Stickers - Sticker Mule

 

©2022 Teacher Tech | Theme by SuperbThemes