Take Your Data to New Heights With Google Tools |
Explore and create : Creation lab
Emily Thomas
The Google Tools of Forms, Sheets and Data Studio can take data from unmanageable to informative. This session will help you save time when collecting data, creating lesson plans, filling out IEPs, tracking goals and time, and even creating a searchable database for resources.
Audience: | Coaches, Curriculum/district specialists, Professional developers |
Skill level: | Intermediate |
Attendee devices: | Devices required |
Attendee device specification: | Laptop: PC, Chromebook, Mac |
Participant accounts, software and other materials: | Google Workspace (Google Docs, Google Sheets, Google Forms) Autocrat add-on (may need to be whitelisted by domain administrator) Google Data Studio (may need to be turned on by domain administrator) |
Topic: | Online tools, apps & resources |
Subject area: | Special education, Not applicable |
ISTE Standards: | For Educators: Analyst
Data-Driven Decision-Maker
|
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
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
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
Emily is a Technology Integrator and Trainer for Northeast Metro Intermediate School District 916, a former middle school German Teacher, and a Google Certified Trainer & Coach and ISTE Certified Educator. Throughout her time at 916, she has worked with staff and students to grow their instructional technology skills and meets everyone where they are at. Emily has presented at a variety of local, regional, national, and international conferences, both in-person and virtually. She uses her professional experiences, passion for technology, and drive to innovate student learning to inform and plan her training sessions, including one-on-one, group, and online.
Deep Dive With EduProtocols
Tech Tools To Support Classroom Instructional Strategies
The Fight for Inclusive Libraries