ICT IV Plan

LESSON PLAN IN ICT 4
Competency:
Demonstrate functional knowledge and

skills in word processing.
I. OBJECTIVES:
1.
Demonstrate skills in listening to audio-guided instructions.
2.
Perform instructions of the audio-guided tutorial.
3.
Follow and conform to the level-by-level tutorial from basic to

advance.
4.
Give importance to honesty and perseverance.
II. SUBJECT MATTER:

Topic:
MICROSOFT WORD TUTORIAL
Materials:
MSOffice Tutorial Program, Personal Computer,

earphone, notebook
Reference:
Tudlo Mindanao ICT Materials
III. PROCEDURE:
A. OPENING PRAYER
B. MOTIVATION:
Competition: on signal by the teacher, students are to boot
their units. First and proper booting earns a point of 50; deducting
one (1) point each delay in time.
C. ACTIVITIES
Lesson Plan in ICT IV
1.Introduction to the program

2. Follow the 40 boxes/levels of the tutorial program within the
three levels of improvement, BASIC-INTERMEDIATEADVANCE and note taking.
BASIC LEVEL
1)
3)
5)
7)
9)
11)
13)
15)
Opening a document
Saving a document
Inserting Text
Placing Text on screen
Using Undo
Collect and paste
Using the spelling checker
Print preview
2)
4)
6)
8)
10)
12)
14)
16)
Opening an existing document

Expanding Menus
Selecting Text
Deleting text
Copy and paste
Cutting text
Page orientation
Printing a document
18)
20)
22)
24)
26)
Aligning text
Go to, find and replace
Page break
Changing spacing
Indents
28)
30)
32)
34)
36)
38)
40)
Create a table
Merge/split cells
Create/apply styles
Importing graphics
Creating versions
Mail merge
Macros
INTERMEDIATE LEVEL
17)
19)
21)
23)
25)
Formatting text
Changing margins
Headers and footers
Viewing documents
Tabs
ADVANCE LEVEL
27)
29)
31)
33)
35)
37)
39)
Convert text to tables

Add/delete rows and columns
Borders and shading
Bullets/number lists
Creating columns
Creating data source
Text boxes
D. CLOSING PRAYER
IV. EVALUATION:
Quiz- Categorize the following according to what menu it
belong:
FILE
Page
Set-Up
EDIT
Paste
Special
VIEW
Header
/Footer
INSERT
Page
Number
Save
Cut
Zoom
Text Box
Print
Copy
Toolbars
Paste
Print
Layout
Open
Page Set-Up
Page Number
Insert Table
Zoom
Auto Fit
Toolbars
Letter Wizard
Paste
Columns
Borders And Shading
TOOLS
Spelling
Checker
TABLE
Insert
Table
Borders And
Shading
Mail Merge
Auto Fit
Symbol
Change Case
Letter
Wizard
Merge
Cells
Auto Text
Columns
Macros
Convert
Paste Special
Paragraph
Save
Text Box
Print
Symbol
Merge Cells
Print Layout
Macros
FORMAT
Paragraph
Header /Footer
Spelling Checker
Cut
Mail Merge
Copy
Change Case
Open
Auto Text
Convert
Direction: Label the following icons, symbols and buttons with

the number that corresponds to your answer using the
legends prepared.
Table AutoFormat
Insert Table
Print Preview
Distribute Rows Evenly
Align Right
Free Rotate
Print
Bold
Line style
Font Color
Clipart
Format Painter
Sort Descending
Merge Cells
Standard Toolbar
Restore
Minimize
Redo
Italic
Draw Table
Font size
Spelling & Grammar
Save
Font
Style
Eraser
Copy
Zoom
Highlight
Cell Align Center
MSWord Help
Text Box
Open
Bullets
18 Tables and Borders Toolbar
Align Left
Paste
Shading Color
26 Distribute Columns Evenly
Columns
Underline
Undo
Formatting Toolbar
Tables and Borders
New Document
Line color
Numbering
Superscript
Close
Insert WordArt
Cut
V. ASSIGNMENT
Familiarize the different shortcut icons and symbols.

Competency:

I. OBJECTIVES:
1. Define parts of the MS Word window.
2. Identify and discuss different parts of a MS Word window.
II. SUBJECT MATTER:
Topic:
THE MICROSOFT WORD SCREEN
Materials:
Personal Computer, MSWord Program
References:
1. Workbook on EDP Concepts with Windows Application by
Rollan and Gatpandan pp. 1-2;
2. Microsoft Made Easy by Roland Go pp.
3. Tudlo Mindanao Handouts
III. PROCEDURE:
A. OPENING PRAYER
B. ACTIVITIES:
1. APPLICATION PROGRAM ACTIVATION:
Microsoft Word is a word processing application that is
used to create written documents letters, memos, research
papers and so forth. To open MS Word application program

from your desktop follow the following steps:
1) Click on the Start button if your using the mouse or press
CTRL + ESC if your using the keyboard. If the application
logo is already on your desktop, double click it to activate
the program.
2) From the start menu, choose programs.
3) From the submenu, choose Microsoft Office, then Microsoft
Word.
After following the series of steps above, you will see MS
Words application logo for a few seconds and then the main
screen appears with a blank document ready for input.
C. CLASS DISCUSSION
The following are the basic parts of the MSWord screen:
Title Bar: Located at the very top of your screen. Displays
the program name and the name of the document
being edited.
Menu Bar: Contains the main word for Windows menu.
Standard toolbar: Displays the buttons that you can select

to perform common editing task.
Formatting toolbar: Use to select character and

paragraph formatting commands to enhance the look of your
document.
Ruler:
control margins, indents and tab alignment.
Work area: also called text area, the place where your word
document appears.
Scroll Bar:
Status bar: displays information about your word document

(e.g. Page Number, section number, etc.)
Appear along the bottom and

right edges of the word screen and is use to move up and
down, left or right of your screen.
DOCUMENT VIEW: With word you can display your
document in one of the four views: Normal, Outline, Print
Layout and Online or Web Layout.
a. Normal view is the most often used and shows such
formatting as line spacing, font, point size, and
italics. Multiple-column text is displayed in one
continuous column.
b. Outline view displays the document in outline form.
Headings can be displayed without the text. A
heading can be moved and the accompanying text

moved with it.
c. The Page Layout view shows the document as it will
look when it is printed.
d. The Online Layout view optimizes the document for
online viewing (viewing the document in a browser).
IV. EVALUATION:
Proper activation of the Microsoft Word Application Program.
Quiz: Label the following
parts of a document
window using a number,
which corresponds to the
list below. Write your
answer on the boxes
provided.
1
2
3
4
5
6
7
8
9
10
Vertical Ruler
Horizontal Ruler
Vertical Scroll Bar
Horizontal Scroll Bar
Title Bar
Standard Toolbar
Menu Bar
Formatting Toolbar
Text Area
Tables And Borders Toolbar
AGREEMENT:
Familiarize icons, graphics, and symbols.

Competency:

I. OBJECTIVES:
1.
Utilize the general operations of a word processor.
2.
Create a personal folder.
3.
Save a file onto personal folder.
II. SUBJECT MATTER:

Topic:
CREATING A FOLDER
Materials:
Personal Computer, MS Word Program
Reference:
Tudlo Mindanao Handouts
III. PROCEDURE:
A. OPENING PRAYER
B. Booting of units
C. REVIEW:
What are the different parts of a MS Word screen? (point it out
on your display)
D. Create new document.
E. Click on the File Menu, look for Save As, and open it.
F.
Click on create new folder and type your name and click OK.
G. Exit
IV. EVALUATION:
Check for folder and file on desktop 30 points
V. ASSIGNMENT: Recall and familiarize process.

Competency:
Demonstrate functional knowledge and skills

in word processing.
I. OBJECTIVES:
1. Describe the process of creating graphic images on the
computer.
2. Import picture from Encarta using print screen.
3. Edit picture using paint program.
II. SUBJECT MATTER:
Topic:
IMPORTING
PROGRAMS
GRAPHICS
FROM
Reference:
Materials:
Personal Computer, MS Word Program, Paint

Program, MS Encarta Program
III. PROCEDURE:
A. Opening Prayer
B. Booting of units
C. Create new document and minimize window.
D. Open Microsoft Encarta, type in Beethoven and search for an
image and then press Print Screen on the keyboard.
E. Close Encarta program and open Paint program.
OTHER
F.
From the edit menu click paste to paste copied image using
print screen.
II. SUBJECT MATTER:

Topic:
INSERT CLIP ART IMAGE
G. Using select button on the paint toolbar, select and frame only
the picture of Beethoven and copy it using edit menu then
close paint program.
Reference:
Materials:
H. Create new document from MS Word application program and

