Take Your Data to New Heights With Google Tools

Purpose & objective

Purpose: The purpose of this session is to show attendees the ease of using Google Form to collect and use data. It is also to show the different things they can do with Google Forms to help with individual students IEPs, Evals, and working with classroom stakeholders to make data-driven decisions. Additionally how Google Data Studio can be used to create dashboards and searchable databases so the data can be used to make informed decisions.

Objectives:
1. The participant will be able to make Google Form templates to share with others in the district.
2. The participant will be able to create lesson plans using Google Forms.
3. The participant will be able to create IEP and/or Evaluation collection tools in Google Forms
4. The participant will be able to use branching to differentiate as needed using a Google Form.
5. The participant will be able to use Google Sheets and the add-on Autocrat to work with the data more easily.
6. The participant will be able to create a searchable database in Data Studio
7. The participant will be able to share their creations with their district.

Evidence of Success:
-Editing of the Google Form the presenter will share with participants
-Evaluation of session
-Participant participation
-Participants will be able to use Google Forms to collect data applicable to their role and district
-Participants will be able to use Google Data Studio to report and share data applicable to their role and district

Outline

Below are two different timelines for the creation lab. During each of the presentations, the presenter will use live demonstrations, participant activities, and peer-to-peer interactions to keep the presentation engaging.

90-minute Deep Dive Creation Lab (requested by participants of ISTE Live2020)
Introduction to presenter, session goals, and success tips - 3 min
Google Forms for Lesson Planning - 5min
Google Forms for SpEd Forms, IEPs, and Evaluations - 10min
Google Forms for Data Collection - 5 min
Google Sheets useful formulas - 10 min
Autocrat process - 10 min
Data Studio Database - 10 min
Participant creation time - 35min
-Presenter will circulate the room talking with participants and assisting in creating Google Forms, Sheets, Autocrat Processes, and Data Studio Reports.
Final wrap up - 2 min

60-min Exploratory Creation Lab
Introduction to presenter, session goals, and success tips - 3 min
Google Forms for Lesson Planning - 5min
Google Forms for SpEd Forms, IEPs, and Evaluations - 5min
Google Forms for Data Collection - 5 min
Google Sheets useful formulas - 5 min
Autocrat process - 5 min
Data Studio Database - 10 min
Participant creation time - 20min
-Presenter will circulate the room talking with participants and assisting in creating Google Forms, Sheets, Autocrat Processes, and Data Studio Reports.
Final wrap up - 2min

Supporting research

http://www.teachhub.com/technology-classroom-how-use-google-forms

https://www.cyberacoustics.com/education/Blog?archives=04-07-2017&title=Tech-Tip-The-Benefits-of-Using-Google-Forms-in-Education%25C2%25A0%25C2%25A0

https://er.educause.edu/articles/2011/3/using-google-forms-for-student-engagement-and-learning

http://ditchthattextbook.com/2019/01/11/40-innovative-ideas-for-using-google-forms-in-your-classroom/

http://ditchthattextbook.com/2016/09/12/the-magic-automatic-lesson-planner-with-google-forms/

https://nces.ed.gov/pubs2017/NFES2017016.pdf

https://www.amazon.com/Hands-Google-Data-Studio-Citizens/dp/1119616085