Editors: Mark A. Lau , Stephen J. Sugden

Applications of Spreadsheets in Education The Amazing Power of a Simple Tool

eBook: US $29 Special Offer (PDF + Printed Copy): US $121
Printed Copy: US $107
Library License: US $116
ISBN: 978-1-60805-592-0 (Print)
ISBN: 978-1-60805-276-9 (Online)
Year of Publication: 2011
DOI: 10.2174/97816080527691110101


This e-book is devoted to the use of spreadsheets in the service of education in a broad spectrum of disciplines: science, mathematics, engineering, business, and general education. The effort is aimed at collecting the works of prominent researchers and educators that make use of spreadsheets as a means to communicate concepts with high educational value. The e-book brings some of the most recent applications of spreadsheets in education and research to the fore. To offer the reader a broad overview of the diversity of applications, carefully chosen articles from engineering (power systems and control), mathematics (calculus, differential equations, and probability), science (physics and chemistry), and education are provided. Some of these applications make use of Visual Basic for Applications (VBA), a versatile computer language that further expands the functionality of spreadsheets.

The material included in this e-book should inspire readers to devise their own applications and enhance their teaching and/or learning experience.


A little over 30 years have passed since the first spreadsheet, VisiCalc, made its appearance as an exciting and effective computer tool for accounting and business modeling. In the ensuing years, educators have increasingly recognized that the spreadsheet has extraordinary potential for other applications as well. Today, not only are spreadsheets, as exemplified by Microsoft Excel, among the most widely-used modeling and mathematical tools of the workplace, but they also find abundant use in diverse areas of education. In addition to business-related areas, usage flourishes in mathematics, the natural and social sciences, engineering, and many other areas. The spreadsheet's natural, approachable tabular format and its operations that are acquired readily make it accessible to students. With their formidable graphics features, user tools, and programming capabilities, spreadsheets are effective tools for teachers, students, and researchers.

Yet, even today the value of spreadsheets in education is not always fully recognized. To address that situation, this book supplies readers with a substantial variety of educational applications for spreadsheets, from fields such as engineering, mathematics, science, and business. The diverse applications show two principal ways of using a spreadsheet. First, it is a natural tool for designing applications directly from first principles and then experimenting with the resulting model. Second, it provides an accessible way to implement models and algorithms that are first derived analytically by traditional methods. In either way, a major advantage of the spreadsheet approach is to make more topics accessible to students that may otherwise be too advanced for them.

Using the book's applications, instructors and students can investigate and interrogate the various models in the traditional "What if . . .?" spreadsheet manner by varying its parameters values. They also can visualize the results in both the attractive graphs and the well-designed spreadsheet displays that are presented.

The examples provided include a number that are of a sophisticated nature, showing how spreadsheet usage can be extended to more complex problems. Several examples examine models that use a difference equation approach that is natural for the spreadsheet medium to implement numerical analysis algorithms for topics coming from calculus, linear algebra, and ordinary and partial differential equations.

Throughout the book readers also will encounter the use of powerful tools provided on a spreadsheet such as Excel, including built-in and user-designed functions, matrix operations, a solver, sliders, and VBA programming. Finally, in addition to providing a wealth of useful examples, each chapter contains numerous references and a list of other related topics and problems to pursue, as well as ways in which spreadsheet usage can be incorporated into the classroom, assignments, and group projects. This book represents a very useful contribution to the literature on the educational uses of spreadsheets.

Deane Arganbright
Martin, Tennessee, USA
and Divine Word University, Papua New Guinea


.Reshaping Universities for Survival in the 21st Century: New Opportunities and Paradigms.
.The Psychology of Cinematic Popular Culture and Educators’ Reflective Practices.
.Inside the New University: Prerequisites for a Contemporary Knowledge Production.
.Supervising and Writing a Good Undergraduate Dissertation.