Skip to main content

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

Popular posts from this blog

Virtual EdTech Coaching Sessions

  I'm really enjoying these virtual tech coaching sessions with teachers across our district! Here are some takeaways about coaching virtually: 🤝 Building relationships is still key to effective coaching. I try to look for things a teacher has on their desk or wall that I can see in the camera. This helps start a conversation about something meaningful to the teacher and starts our session on a positive note. ❓ Ask lots of questions rather than jumping in with a solution. I like to ask, "Can you please share your screen and show me how you would typically do/get to ____?" rather than telling them where to click right away. It helps me learn about how they navigate digital tools. 📧 Follow up the conversation with an email. I like to include a short video with a quick tutorial about something specific they talked about during the session. It helps demonstrate that I was actively listening and that I'd love to keep the conversation going and keep working together. What...

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.  ...

#ISTELive 21 - Day 3

Day 3 of ISTELive! I started my morning by listening to Leslie Odom, Jr. on the Mainstage. He encouraged leaders to give people permission to fail, described the positive impact of his 5th-grade teacher, and then he sang "Room Where It Happens"! It was an amazing Monday morning! 🤩 Later that morning I had a great time attending "Connect, Create and Collaborate: Edtech Coaches PLN Best Practices and Favorite Tools." I was super excited to  connect with other coaches, learn some new strategies, and hear about some helpful tools! One of the awesome things about ISTELive being virtual is that ALL of the sessions are being recorded. So, I was able to catch up on a session from the weekend called, "A Pandemic's Impact on Online Learning: A Panel." The panel members were  Michele Eaton ,  Diana Gill ,  Dr. Marcus Vu , John Watson, and  Claudio Zavala . They made some great points about choice, student self-efficacy, and the importance of collaboration when s...