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

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.

Don't Fear the F Word — Google Sheets 101

,

Presenters

Session description

Purpose & objective

Outline

Supporting research

Session specifications

People also viewed