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.