Spreadsheets Lab
Safety Concerns
- Be sure to save data often. Losing work to a crash can cause outbursts of profanity.
Materials
- Previous lab data
- Laptop
- Access to Excel/Word or Docs/Sheets
Ohm’s Law Lab Revisited
- Review slopes and areas
- Cover techniques for finite differences in spreadsheets
- Revisit Ohm’s Law objectives and data
- Design raw data tables
- Design graph
- Fit slope to graph
- Use slope to verify resistance
- Create doc with explanation and include graphs
- You will share this document
Conduction Lab Revisited
- Cover examples of similar calculations in a scientific computing environment
- Revisit Conduction Lab objectives and data
- Design raw data tables
- Design graph
- Fit slope to graph
- Use slope to determine UA value
- If time, compute expected UA value
- Create doc with explanation and include graphs
- You will share this document
Exercises
1 Review Slopes and Areas
Review the linked notes on Slopes and Areas.
Think about
- How we have arranged our equations and axes so that the slope tells us a quantity we want to know.
- How you would calculate these slopes using the data that you have taken in your tables.
Turn in a brief description (a couple of sentences) of concepts or ideas you want to strengthen your understanding of.
2 Ohm’s Law Report Document
Turn in a document based on your results from the Ohm’s Law lab. You may use Excel/Word or Sheets/Docs but please turn in a PDF.
- Include a table of data fro the Ohm’s Law lab
- Include a graph from the Ohm’s Law lab pasted into the document.
- Include a numerical calculation of the slope and describe the implication.
- Include a short statement in the document about how the data was collected.
3 Conduction Lab Report Document
Turn in a document based on your results from the Conduction lab. You may use Excel/Word or Sheets/Docs but please turn in a PDF.
- Include a table of data from the Conduction lab
- Include a graph from the Conduction lab pasted into the document.
- Include a numerical calculation of the slope and describe the implication.
- Include a short statement in the document about how the data was collected.