Google Sheets for Data Dashboards - Forum for Excellence 2020 - Workshop Agenda

Sep 12, 2026

A workshop agenda centered on using Google Sheets to build data dashboards that improve workflow visibility and support evidence-based decisions. The session outlines core values such as growth mindset, continuous learning, and learning-first technology use, then walks through four practical dashboard use cases: staff/student workflow, item analysis, retention tracking, and transposing survey results. It also provides resources for ongoing training through courses, conferences, communities, and digital literacy tips for getting started.

LanguageEnglish

CategoryPresentations

FormatPDF

Pages19

Reading Time7 min

AccessFree to download

Workshop Agenda

Values guiding today’s presentation

Four use cases with data dashboards in Google Sheets

How to continue learning after today

Forum for Excellence Using Google Sheets to Create Data Dashboards [teachjoey.com](teachjoey.com) How are you doing? Reply at [bit.ly/excellenceforum](bit.ly/excellenceforum) Joey Lehrman Program Eﬀectiveness Coordinator Adult Education at Delgado Community College SkillRise Project Manager International Society for Technology in Education (ISTE) [teachjoey.com](teachjoey.com) @joey lehrman Workshop Agenda ● Values guiding today’s presentation ● Four use cases with data dashboards in Google Sheets ○ Staﬀ/student workflow dashboard ○ Item analysis dashboard ○ Retention dashboard ○ Transposing survey results ● How to continue learning after today All materials available [at](at bit.ly/COABEsheets)[ ](at bit.ly/COABEsheets)[bit.ly/COABEsheets](at bit.ly/COABEsheets) Values Guiding Today’s Presentation ● Lifelong learning-let’s be ready to see what’s POSSIBLE today so we can learn more tomorrow. \#growthmindset ● We are all teachers, we are all students-let’s connect online so we can continue learning from each other. ● Done is better than perfect-we can spend ALL DAY exploring apps, learning new features. Build it now, then get feedback and continuously reflect to improve. ● It’s never about the technology-it’s always about the learning.(the technology can greatly enhance access and quality of learning) Continuous learning! Resource How to use it Collins School of Data Free 30-day “challenge” class to get started with core Sheets functions and features Google Certified Educator, Level 1 and 2 Help students and staﬀ build new edtech skills! SheetsCon Free, 2-day conference on all-things Google Sheets (register now to watch any session on-demand) Google Sheets on Facebook Community of practice-post questions! Google Applied Digital Skills Curriculum Free, video-based tutorials on dig lit skills On YouTube ● Flipped Classroom ● Learn Google Spreadsheets On Twitter ● @AliceKeeler ● @JakeMillerTech A few digital literacy tips and tricks to get started ● Create new Drive files with .new ○ [sheets. new](sheets. new) ○ [forms. new](forms. new) ○ [slides. new](slides. new) ○ [docs. new](docs. new) ● Access any app with subdomains ○ [sheets.google.com](sheets.google.com) ○ [forms.google.com](forms.google.com) ○ [drive.google.com](drive.google.com) ○ [calendar.google.com](calendar.google.com) ○ [keep.google.com](keep.google.com) ○ [mail.google.com](mail.google.com) ● Learn how to split your screen ASAP! \#GoogleIt Why am I here? Technology can increase access and impact. When we published a Form. . . ● Received over 500 registrants in under a month ● Creating the OPTION to register online is a great way to increase awareness and expand access Use Case 1 The Workflow Dashboard

FAQs

What principles guide the workshop session on Google Sheets dashboards?

The workshop emphasizes lifelong learning, connecting online to learn from each other, building first then improving with feedback, and focusing on learning rather than technology.

Which four data dashboard use cases are covered?

The agenda covers a staff/student workflow dashboard, an item analysis dashboard, a retention dashboard, and transposing survey results.

What resources are suggested for continued learning after the workshop?

The materials point to options such as a free 30-day Sheets challenge class, SheetsCon, Google Sheets Facebook community practice, and video tutorials plus further learning on social platforms like YouTube and Twitter.

Sep 12, 2026

Upload by Lucas Vance