STEM Practices

In a training webinar for the PEAR (Partnerships in Education and Resilience) Institute’s DoS (Dimensions of Success) Observation Tool, the facilitators discussed how the 3rd of their 4 domains – STEM Knowledge and Practices – was based on the STEM Practices outlined by the NGSS‘ (Next Generation Science Standards) “A Science Framework for K-12 Science Education.”  I think that these 8 practices are fantastic and that schools should place a focus on integrating into the curriculum maps for all content areas, not just science.  Here they are: Continue reading STEM Practices

Exploring Measures of Center with Google Sheets

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.

Proving the Algorithm for Mean (Average) in Google Sheets

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.