This article is the second in a series of two papers which suggest some practical, spreadsheet-based ideas for helping students to make appropriate connections between particular algebraic concepts. Solving equations has traditionally been taught as a pen-and-paper process. Spreadsheets, such as that of Excel, provide a contemporary, and powerful…

A national student competition problem in business intelligence (BI) is considered to foster an understanding of this competition and of the underlying case study problem used. The focus here is two-fold. First, is to illustrate this competition, and second, is to provide a case problem that can be considered for use in various information systems…

Excel, Microsoft's spreadsheet program, offers several tools which have proven useful in solving some optimization problems that arise in operations research. We will look at two such tools, the Excel modules called Solver and Goal Seek--this after deriving an equation, called the "cash accumulation equation", to be used in conjunction with them.

Solving true problems requires persistence. The National Council of Teachers of Mathematics (NCTM) states that "problem solving means engaging in a task for which the solution method is not known in advance. In order to find a solution, students must draw on their knowledge, and through this process they will often develop new mathematical…

An attempt to model the physical process of annealing lead to the development of a type of combinatorial optimization algorithm that takes on the problem of getting trapped in a local minimum. The author presents a Microsoft Excel spreadsheet that illustrates how this works.

This article shows how to use six parameters describing the International Space Station's orbit to predict when and in what part of the sky observers can look for the station as it passes over their location. The method requires only a good background in trigonometry and some familiarity with elementary vector and matrix operations. An included…

Solving indeterminate algebraic equations in integers is a classic topic in the mathematics curricula across grades. At the undergraduate level, the study of solutions of non-linear equations of this kind can be motivated by the use of technology. This article shows how the unity of geometric contextualization and spreadsheet-based amplification…

Knowing the mathematics relating to a problem is one thing, but producing a tool to solve a practical example is often daunting. This article describes a case study which presented an interesting implementational challenge.

This study is part of a large research and development project aimed at observing, describing and analyzing the learning processes of two seventh grade classes during a yearlong beginning algebra course in a computer intensive environment (CIE). The environment includes carefully designed algebra learning materials with a functional approach, and…

This is a must-have resource for all K-12 teachers and administrators who want to really make the best use of available technologies. Written by Doug Johnson, an expert in educational technology, "The Classroom Teacher's Technology Survival Guide" is replete with practical tips teachers can easily use to engage their students and make their…

In this note, we demonstrate with illustrations two different ways that MS Excel can be used to solve Linear Systems of Equation, Linear Programming Problems, and Matrix Inversion Problems. The advantage of using MS Excel is its availability and transparency (the user is responsible for most of the details of how a problem is solved). Further, we…

This paper reports on a study that examined if it is possible to start teaching algorithmic problem solving as early as elementary school, given the condition that studying mathematics is augmented by suitable use of computer technology. Three pre-service teachers, enrolled on a course on algorithmic problem solving in mathematics and who were…

This article uses one of the authors' classroom experiences to explore how teachers can create technology-rich learning environments that support upper elementary students' mathematical understanding of algebra and number and operations. They describe a unit that presents a common financial problem (the use of credit cards) to engage sixth graders…

Principle of duality and numerical calculation of income and substitution effects under Hicksian Compensation are often left out of intermediate microeconomics courses because they require a rigorous calculus based analysis. But these topics are critically important for understanding consumer behavior. In this paper we use excel solver--a…

Presents selected responses to the question "The Farmer's Dilemma" that represent the thinking of sixth-, seventh-, and eighth-grade students. Indicates that by being given the freedom to use a variety of methods, most students found at least one solution or demonstrated an understanding of the restrictions set by the problem. (ASK)