Physics with Excel and Python : using the same data structure. Volume I, Basics, exercises and tasks / Dieter Mergel.
2022
QC52
Linked e-resources
Linked Resource
Online Access
Concurrent users
Unlimited
Authorized users
Authorized users
Document Delivery Supplied
Can lend chapters, not whole ebooks
Details
Title
Physics with Excel and Python : using the same data structure. Volume I, Basics, exercises and tasks / Dieter Mergel.
Author
Mergel, Dieter, author.
Uniform Title
Physik mit Excel und Visual Basic. English
ISBN
9783030823252 (electronic bk.)
3030823253 (electronic bk.)
9783030823245
3030823253 (electronic bk.)
9783030823245
Published
Cham : Springer, 2022.
Language
English
Description
1 online resource (xvii, 482 pages) : illustrations (some color)
Item Number
10.1007/978-3-030-82325-2 doi
Call Number
QC52
Dewey Decimal Classification
530.0285
Summary
This book is intended to serve as a basic introduction to scientific computing by treating problems from various areas of physics - mechanics, optics, acoustics, and statistical reasoning in the context of the evaluation of measurements. After working through these examples, students are able to independently work on physical problems that they encounter during their studies. For every exercise, the author introduces the physical problem together with a data structure that serves as an interface to programming in Excel and Python. When a solution is achieved in one application, it can easily be translated into the other one and presumably any other platform for scientific computing. This is possible because the basic techniques of vector and matrix calculation and array broadcasting are also achieved with spreadsheet techniques, and logical queries and for-loops operate on spreadsheets from simple Visual Basic macros. So, starting to learn scientific calculation with Excel, e.g., at High School, is a targeted road to scientific computing. The primary target groups of this book are students with a major or minor subject in physics, who have interest in computational techniques and at the same time want to deepen their knowledge of physics. Math, physics and computer science teachers and Teacher Education students will also find a companion in this book to help them integrate computer techniques into their lessons. Even professional physicists who want to venture into Scientific Computing may appreciate this book.
Note
Includes index.
Access Note
Access limited to authorized users.
Source of Description
Online resource; title from PDF title page (SpringerLink, viewed January 17, 2023).
Available in Other Form
Physics with Excel and Python
Linked Resources
Online Access
Record Appears in
Online Resources > Ebooks
All Resources
All Resources
Table of Contents
1 Introduction: What do you need, what do you learn
2 Sets of curves
3 Networks of formulas
4 Macros
5 Basic mathematical techniques
6 Superposition of motions
7 Random numbers and random number generators
8 Evaluation of measurements
9 Trend curves
10 Integration of Newton's equation of motion.
2 Sets of curves
3 Networks of formulas
4 Macros
5 Basic mathematical techniques
6 Superposition of motions
7 Random numbers and random number generators
8 Evaluation of measurements
9 Trend curves
10 Integration of Newton's equation of motion.