A mechanism for using personal computer spreadsheet software to generate unique laboratory and problem assignments in optics for each student and provide corresponding solutions that can be checked quickly is described. The method minimizes some students' tendency to inspect others' solutions without solving problems themselves. Another…

Spreadsheet programs are used increasingly by engineering students to solve problems, especially problems requiring repetitive calculations, as they provide rapid and simple numerical solutions. This article shows how advanced spreadsheet programs are used in the learning of numerical solutions of two-dimensional diffusion equation using the…

Discusses the use of a spreadsheet program to vary the parameters in multiloop circuit problems. Enables students to better understand how the elements in a multiloop circuit determine the current by allowing them to see the results of the changes immediately. (JRH)

Discusses a method that uses spreadsheets to calculate the exact distribution of the sum of two or more discrete random variables with arbitrary distributions. Demonstrates how this method can be used to investigate several problems that would be found interesting at the elementary level. (Author/ASK)

Reports on the results of a project that involved experienced K-12 teachers in mathematical modeling, using variables and functions in a fundamental and intuitive context, while investigating the appropriateness of spreadsheet solution methods across a broad range of grade levels. (14 references) (LZ)

Describes the range of processes used by year 3 children engaged in solving non-routine mathematics problems. Discusses how it can be told when children are thinking mathematically. (ASK)

Presents historical mathematics to students. Suggests allowing students to have two methods of problem solving with a graphing calculator to allow for a visual result. Indicates that students should have more than one opportunity to experience a solution to a problem, a variety of contexts for the problem, and an opportunity to communicate. (ASK)

Uses a traditional approach with problem solving, a concrete approach with manipulatives, and a visual approach with computer spreadsheets to teach the arithmetic mean to 22 children in grades 4-6 in three multiage groups. Differences among pretest, posttest, and interview performances suggest some advantage to the use of a visual instructional…

Presents a model based on a bicycle metaphor for teaching problem solving and computer-mediated solutions, discusses its implications for education, and lists ten strategies applied using the model. Provides a unit plan on using spreadsheets to explore Australian convict history, outlining establishment, development, interpretation, and…

Responds to the suggestion that computational tools be used in undergraduate thermodynamics courses. Argues that instead of using spreadsheets or specially prepared programs, students can quickly develop their own worksheets and solve problems using an equation-solving software program such as MATHCAD. Emphasis is on understanding the fundamentals…

Discusses the use of spreadsheets for mathematical problem solving to help develop higher-level-thinking skills and foster an experimental attitude toward learning mathematics. An example is given of middle-school and high-school students investigating a number-structures problem. (LRW)

Offers a cave-mapping problem and discusses how to solve it. Presents the problem and necessary geologic background and a spreadsheet algorithm to solve the problem. (KHR)

Discusses using a computer spreadsheet's graphing capabilities to assist grade 8-12 algebra students to see equations and their solutions in new ways. Describes and illustrates the solution of two equations and an inequality using ClarisWorks, or Microsoft Excel or Works spreadsheet. Discusses "Curriculum and Evaluation Standards for School…

During the years 2000-2003, a course on Exploring Quantitative Relationships (EQR) was created at Queens College under the support of the U.S. Department of Education Fund for the Improvement of Post-Secondary Education (DOE-FIPSE Grant No. P116B000772). Exploratory in nature, the course goals were to acquaint liberal arts students with…

Recently we were presented with an interesting twist to the sliding ladder problem viewed in the related rates section of most calculus textbooks. Our problem concerning a sliding ladder that eventually hits the ground. At first, those attempting this problem fell into the calculus trap using only related rates. Previous work for this problem…