Activity: Forms for Data Collection

    Create a form for collecting data. Examples include:

Mock up a "proof-of-concept" to illustrate something you might actually implement.

Send the "live form" link to colleagues so they can fill out your form.

Share the results with colleagues or publish them as a web page.

Optional: Create (and publish) charts of the results.

'Extra Credit' Activity: Create a self-grading quiz! (Time permitting)

          In a small group, create a three question quiz using a Google Form.

Solicit sample answers from other participants.

Create an IF formula for each question to "grade" the question. (Each IF formula needs to be in a new column.)

Fill Down so that the IF formulas you've written can "grade" all the responses at once!

Advanced: Create a SUM formula to total up the total score for each person that took the quiz. Then create another formula to calculate the percentage. Finally, create a nested IF formula to convert the percentages to letter grades!

          BONUS: Using Google Docs and Forms on a Mobile Device

                Accessing your Google Docs on a Mobile Device

                Completing a Google Form on a Mobile Device

More Sample Uses of Google Docs Forms (for Administrators)

Sample Forms (and Spreadsheets) Used By Administrators:

Resources for Administrators Using Google Forms (from GCT Jason Borgen at

Additional GCT Resources for Administrators:

Form Templates  used in R.S.U. #19.

If you are logged into your Google Account, these form templates will automatically copy into your Google Docs Dashboard. 

Many of the forms are designed to work with an iPod Touch. For more information about educational uses of that device, go to

Test and Quizzes

Administrative Forms 


Don't miss the fantastic templates provided by Todd Roth.