Google Docs and Forms

    Google Docs is a very powerful resource that all teachers should be aware of. This tutorial will show you how to use Google Docs to create a form. This form will automatically aggregate data and sort it. It really is amazing.

1. Go to docs.google.com

2. Log in with your HCA username and password. An opening screen should look similar to this:

3. Click on the Create Link and Select Spreadsheet

  

4. A Spreadsheet will open, go ahead and rename it and copy Row 1 with the following input: name,occupation,number of years, Subject taught, Favorite subject, Favorite Student.

5. Go to Tools and click "Create a Form"

 

6. A window will pop up:

 

7. Fill in the appropriate data in the shaded box. One thing to note:

If you select "require Heritage Christian Academy sign-in to view this form" only HCA members will be able to view and input data. This is useful if you want only the HCA community to respond. 

8. Right click and copy the blue link in the black region at the bottom.

9. Paste that link into an email or on your website or blog. Users will click that link to fill in your form.  If you get an error that says Google cannot access that URL than you are not signed in to your HCA account or you have "require HCA sign-in" clicked (see section7).

10. Fill out some data to test.

11. Your responses will automatically be placed into your Google Docs spreadsheet.

    

12. As a teacher write down some applications of this tool in the comment section.

Thanks

-Mr. Brenchley

Emergent Technologies Librarian