paste graphics.
III. PROCEDURE:
I.
Format picture into 3 x 3 size and center align.
J.
Save output with file name Beethoven and send to own folder.
IV. EVALUATION:
Check folder for Beethoven Filename in its 3 x 3 size graphics
inside.
Non-compliance of requirement means 2 points deduction each
time.
Competency:

in word processing.
I. OBJECTIVE:
Insert clip art image into a Word document.
A. OPENING PRAYER
B. ACTIVITIES
1. Booting of units
2. Type the following text. (Font size 18, Font style Monotype
Corsiva, single space, center justified in a short size paper
and landscape orientation with 1 inch margin all sides).
Life is not a matter of extent but content,
not so much of action but intention,
not so much of quantity but quality,
not so much of results but efforts.
Life is not a matter of power but of character,
not a matter of popularity but personality,
not a matter of superiority but dignity,
not a matter of enjoying money but harmony.
Life is not just a question of ability but responsibility,
not just a question of aptitude but attitude,
not just a question of magnitude but gratitude.
In the final analysis, life is not a matter of

How much you have done? but
How much you have loved?
definite size of your image, click on the picture till the sizing
handles appear and go to format menu then picture, and
click size tab. Uncheck radio button containing lack aspect
ratio and relative to original picture to get exact size.
Resize your picture to 6.5 H x 5 W.
12. Right click now on the clip art image to display a shortcut
menu.
3.
Place the insertion point at the beginning of the document.
4.
Click Insert from the menu bar, then from the pull-down
menu choose Picture then Clip Art.
5.
From the Insert ClipArt dialogue box, click the Pictures tab if
necessary.
14. In the Format picture dialogue box, click the layout tab to
display the wrapping options.
6.
Scroll down until you see the Nature category and click on it
7.
Nature clip art images are displayed. Click the Sunshine

image. A pop-up menu is displayed.
15. Click Square in the wrapping style section. Confirm that the
Left choice is selected for horizontal alignment.
8.
Click the insert clip button in the pop-up menu to place the
image in the document. Click the close button on the dialog
box. The image now will be inserted, but may not be in the
position and size that you want.
9.
To resize the image click on it, the sizing handles at the

corners of and in the middle of the images edges indicate
that the image is selected.
10. Move the pointer onto the sizing handle in the lower-right
corner. The pointer changes to a diagonal two-sided arrow.
11. Click and hold down the left mouse button and drag the
sizing handle up and to the left until the image is about four
inches wide and then release the mouse button. To have a
13. From the shortcut menu, choose Format Picture.
16. Press enter or click OK button. The text now of your

document is wrapped at the right side of the clip art image.
17. Save your output with the following LIFE 1 <your name>
and send it to your own folder.
C. CLOSING PRAYER.
IV. EVALUATION:
Check for folder content LIFE 1 <user name> = 30 points
Non-compliance of requirements means 2 points deduction each
time.

Competency:

in word processing.
I. OBJECTIVE:
IV. EVALUATION
Check formatted LIFE 1 file with page border following requisites =
30 pts. Non-compliance means 2 pts deduction.
V. AGREEMENT. Recall entire process.
Insert page border to LIFE 1 file.

II. SUBJECT MATTER:
Topic:
BORDERS AND SHADING
Materials:
Reference:
III. PROCEDURE

Competency:

in word processing.
I. OBJECTIVE:
Show functional skills in using WordArt.
II. SUBJECT MATTER:
A. OPENING PRAYER
Topic:
WORDART
B. ACTIVITIES
Reference:
Materials:
1. Open LIFE 1 file from your folder, go to Format Menu from

the menu bar, and choose Borders and Shading.
2. Click Page Border tab, click box setting, and choose the art
you like to appear on your screen. Adjust the width of your art
and go to options button and set the margin of your bottom
and right margin to 31 pt to avoid cuts during printing and
uncheck Always Display In Front Box.
3. Press Enter or click the OK button. Your output now has a
page border around it.
C. CLOSING PRAYER
III. PROCEDURE
A. OPENING PRAYER
B. ACTIVITIES
1. Open LIFE 1 File and copy text and image then close file.
2. Create new document and paste copied text and image.
3. Set the page to long size paper, margin of 1 inch all sides
and landscape orientation.
4. Place the insertion point at the beginning of the text and

press enter until it goes down to the third page.
5. Click on the picture and resize it to 6.5 x 10.5 wrapping it to
Square style in the Layout tab and select Center choice to
place the picture at the center of your first page.
6. Work on your second page by putting the insertion point at
the beginning then go to Insert Menu, choose Picture then
WordArt or click WordArt shortcut icon on your WordArt
toolbar to activate it.
7. Your WordArt gallery pops up and choose the first design,
which is transparent.
8. Type the word LIFE (Uppercase) and choose from the wide
range of fonts then click ok.
9. Expand the WordArt by stretching it over the entire paper
using the sizing handles living an allowance for the margins.
10. Right click on the WordArt design and choose Format
WordArt. Click on Color and Lines Tab and click expanded
arrow of color fill. Format the WordArt color using trying
and choosing from the following:
Fill choose from the default colors from standard or
custom which normally fills one color only to your
design;
Fill Effects sophisticated mixture of colors & designs
Gradient (one color, two color or preset)
Texture
Pattern
11. Click OK or press enter button to activate the format.

12. Work on the next pages by highlighting the entire
text/passage of life and changing the font style to Century
Gothic with 48-font size.
13. Set entire text to full justification except last stanza.
14. Adjust zoom level to 25% to have better view of your work.
15. Highlight the text from first to third stanza and move hanging
indention of your ruler to 2 inches.
16. This time highlight the text from the second line of your first
stanza to the end first line indent to 1 inch on your
horizontal ruler. Do the same with your second and third
stanzas.
17. On the last stanza, which is the fourth one, move the
passage life is not a matter of to the second line by
pressing enter once. Move the word but in your third line by
pressing enter and placing the insertion point after it and
press enter again this will make the word but the only text
in the fourth line of your fourth stanza.
18. Highlight the entire fourth stanza and center align it.
19. Now you have 6 pages of enlarged graphics and text of Life
passage that could be mounted on the wall.
20. Save your output with file name LIFE 2 <your name> and
send it to your folder.
C. CLOSING PRAYER
1. Switch on the AVR.

2. Boot units.
IV. EVALUATION
Check formatted LIFE 2 file with page border following requisites =
30 pts.
Non-compliance means two points deduction.
V. AGREEMENT.
Recall entire process.
Competency:

in word processing.
I. OBJECTIVES:
Transfer files from hard disk/Drive C to Drive A/Floppy Disk and
vice versa.
II. SUBJECT MATTER:
TRANSFERRING DATA
Materials:
Personal Computer, MSWord program
Reference:
III. PROCEDURE:
A. OPENING PRAYER
4. Right click on the Start Menu button and click explorer.

Search for the file to be transferred from the right panel of
the explorer that is your LIFE 1 file inside your folder.
5. Click the file once and drag your vertical scroll bar up to the
location of the Floppy driver.
6. Once your floppy drive is ready, drag your file towards the
3- floppy and automatically the file will be copied from
your Hard disk to your floppy disk.
7. For floppy to hard disk, reverse the process by starting
looking for your file on your floppy.
C. CLOSING PRAYER
IV. EVALUATION:
Check for copied file from the hard disk to drive A.
Topic:
B. ACTIVITIES
3. Prepare diskette and insert on the Drive A with headfirst.
V. AGREEMENT:
Recall and familiarize process
B. ACTIVITIES
Competency:

of spreadsheets.
1.
Booting
Menu
Bar
Standard Toolbar
Formatting Toolbar
I. OBJECTIVES:
1. Define Microsoft Excel Program.
Formula
Bar
Name
Box
2. Identify basic elements and parts of workbook window.

3. Describe and discuss the elements and parts.
Column Heading
Row Heading
4. Familiarize Microsoft Excel Window basic elements and parts of

workbook window, combination keys, icons, buttons and logos
through battery of test.
Workbook
Window
Vertical Scroll
Bar
Tab Scrolling
Buttons
Sheet Tab
Status Bar
II. SUBJECT MATTER:

Topic:
MICROSOFT EXCEL BASIC ELEMENTS

AND PARTS
Reference:
Tudlo Mindanao, Workbook on EDP Concepts with

windows Application by Rollan and Gatpandan pp.
82-84
Materials:
Microsoft Excel Application Program, Personal

Computer, Questionnaire
III. PROCEDURE:
A. OPENING PRAYER
of units.
2.
Distribution of Microsoft Excel Handouts.
3.
Define Microsoft Excel Program.

Microsoft Excel is a graphics-oriented spreadsheet
program developed by Microsoft Corporation for IBM PCCompatible computers. It enables you to use multiple
typefaces, type sizes, object-oriented graphics, shading,
and even color; you can include business charts and graphs
in the output.
4.
Activation of Microsoft Excel Application Program.
To open MS Excel application program from your desktop

