Learn more about Forms

Creating and Using Google Forms Workshop

Forms in the Classroom Resources

An Overview of Forms

Watch: A Tour of Google Forms

Create and Customize Forms

• Create a new form

• Form question types

• Add and edit questions

• Format form appearance

• Allow respondents to skip or jump to different sections

• Provide respondents a custom form submission message

• Set default text and answer fields in a form

Collect Form Responses

• Send form via email

• Access the form with a URL

• Embed the form on a website

• Allow individuals to edit form responses

• Edit a submitted form response

• Automatically collect username

• Stop accepting form responses

• Set notification for new form responses

View Form Results and Share with Others

• Access form response spreadsheet

• Make changes to the form response spreadsheet

• Automatic summary of form responses

• Share automatic summary with others

• Share custom form results

Design and Deliver Quizzes and Tests

• Deliver quizzes and test online with forms

• Create and use quic template

• Tips for automatically grading quizzes

Structure Peer Reviews and Feedback

Check and Submit Assignments

Log Reports and Information into a Single Database

File and Track School-Wide Requests

Introduction to Forms in Google Docs webinar

Introduction to Forms in Google Docs

Skill level: Beginner

Lead by Sean Beavers, Google Apps for Education Certified Trainer

Google forms are one of Google Docs best-kept secrets. Using the power of forms, you can develop online surveys, workshop evaluations, and even impromptu quizzes; there is no limit to what you can create!

During the webinar we will cover the basics of creating a form, making it available for submission, and finding your data in Google Docs.

• Basics of creating a form

• Making your form available for others

• Finding your data

• Suggestions for use

Presentation Slides

Transcript

• Plan, Plan, and Write Your Form in MS Word or Google Docs

  • Consider what questions you're going ask; what data you need to collect; how best to collect that data; and how to make that form user-friendly, so that the people who are filling out the form understand what you're asking, why you're asking it, what you're going to do with it, and how they can help fill out the form.

  • Avoid adding superfluous questions; just ask the basics that you need to get the information you want, and ask it in the clearest way.

  • Put a description of the form at the top; tell the user what this form is about, how they should fill it out, and what you're going to do with their answers.

• Watch: Designing a Form in Google Forms - Plan Ahead

• 4 Steps to Creating a Form:

  • 1) Create

  • 2) Share / Collaborate on Building a Form

  • 3) Send / Publish a Form (Gather Information)

  • 4) Analyze the Responses of a Form

Challenge A - Complete a Form/Survey

• Fill out the Dinner Invitation

Case Study I: Simple Survey Responses (SurveyMonkey-esque)

• Survey for Respondents

• Survey Analytics for Author

Advanced Forms in Google Docs

Skill level: Intermediate/Advanced

Lead by Kevin Brookhouser and Tim Lee, Google Apps for Education Certified Trainers

Take your Google form skills to the next level. Learn how to harness the power of lesser known features in Google Forms that can save teachers time and organize a wide variety of student information and data. Learn how forms can be used within Google sites and other websites. Imagine never having to grade a quiz again.

This webinar will cover:

- Quick review of the basics of Google Forms

- Hidden features in forms

- Time saving use examples

- Self Grading Quizzes

- Troubleshooting and lessons learnt

Presentation

Q&A Transcript

Flubaroo Self-Grading Quizzes

• Create a new form

• Form question types

  • Text

  • Paragraph Text

  • Multiple Choice

  • Checkboxes

  • Choose from a List

  • Scale

  • Grid

• Add and edit questions

• Themes

• Copy-and-paste Bulleted List into a "List" or Multiple Choice Question

• Watch: Copy and paste a list — Google Forms

Share and Collaborate on Building a Form

• Google Forms Sharing Settings: Sharing a form with out having to sign in (screencast)

• Create a Self Grading Quiz using Google Forms

• Flubaroo- A Google Spreadsheet Script to grade tests and email results to students

Activity #1

• Fill out the Form

• Summary of Responses

• Results Spreadsheet

• Create a new form

• Parent Survey

• Exit ticket for class

• Show summary of responses

• Collaborative spreadsheet

