BALAYAN SENIOR HIGH SCHOOL

Computer Systems Servicing NCII

Computer Laboratory
Activity Manual

By: Paolo M. Nacionales

Table of Contents:
Chapter 1: Basic Computer Operations: Operating Windows
The PC (Personal Computer)
Starting-up and shutting Down the PC
Desktop, Window and Folders
Working with Icons
Proper Encoding

Chapter 2: Word Processing Software

The Word Processor (MS Word)
Controls and Commands
Creating and Saving a Document
Formatting and Editing a Document
Change Page Appearance, Headers and Footers
Bullets and Numberings
Create and Format Tables
Working with Images
Mail Merging
Paragraph Formatting

Chapter 3: Spreadsheet Software

The Spreadsheet Application (MS Excel)
Controls and Commands
Creating and Saving a Worksheet
Working with Formulas: Arithmetic
Working with Formulas: Business and Financial
Cell Formatting
Conditional Formatting and “If” Condition
Working with Multiple Worksheets
Graphs and Charts

Chapter 4: Presentation Software

Presentation Package
Creating a Presentation
Slide Designs
Slide Transitions and Animations
Command Buttons and Hyperlink
Importing Data from other Applications

Glossary

Reference
Chapter 1:
Basic Computer Operations: Operating Windows

 The PC (Personal Computer)

Computer – a programmable, electromechanical machine that accepts raw data (input) and process it in
to useful information (output).

Output via Monitor,

Fig. 1: Diagram of the Computer’s Main Process Speaker or Printer

Input via Keyboard Processing the Data Storage to Hard disk,

or Mouse via Processor CD or Flash drive

Send to other
computer via Network

Personal Computer (PC) – Also called Microcomputer, are small computers that can fit next to a desk
or on a desktop, or can be carried around. A personal computer may be a desktop computer, a laptop,
tablet PC or a handheld PC (also called palmtop).

Fig. 2: A usual desktop PC. It’s basically composed of four devices

The Monitor
The System Unit

The Keyboard The Mouse

The System Unit (SU) – Also called the system cabinet but popularly called CPU, is the box or cabinet
that contains the microcomputers processing and memory hardware and other components. This is
where the actual computing (processing) of data is being done. Almost all the devices are connected
directly to the system unit.
The upright standing system unit above is called a tower type case or chassis.

Peripheral Device – any device that is connected and controlled by the computer. It can be internal like
disk drives and adapter cards, or external like the keyboard, mouse and monitor.

The Monitor – is an electronic visual display for computers. Allows the PC to return information to the
user
The monitor above is a flat-panel or flat-screen monitor. Another type of monitor is the older CRT
monitor.

The Keyboard – is an input device that looks like the keyboard from typewriter. It converts letters,
numbers, symbols and other characters into a form that the computer can process.

The Mouse – pointing device that is roll-about on a desktop to control the pointer or cursor on the
computer’s display screen. It is named “mouse” because of its similarity to the actual mouse (animal)
having an oval body and a long tail at the rear.
 Starting-up and shutting down the PC

A. Male PSU socket

B. PSU Fan
C. P/S 2 Mouse Port (Green)
D. P/S 2 Keyboard Port (Violet)
E. USB Ports (for newer peripherals)
F. Parallel Port (for older printers)
G. Serial Port (for older peripherals)
H. Built-in sound card ports (Speaker, Microphone, Line-in and
Game port)
I. VGA Video Port (for the monitor)
J. Network Port (for network cables)
K. Modem card ports (Line-in and Phone Ports)

Fig. 3: The SU back panel and some basic ports.

1. Connecting
Check if all your cables and connectors are connected properly. Loose connections make some
devices not to work properly or not to work at all. Improper connections, (i.e. reversed
connections or connected to wrong ports) might harm or damage some devices.
2. Plugging
After checking connections, it’s time plug you computer to the AC outlet. Plug the computer power
cable to the AVR or UPS then plug all peripheral devices and then plug the AVR or UPS to the AC
outlet. Be careful of loose power connections for it can severely damage you computer.

* Note: Laptop computers have adaptors instead.

3. Turning-on the computer

Turning-on the computer is as easy as pushing a button. Push the SU power switch (usually the
largest button on the SU with this symbol: ). Then push the Monitor and other peripheral device
power buttons.
4. Waiting the computer to “Boot-up”
Booting-up means loading-up the computer’s software so we can use it. Usually it begins with
POST to check the computer for errors then loading the OS (i.e. Windows) and then waiting for
everything on the desktop to load.

When everything on the desktop is loaded, you can now use you computer.

* Note: Sometimes, some computers have usernames and passwords. You have to enter the correct
username and password to be able to use that computer.

5. Shutting down a PC
Unlike turning off an electric fan or TV where you just have to push the power button again,
shutting down properly a PC uses a different process. Because just pushing the power button of the
PC and not doing the proper process can lead to malfunctioning of the PC. You can properly
shutdown a PC in by following the instruction in COMPLAB Operation sheet 1.
COMPLAB Operation sheet 1
Starting-up and shutting down the PC
1. Connecting:
a) Check the connections of the different peripheral devices in you SU. If a device is not connected, try to connect it in
the proper port.
b) Also, check for reversed or loose connected devices.
Fig. 4: PS2 ports. If you can notice, the keyboard and mouse port (also PS2 port) has 6 round
holes and 1 rectangular hole. The rectangular hole is an indicator for the proper connecting.
Also make sure that you avoid bending the pins. This will lead to malfunctioning of the device.
c) You can check the proper ports for the devices in figure 3.
d) Double check you work.
2. Plugging:
a) After making sure that all the connections are ok, you can now plug the SU to the AVR or UPS.
b) Then plug the remaining peripherals.
c) Lastly plug the AVR or UPS to the AC outlet.
d) Double check you work.
3. Turning-on the computer:
a) Push the power switch/button of the AVR or UPS first. If the AVR or UPS has a light (usually green) on it, it’s now
turned-on.
b) Push the power button of the SU and Monitor.
c) Now switch-on the other peripheral devices. (Speaker, Printer, Scanner, etc.)
4. Waiting the computer to “Boot-up”:
a) After you switch-on the SU and Monitor, what you will see in the screen is called the POST.
Fig. 5: The POST. The POST will check if there’s any error on your PC
before it boots-up. If a “Keyboard Error” appears, it’s either you
didn’t connect the keyboard properly or you have a non-functioning
keyboard. Just reconnect it and restart the PC (using reset button) to
make sure.
If a “CMOS Error” appears, that means your CMOS battery is out of
charge. Just press “continue” (usually F1) to continue to booting.

