Doing Physics With Spreadsheets

by Aubrecht, Gordon J., II; Bolland, T. Kenneth; Ziegler, Michael G.

• ISBN13: 9780130214744
• ISBN10: 0130214744
• Edition: 3rd
• Format: Paperback
• Copyright: 1999-01-01
• Publisher: Pearson College Div

Table of Contents

Introduction: Why use spreadsheets?	1	(3)
Diagnostic for expertise in use of spreadsheets	3	(14)
Using spreadsheets to get an answer by successive approximation: an example	17	(10)
Creating a spreadsheet	27	(10)
Velocity	37	(10)
The spaceship	47	(4)
Determining constant acceleration from data	51	(8)
How to define a constant	59	(12)
Projectile motion	71	(6)
Air resistance	77	(14)
Rotational velocity and acceleration	91	(12)
Rotational motion: Solving a transcendental equation	103	(16)
Conservation of mechanical energy	119	(8)
Energy conservation for a circular object	127	(10)
Fluids	137	(8)
Oscillations	145	(10)
Energy conservation in rotational motion: the pendulum	155	(6)
Pendulum speed and tension	161	(8)
How harmonic is a pendulum?	169	(8)
Waves	177	(10)
Fields	187	(6)
Statistical mechanics	193	(10)
Thermodynamic processes	203	(6)
Thermodynamic cycles	209	(8)
Gauss's Law	217	(8)
Electric potential and conservation of energy	225	(14)
Relativity	239	(6)
Nuclear decay	245	(18)
Stellar Structure	263	(4)
Appendix	267	(2)
concordance	269