• Branch Logic for Google Forms

Administrative Example: Submitting a Maintenance Request Form

• Pages

• The Three Parts of a Google Form:

  • a) Form Settings

  • b) Form Questions

  • c) Confirmation Page

• Form Settings:

  • Require The Blake School login to view this form

  • Automatically collect respondent's The Blake School username

• Confirmation Page:

  • Confirmation message

  • Show link to submit another response — Checking this box will allow users to submit as many form responses as they'd like

  • Publish and show a link to the results of this form — Checking this box will give respondents access to the form's summary of responses.

  • Allow responders to edit responses after submitting — Checking this box will allow respondents to change their answers to your form.

• Send form via email to participants.

• Reference: New Layout and Features in Google Forms

• Read: Forms Refreshed Google Blog Post

Challenge B - The Dinner Invitation (Evite-esque)

• Create a dinner invitation for a Blake Colleague and include:

  • Choose a Theme

  • Form Settings:

    • Require The Blake School login to view this form

    • Automatically collect respondent's The Blake School username

  • All questions should be set to be "Required."

  • Questions should include:

    • First Name

    • Last Name

    • Multiple Choice Question - What is your preferred night for dinner? (Hint: use copy-and-paste)

      • Friday

      • Saturday

      • Sunday

      • + an "Other" Date

    • List Question - Type of Entree? (Hint: use copy-and-paste)

      • Chicken

      • Seafood

      • Steak

      • Vegetarian

    • Grid Question - Favorite Type of Music? (Hint: use copy-and-paste)

      • Row:

        • Purple Rain by Prince

        • Blue by Joni Mitchell

        • The White Album by The Beatles

        • Kind of Blue by Miles Davis

      • Column:

        • 1.0 stars - Album that is consistently bad.

        • 2.0 stars - Album has equal amount of bad songs and good songs.

        • 3.0 stars - Album is unique, but underdeveloped.

        • 4.0 stars - Album is either completely perfect.

        • Never listened to this album.

  • Confirmation Page:

    • Include the address of the party; an email address and phone number for any questions.

  • View: An Example of a Dinner Invitation

  • Send form via email to the person on your right via email.

  • Once you receive the form from the person on your left, complete their dinner invitation. Ensure you select a "vegetarian" entree.

Part II. Share and Collaborate on Building a Form

• Branching Logic

  • Pages

  • "Go to page based on answer"

    • Submit Form

• Add Collaborators

• Note: When you share a Google form with a collaborator, you give that collaborator full editing access to the form. That collaborator will have the ability to make any changes they'd like to the form, including a change to where responses are collected.

• Workshop Lead will Collaborate on Adding a Question to a Form

• Watch: Add and Share your form with Collaborators in Google Forms

Part III. Send and Publish a Form

• Watch: Collecting Form Responses and Sending Invitations to Respond

• View live form

• Send your form to respondents via

  • Send Form via email: Email

  • Link to Share: Copy-and-paste the URL / Link

  • Social media: FaceBook, Twitter, G+

• Accepting Responses

• Delete All Responses

Challenge C - Submit Your Invitation to the Digital Inbox

• Open: Google Forms - Digital Inbox

• Fill out the Form. Copy-and-paste the URL of your Dinner Invitation

• View the results: Google Forms - Digital Inbox (Responses)

• Watch: How to Setup Your Own Digital Inbox

Part IV. Getting Going - Analyze the Responses of a Form

• Watch: Analyzing Form Responses using Summary of Responses and a Google Spreadsheet

• Three options:

  • 1) Summary of Responses

  • 2) Download a Summary of Responses as a .CSV (Comma Separated Values) which can be imported by MS-Excel, Apple's Numbers, and other spreadsheet/database applications

  • 3) Choose a Response Destination

• Note: You can choose either to send responses to a spreadsheet, or you can store them only in Forms. If you choose to store them in a spreadsheet, you’ll be able to see individual responses as they come in. If you choose to store them in Forms, you’ll be able to see a summary of all the responses you’ve received, and you’ll also be able to download the responses as a CSV file.

• Store Responses in a Spreadsheet (Choose a Response Destination)

