This paper presents a dynamic Excel visual. The visual has three graphs that are all driven by the same data, so students can see how changes (via Slider controls) in data appear on a univariate graph, a bivariate graph, and a graph that shows a ratio of two variables on one axis. The visual has macros that let a statistics teacher reveal parts of…

Charts and graphs are ubiquitous in business documents, and most students in the author's business communication courses are well aware that they need to be able to create many different types of data representation. Most of them have had a great deal of experience working with spreadsheet applications, and they know how to manipulate data and…

In this article, the author focuses on possible ways to develop the concepts of joint variation and function through the upper primary and lower secondary years of education. The examples demonstrate the building of a range of important mathematical ideas by modelling life-related situations using students' informal and intuitive knowledge. Over…

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…

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)

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)

Presented are ideas for the utilization of Microsoft Works in the secondary mathematics classroom. The spreadsheet and graphing capabilities of this software package are demonstrated for several topics including the concept of slope for first year algebra, and creating and interpreting graphs for a general mathematics class. (Author/CW)

Described is an instructional method that makes use of an electronic spreadsheet for the numerical and graphical introduction of the fundamentals of Taylor polynomials. Included is a demonstration spreadsheet using the expansion polynomial to evaluate the cosine function. (JJK)

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…

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…