Using Excel to Explore Rates and Proportions

My fifth graders are currently studying rates and proportions. Earlier in the week they explored rates by looking at unit prices and solving problems with some type of cross-multiplication strategy.  Although they’ve made progress I still feel as some many still need to cement their understanding of a ratio and proportion. So it was time to switch up the instruction model.

I decided to go with using a spreadsheet. In this case, the spreadsheet would be in the form of an Excel document. Each student grabbed a laptop and opened up Excel. The students used Excel earlier in the year so they were familiar with some of the basic functions.

After entering a few text cells, students were asked to put a random number above zero in cells B4 and C4. Then the class discussed what GCD stood for. Most of the students said “greatest common denominator.” That response made sense because that’s heavily emphasized in fourth grade as students add and subtract fractions. In this case, GCD means greatest common divisor. The class then discussed what that meant when comparing two numbers and the helpfulness in finding the GCD when exploring equivalent fractions. The discussion then transitioned from equivalent fractions to finding ratios.

Students entered in the formula =GCD(b4,c4) to find the GCD of the two different numbers. Students observed how the GCD changed as they updated their numbers.

Screen Shot 2015-04-17 at 7.30.47 PM

The next part was a bit tricky. I asked the students to write a formula to express the ratio in simplest form. The class used the GCD and trial and error to come up with the ratio formula. Once students wrote the formula and placed it in E4.  Students then explored how the ratio changed when their numbers were updated.

Screen Shot 2015-04-17 at 6.51.42 PM

The class then reviewed why the formula actually worked.  The class discussed that basically the formula took each number and divided it by the GCD of both numbers. What was great was that students were starting to connect the reasoning behind the creation of a ratio. Instead of just cross-multiplying, students are starting to show a deeper understanding of how ratios are constructed and the process used to simplify. The students were able to save and print out their spreadsheets for later review.


Excel Template

Example for Class Use



2 thoughts on “Using Excel to Explore Rates and Proportions

  1. Having read this I believed it was very informative.

    I appreciate you taking the time and energy to put this article
    together. I once again find myself personally spending a lot of time both reading
    and commenting. But so what, it was still worth it!


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s