Drexel dragonThe Math ForumDonate to the Math Forum



Search All of the Math Forum:

Views expressed in these public forums are not endorsed by Drexel University or The Math Forum.


Math Forum » Discussions » Education » math-teach

Topic: Ron Wilk on math courses
Replies: 47   Last Post: May 27, 2006 3:31 AM

Advanced Search

Back to Topic List Back to Topic List Jump to Tree View Jump to Tree View   Messages: [ Previous | Next ]
NealAgMan@aol.com

Posts: 181
Registered: 12/4/04
Re: Ron Wilk on math courses
Posted: May 25, 2006 11:29 AM
  Click to see the message monospaced in plain text Plain Text   Click to reply to this topic Reply

In my own experience, building a spreadsheet has been more of an application of mathematical concepts, or reinforcement of those concepts, rather than the learning of new mathematics. (Although I have certainly seen the reverse--e.g., graphing trig functions using the spreadsheet's graphing utility).

I spent a great deal of time as a lawyer practicing in the field of trusts and estates. Much of what we do in that area consists of very sophisticated tax planning, involving frequent computations of estate and gift taxes, present values of streams of future payments, etc. Once we all got computers at our desks and spreadsheet software (by the early to mid 1980's), it became obvious that the spreadsheet was an answer to our prayers for doing the kinds of computations that we do, especially with its ability to do iterative computations at enormous speeds (for our so-called "inter-related computations").

I became the unofficial Lotus "maven" in our group, probably because I very quickly learned that every hour I spent learning the techniques, formulas, and built-in functions of the software would be repaid a hundred-fold, if not more. I can still remember a very simple spreadsheet I did for one of the senior tax partners, which really did nothing more than compute simple and compound interest, maybe with a few bells and whistles. One would input the starting and closing dates for the running of interest, the annual rate, the principal amount, compounding periods/year, etc., and the spreadsheet instantly produced all the answers.

My boss and I were showing this to the tax partner, who was a big wheel in this firm who billed out his time (way back then) at maybe $500/hr. He was just amazed. "Mr. Silverman," he said, "have you had graduate work in mathematics?" "No, Mr. Wolf," I replied. "In fact, the mathematics involved in this spreadsheet is nothing more advanced than I learned in first-year algebra with Mr. Monteverde in 8th grade!" He wanted to see the "guts" of the spreadsheet, so we looked at the formulas, not much more than i=prt and FV=PV*(1+r)^n. And, of course, a simple subtraction to get the number of days for which interest runs. I reminded this guy (who was very nice) of those problems he most likely did not much enjoy, in which Susie's age was 1/3 mother's age, but in 10 years . . . (fill in the rest). How old are Susie and mother now? I pointed out to him that by doing those problems, you develop that skill for converting facts stated in English into algebraic expressions, so they really did have a purpose (as Mr. Monteverde used to assure us). One uses that skill constantly in creating non-routine spreadsheets.


Date Subject Author
5/23/06
Read Ron Wilk on math courses
Domenico Rosa
5/23/06
Read Re: Ron Wilk on math courses
Michael Paul Goldenberg
5/24/06
Read Re: Ron Wilk on math courses
Domenico Rosa
5/24/06
Read Re: Ron Wilk on math courses
Haim
5/24/06
Read Re: Ron Wilk on math courses
Joshua Zucker
5/24/06
Read Re: Ron Wilk on math courses
Michael Paul Goldenberg
5/24/06
Read Re: Ron Wilk on math courses
Haim
5/24/06
Read Re: Ron Wilk on math courses
Kirby Urner
5/25/06
Read Re: Ron Wilk on math courses
Wayne Bishop
5/25/06
Read Re: Ron Wilk on math courses
Kirby Urner
5/25/06
Read Re: Ron Wilk on math courses
Kirby Urner
5/25/06
Read Re: Ron Wilk on math courses
Kirby Urner
5/25/06
Read Re: Ron Wilk on math courses
Dave L. Renfro
5/25/06
Read Re: Ron Wilk on math courses
Kirby Urner
5/24/06
Read Re: Ron Wilk on math courses
Domenico Rosa
5/24/06
Read Re: Ron Wilk on math courses
Richard Strausz
5/24/06
Read Re: Ron Wilk on math courses
Paul A. Tanner III
5/24/06
Read Re: Ron Wilk on math courses
Michael Paul Goldenberg
5/24/06
Read Re: Ron Wilk on math courses
Paul A. Tanner III
5/24/06
Read Re: Ron Wilk on math courses
Paul A. Tanner III
5/24/06
Read Re: Ron Wilk on math courses
Michael Paul Goldenberg
5/24/06
Read Re: Ron Wilk on math courses
Haim
5/24/06
Read Re: Ron Wilk on math courses
Richard Strausz
5/24/06
Read Re: Ron Wilk on math courses
Haim
5/25/06
Read Re: Ron Wilk on math courses
Paul A. Tanner III
5/25/06
Read Re: Ron Wilk on math courses
Richard Strausz
5/25/06
Read Re: Ron Wilk on math courses
Paul A. Tanner III
5/25/06
Read Re: Ron Wilk on math courses
Richard Strausz
5/25/06
Read Re: Ron Wilk on math courses
Paul A. Tanner III
5/25/06
Read Re: Ron Wilk on math courses
Richard Strausz
5/25/06
Read Weeding out (Was: Ron Wilk on math courses)
Michael Paul Goldenberg
5/26/06
Read Re: Weeding out (Was: Ron Wilk on math courses)
Paul A. Tanner III
5/26/06
Read Re: Weeding out (Was: Ron Wilk on math courses)
Michael Paul Goldenberg
5/27/06
Read Re: Weeding out (Was: Ron Wilk on math courses)
Paul A. Tanner III
5/25/06
Read Re: Ron Wilk on math courses
Paul A. Tanner III
5/26/06
Read Re: Ron Wilk on math courses
Michael Paul Goldenberg
5/25/06
Read Re: Ron Wilk on math courses
Louis Talman
5/25/06
Read Re: Ron Wilk on math courses
Paul A. Tanner III
5/25/06
Read Re: Ron Wilk on math courses
Joshua Zucker
5/25/06
Read Re: Ron Wilk on math courses
Michael Paul Goldenberg
5/25/06
Read Re: Ron Wilk on math courses
Louis Talman
5/25/06
Read Re: Ron Wilk on math courses
Richard Strausz
5/25/06
Read Re: Ron Wilk on math courses
Wayne Bishop
5/25/06
Read Re: Ron Wilk on math courses
Richard Strausz
5/25/06
Read Re: Ron Wilk on math courses
Greg Matheson
5/26/06
Read Re: Ron Wilk on math courses
Richard Strausz
5/26/06
Read Re: Ron Wilk on math courses
Greg Matheson
5/25/06
Read Re: Ron Wilk on math courses
NealAgMan@aol.com

Point your RSS reader here for a feed of the latest messages in this topic.

[Privacy Policy] [Terms of Use]

© Drexel University 1994-2014. All Rights Reserved.
The Math Forum is a research and educational enterprise of the Drexel University School of Education.