Powerful Assessment Data Dashboards with Google Data Studio
Participate and share : Poster
Learn how to take a spreadsheet and use it to create a powerful, interactive dashboard within Google's free Data Studio data visualization tool. Learn the essentials — tables, scorecards, bar graphs, pie charts and filters. A sample spreadsheet will be provided. No coding knowledge needed!
|Audience:||Coaches, Curriculum/district specialists, Principals/head teachers|
|Attendee devices:||Devices required|
|Attendee device specification:||Laptop: Chromebook, Mac, PC
|Participant accounts, software and other materials:||Attendees should have a Google Account, and access to drive.google.com as well as datastudio.google.com.|
|Topic:||Assessment/evaluations/use of data|
|ISTE Standards:||For Coaches:
Teaching, Learning and Assessments
Participants will be able to turn confusing and difficult to read spreadsheets into easy to understand, interactive, and fun data dashboards.
Participants will create a tool that they can share with key stakeholders to easily interpret and act on school assessment data.
Introduction (10 minutes): Who I am, what my dashboards look like, and how they have been used to improve teaching and learning at my school.
Gather resources (5 minutes): Participants will use a qr code or a bit.ly link to access my sample Google Sheets spreadsheet data. They will copy this Google Sheet to their personal account.
Google Data Studio Orientation & Import (10 minutes): Participants will be introduced to Google Data Studio. I'll show off the major feature and demonstrate how to navigate everything that they will need to know. They will also learn how to import their Google Sheet data into Data Studio.
Dashboard Creation (25 minutes): Participants will learn how to set up the key features of an assessment dashboard, including tables, filters, pie chart, and bar graphs. They will learn how to make these elements interactive, and how to adjust the formatting to create an attractive dashboard.
Close (5 minutes): I will share my contact information as well as some free online resources for participants to refer to as they continue their dashboarding journey.
Driven by Data: A Practical Guide to Improve Instruction
by Paul Bambrick-Santoyo