egr 105 foundations of engineering i n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
EGR 105 Foundations of Engineering I PowerPoint Presentation
Download Presentation
EGR 105 Foundations of Engineering I

Loading in 2 Seconds...

play fullscreen
1 / 16

EGR 105 Foundations of Engineering I - PowerPoint PPT Presentation


  • 67 Views
  • Uploaded on

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…….

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

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


An Image/Link below is provided (as is) to download presentation

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

EGR 105 Foundations of Engineering I

Fall 2008 – Day 3

Excel – Basics through Graphing

time management
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……
egr105 day 3 topics
EGR105 – Day 3 Topics
  • Excel basics
  • Cell referencing
  • Math functions
  • Graphing
  • Homework Assignment
excel basics
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
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
More Complicated Math
  • What if you had to compute

or

n = number of

points

built in functions in excel
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
slide8

Some work on single arguments, some on groups of arguments, some on none

  • Composition of functions works:

= SQRT ( SUM ( A10:B17 ) )

  • How to invoke:
    • Know the name of the function
    • Function wizard button: f x
elementary math
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
Trigonometry

= PI ( )

= DEGREES (x)

= RADIANS (x)

= SIN (x)

= COS (x)

= TAN (x)

= ACOS (x)

= SINH (x)

= ATAN2 (x,y)

logical functions
Logical Functions
  • If test:

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

  • Example:

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

  • Others: AND, NOT, OR
statistics
Statistics

= min (c1:d10)

= max (c1:d10)

= average (c1:d10)

= median (c1:d10)

= stdev (c1:d10)

= var (c1:d10)

interfacing to the world
Interfacing to the World
  • Importing/Exporting data
    • “open”
    • “save as”
graphics
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
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
Homework Assignment

See passed out sheet or course web site