Change display time — Currently: Mountain Daylight Time (MDT) (Event time)

Don't Fear the F Word — Google Sheets 101

,

Explore and create: Exploratory Creation lab
Recorded Session
Virtual Session
Save to My Favorites

Presenters

Photo
Dr. Wanda Terral
Director of Technology
Lakeland School System
@wterral
@wandaterral
Wanda Terral, Ed.D., is a veteran educator who began her career as a band director. After teaching band for nine years, she moved into the world of instructional technology, first as a tech coach and, since 2014, as the director of technology for the Lakeland School System outside of Memphis. She’s a Google Certified Trainer and Innovator, co-leader of Google Educator Group Tennessee, and manages her district's Google Workspace domain. She earned her doctoral degree from the University of Memphis, focusing her research on self-directed professional learning for educators. Terral shares resources on IgnitionEDU.com and via social media.

Session description

Conquer your fear of spreadsheet "F"unctions and "F"ormulas. Get hands-on practice combining text functions into handy formulas that can be time-savers for any teacher. No spreadsheet experience required! Will focus on Google Sheets but most can be transferred to Excel.

Purpose & objective

Participants will be able to manipulate lists of text in Google Sheets using a variety of functions and formulas. Use of each function is demonstrated by the presenter while attendees are able to get hands-on practice through the use of a provided template. Throughout the session, the presenter will include common education-related scenarios where using these functions can be used. Attendees will be encouraged to share ways they can envision the functions being used in their own circumstances.

More [+]

Outline

Timing will vary based on the length of the length of the session. The bulk of time is spent in #4 and #5 on the list below.

1. Copy the provided template
2. Review basic spreadsheet vocabulary
3. How to build formulas
4. Basic functions for manipulating text
5. A few more complicated functions for manipulating text 6. Some useful formula recipes
7. Review resources for continued learning

More [+]

Supporting research

https://www.iste.org/explore/professional-development/5-ways-educators-can-get-more-done-less-time

https://kappanonline.org/time-teacher-learning-planning-critical-school-reform/

https://www.gse.harvard.edu/news/uk/19/09/gift-teacher-time

More [+]

Session specifications

Topic:
Online tools, apps & resources
Skill level:
Beginner
Audience:
Curriculum/district specialists, Teachers, Technology coordinators/facilitators
Attendee devices:
Devices required
Attendee device specification:
Laptop: Chromebook, Mac, PC
Participant accounts, software and other materials:
Attendees will need access to Google Sheets in order to be hands-on in the activities included in the session. Many of these skills can also be applied in other spreadsheet programs but examples included in the session are presented in Google Sheets. Attendees without a Google account or access to Google Sheets will still be able to view the resource.
ISTE Standards:
For Education Leaders:
Connected Learner
  • Develop the skills needed to lead and navigate change, advance systems and promote a mindset of continuous improvement for how technology can improve learning.
For Educators:
Leader
  • Model for colleagues the identification, exploration, evaluation, curation and adoption of new digital resources and tools for learning.
For Students:
Empowered Learner
  • Students understand the fundamental concepts of technology operations, demonstrate the ability to choose, use and troubleshoot current technologies and are able to transfer their knowledge to explore emerging technologies.

People also viewed

Empowering Student Voice through Problem Based Learning
Gobs of Goodies from Google (& Other Stuff that Plays Well with Google)
Graphic Design for Educators: Easy Ways to Create Engaging, Accessible Digital Content