Creative
Constructor
DigCit
Connect
Leadership
Exchange
Edtech Industry
Network Summit
Edtech Advocacy &
Policy Summit

Take Your Data to New Heights With Google Tools

Change display time — Currently: Central Daylight Time (CDT) (Event time)
Location: Room 343-4
Experience live: All-Access Package Year-Round PD Package Virtual Lite
Watch recording: All-Access Package Year-Round PD Package Virtual Lite

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
  • Use technology to design and implement a variety of formative and summative assessments that accommodate learner needs, provide timely feedback to students and inform instruction.
  • Use assessment data to guide progress and communicate with students, parents and education stakeholders to build student self-direction.
For Coaches:
Data-Driven Decision-Maker
  • Support educators to interpret qualitative and quantitative data to inform their decisions and support individual student learning.

Proposal summary

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

More [+]

Presenters

Photo
Emily Thomas, Northeast Metro Intermediate School Dist
ISTE Certified Educator

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.

People also viewed

Future Ready Library Media Specialists Summit
Google for Education Adaptive Learning Lab
Tuesday Mainstage