Pre-Filled Google Forms

Have a form that you fill out regularly?  Create a pre-filled form link that is partially filled in for you.

Sending a form out to a certain group who will all have the same response to a certain question (i.e., grade level)?  Create a pre-filled form link to save them a few moments.

Directions are underneath the GIF

Pre-Filled Google Forms Animation

Here’s how:

  1. Click the 3 dots in the top right corner.
  2. Select “Get Pre-Filled Link.”
  3. Enter the answers you’d like to pre fill.
  4. Click Submit.
  5. Copy the link.  All done!

Differentiation in Google Forms

Google Forms are great for collecting information and delivering assessments, but did you know Forms had some differentiation swag?

Yup, it’s true. Use “Go to Section Based on Answer” with a Multiple Choice question to have right answers and wrong answers lead to different sections. A general mockup of what this could look like, and steps for creating it, are below the GIF.

Differentiated Google Forms Animation

Steps:

  1. Add a question with a correct answer and (at least one) wrong answer.
  2. Add a section after that question.
  3. Put your remedial content in that section. YouTube videos work well.  You could even make your own video to put in there.  You could also include a follow-up question to give your students a chance to re-assess.
  4. Add a section after the remedial content.
  5. Put your next content here.  This is the section where students who got the correct answer will land.  It will probably also be where you have students who completed the remedial step will land.
  6. Go back to your initial question.
  7. Select “Go to Section Based on Answer.”
  8. Have the incorrect choice(s) go to the remedial section.
  9. Have the correct choice(s) skip to the section after the remedial one.
  10. Sit back and enjoy the differentiated learning experience!

General Layout:

  • Section 1: includes the question the differentiation is based on
  • Section 2: the remedial section – whatever content you want the students who got the previous question incorrect to see (video, explanation, follow-up question)
  • Section 3: the “next step” – the slide that the students with the correct answer jump to, also where the students with the incorrect answers land after completing the remedial section.

Note: you can add multiple levels of this in one Form, but it can get hard to manage.  I once created a Form that went: Question 1, Remedial Video & Question 1a, Remedial Video & Question 1b, Question 2, Remedial Video & Question 2a, Remedial Video & Question 2b, etc.  As you may guess, I had to create a complex flowchart to make sure I had everything jumping to the correct places.

FormRanger Add-On

I love me some Add-Ons. One of my favorites is FormRanger from New Visions Cloud Lab. It can be used to pull in a column of information from a Google Sheet as multiple choice or dropdown options.

This is nice for quickly creating a lot of options for a multiple choice or dropdown question, but what takes it from nice to awesome is  . . . you can set it to automatically update based on changes made to the spreadsheet. Whaaaaat!?  I know, right?

There are two main cases for use: Continue reading FormRanger Add-On

Password Protected Google Forms

First off – I can’t take credit for this idea – just the GIF below.  I’ve heard it mentioned most recently on the Google Teacher Tribe podcast who credited the idea to Jeremy Badiner.

There are a lot of uses, but here are the 4 main ones that I can see:

  1. Post a Google Form (i.e., an assessment) to your LMS early, but students won’t be able to access the questions until you give them the password.
  2. Set this form as part of a BreakOutEDU style activity – participants can only access the form once they’ve found the password in the previous stage.
  3. Make it so only your intended audience can fill out a form.
  4. Keep sensitive information within the form, just like a password-protected website.

One important note: setting “error text” is essential – otherwise it will tell the user the password.

Password Protected Forms Animation

Note: Ah, the power of the Twitter PLN. @HaleEdTech pointed out that the user (i.e., student) can discover the password using Inspect Element or View Page Source (both are in the right-click menu).  If you intend to use this regularly, you may want to 1) turn off Inspect element in the Google Admin Console and 2) block “view-source” in the URL blacklist in your Admin Console.  These will only prevent this in Chrome – there are likely other steps you’d need to take with Safari or Firefox.

Exploring the Number pi with Google Sheets & Forms

What better way to celebrate Pi Day than with a hands-on, tech-on exploration activity that helps students build their own understanding of what pi really is?  Well, probably a good piece of pie, but this is awesome nonetheless.

Here’s what you do:

  1. Get a bunch of fabric tape measures (using string and then measuring lengths on the string works too).
  2. Get a bunch of circular objects.
  3. Have kids measure the circumference and diameter of different circular objects.
  4. Instruct the kids to submit their measurements to a Google Form
    (note: my form doesn’t collect names, but it would be best to collect them so you can help kids who have measurement errors).
  5. Setup a QUERY formula to find the circumference/diameter for each entry.
    =QUERY(B2:C1000, “select B/C”)
  6. Fix that pesky 2 in the Query formula after the first submission – when the first entry inserts a row, it changes B2 to B3.  Change it after the first entry and you’re good to go.
  7. Setup an AVERAGE formula to find the mean of the circumference/diameter calculations.
  8. Project the spreadsheet as entries are recorded.  See what your kiddos notice about the numbers they see on their screen!