Example Spreadsheets for Phys 1102 & Phys 1220 Labs - RICHMOND

Phys 1102-1220 Example Spreadsheets


  • 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 Spring 2014, 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:
The Prism Spectrometer
 Expt 2:
Thin Lenses (2 pages)
 Expt 3:
The Grating Spectrometer (2 pages)
 Expt 4:
The Michaelson Interferometer (2 pages)
 Expt 5:
(No additional materials)
 Expt 6:
(No additional materials)
 Expt 7:
(No additional materials)
 Expt 8:
(No additional materials)
 Expt 9:
DC Circuits (simplified) (2 pages)

 Expt 10:
Introduction to the Oscilloscope (RC Circuits) (2 pages)

 Expt 11:
(No additional materials)

 Expt 12:
Determination of e/m

 Expt 13:
The Current Balance