Google+Docs+for+the+Science+Teacher

Presenter: Danielle Gladfelter Time: 10:30 - 11:15 Room: Lab A Contact: Danielle.Gladfelter@dallastown.net

__Description of Presentation__

I use Google Docs in my classroom to share documents, publish presentations, and allow students to collaborate on documents. I also use Google forms to create quizzes to assess my student's understanding of topics. Google forms then provides me with data concerning each question asked so that I can match my instruction to the needs of my students. I will show participants at the workshop how to obtain their own account, sign students up, share and publish their documents, create quizzes with Google forms and analyze the results.

[|Sample Quiz created with Google Docs (forms)] [|grading template for google doc form quiz] media type="custom" key="3256812" width="76" height="61" Danielle shared what she is doing with google docs. Those who are also using google docs are welcome to share on this blog what they are doing with google docs in their classroom. Danielle's email is danielle.gladfelter@dallastown.net. Feel free to contact her if you have any questions. You must have a google account to go into the google tools. To create an account you just click on create an account at the main google page. Danielle has focused on documents. Users of google docs can create folders and keep documents organized. Using google docs is a great tool to use if you have a space limit in your district. Danielle can put items on google that she then doesn't have to take space on the district server drive so it gives her extra storage for other things without using up all of her allotted space. Documents can be uploaded to google docs. You can bring the document right from word or in the case of spreadsheets, Excel. Documents can be shared. **If you publish your google docs then each page is published as a web page and then you can put the link for your published page to your own teacher web page.** Forms can be created in google docs also by selecting the new option on the menu bar and then select form. The teacher can then title the form, create questions. Multiple choice, text, checkboxes, choose from a list, scale, paragraph text. Questions and responses can be create and reorganized after being created. When the students complete the form a spreadsheet will be automatically created showing all of the responses that students put in. Teacher was able to then take the data from her students. Danielle took her quiz first and locked her responses in place so that as she scrolled down through the student responses she was able to see how the students responded with regard to correct or incorrect answers. She then used the summary feature to see a summary of responses for each question and she could then use that data to make **Data Driven Decidions** about what her students were struggling with so that she could go back and review. She shared the summary data with her students so that they could see summarized responses. She then let the students go back and take the quiz again. This way of presenting information was good in that she was able to spend the review day actually reviewing the items that students were most struggling with.
 * Blogging**

Danielle eventually began to export her spreadsheet to excel by going to file, export and choosing .xls as the export option. There are many ways to export. She set up the excel worksheet column A B with Student first last name, then columns followed with student answers and then columns followed that included a formula if then statements to automatically score the student reponses. A copy of her grading template is provided on this wiki page. For more information contact Danielle at her e-mail.

If you have data in a google docs spreadsheet it can be copied into your own graphing program. Graphing in google docs is limited in the types of graphing that can be done. Danielle her her students data dumped into Logger Pro.

Danielle uses the web live link in google docs to link her google forms to her web site so that the kids can go to her web site, click on the link and then key right on the form.