[et_pb_section bb_built=”1″ admin_label=”section”][et_pb_row admin_label=”row” background_position=”top_left” background_repeat=”repeat” background_size=”initial”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” border_style=”solid” background_position=”top_left” background_repeat=”repeat” background_size=”initial” _builder_version=”3.0.51″ custom_margin=”-100px|||”]
Google Forms is one of the simplest tools to use to collect data and information but as they are connected to a spreadsheet (Google Sheet) they can be very powerful in terms of data analysis.
There are numerous uses for Google Forms but common ones are:
- Collecting feedback – questionnaire
- Signing up to an event
- Data entry – providing a more user-friendly interface
- Collecting opinions on a topic
- Collecting answers to a test
So how do they work?
1) Someone creates a form filled with questions.
2) That is linked to a spreadsheet (Google Sheet).
3) Someone fills out the form and submits in it.
4) The answers automatically arrive in the spreadsheet.
5) Each line of the spreadsheet is a response from someone.
Even without any analytical tools I can quickly see that in this example, for some this was their first session but not all; on the whole they liked the session; I have some tangible ideas on how to improve next time; and most want to see either grammar or skills in the next session.
As the responses are in a spreadsheet, they can then be analysed in a wide variety of ways and Google Sheets even provides an automatic summary of the responses.
To show the above, in the Google Sheet, go to Form>Show summary of responses.
So, how do you make them? See my post “Making a Google Form“.
[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row admin_label=”Row” background_position=”top_left” background_repeat=”repeat” background_size=”initial”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” use_border_color=”off” border_color=”#ffffff” border_style=”solid” saved_tabs=”all” global_module=”22296″ background_position=”top_left” background_repeat=”repeat” background_size=”initial”]
eBooks available on Drive, Forms, Sheets, Docs, Slides, and Sheet Functions:
- “Beginner’s Guide to Google Drive” – iBooks store / Kindle store
- “Beginner’s Guide to Google Forms” – iBooks store / Kindle store
- “Beginner’s Guide to Google Sheets” – iBooks store / Kindle store
- “Beginner’s Guide to Google Docs” – iBooks Store / Kindle store
- “Beginner’s Guide to Google Slides” – iBooks Store / Kindle store
- “Google Sheet Functions – A step-by-step guide” – iBooks Store / Kindle Store
Baz Roberts (Google+ / Flipboard / Twitter)
[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section]