Uses for Google forms...6 Ways to collect data using a Google Form
- Have students conduct experiment in classroom and one member goes to teacher's computer to enter data for that group
- Have students create surveys using Google forms and display on own
computer; students travel from machine to machine to fill out the
- Email the form to participants to collect data (can embed the form in the email); must know all members email addresses
- Email the form by using a distribution list from your contacts (very easy if using Google Apps since all domain names are the
- Share the URL of the published form; consider using a URL shortener for easy access like: http://goo.gl/, http://bit.ly/ or http://tinyurl.com/
- Embed the form in a Google Site, wiki, blog or Moodle.
More ideas ...
- Creative Ways to Use Google Forms (Presentation) - https://docs.google.com/presentation/d/1bHF-ZaXbJ1zjpNySsTepOT-6Sbihscbe_lXXesgPlPo/edit#slide=id.g1132e7f5_1_8
- Flipped Classroom Example - Watch Presentation and then use Form to check for understanding: https://sites.google.com/a/lghs.k12.ca.us/flippedclassroomexample/
- Pre-assessment in Math to see if students understand content before teaching https://spreadsheets.google.com/viewform?formkey=dDhTeTY5UHJuN1JOM1ZrTTRSdU91X3c6MQ
- 7th grade science teacher used to collect data on environmental issues
- 40 ways to use Google Apps in your classroom https://docs.google.com/presentation/d/1igbuSO-r38J5ngdGgAr70JoS0hOFAJ0qm5CN9WGYLmc/present#slide=id.i0
- Forms used for self grading quizzes
- Embed practice quizzes on a blog or website to give students additional practice before a big test. You find out right away their understanding of the material.
for work check, again with a Touch, teacher walks around the room,
selects student and score, the spreadsheet calculates the rest.
- Form for classroom behavior.
Evaluation Form. At the end of a workshop, I post a website address
and ask the students to complete the satisfaction form. See: http://tinyurl.com/5znk5x
- International Feedback: as a means of receiving input from people around the world during a webinar.
- Peer feedback on a science lab: http://spreadsheets.google.com/viewform?hl=en&formkey=cE9JVTNLME93UlZLUGFPQkZ6QUpzWFE6MA..
- Quiz on a lab: http://spreadsheets.google.com/viewform?hl=en&formkey=cE9JVTNLME93UlZLcWEyZjFLMEhMYVE6MA..
- Organize student research:
Grade 3: http://spreadsheets.google.com/viewform?key=pi_kLO4kTWrIfHHc7j289LQ&hl=en
Grade 4: http://spreadsheets.google.com/viewform?key=pi_kLO4kTWrK_Gq_GJi9aEQ&hl=en
Grade 5: http://spreadsheets.google.com/viewform?key=pi_kLO4kTWrIbAJS9n_SMMQ&hl=en
- 3-teacher class where we capture student progress. Includes auto-updating grading sheets and distribution charts:
- Contact Form that I sent out to students at the beginning of the
semester to collect all of their contact info in one spreadsheet.
- For our department to conduct an item analysis of our January
Algebra Regents results. We are only going to input the responses of
those students who failed this way we can see if any patterns develop
in order to help with the curriculum development for those teachers
teaching the regents review classes.
- Student Research: Students finding an abstract of an article and needing the full-text version:
- For peer editing of compositions. (can
be used with middle schoolers.The task is to get them to act as peer
editors, focusing on content, tone, grammar, spelling, etc.)
- Parent input for the IEP: https://spreadsheets.google.com/viewform?key=pH0bTGiH1G_6jjJWJYGy3Wg&hl=en
- Kern Kelly's Google Forms templates - includes self-grading quizzes, response to Literature form, Science Fair judging forms, and more!!! Excellent Resource https://sites.google.com/site/kernkelley/forms
- Homework turn in form (template) https://drive.google.com/previewtemplate?id=0AqA5QalhzshTdHBFN0JWS29FcHB4eVBtaUxWcFRicHc&mode=public
Google form ideas collected by Karl Fisch http://sites.google.com/site/ahsgform/
Examples of embedded forms:
Reference links from Google Help:
Creating, Editing and Formatting Spreadsheets
Sharing, Collaborating and Publishing
Working with Data
Uploading, Exporting, and Using Docs Offline
View a Screencast for making a self-grading quiz using Google Forms (thanks to Jesse Spevack) http://www.screencast-o-matic.com/watch/cjXeqwnDe
Google Spreadsheets Background Info
Google offers a spreadsheet as
part of its office tool suite. A spreadsheet helps you organize data in
columns and rows and can generate graphs using the data. Google
Spreadsheet has the added features of being stored online to allow
access from any online computer. Collecting data from multiples
users has always been quite the challenge. But now thanks to Google's
shared spreadsheets and forms - it's a snap! Just like Google Docs,
spreadsheets can be shared with anyone.
Here are some examples of how you can use Google spreadsheets:
* Collect names, addresses, and emails of group members or class parents
* Create a survey for opinions. votes, or preferences
* Collaborate with others for data collection (ie, fast food nutritional information, State facts, Historical data)
* Financial Planning or Budgeting
* Plan a project
* Collect and store student information
Before you start, decide how you want users to enter the data on a spreadsheet.
* If you'd like users to access the Google spreadsheet and add the data
directly on the spreadsheet, you can share the spreadsheet with them,
just like you can with documents. Note: If you do this, all data will
be visible to the user.
* You can email a form, and users can submit the data right from their email program.
* A user can link to the published form from a URL.
* You can embed a form into a webpage and users can submit the data from the embedded form.
You can create a new spreadsheet at http://docs.google.com
by going to New > Spreadsheet. This will open a blank spreadsheet
which you should name and save. Enter your titles, data, or formulas
and then click on the SHARE button to enter the email addresses of
those you want to collaborate. They will receive an email with a link
to be able to access the spreadsheet. This also allows for easy
collaboration through a chat window when two or more of the
collaborators are online at the same time!
Another option is to upload an existing Excel spreadsheet. Now you can access this data from any computer.
you would rather have the users enter the data into a FORM - go to New
> Form and you will see the beginnings of a web form. Add your
questions and choose the type of answer: text, paragraph, check boxes, multiple choice, choose from a list or Scale (1-n).
When done, save and then choose to "publish" the form (it provides a
long URL), "Email this form", or from "More Actions", get the embed
code to embed the form into a webpage, wiki, or blog.
users enter the data into the form and press submit, all of the data
will be dropped into ONE spreadsheet. This is an excellent way to
gather data from multiple users.
Example of peer evaluation form from HS science class