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)

This paper extends the discussion of the critical line approach using three risky stocks as described in Haugen's Modern Investment Theory, 4th edition. A dynamic presentation of the concepts involved in finding the efficient set, using two EXCEL spreadsheets and an HP-12C hand-held calculator, is provided. This dynamic presentation will enable…

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.

In this brief article, the author instructs teachers on how to produce an interactive spreadsheet from scratch in about 20 minutes and en route equip themselves and their students, with handy "Excel" skills. The aim is to introduce the basics of "Excel," plus some fun bits, speedily and with a purpose; producing something that is useful in its own…

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…

A series of spreadsheet modeling exercises constructed as part of a new upper-level elective course on solid state materials and surface chemistry is described. The spreadsheet exercises are developed to provide students with the opportunity to interact with the conceptual framework where the role of the density of states and the Fermi-Dirac…

This article demonstrates how within an educational context, supported by the notion of hidden mathematics curriculum and enhanced by the use of technology, new mathematical knowledge can be discovered. More specifically, proceeding from the well-known representation of Fibonacci numbers through a second-order difference equation, this article…

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

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…

An understanding of limits is valuable for learning advanced mathematics. Fundamental to almost all branches of mathematics, studying and applying limits enable students to pursue meanings instead of calculations to many different applications. The idea of nearness to a point instead of exactness is different for many students. Using spreadsheets…