Lab 0

1
Lab 0
Logging in and Using Excel

• Sociology 549
• Paul von Hippel

2
Where you are

• Sociology Instruction Lab (SIL), 70 Derby Hall
• used for computer courses

3
Logging in to the SIL

• Turn on computer
• Enter your user name
• If your OSU email is buendia.100_at_osu.edu
• then your SIL user name is buendia.100
• not the same as in SRL
• Enter your password
• your first initial last 4 digits of your SS
  your last initial
• e.g., Jose Arcadio Buendia, SS 100-10-0100

4
Launching Excel

• Lower left corner, click Start
• Choose
• Programs
• Office Productivity
• Microsoft Excel

5
Entering data

• Enter the following data

• Columns are letters A-D
• Rows are numbers 1-2
• Cells are column-row combinations
• e.g., 1991 is in cell A2

6
Saving a spreadsheet

• File
• Save (or Save As)
• Desktop
• My Computer
• X
• This is your personal storage area
• Call the file anything you want
• Then
• File
• Exit

7
Opening a spreadsheet

• From Desktop
• My Computer
• S
• 549 von Hippel
• MissAmericas.xls (double-click)

8
Formulas

• Convert inches to meters

9
Formulas

• Convert pounds to kilograms

10
Repeat formulas (fill)

• Check it out

11
Repeat formulas Another way

• Check it out

12
Squaring (2)

• Calculate body mass index (BMI)

13
Formulas for groups of cells
Average18.7
14
Other operations used in statistics

• Weve seen
• addition (), division (/), and squaring (2)
• Multiplication and subtraction -
• e.g., A2sum(D2D4)-G3
• Square root
• e.g., sqrt(average(C1C3))

15
To learn more about Excel

• Help menu
• Statistics with Microsoft Excel
• Now
• File
• Exit
• Save to X if you want
• See you Wednesday!