Physics
Laboratory
Excel
Tutorials


Physics Tutorials
E

Tutorial Menu 1. Terminology
F


Hello, and welcome to my Microsoft Excel tutorials. I've created these pages to supplement your physics laboratory course here at Clemson University. Most of our lab courses require using Excel or some similar spread sheet application to display data, perform calculations and create plots. These tutorials are designed to familiarize our lab students with specific Excel tasks, which are required for successful completion of the course.

There are dozens of ways to perform the same Excel operation. In these tutorials I present various techniques and methods that I have found works well for me. Below is a listing of the 10 tutorials and their subheadings. Even if you are familiar with Excel, you should start at the beginning and work your way to the end. (At a minimum L200 and L207 students should be familiar with Tutorials 1, 2, 3, 7 and 10.)

  1. Terminology
  2. Arithmetic
    1. Addition
    2. Other basic operators
    3. Exponential operator
    4. Referencing cells within formulas
    5. Three built in functions (SUM, AVERAGE, SQRT)
  3. Basic Actions
    1. Create titles and headings
    2. Add units to headings
    3. Copy and paste your formula
    4. Use correct significant figures
    5. Emphasize important text
    6. Shade important cells
    7. More cell manipulations (resize columns, change font styles, add borders)
    8. That ###### error message
    9. Display sample formulas
    10. Consult the page setup (print gridlines and row and column headings)
  4. Algebra
    1. Thickness of sheet of paper
    2. Distance traveled around a perimeter
    3. Conversions
    4. Solve a quadratic equation
    5. Determine the radius of a sphere
    6. PI( ), a built-in constant
    7. Copy and paste formulas
  5. Displaying Symbols
    1. Display symbols with "Symbol" font
    2. Display symbols with <ALT>+code
  6. Trigonometry
    1. Using radians
    2. Built-in trig functions (sine, cosine tangent, arcsine, arccosine, arctangent)
    3. Finding the height of a tree
    4. Finding the launch angle of a ski ramp
    5. Verifying a trig identity
  7. Graphing Data and Curve Fitting
    1. An experiment to determine p
    2. How to plot a data set
    3. Displaying units on the axes
    4. Displaying symbols
    5. Add a trendline and equation to the graph
    6. Altering the look of the displayed equation
    7. Altering the attributes of the trendline
    8. Calculating p from the slope (and finding % Error)
  8. Advanced Graphing and Curve Fitting
    1. Creating plots of two data series on one graph
    2. Altering the graph's legend
    3. Fitting multiple curves on one set of data
    4. Using error bars
  9. Advanced Topics
    1. Creating user-defined constants
    2. Adjusting the graph's scale
  10. Using Excel's Statistics Commands
    1. Basic built-in functions (AVERAGE, MEAN, MODE, COUNT, MAX, MIN)
    2. Linear regression equations (SLOPE, INTERCEPT, CORREL)
    3. Error analysis tools (STDEV)
    4. Miscellany (ABS)
  11. Linear Regression and Excel
    1. Sample data
    2. Linear regression equations
    3. Applying regression to the sample data
    4. Linear regression with built-in functions
  12. Helpful Hints Concerning the Physics Lab Reports
    1. Work carefully
    2. Neatly display your work
    3. Display sample formulas
    4. Check your work by hand
    5. Printing tips (making your work easy to read, easy to grade, and adjusting it to fit neatly on the printed page)

Of course, Microsoft Excel has an extensive built-in help application and you are encouraged to use it to dig deeper into the capabilities of the spread sheet program. These pages are intended to be used by the uninitiated physics laboratory student as a basic tutorial on getting started with Excel.

please let me() know if you find these tutorials helpful. I appreciate any feedback you may have.



If you have a question or comment, send an e-mail to Lab Coordinator: Jerry Hester


 
Physics Tutorials
E

  1. Terminology
F

   

Copyright © 2006, Clemson University. All Rights Reserved.
Photo's courtesy Corel Draw.
Last Modified on 01/27/2006 14:25:18.