Reflection 8: Let's Go Riding with Google Sheets

Before digging into my assignments for Module 7, I went mounting biking in Frazier Park with some good friends. I have not been able to get much weekend riding under my belt this Spring because I have been busy with work, coaching and grad school, so it felt good to get out on the trail and escape into the mountains for the afternoon.

For one of our assignments in Module 7 I created a short 30sec video (seen above) with the GoPro footage I shot while riding over the weekend, Mountain Biking with Michael Barcellos. It made me happy to have freedom with the content of the video short. I almost filmed my dog, Porter, but thought I would share a 30 second taste of a typical weekend for me. Especially since it was such a good weekend to hangout with my friends and spend time on adventure. Porter still had a good staycation with his best pal, Miles.

For the next two assignments, Part I and Part II, I used a Google Sheets to create two different projects. Part I is a Gradebook created from scratch (with detailed instructions provided by Kimberly Rubal), and the results were pretty remarkable. It's not like I reinvented the wheel, but I added new Sheets Functions to my arsenal of Functions in Google Sheets. In Part I I used several different functions to achieve data driven results. It kinda feels like I wrote a miniature AI machine that can help sort, organize and visualize data.

Part II is creative way to show other capabilities of Google Sheets, and its ability to sort information in various ways. I called it The Berries, because I used Sheets Functions that help me figure how many different variations of "Halle Berry" were in the Column A. Column B displays the unique spellings (or misspellings) of Halle Berry and Column C displays the number each unique "Halle Berry" from Column A.

Obviously, I enjoy mountain biking, but I also enjoyed getting back into Google Sheets, using Functions to sort, and visualize data. I like how this module paralleled with the introduction of IBM SPSS from my EDFN 5000 class. I like looking at data and especially designing for it too.