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.

Google Docs, Sheets get iOS 9 split screen (finally)

From the Six Colors blog:

Today brought some great news. Updates to Google Docs and Google Sheets add split-view multitasking to those apps at last.

This is a big deal for iPad users. Now it’s possible to update a Google document or spreadsheet while also viewing Safari or using any other multitasking-capable app you can think of.

Yes! I am recently relying way more on Google Docs and Sheets to collaborate with my colleagues. I am also using my iPad increasingly more often as a work device. These two apps were previously the only two I used on a regular basis that could not be opened alongside another app on my giant iPad Pro’s display. Now I can finally do something like, for example, plan a concert in Notes on one side of the screen while referencing my score inventory in Google Sheets on the other side.