Don't Fear the F Word — Google Sheets 101
,
Presenters

Session description
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.
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
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
Session specifications
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.
Leader
- Model for colleagues the identification, exploration, evaluation, curation and adoption of new digital resources and tools for learning.
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.