In this course, you will:

  • Set up a spreadsheet from scratch

  • Learn shortcuts to speed up formatting in Google Sheets

  • Learn advanced formulas to automate routine tasks in Google Sheets

  • Learn how to extract data from Google Calendar to Google Sheets

  • Build templates for collecting data year after year

  • Connect Google Sheets to Google Data Studio

  • Create Dynamic Dashboards in Google Data Studio

  • Use GDS Dashboards to monitor and evaluate your team’s work

  • Create line charts, stacked bar charts and more

  • Start anytime, learn at your own pace.

We will cover the following in this course:

  1. 01
    • The Why Behind the Work

    • Take a deeper look at your work

    • Activity: Tagging your work

    • Setting up Google Calendar

    • Google Calendar Settings

  2. 02
    • First things First: The Spreadsheet

    • Details Members and Images

    • Creating calMember Tabs

    • App Script Code

  3. 03
    • QMember Tab Setup

    • Query Data from calMember Tabs

    • Calculating our Queries

    • Calculating our Queries Part 2

    • Calculating our Queries Part 3

    • Combining Member Tabs in one place

    • Prepping the Data for Visualization Part 1

    • Spreadsheet formulas and what they mean

    • Prepping the Data for Visualization Part 2

  4. 04
    • Getting Started and Connected with Google Data Studio

    • Designing our Layout

    • Creating a Line Chart in GDS: Part 1

    • Creating a Line Chart in GDS: Part 2

    • Small Multiples Using a Table

    • Averages with Score Cards

    • Design Themes and Colors

    • Adding in Interactivity with Controls

    • Google Data Studio Introduction Quiz

  5. 05
    • Creating Pages and Navigation Menus

    • Detailed Charts Page

    • Stacked Bar Chart

    • Gauge Charts and Sparklines

    • Sharing our GDS Report

    • Google Data Studio Quiz 2

  6. 06
    • Course Completion Survey

From those who have taken the course:

“I loved how systematically the course material was organized! It was so easy to follow Chris' instructions for both Google Sheet Queries and Data Studio. And having access to sample data was immensely helpful - it allowed me to create my own dashboards as I moved forward in the course. This may sound trivial but one of my favorite parts of the course was Chris' attention to detail - the formatting tips will transform the aesthetic quality of my reports! Since this Datastudio course is set in an educational context, the learning was so transferrable - I was continuously making notes on what I wanted to share and build for my own school! I highly recommend this course for educators or anyone on Google Workspace who wants to begin visualizing data to make better decisions!”

School Director, Green Acres Academy

Radhika Zahedi

“Chris is meticulous in explaining the formulas and setup of the various tabs in his example spreadsheets. I love how the training is focused on individuals in the education field.”

Director of Information and Technology, Idaho Digital Learning Alliance

Ryan Gravette

“The workshop gave me the impetus to get started with Google Data Studio and visualize data that we have been collecting for years. I now have several projects in the pipeline where we will create actionable visualizations to improve teaching and learning.”

Vice Principal - Educational Technology, International School of Tanganyika

Declan Burke

What are you waiting for?

Sign up now

You will learn how to set up a spreadsheet and incorporate complex formulas for automation. You will also learn how to link your spreadsheet to Google Data Studio to create a functioning dynamic dashboard. By the end of the course, you will have learned skills through practical creation of a project you can use right away in your own work setting.

Instructor

Instructor Bio:

After being a classroom teacher for 17 years, Chris is now an educational data specialist and coach. He works directly with district administration, coaches, teachers and students. He currently serves on a data team and is in charge of the academic side of data collection. Chris is a Google Innovator, an Apple Distinguished Educator, and an Apple Professional Learning Specialist. He has a passion for making the lives of teachers easier by creating automated systems for mundane tasks. He is a life-long learner and continues to search for new innovations to allow both teachers and students to be creative. In his spare time, he enjoys curling up next to a good spreadsheet.

Chris Smith

Data & Innovation Specialist