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…

A simple interface between VPython and Microsoft (MS) Office products such as Word and Excel, controlled by Visual Basic for Applications, is described. The interface allows the preparation of content-rich, interactive learning environments by taking advantage of the three-dimensional (3D) visualization capabilities of VPython and the GUI…

To reach a sustainable world the use of renewable energy sources is imperative. Photovoltaics (PV) is but one of the technologies that use the power of the sun and its deployment is growing very fast. Several master programs have been developed over the world, including Utrecht University, that teach these technologies. Within the framework of a…

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…

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…

The use of technology such as computers and programmable calculators enables students to find p-values and conduct tests of hypotheses in many different ways. Comprehension and interpretation of a research problem become the focus for statistical analysis. This paper describes how to calculate chisquare statistics and p-values for statistical…

Presents activities for teaching the logistic growth model using calculators and spreadsheets. (ASK)