• Note: Responses are One-Direction Only

  • Responses sent to a spreadsheet are essentially a copy of your responses and are only sent one way — form to spreadsheet, not spreadsheet to form. In other words, if you modify a response in your spreadsheet, you’re not changing the original response, which will show up in summary view or the CSV download.

• Enable Email Notifications to Alert You to New Responses

• Filter your data in Sheets

  • Watch: Sorting and Filtering in Google Spreadsheet

• Watch: Apply conditional formatting rules

• Notification Rules in Sheets

• Protecting sheets from being edited

• Watch: Named and protected ranges

• Watch: Protecting Cell Ranges in Google Spreadsheets

Challenge D - Highlight your vegetarian diners using conditional formatting.

• Send your responses to a Google Spreadsheet.

• (Ensure you have at least one response that includes a vegetarian entree.)

• In the spreadsheet, create a conditional formatting rule which highlights your vegetarian diners in the color yellow.

• Send form via email to the person on your left via email.

• Once you receive the form from the person on your right, complete their dinner invitation. Ensure you select a "chicken" entree.

• What do you notice in your responses? Did your conditional rule apply?

Case Study #2: Parent Association Volunteer Form (PivotTables)

• Volunteer Leadership form for participants

• Planning the Volunteer Leadership form (LucidChart)

  • Branching Logic

• Data from the Volunteer Leadership form (not publicly available)

  • Using Pivot Tables to Share the Data

  • PA Leadership Index (not publicly available)

Part V. Getting Geeky - Deep Dives into Analysis

• List View

  • Watch: Performing Queries in a Google Spreadsheet

• Pivot Tables

  • Report Editor

    • Be sure you select the correct Range. (Typically, I leave out row numbers since the form responses can grow exponentially to ensure all of the data is reported. I also expand the Column Letter to Z [or the last column letter.)

  • Rows

  • Columns

  • "Show Totals" - Unless I am preforming a mathematical analysis, I turn off "Show Totals"

  • Filter - Filter your data based on the appropriate critera

  • Values - Fields in the Values category can be sorted by functions like number, CountA, sum, and average. To change how data is sorted in your pivot table report, click the drop-down menu at the bottom of the a field in the Values category. Then, select how you'd like to sort your data.

  • "Update table on each change"

  • Once you have a pivot table report template, I duplicate the worksheet, adjust the filter, and rename the worksheet accordingly.

  • Watch: Summarizing Student Information with a Pivot Table

• • Watch: How to use Pivot Tables in Google Spreadsheets

Challenge E - Create a pivot table report the illustrates the number of guests for each evening.

• Create a 3 pivot table reports. One report should the the RSVPs for Friday, the second report for Saturday, and the last report for Sunday.

• What is the "Grand Total" of your RSVPs?

• Bonus: How many vegetarian meals do you need to prepare?

Part VI. Getting Geeky - Scripts Gallery

• Google Scripts Gallery

• Merge your Form into Google Mail

  • Using Mail Merge HD

  • Using the ValMerge Script

• Merge your Form into Google Documents using the AutoCrat Script

  • Overview: The autoCrat Script was written to be a multi-purpose document merge tool that allows you to take any personalized, row-based spreadsheet data and create, save, attach to email, and share templated documents.

Case Study #3: ISS Welcome Letter (MailMerge using MailMerge HD)

Case Study #4: LS Child Study (GoogleDocs using AutoCrat)

• Overview: The autoCrat Script was written to be a multi-purpose document merge tool that allows you to take any personalized, row-based spreadsheet data and create, save, attach to email, and share templated documents.

Case Study #5: LS Field Trips (Calendar using FormMule)

• Overview: The formMule (aka "The Mule") is a Google Apps script that is useful for automating lookups, emails and calendar events created dynamically from Google Forms.

Case Study #6: (using Doctopus)

• Overview: The doctopus script gives teachers the ability to auto-generate, pre-share, and manage grading and feedback on templated Docs for group and individual projects.

• Watch: Doctopus Demo

Case Study #7: (using Goobric)

Case Study #8: (using Flubaroo)

Take the Workshop Evaluation