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

Awesome Projects for January!

This week has been super busy! But it's that awesome kind of busy where I am working on multiple projects for January that I am SUPER excited about! Kinders on Chromebooks We are preparing for our 3rd Quarter EdTech session, and we are planning to include resources specifically designed for our K-2 teachers. We want to create videos in which we model strategies that K-2 teachers can use to help their students learn how to login to Chromebooks. My EdTech teammate reached out to the Kindergarten team at one of our schools, and they were kind enough to open their doors to us! We will be working with this team on the first day back from Winter Break in January. Our plan is for me to lead the first session while another EdTech team member records the lesson and assists students as needed. We will be sharing the video footage, along with other K-2 resources, with our teachers during our sessions throughout the 3rd Quarter. This week I am trying to build a Google Site th

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 more

Creating PD Choice Boards!

As the new EdTech and Social Studies Specialist, part of my job includes planning and facilitating professional development for our social studies teachers. Our main PD sessions take place once a month on Wednesdays when teachers are released early from their school sites. Leading these PD sessions was a part of the job that I was SUPER excited about when I first started. However, there are some challenges that I wasn't prepared for that have caused me to reflect and rethink the way I have been planning. Challenges 1) We have 32 schools in our district, and there are three different release times. To honor everyone's time and make sure teachers don't have to work outside of contract hours, we decided to have two different sessions with a half-hour of overlap time. I set up the activities in Google Classroom, number them, and include videos and directions so that teachers can work through them at their own pace when they arrive. However, some teachers have a d

Roxi Thompson

Search This Blog