Data Workshop Series: Google Sheets

TOPIC      Google Sheets- Querying and Dashboards

PRESENTERS     Po-yee Pang, DC International School

AUDIENCE     School Data Users (Preference will be given to LEAs)

DETAILS  Do you rely heavily on Google Sheets and want to learn some shortcuts? Then this might be the workshop for you. In this session, we will focus on various Google specific functions. We'll take a large data set and connect to other sheets where that data is being used again, so that it only ever needs to be updated in one place. We will also then take that data set and use the Google Query function to build out basic dashboards based on certain criteria. The session is designed for users with basic experience in Google Sheets and will review the most basic SQL functions as it applies to Google's Query function. We will practice with a sample data set, but feel free to also bring your own data sets to practice with.

The session is intended for intermediate data users with experience in Google Sheets or Excel. Data users should be able to comfortably use functions and formulas prior to attending. Some background knowledge of what SQL is helpful, but is not required.

Participants are required to bring a laptop and charger.

March 18th, 2020 9:00 AM   through   11:00 AM
Event Fee(s)
VSP $ 20.00
Other $ 50.00
Event Tags
Audience Targeted (L) - School Leader, (D) - Data Manager, (H) - Human Resources Manager
Subject Matter Data
Workshop
Strand Business, Operations and Compliance
Activity Workshop

Please let your friends, colleagues and followers know about this page by clicking a social button below or by sharing the following url:
https://www.focusdc.org/civicrm/event/info?id=447&reset=1