- First introduce Fibonacci Numbers. I used wikipedia's entry to introduce the concept. It helped that the kids were already familiar with it from math class. Be sure to point out the elaborate algebraic formula represented: Fn=Fn-1+Fn-2,
- Have students open a blank Excel file.
- Highlight cells A1 and A2. I used bright yellow. This is to designate them as the cells where the student will change the values.
- In cell A3 type the following formula "=A1+A2"
- Type the number "1" in both cells A1 and A2. This is to illustrate that the formula in A3 works.
- Then in cell B1 type "=A2"
- In cell B2 type "=A3"
- Auto fill cell A3 down to B3
- Row B should now reflect a Fibonacci Number sequence.
- Auto fill B1:B3 down to about row ten. Notice how quickly the numbers grow.
Next create a chart to illustrate the relationship between the numbers.
- select column C from row 1 through 10
- Go to Insert and select various charts.
- Place the chart next to the column of data.
- Compare various charts to see which ones give the best representation.
- Change the values in the highlighted cells and point out that the curve of the chart does not change even though the initial values change - that's because Fibonacci Numbers represent a relationship!
Blogged with the Flock Browser