We continue to find ways in which Looker Studio, formerly known as Data Studio, can be used to help visualize data differently. (NOTE: In the example provided, no student data is used). For years, our Athletic Director at the high school posts a monthly schedule of all sport practices, games/meets, team meetings etc that happen as to way to make sure that all athletes and parents are on the same page. But how can we make this schedule experience better? Welcome Looker Studio.
The athletics schedule had always been created in a Google Sheet. The community was given view access each month so that they can scroll through and find the events that pertain to them. The one missing element was being able to sort the data easily. This meant that users had to scroll through all of the events and hope that they didn’t miss a practice or a game. The athletic director would hide dates once they passed so that those events no longer showed to help with the view of the sheet; meaning that once a date happened, the row was hidden. Below is a gif showing what one calendar view looked like:
On this seventh day of Google, we will be taking a look at a couple of Google Sheet features.
Use spreadsheets from time to time? Google Sheets now allows users to have checkboxes in a column. It might seem like a small feature but in all honesty, it can be a great visual cue to know who has and has not done a particular task.
Craig M Sheil 