Spreadsheets provide a rich setting for first-year algebra students to solve problems. Individual spreadsheet cells play the role of variables, and creating algebraic expressions for a spreadsheet to perform a task allows students to achieve a glimpse of how mathematics is used to program a computer and solve problems. Classic optimization…

Single-period inventory models with uncertain demand are very well known in the business analytics community. Typically, such models are rule-based functions, or sets of functions, of one decision variable (order quantity) and one random variable (demand). In academics, the models are taught selectively and usually not completely. Students are…

In this article we report and discuss a contextual problem solving task that was proposed to a class of 8th grade (13-14-year-old) students. These students had been developing a reasonable experience in the use of the spreadsheet to model relations within contextual problems and chose to use this tool to solve the mentioned problem, engaging in…

A problem that illustrates two ways of computing the break-even radius of insulation is outlined. The problem is suitable for students who are taking an introductory module in heat transfer or transport phenomena and who have some previous knowledge of the numerical solution of non- linear algebraic equations. The potential for computer algebra,…

This study investigates prospective secondary mathematics teachers' visual representations of polynomial and rational inequalities, and graphs of exponential and logarithmic functions with GeoGebra Dynamic Software. Five prospective teachers in a university in the United States participated in this research study, which was situated within a…

This experiment investigates the effectiveness of Excel spreadsheets in a high school algebra class. Students in the experiment group convincingly outperformed the control group on a post lesson assessment. The student responses, teacher observations involving Excel spreadsheet revealed that it operated as a mindtool, which formed the users'…

A simple, conceptual method is described for using the spreadsheet scroll bar to find the composition of a system at chemical equilibrium. Simulation of any kind of chemical equilibrium can be carried out using this method, and the effects of different disturbances can be predicted. This simulation, which can be used in general chemistry…

The study documents the extent to which high school teachers reflect on their need to revise and extend their mathematical and practicing knowledge. In this context, teachers worked on a set of tasks as a part of an inquiring community that promoted the use of different computational tools in problem solving approaches. Results indicated that the…

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…

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…

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…

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 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…

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)

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…