Embedded Files
The information entered in a Google Form, when submitted, goes automatically into a Google [spread]Sheet. Once in the Sheet, the owner of the form/sheet can sort, filter, format, run formulas, create graphs etc. with the data.
Google Forms will also automatically format data into charts and graphs, based on the type of question. The owner can look at the results in spreadsheet format, in a summary format, and also individual record format.
What can I make with Google Forms?
What can I make with Google Forms?
Surveys: volunteers, special events, safety polls, opinion polls, birthdays
Directory lists: staff calling tree, emergency info, club membership
Databases: inventories, science observations and experiments, immigration maps
Registration data: volunteers, workshops, afterschool events
Maps: by country, by specific location, with annotations
Dissertation research: Likert scale, open response, demographics
Quizzes: multiple choice, automatically graded, optional feedback
Google Forms YouTube Playlist
Google Forms YouTube Playlist
Google for Education
Example Forms
Example Forms
Google Sheets
Google Sheets
GCF Learning Free Sheets tutorials, Getting Started video (2:29)
Google Sheets Help https://gsuite.google.com/learning-center/products/sheets/get-started/
Keyboard shortcuts
Line break in a cell: Ctrl/Cmd + Enter
To repeat the last action: Ctrl/Cmd + Y
To select multiple cells: Click on first cell, then hold Ctrl/Cmd, as you select the cells.
BONUS: Sheets & Forms plus Maps
How to build a custom Google Map Using Addresses in Google Sheets: You could collect addresses and other information via a Google Form!
How to make awesome interactive map using Google Sheets in under 1 minute? Use a form to collect data about cities, regions, or countries. Then create [multiple] choropleth maps from the data.
Report abuse