1 / 30

Geek out with Google Forms & Scripts!

Geek out with Google Forms & Scripts!. Katie Plunkett & Maria Lewis Charlottesville City Schools December 2012 http://goo.gl/MAhNU Edmodo code: 1nbivb. Agenda:. What are google forms? How can they help you in the classroom? Examples of a variety of different forms What is a script?

sherry
Download Presentation

Geek out with Google Forms & Scripts!

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Geek out with Google Forms & Scripts! Katie Plunkett & Maria Lewis Charlottesville City Schools December 2012 http://goo.gl/MAhNU Edmodo code: 1nbivb

  2. Agenda: • What are google forms? • How can they help you in the classroom? • Examples of a variety of different forms • What is a script? • Useful resources

  3. What are Google forms?

  4. Using forms in your school: • Teachers: • classroom activities, data collection, assessments • Administrators: • Data collection, Observations, Discipline forms, Anecdotal notes • Guidance Counselors: • Data collection, completing weekly/daily forms

  5. Creating a form: • Log in to your Google account & go to Google Drive. • Click on the Create button and choose form from the list. • Give your form a name and begin adding questions. • The form has two views: edit mode & spreadsheet mode. http://goo.gl/L5Jtk *Template gallery: http://goo.gl/Cu53D

  6. Here are some examples: • Classroom examples: • Parent Contact form: • http://goo.gl/ZhGmG • States and capitals quiz: • http://goo.gl/L5Jtk • Staff examples: • Technology survey • http://goo.gl/26ejg • Google Ninja Program: • http://goo.gl/JSARJ

  7. First Day of School activity: • Use as a way to get to know your students • Find out interests and ways they enjoy learning http://goo.gl/JHqRy

  8. Collect data for students to use: • Data collection for Science or Math projects • Collect information for your class and use in word problems • Find out what your students are reading http://goo.gl/74n3O

  9. Student response: Showing a video: • Use during or after a video • Students take notes and provide feedback for the teacher after class. http://goo.gl/ddEqX

  10. Data collection: Guided reading group • Easy way to collect data during or after guided reading • Simple record to use to refer to later http://goo.gl/egLbI

  11. Pre-assessment for a unit: • Find out what students know • Use data to create research groups http://goo.gl/5Zjv1

  12. Book Review & online reading record: • Find out what students are reading • Have a log to share with students and parents • Add short answer or discussion questions to the form http://goo.gl/ADfXr

  13. Student assessments: (group & lesson) • Lesson Review: • Gain feedback from students on a lesson. http://goo.gl/fw784 • Group Assessments: • Have students grade themselves & their peers. http://goo.gl/kwUrS • Exit Ticket: • Simple assessment for students on a daily basis. http://goo.gl/PdyKk

  14. Homework & Attendance Check: • Daily form to check homework, attendance, take daily grades http://goo.gl/lMgUj • After school program-Data collection http://goo.gl/BKP9L

  15. Classroom Examples: Administrators: • Observation Form: http://goo.gl/pKvwm • Discipline records: http://goo.gl/ENlM0

  16. Google Flip Packs • Uses Google presentations and forms to share information and see what students know. http://goo.gl/bGEqH

  17. Parent information: • Collect data & information from parents when they come to school. • PTO meetings • Back to School night • Content evenings (Math Night or Science Night) http://goo.gl/Bsbpr

  18. Ideas for using forms & templates: • Ideas for using forms: • Tom Barrett's: 85 ways to use Google Forms • http://goo.gl/IipvG • Colette Cassinelli: Google Certified Teacher • http://goo.gl/jPiBT • Google Template gallery: • http://goo.gl/Cu53D

  19. What is a script? • Scripts are a short code that you can include in Google apps that allows you to customize the google tools to work for you. • All done from within Google. http://goo.gl/mhHgJ

  20. Flubaroo: Quick & instant feedback • Script that will grade assessments quickly • Teachers and students like gaining feedback quickly • Use for formal & informal assessments: • Exit tickets • Check for understanding • Quick feedback tool & access to data • Quiz/Tests • Helpful video: • http://goo.gl/Pzwsr

  21. Flubaroo example: • CCS Google Ninja Program: • Staff professional development program used with quizzes for November PD. • Teachers worked through training materials and then took short quizzes. • Flubaroo script was used to grade assessments. • Try it out now! • http://goo.gl/KRplW

  22. Doctopus Written by an educator for educators, the free doctopus script gives teachers the ability to auto-generate, pre-share, and manage grading and feedback on templated Docs for group and individual projects. Start by creating a Google spreadsheet with student names and emails. http://www.youpd.org/doctopus

  23. formMule (aka "The Mule") • An automatic calendar booking system • Users add events/information to the system, notifies the manager and invites the requester to the event • Used by schools for facilities management, parent teacher conferences, equipment reservations, and discipline tracking. • http://www.youpd.org/formmule

  24. Google Snooze • Overwhelmed by email • Desiring a way to prioritize messages http://www.googleappscentral.com/blog/2011/07/what-is-gmail-snooze-and-how-to-use-it/ • Another option: Pause it! http://inboxpause.com/

  25. Save Gmail Attachment Directly into Google Drive http://ctrlq.org/code/19053-send-to-google-drive

  26. Gmail Meter http://www.gmailmeter.com/

  27. Gmail Merge http://googleappsdeveloper.blogspot.com/2011/10/4-ways-to-do-mail-merge-using-google.html http://www.youpd.org/autocrat

  28. Useful Resources: • Intro to Google Apps Scripts: • http://goo.gl/iojuq • Google Script Developers tutorials: • http://goo.gl/lZxwX • Google Education OnAir Hangouts: • http://goo.gl/HHWxz • Google Apps YouTube channel: • http://goo.gl/IezAa • Google Docs YouTube channel: • http://goo.gl/IbboL

  29. More useful resources: • edCode.org: • Open source development for educators--created by the maker of Flubaroo • http://www.edcode.org/ • youpd: • Great site with resources for online professional development and blended learning. • http://www.youpd.org/ • Phillip Martin Clip Art: • http://www.phillipmartin.info/clipart/homepage.htm

  30. Feel free to contact us with questions: • Katie Plunkett, ITRT • Katherine.Plunkett@charlottesvilleschools.org • Maria Lewis, Coordinator of Tech Integration • Maria.Lewis@charlottesvilleschools.org

More Related