This course will cover all aspects of creating and using Google Forms. We will show you how to create forms, apply templates, share forms, embed forms and display form results. We will then look at how forms interact with Google spreadsheets. We will conclude with a show-and-tell of some spreadsheet techniques from Google Spreadsheets Advanced to get the most out of form data. Such techniques include parsing strings of data from checklist questions, auto-summarizing data, re-arranging or displaying only portions of data, and creating summary cells that will auto-email you when certain circumstances occur with your collected data.
Why Google Forms?
Are you currently using a spreadsheet to track information sent to you by other people? How are you inputting this information into your spreadsheet? Do they email it you and you copy-paste? Thats a lot of redundant work. Do you have people enter the info themselves into a shared spreadsheet? This is a real issue because people can easily mess up your spreadsheet or misenter the information. Solution: Google Forms. You can create custom forms with all different types of data entry: text, multiple choice, drop-down menu, checkboxes, scale, grid. The form can be embedded into an email, embedded into a webpage, or simply sent to people as a link. When a form is filled out the data can be automatically entered into a spreadsheet. The time savings are instant and everyone is happier!
Basic Question Types
- Paragraph text
- Multiple Choice
- Choose from a List
Adding, Duplicating and Deleting Questions
Re-ordering Questions and selections within Questions
- Settings within confirmation page.
Send / Post the Form
- Send Via Email Using the Send Form window
- The Link to Share
- Embed a Form into a Webpage
- Viewing the Summary of Responses
- Choosing the Form Response Destination
Pre-populate form responses
Creating a Complex Form
Advanced Question Types
- Section Headers
- Page Breaks
- Go to page based on answer
Creating a Form from a Spreadsheet
Tips on Manipulating Data in a Google Spreadsheet
- Considerations when creating forms
- Analyzing data in Google Spreadsheet
Applications of Forms with Google Apps Scripts
10 business days cancellation or full course fee will be charged
TTC, B-11 Cameron Library
11320-89 Avenue, University of Alberta