1 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Forms & Add ons

​

Google Education Trainer

2 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

https://goo.gl/VEe4Gi

Google Education Trainer

3 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

https://goo.gl/Bzd8M9

Please take this survey

Google Education Trainer

4 of 43

Survey Development

  • Start with the end in mind
  • Analytics
    • Discover meaningful data patterns and insights
    • How will your survey provide actionable information?
  • Cyclical process:
    • Reporting (data)
    • Analysis (numbers, trends)
      • Do the outliers materially affect the outcome?
      • If yes, throw them out.
    • Research (why these trends)
    • Recommendation
    • Remedy

​

Source: Harley Davidson Marketing - Insight, November 3, 2016

​

Google Education Trainer

5 of 43

Survey Development

​

  • What information will survey provide?
  • What are you doing with this data?
  • How much detail do you need to make decisions?
  • Vary the types of questions
    • Likert scales (how many points?)
    • Open-ended questions provide valuable information, but are more cumbersome to analyze.
  • Keep all surveys to under 5 minutes.
  • Only ask necessary questions
  • Use clear language.
  • Only ask one question at a time.

​

Source: Harley Davidson Marketing - Insight, November 3, 2016

​

Google Education Trainer

6 of 43

Survey Development

​

​

  • Explain key elements in introduction to survey
    • Don’t lie (about time, etc.)
    • Try not to use subjective words like “few”
    • Don’t overshoot expectations
    • Don’t overdeliver
    • Tell people what kind of information will be provided and what you will do with it.
  • Shift from stale, black and white, PC-language to language with a personality (HD - “surprise & delight”) - tone of voice

​

Source: Harley Davidson Marketing - Insight, November 3, 2016

​

Google Education Trainer

7 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

https://goo.gl/Bzd8M9

How did I do?

Google Education Trainer

8 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

Google Education Trainer

9 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

  • Add Question
  • Add Title
  • Add Image
  • Add Video
  • Add Section

Question format

Duplicate question

Google Education Trainer

10 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

Question format

Drop-down menu

Google Education Trainer

11 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

These question formats provide space for open-ended responses and comments.

Question Formats

Google Education Trainer

12 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

Question Formats

Choices can be images

“Breadcrumbs” = more options

Allows you to differentiate the form based on answer.

Google Education Trainer

13 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

Question Formats

Choices can be images

​

“Breadcrumbs” = more options

Unlike, multiple choice, more than one option may be chosen.

​

Google Education Trainer

14 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

Question Formats

Choices can be written (no images)

“Breadcrumbs” = more options

Allows you to differentiate the form based on answer.

Dropdowns are useful when you provide a long list of options with only one choice.

​

​

​

This also ensures proper formatting.

Google Education Trainer

15 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

Question Formats

Scale options from 0 to 10

“Breadcrumbs” = more options

Provide descriptors for low and high end of the scale.

Google Education Trainer

16 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

Question Formats

“Breadcrumbs” = more options

Choose number of rows and columns and add descriptors.

Google Education Trainer

17 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

Question Formats

“Breadcrumbs” = more options

Google Education Trainer

18 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

Changing order of questions

Use this to slide questions up and down.

Google Education Trainer

19 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

Forms Toolbar

Installed Add ons are here (Stay tuned!)

Change the appearance of

your form (colors and images)

Live Form view

Form settings:

  • General
  • Presentation
  • Quizzes

Google Education Trainer

20 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

Forms Toolbar

Installed Add ons:

  • Only installed Add on are here
  • Go to the “Breadcrumbs” to install Add ons
  • Stay tuned for suggested Add ons.

Google Education Trainer

21 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

Forms Toolbar

Format Form Appearance

​

  • Colors
  • Images

Google Education Trainer

22 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

Forms Toolbar

Shows the live Form

​

  • Never share the link to Form editor
  • Be sure to share the Live Form Link

Google Education Trainer

23 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

Forms Toolbar

Google Education Trainer

24 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

Forms Toolbar

Google Education Trainer

25 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

Forms Toolbar

Google Education Trainer

26 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

Forms Toolbar

Google Education Trainer

27 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Creating Google Forms

Forms Toolbar

Google Education Trainer

28 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Differentiated Forms

Go to sections based on answers

Choices can be images

“Breadcrumbs” = more options

Allows you to differentiate the form based on answer.

Google Education Trainer

29 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Differentiated Forms

Go to sections based on answers

  • Create a question that will send person to different “sections” based upon their answer.
  • Create sections to differentiate
  • Create questions underneath each section.
  • Map answers to sections (in original question).
  • Sequence form and submission (under each section).
  • Examples:

Google Education Trainer

30 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Where does the data go?

On the Form Editor

Google Education Trainer

31 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Summary of Responses

Google Education Trainer

32 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Summary of Responses

Google Education Trainer

33 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Summary of Responses

Google Education Trainer

34 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Summary of Responses

Google Education Trainer

35 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Google Forms

​

​

Add ons: formLimiter

  • formLimiter automatically sets Google Forms to stop accepting responses after a maximum number of responses, at a specific date and time, or when a spreadsheet cell contains a specified value.

​

  • Great for time-bound assignments, event registrations with limited seats, or other first-come, first-served sign up scenarios.

​

  • Example

​

Google Education Trainer

36 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Google Forms

​

​

Add ons:

Choice Eliminator

Form Notifications

​

  • Choice Eliminator will eliminate an option from a multiple choice, list, or checkbox question after user has submitted it.
  • Form Notifications allows users to create and configure email notifications that are sent when a Form receives submissions.
  • Example

​

  • Users can have emails sent to the creator of the Form and/or send short, customized reply emails to the Form submitter.
  • Great for signing up for time slots or having students choose topics without doubling up.

​

​

Google Education Trainer

37 of 43

Sort & Analyze Data

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Google Education Trainer

38 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Now, let’s analyze the data you provided in our survey to create an awesome table and sort the results. We’ll work on this site.

Google Education Trainer

39 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Awesome Table Set Up:

Here’s what you need:

  • Results of Survey or any Google Sheet with data & row 1 marked “CategoryFilter” for each topic that you want to sort. (Example)
  • A Google Site to display the table

​

Google Education Trainer

40 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Awesome Table

​

​

Set Up:

After you create a Site:

  • Edit the page
  • Insert: More gadgets
  • Search Public for Awesome Table

Google Education Trainer

41 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Awesome Table

​

​

Set Up:

Settings:

​

  • Be sure Sheet is set to “Anyone with the link can view”
  • Can sort by any column that you marked with “CategoryFilter”

Google Education Trainer

42 of 43

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Autocrat

​

​

Google Sheets Add on:

  • Automates the creation and sharing of personalized (e.g. merged) Google Docs or PDF email attachments from columns of data in a Google Sheet."

​

  • Example: Fill out THIS FORM

​

Google Education Trainer

43 of 43

Melinda Larson-Horne

​

​

Melinda Larson-Horne, EdTech/EE Coach

melindamlarson@gmail.com - @melindamlarson

Google Certified Innovator

Google Education Trainer