b) After POST, the booting begins. If an “Operating System not found” or “Disk boot failure” appears, that means
either you do not have an OS installed on your PC or the PC does not detect your hard disk.
c) You’ll know if your computer is booting when you see this on your screen:

Fig. 6: Different OS
Loading screens (From
Left; Windows XP,
Mac OS, Linux

d) The computer is done loading when you see the desktop and all the icons in the systray is complete.
5. Shutting down a PC:
a) At the desktop click “Start”, located at the lower left of the screen.
Fig. 7a: The Start button

b) Then click “turn-off” or “shutdown” button.

Fig. 7b: The Shut down or Turn off button

c) Then the Turn off window will appear:

Fig. 7c: The Shut down or Turn off window

d) Click “Turn Off” button or select “Shut Down” then click OK to shutdown the computer. No need to push the
power button.
e) When the PC is off. Switch off the monitor and all the peripherals.
f) Unplug the AVR or UPS to the wall AC socket.
 Desktop, Window and Folders

Fig. 8: Desktop parts and labels

The Desktop is the first display that we will see every time the computer was completely loaded and
ready for use. It’s where we do our computer related task. It’s also where can see the icons, desktop
background, the task bar and start button.

A Window will appear every time we open a folder or windows program. When we open a folder, we
can see parts of a window, like the title bar, menu bar, address bar and common tasks.

Folders are directories where we can save our files and programs.

 Working with Icons

Icons are small pictures that represent a folder, file or program. If we want to open a folder, file or
program, we double-click their icon.

What can we do with icons?

We can create, rename, move, copy, delete, and change the properties of an icon.
A. To create an icon means to create the folder or file the represents it (programs are installed). To
do this, just follow the steps in COMPLAB Operation Sheet 2.
B. You can also rename an icon that already has a name. But when we are renaming a file, you
should also consider its file name extension. To do this, just follow the steps in COMPLAB
Operation Sheet 2a.
C. There are two ways to move an icon, drag and drop, and cut and paste. To do this, just follow
the steps in COMPLAB Operation Sheet 2.
D. To copy an icon is to duplicate a file or folder. Sometimes this is called backing-up. To do this,
just follow the steps in COMPLAB Operation Sheet 2.
E. Deleting an icon is not to remove completely but just to throw it away to the computer’s trash
can called the Recycle Bin. You can also restore deleted files from a recycle to its original
location. To do this, just follow the steps in COMPLAB Operation Sheet 2.
F. You can also change the properties of an icon, like changing its image or how you can view it in
your desktop. You can also share a folder to a network. To do this, just follow the steps in
COMPLAB Operation Sheet 2.
COMPLAB Operation sheet 2
Working with Icons
1. Creating an icon:
a) On the desktop, right click at the background and choose new, and then click “Folder”. A new folder will emerge
and should be like this: Fig. 9a: New folder icon

b) As you can see the new folder’s name is “New Folder”, you can change this by typing a new name and pressing
“Enter".
2. Renaming an icon:
a) To rename an icon, right-click on the icon that you want to rename, then click rename, then type the new name of
the icon, and then press enter.
b) If you are going rename a file, be sure not to change its file name extension (.doc or .txt). It could make the file
unusable. Except if you intended to change the file type.
3. Moving icons:
a) There are two ways to move an icon. You can use your recently created folder as the new location.
b) First create a new notepad or text document. You can also rename it if you want.
c) On way to move an icon is to drag-and-drop the icon to its new location. You can do this by click and hold the icon
of the notepad or text document, then point your mouse pointer over the icon of your folder, and when the icon
changes color (usually blue), release your finger from holding.

Fig. 9b/9c: Left - Moving the text document to

a folder using drag and drop. Right – My Text
text document inside a folder.

d) Open your folder to check if the notepad or text document has been moved in your
folder.
e) To use cut and copy to move an icon, right click at your notepad or text
document, then click Cut, then go to a different directory (ex. My
Documents), and then right click at the background and click Paste.
f) You can also move multiple icons by selecting the icons that you want to move
using drag and drop selection and doing the process above.
Fig. 9e: Selecting 2 icons using drag and drop.
g) Cut and paste are usually used for moving an icon to a location where you cannot use drop and drag.
4. Copying an icon:
a) Copying an icon means to duplicate or make a copy of the file or folder.
b) To do this, open My Documents folder, then right-click on your notepad or text document and click Copy, and then
go to your folder, right click on the background and click paste.
c) You can check if you successfully copied the icon if it both exists in MY Documents and your folder.
5. Deleting and Restoring an icon:
a) Deleting an icon doesn’t mean removing it completely but just to throw it in the computer’s trash can called the
Recycle Bin.
b) Delete your notepad or text document by right-clicking it and choosing Delete or you can also select you notepad or
text document and pressing Delete button on you keyboard.
c) Then the “Confirm file delete” message will appear. Click yes to send you file
in to the recycle bin. It is now deleted. To restore deleted files, open the
recycle bin, find your file, then right-click and choose Restore.
d) The deleted file will return to its original location.
6. Changing the properties of an icon:
a) To change the properties of an icon, just right click the icon and click
Properties. Depending on what’s you icon type, you will notice that you can
check Read-only and Hidden boxes. Just check any and click OK. >>
b) If you choose to hide an icon, you won’t be able to see that icon unless that
you configure you computer to view hidden objects.
c) To view hidden files and folders, open My Computer, click Tools in the menu
bar, and then click Folder Options...
d) The Folder Options window will appear. Click View tab and check “Show
Hidden Files and Folders” and click OK.
Fig. 9f/9c: Left – Checked show
hidden files and folders. Right – New Folder Properties window.

e) Your folder or file will appear as a semi-transparent or translucent icon

 Proper Encoding

Touch typing is typing without using the sense of sight to find the keys. Touch typing typically involves
placing the eight fingers in a horizontal row along the middle of the keyboard (the home row) and
having them reach for other keys.
Fig. 10: The ten fingers with corresponding keys. Fig. 11: Colored blue is the keyboard Home Row

Space
bar

You will also feel a small bump or line over “F” and “J” keys. It’s because these keys are the one where
we put our two pointing fingers. It helps us find where the home keys are even with out looking at the
keyboard.

The proper sitting position is to sit up straight, elbows close to the body and keep your shoulders, arms
and hands relaxed.

Fig. 12: Proper sitting position.

