Archive for October 7th, 2021

Google Data Studio: YCISL Skills Survey

Thursday, October 7th, 2021

I have been wondering how to create web dashboards and came across Google Data Studio. While learning how to use Google Data Studio, I played with visualizing the results from the YCISL Skills Survey. I aggregated the results from several YCISL workshops including two NIFTI programs, one ITW workshop and one YCISL Focus Group; there were responses from 107 students.

I will be starting the another NIFTI program next week and will update this dashboard when the survey results are in.

First, a few things I learned about using Google Data Studio:

  1. Collect GEO information. Google Data Studio includes a Google Maps chart which looks cool and would show the worldwide reach of the YCISL program.
  2. Try to eliminate chances for duplicate entries. I use Google Forms to do the survey and that is collected into Google Sheets. I manually moved data from each event’s survey to an aggregate Google Sheet from which Google Data Studio accesses data. I did this because I needed to clean out duplicates manually in Google Sheets.
  3. Include time stamp information. This allows Google Data Studio to display data from different time frames.

And now some observations about what I found through Google Data Studio:

  1. Students rated their Positivity skills very high at 4 or 5. This is a great indication of growth mindset.
  2. Students rated their Design Skills as average with most choosing 3. This suggests that we could discuss the meaning of “design” in the same way we discuss the broadness of “creativity” and “leadership” so every one feels that it is accessible. It was also interesting to see that design was the skill most students wanted to improve. Fits well with our programming on design thinking and design-build.
  3. There are also several students who rate various skills at 1 or 2. This could be an indication of no prior exposure or poor past experiences. Pushes our YCISL program to try to turn this around by creating memorable great experiences.

Looking forward to collecting more survey feedback and updating this dashboard.