EGR 105 Foundations of Engineering I

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 dont
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 ( A10C20 )
• 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 ( A10B17 ) )
• How to invoke
• Know the name of the function
• Function wizard button f x

25
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 ( )

26
Trigonometry

• PI ( )
• DEGREES (x)
• RADIANS (x)
• SIN (x)
• COS (x)
• TAN (x)

• ACOS (x)
• SINH (x)
• ATAN2 (x,y)

27
Logical Functions

• If test
• IF ( logical test, value if true, value if
  false )
• Example
• IF (A10 gt 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