Technology is the Plate!
Tools that Enhance Elementary Problem Solving
Spreadsheets as Tools for
|How can spreadsheets be used in elementary and middle grades grades
mathematics classes? Students can use this tool to organize and
analyze data, to create representations, to develop deeper understanding
of mathematics, and to “uncover” powerful mathematical
|Why use spreadsheets in problem solving?
- Mindtools, à la David Jonassen,
- are critical thinking tools that engage and facilitate
- are constructive.
- amplify and reorganize mental functioning.
- require learners to think more deeply than they would
have to without the tool.
- make more effective use of the mental efforts of the learner;
offloading calculation tasks allows learner to apply more
effort to understanding.
- Spreadsheets support problem solving by enabling students
- identify and describe relationships and patterns —
facilitated by organization of data.
- answer questions and make decisions.
- test hypotheses: “what if?”
- integrate graphical representation with numerical
- double check through alternate calculation.
- explore extensions of the problem.
- Spreadsheets enhance mathematical comprehension by supporting
- Spreadsheets facilitate generalization which prepares them
- Teach spreadsheet as alternate method after solving small
scale problem with paper and pencil.
- Begin with words before building formulas.
- Begin with a teacher-created template.
- Reinforce labeling of data, formatting number, including rounding
- Not a replacement for understanding.
- Importance of estimation and determining reasonableness of
- Effective use of technology will influence what math is taught.
Mathematical concepts supported by spreadsheet:
- formula generation
- discrete vs continuous
- geometric relationships among dimension, area, perimeter,
- rate of growth
- Principals and Standards for School Mathematics.
National Council of Teachers of Mathematics.
- Computers as Mindtools for Schools. David H Jonassen;
- Spreadsheet Activities in Middle School Mathematics.
John C Russell; NCTM.
to Math and Spreadsheets
© 1994-2007 The Math Forum