Practice Activity:

1. Open a word processing software (i.e. MS Word, Notepad, Wordpad, etc.)

2. Try typing the following 5 times using all your fingers:
“The quick brown fox jumps over the lazy dog.”

For the next activities, refer to the typing tutorial software.

You can ask for the assistance of you teacher or the laboratory in-charge.
Chapter 2:
Word Processing Software

 The Word Processor (MS Word)

Word Processor – application software that allows you to use the computer to create, edit, store and
print documents.
Fig 13: Examples of Word Processors [From left to right: Apple iWork (Mac OS), Applix Word (Linux), MS Word
(Windows)

Microsoft Word - is a word processor designed by Microsoft to be installed and use in Windows and
other OS.
Fig. 14: Parts of an MS Word (MS Word 2010)
 Controls and Commands

During the lessons that follow, you will be asked to "click" items. When asked to click:
1. Point to the item.
2. Press your left mouse button once.
If you are asked to double-click an item:
1. Point to the item.
2. Quickly press your left mouse button twice.
If you are asked to right-click:
1. Point to the item.
2. Press your right mouse button.
Highlighting by Using the F8 and Arrow Keys
1. Place the cursor before or after the text you wish to highlight and click the left mouse button.
2. Press the F8 key, which will serve as an "anchor" showing where text you wish to highlight
begins or ends.
3. Press the appropriate arrow key (left arrow to move to the left or right arrow to move to the
right) until the text is highlighted. You can use the up or down arrow key to highlight one line at
a time. Press Esc to remove the anchor.
Highlighting by Using the Mouse
1. Place the cursor before or after the text you wish to highlight.
2. Hold down the left mouse button.
3. Move the mouse left, right, up, or down until the text is highlighted.

 Creating and Saving a Documents

You have completed this lesson. Typically, you would save your work before exiting. This lesson does
not require you to enter any text, so you might have nothing to save. To exit Microsoft Word:
1. Click File on the Menu bar.
2. Click Exit, which can be found at the bottom of the drop-down menu.
3. If you have entered text, you will be prompted: "Do you want to save changes to Document1?"
To save your changes, click Yes. Otherwise, click No.
4. Specify the correct directory in the Save In box.
5. Name your file by typing lesson2.doc in the File Name field.
6. Click Save.

Checking for wrong spelling and grammar:

MS Word and other MS Office applications has a feature for checking and correcting spelling and
grammar. A wavy red underline indicates a wrong spelling; a wavy blue or green
indicates a wrong grammar.
You can correct this error by right clicking the masked word/s then choosing the correct formatting.

Try doing these activities on the next pages:

*Note: You must create your own folder for the following activities. Use another storage media (USB
Flash drive) to save your backup.
Activity No. 1: Create Documents (Blank Document)

Instructions:
1. Copy the document sample below.
2. Use “Tab” key on the keyboard to indent the first line of the paragraph.

August 21, 2008

Dear Mr. Smith, Use Tab here instead of spaces

The XYZ Business Firm would like to welcome you as a new customer to our firm. We know
that you will be extremely satisfied with our line of products and the service we provide to our
customers.

You are invited to purchase our merchandise on our regular open account terms, 20$ per month,
our credit manager, John Hancock, will be happy to discuss any aspect of our credit policy with you at
your convenience.

I am enclosing our catalogue and price list for your review. I believe that you will find our prices
competitive and in keeping with industry trends. Throughout the year, we offer our valued customers
frequent discounts as an incentive and as a showing of our appreciation.

I do hope you will afford us the opportunity to serve you in the near future.

Sincerely Yours,

[Type your name here]

VP for Sales
123 Trades Company

3. To save your work, click File or the Office Button tab, then click Save or Save As, then choose
the location of where you want to save your files in Browse, then type the file name in File
Name, then click Save.
Office Button
Activity No. 2: Create Documents (Using Templates)

Instructions:
1. Almost the same as activity 1, but this time we will use a Document Template.
2. For MS Word 2007/2010, use any available letter template with almost the same format.
3. To use a template, click File, then New, and then under Featured, choose any letter template
(i.e. Business Letter, etc.)
4. On[Click here and type return address], type your address.
5. On Company Name, type 123 Trades Company.
6. On [Click here and type recipient’s address], type the address block of the letter:

Mr. John Smith

Marketing Assistant, ABC Company
Redmond, WA 12345

7. Change the Dear Sir or Madam: to Dear Mr. Smith.

8. Then copy the body of the letter from activity 1.
9. Preview below

Sample letter template:

You can choose different template formats. Just select then create.

10. Save your work under the file name [your full name] - Activity 2.docx
Activity No. 3: Format Documents (Paragraph Formatting)

1. Type the paragraphs below:

2.

3. Set the first paragraph to align center by dragging the first paragraph and clicking center align

4. Set the second paragraph to align right by dragging the second

paragraph and clicking right align button

5. Set the third paragraph to justify by dragging the third

paragraph and clicking justify align button

6. Select all the three paragraphs and

change the line spacing to 1.0 and
Remove Space After Paragraph
by clicking the Line and
Paragraph Spacing button

7. Your document should be look like this:

8. Save your work on your folder

 Formatting and Editing a Document

In this lesson you will learn how to format and edit documents. Changing page setup, (margins, paper
size, etc.), changing font styles, spaces and indentations are examples.

This is a preview of Activity No. 4:

Announcement!
From the makers of Magic Shrub Whitening Soap comes this new
line of products:
1. Magic Shrub Whitening Lotion.
2. Magic Shrub Moisturizing Cream.
3. Magic Shrub Anti-aging Lotion.
This is also to announce that we have 10% Special Discount Offer that we are making on all orders for
the following items for the month of (month) only:

 Magic Shrub Whitening Soap

 Magic Shrub Medicinal Soap

This 10% discount is available on any order set for delivery from June 1, 2008 through December 1,
2008, and is our way of saying thank you for making our product number one.

We hope you will take advantage of this offer and will send us your purchase order
today. We will look forward to hearing from you.
Activity No. 4: Format Documents (Font, Bullets, and Numbering)

Instructions:
1. Copy the sample announcement below:

Announcement!

From the makers of Magic Shrub Whitening Soap comes this new line of products:

Magic Shrub Whitening Lotion.

Magic Shrub Moisturizing Cream.
Magic Shrub Anti-aging Lotion.

This is also to announce that we have 10% Special Discount Offer that we are making on all orders for the
following items for the month of (month) only:

Magic Shrub Whitening Soap

Magic Shrub Medicinal Soap

This 10% discount is available on any order set for delivery from June 1, 2008 through December 1, 2008, and is
our way of saying thank you for making our product number one.

We hope you will take advantage of this offer and will send us your purchase order today. We will look forward
to hearing from you.

2. Format the “Announcement!” word at the top by dragging the word and choosing font style
Arial Black and size 24. Color is Red.
3. The sentence below the Announcement is Times New Roman size 18, color blue.
4. Center the Announcement and the sentence below it by dragging both and clicking Center
align on the alignment.
5. Use automatic numbering for the 3
products below it. Font style Times New
Roman size 14 and in Bold face emphasis.
6. The short paragraph below the 3 products is
Left aligned, font style Arial, and size 11.
7. The 2 other products below is Bulleted, font style Arial, size 11, and in bold face emphasis.
8. The short paragraph below the 2 products has the same formatting as the first short paragraph.
But the words “number one” is in bold face emphasis.
9. The ending paragraph is Center aligned font style Times New Roman, size 14, and in bold face
and Italic emphasis.
10. A preview of the completed work is in the previous page.
11. Save your work in to your folder.
Font Style Font Size Bullets and
Numbering

Emphasis Font Color Alignment

Activity No. 5: Change Page Appearance (Orientation, Paper Size and Margins)

Instructions:
1. Set page orientation to landscape. You can do this by going to Page Layout ribbon, and then on the
Page Orientation, click Orientation then select Landscape.

2. Click Margins and all the margins to Narrow all 0.5” (Top, Bottom, Left, Right)
3. Copy the documents below. The gray boxed area are the instructions
4. Save your work in your folder
Activity No. 6: Change Page Appearance (Columns and Header)

Instructions:
5. Set page orientation to landscape. You can do this by going to Page Layout ribbon, and then on the
Page Orientation, click Orientation then select Landscape.
6. Click Margins and all the margins to 1.5” (Top, Bottom, Left, Right)
7. Set the page in two columns. You can do this by clicking Columns, then click Two.

8. Insert header. Click Insert then click Header and choose the first.

9. On the [Type text], type:

MS WORD HELP
FORMAT A DOCUMENT
10. Drag it and click center align, font size 16 and bold face emphasis. Then click Close in header and footer
toolbar. Copy the sample document below:
Table of Contents:

I. Format a document automatically.

A. Automatically format as you type.

B. Automatically format after you type.

II. Reapply formatting.

11. Then press enter until the cursor reaches the

second page:
12. Then type the following:
I. Format a document automatically.
A. Automatically format as you type.
1. On the Tools menu, click AutoCorrect Options, and then click the AutoFormat As You Type tab.
2. Select or clear the options you want.
B. Automatically format after you type.
1. On the Format menu, click AutoFormat.
2. To choose which types of automatic changes Microsoft Word makes, click Options, select or clear the options you
want, and then click OK.
3. Click a document type to apply the most appropriate formatting.
4. Do one of the following:
a. To have Word automatically format the document, click AutoFormat now.
b. To review and accept or reject each change, click AutoFormat and review each change.
II. Reapply formatting.
This procedure quickly applies formatting that you've used elsewhere in your document.
1. If the Styles and Formatting task pane is not open, click Styles and Formatting on the Formatting toolbar.
2. Select the text that you want to format.
3. In the Styles and Formatting task pane, click the formatting that you want to apply.

13. Save your work in your folder.

This is a preview of Activity No. 6:
Activity No. 7: Create and format tables

Instructions:
1. Copy the sample document below:

August 22, 2008

Mr. John Smith

123 Trading Company
XYZ Building, Balayan Public Market
Balayan, Batangas.

Dear Mr. Smith,

This letter will serve to confirm our agreement regarding your purchase of, and payment for,
certain merchandise from our company.

We have agreed to ship the following merchandise to you:

2. After copying the above document, click Insert, and then click Table.
3. Choose 5 columns and 4 rows.
4. Type the following data in the table:
Quantity Unit Item/Product Price (Php) Total Price (Php)
3 boxes Tuyo 300 900
2 boxes Tinapa 250 500
5 1,400
5. Copy the following closing below the table:
You agree to abide by our printed terms and conditions, and you additionally agree to pay for the
merchandise in three equal payments. The first payment shall be sent so as to be received by my office
not later than September 11, 2008. The second payment shall be received not later than thirty days later,
and the third payment shall be received not later than thirty days after the second payment. In no event
shall payment be received later than November 11, 2008.

Please sign a copy of this letter and return it to me. Upon receipt of your confirmation of our
agreement, I shall release shipment of the aforementioned merchandise.

Sincerely yours,

(Type your name here)

President
EFG General Store

6. Drag the Total Price, then right-click, and then click Text Direction.
Choose the vertical text going up, and then click OK.
7. Drag the 3 paragraphs and Justify align them.
8. Save your work in your folder.
Activity No. 8: Create and format tables (with font and paragraph formatting)

Instructions:
1. On your MS Word, type Evidence Plan, then press enter.
2. Copy the sample table below:

Evidence Plan
QUALIFICATION PC Operations NC II
Unit of Competency Operate a word processing application
Ways in which evidence will be collected: [tick the column]

Demonstration with
The evidence shows that the candidate…

Direct observation
with questioning

questioning
Portfolio
 Creates table of content according to requirements

 Save documents into another file formats*

 Inserts table into a document according to requirements*

 Copies table into a document according to requirements

 Create, to meet information requirements

 Edit table cells, columns and rows to meet information

requirements
 Save document to correct folder or directory*

Prepared by: Date:

Checked by: Date:

3. Make the title “Evidence Plan”, “Qualification” and “Unit of

Competency” in bold.
4. Use Gray Shading for “Qualification”, “Unit of Competency” and the
checklist title.
5. Use square bullets for the list:
6. Save you work in your folder
Activity No. 9: Create and format tables (with Page Layout)

Instructions:
1. Set the paper size to A4 and the page orientation to Landscape.
2. Copy the sample table below with the following instructions:
3. The TESDA code and table title are Arial, 12, Black but the table title below is in Bold
4. All the text inside the table are Calibri, 12, Black
5. The list below “CORPORATE AND ADMINISTRATIVE DOCUMENTS” are Bulleted (small letters)

6. Use cell alignment for the check markers (select the check markers, right-click then click cell
alignment and choose align center

7. Save your work in your folder.

Activity No. 10: Paragraph Formatting
Instructions:
a. Page margins are 1.5” at the top and 1” in both sides and bottom.
b. Set the paper size to A4.
c. The company name and address at the top are in Headers. For the header the company name is in
Verdana size 16, the address is size 14.
d. The line and address below are Footers. For the footer and the address is Verdana size 12
e. All the texts in the Bill of Sale are Arial size 12.
f. The heading in the tables are in bold.
g. The paragraphs are Justified; The indentation special: first line is 0.4”; The spacing (before and after)
are 6 pt; and line spacing is Double;
h. Save your work in your folder and let the person in charge checks your work.

Header

Footer
Activity No. 11: Adding Image (with editing)

Instructions:
1. On your MS Word, click Insert, and then click Shapes.
2. Under Stars and Banners select Explosion 2.
3. Insert the shape on the upper left corner of the document.
4. Make the banner about 2” high and 3” wide.
5. Select the banner and color the outline with Black and fill with Red, and the weight
should be 3pt.
6. Click Insert, then click WordArt. Choose WordArt style 1. The type SALE!!! and click OK.

7. Put the WordArt SALE!!! inside the red banner. Like this:
8. Below that, insert a picture of a desktop computer set. You can insert a picture or draw it using
Shapes.
9. Put the computer picture bellow the sale banner by dragging it with your mouse or by using the
arrow keys on your keyboard.
10. Insert a text box by clicking the text box button put it on the right side of the computer
picture.
11. Type the following data:
For sale: Personal Computer
LGA 775 Intel Core duo 2.6Ghz Processor
DDR-II Memory 1GB
Seagate SATA Hard disk 120GB
A4Tech Optical mouse
A4Tech USB Keyboard
21” LCD Monitor
Desktop stereo speakers
Price: 14,995 Only!

12. Copy the picture of the computer and paste it below, adjust the second picture by dragging it or
by using the arrow keys on the keyboard.
13. Crop the image and remove the monitor, keyboard, mouse, and other peripherals leaving the
System Unit only. You can do this by the selecting the picture, click Format ribbon, then click
Crop.

14. Click and drag the edges of the picture until the system unit is the only one left.

15. Insert a text box on the left of the second picture and type the following:
System Unit Only Price:
8,995 Php Only!

16. Save your work in your folder.

Activity No. 11 Preview:
Activity No. 12: Adding Image (Insert Picture from File, Formatting and Text Wrapping)

Instructions:
1. Type the following paragraph 3 times. Put it at the top, middle and bottom:

1. Insert a new picture from File.

2. You can search a picture from My Documents, My Pictures or any folder.
3. Choose any picture.
4. Format the picture by selecting it and clicking Format ribbon.
Crop and Resize the picture to 1:1 aspect ratio and 3” by 3” size.

5. Wrap Text the picture and choose Behind Text. Put it behind the top paragraph.
6. Copy the picture and paste it below the first.
7. Wrap Text the picture and choose Square. Put it behind the middle paragraph.
8. Copy the picture and paste it below the second.
9. Wrap Text the picture and choose In Front of Text. Put it behind the bottom paragraph.
Preview:
Activity No. 13: Adding image (Organizational Chart)

Instructions:
1. At the top of the document, type ABC Company Organizational Chart. Use font Arial size 20,
click center, and then press enter twice so that the cursor is below the company name.
2. Below the company name, insert a Hierarchy Chart by clicking Insert, then SmartArt, then
Hierarchy Chart.
3. At the top box type your full name then below it, type President. It should be like this
4. Select all the boxes and change the Layout to Standard.

5. Then an assistant box will appear, then type Jane Smith then type Secretary below.
6. Delete one of the 3 boxes below by selecting the box then press delete on the keyboard.
7. On one of the boxes below type John Dough then type VP Sales and the other box type John
Smith then type VP Marketing below.
8. Select the VP Sales box and add shape bellow. Do this also to the VP Marketing box. The type
Export under the VP Sales boxes and Advertising under the VP Marketing box. The output
should be like this:

9. Insert another Subordinate under VP Sales box, then type Local.

10. The entire font in the boxes should be Arial and size 14.
11. Change the box shapes to Rounded Rectangle. Click the box, click Format, then Change Shape.

12. Fill color the boxes with Yellow, outline colors with Blue, connecting lines with Red.
13. Save your work in your folder. The preview is below:
Activity No. 14: Mail merge and print word processing documents

Instructions:
1. Open a word document and copy the letter below: Use any Picture for the logo.

Header
Area

Mail Merge Area:

Address Block
Greeting Line

Footer
Area

2. The logo, email and school name are headers; and the address and line below are footers.
3. To insert headers and footers, click View, and then click Headers and Footers. A box above
and below the document will appear and there is where you will type the header and footer.
4. Use Mail Merge feature for the address block by clicking Mailings, then Select Recipients, and
choose Type a New List.
5. Type data onto the new address list window from
Title to City then click OK. Title = Mr./Ms./Mrs.
6. Save the Recipient list in your folder.
7. Use Address Block and Greeting Line as
illustrated above.
8. Click Preview Results to check.
9. Save your work in your folder
 Creating a Formal Letter

Activity No. 15: Creating a Formal Letter

Instructions:
4. Read carefully all the instructions before you begin.
5. Open a word document and copy the letter below:

6. Special instructions for the activity:

i. Page margins are 1.5” at the top and 1” in both sides and bottom. Set the paper to A4.
j. The logo with the company name and address at the top are in headers. The line and address
below are footers. For the header the company name is in Times New Roman size 16, the
address is size 14. For the footer the address size 12 and use insert for the line.
k. All the texts in the letter are Arial size 12. The body of the letter is justified.
l. The heading in the tables are in bold.
m. The paragraphs are indented in first line by 0.5” spacing are 6 pt before and after and line
spacing is exactly 12 pt.
7. Save your work in your folder and let the person in charge checks your work.
Chapter 3:
Spreadsheet Software

 The Spreadsheet Software (MS Excel)

Spreadsheet Software - (sometimes referred to simply as spreadsheets) are computer programs that let
you create and manipulate spreadsheets electronically. In a spreadsheet application, each value sits in
a cell. You can define what type of data is in each cell and how different cells depend on one another.
The relationships between cells are called formulas, and the names of the cells are called labels.

Fig 15: Examples of Spreadsheet Software [From left to right: MS Excel 2007, Quattro Pro

Microsoft Excel - is spreadsheet software designed by Microsoft to be installed and use in Windows
and other OS.
Fig. 16a: Parts of an MS Excel 2016
 Controls and Commands

Controls and commands of MS Excel is almost the same as MS Word.

But unlike MS Word on which you will work with a black document, in MS Excel, you will wor with
a blank worksheet.
A worksheet is a collection of cells arrange together in sets of columns and rows.

Columns
(Letters)

Name Box Formula Bar

Rows
(Numbers) Active Cell

Rows are represented by numbers and Columns are represented by letters.

A Cell is the combination of both. An Active Cell is the cell that is currently selected, indicated by a
thick border. If a formula is typed at the active cell, that formula will show at the Formula Bar.

The mouse pointer changes in MS Excel according to which function is available.

If the mouse pointer looks like this: That means you’re on select mode.
This allows you to select multiple cells.

If the mouse pointer looks like this: That means you’re on move mode.
This allows you to move contents of a cell. You can also move contents of multiple cells.

If the mouse pointer looks like this: That means you’re on drag-copy mode.
This allows you to copy the contents of a cell by dragging.
You can choose the outcome by clicking this symbol after dragging:

Try doing these activities on the next pages:

*Note: You must create your own folder for the following activities. Use another storage media (USB
Flash drive) to save your backup.
 Creating and Saving a Worksheet

Activity No. 1: Create and save worksheets

Instructions:
1. On the worksheet click cell A1.

2. Type Student Enrollees then press Enter.

3. Then copy the rest of the data below:

4. On cell D3, type the total using sum formula: =B3+C3 (the equal sign means the beginning of a
formula, B3 is the cell reference of boys enrolled in BSCoE and C3 is girls, and the plus sign
means to add both.) Then press Enter.
5. It should be like this:
After
pressing
Enter

6. Do the same on the other courses.

7. Then on cell B7, also compute the total for all boys and girls, but instead of typing the formula,
use AutoSum button on the toolbar. You can do this by clicking the small triangle on the right
side of the AutoSum button, then click Sum, and then press Enter.

8. It should be like this:

After pressing Enter

9. Do this in girls total and overall total too. And it should be like this:

10. Save you work in your folder.

Activity No. 2: Create and save worksheets (With text editing)

Instructions:
1. Copy the worksheet below:

2. Select cell B2, then change the font style to Arial

Black, size 14.
3. Select cell B3, then change the font style to Arial
Black, size 12.
4. Then select A6, and then change the font style to
Times New Roman, size 14.
5. Then select cells A7 to D7, by clicking A7 then
drag the mouse to D7. It should be look like this:
6. Then click format it to bold face.
7. Do this also to all the courses and totals including the total numbers.
8. After that, drag cells B7 to D12, you can do this
by clicking B7 then drag the mouse down then
left to D12. It should be like this:

9. Then click the Center button, on the toolbar.

10. Save your work in your folder.

 Working with Formulas: Arithmetic

Activity No. 3: Working with Formulas (PEMDAS)

Instructions:
1. Copy the document sample below.

2. In C3, type the number 8 and in C4, type the number 4.

3. In C5, type this formula: =C3+C4
4. In C6, type this formula: =C3-C4
5. In C7, type this formula: =C3*C4
6. In C8, type this formula: =C3/C4
7. In C9, type this formula: =C3^C4
8. In C10, type this formula: =C3*0.5
9. In C11, type this formula: =C4*0.3
10. The output should be like what illustrated below:

11. Save this activity in your folder.

12. You can change the values of the 1st number and 2nd number and you will see that the results
below will automatically change.
Activity No. 4: Working with Formulas (Commission Schedule)

Instructions:
1. Copy the document sample below. Type commission schedule in cell C3:

2. Center Comm1, Unit, Sales, Base, Comm2, Income and all the values below them is in Comma Style w/ 2
digits.
3. On cell A7, compute the proceeding values by this formula: (Comm1 = Previous Comm1+0.01)
Copy this to the succeeding cells below it.
4. The value below column A6 must be 0.26, 0.27, 0.28... up to 0.50.
5. Adjust the column A to width as Comm1 approx. 6.14. You can
do this by clicking the edge of column A, then slowly drag it to the
the left.

Notice that column A is now

shorter than column B
6. Now adjust the size of row 3, same as what you did to column A, only this time you will drag it down ward.

Row 3 is now
bigger then
the other rows

7. Now continue with filling the table by applying these formulas below: (* = means to multiply)
Unit = Previous Unit*1.1
Sales = Previous Sales*1.1
Base = Previous Base
Comm2 = Comm1*Sales
Income = Base + Comm2
8. After you are done, select Comm1 to
Income and format them to Bold
emphasis, do this also to
Commission Schedule
9. Change the Orientation to
Landscape in Layout tab.
10. Save your work in your folder.
 Working with Formulas: Business and Financial

Activity No. 5: Working with Formulas (Business and Financial)

Instructions:
1. Copy the rest of the document below:

2. On cell A7 to A18, type the numbers 1 to 12.

3. On cell B1, type the annual interest rate of 5%.
4. On cell B2, type the years of 1.
5. On cell B3, type the number of payments per year of 12.
6. On cell B4, type the amount loaned of 100,000.

Now we can begin computing the Payment, Principal, Interest and Balance on each payment period:
7. On cell B7, compute the Payment. To compute the Payment, type this formula:

Explanation: The formula for getting Payment is =PMT(rate, nper, pv) Where:
rate = Annual Interest Rate / No. of Payments, in this case: =PMT(B1/B3,
nper (number of periods) = Years * Payments per Year, in this case: =PMT(B1/B3,B2*B3,
pv (principal value) = Amount, in this case: =PMT(B1/B3,B2*B3,B4)
8. The answer should be: ($8,560.75), the parenthesis and red color means that it is a negative
number.
9. You should do this for all the payment numbers, but there is a shortcut for copying a formula.
10. First, in B7, put a dollar sign ($) in front of the letter and number inside the formulas:

11. Then copy the formula from B7 to B8 up to B18

12. This means that the amount of payment for each is always
($8,560.75)
13. To compute the Principal, on cell C7, type this formula:

Explanation:
The formula to get the Principal is =PPMT(rate, per, nper, pv) where per is the payment period
14. Do the same steps in 9 to 11 but change B7 to C7
15. To compute the Interest, type this formula:

Explanation:
The formula to get the Interest is =IPMT(rate, per, nper, pv) where per is the payment period
16. Do the same steps in 9 to 11 but change B7 to D7
17. Now, finally, to compute the Balance.
18. The formula for Balance is: Balance = Previous Balance + Current Principal
19. On the above case, on E7, type =B4+C7

Explanation: The previous balance is the amount loaned (B4) and the current principal for the 1st
payment is C7.
20. For the 2nd payment, the previous balance will change from B4 to E7.

21. Copy the formula from E8 to E18 to complete the Balance.

22. If you do all this correctly, the final balance (12th Payment) should be 0.
23. Save your work in your folder.
 Sorting and AutoFill Options

Activity No. 6: Sorting and AutoFill Options

Instructions:
1. Copy the following data:

2. On D3, type the 1st student’s Full name in this format: Last name, First name MI.

3. Copy cell D3 using AutoFill by dragging the small square down up to D12.

4. It should be like this:

Drag this small square
down to D12
5. Click the AutoFill option and select Flash Fill

6. After doing that, the output should be like this:

7. Select the list and click Sort and Filter and choose Sort A to Z.

8. In the Sort Warning window, choose Expand the Selection.

9. The list should become alphabetical. The output should be like this:

10. Save your work in your folder.

 Cell Formatting

Activity No. 7: Format Worksheets (Borders and Shadings)

Instructions:
1. On cell A1, Type the following in Bold.

2. Then adjust column A width to 5.00

3. Do this also to column F.

4. Select A7 to B7 and click Merge and Center button. You will notice that both A7 and B7
merged as one cell.
5. Click the small triangle beside the Borders button and choose Outside Borders.
You will notice that A7 and B7 have an outside border.

6. Copy the illustration below, use Merge and Center and Borders buttons on the cells that needed
to be merged:

7. On DEDUCTIONS right click the cell then click Format Cells…

Then at the Alignment tab set the orientation to 90 Degrees.
Then click OK.
8. Modify the document to be the same as the one in the illustration below:

9. To do the Double Border Select the cell then right click and click
Format Cell… then at the Border tab select Double Border at the line style then click the
position of border that you want.

10. Put Light Grey shade on all title

cells.

11. On cell B16, type these data:

12. Do this from day 1 to day 15
13. Now we must compute the Total for both regular hours and overtime hours. You can do this by
typing the formula below on cell F16:
=((C16*24)-(B16*24))+((E16*24)-(D16*24))
For overtime, on cell I16, type the formula below:
=(H16*24)-(G16*24)
14. The if done properly, the output should be like this:

15. To compute the payroll above, the formulas are as follows:

reg. = total regular hours, on B8 type =sum(F16:F30)
over. = total OT hours, on B9 type =sum(I16:I30)
reg. rate = 100
OT rate =C8*1.5
reg. Amount =B8*C8
OT Amount = B9*C9
Gross Salary =D8+D9
Canteen =750
Tax =D11*0.2
SSS =D11*0.5
PHLT =D11*0.2
Total Deduction =sum(I8:I11)
Less Deductions =I13
NET PAY =D11-D12

16. The final output should be like this:

17. Save your work in your folder.

 Conditional Statements

Activity No. 8: Conditional Formatting and “IF” Condition

Instructions:
1. On the A4 up to H4, use Merge and Center.

2. Type the Grades Computation with the font style are Arial, font size are 22 and color Red.

3. Copy the following data.

4. Compute the average grades of all the subjects. Use 2 decimals.

5. Use Conditional Formatting to automatically format the color
of the average grades. If the grades are less than 75, the grades
will automatically be Red, and if the grade is 90 or greater, the
grades will be Blue.
6. To do this, select G7 to G13. Then on the Home tab, click
Conditional Formatting, Highlight Cells Rules, Less Than…
7. On the Less than window, put 75 with Red Text

8. Then click OK.

9. Then click Conditional Formatting again, Highlight Cells Rules, More Rules…
10. Choose greater than or equal to, 90.
11. Click Format and choose Blue

12. Now every time the grade drops to lower than 75, it automatically turns into Red, and if the grade
increases to 90 and above, it automatically turns into Blue.
13. For the remark, use If condition.
14. If the grades are less than 75, the remark will automatically be “Failed”, if the grade is 90 or
greater, the grade will be “VG”, and if the grade is 75 to 89.99, the grade will be “Passed”
15. To do this, on cell H7, type the following formula:

16. The final output should be like this:

17. Save your work in your folder.

 Working with Multiple Worksheets

Activity No. 9: Working with Multiple Sheets

Instructions:
1. Open a new worksheet and copy the following:

Note: The title is size 14, “Judge 1” is 12 and “Criteria for Judging” is size 10 Arial. All
headings, totals and titles are in bold face.

2. Put any score (%) for candidates 1 to 3 in the respected criteria and use formula for all totals.
(Score total must not be over 100%)
3. Go to sheet2 and copy the above illustration but replace Judge 1 with Judge 2.
4. Go to sheet3 and do the same, the judge is Judge 3. You can put different scores.
5. Rename sheet1 with Judge 1, sheet2 with Judge 2 and sheet3 with Judge 3. To do this, right
click the sheet name and click rename, then type the name that you want.

6. Insert a new sheet and rename it Total. To do this, right click the sheet name and click insert,
then on the insert window, choose Worksheet and click Ok.
7. Put Total sheet to the last by dragging it to the right.

8. Copy the following in Total sheet:

9. Link the cells in the Total sheet to the cells in Judge 1 to 3 sheet so that it automatically fills the
cells with data. Means that when you put total score in Judge 1, it will automatically fill data to
Total sheet.
10. To do this, in Total sheet under Judge 1 type ='[Sheet name]'![Cell Reference] w/o the
bracket on the separate sheet.
Example: (In Judge 1, Candidate 1)
='Judge 1'!G8
11. Do the same on other cells respectively to get all the average of total score.
12. Save your work in your own folder.
 Graphs and Charts
Activity No. 10: Graphs and Charts
Instructions:
1. Type the following.
A B C D E F G H I
5 INCOME WEEK1 WEEK2 WEEK3 WEEK4 WEEK5 WEEK6 WEEK7 TOTAL
6 FISH BALLS 900
7 KIKIAM 500
8 KWEK-KWEK 800
9 PALAMIG 1,200
10 TOTAL SALES
2. Formula:
Fish Ball: =B6+100
Kikiam: =B7+200
Kwek-kwek: =B8
Palamig: =B9+500
Total Sales: @SUM(B6:B9)
TOTAL: @SUM(B6:H6)
3. Type the remaining

Other Formulas:
Net Income: =Total Sales - Total Expenses
Cumulative Loss: =Prev. Cumulative Loss + Net Income

4. Create charts of the Income Data, Expenses Data, Net Income and Cumulative Loss.
5. For Income, drag cells A5 to I10 then click Insert, then in the Charts, select Columns (2D
Columns). The chart must be like this one:
6. Do the same for the Expenses.
7. For Net Income and Cumulative Loss, use Line chart.
8. Save your work.
Chapter 4:
Presentation Software

 The Presentation Package (MS PowerPoint)

Presentation Software – (also called a presentation graphics program) is computer software used to
present information in the form of a slide show. It typically includes functions such as allowing text to
be inserted and formatted, inserting and manipulating graphic images (animations), a slide-show system
to display the content and sometimes audio and video.
Fig 17: Examples of Presentation Software [From left to right: Zoho Show 2.0, Open Office, MS PowerPoint

Microsoft PowerPoint - is the name of a non-free commercial presentation software program developed
by Microsoft.
Fig. 18: Parts of an MS PowerPoint
 Creating a Presentation

Activity No. 1: Creating a Presentation.

Instructions:
1. Open MS PowerPoint.
2. Create a 3 slide presentation about yourself.
3. To insert new slides, on the home button, click New Slide. The shortcut is Ctrl+M
4. On the first slide, put “HELLO!” as a title, Arial Black, size 72, color is red.
5. Below the HELLO! type “Welcome to My Presentation” as subtitle, Arial, size 40, color is
blue.

6. On the 2nd slide, type My name is <your name> on the upper box (any style, size and color)
7. Below, type the following information:
I live in <your barangay, town>
I’m currently studying in <name of school>
I’m under the qualification <your course>
<Type any information about yoursef>

8. On the 3rd slide, type Thank You for Listening, Arial, size 40, black, bold.

9. Save your work in your folder and present it to the Lab In-charge.
10. To present, click View tab then Slide Show. Or by pressing F5.

*Note: Your presentation must be readable even from 2 to 3 meters.

Activity No. 2: Creating a Presentation (With background and image)
Instructions:

1. Create a 6 to 9 slide presentation about Presentation Software

and MS PowerPoint.
2. Use Background feature by going to Design tab then click
Format Background.
3. Choose any light-colored Gradient background.
4. The first slide is the title. Type Presentation Software in the
bigger box (Title) and MS PowerPoint on the smaller box
(Subtitle)
5. On the second slide, write the definition of the Presentation
Software and on the third slide, write the definition of MS PowerPoint.

6. On the fourth slide, put a picture of MS PowerPoint as an illustration.

7. You can screenshot MS PowerPoint by opening MS PowerPoint, then press “Print Screen” key
on the keyboard. Then go to your presentation and Paste the screenshot.
8. Then on 5th to 8th, write some features of the product, its advantages over other products, and
additional information.

9. On the last slide, write “Thank You for Listening”, then put
any picture below it.
10. Write “Presented By: (Your Name)” below the picture.
11. Put a light color background to title slide and a different
light color background for the rest of the slides.
12. Save your work in your folder and present it.

*Note: Your presentation must be readable even from 2 to 3 meters.

 Slide Designs

Activity No. 3: Commercial Presentation (With background and image)

Instructions:

1. Create a 6 slide commercial presentation about a product/service (this could be real or fictional
product/service.)
2. Use slide designs for this activity. Click Design then choose themes, color themes, fonts and
effects that you want for your presentation.
3. On the 1st slide, put the name, logo and slogan of the product/service that you’re advertising.
4. You can use WordArt by clicking Insert tab.
5. On the 2nd to 4th slide, tell why we have to buy that product/service.
Examples: (Don’t copy, make your own)
Our product is what’s “IN” today.
Our company is celebrating its 20th anniversary and we’re having discounts
Our service is #1 in terms of quality
Our new product is scientifically approved
Our service is the best in the whole-wide world ever.
6. On the 5th slide, put where your products are available for sale or the address and contact of your
company/office.
7. You can also put prices and special offers.
8. On the last slide, Put the again the name, logo and slogan of your product/service but with
different design from the 1st slide.
9. Example:

10. Save your work in your folder and present it.

*Note: Your presentation must be readable even from 2 to 3 meters.

Activity No. 4: Applying Slide Number, Date and Time, and Slide Master

Instructions:
1. Insert 6 slides.
2. In the 1st slide, put ABC Company as the title. Type 123 St. XYZ Bldg Balayan Batangas as
the subtitle.
3. Insert Header and Footer by going to the Insert tab then click Header and Footer.
4. Type ABC Company 123 St. XYZ Bldg Balayan Batangas on the Footer.
5. Check the Date and Time box and Slide Number box. Then click the “apply to all.”

6. As you can see, there will be the same information below all your slides:

7. Copy the following for the rest of the slides:

Slide no. 2 Slide no. 3

Slide no. 4

Slide no. 5 Slide no. 6

8. Save and present your work.

 Slide Transitions and Animations

Activity No. 5: Types of Computer Hardware (Slide Transition and Animations)

Instructions:
1. Create a 7-slide presentation on Types of Computer Hardware.
2. Draw the pictures of the computer hardware by using Shapes.
3. On the Insert tab, click Shapes.
4. Use combinations of shapes to draw the different computer hardware.
5. Use Slide Transitions for all the slides.
6. Select the slide that you want to put transition, and then on the Transition tab, click the
transition style.
7. Use either Push, Cover, or Peel Off transitions.
8. Use Entrance animation for all the pictures.
9. Save and present your work.
Activity No. 6: How Data are Processed into Information (Custom Animation)

Instructions:
1. Create a 6 slide presentation on “How Data are Processed into Information”.
2. The 1st slide is a title slide and the 2nd is a slide that explains how the computer works.

3. 3rd to 5th slide will explain how data is processed into information.
4. Use Shapes, WordArt and Text Boxes for the Digital Data, Analog Data, Input hardware,
Output Hardware, Processing and Memory Hardware, Digital Information, Analog Information,
etc.
5. Put custom animation on Analog Data. Select Analog Data, then in Animations, click custom
animation, then add effect, then Motion Paths, and then choose Right.
6. Adjust the animation so that the Analog Data will hide under the box.
7. Then put an Entrance animation, then Emphasis, then Exit, animation on Converting and
Processing.
8. Then create Digital Data and put it behind the yellow box. Put also Right custom animation on
Digital Data so that it will show after Converting animation.

9. Do the same to slides 4 and 5.

10. Save and present your work.