Computer Laboratory Manual: Fundamental of ICT Lab Manual

COMPUTER LABORATORY MANUAL
Fundamental of ICT
(CPS – 101)
Fall Semester
DEPARTMENT OF COMPUTER SOFTWARE ENGINEERING

Military College of Signals
National University of Sciences and Technology
www.mcs.nust.edu.pk
1 Fundamental of ICT Lab Manual

PREFACE
This manual has been prepared to accompany the course CPS-101 Introduction to computing for UG Students.
The laboratory exercises are designed in such a way to reinforcement the concepts taught in the lectures. The
specific intent of each lab session should be kept in mind throughout the laboratory session and that is to introduce
a topic and have the student feel comfortable with the use of the machine and the particular software. Each student
is responsible for submitting lab report upon completion of each session. The report must be submitted on the
next lab
PREPARED BY
Lab manual is prepared by Lt Col (R) Mohammad Saleem and Demonstrator Kabeer Ahmed under the supervision
of Head of Department Dr. Naveed Iqbal Rao in year 2013.
GENERAL INSTRUCTIONS
a. Students are required to maintain the lab manual with them till the end of the semester.
b. All readings, answers to questions and illustrations must be solved on the place provided. If more space is
required then additional sheets may be attached. You may add screen print to the report by using the ‘Print
Screen’ command on your keyboard to get a snapshot of the displayed output.
c. It is the responsibility of the student to have the manual graded before deadlines as given by the instructor
d. Loss of manual will result in re submission of the complete manual.
e. Students are required to go through the experiment before coming to the lab session. Lab session details will
be given in training schedule.
f. Students must bring the manual in each lab.
g. Keep the manual neat clean and presentable.
h. Plagiarism is strictly forbidden. No credit will be given if a lab session is plagiarised and no re submission
will be entertained.
i. Marks will be deducted for late submission.
j. In the exercises, you have to put the output in your Lab report.
k. Name your reports using the following convention:
Lab#_Rank_YourFullName
(1) ‘#’ replaces the lab number.
(2) ‘Rank’ replaces Maj/Capt/TC/NC/PC
(3) ‘YourFullName’ replaces your complete name.
l. You need to submit the report even if you have demonstrated the exercises to the lab engineer/instructor or
shown them the lab report during the lab session.
VERSION HISTORY
Date Update By Details
July 2011 Lec Ijaz Ahmed First Version Created
July 2013 Demo Kabeer Ahmed Second Version Created

MARKS
Exp Date Experiment Title Max. Marks Instructor

# Conducted Marks Obtained Sign
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Grand Total

LIST OF EXPERIMENTS
EXPERIMENT 1 – INTRODUCTION TO COMPUTER AND CAMPUS NETWORKING .............................................. 5
EXPERIMENT 2 – INTRODUCTION TO MS OFFICE ...................................................................................................... 9
EXPERIMENT 3 – MS WORD-I ......................................................................................................................................... 12
EXPERIMENT 4 – MS WORD-II ....................................................................................................................................... 33
EXPERIMENT 6 – MS POWER POINT-II ......................................................................................................................... 78
EXPERIMENT 7 – MS EXCEL-I ........................................................................................................................................ 94
EXPERIMENT 8 – MS EXCEL-II ..................................................................................................................................... 111
EXPERIMENT 9 – MS OUTLOOK .................................................................................................................................. 128
EXPERIMENT 10 – MS PUBLISHER ................................................................................... Error! Bookmark not defined.
EXPERIMENT 11 – INTRODUCTION TO PROGRAMMING ENVIRONMENT IN C++ Error! Bookmark not defined.
EXPERIMENT 12 – INPUT/OUTPUT IN C++ ..................................................................... Error! Bookmark not defined.
EXPERIMENT 13 – DECISION STATEMENT IN C++ ....................................................... Error! Bookmark not defined.

EXPERIMENT 1 – INTRODUCTION TO COMPUTER AND CAMPUS
NETWORKING
Objective
 To acquaint the students with different hardware parts of the computer system and layout of the MCS
network from student prospective
Time Required : 3 hrs
Programming Language : NIL
Software Required : NIL
Hardware Required : Computer System
Procedure
Physically show each hardware part and hands on experience with login procedure.
Introduction to Computer Components

Motherboard: A motherboard (sometimes alternatively known as the main
board, system board, planar board or logic board, or colloquially, a mab0) is the
main printed circuit board (PCB) found in computers and other expandable
systems. It holds many of the crucial electronic components of the system, such
as the central processing unit (CPU) and memory, and provides connectors for
other peripherals. Unlike a backplane, a motherboard contains significant sub-
systems such as the processor.
Microprocessor: A microprocessor incorporates the functions of a computer's

central processing unit (CPU) on a single integrated circuit (IC), or at most a
few integrated circuits. It is a multipurpose, programmable device that accepts
digital data as input, processes it according to instructions stored in its memory,
and provides results as output. It is an example of sequential digital logic, as it
has internal memory. Microprocessors operate on numbers and symbols
represented in the binary numeral system.
Hard Disk: A hard disk drive (HDD) is a data storage device used for storing and retrieving digital information
using rapidly rotating disks (platters) coated with magnetic material. An HDD retains its data even when powered
off. Data is read in a random-access manner,
meaning individual blocks of data can be stored or
retrieved in any order rather than sequentially. An
HDD consists of one or more rigid ("hard") rapidly
rotating disks (platters) with magnetic heads
arranged on a moving actuator arm to read and
write data to the surfaces.
Optical Driver (CD Rom Driver): CD-ROM discs are read using CD-ROM drives.
A CD-ROM drive may be connected to the computer via an IDE (ATA), SCSI,
SATA, FireWire, or USB interface or a proprietary interface, such as the Panasonic
CD interface. Virtually all modern CD-ROM drives can also play audio CDs (as well
as Video CDs and other data standards) when used in conjunction with the right
software.
CD-ROM: This modern miracle gained prominence in the late 1980's and has become the primary distribution
medium for software to consumers. The Compact Disk-Read Only Memory (CD-ROM) disk itself is a
5 Fundamental of ICT– Introduction to Computer and Campus Networking
collection of concentric circles containing millions of pits and plateaus which
correspond to on/off bits of data. The disk is read with an optical laser similar to
the one used to scan your groceries at the supermarket. Most disks of this kind are
"Read only" meaning that the computer can retrieve information from the disk,
but cannot place information on it. New developments have improved this
technology to allow writing and rewriting data to the disk. A different kind of
hardware mechanism is needed to employ this innovation.
Random-access memory (RAM): Random-access memory (RAM) is a form of

computer data storage. A random-access device allows stored data to be accessed
directly in any random order. In contrast, other data storage media such as hard
disks, CDs, DVDs and magnetic tape, as well as early primary memory types such
as drum memory, read and write data only in a predetermined order, consecutively,
because of mechanical design limitations. Therefore the time to access a given data
location varies significantly depending on its physical location.
RAM TYPE PINS WIDTH USAGE

SD RAM 168 64 bit Older and slower type. No use.
Rambus RAM 184 16 bit Advanced RAM. Only used for very few
Pentium 4’s with certain Intel chipsets.
DDR RAM 184 64 bit A faster version of SD RAM. Used both for
Athlon and Pentium 4’s. 2,5 Volt.
DDR2 RAM 240 64 bit New version of DDR RAM with higher clock
frequencies. 1,8 Volt.
Power Supply: A power supply unit (PSU) converts mains AC to low-voltage regulated
DC power for the internal components of a computer. Modern personal computers
universally use a switched-mode power supply. Some power supplies have a manual
selector for input voltage, while others automatically adapt to the supply voltage.
Data Cables: Serial ATA (Advance Technology Attachment)(SATA) is a computer bus

interface that connects host bus adapters to mass storage devices such as hard disk drives
and optical drives. Serial ATA replaces the older AT Attachment standard (ATA later
referred to as Parallel ATA or PATA), offering several advantages over the older interface:
reduced cable size and cost (seven conductors instead of 40), native hot swapping, faster
data transfer through higher signalling rates, and more efficient transfer through an
(optional) I/O queuing protocol.
Computer Network Overview:

A computer network consists of a collection of computers,
printers and other equipment that is connected together so that
they can communicate with each other. An example of a network
comprising of a local area network or LAN connecting computers
with each other, the internet, and various servers.

Characteristics of a Computer Network
The primary purpose of a computer network is to share resources:
 You can play a CD music from one computer while sitting on
another computer
 You may have a computer that doesn’t have a DVD or BluRay
(BD) player. In this case, you can place a movie disc (DVD or
BD) on the computer that has the player, and then view the
movie on a computer that lacks the player
 You may have a computer with a CD/DVD/BD writer or a