follow the following steps:
STANDARD TOOLBAR. Displays the buttons that you can

select to perform common editing task.
FORMATTING TOOLBAR. Use to select character and

paragraph formatting commands to enhance the look of
your document.
NAME BOX. The box at the left end of the formula bar that
identifies the selected cell, chart item, or drawing object.
Type the name in the Name box, and then press ENTER to
quickly name a selected cell or range. To move to and
select a previously named cell, click its name in the Name
box.
FORMULA BAR. A bar near the top of the window that

displays the constant value or formula used in the active
cell. To enter or edit values or formulas, select a cell, type
the data, and then press ENTER. You can also double-click
a cell to edit data directly in the cell.
WORKBOOK WINDOW. Also called the Worksheet area.

The entire worksheet and all its elements, including cells,
gridlines, row and column headings, scroll bars, and sheet
tabs.
STATUS BAR. The bar near the bottom of the screen that
displays information about a selected command or an
operation in progress. The right side of the status bar shows
whether keys such as CAPS LOCK, SCROLL LOCK, or
NUM LOCK are turned on. Click Status Bar on the View
menu to display or hide the status bar.
a. Click on Start button.

b. From the start menu, choose Programs.
c. From the sub-menu choose Microsoft Excel
5.
6.
Identify basic elements of MS Excel Window and parts of

workbook window.
Describe and discuss basic elements and parts of Microsoft

Excel window using handouts and hands on with the aid of
Help menu.
ELEMENTS OF EXCEL WINDOW
MENU BAR. Displays the name of available pull-down

menus.
PARTS OF THE WORKBOOK WINDOW
SHEET TABS. A tab near the bottom of a workbook

window that displays the name of a sheet. Click the sheet
tab to make a sheet active. To display a shortcut menu, click
a tab with the right mouse button. To scroll through the
sheet tabs, use the tab scrolling buttons to the left of the
tabs.
ROW
1
SCROLL BARS. The shaded bars along the right side and
bottom of a window. To scroll to another part of the file, drag
the box or click the arrows in the scroll bar.
COLUMN HEADING. The lettered or numbered gray area

at the top of each column. Click the column heading to
select an entire column. If you click the column heading with
the right mouse button, a shortcut menu appears. To
increase or decrease the width of a column, drag the line to
the right of the column heading. If you are using R1C1
reference style, your column headings will have numbers
instead of letters.
6 7
15
8
14
16
TAB SCROLLING BUTTONS. The arrow buttons to the left

of the sheet tabs. To scroll between sheet tabs if the
workbook has more tabs than are currently displayed, click
an arrow for the direction you want to scroll; to select a
sheet, click its tab. To scroll several tabs at a time, press
SHIFT while you click one of the middle tabs scrolling
buttons. To display a menu of sheets in the workbook, click
a tab scrolling button with the right mouse button.
10
11
12
1
3
HEADING. The numbered gray area to the left of each row.

Click the row heading to select an entire row. If you click the
row heading with the right mouse button, a shortcut menu
appears. To increase or decrease the height of a row, drag
the line below the row heading.
CELL ADDRESS.
coordinates.
6.
NOTE TAKING.
The combination of column and row
The students are asked to do hands on as per instruction by

the instructor. Takes down notes on the following items:
a. Drop-down menu commands;
b. Standard and Formatting Toolbars buttons;

c. Icons, buttons, graphics; and
d. Shortcut key or function key of some commands.
C. CLOSING PRAYER
IV. EVALUATION: Paper-pencil Test. Students are to prepare one
whole sheet of paper as answer sheet to the battery of test.
I.
Label the following basic elements of Microsoft Excel and

parts of workbook window.
IDENTIFICATION:
17. The lettered or numbered gray area at the top of each column.
18. It contains the workbook where you will enter the data and
formula. It is also called the Worksheet area.
24. A tab near the bottom of a workbook window that displays the
name of a sheet.
25. An application program which is used to enter numeric data in
tabular format, along with row/ column labels and formulae that
can be combined to solve a variety of business numeric problems.
26. The box at the left end of the formula bar that identifies the
selected cell, chart item, or drawing object.
27. A bar near the top of the window that displays the constant value
or formula used in the active cell
28. The bar near the bottom of the screen that displays information
about a selected command or an operation in progress. The right
side of the status bar shows whether keys such as CAPS LOCK,
SCROLL LOCK, or NUM LOCK are turned on.
29. The shaded bars along the right side and bottom of a window.
19. It displays the name of available pull-down menus.
30. The numbered gray area to the left of each row.
20. It allows you to scroll through the worksheets in the workbook.
31. It is a combination of column and row coordinates.
21. Is a graphics-oriented spreadsheet program developed by

Microsoft Corporation for IBM PC-compatible computers, It
enables you to use multiple typefaces, type sizes, object-oriented
graphics, shading, and even color; you can include business
charts and graphs in the output.
III. Classify the following according to the pull down menu it belong.
22. Displays the buttons that you can select to perform common
editing task.
23. Use to select character and paragraph formatting commands to
enhance the look of your document.
FILE
Auto Format
Cells
Chart
Sheet
EDIT
VIEW
Delete Sheet
Filter
Full Screen
Function
INSERT
Macro
Open
Page Setup
Paste Special
FORMA
T
TOOLS
Print Preview
Protection
Zoom
Sort
DATA
Spelling
Toolbars
Undo
Validation
Worksheet
IV. Match the commands in Column A with their corresponding

shortcut key or function key in Column B. Write the letter of the
correct answer.
Column A
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
Column B
New Document
Open Existing Document
Save
Print
Cut
Copy
Paste
Undo
Spelling
Cells
3.
5.
7.
a.
b.
c.
d.
e.
f.
g.
h.
i.
j.
9.
Name Box
Standard Toolbar
Column Heading
Sheet Tabs
Workbook Window
2.
5.
8.
11.
14.
Formatting Toolbar
Menu Bar
Row Heading
Status Bar
Vertical Scroll Bar
18.
21.
24.
27.
30.
Workbook Window
MS Excel
Sheet Tab
Formula Bar
Row Heading
3.
6.
9.
12.
15.
Title Bar
Formula Bar
Tab Scrolling Button
Task Bar
Cell Address
II. Identification:
17.
20.
23.
26.
29.
Shift + F1
F7
Ctrl + Z
Ctrl + N
Ctrl + O
Ctrl + S
Ctrl + V
Ctrl + P
Ctrl + X
Ctrl + C
Column Heading
Tab scrolling button
Formatting Toolbar
Name Box
Scroll Bars
19.
22.
25.
28.
31.
Menu bar
Standard Toolbar
MS Excel
Status Bar
Cell Address
III. Classification:
FILE
Page
Setup
Open
Print
Preview
EDIT
Delete
Sheet
Paste
Special
VIEW
INSERT
Full
Screen
Worksheet
Toolbars
Function
Zoom
Chart
Undo
FORMAT
Auto
Format
TOOLS
DATA
Spelling
Filter
Sheet
Protection
Sort
Cells
Macro
Validatio
n
IV. Matching Type
V. Give the functions of the following buttons.

1.
1.
4.
7.
10.
13.
16.
11.
13.
1. d
6. j
15.
2. e
7. g
3. f
8. c
4. h
9. b
5. I
10. a
V. Functions of buttons
2.
4.
ANSWER KEY:
I. Labeling:
6.
8.
10
12.
14.
1.
2.
3.
4.
5.
AutoSum
Chart Wizard
Merge and Center
Percent Style
Increase Decimal
6.
7.
8.
9.
10.
Paste Function
Drawing
Currency Style
Comma Style
Decrease Decimal
V. AGREEMENT: Read handouts in advance.
11. Microsoft Excel Help

12. Decrease Font Size
13. Increase Font Size
14. Legend
15. Format Selected
Object

Competency:

of spreadsheets.
I. OBJECTIVES:
1. Describe the common spreadsheet features
2. Discuss how the spreadsheet works.
3. Perform a series of operation using the toggle keys.
II. SUBJECT MATTER:
Topic:
MICROSOFT EXCEL FEATURES
Materials:
Personal Computer, handouts
Reference:
II. PROCEDURE:
A. OPENING PRAYER
B. MOTIVATION
1. Switch on the AVR.
2. Boot units.
3. Activate Microsoft Excel application Program.
C. INTRODUCTION
Microsoft Excel consists of worksheets. Each worksheet
contains columns and rows. The columns are lettered A to IV;
the rows are numbered 1 to 65536. The combination of column
and row coordinates make up a cell address. For example, the
cell located in the upper left corner of the worksheet is cell A1,
meaning column A, row 1. Cell E10 is located under column E

