This digest discusses using spreadsheets in mathematics education. The case is made that being able to manage spreadsheets is an important skill in the technologically enhanced new millennium. An annotated list of World Wide Web resources is included. (MM)

Describes the use of a Lotus 1-2-3 spreadsheet to provide students in a networked microcomputer lab with up-to-date information on grades and attendance. (SK)

Presents exemplary material from the publication "From Little Acorn Grow--Spreadsheets 9 to 13," a photocopiable resource book that contains spreadsheet ideas. Highlights the process of preparing the publication. (JRH)

Describes the development and instructional use of a Microsoft Excel spreadsheet template that facilitates analytical and Monte Carlo risk analysis of investment decisions. Discusses a variety of risk assessment methods followed by applications of the analytical and Monte Carlo methods. Uses a case study to illustrate use of the spreadsheet tool…

Discusses an integrated approach for presenting production planning and control fundamentals at the survey level using a Lotus 1-2-3 template. This approach provides an overview of the relationships between the problem components and highlights managerial decision-making points. (Author/JOW)

Presents a spreadsheet model that is useful in introducing students to regression analysis and the computation of regression coefficients. Includes spreadsheet layouts and formulas so that the spreadsheet can be implemented. (Author)

Very young students can begin to use technology to organize and analyze their data in sophisticated ways. The National Center for Education Statistics (2005) reported that 67% of nursery school students and 80% of kindergarten students were using computers in 2003. By the early elementary grades, some of these students are ready to begin using…

Directions for using a function called Mail Merge in Microsoft Office are mentioned. Using a spreadsheet and mail merge, allows one to create different assessments, complete with worked solutions, generate them on demand or save them for later use.

This paper describes how parametric cubic splines and cubic Bezier curves may be used in designing a two dimensional shape. A simple aerofoil shape is designed using both methods. The mathematics is described and the shape drawn using Excel. The effect of varying parameters is shown in both methods.

This article looks generally at spreadsheet modelling of feedback situations. It has several benefits as a teaching tool. Additionally, a consideration of the limitations of calculating at many discrete points can lead, at A-level, to an appreciation of the need for the calculus. Feedback situations can be used to introduce the idea of…

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…

A novel ratio method is developed and automated for finding the bromine-chlorine-sulfur stoichiometry in the molecular formula of an unknown. This method is also useful in spectrometric analysis or beginning organic chemistry.

There are few studies of the impact of ubiquitous computing on high school science, and the majority of studies of ubiquitous computing report only on the early stages of implementation. The present study presents data on 3 high schools with carefully elaborated ubiquitous computing systems that have gone through at least one "obsolescence cycle"…

A new Microsoft Excel spreadsheet design that enables a prompt calculation of rate constant, k values and associated errors and also addresses less common features such as the choice of an experimental curve's extent is presented. To complete the spreadsheet design, several highlights and squared colored boxes were included to assist the user and…

The monthly newsletter of the National AppleWorks Users Group (NAUG), "The AppleWorks Forum," serves as a clearinghouse for user-discovered applications and work-arounds. This article presents 10 of the most popular suggested applications for the program, including the development and use of word processing templates, the installation of…