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…

We discuss the introduction and teaching of partial differential equations (heat and wave equations) via modeling physical phenomena, using a new approach that encompasses constructing difference equations and implementing these in a spreadsheet, numerically solving the partial differential equations using the numerical differential equation…

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…

We describe a computer tutorial that introduces the concept of the steady state in enzyme kinetics. The tutorial allows students to produce graphs of the concentrations of free enzyme, enzyme-substrate complex, and product versus time in order to learn about the approach to steady state. By using a range of substrate concentrations and rate…

One of the most remarkable devices embedded in a Microsoft Excel spreadsheet is known as the spinner. Its staggering simplicity is undoubtedly its strength. As an incrementing device that allows graphs to dance across the screen, it gives the concept of variability a whole new meaning. Spinners and their close cousins scroll bars can be grabbed…

Discusses children's use of spreadsheets and the access that this gives to the instantaneous production of a variety of graphs. (10 references) (MKR)

Describes research using a pedagogic strategy developed during an exploratory work called Active Graphing in which access to spreadsheets allows graphs to be used as analytic tools within practical experiments. Identifies aspects of student interaction with the experiment itself, the data collected and the graphs, and traces the emergence of…

A search on the Internet for resources for teaching statistics yields multiple sites with data sets, projects, worksheets, applets, and software. Often these are made available without information on how they might benefit learning. This paper addresses potential benefits from resources that target trend and variability relationships in bivariate…

Presents a graphing activity to show transverse and longitudinal waves using spreadsheets. (Author/NB)

Describes two spreadsheets for producing acid-base titration curves, one uses relatively simple cell formulae that can be written into the spreadsheet by inexperienced students and the second uses more complex formulae that are best written by the teacher. (JRH)

Takes a theme from "IMPACT Maths" and works it into a spreadsheet activity to display data in bar charts, pie charts, and line graphs. (ASK)

Discusses the use of technology to investigate what graphs represent as well as how to interpret graphs. (MKR)

Provides a lesson that focuses on three-dimensional graphing, contours, and topographical maps using computer spreadsheets. (ASK)

Acknowledging the need for additional practical resources for integrating technology into physical education assessment, this paper provides strategies and step-by-step instructions for incorporating Microsoft Excel into physical educators' assessment tools. The first section briefly reviews the literature on assessment in physical education. The…