on row 10. You enter your data into the cells on the worksheet.
D. ACTIVITIES
Discussion on Excel features and toggle keys. Learn on-Hands
on after each discussion.
The Formula Bar
If the Formula bar is turned on, the cell address displays on the
left side of the Formula bar. Cell entries display on the right side
of the Formula bar. Before proceeding, make sure the Formula
bar is turned on.
1. Point to View, which is located on the Menu bar.
2. Click the left mouse button. A drop-down menu will appear.
3. On the drop-down menu, if Formula Bar has a checkmark
next to it, the Formula bar is turned on. Press the Esc key
twice to close the drop-down menu.
4. If Formula Bar does not have a checkmark next to it, press
the down arrow key until Formula Bar is highlighted and
press Enter. The Formula bar should appear below the
toolbars.
5. Note that the current cell address displays on the left side of
the Formula bar.
The Status Bar

If the Status bar is turned on, it appears at the very bottom of the
screen. Before proceeding, make sure the Status bar is turned
on.
1. Point to View, which is located on the Menu bar.
2. Click the left mouse button. A drop-down menu will appear.
3. On the drop-down menu, if Status Bar has a checkmark next
to it, it is turned on. Press the Esc key twice to close the dropdown menu.
4. If Status Bar does not have a checkmark next to it, press the
down arrow key until Status Bar is highlighted and press
Enter. The Status bar should appear at the bottom of the
screen.
1. Press the Num Lock key several times and note how the
indicator on the Status bar changes.
2. The Caps Lock key is also a toggle key. Pressing it turns the
caps function on and off. When the caps function is on, your
entry will appear in capital letters.
3. Press the Cap Lock key several times and note how the
indicator on the Status bar changes.
Other functions that appear on the Status bar are Scroll Lock
and End. Scroll Lock and End are also toggle keys. Pressing the
key toggles the function between on and off. Scroll Lock causes
the pointer movement key to move the window but not the cell
pointer. End allows you to jump around the screen. We will
discuss both of these later in more detail.
Make sure the Scroll Lock and End indicators are off and
complete the following exercises.
Notice the word "Ready" on the Status bar at the lower left side
of the screen. The word "Ready" tells you that Excel is in the
Ready mode and awaiting your next command. Other indicators
appear on the Status bar in the lower right corner of the screen.
Here are some examples:
The Down Arrow Key
The Num Lock key is a toggle key. Pressing it turns the numeric
keypad on and off. You can use the numeric keypad to enter
numbers as if you were using a calculator. The letters "NUM" on
the Status bar in the lower right corner of the screen indicate
that the numeric keypad is on.
2. Note that the cursor moves downward one cell at a time.
You can use the down arrow key to move downward on the
screen one cell at a time.
1. Press the down arrow key several times.
The Up Arrow Key
You can use the Up Arrow key to move upward on the screen
one cell at a time.
1. Press the up arrow key several times.
1.
Press the End key.
2. Note that the cursor moves upward one cell at a time.
2.
Note that "END" appears on the Status bar in the lower right
corner of the screen.
3.
Press the right arrow key.
4.
Note that the cursor moves to the farthest right area of the
screen.
5.
Press the END key again.
6.
4. Note that the cursor moves to the left.
Press the down arrow key. Note that the cursor moves to
the bottom of the screen.
7.
Press the End key again.
Page Up and Page Down
8.
The Page Up and Page Down keys move the cursor up and
down one page at a time.
Press the left arrow key. Note that the cursor moves to the
farthest left area of the screen.
9.
Press the End key again.
The Right and Left Arrow Keys

You can use the right and left arrow keys to move right or left
one cell at a time.
1. Press the right arrow key several times.
2. Note that the cursor moves to the right.
3. Press the left arrow key several times.
1. Press the Page Down key.

2. Note that the cursor moves down one page.
3. Press the Page Up key.
4. Note that the cursor moves up one page.
The End Key
The End key, used in conjunction with the arrow keys, causes
the cursor to move to the far end of the spreadsheet in the
direction of the arrow.
10. Press the up arrow key. Note that the cursor moves to the
top of the screen.
Note: If you have entered data into the worksheet, the End key
moves you to the end of the data area.
The Home Key
The Home key, used in conjunction with the End key, moves you
to cell A1 -- or to the beginning of the data area if you have
entered data.
1. Move the cursor to column J.
2. Stay in column J & move the cursor to row 20.
3. Press the End key.

4. Press Home.
cells, you must first select those cells by highlighting them. To

highlight cells A1 to E1:
5. You should now be in cell A1.
1. Place the cursor in cell A1.
Scroll Lock
2. Press the F8 key. This anchors the cursor.

3. Note that EXT appears on the Status bar in the lower right
corner of the screen. You are in the Extend mode.
Scroll Lock moves the window, but not the cell pointer.
4. Click in cell E7. Cells A1 to E7 should now be highlighted.
1. Press the Page Down key.
5. Press Esc and click anywhere on the worksheet to clear the

highlighting.
2. Press Scroll Lock. Note "SCRL" appears on the Status bar in

the lower right corner of the screen.
3. Press the up arrow key several times. Note that the cursor
stays in the same position and the window moves upward.
4. Press the down arrow key several times. Note that the cursor
stays in the same position and the window moves downward.
5. Press Scroll Lock to
turn the scroll lock
function off.
6. Press End.
7. Press Home. You
should be in cell A1.
Selecting Cells
If you wish to perform a
function on a group of
Alternative Method - Selecting Cells by Dragging

