Example Spreadsheets for Phys 1101 & Phys 1120 Labs - SURREY

Phys 1101-1120 Example Spreadsheets

SURREY

  • Below are PDFs of spreadsheets with (fake) example data entered into them in red. After creating your own spreadsheets for the labs, use these data to check whether you have typed your formulae correctly. You should be able to reproduce the calculated values in black.
  • Caveat:, These spreadsheets were created in August 2010, and although they have been checked carefully, there is still the possibility that typos remain in them. If you are unable to reproduce one of the answers, ask your lab instructor to help check your calculations.

 Expt 1
Acceleration on an Incline

 Expt 2
Uniform Circular Motion

 Expt 3
The Simple Pendulum

 Expt 4
Hooke's Law

 Expt 4 - IF HANGER AND ADDED MASSES WEIGHED TOGETHER
Hooke's Law - If Hanger and Added Masses Weighed Together

 Expt 5
Moment of Inertia

 Expt 5 - USING BLOCK
Moment of Inertia - Using Block (2 pages)

 Expt 6
Collisions (2 pages)

 Expt 7
Inelastic Collisions (2 pages)

 Expt 8
Resonance of a String

 Expt 9
Canimals

 Expt 10
Projectile Motion