|
|
|
|
|
|||
|
|
|
|
|
|||
|
|
MS EXCEL
SPREADSHEETS |
|
|
|||
|
|
|
|||||
|
This site is designed to help you with your studies in physics. This page is constantly being updated to make it more useful. To help make this site more valuable for you as a resource please send any comments or questions to: |
|
|||||
|
||||||
|
|
|
|||||
|
If you have MS EXCEL version 5 or later, you can download the EXCEL
tutorials / simulations onto your computer via the WEB. An advantage of this
approach is that you can then run the tutorial / simulation without the WEB
connection. The MS EXCEL spreadsheets have been devised to aid you in
increasing your understanding of the content covered in lectures. The
spreadsheets often contain content notes, graphs, pictures and simulations in
which you can change parameters to answer what if questions. Also, can "learn
a lot of physics" by working out how the simulation was constructed. |
|||||
|
|
|||||
|
|
Experimental Physics (LAB) Curve fitting and data analysis (wlsfit.xls) - used for graphing and analyzing data. The program does a weighted least squares on your data. Numerous functions can be tried. |
||||
|
|
Waves Waves Demonstrations (WAVESFB1.XLS) - This
program was created by Ferg Brand (Plasma Physics). It has a collected of
very useful demonstrations related to waves. Demonstration |
||||
|
|
Waves Waves Demonstrations (WAVESFB2.XLS) - This
program was created by Ferg Brand (Plasma Physics). There are two
demonstrations - Fourier Synthesis and Beats. Demonstration |
||||
|
|
Waves Traveling Waves (trlwave.xls) - you
can study the characteristics of traveling waves. Tutorial/Simulation. |
||||
|
|
Waves Standing waves: Strings (string.xls) - you
can study the behaviour standings waves due to the vibrations of string. Tutorial/Simulation |
||||
|
|
Waves Standing waves: Vibrating air columns in pipes (pipe.xls) - you
can study the behaviour standings waves due to the vibrations of air in a
pipe. Tutorial/Simulation |
||||
|
|
Waves Beats (beats.xls) - you can
examine the beat pattern produced by the superposition of two waves. You can change
the frequency difference between them by using the scroll button on Chart1. Simulation |
||||
|
|
Quantum A Particle Confined to a Box (box.xls) - you
can input different values for the quantum number n (worksheet Data) and view
the wavefunction and some expectation values. Simulation. |
||||
|
|
Nuclear Radioactive Decay Simulation (decay.xls) - This
is a simulation of the spontaneous decay of a population. It shows the random
nature of the decay and discusses how the decay process can be modeled. |
||||
|
|
|
||||
|
|
|
||||
Ian Cooper
School of Physics
University of Sydney
2 September, 1999