### Tuesday, December 02, 2008

##
Teaching spreadsheets in high school math classes

Should high-school math classes be teaching Excel? Or, more generally, should we be teaching

Certainly the right point of view is to teach spreadsheets rather than Excel, although the dominance of Excel means that it will inevitably be hard to distinguish it from spreadsheets in general. Anyway, I think the real questions are the following:

There are a lot of issues, large and small, in using Excel. The notion of a variable is quite different from that of a variable in mathematics. Order of operations is important, and that’s almost identical to what we do in math and can therefore reinforce it. Sorting becomes important, and that’s a mathematical concept that comes up a lot in computer science courses but rarely in pure math. Graphing and regression are possible in Excel, but both are clumsy. Sometimes the syntax can be confusing, such as beginning a formula with an equals sign, but getting used to different syntactic conventions is a useful mathematical skill. A great many mathematical

We’ve just completed an Excel activity in my college-prep Algebra II class: Saving for College. My hope is that this activity will not only give some experience with spreadsheets (that’s the secondary goal) but will also reinforce some of the important concepts in exponential functions (that’s the primary goal).

Incidentally, it turns out that many of those who teach Excel only have a very narrow view of this powerful piece of software. (As much as I don’t like Microsoft, I do have to admit that Excel has a great many excellent features and has an enormous number of useful options, many of which I barely know myself.) So I wonder if Weston needs to have a workshop in which we try to plumb the depths of Excel and figure out which aspects of this software will be most useful in teaching high-school math.

*spreadsheet use*— and Excel just happens to dominate the market? We have been exploring these issues at Weston High School.Certainly the right point of view is to teach spreadsheets rather than Excel, although the dominance of Excel means that it will inevitably be hard to distinguish it from spreadsheets in general. Anyway, I think the real questions are the following:

- What can spreadsheets add to high-school math?
- When and in what order should we teach various spreadsheet techniques?
- Should we teach non-mathematical skills such as formatting cells, creating headers, etc.?

*somebody*should teach it in high school. I suppose the responsibility falls to the math department by default, even if it isn’t really math, though that conclusion makes me uncomfortable. The only other likely places are the science department — since science courses also do a fair amount with Excel — and the business department, though that wouldn’t touch all students by any means.There are a lot of issues, large and small, in using Excel. The notion of a variable is quite different from that of a variable in mathematics. Order of operations is important, and that’s almost identical to what we do in math and can therefore reinforce it. Sorting becomes important, and that’s a mathematical concept that comes up a lot in computer science courses but rarely in pure math. Graphing and regression are possible in Excel, but both are clumsy. Sometimes the syntax can be confusing, such as beginning a formula with an equals sign, but getting used to different syntactic conventions is a useful mathematical skill. A great many mathematical

*functions*are built into Excel and can therefore be reinforced when we use spreadsheets. Perhaps most important is the level of abstraction involved in creating formulas that can be dragged vertically or horizontally independent of pre-existing data.We’ve just completed an Excel activity in my college-prep Algebra II class: Saving for College. My hope is that this activity will not only give some experience with spreadsheets (that’s the secondary goal) but will also reinforce some of the important concepts in exponential functions (that’s the primary goal).

Incidentally, it turns out that many of those who teach Excel only have a very narrow view of this powerful piece of software. (As much as I don’t like Microsoft, I do have to admit that Excel has a great many excellent features and has an enormous number of useful options, many of which I barely know myself.) So I wonder if Weston needs to have a workshop in which we try to plumb the depths of Excel and figure out which aspects of this software will be most useful in teaching high-school math.

Labels: math, teaching and learning, Weston

###### ARCHIVES

- May 2005
- June 2005
- July 2005
- August 2005
- September 2005
- October 2005
- November 2005
- December 2005
- January 2006
- February 2006
- March 2006
- April 2006
- May 2006
- August 2006
- September 2006
- November 2006
- December 2006
- January 2007
- February 2007
- March 2007
- April 2007
- May 2007
- December 2007
- January 2008
- February 2008
- March 2008
- April 2008
- May 2008
- July 2008
- November 2008
- December 2008
- January 2009