My obsession with Google Sheets is no secret. I loooove spreadsheets. And I think that they have a big place in education, especially in math (but elsewhere as well).
Recently, I posted about how you can prove the mean (or average) formula using Google Sheets. In this post, I’d like to share with you how you can find all 3 measures of center (or measures of central tendency) and explore them in Google Sheets. I love to change or add numbers in the data set and ask students to make predictions about what will happen. It really is a great–and relevant–way for students to become more familiar with these statistical measures.
In a recent post and video, I shared one of my favorite Google Docs hidden gems: the Paint Format Tool. This Google Docs feature is also a lesser known feature and goes hand-in-hand with the Paint Format Tool. Watch the video below to learn about the “Select Matching Text” option.
The OneTab Chrome Extension (one-tab.com) is typically recommended as a way to free up processing speed and reduce clutter when attempting to have a tab-tervention with a tab-crazy browser user. And, well, that’s a true, but it doesn’t tell the full story of OneTab . . .
OneTab is actually a fantastic option for organizing, categorizing and sharing the sites that we mean to look at, read or follow up on, but just don’t have time – as well as ones that we intend to come back to repeatedly. Think of it as your website to-do list manager. Check it out in the video below.
Pro Tip: At the school that I work at, our students are doing Passion Projects. Each week, they have to reflect on their progress and growth in a Google Doc. For 12 of the kids, I’m tasked with looking at that reflection weekly and providing feedback. So, I keep the links to their reflections in a locked OneTab Group.
I am a huge spreadsheets nerd and a huge advocate of the use of spreadsheets in mathematics instruction. If you keep an eye on my site (or Twitter feed or YouTube Channel) you’ll see plenty of my reasons why I feel this way. Here’s one:
Spreadsheets are a great tool for proving mathematical algorithms and formulas. In this post . . . how we can use a Google Sheet to prove the formula for the mean (which, in spreadsheet land, is known as the average).
Check out this post about finding and exploring all 3 measures of central tendency with Google Sheets.