The author focused on solving problems of third-degree price discrimination under a monopoly by integrating microeconomic theory and spreadsheet modeling. Price discrimination refers to a firm situation in which the same good is sold to different groups of consumers at different prices. First, the author included an introductory math background…

For the least-squares analysis of data having multiple uncertain variables, the generally accepted best solution comes from minimizing the sum of weighted squared residuals over all uncertain variables, with, for example, weights in x[subscript i] taken as inversely proportional to the variance [delta][subscript xi][superscript 2]. A complication…

The oxidation of iron is an important reaction due to its high economic impact. In this laboratory exploration, the total order of this reaction was determined using commercially available handwarmer packets that rely on the iron-oxygen reaction to generate heat. The active ingredient in the handwarmer packet is iron, which interacts with…

The aim of this study is to scrutinize the characteristics of conceptual meaning making when students engage with virtual worlds in combination with a spreadsheet with the aim to develop graphs. We study how these tools and the representations they contain or enable students to construct serve to influence their understanding of energy resource…

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…

Describes how a software package that includes a spreadsheet, a relation grapher, and a dynamic geometry can contribute to teacher training through an exploratory problem-solving course. Discusses the ways in which technology-rich environments enhance and extend traditional topics. Contains 17 references. (DDR)

Addresses the early stages of children's introduction to the use of variables in formal algebraic notation. Describes a teaching approach that aims to situate the use of formal notation in meaningful contexts. Presents a study of a teaching sequence based on children working with this approach using graphical feedback in problem solutions. (AIM)

Examines research on computers as cognitive enhancers, focusing on applications software that includes spreadsheets, graphing, and databases. Appropriate computer-based problem-solving environments for young children are reviewed, and implications for teachers are suggested. (Contains eight references.) (LRW)

Demonstrated in this article are some of the capabilities of a spreadsheet program using data obtained in gas law experiments and a computer interface system. The ability to organize and analyze data which a computer can provide for the student is emphasized. (KR)

U.S. mathematics education has been criticized for being too broad. This article examines ways middle school students use simple problems and situations to foster a deeper understanding of underlying concepts. Presents a sample area and perimeter problem, describes extending the problem using tiles to determine minimum perimeter, and discusses…

Illustrates the diverse ways in which the computer spreadsheet can be used by both teachers and students as a problem-solving tool in high school mathematics, and provides detailed examples of spreadsheet use in word problems. Discusses the functions of spreadsheet tables, columns, and graphs. (AEF)

Described are several spreadsheet templates which use the functions of iteration and logical look-up which allow students to calculate and graph quantum mechanical functions and to simulate rotational and vibrational energy level and spectra. The templates are listed in the appendix. (KR)

Explores alternative strategies to solve algebraic equations that do not lend themselves to traditional methods. Examines one nontraditional equation by a graphical approach using a graphing utility and by a numerical approach using spreadsheets. Discusses new basic skills for algebra utilizing technology. Provides a computer program to solve…

Discussed are the possible uses of spreadsheets in the undergraduate curriculum in chemical engineering classes. The advantages and flexibility of spreadsheets, spreadsheet instruction, graphing capabilities, assignment examples, and conclusions are described. (KR)

Presents an activity through which students develop mathematical concepts connected to area and perimeter in a rich, real-life setting and use tables, graphs, diagrams, and spreadsheets to explore the problem, see relationships, and make and test conjectures about those relationships. Encourages algebraic thinking. (SYB)