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.


- Pp. i
Deane Arganbright
Download Free


- Pp. ii-iv (3)
Mark Lau, Stephen Sugden
Download Free


- Pp. v-vi (2)
Mark Lau, Stephen Sugden
Download Free

Fault Analysis in Power Systems

- Pp. 3-17 (15)
Mark A. Lau, Sastry P. Kuruganty
View Abstract

Use of Spreadsheets for Analyses in Structural Engineering

- Pp. 18-40 (23)
Nelson Lam
View Abstract

Optimal Control of Dynamical Systems

- Pp. 41-63 (23)
Mark A. Lau, William E. Singhose
View Abstract

Spreadsheet Conditional Formatting Illuminates Investigations into Modular Arithmetic

- Pp. 64-83 (20)
David Miller, Stephen Sugden
View Abstract

Computational Problem Solving in Context: From Arithmetic Sequences to Polygonal-like Numbers

- Pp. 84-106 (23)
Sergei Abramovich
View Abstract

Enzyme Kinetics for Novice Learners: Numerical Simulation in Excel

- Pp. 107-115 (9)
Scott A. Sinex, Barbara A. Gage
View Abstract

Project Management Spreadsheet Gaming Application

- Pp. 116-139 (24)
Wee Leong Lee
View Abstract

Teaching Portfolio Theory in an Equilibrium Setting with the Aid of Spreadsheet Tools

- Pp. 140-158 (19)
Clarence C.Y. Kwan
View Abstract

Forecasting with Innovation Diffusion Models: An Updated Example from the Telecommunications Industry 1994-2009

- Pp. 159-172 (14)
John F. Kros, S. Scott Nadler
View Abstract

School Mathematics with Excel

- Pp. 173-240 (68)
Jan Benacka
View Abstract

Graduates’ Use of Technical Software in Financial Services

- Pp. 241-260 (20)
Timothy Kyng, Leonie Tickle, Leigh Wood
View Abstract

Professional Development in Electricity Markets with Spreadsheet Models

- Pp. 261-273 (13)
Elliot Tonkes
View Abstract

Subject Index

- Pp. 274-279 (6)
Mark A. Lau, Stephen Sugden
Download Free


.Fundamentals of Educational Technology.
.Animal Models for Neurological Disorders.
.Virtual and Classroom Learning in Higher Education: A Guide to Effective Online Teaching.
.Physics Education for Students: An Interdisciplinary Approach.