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 $133
Printed Copy: US $118
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, Stephen Sugden
Download Free

Contributors

- 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

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, William E. Singhose

PDF Price: $15

View Abstract Purchase Chapter

Spreadsheet Conditional Formatting Illuminates Investigations into Modular Arithmetic

- Pp. 64-83 (20)
David Miller, 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, 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, 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, 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, Stephen Sugden
Download Free

RELATED BOOKS

.Architecture in Cinema.
.Navigating through Technology in Modern Education.
.IInd International Conference "Open Science and Innovation in Ukraine 2023".
.Virtual Lifelong Learning: Educating Society with Modern Communication Technologies.