COMPUTER LITERACY

1
COMPUTER LITERACY

• UNIT 6 COMPUTER
• SOFTWARE
• (ELECTRONIC SPREADSHEETS)

2
LEARNING OBJECTIVE

• At the end of the lesson, student
• will be able to demonstrate the
• way to enter a data on Excel
• document successfully

3
EXPLORE

• In 2 minutes
• launch Microsoft Office Excel 2007
• find the way to enter a data in Excel 2007

4
MS OFFICE EXCEL 2007 (CONT..)

• There are different ways to enter
• data in Excel

• In an active cell

• In the formula bar

5
MS OFFICE EXCEL 2007 (CONT..)

• ENTER DATA IN AN ACTIVE CELL

STEP 1 Click in the Cell where you want a
data STEP 2 Begin typing
6
MS OFFICE EXCEL 2007 (CONT..)

• ENTER DATA INTO THE FORMULA BAR

STEP 1 Click in the Cell where you would like
the data STEP 2 Place the cursor on the
Formula Bar STEP 3 Type in the data
7
ACTIVITY 1
8
LEARNING OBJECTIVE

• At the end of the lesson, student
• will be able to create a border on
• Excel document successfully

9
EXPLORE

• Find the way to create a border for a table in
  Excel 2007

10
MS OFFICE EXCEL 2007 (CONT..)

• CREATE A BORDER

STEP 1 Highlight the selected cell to create
border for a table E.g Click at cell A6 and
drag mouse to cell C17 to highlight the area
11
MS OFFICE EXCEL 2007 (CONT..)

• CREATE A BORDER

STEP 2 Click at Home Tab STEP 3 Click at the
Borders icon on the Font group
12
MS OFFICE EXCEL 2007 (CONT..)

• CREATE A BORDER

STEP 4 Choose the appropriate border E.g
Select All Borders icon
13
EXTEND

• How you create a border on Excel worksheet using
  previous version of Excel

Microsoft Office Excel 2003
14
ACTIVITY 2
15
LEARNING OBJECTIVE

• At the end of the lesson, student
• will be able to create a basic
• Mathematic formula on Excel
• document correctly

16
MS OFFICE EXCEL 2007 (CONT..)

• FORMULA
• A set of mathematical instructions that
• can be used in Excel to perform
• calculations

17
EXPLORE

• In 2 minutes
• find the right place to enter formula
• find the way to create formula

18
MS OFFICE EXCEL 2007 (CONT..)

• There are many elements to and excel formula

References The cell or range of cells that
you want to use in your calculation Operators
Symbols (,-,,/,etc) that specify
calculation to be performed
19
MS OFFICE EXCEL 2007 (CONT..)
Constants Numbers or text values that do not
change Functions Predefined formulas in
Excel
20
MS OFFICE EXCEL 2007 (CONT..)

• CREATE A BASIC FORMULA

STEP 1 Click at the Formula Bar STEP 2 Type
(the equal sign) and the formula STEP 3 Press
Enter
21
MS OFFICE EXCEL 2007 (CONT..)

• CREATE A BASIC FORMULA

OR STEP 1 Select the Cell for the formula STEP
2 Type (the equal sign) and the formula
STEP 3 Press Enter
22
MS OFFICE EXCEL 2007 (CONT..)

• BASIC MATHEMATICAL FORMULA

(SUM) STEP 1 Click at the D8 cell STEP
2 Type
STEP 3 Press Enter
23
MS OFFICE EXCEL 2007 (CONT..)

• BASIC MATHEMATICAL FORMULA

(MINUS) STEP 1 Click at the D8 cell STEP
2 Type
STEP 3 Press Enter
24
MS OFFICE EXCEL 2007 (CONT..)

• BASIC MATHEMATICAL FORMULA

(MULTIPLE) STEP 1 Click at the D8 cell STEP
2 Type
STEP 3 Press Enter
25
MS OFFICE EXCEL 2007 (CONT..)

• BASIC MATHEMATICAL FORMULA

(DIVIDE) STEP 1 Click at the D8 cell STEP
2 Type
STEP 3 Press Enter
26
ACTIVITY 3
234
3726

• 3.1
• Click on E7 cell
• Count data B9, B10 and B12

• 3.3
• Click on G7 cell
• Multiple data B10 and B8

• 3.2
• Click on F7 cell
• Minus data E7 and B10

• 3.4
• Click on H7 cell
• Divide data G7 and B13

55.61194
165
27
LEARNING OBJECTIVE

• At the end of the lesson, student
• will be able to produce sum
• percentage calculation on Excel
• document successfully

28
EXPLORE

• In 2 minutes, find the way to produce sum and
  percentage calculation from Excel 2007 menu

29
MS OFFICE EXCEL 2007 (CONT..)

• SUM FORMULA

STEP 1 Click your mouse inside cell B16 STEP
2 Click at the Auto Sum icon on Editing group
STEP 3 The pull down menu will appear and choose
Sum
30
MS OFFICE EXCEL 2007 (CONT..)

• SUM FORMULA

STEP 4 Your worksheet will look like
this STEP 5 Press Enter
31
MS OFFICE EXCEL 2007 (CONT..)

• PERCENTAGE FORMULA

STEP 1 Click your mouse inside cell B17 STEP
2 Type
B16/(8100)
32
MS OFFICE EXCEL 2007 (CONT..)

• PERCENTAGE FORMULA

STEP 3 Click on cell B17 STEP 4 Click on
Percentage icon on Number group STEP 5 Press
Enter
33
EXTEND

• How you create sum percentage formula on Excel
  using the previous version of Excel

Microsoft Office Excel 2003
34
ACTIVITY 4
35
LEARNING OBJECTIVE

• At the end of the lesson, student
• will be able to produce at least one
• chart in Excel document based on
• data provided successfully

36
EXPLORE

• In 2 minutes, find the way to create chart on
• Excel 2007 document

37
MS OFFICE EXCEL 2007 (CONT..)

• Charts allow you to present
• information contained in the worksheet
• in a graphic format
• Excel offers many types of charts including
• Column, Line, Pie, Bar, Area, Scatter and more

38
MS OFFICE EXCEL 2007 (CONT..)

• CREATE A CHART

STEP 1 Select the cell that contain the data
you want to use in the chart
39
MS OFFICE EXCEL 2007 (CONT..)

• CREATE A CHART

STEP 2 Select the Insert tab on the
Ribbon STEP 3 Select the type of Chart you
want to create
40
EXTEND

• How you create chart on Excel using the previous
  version of Excel

Microsoft Office Excel 2003
41
ACTIVITY 5
42
ACTIVITY 6
43
(No Transcript)
44
CONCLUSION

• The procedure to enter data on Excel document
  on cell or formula bar
• The procedure to create a border for Excel table
• The procedure to create basic formula sum,
  minus, multiple and divide
• The procedure to produce sum percentage
  calculation using Excel 2007 menu
• The procedure to produce a chart based on data in
  Excel