You can also highlight an area by holding down the left mouse
button and dragging the mouse over the area. In addition, you
can select noncontiguous areas of the worksheet by doing the
following:
2. Hold down the Ctrl key. Do not release it until you are told.
Holding down the Ctrl key enables you to select
noncontiguous areas of the worksheet.
3. Press the left mouse button.
4. While holding down the left mouse button, use the mouse to
move from cell A1 to E7.
5. Continue to hold down the Ctrl key, but release the left
mouse button.
6. Using the mouse, place the cursor in cell G8.
7. Press the left mouse button.
8.
While holding down the left mouse button, move to cell I17.
Release the left mouse button.
9. Release the Ctrl key.
10. Press Esc and click anywhere on the worksheet to remove
the highlighting.
Alternative Method - Selecting Cells by using Shift + Arrow
key
You can also highlight an area by holding down the shift button
and arrow key desired.
2. Hold down the Alt key. Do not release it until you are told.
3. While holding down the Alt key, press the right arrow key to
highlight cell A1 to E7.
4. Continue to hold down the Ctrl key, but release the left mouse
button.
5. Release the Alt key and arrow key.
6. Press Esc and click anywhere on the worksheet to remove
the highlighting.
E. CLOSING PRAYER
IV. EVALUATION. Fill in the blanks with the correct answer.
The Microsoft Excel consists of _(1)_. Each _(2)_ contains _(3)_
and _(4)_. The columns are _(5)_ from _(6)_ to _(7)_ and the rows
are _(8)_ from _(9)_ to _(10 .
There are special keys in it one of which is the _(11)_ key that lets
you move upward on the screen one cell at a time. The _(12)_ and
_(13)_ keys move the cursor up and down one page at a time.
The toggle keys are also its feature. The _(14)_ used in
conjunction with the _(15)_ keys, causes the cursor to move to the far
end of the spreadsheet in the direction of the assigned. The _(16)_
key, used in conjunction with the _(17)_ key, moves you to the
beginning of the data area if you have entered data. The _(18)_ moves
the window but not the cell pointer.
In selecting cells, there are 3 possible ways and they are: _(19)_,
_(20)_, and _(21)_ .
ANSWER KEY:
worksheets
worksheets
columns
rows
lettered
IV
numbered
1
65536
up arrow
page up
page down
end
arrow
home
A
V. AGREEMENT: Read handouts in advance
end
scroll lock
by F8
by dragging
using shift +
arrow key
1.
Click on Format, which is located on the Menu bar.
2.
Press the down arrow key until Style is highlighted.
3.
Press Enter. A dialog box will appear.
4.
Click on Modify.
1. Enter data in the worksheet.
5.
Click on the Font tab, if it is not in the front.
2. Use various ways to edit the data.
6.
Click on Arial in the Font box, if Arial is not already selected.
7.
Click on OK.
8.
Click again on OK.
Competency:

of spreadsheets.
I. OBJECTIVES:
II. SUBJECT MATTER:

Topic:
MICROSOFT
EDITING DATA
EXCEL
ENTERING
AND
Materials:

Computer, Handouts
Reference:
Tudlo Mindanao
III. PROCEDURE:
A. OPENING PRAYER
B. ACTIVITIES
1. Booting of units.
2. Learn on-hands on. Teacher guides the processes and the
students do the hands on
In this lesson you are going to learn how to enter text. To begin,
open Microsoft Excel. For this lesson, your default font should
be set to Arial. Lets check to make sure it is.
This lesson
will teach you
how to enter
data into
your
worksheet.
First you
place the
cursor in the
cell in which
you would
like to enter
data, type
the data, and
then press Enter.
1.
Place the cursor in cell A1.
2.
3.
4.
Type John Jordan. Note that the word Ready on the

Status bar changes to Enter.
3.
Change "John" to "Jones."
4.
Use the backspace key to delete the "n" and the "h."
The Backspace key erases one character at a time. Erase

"Jordan" by pressing the backspace key until Jordan is
erased.
5.
Type nes.
6.
Press Enter.
Press Enter. The name "John" should appear in cell A1.
Editing a Cell
After you enter data
into a cell, you can
edit it by pressing
F2 while you are in
the cell you wish to
edit.
1.
Move
the
cursor to cell
A1.
2.
Press
F2. Note
that the
word
Ready
on the
Status
bar
changes
to Edit.
Alternate Method Editing a Cell by Using the Formula Bar

You can also edit the cell by using the Formula bar. You can
change "Jones" to "Joker" as follows:
1.
Move the cursor to cell A1.
2.
Click in the formula area of the Formula bar.
3.
Use the backspace key to erase the "s," "e," and "n."
4.
Type ker.
5.
Press Enter.
Alternate Method Editing a Cell by Double-Clicking in the

Cell
You can change "Joker" to "Johnson" as follows:
1. Move the cursor to cell A1.
2. Double-click in cell A1.
3. Press the
End key.
That will
place the
cursor at
the end
of your
text.
4. Use
mode will replace the old cell entry with the new information you
type.
2. Type Cathy.
3. Press Enter. The name "Cathy" should replace "Johnson."
the
backspace to erase "r," "e," and "k."

5. Type hnson.
6. Press Enter.
Changing
Cell Entry
Typing in a cell
while you are in
the
Ready
C. CLOSING PRAYER
IV. EVALUATION:
Practicum on:
Changing Default Font
Entering Data
Editing Data
V. AGREEMENT: Read handouts in advance.

Competency:

of spreadsheets.
I. OBJECTIVES:
1. Adjust column width.
2. Align data in cells at left, right, center.
II. SUBJECT MATTER:
Topic:
MICROSOFT EXCEL ADJUSTING COLUMN

WIDTH
Reference:
Tudlo Mindanao
Materials:

Computer, Handouts
III. PROCEDURE:
Adjusting the Standard Column Width

When you enter Microsoft Excel, the width of each cell is set
to a default width. This width is called the standard column width.
We need to change the standard column width to complete our
exercises. To make the change, follow these steps:
1.
2.
Press the down arrow key until Column is highlighted.
3.
Press Enter.
4.
Press the down arrow key until Standard Width is highlighted.
5.
Press Enter.
6.
Type 25 in the Standard Column Width field.
7.
Click on OK. The width of every cell on the worksheet should

now be set to 25.
A. OPENING PRAYER
Cell Alignment
B. ACTIVITIES
Look at cell A1. The name "Cathy" is aligned with the left side of
the cell. You can change the cell alignment.
2. Activation of Microsoft Excel Program
3. Learn on-hands on. (Teacher guided instruction and hands
on)
Centering by Using the Menu
To center the name Cathy, follow these steps:
7.
Click on OK to close the dialog box. The name "Cathy"

should now be right-aligned.
2. Click on Format, which is located on the Menu bar.

3. Press the down arrow key until Cells is highlighted.
4. Press Enter.
5. Click on the Alignment tab, if it is not in the front.
Left-Aligning by Using the Menu

To left-align the name "Cathy," follow these steps:
6. Click to open the drop-down box associated with the Horizontal

field. After the drop-down box is opened, click on Center.
1.
7. Click on OK to close the dialog box. The name "Cathy" should

now be centered.
2.
3.
Press the down arrow key until Cells is highlighted.
4.
Press Enter.
5.
Click on the alignment tab, if it is not in the front.
6.
Click to open the drop-down box associated with the

Horizontal field. After the drop-down box is opened, click on
Left (Indent).
7.
Click on OK to close the dialog box. The name "Cathy"

should now be left-aligned.
Right-Aligning by Using the Menu

To right-align the name "Cathy," follow these steps:
1.
2.
3.
4.
Press Enter.
5.
Click on the Alignment tab, if it is not in the front.
6.
Click to open the drop-down box associated with the

Horizontal field. After the drop-down box is opened, click on
Right.
Alternate Method -- Alignment by Using the Formatting

Toolbar
Using the Formatting toolbar, you can quickly perform functions.

You can use the Formatting toolbar to change alignment.
2.
Click on the Align Left icon, which is located on the

Formatting toolbar.
The red circle designates the Align Left icon.
Centering by Using the Toolbar

To center the name "Cathy," follow these steps:
C. CLOSING PRAYER
IV. EVALUATION. Practicum
2. Click on the Center icon, which is located on the Formatting

toolbar.
V. AGREEMENT.
The red circle designates the Align Center icon.

Right-Aligning by Using the Toolbar
To right-align the name "Cathy," follow these steps:
Read handouts in advance

Competency:

of spreadsheets.
I. OBJECTIVES:
1.
1. Add Bold, Underline, and Italic formats.
2.
Click on the Align Right icon, which is located on the

Formatting toolbar.
2. Use varied ways and process in adding bold, underline and

italics in formatting.
II. SUBJECT MATTER:
The red circle designates the Align Right icon.

Left-Aligning by Using the Toolbar
To left-align the name "Cathy," follow these steps:
1.
Topic:
MICROSOFT EXCEL BOLD, UNDERLINE

AND ITALIC
Reference:
Tudlo Mindanao
Materials:

Computer, Handouts
III. PROCEDURE:
A. OPENING PRAYER
B. ACTIVITIES
6. Click on the Font tab, if it is not in the front.

7. Click on Bold in the Font Style box.
8. Click on OK. The word "Bold" should now be bolded.
Adding Italic -Using the Menu
2. Learn on-hands on
1. Type Italic in cell B2.
Adding Bold, Underline, and Italic
2. Click on the checkmark located on the Formula bar. Clicking

on the checkmark is similar to pressing Enter.
You can bold, underline, or italicize text in Microsoft Excel. You

can also combine these features -- in other words, you can bold,
underline, and italicize a single piece of text.
In the exercises that follow, you will learn three different methods
for bolding, italicizing, or underlining text in Microsoft Excel. You
will learn to bold, italicize, and underline by using the menu, the
icons, and the shortcut keys.
Adding Bold -Using the Menu

5. Press Enter.
6. Click on Italic in the Font style box.
7. Click on OK. The word "Italic" should now be italicized.
Adding Underline -Using the Menu
1. Type Bold in cell A2.
In Microsoft Excel there are several types on underlines. The

exercise that follows illustrates several of them.
2. Click on the checkmark located on the Formula bar. Clicking

1.
Type Underline in cell C2.
2.
Click on the checkmark located on the Formula bar. Clicking

3.
4.
5. Press Enter.
5.
Press Enter.
6.
Click to open the drop-down menu associated with the

Underline box.
24. Click on Single Accounting.
7.
Click on Single.
25. Click on OK. The cell entry should now have a single
accounting underline.
8.
Click on OK.
26. Type Underline in cell F2.
9.
Note: The cell entry should now have a single underline.
27. Click on the checkmark located on the Formula bar.
10. Type Underline in cell D2.
30. Press Enter.
31. Click to open the drop-down menu associated with the

Underline field.
14. Press Enter.

Underline field.
16. Click on Double.
32. Click on Double Accounting.

33. Click on OK. The cell entry should now have a double
accounting underline.
17. Click on OK. The cell entry should now have a double
underline.
Adding All Three Using the Menu

1.
Move the cursor to cell G3.
18. Type Underline in cell E2.
2.
Type All three.
3.
Click on the checkmark located on the Formula bar.
4.
5.
22. Press Enter.
6.
Press Enter. The Font dialog box will open.

Underline field.
7.
Click on the Font tab, if it is not in the front.
8.
Click on Bold Italic in the Font Style box.
9.
Click to open the drop-down menu associated with the

Underline field. Then click on Single.
Alternate Method Adding Bold by Using the Icon

10. Click on OK.
Note: The words "All three" should now be bolded, italicized,

and underlined.
3. Click on the Bold icon, which is on the Formatting toolbar.
Removing Bolding and Italics Using the Menu

1. Highlight cells A2 to B2. Place the cursor in cell A2. Press the
F8 key. Press the right arrow key once.
4. Press Enter.
5. Click on Regular in the Font style box.
6. Click on OK.
Removing an Underline Using the Menu
1. Move the cursor to cell C2.
4. Click again on the Bold icon if you wish to remove the

bolding.
Alternate Method Adding Italic by Using the Icon
3. Click on the Italic icon, which is on the Formatting toolbar.
4. Click again on the Italic icon if you wish to remove the italics.
Alternate Method Adding Underline by Using the Icon
1. Type Underline in cell C3.
3. Click on the Underline icon, which is on the Formatting
toolbar.
4. Press Enter.
4. Click again on the Underline icon if you wish to remove the

underline.

Underline field. Then click on None.
Alternate Method Bold, Underline, and Italicize Using

Icons
6. Click on OK.
1. Type All Three in cell D3.

3. Click on the Bold icon.
Alternate Method Bold, Underline, and Italicize Using

Shortcut Keys
4. Click on the Italic icon.
1. Type All three in cell D4.
5. Click on the Underline icon.
Alternate Method Adding Bold by Using Shortcut Keys

3. Hold down the Ctrl key while pressing "b" (Ctrl-b).
3. Hold down the Ctrl key while pressing "b" (Ctrl-b).

4. Hold down the Ctrl key while pressing "i" (Ctrl-i).
5. Hold down the Ctrl key while pressing "u" (Ctrl-u).
C. CLOSING PRAYER
4. Press Ctrl-b again if you wish to remove the bolding.
Alternate Method Adding Italic by Using Shortcut Keys
V. AGREEMENT. Read handouts in advance

3. Hold down the Ctrl key while pressing "i" (Ctrl-i).
4. Press Ctrl-i again if you wish to remove the italic formatting.
Competency:
Alternate Method Adding Underline by Using Shortcut

Keys
I. OBJECTIVES:

of spreadsheets.
1. Type Underline in cell C4.
1. Change font style and font size.
2. Delete cell entry.
3. Hold down the Ctrl key while pressing "u" (Ctrl-u).
3. Work with long text.
4. Press Ctrl-u again, if you wish to remove the underline.

II. SUBJECT MATTER:
Topic:
MICROSOFT EXCEL FONT STYLE AND

FONT SIZE, DELETING CELL ENTRY
Reference:
Tudlo Mindanao
4. Press Enter.
Materials:

Computer, Handouts
5. Click on the Font tab, if it is not in the front.
III. PROCEDURE:
6. Click on 16 in the Size box.

7. Click on OK.
A. OPENING PRAYER
B. ACTIVITIES:
3. Press the down arrow and highlight Cells.
Learn on-hands on
Deleting a Cell Entry
Changing the Font and Font Size
To delete an entry in a cell or a group of cells, you place the

cursor in the cell or highlight the group of cells and press Delete.
You can change the Font and Font Size of the data you enter.
1. Type Times New Roman in cell A5.
2. Press the Delete key.
C. CLOSING PRAYER
4. Press the down arrow and highlight Cells. Press Enter.

5. Click on the Font tab, if it is not in the front. All of the Fonts
listed in the Font box are available to you.
V. AGREEMENT. Read handouts in advance
6. Find and click on Times New Roman in the Font box.

7. Click on OK.
Note: The font changes from Arial to Times New Roman.
Competency:
Changing the Font Size
I. OBJECTIVES:


of spreadsheets.
1. Work with long text
2. Change single column width.

3. Use varied ways in changing single column width.
2. Type Now is the time for all good men to go to the aid of
their army.
4. Move worksheets using sheet tabs.
3. Press Enter.
II. SUBJECT MATTER:

Topic:
MICROSOFT EXCEL LONG TEXTS AND

SINGLE
COLUMN
WIDTH,
MOVING
WORKSHEETS
4. Note that everything that does not fit into cell A6 spills over
into the adjacent cell.
5. Move the cursor to cell B6.
6. Type TEST.
Reference:
Tudlo Mindanao
7. Press Enter.
Materials:

Computer, Handouts
8. Note: The entry in cell A6 is cut off.

10.
III. PROCEDURE:
A. OPENING PRAYER
B. ACTIVITIES:
Learn on-hands on
Working with Long Text

Whenever you type text that is too long to fit into a cell, Microsoft
Excel attempts to display all of the text. It will left-align the text
regardless of the alignment that has been assigned to it, and it
will borrow space from the blank cells to the right. However, a
long text entry will never write over cells that already contain
entries instead, the cells that contain entries will cut off the
long text. Do the following exercise to see how this works.

Look at the Formula bar. The text is still in the cell.
Changing a Single Column Width

Earlier we increased the column width of every column on the
worksheet. You can also increase individual column widths. If
you increase the column width, you will be able to see the long
text.
1. Make sure the cursor is anywhere under column A.
2. Point to Format, which is located on the Menu bar.
3. Click the left mouse button.
4. Press the down arrow key until Column is highlighted.
5. Press Enter. Width is highlighted.
6. Press Enter.
7. Type 55 in the column width
field.
8. Click on OK.
Column A is now set to a width of
55. You should now be able to
see all of the text.
Alternate Method Changing a Single Column Width
You can also change the column width using the cursor.
1.
2.
3.
Place the cursor on the line between the B and C column

headings. The cursor should look like the one displayed
here, with two arrows.
Move your mouse
to the right while
holding down the
left mouse button.
The width indicator
will appear on the
screen.
Release the left mouse button when the width indicator
shows approximately 40.
Moving to a New Worksheet
In Microsoft Excel, each

workbook is made up of
several
worksheets.
Before moving to the next
topic, move to a new
worksheet.
1.
C. CLOSING PRAYER
IV. EVALUATION: Practicum

Competency:

of spreadsheets.
I. OBJECTIVE:
1. Fill cells automatically.
2. Follow instructions carefully.
3. Perform the drill properly.
II. SUBJECT MATTER:
Topic:
Click on Sheet 2, which is located in the lower left corner

of the screen.
MICROSOFT EXCEL
AUTOMATICALLY
FILLING
CELLS
Reference:
Tudlo Mindanao
Materials:
Computer, Handouts
III. PROCEDURE:
4. Press the right arrow key six times to highlight cells A1

through G1.
5. Find the small black square in the lower right corner of the
highlighted area. This is called the Fill Handle.
A. OPENING PRAYER
6. Grab the Fill Handle and drag with your mouse to highlight
cells A1 to G24.
B. ACTIVITIES:
7. Note how each cell fills.
Learn on-hands on
8. Press Esc and then click anywhere on the worksheet to

remove the highlighting.
Filling Cells Automatically

You can use Microsoft Excel to automatically fill cells with
information that occur in a series. For example, you can have
word automatically fill in times, the days of the week or months
of the year, years, and other types of series. The following
demonstrates:
1. Type the following into the worksheet as shown.
A
B
C
D
E
F
1 1:00 Sun Sunday Jan January 2000
2. Place
the
cursor in cell
A1.
3. Press F8. This
will anchor
the cursor.
G
Type 1
3. Utilize Function keys and combinations keys in transferring from

one cell address to another.
4. Perform mathematical calculations: addition, subtraction,
multiplication and division.
D. CLOSING PRAYER
Type the following entry as required:
Insert Sheet 7 and rename it to CELL FILL.
Type the following entry as written
A
B
C
D
st
1
1 January
Monday 2000
Week
E
SN
001
PC 1
1st
Automatically fill up to row 25

Adjust column width to 15 up to G

Competency:

of spreadsheets.
I. OBJECTIVES:
1. Set enter key directions to down.
2. Make numeric entries.
II. SUBJECT MATTER:

Topic:
MICROSOFT
EXCEL
NUMBERS
AND
MATHEMATICAL CALCULATIONS
Materials:
Computer, Handouts
Reference:
Tudlo Mindanao
III. PROCEDURE:
A. OPENING PRAYER
B. ACTIVITIES:
Learn on-hands on
Numbers and Mathematical Calculations

In this lesson you will learn how to work with numbers and
how to perform mathematical calculations. To begin, open
Microsoft Excel.
Setting the Enter Key Direction
In Microsoft Excel, you can specify which direction the cursor
moves when you press the Enter key. You can have the cursor
move up, down, left, right, or not at all. Lets make sure the
cursor is set to move down when you press the Enter key.
1.
Click on Tools, which is located on the Menu bar.
2.
Press the down arrow key until Options is
highlighted.
3.
Press Enter.
4.
5.
6.
7.
Click on the Edit tab, if it is not in the front.

Make sure there is a checkmark in the "Move
Selection after Enter" box.
If Down is not selected, click to open the Direction
drop-down box. Click on Down.
Click on OK.
Making Numeric Entries

In Microsoft Excel, you can enter numbers and mathematical
formulas into cells. When a number is entered into a cell, you
can perform mathematical calculations such as addition,
subtraction, multiplication, and division. When entering a
mathematical formula, precede the formula with an equals sign.
Use the following to indicate the type of calculation you wish to
perform:
+ Addition - Subtraction * Multiplication
/ Division
^ Exponential
Moving Quickly Around the Worksheet
The following are shortcuts for moving quickly from one cell to a
cell in a different part of the worksheet.
Go to F5
The F5 function key is the "Go To" key. If you press the F5 key
while in the Ready mode, you will be prompted for the cell you
wish to go to. Enter the cell address, and the cursor will jump to
that cell.
1. Press F5. The Go To dialog box will appear.
2. Type J3.
3. Press Enter. The cursor should move to cell J3.
Go to Ctrl-G
You can also use Ctrl-G to go to a specific cell.
1. Hold down the Ctrl key while you press "g" (Ctrl-g). The Go
To dialog box will appear.
2. Type C4.
3. Press Enter. You should now be in cell C4.
Performing Mathematical Calculations
The following exercises demonstrate how to perform
mathematical calculations.
Addition
1. Move the cursor to cell
A1.
2. Type 1.
3. Press Enter.
4. Type 1 in cell A2.
5. Press Enter.
6. Type =A1+A2 in cell Place the cursor in cell A3 and
look at the Formula bar.
A3.
7. Press Enter.
8. Note that cell A1 has been added to cell A2 and the result is
shown in cell A3.
Subtraction
1.
Press F5. The Go To dialog
box will appear.
2.
Type B1.
3.
Press Enter.
Place the cursor in cell B3 and
4.
5.
6.
7.
8.
9.
10.
11.
The cursor should move to cell B1.

Type 5 in cell B1.
Press Enter.
Type 3 in cell B2.
Press Enter.
Type =+B1-B2 in cell B3.
Press Enter.
Note that cell B1 has been subtracted from B2 and the
result is shown in cell B3.
Multiplication
1. Hold down the Ctrl key while you press "g"
(Ctrl-g). The Go To dialog box will appear.
2. Type C1.
3. Press Enter. You should now be in cell C1.
4. Type 2 in cell C1.
5. Press Enter.
6. Type 3 in cell C2.
7. Press Enter.
8. Type =C1*C2 in cell C3.
9. Press Enter.
10. Note that C1 is multiplied by C2 and the
answer is displayed in C3.
Division
1. Press
F5.
2.
3.
4.
5.
6.
7.
8.
9.
10.
Type D1.
Press Enter. You should now be in cell D1.
Type 6 in cell D1.
Press Enter.
Type 3 in cell D2.
Press Enter.
Type =D1/D2 in cell D3.
Press Enter.
Note that D1 is divided by D2 and the answer is displayed in
cell D3.
Automatic Calculation
If you have automatic calculation turned on,
Microsoft Excel recalculates the worksheet
as you change cell entries. Lets check to
make sure automatic calculation is turned
on.
Place the cursor in cell C3 and

Place
the
cursor
in cell
D3 and
look at
the
Formula
bar.
3.
4.
5.
6.
Setting Automatic Calculation

1.
Click on Tools, which is located
on the Menu bar.
2.
Press the down arrow key until
Options is highlighted.
Press Enter.
Click on the Calculation tab if it is not in the front.
Select Automatic, if it is not already selected.
Click on OK.
Trying Automatic Calculation
Make the changes outlined below and note how Microsoft Excel
automatically recalculates.
1.
Hold down the Ctrl key while pressing Home (Ctrl-Home).
This will move you to cell A1.
2.
Type 2. Press the Tab key.
3.
Note that the results shown in cell A3 have changed. The
number in cell A1 has been added to the number in cell A2
and the results display in cell A3.
4.
You should now be in cell B1.
5.
6.
Note that the results shown in cell B3 have changed. The
number in cell B1 has been subtracted from the number in
cell B2 and the results display in cell B3.
7.
You should now be in cell C1.
8.
9.
Note that the results shown in cell C3 have changed. The
number in cell C1 has been multiplied by the number in
cell C2 and the results display in cell C3.
10. You should now be in cell D1.
11. Type 12. Press the Tab key.
12. Note that the results shown in cell D3 have changed. The
number in cell D1 has been divided by the number in cell
D2 and the results display in cell D3.
C. CLOSING PRAYER
IV. EVALUATION
Practicum

Competency:

of spreadsheets.
I. OBJECTIVES:
1. Format numbers using the menu bar and the shortcut toolbars.
2. Perform more advanced mathematical calculations.
II. SUBJECT MATTER:
Topic:
MICROSOFT EXCEL FORMATTING NUMBERS
Materials:
Computer, Handouts
Reference:
Tudlo Mindanao
III. PROCEDURE:
A. OPENING PRAYER
B. ACTIVITIES:
Learn on-hands on
Formatting Numbers
You can format the numbers you enter into Microsoft Excel. You
can add commas to separate thousands, specify the number of
decimal places, place a dollar sign in front of the number, or
display the number as a percent in addition to several other
options.
BBefore formatting.
formatting.
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
After

Type 1234567.
Press Enter.
Move the cursor back to cell A5.
Press Enter.
Click on the Number tab, if it is not in the front.
Click on Number in the Category box.
Type 2 in the Decimal Places box. This will cause the
number to display with two decimal places.
11. Place a checkmark in the Use 1000 Separator box. This will
cause thousands to be separated with commas.
12. Click on OK.
Adding a Dollar Sign to the Numeric Entry
2. Click on Format, which is located on the
Menu bar.
3. Press the down arrow key until Cells is
highlighted.
4. Press Enter.
5. Click on the Number tab, if it is not in the front.
6. Click on Currency in the Category box.
7. Make sure there is a "$" in the Symbol box.
8. Click OK.
Alternate Method Formatting Numbers by Using the

Toolbar
1. Move the cursor
to cell A6.
2. Type 1234567.
3. Press Enter.
4. Move the cursor
back to cell
A6.
5. Click twice on the Increase Decimal icon to change the
number format to two decimal places. Clicking on the
Decrease Decimal icon decreases the decimal places.
6. Click once on the Comma Style icon to add commas to the
number.
7. To change the number to a currency format, click on the
Currency Style format.
9. Type .35 (note the decimal
point).
10. Press
Enter.
11. Move the cursor back to cell A7.
12. Click on the Percent Style icon to turn .35 to a percent.
More Advanced Mathematical Calculations
When you perform mathematical calculations in Microsoft Excel
be careful of precedence. Calculations are performed from left to
right, with multiplication and division performed before addition
and subtraction.
1.
2.
3.
4.
Move to a new worksheet by clicking on Sheet2, which is

located in the lower left corner of the screen.
Go to cell A1.
Type =3+3+12/2*4.
Press Enter.
Note: Microsoft Excel divided 12 by 2, multiplied the answer by

4, added 3, and then added another 3. The answer 30 displays
in cell A1.
To change the order of calculation, use parentheses. Microsoft
Excel will calculate the information in parentheses first.
1. Double-click in cell A1.
2. Edit the cell to read =(3+3+12)/2*4.
3. Press Enter.
Note: Microsoft Excel added 3 plus 3 plus 12, divided the
answer by 2, and multiplied the result by 4. The answer 36
appears in cell A1.
C. CLOSING PRAYER
V. AGREEMENT:
Read handouts in advance.

Competency:

of spreadsheets.
I. OBJECTIVES:
1. Copy entries and formula to a cell address in various methods.
2. Create formula.
3. Identify the two types of reference operators
II. SUBJECT MATTER:
Topic:
FORMULA
MICROSOFT EXCEL CREATING AND COPYING
Reference:
Tudlo Mindanao
Materials:

Computer, Handouts
III. PROCEDURE:
A. OPENING PRAYER
B. ACTIVITIES:
Learn on-hands on
Cell Addressing
Microsoft Excel records cell addresses in formulas in three
different ways, called absolute, relative, and mixed. The way a
formula is recorded is important when you copy it.
With relative cell addressing, when you copy a formula from one
area of the worksheet to another, Microsoft Excel records the
position of the cell relative to the cell that originally contained the
formula. The following exercises demonstrate:
Creating the Formula
1. Press F5.
2. Type A7. Press Enter.
3. Type 1. Press Enter.
6. Press F5.
7. Type B7. Press Enter.
11. Press F5.
12. Type A10.
13. Press Enter.
In addition to typing a formula as we did in Lesson 2, we
can also enter formulas using the Point mode. When you are in
the Point mode you can enter a formula either by clicking on a
cell with your mouse or by using the arrow keys.
1. You should be in cell A10.
2. Type =.
3. Use the up arrow key to move to cell A7. Note that the word
"Ready" in the lower right corner of the screen changes to
"Point."
4. Type +.
5. Use the up arrow key to move to cell A8.

6. Type +.
7. Use the up arrow key to move to cell A9.
8. Press Enter.
9. Look at the formula bar while in cell A10. Note that the
formula you entered is recorded in cell A10.
Copying by Using the Menu
You can copy entries from one cell to another cell. To copy
the formula you just entered, follow the steps outlined below:
1. You should be in cell A10.
2. Click on Edit, which is located on the Menu bar.
3. Press the down arrow key until Copy is highlighted.
4. Press Enter. Moving dotting lines will appear around cell A10.
These dotted lines indicate the cells to be copied.
5. Press the Tab key once. This should move you to cell B10.
6. Click on Edit, which is located on the Menu bar.
7. Press the down arrow key until Paste is highlighted.
8. Press Enter. The formula in cell A10 should be copied to cell
B10.
9. Press Esc to exit the Copy mode.
Compare the
formula in cell A10 with the formula in cell B10 (while in
the respective cell look at the formula bar). They are the
same except the formula in cell A10 sums the entries in
column A and the formula in cell B10 sums the entries in
column B. The formula was copied in a relative fashion.
Before proceeding with the next exercise, we must copy

the information in cells A7 to B9 to cells C7 to D9. This time we
will copy by using the Formatting toolbar.
Copying by Using the Formatting Toolbar
1. Highlight cells A7 to B9. Place the cursor in cell A7. Press F8.
Press the down arrow key twice. Press the right arrow key
once. A7 to B9 should be highlighted.
2. Click on the Copy icon
, which is located on the
Formatting toolbar.
3. Use the arrow key to move the cursor to cell C7.
4. Click on the Paste icon
, which is located on the
Formatting toolbar.
5. Press Esc to exit the Copy mode.
Absolute Cell Addressing
An absolute cell address refers to the same cell, no matter
where you copy the formula. You make a cell address an
absolute cell address by placing a dollar sign in front of both the
row and column identifiers. You can do this automatically by
using the F4 key. To illustrate:
1. Move the cursor to cell C10.
2. Type =.
3. Use the up arrow key to move to cell C7.
4. Press F4. Dollar signs should appear before the C and
before the 7.
5. Type +.
6. Use the up arrow key to move to cell C8.
7.
8.
9.
10.
11.
12.
Press F4.
Type +.
Use the up arrow key to move to cell C9.
Press F4.
Press Enter.
The formula is recorded in cell C10.
Copying by Using the Keyboard Shortcut

Now copy the formula from C10 to D10. This time, copy by using
the keyboard shortcut.
1. Your cursor should be in cell C10.
2. Hold down the Ctrl key while you press "c" (Ctrl-c). This
copies the contents of cell C10.
3. Press the Tab key once.
4. Hold down the Ctrl key while you press "v" (Ctrl-v). This will
paste the contents of cell C10 in cell D10.
Compare the formula in cell C10 with the formula in cell
D10. They are exactly the same. The formula was copied in an
absolute fashion. Both formulas should add up column C.
Mixed Cell Addressing
You use mixed cell addressing to reference a cell that is
part absolute and part relative. You can use the F4 key.
1. Move the cursor to cell E1.
2. Type =.
3. Press the up arrow key once.
4. Press F4.
5. Press F4 again. Note that the column is relative and the row
is absolute.
6. Press F4 again. Note that the column is absolute and the row
is relative.
7. Press Esc.
Reference Operators
Reference operators are helpful when referring to a cell or group
of cells. Two types of reference operator are range and union.
A range reference refers to all the cells between and including
the reference. A range reference consists of two cell addresses
separated by a colon. The reference A1:A3 includes cells A1, A2,
and A3. The reference A1:C3 includes A1, A2, A3, B1, B2, B3,
C1, C2, and C3.
A union reference includes two or more references. A union
reference consists of two or more cell addresses separated by a
comma. The reference A7,B8,C9 refers to cells A7, B8, and C9.
C. CLOSING PRAYER
IV. EVALUATION
Practicum
V. AGREEMENT: Familiarize process and read handouts in
advance
Functions
Microsoft Excel has a set of prewritten formulas called functions.
Functions differ from regular formulas in that you supply the
value but not the operators, such as +, -, *, or /. The SUM
function is used to calculate sums. When using a function,
remember the following:
Use an equals sign to begin a formula
Specify the function name
Enclose arguments within parentheses
Use a comma to separate arguments
Here is an example of a function:
=SUM(2,13,10,67)
In this function:
The equals sign begins the function

SUM is the name of the function
2, 13, 10 and 67 are the arguments
Parentheses enclose the arguments
A comma separates each of the arguments
The SUM function adds the arguments together. In the exercises that
follow, we will look at various functions.
Typing a Function
1.
2.
3.
4.
5.
6.
7.
8.
Click on Sheet3 located at the bottom of your window to move to

a new worksheet:
Type 12 in cell B1.
Press Enter.
Type 27 in cell B2.
Press Enter.
Type 24 in cell B3.
Press Enter.
Type =SUM(B1:B3) in cell A4. Microsoft Excel sums cells B1 to
B3.
Alternate Method Entering a Function by Using the Menu

1.
2.
3.
4.
5.
6.
Type 20 in cell C1.

Press Enter.
Type 30 in cell C2.
Press Enter.
Type 50 in cell C3.
Press Enter. Your cursor should be in cell C4.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
Click on Insert, which is located on the Menu bar.

Press the down arrow key until Function is highlighted.
Press Enter.
Click on Math & Trig in the Function Category box.
Click on Sum in the Function Name box.
Click on OK.
Type C1:C3 in the Number1 entry field, if it does not
automatically appear.
Click on OK.
Move to cell A4.
Type the word Sum.
Press Enter.
Calculating an Average
You can use the AVERAGE function to calculate an average from a
series of numbers.
2. Type Average.
3. Press the right arrow key.
4. Type =AVERAGE(B1:B3).
5. Press Enter. The average should appear.
Calculating Min
You can use the MIN function to find the lowest number in a series of
numbers.
1.
2.
3.
Move the cursor the cell A6.

Type Min.
4.
5.
Type = MIN(B1:B3).
Press Enter. The lowest number in the series, which is 12,
should appear.
Calculating Max
You can use the MAX function to find the highest number in a series of
numbers.
1.
2.
3.
4.
5.
Move the cursor the cell A7.

Type Max.
Type = MAX(B1:B3).
Press Enter. The highest number in the series, which is 27,
should appear.
Saving Your File and Closing Microsoft Excel

This is the end of Lesson 3. Save your file & close Microsoft Excel.
1. Click on File, which is located on the Menu bar.
2. Press the down arrow key until Save is highlighted.
3. Press Enter.
4. Type lesson3.xls in the filename field.
5. Click on Save.
6. Click on File, which is located on the Menu bar.
7. Press the down arrow key until Exit is highlighted.
8. Press Enter.

ICT IV Plan

Uploaded by

Copyright:

Available Formats

ICT IV Plan

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

ICT IV Plan

Uploaded by

Copyright:

Available Formats

LESSON PLAN IN ICT 4

Demonstrate functional knowledge and

Demonstrate skills in listening to audio-guided instructions.

Perform instructions of the audio-guided tutorial.

Follow and conform to the level-by-level tutorial from basic to

Give importance to honesty and perseverance.

II. SUBJECT MATTER:

MICROSOFT WORD TUTORIAL

MSOffice Tutorial Program, Personal Computer,

Tudlo Mindanao ICT Materials

1.Introduction to the program

Opening an existing document

Convert text to tables

Direction: Label the following icons, symbols and buttons with

Lesson Plan in ICT IV

LESSON PLAN IN ICT 4

Demonstrate functional knowledge and

THE MICROSOFT WORD SCREEN

Personal Computer, MSWord Program

papers and so forth. To open MS Word application program

Standard toolbar: Displays the buttons that you can select

Formatting toolbar: Use to select character and

control margins, indents and tab alignment.

Status bar: displays information about your word document

Appear along the bottom and

Lesson Plan in ICT IV

heading can be moved and the accompanying text

Familiarize icons, graphics, and symbols.

Demonstrate functional knowledge and

Utilize the general operations of a word processor.

Create a personal folder.

Save a file onto personal folder.

II. SUBJECT MATTER:

Personal Computer, MS Word Program

Tudlo Mindanao Handouts

LESSON PLAN IN ICT 4

Demonstrate functional knowledge and skills

Tudlo Mindanao Handouts

Personal Computer, MS Word Program, Paint

Lesson Plan in ICT IV

II. SUBJECT MATTER:

INSERT CLIP ART IMAGE

Tudlo Mindanao Handouts

Personal Computer, MS Word Program

H. Create new document from MS Word application program and

Format picture into 3 x 3 size and center align.

Demonstrate functional knowledge and skills

Lesson Plan in ICT IV

In the final analysis, life is not a matter of

Place the insertion point at the beginning of the document.

Nature clip art images are displayed. Click the Sunshine

To resize the image click on it, the sizing handles at the

13. From the shortcut menu, choose Format Picture.

16. Press enter or click OK button. The text now of your

LESSON PLAN IN ICT 4

Demonstrate functional knowledge and skills

Insert page border to LIFE 1 file.

BORDERS AND SHADING

Personal Computer, MS Word Program