Google docs Spreadsheets added a new feature recently that dramatically enhances the application of this tool for education. You can Create a Form associated to a spreadsheet; publish or email that form; and when a person (one of your students) fills out the form, the data is automatically added to the spreadsheet it is associated to. Let me show you a sample and then the step by step instructions on how to do it. - Submit the answer to the question using the form.
- Reload the page.
- In a few minutes you will see your answer in the spreadsheet published below.
Sample
Instructions
Sign in to your Google account.Navigate to the documents section. Create a new Spreadsheet document.
 Save the document, giving it a name and click the share tab.
 In the share options, select: "to fill out a form"
 Click on the "Start editing your form..." button.
 Enter a Title and some instructions. Create the questions, choose the kind of question it is. and click "Done".
Add questions to the form by clicking the "Add a question" link. Remember to add a question for your student's name.
When you are finished, click "save" and close the window.
 Back in the share options, make sure you give permission to everyone to view the spreadsheet.
Copy the spreadsheet address displayed in the share options.
 In your webpage, insert a new spreadsheet form.
Paste the spreadsheet address. Remember you copied this address form the spreadsheet share options page.
If all the steps are complete you will see the form published on your webpage ready to receive information.
| 
