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

How To Find Who Did NOT Fill Out the Google Form

Posted on April 23, 2022May 13, 2022 by Alice Keeler

Google Forms™ are awesome, you immediately get the information when students fill out the Form. You know who DID fill out the Form. But what about who did NOT fill out the Form. This is a lot trickier. Obviously, the Form does not know who was supposed to fill out the Form so it can not tell you who is missing. I have created an Add-on that will provide you with a list of those who did NOT fill out the Form.

Missing From the Google Form. How To Find Who Did NOT Fill Out the Google Form

Missing From Google Forms™

The Missing From by Alice Keeler Add-on helps you to match up a list of email addresses you were expecting to fill out the Form with the email addresses that were submitted. This works quickly and easily to provide you a list of who did NOT fill out the Form.

Install Missing From by Alice Keeler
Who did not fill out the Google Form

Privacy Permissions with Missing From

The Missing From Add-on has zero access to your Google Forms or Google Drive data. Your email address is matched to confirm your subscription to Missing From. This is the only information that is known or used by the developer: AliceKeeler.

Create a Google Form™

Obviously, if you want to know who did NOT fill out a Google Form you will need to have a Google Form.

The Form MUST collect email addresses.

Add a New Sheet

You will need a sheet in the Google Form responses spreadsheet that contains a list of expected email addresses. Missing From by Alice Keeler is a Google Sheets™ Add-on. Start by going to the Responses tab in your Google Form and clicking on the spreadsheet icon. You should be viewing the Google Sheets spreadsheet that collects Google Form responses. Add a new sheet or you can send a sheet that you have of participant email addresses to the Form Responses sheet.

Insert a sheet int the form responses of the Google Form spreadsheet with the full participant list. Be sure that there is a column with the word email in the header.

For an existing spreadsheet use the “Copy to” in the tab menu to send to “Existing spreadsheet.”

copy an existing sheet by using the tiny triangle on the tab and choosing copy to and existing spreadsheet

Column Header Email

You MUST have column headers on your expected participant’s sheet. The header needs to contain the word email. No other headers should contain the word email. Missing From by Alice Keeler Finds email addresses that are missing from Google Forms by matching email addresses so it is important that you label which column has those email addresses.

Form Collects Email

It is very important that your Google Form is automatically collecting email addresses. To ensure unique values to match, email addresses are used as the key for who is missing from the Google Form.

Matching Form Tab

Missing From by Alice Keeler does assume that you are using a Google Form and that your tab with the Form Responses says “Form.” You may have renamed the tab for Form Responses. At least temporarily please put “Form” as the first 4 characters on the tab name.

Extensions Menu

The Add-on Missing From by Alice Keeler can be found in the Extensions menu after you have installed it. Be sure that you are looking at the pull participant list before running the Add-on. The Add-on will automatically detect which column has the word email in it and match it against column B (email addresses) in the Form tab. A new sheet will be added to your spreadsheet with the list of who did NOT fill out the Form.

VLOOKUP

If you would like to know more than the email address of who did not fill out the Google Form, please use a vlookup on the participants email addresses to grab additional columns such as name.

Want More Help with This? Become a Premium Member

$12 per Month: Cancel Anytime

Premium AliceKeeler Add-ons are included with membership

Scheduler Add-on by Alice Keeler

The quest to know who did NOT fill out the Google Form™ was started by me (Alice) when I was trying to organize and “Adulting Day” at the high school I teach at. I told the principal I would have the list of those students who did NOT fill out the Form on Monday. This proved to be more difficult than I thought it would be.

I designed an Add-on that helps you to organize participants into a schedule when there are multiple sessions throughout the day.

Obviously, you can not build a schedule if you do not have everyone on the list.

We used a Google Form™ to ask the students their 1st, 2nd, 3rd, etc… choice out of the 50 activities. We then needed to arrange them into session blocks based on their preferences and room availability. Each room had a cap of the number of students who could attend.

Install Scheduler by Alice Keeler

Please review and install all of my Add-ons in the Google Marketplace.

Who is Not Registered For the Event?

After giving the Google Form™ to the students, we needed to know who did not fill out the Form so they can be scheduled. I built into the Scheduler Add-on the ability to generate the list of email addresses of who did not fill out the Form and add them to the Form Responses tab so you have a complete list.

My Add-on “Scheduler by Alice Keeler” collects no user data. NO PII. While its main function is to create schedules for an activity day, you can use Scheduler with ANY Google Form™.

List of Who is Missing

Using the Extensions menu, choose “Scheduler by Alice Keeler” and use the option for “Find Missing Participants.”

Extensions menu with scheduler by alice keeler selected. The more options menu expanded out to offer "Find Missing Participants."  How To Find Who Did NOT Fill Out the Google Form

This will prompt you to confirm that you are looking at the sheet with the full roster of who you expect to fill out the Form. The Add-on will automatically detect the column with the word “Email” in the header. It will also automatically detect the “Form” sheet and the column that says “Email Address.” These 2 columns will be compared. Any emails on the active sheet that are NOT on the Form Responses will be added to a new sheet.

Want More Help with This? Become a Premium Member

$12 per Month: Cancel Anytime

  • Google Slides: Blackout
  • Lesson Planning: What Are the STUDENTS doing?
  • Google Apps Script: Create New Tabs
  • Homework Does Not Teach Responsibility – Sports Does
  • Google Slides: Add Your Roster
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

How Do You Know Who Did Not Fill Out a Google Form™

How do you know who did not fill out a Google Form? You MUST have a list of who was supposed to fill out the Google Form.

Related

Related Alice Keeler Blog Posts:

  1. Turn Your Docs into Forms and Slides
  2. How To Make a Form from Google Sheets
  3. How to Use Quiz Helper for Google Forms™
  4. 9 Google Forms Formative Assessment Tips

Continue Reading

Next Post:
How to Randomize Range in Google Sheets
Previous Post:
How to Make a Rubric with Multiple Choice Grid in Google Forms

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