Google Tools to Improve Your Workflow: Google Sheets, Forms and Calendar

Learn how to improve your workflow with Google Tools! In this four week online course, we will explore Google Calendar, Google Forms and Google Sheets. We’ll learn the basics of these tools as well as lots of tips and tricks that will keep you more organized and efficient. Completion of the Google Tools to Improve Your Workflow: Google Drive and Gmail  workshop is not required to take this course! 


Course Details

Audience Teachers, Administrators, School Staff 
Level Beginner/Intermediate
Instructor Margaret Peixoto
Dates May 22, 2020 to June 22, 2020
Earn 16 hours of certificate of participation
Location Online
MassCUE Member Cost $150
Non-Member Cost $190
Limit 20 Participants
Graduate Credit   At the first class, participants may choose to register for 1 graduate credit through Worcester State University for an additional fee of $125. All participants, including those who do not opt for graduate credit, will receive a certificate documenting the number of course hours attended.

Margaret Peixoto

Margaret Peixoto taught high school math for six years at Bishop Feehan High School. She is currently the Learning Commons Director at BFHS and teaches AP Seminar and online SAT Prep. Margaret earned her undergraduate degree in Mathematics from Villanova University and her Master’s Degree in Secondary Education from Providence College.  She holds her Innovative Educator Certificate, Leading Edge Certification for Online and Blended Learning and loves learning new things to improve her work in the classroom.  She provides professional development for Bishop Feehan High School, MassCUE and Framingham State University.  Margaret is enthusiastic about helping teachers reflect on their teaching and integrate technology into their classrooms.




Weekly Outline:

This course will follow this general outline but will be tailored to the needs of the participants. A survey at the beginning of the course will ask participants to share their current tech usage and comfort level as well as their tech needs so that the instructor can create offer modules that best fit those needs.  

Online Session 1: Google Calendar 

Learn the basics of Google Calendar, including how to create events, edit event settings, and add guests. Learn how to organize your calendar and set reminders so you never miss a meeting! 

Online Session 2: More Google Calendar 

Learn ways to streamline and organize your tasks by adding agendas from Google Drive to events, creating appointment slots, sharing appointment calendar, and adding new calendars. 

Online Session 3: Google Forms & Google Sheets 

Learn the basics of creating and sending Google Forms. Learn the basics of finding and sorting responses in Google Sheets. 

Online Session 4: More Google Forms & Google Sheets 

Dive deeper into Google Forms & Google Sheets by learning how to use formulas to move responses to new tabs or spreadsheets.  

Project Description:  

Educators wishing to receive one credit from WSU will create a screencast tutorial demonstrating their understanding and use of the skills and strategies learned OR create a lesson plan in which they teach students the workflow skills from one of the tools. 

This course supports the following Massachusetts Digital Literacy and Computer Science standards:  

Identify the importance of keeping personal information (e.g., name, location, phone number, address, school, etc.) private. 

Identify the importance of keeping personal information (e.g., name, location, phone number, address, school, etc.) private. 

Use a variety of digital tools to exchange information and feedback with teachers and other students (e.g., e-mail, text messaging). 

Operate a variety of digital tools (e.g., open/close, find, save/print, navigate, use input/output devices). 

Explain that computers can save information as data that can be stored, searched, retrieved, and deleted. 

Navigate between local, networked, or online/cloud environments and transfer files between each (upload/download). 

Perform searches to locate information using two or more key words and techniques to refine and limit such searches. 

Write an algorithm to solve a grade-level appropriate problem (e.g., move a character/robot/person through a maze, instruct a character/robot/person to draw a specific shape, have character/robot/person start, repeat, or end activity as required or upon a specific event), individually and collaboratively. 

Detect and correct logical errors in algorithms; written, mapped, live action, or digital. 

Utilize a database, such as a spreadsheet, to collect, organize, graph, and analyze data to answer a question. 

Identify and discuss the technology proficiencies needed in the workplace, as well as ways to prepare to meet these demands.  

Develop and conduct an online survey, individually and collaboratively. 

Collaborate synchronously and asynchronously through online digital tools (e.g., not necessarily in the same time and place).  

Perform advanced searches to locate information using a variety of digital sources (e.g., Boolean Operators, limiters like reading level, subject, media type). 

Sign Up for This Workshop

Google Tools to Improve Your Workflow: Google Sheets, Forms and Calendar
May 22, 2020 to June 22, 2020 
Four online weekly sessions

Register Now
Print this post Print this post