|Mathematics Books using Excel, available from Chartwell-Yorke|
|Mathematics with Excel David Sjostrand|
|This book leads you through some beautiful parts of the mathematical landscape and shows that Excel is a superb exploration tool. |
It shows how Excel can be used to visualize important mathematical ideas and make them concrete. The graphical features of Excel are used frequently.
Intended for students at secondary school and college level, the book contains many examples with detailed instructions and exercises. It can be used by students with little or no experience of spreadsheets as well as by advanced Excel-users. The reader is assumed to have access to Excel 5.0 although readers with older versions or other spreadsheets will find it useful.
The following topics are covered. Introduction to worksheets, charts and workbooks. Worksheet formulas. Copying formulas using absolute and relative references. Customizing Excel using Visual Basic macros and user-defined functions. Graph plotting in 2 and 3 dimensions. Shifts, reflections and rotations of curves. Numerical calculation of derivatives and integrals. Numerical solution of equations, systems of equations and differential equations. Direction fields. Simulation of motion. Matrices. Linear and non-linear optimization. Sets and algebraic structures, groups. Combined use of spreadsheets and computer algebra (DERIVE).
Contents: Worksheet formulas; Copying formulas using absolute and relative references; Customizing Excel using Visual Basic macros and user-defined functions; Graph plotting in 2 and 3 dimensions; Shifts, reflections and rotations of curves; Numerical calculation of derivatives and integrals; Numerical solution of equations; Systems of equations and differential equations; Direction fields; Simulation of motion; Matrices; Linear and nonlinear optimization; Sets and algebraic structures; Groups; Combined use of spreadsheets and computer algebra (DERIVE).
Reprint with amendments.
190 pp, 1994, 14.95 Pounds Sterling.
|Spreadsheets and Numerical Analysis D. McLaren|
|Using spreadsheets as a powerful tool to discover numerical analysis at college and undergraduate level. The text includes examples to illustrate the various methods discussed and includes appropriate sample spreadsheets. Many are structured so that the reader has the exercise of finishing them in order to see the results mentioned in the text. It is intended that readers' curiosity will lead them to explore beyond the given problems. |
The book is based on a second year course taught by the author in the La Trobe University School of Mathematics. The mathematical knowledge assumed is that gained from first-year mathematics, namely basic calculus and elementary matrix algebra.
Contents: Introduction to the spreadsheet; Convergence of sequences; Simultaneous linear equations; Solution of non-linear equations; Numerical integration; Ordinary differential equations; Partial differential equations.
250 pages, 1997, 15.95 Pounds Sterling.
|FREE DELIVERY in the UK. |
For overseas please ask.
Back to Chartwell-Yorke Maths Books Home Page
|Available from Chartwell-Yorke, 114 High Street, Belmont, Bolton, Lancashire, BL7 8AL, England. |
Tel (+44) (0)1204 811001, fax (+44) (0)1204 811008, firstname.lastname@example.org