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

Introduction

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.

Foreword

- Pp. i
Deane Arganbright
Download Free

Preface

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

Contributors

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

Fault Analysis in Power Systems

- Pp. 3-17 (15)
Mark A. Lau and Sastry P. Kuruganty

PDF Price: $15

View Abstract Purchase Chapter

Use of Spreadsheets for Analyses in Structural Engineering

- Pp. 18-40 (23)
Nelson Lam

PDF Price: $15

View Abstract Purchase Chapter

Optimal Control of Dynamical Systems

- Pp. 41-63 (23)
Mark A. Lau and William E. Singhose

PDF Price: $15

View Abstract Purchase Chapter

Spreadsheet Conditional Formatting Illuminates Investigations into Modular Arithmetic

- Pp. 64-83 (20)
David Miller and Stephen Sugden

PDF Price: $15

View Abstract Purchase Chapter

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

- Pp. 84-106 (23)
Sergei Abramovich

PDF Price: $15

View Abstract Purchase Chapter

Enzyme Kinetics for Novice Learners: Numerical Simulation in Excel

- Pp. 107-115 (9)
Scott A. Sinex and Barbara A. Gage

PDF Price: $15

View Abstract Purchase Chapter

Project Management Spreadsheet Gaming Application

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

PDF Price: $15

View Abstract Purchase Chapter

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

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

PDF Price: $15

View Abstract Purchase Chapter

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

- Pp. 159-172 (14)
John F. Kros and S. Scott Nadler

PDF Price: $15

View Abstract Purchase Chapter

School Mathematics with Excel

- Pp. 173-240 (68)
Jan Benacka

PDF Price: $15

View Abstract Purchase Chapter

Graduates’ Use of Technical Software in Financial Services

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

PDF Price: $15

View Abstract Purchase Chapter

Professional Development in Electricity Markets with Spreadsheet Models

- Pp. 261-273 (13)
Elliot Tonkes

PDF Price: $15

View Abstract Purchase Chapter

Subject Index

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

RELATED BOOKS

.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.