YOU can master Google Forms!
Google Forms is a simple tool for creating surveys and quizzes…right? Well, yes, but it can also be a powerful tool for creating automated systems to organize your classroom. This advanced course will reveal hidden features of Forms and introduce you to new tools to supercharge your use of Google Forms in the classroom.
This virtual course is for teachers, school administrators, and tech coaches, who want to collect and analyze data more effectively.
Are you…
- manually grading multiple-choice assessments?
- constantly copy / pasting information from one place to another?
- tracking lunch counts, attendance or other records data using paper?
- creating certificates, report cards, or permission slips one at a time?
- filled with dread when you need to open up a spreadsheet?
- having a difficult time keeping accurate records on student behavior and IEP implementation?
- Spending hours staring at spreadsheets and creating charts and reports?
…Then you need to start using Google Forms & Sheets!
In this course you will learn how to:
- Use Google Forms to organize daily classroom chores like attendance, lunch counts, permission slips, and behavior logs.
- Create personalized certificates from form submissons.
- Confidently add simple calculations to your spreadsheet data to quickly summarize order totals, volunteer hours, practice log minutes, etc.
- Help your students visualize data by creating dynamic charts that update automatically when new data is submitted through a form.
- Save time by creating automated systems that combine Forms, Sheets and add-ons
- Thwart cheaters by learning how to design quizzes that make cheaters sweat.
- Create Forms to collect parent contact information and organize parent-teacher conferences.
- Master powerful spreadsheet skills like data validation, VLOOKUP, pivot tables and more!
Google Forms & Sheets for Educators is a 5 module online course that will help you organize classroom data using Google Forms & Sheets. By streamlining and automating common, repetitive tasks you will have MORE time to connect with your students.
I will share my personal collection of Google Forms with you and help you design forms you can use in your classroom.
I will personally work with you throughout the course and will answer questions and provide personal feedback on a weekly basis. My goal for this course is to help you SAVE TIME by eliminating time-consuming processes.
Note: this is a intermediate course. It is recommended that you have some experience with Google Forms and Sheets (you don’t have to be an expert!) before taking this course. Not sure? Send me an email and I will help you decide if this course is a good fit for you!
Course Summary
- Start Date: April 11, 2022
- End Date: May 13, 2022 (suggested)
- Course Access: Google Classroom
- 5 hours of continuing education credit
- Skill: Intermediate / Advanced
- Includes 3 LIVE virtual sessions
- Cost: $99
- Register by CC or Purchase order
Hey friends! John Sowash here….I will be personally facilitating this course. You can ask me questions through Google Classroom and even join me LIVE during one of the three bonus sessions. I love working with teachers and sharing the lessons I learned by using these tools in my classroom! I hope you’ll consider joining me!
Course Outline
Module 1: Advanced Form Building Strategies
In this module, you will explore advanced features of Google Forms including as data validation and branching, add-ons, and form response “tricks.”
Everyone will have an opportunity to update or create a form that takes advantage of these form elements to improve a record-keeping activity.
Optional project: create a record-keeping form
Module 2: Creating Advanced Assessments
During this module we will explore advanced strategies for creating challenging and engaging questions such as matching questions, adding hints, creating adaptive assessments and using images and videos in quiz questions.
We’ll also discuss strategies for preventing cheating and making your assessments accessible to all students.
Optional project: create an advanced assessment
Module 3: Making Sense of your Data
Collecting information is easy; understanding what that information means and using it to take action is hard! This module will explore ways you can use the summary of responses in Google Form AND begin analyzing your data using Google Sheets.
Optional project: organize your data and build a graph
Module 4: Going Deeper with Google Sheets
Being able to confidently analyze spreadsheet data is an essential skill for all professionals. In this module we’ll begin explore more advanced applications for Google Sheets such as pivot tables, dava validation, VLOOKUP, and more.
Optional project: add calculations to your data and add a pivot table or conditional formatting
Module 5: Working with Add-ons
Being able to confidently analyze spreadsheet data is an essential skill for all professionals. In this module we’ll begin explore more advanced applications for Google Sheets such as pivot tables, dava validation, VLOOKUP, and more.
Optional project: create an automated system by combining forms, sheets, and add-ons.
In addition to the self-paced course content listed above, you will also be invited to join John Sowash for three LIVE virtual sessions that will further explore analyzing data with Google Sheets.
April 19, 2022
Organizing spreadsheet data
April 26, 2022
Introduction to formulas
May 3, 2022
Working with add-ons
All three LIVE sessions will take place from 4-5:30 PM EST via Google Meet. These sessions are optional and will be recorded for on-demand viewing.
Kind words from past participants
“One of the best courses I’ve taken due to its clear purpose and thoroughness and practicality of content. It was also conducted in a low-key manner without too much stress.” Theresa M Deriso, Technology Integration Specialist, Bristol, Rhode Island
“This entire course was very informative for me – I’ve never been the creator of Google Forms before, and really didn’t know how to use it effectively in my classroom. I left this course with a host of new knowledge, and a ton of ideas and things to think about.” – Annika Otto
“In the short amount of time we had with this course, it was one of the most efficient, well-organized courses I have ever taken online. John is a great communicator!” Mike Dallavalle, Teacher
“I enjoyed this course. Learning about the different add-ons was very valuable to me. I would definitely take another course from John! It was very informative, organized, and John actually answers emails with our questions!” Kristen Hodgkinson, Teacher, Pratt, Kansas
“This class was definitely helpful. One of the benefits was taking this course with other educators. I learned a lot from reading their thoughts and comments, too.” – Ashley Hufnagel
“One of the best courses ever! The section on analyzing data was especially helpful as I will be able to do less number-crunching by hand and let the charts do it for me!” Kimberly Peaslee, School Administrator
You might be wondering…
Can I earn continuing education credits?
Probably! This course qualifies for continuing education credits in many states. Check with your district to verify their requirements.
Michigan teachers: this course has been approved for 5 SCECH credits. Your PIC number will be collected at the start of the course.
Is this just another lousy online course?
I certainly hope not! I have worked hard to make this course practical and actionable. This is NOT an automated course. I will be participating in the course throughout the week; answering questions and personally working with the entire group. You can look at the testimonial section (above) to hear what others are saying.
I can’t take the course right now. Will it be offered again?
Probably. If you would like to be notified about future courses, click here.
How long will I have access to the course?
Forever! The course will remain accessible indefinitely, although after the end-date I will no longer be active in the course.
Can I pay by purchase order?
Sure! Visit the registration page and look for the PO option. Your school will receive an invoice for your course registration. A PO number is required before you can join the course.
Why are you charging $99?
Creating a quality online course requires a tremendous amount of time and preparation. I feel the price is reflective of the value that I am able to provide.
How much work is required?
You can expect ~60 minutes of content during each module. All assignments are optional; if it doesn’t fit your teaching style or classroom set up, skip it!
What equipment / tools will I need?
All of the tools mentioned in this course are web-based and will work on any Mac, PC, or Chromebook running the Chrome browser.
What if I have questions or get stuck?
If you have any issues or concerns, you can connect directly with me via email. My contact information is available in the “about” section of Google Classroom.
I’m not a “techie” person. Is this course for me?
Sure! If you are eager to learn, I am excited to work with you! Google Classroom is easy to use and I will be with you the entire time!
Do I have to do the activities?
Only if you want to! I hope that you will implement the ideas from the course into your classroom, but how and when you do so is up to you.
Are the tools mentioned in the course all free?
Everything I recommend in the course is either free or “freemium.” I never recommend a tool that requires payment in order for it to be used. The freemium products I recommend can be used successfully without a paid subscription.
