Phys 1102-1220 Example Spreadsheets
RICHMOND
- 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: |
| Expt 11: (No additional materials) |
|
Expt 12: |
|
Expt 13: |