backup system but the other computer(s) doesn’t (don't) have it.
In this case, you can burn discs or make backups on a computer
that has one of these but using data from a computer that
doesn’t have a disc writer or a backup system
 You can connect a printer (or a scanner, or a fax machine) to one computer and let other computers of the
network print (or scan, or fax) to that printer (or scanner, or fax machine)
 You can place a disc with pictures on one computer and let other computers access those pictures
 You can create files and store them in one computer, then access those files from the other computer(s)
connected to it
Web Resources
http://www.wies-
hs.eu.dodea.edu/Courses/PTS/Electronics/ComputerServiceSupport/css/Forms/Doc/CPUAsyGD.pdf
http://vfu.bg/en/e-Learning/Computer-Networks--Introduction_Computer_Networking.pdf
Videos Resources
http://www.youtube.com/watch?v=ClPA3F_ZXds
http://www.youtube.com/watch?v=BZ6WCqRb_us

EXERCISES
Exercise 1.1 [4]
Different hardware part of the computer with the purpose/function of each.
Exercise 1.2 [6]

Network Diagram of MCS for students

EXPERIMENT 2 – INTRODUCTION TO MS OFFICE
Objective
To acquaint the students with different applications available in MS office Package.
Software Required : Microsoft Office 2007 or latest
Hardware Required : NIL
Procedure
To open an application, Double click quickly on the application icon (Word, PowerPoint, Excel, etc.) on the
Windows desktop. Or, click the Start button, in the lower left corner of the screen, then click All Programs, move
the cursor over Microsoft Office and select the desired application.
MS Office Applications
Following applications are available in MS Office; we’ll be addressing each one by one.
 MS Word
 MS Power Point
 MS Excel
 MS Outlook, MS Publisher
MS Word: Microsoft Word is an example of a program called a “word processor.”Word processors are used to
create and print text documents in much the same way that you would use a typewriter. The key benefit to using
a word processor is that you can make changes easily, including correcting spelling; adding, deleting, formatting,
and relocating text; and inserting images. Once you create a document, you can effortlessly print it (as many
copies as you want!), save it for later modifications, or send it to a friend via e-mail. Microsoft Word is a very
powerful word processor
MS Excel: Microsoft Excel is an example of a program called a “spreadsheet.”Spreadsheets are used to organize
real world data, such as a check register or a rolodex. Data can be numerical or alphanumeric (involving letters
or numbers). The key benefit to using a spreadsheet program is that you can make changes easily, including
correcting spelling or values, adding, deleting, formatting, and relocating data. You can also program the
spreadsheet to perform certain functions automatically (such as addition and subtraction), and a spreadsheet can
hold almost limitless amounts of data—a whole filing cabinet’s worth of information can be included in a single
spreadsheet. Once you create a spreadsheet, you can effortlessly print it (as many copies as you want!), save it for
later modifications, or send it to a colleague via e-mail. Microsoft Excel is a very powerful calculator
MS Power Point: Microsoft PowerPoint is a software product used to perform computer-based presentations.
There are various circumstances in which a presentation is made: teaching a class, introducing a product to sell,
explaining an organizational structure, etc.
MS Outlook: Microsoft Outlook is a versatile component of the Microsoft Office 2003 for users to manage
personal information and to communicate with others. It helps you in managing your email messages,
appointments, contacts, and tasks, as well as making reminders and tracking activities
MS Publisher: Microsoft Publisher is a desktop publishing program that can be used to create a variety of
publications. Using Publisher, you can easily create business cards, greeting cards, calendars, newsletters and
much, much more
9 Fundamental of ICT – Introduction to Ms Office

Web Resources
http://www.dummies.com/how-to/content/office-2007-for-dummies-cheat-sheet.html
http://winsupersite.com/office/microsoft-office-2007-review-part-1-introduction
http://www.slideshare.net/GurpreetSingh160/ms-office-2010-vs-2007
Videos Resources
http://www.youtube.com/watch?v=G9ixcE9Bj44
http://www.youtube.com/watch?v=CK_xa_avd44

EXERCISES
Exercise 2.1 [5]
Compare the different version of MS office 2007, 2010, 2013 and list down the difference between them.
Exercise 2.2 [5]

What are the common feature in MS office applications (Word, Excel, Power point etc).

EXPERIMENT 3 – MS WORD-I
Objective
To acquaint the students with different options available in MS word application.
Procedure
It is the word processing program of the Microsoft Office suite that allows you to create documents and reports.
Introduction MS Office Interface

First screen of word, which is produced showing the effects of each option.
Menus: When you begin to explore Word 2007 you will notice a new
look to the menu bar. There are three features that you should remember
as you work within Word 2007: the Microsoft Office Button, the Quick
Access Toolbar, and the Ribbon. These three features contain many of
the functions that were in the menu of previous versions of Word. The
functions of these three features will be more fully explored below.
The Microsoft Office Button: The Microsoft Office button performs

many of the functions that were located in the File menu of older versions
of Word. This button allows you to create a new document, open an
existing document, save or save as, print, send (through email or fax),
publish or close.
12 Fundamental of ICT – MS Word-I

The Ribbon
The Ribbon is the panel at the top portion of the document. It has seven tabs: Home, Insert, Page Layout,
References, Mailings, Review, and View that contain many new and existing features of Word. Each tab is divided
into groups. The groups are logical collections of features designed to perform functions that you will utilize in
developing or editing your Word document. Commonly used features are displayed on the Ribbon, to view
additional features within each group, click on the arrow at the bottom right of each group.
Each of the tabs contains the following tools:

Home: Clipboard, Fonts, Paragraph, Styles, and Editing.
Insert: Pages, Tables, Illustrations, Links, Header & Footer, Text, and Symbols
Page Layout: Themes, Page Setup, Page Background, Paragraph, Arrange
References: Table of Contents, Footnote, Citation & Bibliography, Captions, Index, and Table of Authorities
Mailings: Create, Start Mail Merge, Write & Insert Fields, Preview Results, Finish
Review: Proofing, Comments, Tracking, Changes, Compare, Protect
View: Document Views, Show/Hide, Zoom, Window, Macros
Quick Access Toolbar
The quick access toolbar is a customizable toolbar that contains commands that you may want to use. You can
place the quick access toolbar above or below the ribbon. To change the location of the quick access toolbar, click
on the arrow at the end of the toolbar and click on Show Below the Ribbon.

You can also add items to the quick access toolbar. Right click on any item in the Office Button or the Ribbon
and click on Add to Quick Access Toolbar and a shortcut will be added to the Quick Access Toolbar.
Working With Documents

Create a New Document: There are several ways to create new documents, open existing documents, and save
documents in Word:
 Click the Microsoft Office Button and Click New or

 Press CTRL+N (Depress the CTRL key while pressing the “N”) on the keyboard
You will notice that when you click on the Microsoft Office Button and Click New, you have many choices about
the types of documents you can create. If you wish to start from a blank document, click Blank. If you wish to
start from a template you can browse through your choices on the left, see the choices on center screen, and
preview the selection on the right screen.

Opening an Existing Document
 Click the Microsoft Office Button and Click Open, or

 Press CTRL+O (Depress the CTRL key while pressing the “O”) on the keyboard, or
 If you have recently used the document you can click the Microsoft Office Button and click the name of the
document in the Recent Documents section of the window Insert picture of recent docs
Saving a Document
 Click the Microsoft Office Button and Click Save or Save As (remember, if you’re sending the
document to someone who does not have Office 2007, you will need to click the Office Button, click Save
As, and Click Word 97-2003 Document), or
 Press CTRL+S (Depress the CTRL key while pressing the “S”) on the keyboard, or
 Click the File icon on the Quick Access Toolbar
Renaming Documents: To rename a Word document while using the program:
 Click the Office Button and find the file you want to rename.
 Right-click the document name with the mouse and select Rename from the shortcut menu.
 Type the new name for the file and press the ENTER key.
Working on Multiple Document

Several documents can be opened simultaneously if you are typing or editing multiple documents at once. All
open documents will be listed in the View Tab of the Ribbon when you click on Switch Windows. The current
document has a checkmark beside the file name. Select another open document to view it.

Document Views
There are many ways to view a document in Word.
 Print Layout: This is a view of the document as it would appear when printed. It includes all tables, text,
graphics, and images.
 Full Screen Reading: This is a full view length view of a document. Good for viewing two pages at a time.
 Web Layout: This is a view of the document as it would appear in a web browser.
 Outline: This is an outline form of the document in the form of bullets.
 Draft: This view does not display pictures or layouts, just text.
To view a document in different forms, click the document views shortcuts at the bottom of the screen
or:
 Click the View Tab on the Ribbon
 Click on the appropriate document view.
Close a Document
To close a document:
 Click the Office Button
 Click Close
Customize the Word Environment

Word 2007 offers a wide range of customizable options that allow you to make Word work the best for you. To
access these customizable options:
 Click Word Options

Popular: These features allow you to personalize your work environment with language, color schemes, user
name and allow you to access the Live Preview feature. The Live Preview feature allows you to preview the
results of applying design and formatting changes without actually applying it.
Display: This feature allows you to modify how the document content is displayed on the screen and when
printed. You can opt to show or hide certain page elements.

Proofing: This feature allows you personalize how word corrects and formats your text. You can customize auto
correction settings and have word ignore certain words or errors in a document.
Save: This feature allows you personalize how your document is saved. You can specify how often you want
auto save to run and where you want the documents saved.
Advanced: This feature allows you to specify options for editing, copying, pasting, displaying, printing and
saving.

Customize: Customize allows you to add features to the Quick Access Toolbar. If there are tools that you are
utilizing frequently, you may want to add these to the Quick Access Toolbar.
Editing a Document
Typing and inserting Text: To enter text, just start typing! The text will appear where the blinking cursor is
located. Move the cursor by using the arrow buttons on the keyboard or positioning the mouse and clicking the
left button. The keyboard shortcuts listed below are also helpful when moving through the text of a document:
Move Action Keystroke

Beginning of the line HOME
End of the line END
Top of the document CTRL+HOME
End of the document CTRL+END
Selecting Text: To change any attributes of text it must be highlighted first. Select the text by dragging the mouse
over the desired text while keeping the left mouse button depressed, or hold down the SHIFT key on the keyboard
while using the arrow buttons to highlight the text. The following table contains shortcuts for selecting a portion
of the text:
Selection Technique
Whole word double-click within the word
Whole paragraph triple-click within the paragraph
Several words or lines drag the mouse over the words, or hold down SHIFT while using the arrow
keys
Entire document choose Editing | Select | Select All from the Ribbon, or press CTRL+A
Deselect the text by clicking anywhere outside of the selection on the page or press an arrow key on the keyboard.
Inserting Additional Text: Text can be inserted in a document at any point using any of the following methods:
 Type Text: Put your cursor where you want to add the text and begin typing
 Copy and Paste Text: Highlight the text you wish to copy and right click and click Copy, put your cursor
where you want the text in the document and right click and click Paste.
 Cut and Paste Text: Highlight the text you wish to copy and right click and click Cut, put your cursor
where you want the text in the document and right click and click Paste.
 Drag Text: Highlight the text you wish to move, click on it and drag it to the place where you want the
text in the document.
You will notice that you can also use the Clipboard group on the Ribbon.
Rearranging Blocks of Text: To rearrange text within a document, you can utilize the Clipboard Group on the
Home Tab of the Ribbon.
Insert picture of clipboard group labelled
 Move text: Cut and Paste or Drag as shown above
 Copy Text: Copy and Paste as above or use the Clipboard group on the Ribbon
 Paste Text: Ctrl + V (hold down the CTRL and the “V” key at the same time) or use the Clipboard group to
Paste, Paste Special, or Paste as Hyperlink
Deleting Blocks of Text: Use the BACKSPACE and DELETE keys on the keyboard to delete text. Backspace
will delete text to the left of the cursor and Delete will erase text to the right. To delete a large selection of text,
highlight it using any of the methods outlined above and press the DELETE key.
Search and Replace Text: To find a particular word or phrase in a document:

 Click Find on the Editing Group on the Ribbon
 To find and replace a word or phrase in the document, click Replace on the Editing Group of the Ribbon.
Undo Changes: To undo changes:

 Click the Undo Button on the Quick Access Toolbar
Formatting Text
Styles: A style is a format enhancing tool that includes font typefaces, font size, effects (bold, italics, underline,
etc.), colors and more. You will notice that on the Home Tab of the Ribbon, that you have several areas that will
control the style of your document: Font, Paragraph, and Styles.
Change Font Typeface and Size: To change the font typeface:

 Click the arrow next to the font name and choose a font.

 Remember that you can preview how the new font will look by highlighting the text, and hovering over the
new font typeface.
To change the font size:

 Click the arrow next to the font size and choose the appropriate size, or
 Click the increase or decrease font size buttons.
Font Styles and Effects: Font styles are predefined formatting options that are used to emphasize text. They
include: Bold, Italic, and Underline. To add these to text:
Select the text and click the Font Styles included on the Font Group of the Ribbon, or
Select the text and right click to display the font tools
Change Text Color: To change the text color:

 Select the text and click the Colors button included on the Font Group of the Ribbon, or Highlight the text
and right click and choose the colors tool.
 Select the color by clicking the down arrow next to the font color button.

Highlight Text: Highlighting text allows you to use emphasize text as you would if you had a marker. To
highlight text:
 Select the text
 Click the Highlight Button on the Font Group of the Ribbon, or
 Select the text and right click and select the highlight tool
 To change the color of the highlighter click on down arrow next to the highlight button.
Copy Formatting: If you have already formatted text the way you want it and would like another portion of the
document to have the same formatting, you can copy the formatting. To copy the formatting, do the following:
 Select the text with the formatting you want to copy.
 Copy the format of the text selected by clicking the Format Painter button on the Clipboard Group of the
Home Tab
 Apply the copied format by selecting the text and clicking on it.
Clear Formatting: To clear text formatting:

 Select the text you wish to clear the formatting
 Click the Styles dialogue box on the Styles Group on the Home Tab
 Click Clear All

Formatting Paragraphs
Formatting paragraphs allows you to change the look of the overall document. You can access many of the tools
of paragraph formatting by clicking the Page Layout Tab of the Ribbon or the Paragraph Group on the Home
Tab of the Ribbon.
Change Paragraph Alignment: The paragraph alignment allows you to set how you want text to appear. To
change the alignment:
 Click the Home Tab
 Choose the appropriate button for alignment on the Paragraph Group.
 Align Left: the text is aligned with your left margin
 Center: The text is centered within your margins
 Align Right: Aligns text with the right margin
 Justify: Aligns text to both the left and right margins.
Indent Paragraphs: Indenting paragraphs allows you set text within a paragraph at different margins. There are
several options for indenting:
 First Line: Controls the left boundary for the first line of a paragraph
 Hanging: Controls the left boundary of every line in a paragraph except the first one
 Left: Controls the left boundary for every line in a paragraph
 Right: Controls the right boundary for every line in a paragraph
To indent paragraphs, you can do the following:

 Click the Indent buttons to control the indent.
 Click the Indent button repeated times to increase the size of the indent.
 Click the dialog box of the Paragraph Group

 Click the Indents and Spacing Tab
 Select your indents

Add Borders and Shading: You can add borders and shading to paragraphs and entire pages. To create a border
around a paragraph or paragraphs:
 Select the area of text where you want the border or shading.
 Click the Borders Button on the Paragraph Group on the Home Tab
 Choose the Border and Shading
 Choose the appropriate options

Apply Style: Styles are a present collection of formatting that you can apply to text. To utilize Quick Styles:
 Select the text you wish to format.
 Click the dialog box next to the Styles Group on the Home Tab.
 Click the style you wish to apply.
Create Links: Creating links in a word document allows you to put in a URL that readers can click on to visit a
web page. To insert a link:
 Click the Hyperlink Button on the Links Group of the Insert Tab.
 Type in the text in the “Text to Display” box and the web address in the “Address” box.
Change Spacing Between Paragraphs and Lines: You can change the space between lines and paragraphs by
doing the following:
 Select the paragraph or paragraphs you wish to change.
 On the Home Tab, Click the Paragraph Dialog Box
 Click the Indents and Spacing Tab
 In the Spacing section, adjust your spacing accordingly

Styles: The use of Styles in Word will allow you to quickly format a document with a consistent and professional
look. Styles can be saved for use in many documents.
Apply Styles: There are many styles that are already in Word ready for you to use. To view the available styles
click the Styles dialog box on the Styles Group in the Home Tab. To apply a style:
 Select the text
 Click the Styles Dialog Box
 Click the Style you choose
Creating New Styles: You can create styles for formatting that you use regularly. There are two ways to do
this: New Styles or New Quick Styles.
New Styles: To create a new style:
 Click the Styles Dialog Box
 Click the New Style Button

 Complete the New Style dialog box.
 At the bottom of that dialog box, you can choose to add this to the Quick Style List or to make it available
only in this document.

New Quick Style: To create a style easily:
 Insert your cursor anywhere in the chosen style
 Click the Styles dialog box
 Click Save Selection as New Quick Style
Style Inspector: To determine the style of a particular section of a document:

 Insert cursor anywhere in the text that you want to explain the style
 Click the Styles Drop Down Menu
 Click the Style Inspector Button

Adding Tables
Tables are used to display data in a table format.
Create a Table: To create a table:
 Place the cursor on the page where you want the new table
 Click the Insert Tab of the Ribbon
 Click the Tables Button on the Tables Group. You can create a table one of four ways:
 Highlight the number of row and columns
 Click Insert Table and enter the number of rows and columns
 Click the Draw Table, create your table by clicking and entering the rows and columns
 Click Quick Tables and choose a table
Enter Data in a Table: Place the cursor in the cell where you wish to enter the information. Begin typing.
Modify the Table Structure and Format a Table: To modify the structure of a table:
 Click the table and notice that you have two new tabs on the Ribbon: Design and Layout. These pertain to
the table design and layout.
On the Design Tab, you can choose:

 Table Style Options
 Table Styles
 Draw Borders
To format a table, click the table and then click the Layout Tab on the Ribbon. This Layout tab allows you to:
 View Gridlines and Properties (from the Table Group)
 Insert Rows and Columns (from the Rows & Columns Group)
 Delete the Table, Rows and/or Columns (from the Rows & Columns Group)
 Merge or Split Cells (from the Merge Group)
 Increase and Decrease cell size (Cell Size Group)
 Align text within the cells and change text directions (Alignment Group)
Web Resources
http://www.reading.ac.uk/web/files/its/WordBeginner.pdf
http://www3.northern.edu/help/tutorials/Office2007/Word%202007%20Tutorial.pdf
Videos Resources
http://www.youtube.com/watch?v=4Ha8_CrVCJ8
http://www.youtube.com/watch?v=hzyWJqVqW_U

EXERCISES
Exercise 3.1 [2]

Open Ms Word and save file with name of “My first file” and write two paragraphs, each paragraph contains 4
to 5 lines.
Note: Save file after any change.
Exercise 3.2 [2]

Change the font size of paragraph at 12 font size, style Time New Roman, font effect in to italic, and change
text color into red?
Exercise 3.3 [2]

Change Spacing between Paragraphs and Lines (single lines), and create a hyperlink?
Exercise 3.4 [2]

Change Paragraph Alignment, Left, Centre or Right?
Exercise 3.5 [2]

Add page Borders and Shading, shadow borders and doted line?

EXPERIMENT 4 – MS WORD-II
Objective
To acquaint the students with different options available in MS word application.
Procedure
It is the word processing program of the Microsoft Office suite that allows you to create documents and reports.
Graphics:Word 2007 allows you to insert special characters, symbols, pictures, illustrations, and watermarks.
Symbols and Special Characters

Special characters are punctuation, spacing, or typographical characters that are not generally available on the
standard keyboard. To insert symbols and special characters:
 Place your cursor in the document where you want the symbol
 Click the Insert Tab on the Ribbon
 Click the Symbol button on the Symbols Group
 Choose the appropriate symbol.
Equations: Word 2007 also allows you to insert mathematical equations. To access the mathematical equations
tool:
 Place your cursor in the document where you want the symbol
 Click the Equation Button on the Symbols Group
 Choose the appropriate equation and structure or click Insert New Equation
33 Fundamental of ICT – MS Power point-I

 To edit the equation click the equation and the Design Tab will be available in the Ribbon
Illustrations, Pictures, and SmartArt: Word 2007 allows you to insert illustrations and pictures into a
document. To insert illustrations:
 Place your cursor in the document where you want the illustration/picture
 Click the Clip Art Button
 The dialog box will open on the screen and you can search for clip art.
 Choose the illustration you wish to include

To insert a picture:
 Click the Picture Button
 Browse to the picture you wish to include
 Click the Picture
 Click Insert
Smart Art is a collection of graphics you can utilize to organize information within your document. It includes
timelines, processes, or workflow. To insert SmartArt
 Click the SmartArt button
 Click the SmartArt you wish to include in your document
 Click the arrow on the left side of the graphic to insert text or type the text in the graphic.

Resize Graphics: All graphics can be resized by clicking the image and clicking one corner of the image and
dragging the -cursor to the size you want the picture.
Watermarks: A watermark is a translucent image that appears behind the primary text in a document. To insert
a watermark:
 Click the Page Layout Tab in the Ribbon
 Click the Watermark Button in the Page Background Group
 Click the Watermark you want for the document or click Custom Watermark and create your own
watermark
 To remove a watermark, follow the steps above, but click Remove Watermark
Proofing a Document
There are many features to help you proofread your document. These include: Spelling and Grammar, Thesaurus,
AutoCorrect, Default Dictionary, and Word Count.
Spelling and Grammar: To check the spelling and grammar of a document
 Place the cursor at the beginning of the document or the beginning of the section that you want to check
 Click the Review Tab on the Ribbon
 Click Spelling & Grammar on the Proofing Group.

 Any errors will display a dialog box that allows you to choose a more appropriate spelling or phrasing.
If you wish to check the spelling of an individual word, you can right click any word that has been underlined by
Word and choose a substitution.
Thesaurus: The Thesaurus allows you to view synonyms. To use the thesaurus:
 Click the Review Tab of the Ribbon
 Click the Thesaurus Button on the Proofing Group.
 The thesaurus tool will appear on the right side of the screen and you can view word options.

You can also access the thesaurus by right-clicking any word and choosing Synonyms on the menu.
Customize AutoCorrect: You can set up the AutoCorrect tool in Word to retain certain text the way it is. To
customize AutoCorrect:
 Click the Microsoft Office button
 Click the Word Options Button
 Click the Proofing tab
 Click AutoCorrect Options button

 On the AutoCorrect Tab, you can specify words you want to replace as you type
Create a New Default Dictionary: Often you will have business or educational jargon that may not be recognized
by the spelling and/or grammar check in Word. You can customize the dictionary to recognize these words.
 Click the Microsoft Office button
 Click the Word Options Button
 Click the Proofing tab
 Click the When Correcting Spelling tab
 Click Custom Dictionaries

 Click Edit Word List
 Type in any words that you may use that are not recognized by the current dictionary.
Check Word Count: To check the word count in Word 2007 look at the bottom left corner of the screen. It will
give you a total word count or if you have text highlighted it will tell you how many words are highlighted out of
the total.
Page Formatting
Modify Page Margins and Orientations: The page margins can be modified through the following steps:
 Click the Page Layout Tab on the Ribbon
 On the Page Setup Group, Click Margins
 Click a Default Margin, or

 Click Custom Margins and complete the dialog box.
To change the Orientation, Size of the Page, or Columns:

 On the Page Setup Group, Click the Orientation, Size, or Columns drop down menus
 Click the appropriate choice
Apply a Page Border and Color: To apply a page border or color:

 On the Page Background Group, click the Page Colors or Page Borders drop down menus
Insert Common Header and Footer Information: To insert Header and Footer information such as page
numbers, date, or title, first, decide if you want the information in the header (at the top of the page) or in the
Footer (at the bottom of the page), then:
 Click Header or Footer

 Choose a style
 I
 The Header/Footer Design Tab will display on the Ribbon
 Choose the information that you would like to have in the header or footer (date, time, page numbers, etc.) or
type in the information you would like to have in the header or footer
Create a Page Break: To insert a page break:

 On the Page Setup Group, click the Breaks Drop Down Menu
 Click Page Break
Insert a Cover Page: To insert a cover page:

 Click the Cover Page Button on the Pages Group
 Choose a style for the cover page

I
Insert a Blank Page: To insert a blank page:

 Click the Blank Page Button on the Page Group

Macros
« Page Formatting
Macros Table of Contents »
Macros
Macros are advanced features that can speed up editing or formatting you may perform often in a Word document.
They record sequences of menu selections that you choose so that a series of actions can be completed in one
step.
Recording a Macro: To record a Macro:

 Click Macros
 Click Record Macro

 Enter a name (without spaces)
 Click whether you want it assigned to a button (on the Quick Access Toolbar) or the keyboard (a sequence
of keys)
 To assign the macro a button on the Quick Access Toolbar:
 Click Button
 Under the Customize Quick Access Toolbar, select the document for which you want the Macro
available
 Under Choose Commands: Click the Macro that you are recording
 Click Add
 Click OK to begin Recording the Macro
 Perform the actions you want recorded in the Macro
 Click on Macros

 Click on Stop Recording Macros
 To assign a macro button to a keyboard shortcut:

 Click Keyboard
 In the Press New Shortcut Key box, type the key sequence that you want and click Assign
 Click Close to begin recording the Macro

 Perform the actions you want recorded in the Macro
 Click on Macros
 Click on Stop Recording Macros
Running a Macro: Running a macro depends on whether it’s been added to the Quick Access Toolbar or if it’s
been given a Keyboard Shortcut.
 To run a Macro from the Quick Access Toolbar, simply click the Macro Icon
 To run a Macro from the Keyboard shortcut, simply press the keys that you have programmed to run the
Macro.
Table of Contents
The easiest way to create a Table of Contents is to utilize the Heading Styles that you want to include in the
Table of Contents. For example: Heading 1, Heading 2, etc. based on the content of your document. When you
add or delete headings from your document, Word updates your Table of Contents. Word also updates the page
number in the table of contents when information in the document is added or deleted. When you create a Table

of Contents, the first thing you want to do is mark the entries in your document. The Table of Contents is
formatted based on levels of headings. Level 1 will include any text identified with the style Heading 1.
Mark Table of Contents Entries: You can mark the Table of Contents entries in one of two ways: by using
built-in heading styles or by marking individual text entries.
To Use Built-In Heading Styles

 Select the text that you wish to be the heading
 In the Styles Group, click Heading 1 (or the appropriate heading)
 If you don’t see the style you want, click the arrow to expand the Quick Styles Gallery
 If the style you want does not appear click Save Selection as New Quick Style
To Mark Individual Entries:

 Select the text you wish to make a heading
 Click the References Tab
 Click Add Text in the Table of Contents Group
 Click the Level that you want to label your selection

Create a Table of Contents
To create the table of contents:
 Put your cursor in the document where you want the Table of Contents
 Click the References Tab
 Click the Table of Contents button
Update Table of Contents: If you have added or removed headings or other table of contents entries you can
update by:
 Apply headings or mark individual entries as directed above
 Click the References Tab in the Ribbon
 Click Update Table

Delete Table of Contents: To delete a table of contents:
 Click the References Tab on the Ribbon
 Click Table of Contents
 Click Remove Table of Contents
Creating Web Pages

Simple web pages can be created in Word using the Save as Feature. In a web document, you can insert pictures
and hyperlinks. To view the document as you would a web page:
 Click the Web Layout Button in the Document Views Group

Entering Text: To enter text into the document, simply begin typing. If you want to adjust the layout of the page
and text, you should use tables to format the page properly.
Hyperlinks: Hyperlinks, or links, allow the reader to click on text and go to another web site. To create a
hyperlink:
 Select the text that will be the link
 Click the Hyperlink Button on the Links Group
 Type in the web address, or URL, of the link
 Click OK
Saving Web Pages: To save a web page:

 Move the cursor over Save As
 Click Other Formats

 Under Save as Type, click Web Page
 Type in the name of the document (without spaces)
Lists
Lists allow you to format and organize text with numbers, bullets, or in an outline.
Bulleted and Numbered Lists: Bulleted lists have bullet points, numbered lists have numbers, and outline lists
combine numbers and letters depending on the organization of the list.
To add a list to existing text:
 Select the text you wish to make a list
 From the Paragraph Group on the Home Tab, Click the Bulleted or Numbered Lists button
To create a new list:

 Place your cursor where you want the list in the document
 Click the Bulleted or Numbered Lists button
 Begin typing
Nested Lists: A nested list is list with several levels of indented text. To create a nested list:
 Create your list following the directions above
 Click the Increase or Decrease Indent button

Formatting Lists: The bullet image and numbering format can be changed by using the Bullets or Numbering
dialog box.
 Select the entire list to change all the bullets or numbers, or
Place the cursor on one line within the list to change a single bullet
 Right click
 Click the arrow next to the bulleted or numbered list and choose a bullet or numbering style.
References and Citations

Word 2007 offers great tools for citing sources, creating a bibliography, and managing the sources. The first step
to creating a reference list and citations in a document is to choose the appropriate style that you will be using for
formatting the citations and references.
Style: To choose a publishing style:

 Click the drop down box next to Style in the Citations & Bibliography Group
 Choose the appropriate style.

Citations: To insert a citation in the text portion of your document:
 Click the Insert Citation Button on the Citations & Bibliography Group
 If this is a new source, click New Source
 If you have already created this source, it will in the drop down list and you can click on it
 If you are creating a New Source, choose the type of source (book, article, etc.)
 Complete the Create Source Form
 If you need additional fields, be sure to click the Show All Bibliography Fields check box
 Click OK
Placeholders
Placeholders can be utilized when there is a reference to be cited, but you do not have all of the information on
the source. To insert a Placeholder:
 Click Insert Citation
 Click Add New Placeholder

Manage Sources: Once you have completed a document you may need to add or delete sources, modify existing
sources, or complete the information for the placeholders. To Manage Sources:
 Click the Manage Sources Button on the Citations & Bibliography Group
 From this menu you can Add, Delete, and Edit Sources (note, you can preview the source in the bottom pane
of the window
Bibliography: To add a Bibliography to the document:

 Place the cursor in the document where you want the bibliography
 Click the Bibliography Button on the Citations & Bibliography Group
 Choose Insert Built-in Bibliography/Works Cited or Insert Bibliography

Insert Footnote: Some types of academic writing utilize footnotes. To insert a footnote:
 Click Insert Footnote (or Insert Endnote depending on your needs)
 Begin typing the footnote
Track Changes: Track Changes is a great feature of Word that allows you to see what changes have been made
to a document. The tools for track changes are found on the Reviewing tab of the Ribbon.
Begin Track Changes: To keep track of the changes you’ll be making to a document, you must click on Track
Changes icon.
To start Tracking Changes:
 Click Review Tab on the Ribbon
 Click Track Changes
 Make the changes to your document and you will see any changes you have made.
Document Views: There are four ways to view a document after you have tracked changes:
 Final Showing Markup: This shows the document with the changes displayed
 Final: This shows the changed document, without the changes displayed
 Original Showing Markup: The original document with the changes displayed
 Original: The original document without any changes.
To change the view, click the appropriate choice in the Tracking Group of the Review Tab on the Ribbon.

The Show Markup feature allows you to view different items (comments, formatting, etc.) and choose to view
different authors’ comments.
Accept or Reject Changes: When you view the changes in a document you can either choose to accept or reject
the changes. This allows you to review the document by each change to accept or reject each change.
Comments: The New Comments icon also lets you add comments to the document. To add a new comment, put
your cursor where you would like to add the comment and click on New Comment.
Web Resources
http://litwict.pbworks.com/f/ADVANCEDWord+2007.pdf
http://www.cctglobal.com/sample_courseware_downloads/computer_courses_01/international/sample_word_20
07_advanced_manual.pdf
Videos Resources
http://www.youtube.com/watch?v=v_vlhVWfqw8
http://www.youtube.com/watch?v=Y07aFiqI6qQ

EXERCISES
Exercise 4.1 [1]

Create a file and insert symbol of infinity, dollar, summation, pi and beta?
Exercise 4.2 [1]

Insert picture and change its brightness and contrast?
Exercise 4.3 [5]

Write a paragraph and check its Spelling and Grammar?
Exercise 4.4 [2]

Create a Table of Contents? Create a Page Break? And insert a Blank Page?
Exercise 4.5 [1]

What will the following key combination do: Ctrl+P and How do you print preview a document?

EXPERIMENT 5 – MS POWER POINT-I
Objective
To acquaint the students with different options available in MS PowerPoint application.
Procedure
It creates multimedia presentations to display information in a graphical format.

Getting started with PowerPoint 2007 you will notice that there are many similar features to previous
versions. You will also notice that there are many new features that you’ll be able to utilize. There are three
features that you should remember as you work within PowerPoint 2007: the Microsoft Office Button, the
Quick Access Toolbar, and the Ribbon. The function of these features will be more fully explored below
Presentations: A presentation is a collection of data and information that is to be delivered to a specific

audience. A PowerPoint presentation is a collection of electronic slides that can have text, pictures,
graphics, tables, sound and video. This collection can run automatically or can be controlled by a presenter.
Microsoft Office Button: The Microsoft Office Button performs many of the functions that were located
in the File menu of older versions of PowerPoint. This button allows you to create a new presentation, Open
an existing presentation, save and save as, print, send, or close.

Ribbon: The ribbon is the panel at the top portion of the document It has seven tabs: Home, Insert, Design,
Animations, Slide Show, Review and View. Each tab is divided into groups. The groups are logical
collections of features designed to perform function that you will utilize in developing or editing your
PowerPoint slides.
Commonly utilized features are displayed on the Ribbon. To view additional features within each group,
click the arrow at the bottom right corner of each group.
Home: Clipboard, Slides, Font, Paragraph, Drawing, and Editing

Insert: Tables, Illustrations, Links, Text, and Media Clips
Design: Page Setup, Themes, Background
Animations: Preview, Animations, Transition to this Slide
Slide Show: Start Slide Show, Set Up, Monitors
Review: Proofing, Comments, Protect
View: Presentation Views, Show/Hide, Zoom, Window, Macros
Quick Access Toolbar: The quick access toolbar is a customizable toolbar that contains commands that
you may want to use. You can place the quick access toolbar above or below the ribbon. To change the
location of the quick access toolbar, click on the arrow at the end of the toolbar and click Show Below the
Ribbon.

You can also add items to the quick access toolbar. Right click on any item in the Office Button or the
Ribbon and click Add to Quick Access Toolbar and a shortcut will be added.
Mini Toolbar: A new feature in Office 2007 is the Mini Toolbar. This is a floating toolbar that is displayed
when you select text or right-click text. It displays common formatting tools, such as Bold, Italics, Fonts,
Font Size and Font Color.
Navigation: Navigation through the slides can be accomplished through the Slide Navigation menu on the
left side of the screen. Also, an outline appears from materials that have been entered in the presentation. To
access the outline, click the outline tab.

Slide Views: Presentations can be viewed in a variety of manners. On the View tab, the Presentation Views
group allows you to view the slides as Normal, Slide Sorter, Notes Page, Slide Show, Slide Master, Handout
Master, and Notes Master.
Customize
PowerPoint 2007 offers a wide range of customizable options that allow you to make PowerPoint work the
best for you. To access these customizable options:
 Click PowerPoint Options include picture of OB menu.

Popular: These features allow you to personalize your work environment with the mini toolbar, color
schemes, personalize your user name and allow you to access the Live Preview feature. The Live Preview
feature allows you to preview the results of applying design and formatting changes without actually
applying it.
Proofing: This feature allows you personalize how word corrects your text. You can customize auto
correction settings and have word ignore certain words or errors in a document through the Custom
Dictionaries.

Save: This feature allows you personalize how your workbook is saved. You can specify how often you
want auto save to run and where you want the workbooks saved.
Advanced: This feature allows you to specify options for editing, copying, pasting, printing, displaying,
slide shows, and other general settings.

Customize: Customize allows you to add features to the Quick Access Toolbar. If there are tools that you
are utilizing frequently, you may want to add these to the Quick Access Toolbar.

Creating a Presentation
New Presentation: You can start a new presentation from a blank slide, a template, existing presentations,
or a Word outline. To create a new presentation from a blank slide:
 Click the Microsoft Office Button
 Click New
 Click Blank Presentation
To create a new presentation from a template:

 Click New
 Click Installed Templates or Browse through Microsoft Office Online Templates
 Click the template you choose

To create a new presentation from an existing presentation:
 Click the Microsoft Office Button
 Click New
 Click New from Existing
 Browse to and click the presentation
To create a new presentation from a Word outline:

 Click the slide where you would like the outline to begin
 Click New Slide on the Home tab
 Click Slides from Outline
 Browse and click the Word Document that contains the outline
Save a Presentation: When you save a presentation, you have two choices: Save or Save As.
To save a document:
 Click Save
You may need to use the Save As feature when you need to save a presentation under a different name or
to save it for earlier versions of PowerPoint. Remember that older versions of PowerPoint will not be able
to open PowerPoint 2007 presentation unless you save it as a PowerPoint 97-2003 Format. To use the Save
As feature:
 Click Save As
 Type in the name for the Presentation
 In the Save as Type box, choose Excel 97-2003 Presentation
Add Slides: There are several choices when you want to add a new slide to the presentation: Office Themes,
Duplicate Selected Slide, or Reuse Slides.
To create a new slide from Office Themes:
 Select the slide immediately BEFORE where you want the new slide
 Click the New Slide button on the Home tab

 Click the slide choice that fits your material
To create a slide as a duplicate of a slide in the presentation:

 Select the slide to duplicate
 Click Duplicate Selected Slides

To create a new slide from another presentation:
 Select the slide immediately BEFORE where you want the new slide
 Click Reuse Slides
 Click Browse
 Click Browse File
 Locate the slide show and click on the slide to import
Themes: Themes are design templates that can be applied to an entire presentation that allows for
consistency throughout the presentation. To add a theme to a presentation:
 Click the Design tab
 Choose one of the displayed Themes or click the Galleries button
To apply new colors to a theme:

 Click the Colors drop down arrow
 Choose a color set or click Create New Theme Colors

To change the background style of a theme
 Click the Background Styles button on the Design tab
Working with Content

Enter Text: To enter text:
 Select the slide where you want the text
 Click in a Textbox to add text

To add a text box:
 Select the slide where you want to place the text box
 On the Insert tab, click Text Box
 Click on the slide and drag the cursor to expand the text box
 Type in the text
Select Text: To select the text:

 Highlight the text
Copy and Paste: To copy and paste data:

 Select the item(s) that you wish to copy
 On the Clipboard Group of the Home Tab, click Copy
 Select the item(s) where you would like to copy the data
 On the Clipboard Group of the Home Tab, click Paste

Cut and Paste: To cut and paste data:
 Select the item(s) that you wish to copy
 On the Clipboard Group of the Home Tab, click Cut
 Select the items(s) where you would like to copy the data
 On the Clipboard Group of the Home Tab, click Paste
Undo and Redo: To undo or redo your most recent actions:

 On the Quick Access Toolbar
 Click Undo or Redo
Spell Check: To check the spelling in a presentation:

 Click the Review tab
 Click the Spelling button
Formatting Text
Change Font Typeface and Size: To change the font typeface:
 Click the arrow next to the font name and choose a font.
 Remember that you can preview how the new font will look by highlighting the text, and hovering over
the new font typeface.

To change the font size:
 Click the arrow next to the font size and choose the appropriate size, or
 Click the increase or decrease font size buttons.
Font Styles and Effects

Font styles are predefined formatting options that are used to emphasize text. They include: Bold, Italic,
and Underline. To add these to text:
 Select the text and click the Font Styles included on the Font group of the Home tab or
 Select the text and right click to display the font tools
Change Text Color: To change the text color:

 Select the text and click the Colors button included on the Font Group of the Ribbon, or
 Highlight the text and right click and choose the colors tool.
 Select the color by clicking the down arrow next to the font color button.

WordArt: WordArt are styles that can be applied to text to create a visual effect. To apply Word Art:
 Select the text
 Click the Insert tab
 Click the WordArt button
 Choose the WordArt
To modify the styles of WordArt

 Select the WordArt
 Click the Format tab for the Drawing Tools
 Click the WordArt Fill button, the WordArt Outline button, or the Text Effects button

Change Paragraph Alignment
The paragraph alignment allows you to set how you want text to appear. To change the alignment:
 Choose the appropriate button for alignment on the Paragraph Group.
 Align Left: the text is aligned with your left margin
 Center: The text is centered within your margins
 Align Right: Aligns text with the right margin
 Justify: Aligns text to both the left and right margins.
Indent Paragraphs: To indent paragraphs, you can do the following:

 Click the Indent buttons to control the indent.
 Click the Indent button repeated times to increase the size of the indent.
Text Direction: To change the text direction:

 Select the text
 Click the Text Direction button on the Home tab
 Click the selection
Adding Content
Resize a Textbox: To resize a textbox:
 Click on the textbox
 Click the corner of the box and drag the cursor to the desired size
Bulleted and Numbered Lists: Bulleted lists have bullet points, numbered lists have numbers, and outline
lists combine numbers and letters depending on the organization of the list.
To add a list to existing text:
 Select the text you wish to make a list
To create a new list:

 Place your cursor where you want the list in the document
 Begin typing
Nested Lists
A nested list is list with several levels of indented text. To create a nested list:
 Create your list following the directions above
 Click the Increase or Decrease Indent button
Formatting Lists
The bullet image and numbering format can be changed by using the Bullets or Numbering dialog box.
 Select the entire list to change all the bullets or numbers, or Place the cursor on one line within the list
to change a single bullet.
 Click the arrow next to the bulleted or numbered list and choose a bullet or numbering style.
Adding Video
Video clips can be added to the presentation. To add a video clip:
 Click the Movie button on the Insert tab
 Choose Movie from File or Movie from Clip Organizer

To edit the video options:
 Click the movie icon
 Click the Format tab
Adding Audio
Audio clips can be added to the presentation. To add an audio clip:
 Click the Audio button on the Insert tab
 Choose Sound from File, Sound from Clip Organizer, Play CD Audio Track, or Record Sound
To edit the audio options:

 Click the audio icon
Web Resources
http://www.umm.ac.id/files/file/FileDownload/Panduan_Power_Point_2007.pdf
http://aristwn.staff.stainsalatiga.ac.id/wp-content/uploads/sites/3/2013/06/Microsoft_PowerPoint-2007-
instructions.pdf
Videos Resources
http://www.youtube.com/watch?v=RZtjKiR0nYU
http://www.youtube.com/watch?v=KeYYCBqHg4w

EXERCISES
Exercise 5.1 [2]
You create a new presentation of 5 to 7 slides.
Exercise 5.2 [2]

Change Spacing between Paragraphs and Lines (single lines), and create a hyperlink?
Exercise 5.3 [1]

Change Paragraph Alignment, Left, Centre or Right?
Exercise 5.4 [2]

Change the font size of paragraph at 12 font size, style Time New Roman, font effect in to italic, and change text
color into red?
Exercise 5.5 [3]

To add a video clip.
How do you build a slide in a blank presentation?

EXPERIMENT 6 – MS POWER POINT-II
Objective
To acquaint the students with different options available in MS PowerPoint application.
Procedure
It creates multimedia presentations to display information in a graphical format.
Adding Picture: To add a picture:

 Click the Insert Tab
 Click the Picture Button
 Browse to the picture from your files
 Click the name of the picture
 Click insert
 To move the graphic, click it and drag it to where you want it
Adding Clip Art: To add Clip Art:

 Click the Clip Art Button
 Search for the clip art using the search Clip Art dialog box
 Click the clip art
78 Fundamental of ICT – MS Power point-II

Editing Pictures and Clip Art: When you add a graphic to the presentation, an additional Tab appears on the
Ribbon. The Format Tab allows you to format the pictures and graphics. This tab has four groups:
Adjust: Controls the picture brightness, contrast, and colors
Picture Style: Allows you to place a frame or border around the picture and add effects
Arrange: Controls the alignment and rotation of the picture
Size: Cropping and size of graphic
Adding a Shape: To add shapes:

 Click the Shapes Button
 Click the shape you choose

 Click the Slide
 Drag the cursor to expand the Shape
To format the shapes:

 Click the Shape
Adding SmartArt: SmartArt is a feature in Office 2007 that allows you to choose from a variety of graphics,
including flow charts, lists, cycles, and processes. To add SmartArt:
 Click the SmartArt Button
 Click the SmartArt you choose
 Click the SmartArt

 Drag it to the desired location in the slide

To format the SmartArt:
 Click the SmartArt
 Click either the Design or the Format tab
 Click the SmartArt to add text and pictures.
Adding a Photo Album: The photo album feature is new in PowerPoint 2007 and allows you to easily create a
photo album to share pictures. To create a photo album:
 Click the Photo Album button on the Insert tab
 Click New Photo Album
 Click File/Disk to add pictures to the photo album
 Move the pictures up and down in the order of the album but clicking the up/down arrows
Tables
Tables are used to display data in a table format.
Create a Table: To create a table:
 Place the cursor on the page where you want the new table
 Click the Tables Button on the Tables Group. You can create a table one of four ways:
 Highlight the number of row and columns
 Click Insert Table and enter the number of rows and columns
 Click the Draw Table, create your table by clicking and entering the rows and columns
 Click Excel Spreadsheet and enter data

Enter Data in a Table: Place the cursor in the cell where you wish to enter the information. Begin typing.
Modify the Table Structure and Format a Table: To modify the structure of a table:
 Click the table and notice that you have two new tabs on the Ribbon: Design and Layout. These pertain to
the table design and layout.
On the Design Tab, you can choose:
 Table Style Options
 Table Styles
 Draw Borders
To format a table, click the table and then click the Layout Tab on the Ribbon. This Layout tab allows you to:
 View Gridlines and Properties (from the Table Group)
 Insert Rows and Columns (from the Rows & Columns Group)
 Delete the Table, Rows and/or Columns (from the Rows & Columns Group)
 Merge or Split Cells (from the Merge Group)
 Increase and decrease cell size (Cell Size Group)
 Align text within the cells and change text directions (Alignment Group)

Insert a Table from Word or Excel
 Open the Word document or Excel worksheet
 Select the chart
 Click Copy on the Home tab
 Go to the PowerPoint document where you want the chart located
 Click Paste on the Home tab
Charts
Charts allow you to present information contained in the worksheet in a graphic format. PowerPoint offers many
types of charts including: Column, Line, Pie, Bar, Area, Scatter and more. To view the charts available click the
Insert Tab on the Ribbon.
Create a Chart: To create a chart:

 Click the Insert tab on the ribbon
 Click the type of Chart you want to create
 Insert the Data and Labels

Edit Chart Data: To edit chart data:
 Click on the chart
 Click Edit Data on the Design tab
 Edit data in the spreadsheet
Modify a Chart: Once you have created a chart you can do several things to modify the chart.
To move the chart:
 Click the Chart and Drag it another location on the same slide, or

 Copy it to another slide
 Choose the desired location and click Paste
To modify the chart size:

 Click the Chart
 Click on any of the corners and drop and drag to resize
To modify the labels and titles:

 Click the chart
 Click the Layout tab
 Choose the appropriate label to change

Chart Tools: The Chart Tools appear on the Ribbon when you click on the chart. The tools are located on three
tabs: Design, Layout, and Format.
Within the Design tab you can control the chart type, layout, styles, and location.
Within the Layout tab you can control the insertion of pictures, textboxes, and shapes, labels, backgrounds, and
data analysis.
Within the Format tab you can adjust the Fill Colors and Word Styles.
Paste a Chart from Excel

 Open the Excel worksheet
 Go to the PowerPoint document where you want the chart located
Slide Effects
Slide Transitions: Transitions are effects that are in place when you switch from one slide to the next. To add
slide transitions:
 Select the slide that you want to transition
 Click the Animations tab
 Choose the appropriate animation or click the Transition dialog box

To adjust slide transitions:
 Add sound by clicking the arrow next to Transition Sound
 Modify the transition speed by clicking the arrow next to Transition Speed
To apply the transition to all slides:

 Click the Apply to All button on the Animations tab
To select how to advance a slide:

 Choose to Advance on Mouse Click, or
 Automatically after a set number of seconds

Slide Animation: Slide animation effects are predefined special effects that you can add to objects on a slide. To
apply an animation effect:
 Select the object
 Click the Animations tab on the Ribbon
 Click Custom Animation
 Click Add Effect
 Choose the appropriate effect
Animation Preview: To preview the animation on a slide:

 Click the Preview button on the Animations tab
Slide Show Options: The Slide Show tab of the ribbon contains many options for the slide show. These options
include:
 Preview the slide show from the beginning
 Preview the slide show from the current slide
 Set up Slide Show
Set Up Slide Show: This option allows you to set preferences for how the slide show will be presented. The
options include:
 Whether the show will run automatically or will be presented by a speaker
 The looping options
 Narration options
 Monitor resolutions

Record Narration: When you want to record narration for the slides:
 Click the Record Narration button
 Click Set Microphone Level to check the levels of audio input
 Click OK to record the narration
Rehearse Timings: Use Rehearsed Timings to rehearse the timings of slide with audio.
 Click the Rehearse Timings button
 Practice speaking and advance the slides as you would in the presentation
 When you have completed this click through the end of the slide
 Choose whether or not to keep this timing or to retry

Printing
Create Speaker Notes: Speaker Notes can be added to allow you to create notes for each slide. To add speaker
notes:
 Select the slide
 Click View
 Click Note Pages
 Click the Click to add Notes section of the screen
 Type in the Notes for that slide
Print a Presentation: There are many options for printing a presentation. They are:
 Slides: These are slides that you would see if you were showing the presentation, one slide per page
 Handouts: 1, 2, 3, 4, 6 or 9 per page, this option allows for more slides per page
 Notes Page: This includes the slides and the speaker notes
 Outline View: This will print the outline of the presentation
To access the print options:

 Click Print
 In the Print Dialog Box, click the arrow next to Print what
 Choose the format and click OK to print

To print preview:
 Place the cursor over Print
 Click Print Preview
 Click the arrow next to Print What to change print options
 To print from Print Preview, click Print
To Exit Print Preview:

 Click the Close Print Preview button

Package a Presentation: There are times when you want to package a presentation with all of the additional files
attached as well. To package a presentation for CD:
 Click Publish
 Click Package for CD
 Type a name for the CD
 Click Copy to CD or Copy to Folder
Web Resources
http://www.northbrunswicklibrary.org/ADVANCED%2013%20Powerpoint%202007.pdf
http://www.drexelmed.edu/documents/facaffairs/advanced%20powerpointhandout.pdf
Videos Resources
http://www.youtube.com/watch?v=BIfQgyE_-JM
http://www.youtube.com/watch?v=tnGAqNrT_ag

EXERCISES
Exercise 6.1 [2]
You create a new presentation of 5 to 7 slides and add picture and add clip art.
Exercise 6.2 [2]

Add different shapes and add a photo album?
Exercise 6.3 [2]

Create table on MS Word and Insert it in to MS Power point.
Exercise 6.4 [1
Using above table create a Charts.
Exercise 6.5 [3]

How do you apply a transition to a slide?
How do you print presentation?

EXPERIMENT 7 – MS EXCEL-I
Objective
To acquaint the students with different options available in MS Excel application.
Procedure
It lets you develop spreadsheets that display data in various tabular and visual formats.
Getting started with Excel 2007 you will notice that there are many similar features to previous versions. You
will also notice that there are many new features that you’ll be able to utilize. There are three features that you
should remember as you work within Excel 2007: the Microsoft Office Button, the Quick Access Toolbar, and
the Ribbon. The function of these features will be more fully explored below.
Spreadsheets: A spreadsheet is an electronic document that stores various types of data. There are vertical
columns and horizontal rows. A cell is where the column and row intersect. A cell can contain data and can be
used in calculations of data within the spreadsheet. An Excel spreadsheet can contain workbooks and
worksheets. The workbook is the holder for related worksheets.
Microsoft Office Button: The Microsoft Office Button performs many of the functions that were located in the
File menu of older versions of Excel. This button allows you to create a new workbook, Open an existing
workbook, save and save as, print, send, or close.
94 Fundamental of ICT – MS Excel-I

Ribbon: The ribbon is the panel at the top portion of the document It has seven tabs: Home, Insert, Page
Layouts, Formulas, Data, Review, and View. Each tab is divided into groups. The groups are logical collections
of features designed to perform function that you will utilize in developing or editing your Excel spreadsheets.
Commonly utilized features are displayed on the Ribbon. To view additional features within each group, click
the arrow at the bottom right corner of each group.
Home: Clipboard, Fonts, Alignment, Number, Styles, Cells, Editing

Insert: Tables, Illustrations, Charts, Links, Text
Page Layouts: Themes, Page Setup, Scale to Fit, Sheet Options, Arrange
Formulas: Function Library, Defined Names, Formula Auditing, Calculation
Data: Get External Data, Connections, Sort & Filter, Data Tools, Outline
Review: Proofing, Comments, Changes
View: Workbook Views, Show/Hide, Zoom, Window, Macros
Quick Access Toolbar: The quick access toolbar is a customizable toolbar that contains commands that you
may want to use. You can place the quick access toolbar above or below the ribbon. To change the location of
the quick access toolbar, click on the arrow at the end of the toolbar and click Show Below the Ribbon.

You can also add items to the quick access toolbar. Right click on any item in the Office Button or the Ribbon
and click Add to Quick Access Toolbar and a shortcut will be added.
Mini Toolbar: A new feature in Office 2007 is the Mini Toolbar. This is a floating toolbar that is displayed
when you select text or right-click text. It displays common formatting tools, such as Bold, Italics, Fonts, Font
Size and Font Color.
Customize Excel: Excel 2007 offers a wide range of customizable options that allow you to make Excel work
the best for you. To access these customizable options:
 Click Excel Options
Popular: These features allow you to personalize your work environment with the mini toolbar, color schemes,
default options for new workbooks, customize sort and fill sequences user name and allow you to access the
Live Preview feature. The Live Preview feature allows you to preview the results of applying design and
formatting changes without actually applying it.

Formulas: This feature allows you to modify calculation options, working with formulas, error checking, and
error checking rules.

Proofing: This feature allows you personalize how word corrects and formats your text. You can customize auto
correction settings and have word ignore certain words or errors in a document through the Custom Dictionaries.
Save: This feature allows you personalize how your workbook is saved. You can specify how often you want
auto save to run and where you want the workbooks saved.
Advanced: This feature allows you to specify options for editing, copying, pasting, printing, displaying,
formulas, calculations, and other general settings.
Customize: Customize allows you to add features to the Quick Access Toolbar. If there are tools that you are
utilizing frequently, you may want to add these to the Quick Access Toolbar.

Working with a Workbook
Create a Workbook: To create a new Workbook:
 Click the Microsoft Office Toolbar
 Click New
 Choose Blank Document

If you want to create a new document from a template, explore the templates and choose one that fits your needs.
Save a Workbook: When you save a workbook, you have two choices: Save or Save As.
To save a document:
 Click Save
You may need to use the Save As feature when you need to save a workbook under a different name or to save
it for earlier versions of Excel. Remember that older versions of Excel will not be able to open an Excel 2007
worksheet unless you save it as an Excel 97-2003 Format. To use the Save As feature:

 Click Save As
 Type in the name for the Workbook
 In the Save as Type box, choose Excel 97-2003 Workbook
Open a Workbook: To open an existing workbook:

 Click Open
 Browse to the workbook
 Click the title of the workbook
 Click Open
Entering Data: There are different ways to enter data in Excel: in an active cell or in the formula bar.
To enter data in an active cell:
 Click in the cell where you want the data
 Begin typing

To enter data into the formula bar
 Click the cell where you would like the data
 Place the cursor in the Formula Bar
 Type in the data
Manipulating Data
Excel allows you to move, copy, and paste cells and cell content through cutting and pasting and copying and
pasting.
Select Data: To select a cell or data to be copied or cut:
 Click the cell
 Click and drag the cursor to select many cells in a range
Select a Row or Column: To select a row or column click on the row or column header.

Copy and Paste: To copy and paste data:
 Select the cell(s) that you wish to copy
 On the Clipboard group of the Home tab, click Copy
 Select the cell(s) where you would like to copy the data
 On the Clipboard group of the Home tab, click Paste
Cut and Paste: To cut and paste data:

 Select the cell(s) that you wish to copy
 On the Clipboard group of the Home tab, click Cut
 Select the cell(s) where you would like to copy the data
 On the Clipboard group of the Home tab, click Paste
Undo and Redo: To undo or redo your most recent actions:

 On the Quick Access Toolbar
 Click Undo or Redo

Auto Fill: The Auto Fill feature fills cell data or series of data in a worksheet into a selected range of cells. If
you want the same data copied into the other cells, you only need to complete one cell. If you want to have a
series of data (for example, days of the week) fill in the first two cells in the series and then use the auto fill
feature. To use the Auto Fill feature:
 Click the Fill Handle
 Drag the Fill Handle to complete the cells
Modifying a Worksheet
Insert Cells, Rows, and Columns: To insert cells, rows, and columns in Excel:
 Place the cursor in the row below where you want the new row, or in the column to the left of where you
want the new column
 Click the Insert button on the Cells group of the Home tab
 Click the appropriate choice: Cell, Row, or Column
Delete Cells, Rows and Columns: To delete cells, rows, and columns:
 Place the cursor in the cell, row, or column that you want to delete
 Click the Delete button on the Cells group of the Home tab
 Click the appropriate choice: Cell, Row, or Column
Find and Replace: To find data or find and replace data:

 Click the Find & Select button on the Editing group of the Home tab

 Choose Find or Replace
 Complete the Find What text box
 Click on Options for more search options
Go To Command: The Go To command takes you to a specific cell either by cell reference (the Column Letter
and the Row Number) or cell name.
 Click the Find & Select button on the Editing group of the Home tab
 Click Go To
Spell Check: To check the spelling:

 On the Review tab click the Spelling button

Performing Calculations
Excel Formulas: A formula is a set of mathematical instructions that can be used in Excel to perform
calculations. Formals are started in the formula box with an = sign.
There are many elements to and excel formula.

References: The cell or range of cells that you want to use in your calculation
Operators: Symbols (+, -, *, /, etc.) that specify the calculation to be performed
Constants: Numbers or text values that do not change
Functions: Predefined formulas in Excel
To create a basic formula in Excel:
 Select the cell for the formula
 Type = (the equal sign) and the formula
 Click Enter
Calculate with Functions: A function is a built in formula in Excel. A function has a name and arguments (the
mathematical function) in parentheses. Common functions in Excel:
Sum: Adds all cells in the argument
Average: Calculates the average of the cells in the argument
Min: Finds the minimum value
Max: Finds the maximum value
Count: Finds the number of cells that contain a numerical value within a range of the argument
To calculate a function:
 Click the cell where you want the function applied
 Click the Insert Function button
 Choose the function
 Click OK

 Complete the Number 1 box with the first cell in the range that you want calculated
 Complete the Number 2 box with the last cell in the range that you want calculated
Function Library: The function library is a large group of functions on the Formula Tab of the Ribbon. These
functions include:
AutoSum: Easily calculates the sum of a range
Recently Used: All recently used functions
Financial: Accrued interest, cash flow return rates and additional financial functions
Logical: And, If, True, False, etc.
Text: Text based functions
Date & Time: Functions calculated on date and time
Math & Trig: Mathematical Functions
Relative, Absolute and Mixed References: Calling cells by just their column and row labels (such as "A1") is
called relative referencing. When a formula contains relative referencing and it is copied from one cell to
another, Excel does not create an exact copy of the formula. It will change cell addresses relative to the row and
column they are moved to. For example, if a simple addition formula in cell C1 "=(A1+B1)" is copied to cell
C2, the formula would change to "=(A2+B2)" to reflect the new row. To prevent this change, cells must be called
by absolute referencing and this is accomplished by placing dollar signs "$" within the cell addresses in the
formula. Continuing the previous example, the formula in cell C1 would read "=($A$1+$B$1)" if the value of
cell C2 should be the sum of cells A1 and B1. Both the column and row of both cells are absolute and will not

change when copied. Mixed referencing can also be used where only the row OR column fixed. For example,
in the formula "=(A$1+$B2)", the row of cell A1 is fixed and the column of cell B2 is fixed.
Linking Worksheets: You may want to use the value from a cell in another worksheet within the same
workbook in a formula. For example, the value of cell A1 in the current worksheet and cell A2 in the second
worksheet can be added using the format "sheetname!celladdress". The formula for this example would be
"=A1+Sheet2!A2" where the value of cell A1 in the current worksheet is added to the value of cell A2 in the
worksheet named "Sheet2".
Macros
Macros are advanced features that can speed up editing or formatting you may perform often in an Excel
worksheet. They record sequences of menu selections that you choose so that a series of actions can be completed
in one step.
Recording a Macro: To record a Macro:
 Click the View tab on the Ribbon
 Click Macros
 Click Record Macro
 Enter a name (without spaces)
 Enter a Shortcut Key
 Enter a Description
 Perform the Macro

 Click Marcos
 Click Stop Recording
Running a Macro
To run a Macro from the Keyboard shortcut, simply press the keys that you have programmed to run the
Macro. Or you can view all macros and run by:

 Click Macros
 Click View Macros
 Choose the Macro and click Run
Web Resources
http://www.fgcu.edu/support/office2007/excel/gettingstarted.asp
http://depts.hre.wvu.edu/tltc/excel_tutorial.pdf
Videos Resources
http://www.youtube.com/watch?v=NA0GeNptJIA
http://www.youtube.com/watch?v=X3jB4wncJp4

EXERCISES
Exercise 7.1 [2]
How do you create a spreadsheet in Microsoft Excel from scratch?
Exercise 7.2 [1]

How do you save a spreadsheet in Microsoft Excel?
Exercise 7.3 [1]

How do you format cells in a spreadsheet?
Exercise 7.4 [2
create a spread sheet with the following entries:
 B2=CHIKEN INN  B5=3

 A4=FOOD ITEM  B6=1
 A5=PORTION CHIPS  B7=1
 A6=SADZA AND STEW  B8=2
 A7=RICE AND CHICKEN  B9=3
 A8=HAMBURGER  C4=UNIT COST
 A9=SOFT DRINK  C5=$135.00
 C10=SUB TOTAL  C6=$180.00
 C11=SUB TAX@15%  C7=$200.00
 C12=TOTAL COST  C8=$170.50
 B4=QUANTITY  C9=$6500
 D4=CAST
Exercise 7.5 [4]

i. Make B2 bold, underlined and size 16.
ii. Make all headings, i.e. A4--D4, bold.
iii. Put borders on all entries of the sheet.
iv. Save documents as Qn2data and print it.

EXPERIMENT 8 – MS EXCEL-II
Objective
To acquaint the students with different options available in MS Excel application.
Procedure
It lets you develop spreadsheets that display data in various tabular and visual formats.
Sort and Filter

Sorting and Filtering allow you to manipulate data in a worksheet based on given set of criteria.
Basic Sorts: To execute a basic descending or ascending sort based on one column:
 Highlight the cells that will be sorted
 Click the Sort & Filter button on the Home tab
 Click the Sort Ascending (A-Z) button or Sort Descending (Z-A) button
Custom Sorts: To sort on the basis of more than one column:

 Click the Sort & Filter button on the Home tab
 Choose which column you want to sort by first
 Click Add Level
 Choose the next column you want to sort
 Click OK
111 Fundamental of ICT – MS Excel-II

Filtering: Filtering allows you to display only data that meets certain criteria. To filter:
 Click the column or columns that contain the data you wish to filter
 On the Home tab, click on Sort & Filter
 Click Filter button
 Click the Arrow at the bottom of the first cell
 Click the Text Filter
 Click the Words you wish to Filter
 To clear the filter click the Sort & Filter button

 Click Clear

Graphics
Adding a Picture: To add a picture:
 Click the Picture button
 Browse to the picture from your files
 Click the name of the picture
 Click Insert
Adding Clip Art: To add Clip Art:

 Click the Clip Art button
 Search for the clip art using the search Clip Art dialog box
 Click the clip art

Editing Pictures and Clip Art: When you add a graphic to the worksheet, an additional tab appears on the
Ribbon. The Format tab allows you to format the pictures and graphics.
This tab has four groups:
 Adjust: Controls the picture brightness, contrast, and colors
 Picture Style: Allows you to place a frame or border around the picture and add effects
 Arrange: Controls the alignment and rotation of the picture
 Size: Cropping and size of graphic
Adding Shapes: To add Shape:

 Click the Shapes button
 Click the shape you choose

 Click the Worksheet
 Drag the cursor to expand the Shape
To format the shapes:

 Click the Shape
Adding SmartArt: SmartArt is a feature in Office 2007 that allows you to choose from a variety of graphics,
including flow charts, lists, cycles, and processes. To add SmartArt:
 Click the SmartArt button
 Click the SmartArt you choose
 Select the Smart Art

 Drag it to the desired location in the worksheet
To format the SmartArt:

 Select the SmartArt
 Click either the Design or the Format tab
 Click the SmartArt to add text and pictures.

Charts
Charts allow you to present information contained in the worksheet in a graphic format. Excel offers many types
of charts including: Column, Line, Pie, Bar, Area, Scatter and more. To view the charts available click the Insert
Tab on the Ribbon.
Create a Chart: To create a chart:
 Select the cells that contain the data you want to use in the chart
 Click the Insert tab on the Ribbon
 Click the type of Chart you want to create
Modify a Chart: Once you have created a chart you can do several things to modify the chart.
To move the chart:
 Click the Chart and Drag it another location on the same worksheet, or
 Click the Move Chart button on the Design tab
 Choose the desired location (either a new sheet or a current sheet in the workbook)
To change the data included in the chart:

 Click the Chart
 Click the Select Data button on the Design tab

To reverse which data are displayed in the rows and columns:
 Click the Chart
 Click the Switch Row/Column button on the Design tab
To modify the labels and titles:

 Click the Chart
 On the Layout tab, click the Chart Title or the Data Labels button
 Change the Title and click Enter
Chart Tools: The Chart Tools appear on the Ribbon when you click on the chart. The tools are located on three
tabs: Design, Layout, and Format.
Within the Design tab you can control the chart type, layout, styles, and location.

Within the Layout tab you can control inserting pictures, shapes and text boxes, labels, axes, background, and
analysis.
Within the Format tab you can modify shape styles, word styles and size of the chart.
Copy a Chart to Word

 Go to the Word document where you want the chart located
Formatting a Worksheet
 Convert Text to Columns
 Modify Fonts
 Format Cells Dialog Box
 Add Borders and Colors to Cells
 Change Column Width and Row Height
 Hide or Unhide Rows and Columns
 Merge Cells
 Align Cell Contents

Developing a Workbook
Format Worksheet Tab: You can rename a worksheet or change the color of the tabs to meet your needs.
To rename a worksheet:
 Open the sheet to be renamed
 Click the Format button on the Home tab
 Click Rename sheet
 Type in a new name
 Press Enter
To change the color of a worksheet tab:

 Open the sheet to be renamed
 Click the Format button on the Home tab
 Click Tab Color
 Click the color

Reposition Worksheets in a Workbook: To move worksheets in a workbook:
 Open the workbook that contains the sheets you want to rearrange
 Click and hold the worksheet tab that will be moved until an arrow appears in the left corner of the sheet
 Drag the worksheet to the desired location
Insert and Delete Worksheets: To insert a worksheet

 Open the workbook
 Click the Insert button on the Cells group of the Home tab
 Click Insert Sheet
To delete a worksheet
 Open the workbook
 Click the Delete button on the Cells group of the Home tab
 Click Delete Sheet

Copy and Paste Worksheets: To copy and paste a worksheet:
 Click the tab of the worksheet to be copied
 Right click and choose Move or Copy
 Choose the desired position of the sheet
 Click the check box next to Create a Copy
 Click OK
Page Properties and Printing
Set Print Titles: The print titles function allows you to repeat the column and row headings at the beginning of
each new page to make reading a multiple page sheet easier to read when printed. To Print Titles:
 Click the Page Layout tab on the Ribbon
 Click the Print Titles button
 In the Print Titles section, click the box to select the rows/columns to be repeated
 Select the row or column
 Click the Select Row/Column Button
 Click OK

Create a Header or Footer: To create a header or footer:
 Click the Header & Footer button on the Insert tab
 This will display the Header & Footer Design Tools Tab
 To switch between the Header and Footer, click the Go to Header or Go to Footer button
 To insert text, enter the text in the header or footer

 To enter pre-programmed data such as page numbers, date, time, file name or sheet name, click the appropriate
button
 To change the location of data, click the desired cell

Set Page Margins: To set the page margins:
 Click the Margins button on the Page Layout tab
 Select one of the give choices, or
 Click Custom Margins

 Complete the boxes to set margins
 Click Ok
Change Page Orientation: To change the page orientation from portrait to landscape:
 Click the Orientation button on the Page Layout tab
 Choose Portrait or Landscape

Set Page Breaks: You can manually set up page breaks in a worksheet for ease of reading when the sheet is
printed. To set a page break:
 Click the Breaks button on the Page Layout tab
 Click Insert Page Break
Print a Range: There may be times when you only want to print a portion of a worksheet. This is easily done
through the Print Range function. To print a range:
 Select the area to be printed
 Click the Print Area button on the Page Layout tab
 Click Select Print Area
Customize the Layout
Split a Worksheet: You can split a worksheet into multiple resizable panes for easier viewing of parts of a
worksheet. To split a worksheet:
 Select any cell in center of the worksheet you want to split
 Click the Split button on the View tab
 Notice the split in the screen, you can manipulate each part separately

Feeze Rows and Columns: You can select a particular portion of a worksheet to stay static while you work on
other parts of the sheet. This is accomplished through the Freeze Rows and Columns Function. To Freeze a row
or column:
 Click the Freeze Panes button on the View tab
 Either select a section to be frozen or click the defaults of top row or left column
 To unfreeze, click the Freeze Panes button
 Click Unfreeze
Hide Worksheets
To hide a worksheet:
 Select the tab of the sheet you wish to hide
 Right-click on the tab
 Click Hide
To unhide a worksheet:
 Right-click on any worksheet tab
 Click Unhide
 Choose the worksheet to unhide

Web Resources
http://www.fgcu.edu/support/office2007/excel/
http://www.uoguelph.ca/~jizhu/CIS1000DE/tutorials/Excel2007.pdf
Videos Resources
http://www.youtube.com/watch?v=yEXHkwX5E-c
http://www.youtube.com/watch?v=v4N3YkqRsTI

EXERCISES
Exercise 8.1 [2]
Create a spread sheet with the following entries:
 B2=CHIKEN INN
 A4=FOOD ITEM  B5=3
 A5=PORTION CHIPS  B6=1
 A6=SADZA AND STEW  B7=1
 A7=RICE AND CHICKEN  B8=2
 A8=HAMBURGER  B9=3
 A9=SOFT DRINK  C4=UNIT COST
 C10=SUB TOTAL  C5=$135.00
 C11=SUB TAX@15%  C6=$180.00
 C12=TOTAL COST  C7=$200.00
 B4=QUANTITY  C8=$170.50
 C9=$6500
 D4=CAST
Exercise 8.2 [2]
Input the formula for the cost price of each item D5—D9.?
Exercise 8.3 [3]

Input the formula for the calculated amount for subtotals, sales tax and total cost in D10—D12.?
Exercise 8.4 [3]

create the pie Graph for the Food item and Quantity columns. The pie chart should have an appropriate title, legend, and
each portion should show the percentage occupied by each item.

EXPERIMENT 9 – MS OUTLOOK
Objective
To acquaint the students with different options available in MS Outlook application.
Procedure
It lets the user send and Receive email to and from other mail servers.
Basic Email: Begin by double‐clicking on Outlook 2007 icon in Start/Programs/Microsoft Office or the Desktop.
The opening screen of basic email services of Outlook 2007 will appear.
To read an Email: On the left is the email folder pane. By clicking on the Inbox, you can see your newly arrived
email as well as that email which you have not yet moved to a folder or deleted. Note that the Inbox has been
selected and is listed in the second pane. In the Inbox, the message “Email Demo” from Willis Stephen M. has
been selected and the message is displayed the third pane. On the right is a To Do Bar which we will address
presently. You can select the message in the Inbox and see it displayed in a new window:
128 Fundamental of ICT – Decision Statement in C++

The message has an attachment. If the attachment is selected, it will be displayed in a new window.
To create an Email
A new window will open. Note the various Tool Bar and selection buttons

To create an email, fill in the address and subject fields and enter your text. Perform any editing functions such
as text formatting or spell checking, attach a file in you wish, and then click on the “Send” button and the email
is sent.
The Address Book: The address book contains the names and possibly other information about everyone in the
organization whose has an email address. It is arranged alphabetically by last name. To use the address book,
open Outlook and select New.
The new message window will open. First, lets customize the appearance of the Message format by select Show
Bcc and the Show From buttons.

The Address Book window will open:
There are two types of entries: Users and Distribution Groups (groups of users) To select the message recipient,
type the first few letters of their last name into the Search field and highlight the person or mailbox to whom you
wish to send the message. Select the to button (or the Cc or Bcc buttons, if desired) and then select OK. The
process can be repeated for multiple recipients.
Using the Calendar After opening Outlook 2007, select the Calendar bar on the left hand side. The Calendar will
open:

Web Resources
http://tamhsc.edu/information-technology/tutorials/outlook2007-tutorial/Outlook%202007%20Tutorial.pdf
Videos Resources
http://www.youtube.com/watch?v=DHsYtnGfO2I


Computer Laboratory Manual: Fundamental of ICT Lab Manual

Uploaded by

Copyright:

Available Formats

Computer Laboratory Manual: Fundamental of ICT Lab Manual

Uploaded by

Document Information

Original Description:

Original Title

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

Computer Laboratory Manual: Fundamental of ICT Lab Manual

Uploaded by

Copyright:

Available Formats

COMPUTER LABORATORY MANUAL

DEPARTMENT OF COMPUTER SOFTWARE ENGINEERING

1 Fundamental of ICT Lab Manual

2 Fundamental of ICT Lab Manual

Exp Date Experiment Title Max. Marks Instructor

3 Fundamental of ICT Lab Manual

4 Fundamental of ICT Lab Manual

Introduction to Computer Components

Microprocessor: A microprocessor incorporates the functions of a computer's

Random-access memory (RAM): Random-access memory (RAM) is a form of

RAM TYPE PINS WIDTH USAGE

Data Cables: Serial ATA (Advance Technology Attachment)(SATA) is a computer bus

Computer Network Overview:

6 Fundamental of ICT– Introduction to Computer and Campus Networking

7 Fundamental of ICT– Introduction to Computer and Campus Networking

Exercise 1.2 [6]

8 Fundamental of ICT– Introduction to Computer and Campus Networking

9 Fundamental of ICT – Introduction to Ms Office

10 Fundamental of ICT – Introduction to Ms Office

Exercise 2.2 [5]

11 Fundamental of ICT – Introduction to Ms Office

Introduction MS Office Interface

The Microsoft Office Button: The Microsoft Office button performs

12 Fundamental of ICT – MS Word-I

Each of the tabs contains the following tools:

View: Document Views, Show/Hide, Zoom, Window, Macros

Quick Access Toolbar

13 Fundamental of ICT – MS Word-I

Working With Documents

 Click the Microsoft Office Button and Click New or

14 Fundamental of ICT – MS Word-I

 Click the Microsoft Office Button and Click Open, or

Renaming Documents: To rename a Word document while using the program:

Working on Multiple Document

15 Fundamental of ICT – MS Word-I

Customize the Word Environment

16 Fundamental of ICT – MS Word-I

17 Fundamental of ICT – MS Word-I

18 Fundamental of ICT – MS Word-I

Move Action Keystroke

Search and Replace Text: To find a particular word or phrase in a document:

Undo Changes: To undo changes:

Change Font Typeface and Size: To change the font typeface:

21 Fundamental of ICT – MS Word-I

To change the font size:

Change Text Color: To change the text color:

22 Fundamental of ICT – MS Word-I

Clear Formatting: To clear text formatting:

23 Fundamental of ICT – MS Word-I

To indent paragraphs, you can do the following:

 Click the dialog box of the Paragraph Group

24 Fundamental of ICT – MS Word-I

25 Fundamental of ICT – MS Word-I

26 Fundamental of ICT – MS Word-I

27 Fundamental of ICT – MS Word-I

28 Fundamental of ICT – MS Word-I

 Click Save Selection as New Quick Style

Style Inspector: To determine the style of a particular section of a document: