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:

 

cooper@physics.usyd.edu.au

 

 

 

 

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.

 

 

 

 

 

 dividing_line

Ian Cooper
School of Physics
University of Sydney
2 September, 1999
 [hit counter]