Docstoc

EGR 105

Document Sample
EGR 105 Powered By Docstoc
					         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
                    2,800,000 people have
                    an engineering degree


      1,300,000
                  1,700,000 people work in
                  engineering jobs
       400,000
Where are they employed?
Most work in the private sector

 Employment sector     Percentage
 Industry                 68%
 Self-employed            12%
 Government               13%
 Education and other      9%
Do they stay in engineering?
       Percentage by age still in
             engineering
80

70

60

50

40

30

20

10

0
     25-29   30-34   35-39   40-44   45-59   50-54   55-59   60-64   65 & up
What else can you do with an
   engineering degree?
              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
Is the BS degree enough?
Advanced degrees are popular
     BS degree only   1,637,000
     BS + MS            396,000
     BS + PhD            80,000
     Eng + Business     226,000
     Eng + Science      162,000
     Eng + Other        114,000
Is an MBA or another masters
  degree key for getting into
     upper management?
Percentage in „senior‟ management
     with advanced degrees
 40

 35

 30

 25

 20

 15

 10

  5

  0
      Eng only   Eng + Science   Eng + Business   Eng + Other
Can I get by without the BS?
      Percentage by job description
           with a BS degree
100
90
80
70
60
50
40
30
20
10
 0
      civil   mechanical   electrical   biomedical   environmental   computer   computer
                                                                     hardware   software
Finally, how about starting
          salaries?
Starting salaries for 2006 grads
Chem Eng        $56,335   Comp Sci       $51,305
Comp Eng        $54,200   Accounting     $45,656
Elect Eng       $53,552   Finance        $45,112
Mech Eng        $51,732   Business       $42,048
Indust Eng.     $49,567   Nursing        $38,775
Civil/Env Eng   $46,023   Marketing      $37,832
                          Liberal Arts   $30,958
      EGR105 – Week 2 Topics
•   Engineering numbers
•   Class activity – transcript and GPA
•   Excel basics
•   Assignment # 2
 How does URI compute GPA?
Fall:             Spring:
  EGR105 – A      EGR106 – B+
  PHY 203 – B     PHY 204 – A-


Fall GPA = ?
Spring GPA = ?
Overall GPA = ?
      EGR105 – Week 2 Topics
•   Engineering numbers
•   Class activity – transcript and GPA
•   Excel basics
•   Assignment # 2
                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: 
    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
• 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
= SQRT (x)            = SUM (x1,x2,…)
= ABS (x)             = COUNT (x1,x2,…)
= FACT (x)            = EXP (x)
= SUM (x1,x2,…)       = LOG (x)
= GCD (x1,x2,…)       = LOG10 (x)
= LCM (x1,x2,…)       = POWER (x,y)
= CEILING (x1,x2,…)   = RAND ( )
= ROUND (x)           …
            Trigonometry
= PI ( )          = ACOS (x)
= DEGREES (x)     = SINH (x)
= RADIANS (x)     = ATAN2 (x,y)
= SIN (x)         …
= COS (x)
= TAN (x)
             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………….
   EGR105 – Week 2 Topics
• Engineering numbers
• Excel basics
• Assignment # 2
         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

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:13
posted:8/14/2011
language:English
pages:29