Excel_tutorial - Physics Laboratory Tutorial Menu Excel...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Physics Laboratory Excel Tutorials Tutorial Menu 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. 1. Terminology 2. Arithmetic i. Addition ii. Other basic operators iii. Exponential operator iv. Referencing cells within formulas v. Three built in functions (SUM, AVERAGE, SQRT) 3. Basic Actions i. Create titles and headings ii. Add units to headings iii. Copy and paste your formula iv. Use correct significant figures v. Emphasize important text vi. Shade important cells vii. More cell manipulations (resize columns, change font styles, add borders) viii. That ###### error message ix. Display sample formulas x. Consult the page setup (print gridlines and row and column headings) 4. Algebra i. Thickness of sheet of paper ii. Distance traveled around a perimeter iii. Conversions iv. Solve a quadratic equation v. Determine the radius of a sphere vi. PI( ), a built-in constant vii. Copy and paste formulas 5. Displaying Symbols i. Display symbols with "Symbol" font ii. Display symbols with <ALT>+code 6. Trigonometry i. Using radians ii. Built-in trig functions (sine, cosine tangent, arcsine, arccosine, arctangent) iii. Finding the height of a tree
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 iv. Finding the launch angle of a ski ramp v. Verifying a trig identity 7. Graphing Data and Curve Fitting i. An experiment to determine π ii. How to plot a data set iii. Displaying units on the axes iv. Displaying symbols v. Add a trendline and equation to the graph vi. Altering the look of the displayed equation vii. Altering the attributes of the trendline viii. Calculating π from the slope (and finding % Error) 8. Advanced Graphing and Curve Fitting i. Creating plots of two data series on one graph ii. Altering the graph's legend iii. Fitting multiple curves on one set of data iv. Using error bars 9. Advanced Topics i. Creating user-defined constants ii. Adjusting the graph's scale 10. Using Excel's Statistics Commands i. Basic built-in functions (AVERAGE, MEAN, MODE, COUNT, MAX, MIN) ii. Linear regression equations (SLOPE, INTERCEPT, CORREL) iii. Error analysis tools (STDEV) iv. Miscellany (ABS) 11. Linear Regression and Excel i. Sample data ii. Linear regression equations iii. Applying regression to the sample data iv. Linear regression with built-in functions 12. Helpful Hints Concerning the Physics Lab Reports i. Work carefully ii. Neatly display your work iii. Display sample formulas iv. Check your work by hand v. Printing tips
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/24/2009 for the course PHY 092342 taught by Professor Knott during the Spring '09 term at Cosumnes River College.

Page1 / 49

Excel_tutorial - Physics Laboratory Tutorial Menu Excel...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online