Exploration 12: Write-Up

Spreadsheets in Excel:

Spreadsheets, specifically in Excel, offer many benefits within the realm of mathematics. Excel spreadsheets allows one to store, categorize, and sort through large amounts of data (qualitative and quantitative) with ease. In addition, calculations can be made quickly, which allows students to make observations and explore the mathematics of particular functions.

For instance, let’s take the function:

Within excel, we can create a spreadsheet that will take a list of x- values, input them into the function, and provide the corresponding outputs.

Steps to graphing this function in excel:

Establishing the inputs:

  1. Start by naming the first column Equation 
  2. Place any number in the first entry of the X-column.
  3. Now, in the second entry of the X-column, click the Equation button.
  4. In the input bar input the following “=SUM (A2, 1)” This takes the first x-value and adds one.
  5. Click the cell A3 and drag it down as far as you’d like. This extends the formula

Establishing the outputs:

  1. Start by naming the second column Equation
  2. Click on cell A2 and then click the Equation button.
  3. In the input bar input “=PRODUCT (2, A2)+5”
  4. Just like step 5 for the inputs, click cell A2 and drag it down as far as you’d like. This will extend the formula to create the corresponding output for each input.


Creating the Graph:

  1. Highlight the second column (the y-values)
  2. Click InsertEquation Chart Equation Line Chart Equation Line
  3. A graph will then appear on the sheet. It can then be edited to alter the aesthetics of the graph and how the information is displayed.




There are many interesting ways to utilize spreadsheets in the classroom. Below are a few ideas that I thought of.


Return to Nick's Homepage