Category: data coaching

Create a great STEAM program with Data Studio

Create a great STEAM program with Data Studio ES STEAM Dashboard

A big thank you to Kelli Buxton (@KelliBuxton) for the historical information about the technology team. A Bit of History A number of years ago, Singapore American School rolled out a one to one iPad program in the elementary school.  With nearly 2000 students in the elementary school, this was quite a large task to […]

Give Teachers Access to the Data They Need

Give Teachers Access to the Data They Need

Google Data Studio for the win! Over the years, I’ve done a lot of work with data visualization through the use of Google Data Studio.  I love Data Studio, or DS, or GDS, because it syncs very quickly with Google Sheets, a csv file, or tons of other connectors.  GDS is mainly used by people […]

I want to share my data, but it’s private. Now what?

I want to share my data, but it’s private. Now what? I want to share my data, but it’s private. Now what?

Have you ever wanted to share an example of a spreadsheet or dashboard with someone else but you were worried about having them see the real data because of privacy issues? Many times, I need to create a sample data set, but still keep the integrity of the actual data. I’ll show you a few ways to quickly create sample data sets to use in Google Sheets or Google Data Studio.

Efficient Spreadsheets for Teachers: Automatically Highlight What Cells Look Like

Efficient Spreadsheets for Teachers: Automatically Highlight What Cells Look Like multi school dashboard

Automatically highlight your data with Conditional Formatting! Here are a few ideas basic ways to get started. There is also a custom formula for advanced users!

Efficient spreadsheets in the classroom – Split & Combine Names

Efficient spreadsheets in the classroom – Split & Combine Names

In this article I will show you a way to combine data from more than one cell and put it together into a single cell. I will also show you how you can break apart data in a single cell across multiple cells.

Efficient Spreadsheets in the Classroom – Cell Referencing

Efficient Spreadsheets in the Classroom – Cell Referencing

What are spreadsheets again? In my last article I talked about the basic layout of a spreadsheet.  I also mentioned a few of the most common uses for teachers and educators.  Based on my experience, teachers have used spreadsheets primarily for the following: 1. Lists:  tasks, items in an inventory, birthdays, emails, attendance 2. Grades: […]

Efficient Spreadsheets in the Classroom – Helpful Tips for Teachers

Efficient Spreadsheets in the Classroom – Helpful Tips for Teachers

This is the first part in a series on beginner tips for using spreadsheets to help teachers be more efficient in the classroom. Common Digital Tools Teachers understand Google Docs & Google Slides, but not so much with Google Sheets. Word processing documents, presentation software, spreadsheets.  As teachers, these are digital documents that we use […]

Building A Foundation for Strong Data Culture in Schools

Building A Foundation for Strong Data Culture in Schools

Building A Foundation for Strong Data Culture in Schools Overview Collaboration, communication, creation, workshops, conferences, professional development. These are all concepts that go hand-in-hand with teaching. Teachers are used to workshops and conferences where they are able to connect with other educators on current best practices in education. These opportunities allow them to improve on […]

Scroll to Top