1 / 29

EGR 105 Foundations of Engineering I

EGR 105 Foundations of Engineering I. Fall 2007 – Week 2 Excel part 1. EGR105 – Week 2 Topics. Engineering numbers Class activity – transcript and GPA Excel basics Assignment # 2. How many engineers are there in the US?. Some have degrees and some don’t. 1,500,000.

Download Presentation

EGR 105 Foundations of Engineering I

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. EGR 105 Foundations of Engineering I Fall 2007 – Week 2 Excel part 1

  2. EGR105 – Week 2 Topics • Engineering numbers • Class activity – transcript and GPA • Excel basics • Assignment # 2

  3. How many engineers are there in the US?

  4. Some have degrees and some don’t 1,500,000 2,800,000 people have an engineering degree 1,300,000 1,700,000 people work in engineering jobs 400,000

  5. Where are they employed?

  6. Most work in the private sector

  7. Do they stay in engineering?

  8. Percentage by age still in engineering

  9. What else can you do with an engineering degree?

  10. Lots of careers: • Neil Armstrong – astronaut • Jimmy Carter – president • Alfred Hitchcock – movie director • Lee Iacocca – Ford and Chrysler executive • Tom Landry – Dallas Cowboys coach • John Sununu – politician • Scott Adams – Dilbert cartoonist

  11. Is the BS degree enough?

  12. Advanced degrees are popular

  13. Is an MBA or another masters degree key for getting into upper management?

  14. Percentage in ‘senior’ management with advanced degrees

  15. Can I get by without the BS?

  16. Percentage by job description with a BS degree

  17. Finally, how about starting salaries?

  18. Starting salaries for 2006 grads

  19. EGR105 – Week 2 Topics • Engineering numbers • Class activity – transcript and GPA • Excel basics • Assignment # 2

  20. How does URI compute GPA? Fall: Spring: EGR105 – A EGR106 – B+ PHY 203 – B PHY 204 – A- Fall GPA = ? Spring GPA = ? Overall GPA = ?

  21. EGR105 – Week 2 Topics • Engineering numbers • Class activity – transcript and GPA • Excel basics • Assignment # 2

  22. Excel Basics • Worksheet organization • Entering and formatting data • Copy, etc., autofill • Simple math ( +, –, *, /, ^, autosum ) • Cell entry starts with = • Relative copy for math operations • “autosum” button: 

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

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

  25. = 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 ( ) … Elementary Math

  26. = PI ( ) = DEGREES (x) = RADIANS (x) = SIN (x) = COS (x) = TAN (x) = ACOS (x) = SINH (x) = ATAN2 (x,y) … Trigonometry

  27. Logical Functions • If test: = IF ( logical test, value if true, value if false ) • Example: = IF (A10 >= B20,A10,0) • Others: AND, NOT, OR More in week 10………….

  28. EGR105 – Week 2 Topics • Engineering numbers • Excel basics • Assignment # 2

  29. Assignment # 2 • Create a simple spreadsheet of a transcript, including GPA calculation; see the handout for details • Save your workbook as lastname_2.xls • E-mail your result to me • Beware plagiarism

More Related