EGR 105 Foundations of Engineering I

1 / 16

# EGR 105 Foundations of Engineering I - PowerPoint PPT Presentation

EGR 105 Foundations of Engineering I. Fall 2008 – Day 3 Excel – Basics through Graphing. Time Management. Timesheet #2 due today (#1???) Civil Engineering reports due next Wednesday, Oct 1 Today’s assignment due Oct 7 Can also work on it next week, Oct 1 Work on your presentations…….

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about 'EGR 105 Foundations of Engineering I' - tala

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

### EGR 105 Foundations of Engineering I

Fall 2008 – Day 3

Excel – Basics through Graphing

Time Management
• Timesheet #2 due today (#1???)
• Civil Engineering reports due next Wednesday, Oct 1
• Today’s assignment due Oct 7
• Can also work on it next week, Oct 1
EGR105 – Day 3 Topics
• Excel basics
• Cell referencing
• Math functions
• Graphing
• Homework Assignment
Excel Basics
• Workbook organization
• Cells (row/col)
• Worksheets (names)
• Entering and formatting data
• Copy & paste
• Fill
• Simple math
• +, –, *, /, ^
• Entry starts with =
• “autosum”
• Relative copy for math operations
• Data sort
• Split window
Referring to Cells
• Standard way: row column notation
• Actually, letter number
• For fixed, add \$s (“absolute cell reference”)
• Cell names – can “rename” cells by changing content of box on upper left
• Useful for formulas
More Complicated Math
• What if you had to compute

or

n = number of

points

Built-in Functions in Excel
• Syntax:
• Entry always starts with an equal sign (=)
• Next is the name of the function followed by parentheses containing parameters or values to be operated on (arguments)
• Examples: = SUM ( A10:C20 )

= SQRT ( B17 )

• Many types available
• Composition of functions works:

= SQRT ( SUM ( A10:B17 ) )

• How to invoke:
• Know the name of the function
• Function wizard button: f x
Elementary Math

= SQRT (x)

= ABS (x)

= FACT (x)

= SUM (x1,x2,…)

= GCD (x1,x2,…)

= LCM (x1,x2,…)

= CEILING (x1,x2,…)

= ROUND (x)

= SUM (x1,x2,…)

= COUNT (x1,x2,…)

= EXP (x)

= LOG (x)

= LOG10 (x)

= POWER (x,y)

= RAND ( )

Trigonometry

= PI ( )

= DEGREES (x)

= SIN (x)

= COS (x)

= TAN (x)

= ACOS (x)

= SINH (x)

= ATAN2 (x,y)

Logical Functions
• If test:

= IF ( logical test, value if true, value if false )

• Example:

= IF (A10 >= B20,A10,0)

• Others: AND, NOT, OR
Statistics

= min (c1:d10)

= max (c1:d10)

= average (c1:d10)

= median (c1:d10)

= stdev (c1:d10)

= var (c1:d10)

Interfacing to the World
• Importing/Exporting data
• “open”
• “save as”
Graphics
• Excel’s terminology:
• “Chart”
• Engineers commonly use XY scatter, not line!!
• “Category” is the independent variable, horizontal axis, abscissa
• “Value” is the dependent variable, vertical axis, ordinate
• Excel’s plot wizard
Graphing Standards
• Symbolism:
• Experimental data
• Theoretical curves
• Labeling:
• Axes names
• Units
• Types of scales:
• Linear
• Range to show
• Semilog & log
• Multiple curves on one set of axes
• Legends
Homework Assignment

See passed out sheet or course web site