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 beginner and intermediate data users with some experience in Google Sheets or Excel. Some background knowledge of what SQL is will help, but is not required.
Participants are required to bring a laptop and charger.