Lecture 5 - Using Excel

# Lecture 5 - Using Excel - • S = 51800 and N = 1000 • S...

This preview shows pages 1–4. Sign up to view the full content.

1/25/2010 1 TODAY’S TOPIC: Using Excel Engr 160 Using Excel How will learning this help me? You will learn how to perform calculations using Excel which will make solving problems less time consuming You learn how to save and print Excel files which will enable you to include Excel documents in reports, etc. Connecting to your Background Engr 160

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

View Full Document
1/25/2010 2 The Basics Opening and closing Save and print The “Ribbon” Changing Excel Options How to show equations in your spreadsheet Using the page break view Engr 160 Calculations Cell addresses Absolute \$A\$1 Relative A1 Relative formulas Absolute formulas Naming cells LN Log10 Sin, cos, tan, asin, acos, atan, exp, alog Engr 160
1/25/2010 3 Practice Problems Calculate the surface area and volume of a hollow sphere that has a wall thickness, t, of 3.10 mm and an outer diameter, d o , of 2.60 x 10 2 mm Calculate the natural log of 2.71 Calculate log 10 of 100, 1000, 10 0000 For the equation S = A*N b Find A and b when

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: • S = 51800 and N = 1000 • S = 150 000 and N = 10 000 Engr 160 Comparing What Makes Sense to What Does Not These Things Make Sense • Topic These Things Do Not Make Sense • Topic Engr 160 1/25/2010 4 Teaching your team Team Topic Discussion • Graph the following data using Excel – Theta, θ , starts at 0.0 and goes to 360.0 in steps of 5 degrees – F( θ ) = 100*cos( θ )*sin(2* θ ) • F( θ ) is frequency in Hz. • Label all axes and the graph using professional conventions • Compare values and determine the source of any differences Engr 160 Key points Today’s Assignment • Make an Excel spreadsheet that will calculate your GPA • Use radian measures for all trig functions • Pi = pi() • Pi = 4*atan(1.) • Starting with an equal sign means that you will be entering a formula • Log10 is base 10 log • Ln is base e log • Save your file frequently • Page break view before printing Engr 160...
View Full Document

## This note was uploaded on 02/09/2012 for the course ENGR 160 taught by Professor Sengupta during the Spring '07 term at Iowa State.

### Page1 / 4

Lecture 5 - Using Excel - • S = 51800 and N = 1000 • S...

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

View Full Document
Ask a homework question - tutors are online