Tuesday, May 26, 2009

Fun Link

I had a student introduce me today to the website playauditorium.com It uses sound and motion to emphasize puzzle solving. There are several levels and it gets challenging pretty early so be prepared to work on it a while :)

Tuesday, May 19, 2009

Fibonacci Lesson Plan

Here's a quick little lesson plan I threw together for the fifth graders today. It uses Microsoft Excel and Fibonacci Numbers to practice cell reference, formulas and charts.

  1. 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,
  2. Have students open a blank Excel file.
  3. Highlight cells A1 and A2. I used bright yellow. This is to designate them as the cells where the student will change the values.
  4. In cell A3 type the following formula "=A1+A2"
  5. Type the number "1" in both cells A1 and A2. This is to illustrate that the formula in A3 works.
  6. Then in cell B1 type "=A2"
  7. In cell B2 type "=A3"
  8. Auto fill cell A3 down to B3
  9. Row B should now reflect a Fibonacci Number sequence.
  10. Auto fill B1:B3 down to about row ten. Notice how quickly the numbers grow.
Try a few different numbers in the highlighted cells. Point out how all the data changes based on the information in the two highlighted cells. The reason is cell reference and formulas.

Next create a chart to illustrate the relationship between the numbers.
  1. select column C from row 1 through 10
  2. Go to Insert and select various charts.
  3. Place the  chart next to the column of data.
  4. Compare various charts to see which ones give the best representation.
  5. 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

Saturday, May 2, 2009


Being absent from class has an impact on the student's learning. But what about the absence of tools or equipment that we've depended on for years? I'm talking about the touchscreen.
Four years ago I used a tablet PC at another job (in health care) and found it nice to not be tethered to a keyboard all the time. The reduced footprint of my electronics was a real plus. Today many kids have a touchscreen phones or at least text with their thumbs on tiny keypads. But this morning I received an e-mail from Dell announcing their new Studio One 19 touch screen computer and I wondered what would be the impact on education if everyone of my lab pc's was swapped out with a touch screen PC?

Should I still teach typing? It's not my favorite subject but is a valuable resource, isn't it?

How should the room be reconfigured? Could I get away with fewer computers and set the lab up into "centers" where several students collaborate on one unit rather than one to one interaction with a computer?

I've never been good at predicting the future but analyzing trends is fun. What changes do you see coming with all the recent innovations?