Google Sheets Dashboards — David Getz Creative

David Getz is an educator from Illinois who is doing crazy awesome things with Google Spreadsheets to track the progress of his orchestra students. It reminds me of some of my own goals for tracking data and assessing students. Read about his awesome workflow on his blog.

Post #3 - Creativity in Organization: Google Sheets Dashboards — David Getz Creative:

Spreadsheets begin as endless rows of empty cells, neatly organized in columns and rows; a pure, blank canvas. What’s hidden in each cell though are endless formulas and shortcuts that can allow any creator to manipulate them for artistic and imaginative purposes.

I have always enjoyed goofing around with spreadsheets, but it was typically for the sole purpose of organizing baseball statistics or populating March Madness brackets. It wasn’t until I began coaching cross country that I began using my knack for number crunching for a professional purpose. After a few seasons of gathering large amounts of running data and analyzing trends to help us in our races, I realized I could also be using Google Sheets for educational purposes in my classroom. Music teachers often have the same students for multiple years, so having a way to analyze data over a long period of time is essential.

This year, I have decided to take a deep dive into building Google Sheets Dashboards. Keep reading here…

🔗 Adobe and Wordpress launch Google-backed .new shortcuts - 9to5Google

Cool new document creation shortcuts from Wordpress and Adobe, in collaboration with Google. If you are a Google Docs user and didn't already know about document creation shortcuts, they will save you some time. Click to read the entire article below.

Adobe and Wordpress launch Google-backed .new shortcuts - 9to5Google:

Back in 2018, Google introduced web links to quickly open blank Docs, Forms, and Sheets. Over the years, it expanded to most other G Suite services, with Adobe Acrobat and Spark now supporting several .new shortcuts.

Adobe “collaborated” with Google in hopes of providing a “streamlined way to get things done.” It specifically doesn’t want users to be “stuck scouring the web just to get things done.”

I wish I had more of a need for these. I love the idea of typing "new.sheets" into my browser to set up a new spreadsheet, but I am logged into two different Google accounts and the chance that it creates the document in the correct account is 50/50. Kind of defeats the point of the shortcut.