Wednesday, January 28, 2009

Wednesday Math, Vol. 58: Third thoughts on math education

When I entered high school, I took a typing class in summer school before my freshman year. It was an elective class, and my dad thought it would be a good idea. I want to say it didn't help much, as I am a hunt and peck typist all these decades later, and the damn tunes the teacher played to have us type to a rhythm are still stuck in my head, as are many tunes from other sources. There's not much helping that.

Still, the school provided a useful service in teaching a typing class back then, as it was a skill useful to many people regardless of whether they would go on to college or not. Sadly, the over-reliance on standardized tests in so many aspects of the educational means cutting back on "electives", which means any classes that aren't focused on topics that will be on the standardized tests.

Along similar lines in today's world, I would like to see high school students get training in spreadsheets. Googling "high school spreadsheets", I see I am not the first person with this good idea, but it looks like something only a few schools do, and I assume it is not a mandatory class. Reading some of the websites, there are teachers that dislike the fact that teaching spreadsheets means that you are actually teaching Excel, and they grumble about Microsoft. That's understandable, but nearly unavoidable. Others worry that some vocabulary is used in different ways in a math class than it is in a spreadsheet setting, and since the class will probably be handed to the math department by default, this could cause confusion. Again, unavoidable. The farther you get into math, the more words math appropriates and gives new and unfamiliar definitions, and likewise other fields do the same, so this confusion is par for the course.

Spreadsheets make many statistical calculations much simpler, and it's a good place to get hands on training in the idea of recursion, a mathematical concept that has been around for millenia but became much more important as computers grew more prevalent in society and more computationally powerful.

Like typing, spreadsheet use is a skill needed by those who will go on to college and those who won't. Nearly any office job can involve spreadsheet use in today's world, and high schools should give more thought about what they can offer students who do not plan to continue on to college as well as those who do plan more schooling.


Karlacita! said...

Excellent! I took an Excel class as a part of a current certificate program, and I gotta say, I love me some Excel. What a ginormous program. You can do anything with it - simple or massively complex.

I'm tracking my monthly expenditures with linked spreadsheets, and it's hecka fun. I gots different colors, handmade functions - woot!

Lockwood said...

In Oregon State's math/science education program, prospective teachers are exposed to a variety of teaching methods using Excel, and I imagine that's true for many if not most teacher prep prgrams. The idea pushed there is to embed the use in context, rather than teaching it as a separate "thing." Also, my brother is an actuary- which is obviously a whole 'nother thing in itself. But his niche is to create statisitical models using, yep, Excel. These models then can be used by any ham-handed button pusher (as he refers to execs). He pulls down several hundred k per year... when he feels like working. So there's definitely some incentive to learning this program, even if math and science isn't your bag.

Mathman6293 said...

I think that you are correct about excel. Our math standards are vague but include "technology" for teaching math. Admittedly, I use Geometers Sketch Pad or TI stuff for graphs instead of excel.

But our school does offer classes in Computer Apps which includes excel.

BobManDo said...

I too took typing in my freshman HS summer in ~1967. AND it has served me well. Moving from Typewriters to KPros, Compaq, IBM PCs, Gateways, Generics, Dells, etc... and now MacBook Pro. Foot in both worlds... still daily use Alienware PC with XP on it and a nice curvy keyboard and gel to help my wrists.