Creating My First Data Studio Report

I'm collecting data about the teachers in our district who have obtained Google for Education certifications, so I thought this would be a great time to (finally) learn how to use Data Studio. It's pretty awesome!

A few things I really like so far:

Controls

Adding controls makes filtering data SUPER easy. I know that filtering is possible in Sheets, but this seems so much more user-friendly. I have only tried the Drop-down list so far, so I'm curious to see how the other control work.

Image Theme

Extracting theme colors from an image saved me a ton of time. I usually use an add-on like ColorPick Eyedropper to match up colors. Now they're already built into the report!

Displaying Checkboxes

I had checkboxes on my original spreadsheet, and I really wanted to keep them on the data studio report (at least for now). However, the report was converting the checkboxes into TRUE and FALSE values. I did a quick Google search and found out that I could add special characters in the data validation settings to create the checkbox look.

My next step is to explore the different charts that are available! 📊

If you are looking for more ideas, check out this K-12 Data Studio Report Collection.

Comments

Create an Instagram Story!

One day on Twitter, I came across a tweet from Ryan O'Donnell ( @creativeedtech ) in which he shared a Facebook template that could be used for students to demonstrate their learning. I clicked on the link to his website , and I was AMAZED at all the cool templates he had created for teachers to use for free! I decided to try using an Instagram template during a unit on the planets in our solar system. I wanted students to demonstrate what they learned about the different planets, but I wanted them to do it in a creative way. Here are the directions I gave to my students: Here are some student examples: Student Example #1 Student Example #2 Student Example #3 Student Example #4 I really enjoyed this activity, and I love how students familiar with hashtags were able to create and use them in clever ways! If I was to go back and do this again, I would spend some time working with students less familiar with social media and hashtags and give them some...

First Week of School

We just wrapped up our first week of school! I really enjoyed meeting and getting to know our new 5th grade students! Here are some of the activities we did to start building our classroom culture and learn more about each other: "All About Me" Google Drawing Students learned how to use some of the basic features of Google Drawings by creating a Drawing about themselves. The basic requirements were that they include their name, a picture of themselves, and text/images that describe their personalities or interests. I created an example to give them an idea of what it could look like. I used this activity last year, and I really enjoyed what my students created. However, I decided this year to give them more time to just play with and explore the tools in Google Drawing. I feel like this really paid off because students were able to discover how to use some of the tools and share with each other instead of just relying on me to show them how to use it. ...

Don't Use Coaches as "Fixers"

"It is tempting to ask coaches to work only with teachers who seem to be having difficulties with instruction or classroom management. We discourage this "fixer" approach to coaching for several reasons. First, if coaches are perceived as working only with those who struggle, other teachers may not reach out to coaches for support. Second, the coaching relationship becomes less about providing support for all teachers and more about remediation, in which only "struggling" teachers are assigned to the coach." - Jacy Ippolito and Rita M. Bean Based on the conversations I've had with coaches, this seems to be a common challenge. Coaches often struggle to get teachers to volunteer for coaching cycles because teachers don't want to be viewed as someone who needs coaching - like it's a negative thing. However, the truth is that ALL educators can benefit from good coaching. I think this is why it is important to try to c reate a diverse coaching ros...

Roxi Thompson

Search This Blog