ICT - PR Book - BSCS - Part - 1 PDF

PRACTICAL WORKBOOK
Introduction to Information &

Communication Technologies
MS windows, MS Office, HTML/ Turbo C
Name: ________________________________________
Roll No: _______________________________________
Lab Instructor:
Engr. ASAD NAZIR SOOMRO
Course Teacher:
ENGR. MIR MUHAMMAD

[email protected]
DEPARTMENT OF COMPUTER SCIENCE

QUAID-E-AWAM UNIVERSITY OF ENGINEERING, SCIENCE & TECHNOLOGY
NAWABSHAH, SINDH
QUAID-E-AWAM UNIVERSITY OF ENGINEERING, SCIENCE & TECHNOLOGY, NAWABSHAH
CERTIFICATE
This is to certify that Mr. / Miss __________________________________
of 22BSCS class bearing Roll No. ________________ has carried out the
necessary practical as per course of studies Introduction to
Information & Communication Technologies for the 1st Semester 1st
Year as above in practical schedule of his/her journal.
LAB INSTRUCTOR ________________
Date: __________
COURSE TEACHER _______________

Introduction to Information & Communication Technologies
CONTENTS
Lab Page
OBJECT
Session No.
1. To identify the hardware components of PC 03
2. Assembling and disassembling the hardware components of PC 07
3. Installation of MS Windows 10 operating system 12

To become familiar with network hardware and software on
4. 20
windows 10
5. To become familiar with MS Word 24
6. To become familiar with MS Excel 33
7. To become familiar with MS Power Point 42
8.
9.
10.
11.
12.
13.
14.
1
Roll # _______________
HARDWARE
Introduction to computer:
Computer is an electronic device which takes the input data from
the input device and generates the information and it will be displayed on the
output devices. It enables arithmetic computations, data processing, and
information management (storage) in an efficient manner.
The word computer is derived from the word compute which means ‘to
calculate’. So a computer generally considered to be calculating device that
perform operations at very faster rates.
BLOCK DIAGRAM OF COMPUTER
Basically the computer system has three major components. These are
• System Unit
o Central Processing Unit (Processor)
o Memory Unit.
• Input Unit.
• Output Unit.
2
Roll # _______________
Practical # 01
Objective:
To identify the hardware components of PC
1. CABINET:
a. It is used to install all hardware devices

like(mother board, HDD,CD ROM, FDD)
b. It has Start, Restart Button, Led’s, Audio and
USB Connecters are available at front side.
2. MONITOR:
Monitor of a computer is like a television screen. It
displays text characters and
Graphics in colors or in shades of grey.The monitor is also
called as screen or display or CRT (cathode ray tube).
In the monitor the screen will be displayed in pixels
format.
1. 800 by 600 pixels
2. 1024 by 768 pixels
3. KEYBOARD:
Key board is like a type writer, which
contains keys to feed the data or information into
the computer. Standard keyboards are available
with 104 keys or above.
4. Mouse:
Every mouse has one primary button (left button) and
one secondary button (right button). The primary button is used
to carry out most tasks, whereas secondary button is used in
special cases you can select commands and options.
5. Speaker:
Speakers make your system much more delightful to use entertain while
you are working on computer
3
Roll # _______________
6. Printer:
A device that prints images (numbers, alphabets, graphs, etc…) on paper
is known as Printer. We have different types of printers to take printouts. These
are as follows:
I. Dot matrix printer
II. Inkjet printer
III. Laser printer
7. Scanner:
Scanner used to scan images and text
8. System board/Motherboard:
This is the major part of the
PC hardware. It manages all
transactions of data between CPU
peripherals. This holds the
Processor, Random Access Memory
and other parts, and has slots for
expansion cards. It is rectangle
shape
9. CPU:
The central processing unit contains the
heart of any computer, the processor. The
processor is fitted on to a Mother Board. The
Motherboard contains various components, which
support the functioning of a PC. It is brain of the
computer. It is square shape.
10. RAM Slots and RAMs:

RAM slots are used to install the RAMs. It is large rectangle shape and
each ending has small clips. There two type ram slots
SD RAM ---------- Two Gaps
DDR RAM -------- One Gap
4
Roll # _______________
11. North Bridge:

It is also called as controller. It
converts electronic signals to binary values
and binary values to electronic signals. It is
nearby socket 478. It placed middle of the
mother board.
12. South Bridge:

It is controls major components of
motherboard and it is back bone of the I/O
devices. It communicates PCI slots, IDE-1,
IDE-2, floppy connecter, BIOS chip. It is
nearby CMOS battery.
13. CMOS Battery:

Computer is using a coin shape battery. It generates the clock signal and
it
Manages system continues time.
14. Primary & Secondary (IDE-1 & IDE-2) :

It is also called as IDE-1, IDE-2. It used to connecting Hard Disk Drive, CD
ROM, DVD ROM.
15. BIOS Chip:

BIOS controls how the
operating system and hardware
works together. BIOS identification
is BIOS name is available on chip
or mother board
5
Roll # _______________
16. Input & Output ports:

I/O ports are used to connecting I/O device such as key boards, mouse,
monitor, printer, scanner, speakers etc.
17. Bus Cables or Data cables:

A Bus is a collection of wires through which data is transmitted from one
device to another device. Cables are two types:
 IDE cable : it used to connect HDD, CD ROM, DVD ROM
 FDD cable: it used to connect FDD
18. Hard Disk Drive:

The hard disk drive is the main, and usually largest, data storage device in
a computer. The operating system, software titles and most other files are stored
in the hard disk drive. Identifications is the panel name is Hard Disk dive.
19. CD ROM Drive & CD-Writer:

CD-ROM (Compact Disk Read only Memory) Drive is a device that reads
the information from Compact Disks (CD). CD-Writer is used to write the data
into Compact Disks.
20. Floppy Disk USB Drive:

The floppy disk drive is used to read the information stored in floppy disks.
Floppy disks also called as a diskette.
6
Roll # _______________

Practical # 02
Objective:
Assembling and disassembling the hardware components of PC
Required Tools:
1. CPU (Processor) 08. Key Board
2. Mother Board 09. Mouse
3. Floppy Disk Drive 10. Monitor
4. Hard Disk Drive 11. RAM (SD or DDR)
5. CD or DVD ROM 12. Bus Cables
6. Cabinet 13. Power Cables
7. Speakers 14. Screw driver etc.
Procedure:
1. Mother Board Installation:
 Open the cabinet on either side.
 The back side of the cabinet has readymade provision for the installation
of the I/O shields. An I/O shield is used for connecting the input and
output devices through it.
 Check whether the mother board is placed in such a way that the I/O ports
of the motherboard correctly fit in the I/O shields. Ensure all the specified
screws for the motherboard are fixed and intact.
2. CPU Installations:
7
Roll # _______________

 CPU is one of the most dedicated components of the computer. The CPU
pins have to be clearly studied before fixing into the relevant processor
space on the motherboard. After the CPU is rightly placed in its position
the lever is to be locked.
 As a part of the CPU installation, before the CPU is fixed in the right
position a lever is provided, which needs to be unlocked. This lever is
perpendicular to the motherboard.
 The CPU, which is a square shaped electronic component, comes with pins
below it. One should find for an indication on one of the corners of the CPU
on both sides. This arrow mark is also found on the motherboard which
guides for the fixation of the CPU. Once match of the pins verses
motherboard slot gently push the CPU.
 After the CPU is rightly placed in its position, the lever is to be locked.
 The CPU heat sink fan is to be

carefully plugged on to the CPU
by pushing down the metal plastic
clips.
 The metal/plastic clips provided

with heat sink fan should fix on to
the CPU socket and have to be
locked.
 Once the CPU het sink fan is fixed

and locked, it should be
connected to the Power supply
available on the mother board
through the power connector.
8
Roll # _______________
3. RAM Installation:
Next is installing the RAM.
Insert the RAM into an available
expansion socket. Note how the
RAM is keyed to the socket. This
ensures the RAM can be plugged
into the socket one way only.
Finally press the RAM firmly into
position, making certain the Ram
is completely seated in the
socket.
4. SMPS Installations:
Next is installing the SMPS (switching-mode power supply). This is an
electronic power supply unit that provides and regulates the power supply to all
components of a computer system. SMPS needs to install into cabinet at the place
provided for it. After placing the SMPS into the relevant provider space fix the
outer screws to it intact.
Next installing the ATX power connector, It is a 20/24-pin power connector. This
is the primary power supply to the mother board.
5. Hard Disk Drive Installation:

Installing the Hard Disk Drive (HDD)
is clearly understood in the following steps.
First see the rare of the HDD. It consists of
the 3 types of pins. One left side the HDD
has multiple pins termed as the IDE
connector. In the middle is the jumper
setting pins for the HDD. On the extreme
right side is the power connector pins.
Every device except FDD (floppy Disk
Drive) uses this type of power connector.
HDD and CDD (Compact Disk Drive)
connected by this type of IDE cable.
9
Roll # _______________
Mount the HDD into mounting slot meant for the HDD with the rear end
facing and secure the inner screws intact. Connect the IDE cable to the HDD as
well as the mother board as shown in the figure. Remember for all the power
connectors to be plugged in, one needs to align the Red line on the cable to Pin-1
of the IDE port. Hence connect the power cable to the HDD rare end by gently
pushing the connector.
Note: Use the same procedure for installing the CD-ROM
6. Switches and LEDs Connections:

Installing the Switches and LEDs of front side of the cabinet. Please refer
to your mother board manual to locate where the connectors are. Different
mother boards place the connectors in different locations. The connectors for the
switches and LEDs are normally grouped together. They should look similar to the
figure given below.
Finally connect all peripheral devices like mouse, key-board, monitor, etc… to the
I/O ports.
Review Questions / Exercise:
Q #1: What is difference between Primary storage and Secondary

storage?
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
10
Roll # _______________

Q #2: Which type of storage is composed of computer circuitry that
temporarily holds data waiting to be processed?
_________________________________________________________________
_________________________________________________________________
Q #3: You want to upgrade your PC because it is slow. What components

you can replace with newer ones to increase the processing speed
of your PC.
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
Q #4: You ask shop keeper for a 4 GB RAM for your PC but the shop
keeper says it is not compatible with your computer. How he
knows this?
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
Q #5: Differentiate b/w PATA and SATA Drives.
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
Remarks:
Teacher / Lab Engineer
11
Roll # _______________
Practical # 03
Objective:
To perform installation of MS Windows 7 operating system
Required Tools:
A desktop computer (PC) with CD-DVD ROM, Windows 7 CD or DVD
Procedure:
Warning: Backup any data before you begin!
Minimum Hardware requirements of Windows 7:

This is minimum hardware that you need to have on your computer and should
be checked in advance of installing.
• 1 GHz CPU with 32 bits or 64 bits.

• 1 GB Ram for 32 bits or 2 GB Ram for 64 bits.
• 16 GB empty space hard disk for 32 bits or 20 GB for 64 bits.
• DVD drives (if installing from a DVD).
Step – 1: Turn your

computer on then press
Del or F2 key (depend
on your computer’s
mainboard) to enter the
system BIOS.
Step – 2: Go to Boot
menu and choose Boot
from CD/DVD.
12
Roll # _______________
Step – 3: Press F10 to save the

configuration and exit BIOS then reset
your computer.
Step – 4: Insert Windows 7 DVD into

your DVD drive then start up your
computer, Windows 7 will be loading
files.
Step – 5: Select these parts: Language

to Install, Time and currency format,
keyboard or input method. Then click
Next.
13
Roll # _______________
Step – 6: Choose the Windows 7

version that you want to install
in 'Select the operating system
you want to install'. Here we
choose Windows 7 Ultimate
then click next (depending on
your Windows DVD, this step is
an option).
Step – 7: Click 'I accept the

license terms' in 'Please read
the license' then click Next.
Step – 8: Choose 'Upgrade' in

'Which type of installation do
you want' if you want to
upgrade from an older
Windows version to Windows 7,
'Custom (advance)' if you want
to install a new version of
Windows.
14
Roll # _______________
Step – 9: Choose Partition for

installation, if your computer has
only one hard disk, it will be
easy for selection, but if it has
some Partition, you will have to
consider which Partition to
choose.
Step – 10: Wait for Installing

Windows to progress. Your
computer might be restarted
during the process.
15
Roll # _______________
Step – 11: Type user account

and computer name, and then
click Next.
Step – 12: Type a password for

your account, you can also Type
a password hint to help in case of
forgetting the password in the
future, and then click Next.
16
Roll # _______________
Step – 13: Type in activation

code or key for your license in
Product key box if you have any.
Click Next.
Step – 14: Choose how to

protect your Windows. Here we
choose Use recommended
settings.
17
Roll # _______________
Step – 15: Set up your Time zone

then click Next.
Step – 16: Choose an option

from 3 choices: Public Network,
Work Network, Home Network.
Choose Home Network for using
Internet at home.
18
Roll # _______________
Q #1: The windows 7 setup asks for the user name during the
installation. Suppose you want to add more users who will use the
computer. How you will do that?
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
Q #2: I want to install Windows 7 but when I inserted the CD and

restarted the PC, setup did not start. What could be the possible
problems?
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
Q #3: What is meant by case-sensitive password?
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
Remarks:
19
Roll # _______________
Practical # 04
Objective:
To become familiar with network hardware and software on windows 7
Required Tools:
A desktop computer with network interface card, working internet
connection
PROCEDURE:
Task 1: Find out what kind of network connection you have and whether you
have Internet connectivity or not?
Step-1: Turn your computer which
is connected with the internet.
Step-2: Check whether the

computer is connected to a network
or not.
Step-3: If the computer is

connected to the network, whether
it is a wired or wireless connection?
Step-4: Depending upon the type of

the network connection (wired of
wireless) your PC will be using
different hardware devices. For a
wired connection, the PC mostly use
an NIC (Network Interface Card)
while for the wireless connections,
most devices use wireless adapter
built-in the device like your laptop.
Step-5: Open the browser of your

choice. Here we assume that you
have opened Google chrome.
20
Roll # _______________
Task 2: Configure your network

Step 1: Open Control Panel\Network and Internet\Network and Sharing Center.
It will show you the active networks.
Step 2: Select the network you want to change settings. The status window
opens. Click properties and then select Internet Protocol Version IPv4.
Task 3: Configure your router / switch.

A router is a device that allows your computer to connect with the internet
and provides route for the data traffic in and out for the PC. For most of the
21
Roll # _______________

routers available nowadays, a modern web based GUI interface is provided to
change their settings. However, we will only configure a router to be used as a
gateway for providing internet to one or more PC.
Step 1: Open your browser and type URL for the routers administration panel
(This URL is usually written on the router’s manual or the product packing)
Step 2: Type user name and password in the window that opens (for most of the
routers / switches, the username and password is admin, unless you change it)
Step 3: The router’s administration panel opens. Change the settings according
to your requirements. In this practical we will configure TP-Link TL-MR3040 router
to be used as WAN switch.
Task 4: Make a workgroup to share files / folders and hardware like printers and
scanners.
A workgroup is a network of computers which can share files, folders and other
hardware. In this lab task, we will make a workgroup of two PCs in windows 7.
Make sure that the two PC are turned ON and are connected to the network.
Step 1: Open My Computer ->properties -> Computer Name.
Step 2: Click Change
Step 3: Type a meaningful computer name and the rowkgroup name. Here we
will use TestPC as computer name and TestWorkgroup as workgroup name.
Step 4: To share libraries or folders, open Windows Explorer, and select the
custom library or folder that you would like to share. Click Share With on the
toolbar. Do not double-click the library or folder; just select it by clicking it once.
Step 5: Choose an option on the Share With drop-down menu. If you want to
share only with specific people, click Specific People and continue with the
remaining steps.
Step 6: Type the username of the person you want to share with, or click the
arrow to the right of the dialog box and select the person from the drop-down
menu. Click Add. The person is added with Read permission.
Step 7: To change the permission level for someone, click that person's name
and select Read, Read/Write, or Remove. Click the Remove option if you want to
remove file sharing for that person.
Step 8: Click Share. Windows asks if you want to give access to other people
(the people you designated in the previous step).
Step 9: Click Next.
Step 10: Click Done. Your library is now shared.
CONCLUSION: Students learned to use networks and configure their network
EXERCISE: Information stored on your PC or any other PC on your network is

accessible to you only when your PC is ON or it is connected to a network. What if
you need a file when you are away from home and you don’t have the file in your
USB flash drive? There are q few websites allowing you to put your data online so
that it may be available to you everywhere in the world as soon as you are
connected to the Internet. Find information about such websites and prepare a
table of comparison for theses websites. You are also required to create an
22
Roll # _______________

account on www.dropbox.com and associate your PC with you dropbox.com
account. Further, you are required to create a shared folder on your drop box
account that is shared with your teachers who teach you in this term only. Name
that folder as your roll_number.
Q #1: Differentiate among workgroup, homegroup, and domain of

networks
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
Q #2: Define the functions of DNS and DHCP services. Who provides
these services?
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
Remarks:
23
Roll # _______________
Practical # 05
Objective:
To become familiar with Microsoft Word
Introduction:
Word 2010 is a word processor that allows you to create various types of
documents such as letters, papers and faxes. In this lab, you will learn how to
create new documents and open existing ones. Word 2010 is a bit different from
earlier versions, so even if you've used Word before you should take some time
to familiarize yourself with the interface. The toolbars are similar to those in Word
2007, and they include the Ribbon and the Quick Access Toolbar. Unlike Word
2007, commands such as Open and Print are housed in Backstage view, which
replaces the Microsoft Office Button.
The Ribbon:
The new, tabbed Ribbon system was introduced in Word 2007 to replace
traditional menus. The Ribbon contains all of the commands you'll need in order
to perform common tasks. It contains multiple tabs, each with several groups of
commands, and you can add your own tabs that contain your favorite commands.
Some groups have an arrow in the bottom-right corner that you can click to see
even more commands.
To customize the Ribbon:

You can customize the Ribbon by creating your own tabs with whichever
commands you want. Commands are always housed within a group, and you can
create as many groups as you want in order to keep your tab organized. If you
want, you can even add commands to any of the default tabs, as long as you
create a custom group in the tab.
24
Roll # _______________

 Right-click the Ribbon and select Customize the Ribbon. A dialog box
will appear.
 Click New Tab. A new tab will be created with a new group inside
it.
 Make sure the new group is selected.
 Select a command from the list on the left, then click Add. You
can also drag commands directly into a group.
 When you are done adding commands, click OK
NOTE: If you don't see the command you want, click on the Choose commands
from: drop-down box, then select All Commands
Backstage view:
Backstage view gives you various options for saving, opening a file,
printing, or sharing your document. It is similar to the Office Button Menu from
Word 2007 or the File Menu from earlier versions of Word. However, instead of
just a menu, it is a full-page view, which makes it easier to work with.
Basic tasks with text:

It is important to know how to perform basic tasks with text when
working in a word processing application. You'll learn the basics of working with
25
Roll # _______________

text, including how to insert, delete, select, copy, cut, paste, and drag and
drop text.
To insert text:
1. Move your mouse to the location where you wish text to appear in the
document.
2. Click the mouse. The insertion point appears.
3. Type the text you wish to appear.
To delete text:
1. Place the insertion point next to the text you wish to delete.
2. Press the Backspace key on your keyboard to delete text to the left of the
insertion point.
3. Press the Delete key on your keyboard to delete text to the right of the
insertion point.
To select text:
1. Place the insertion point next to the text you wish to select.
2. Click the mouse, and while holding it down drag your mouse over
the text to select it.
3. Release the mouse button. You have selected the text. A highlighted
box will appear over the selected text.
To copy / cut and paste text:

1. Select the text you wish to copy/ cut.
2. Click the Copy/Cut command on

the Home tab. You can also right-click
your document and select Copy/ Cut.
3. Place your insertion point where you

wish the text to appear.
4. Click the Paste command on the Home

tab. The text will appear.
You can also cut, copy, and paste by right-clicking your document and choosing
the desired action from the drop-down menu.
26
Roll # _______________
Find and Replace text:

When you're working with longer documents, it can be difficult and time
consuming to locate a specific word or phrase. Word can automatically search
your document using the Find feature, and it even allows you to change words or
phrases using Replace.
To find text:
1. From the Home tab, click

the Find command. The Navigation pane
will appear on the left side of the screen.
2. Type the text you wish to find in the field at
the top of the Navigation pane.
3. If the text is found in the document, it will be
highlighted in yellow, and a preview will
appear in the Navigation pane.
4. If the text appears more than once, you can

click the arrows on the Navigation pane to step through the results. You
can also click the result previews on the Navigation pane to jump to the
location of a result in your document.
5. When you close the Navigation pane, the highlighting will disappear.
To replace text:
1. From the Home tab, click
the Replace command. The Find and
Replace dialog box will appear.
2. Type the text you wish to find in the Find
what field.
3. Type the text you wish to replace it with in
the Replace with field.
4. Click Find Next and then Replace to
replace text. You can also click Replace
All to replace all instances within the document.
27
Roll # _______________
Formatting text:
Formatted text can emphasize important information and help organize
your document. In Word, you have many options for adjusting the font of your
text, including size, color, and inserting special symbols. You can also adjust
the alignment of the text to change how it is displayed on the page.
To change font size:
1. Select the text you wish to

modify.
2. Click the drop-down
arrow next to the Font
Size box on the Home tab. A
drop-down menu appears.
3. Select the desired font size
from the menu. Alternatively,
you can type the value that
you want and then press Enter
on your keyboard.
You can also use the Grow
Font and Shrink Font commands to
change the size.
To change the font:

1. Select the text you wish to modify.
2. Click the drop-down arrow next to the Font box on the Home tab.
The Font drop-down menu appears.
3. Move the mouse pointer over the various fonts. A live preview of the font
will appear in the document.
4. Select the font you wish to use. The font will change in the document.
To change the font color:

2. Click the Font Color drop-down arrow on the Home tab. The Font
Color menu appears.
3. Move the mouse pointer over the various font colors. A live preview of the
color will appear in the document.
4. Select the font color you wish to use. The font color will change in the
document.
Select More Colors at the bottom of the list to access the Colors dialog box.
Choose the color that you want, then click OK.
28
Roll # _______________
To highlight text:
1. From the Home tab, click the Text
Highlight Color drop-down arrow.
The Highlight Color menu appears.
2. Select the desired highlight color.
3. Select the text you wish to modify. It will then be highlighted.
4. To switch back to the normal cursor, click the Text Highlight
Color command.
To use the Bold, Italic, and Underline commands:

2. click the bold (ctrl+b), italic (ctrl+i), or underline (ctrl+u) command
in the font group on the home tab.
To change the text case:

1. Select the text you wish to
modify.
2. Click the Change
Case command in
the Font group on the
Home tab.
3. Select the desired case
option from the list.
To change the text alignment:

2. Select one of the four alignment options from the Paragraph group on
the Home tab.
o Align Text Left: Aligns all selected text to the left margin.
o Center: Aligns text an equal distance from the left and right margins.
o Align Text Right: Aligns all selected text to the right margin.
o Justify: Justified text is equal on both sides and lines up equally to the
right and left margins. Many newspapers and magazines use full
justification.
29
Roll # _______________
Checking Spelling and Grammar:

To make your document appear professional, you'll want to make sure it is
free from spelling and grammar errors. Word has several options for checking
your spelling. You can run a spelling and grammar check, or you can allow Word
to check your spelling automatically as you type
1. Go to the Review tab.

2. Click on the Spelling &
Grammar command.
3. The Spelling and
Grammar dialog box will
open. For each error in
your document, Word will
try to offer one or
more suggestions. You
can select a suggestion
and click Change to
correct the error.
4. If no suggestions are
given, you can manually
type the correct spelling
Saving:
Saving your documents helps to keep you from losing your work, and
using Save As allows you to edit a document while leaving the original copy
unchanged
To use the SAVE command:

1. Click the Save command on the Quick Access
Toolbar.
2. The document will be saved in its current
location with the same file name.
To use the SAVE AS command:

Save As allows you to choose a name and location for your document. It's
useful if you've first created a document or if you want to save a different version
of a document while keeping the original.
1. Click the File tab.

2. Select Save As.
3. The Save As dialog box will appear. Select the
location where you wish to save the document.
4. Enter a name for the document, then click Save.
30
Roll # _______________
Printing:
Once you've completed your document, you may want to print it. In
previous versions of Word, there was a Print Preview option that allowed you to
see exactly what the document looked like before printing it. You may have
noticed that this feature seems to be gone in Word 2010. It actually hasn't
disappeared; it's just been combined with the Print window to create the Print
pane, which is located in Backstage view.
1. Click the File tab to go to Backstage view.

2. Select Print. The Print pane appears, with the print settings on the
left and the Preview on the right.
To print:
1. Go to the Print pane.

2. If you only want to print certain pages, you can type a range of pages.
Otherwise, select Print All Pages.
3. Select the number of copies.
4. Check the Collate box if you are printing multiple copies of a multi-page
document.
5. Select a printer from the drop-down list.
6. Click the Print button.
31
Roll # _______________
Q #1: Which operation you will perform if you need to move a block of
text?
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
Q #2: If you need to change the typeface of a document, which menu will
you use?
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
Q #3: How do you print preview a document?
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
Remarks:
32
Roll # _______________
Practical # 06
Objective:
To become familiar with Microsoft Excel
Introduction:
Excel 2010 is a spreadsheet application in the Microsoft 2010 Office Suite.
Excel allows you to store, manipulate, and analyze data in organized workbooks
for home and business tasks.
In this lab, you will learn your way around the Excel 2010 environment, I will
show you how to use and modify the Ribbon and the Quick Access Toolbar,
and how to create new workbooks and open existing ones. After this lesson,
you will be ready to get started on your first workbook.
The Ribbon:
The new, tabbed Ribbon system was introduced in Excel 2007 to replace
traditional menus. The Ribbon contains all of the commands you'll need in order
to perform common tasks. It contains multiple tabs, each with several groups of
commands, and you can add your own tabs that contain your favorite commands.
Some groups have an arrow in the bottom-right corner that you can click to see
even more commands.

commands you want. Commands are always housed within a group, and you can
create as many groups as you want in order to keep your tab organized. If you
want, you can even add commands to any of the default tabs, as long as you
create a custom group in the tab.
33
Roll # _______________
Excel Terminology:
To understand Excel better, you should familiarization yourself with the
terminology: spreadsheet, workbook and worksheet.
Spreadsheets and workbooks

A spreadsheet is a grid of data divide into numbered rows and lettered
columns. Each block in this grid is called a cell, and it can hold an individual piece
of text or data. A cell has a lettered column and numbered row. In Excel, a file /
document is considered a spreadsheet, although it is commonly referred to as a
workbook.
Worksheets
The worksheet is a page of data in your spreadsheet (or workbook) that is
organized by the labeled tabs displayed at the bottom of the Excel window. Each
worksheet has 214 (~16,000) available columns and 220 (~1 million) available
rows, so Excel can easily accommodate large datasets.
Your spreadsheets can contain as many worksheets as you want. By default,
however, all newly opened Excel spreadsheets have three worksheets. To view
the contents of a worksheet, click on its tab at the bottom-left corner of the Excel
window.
CREATING AND OPENING WORKBOOKS
To create a new, blank work book:

1. Click the File tab. This takes you to Backstage view.
2. Select New.
3. Select Blank workbook under Available Templates. It will be highlighted
by default.
4. Click Create. A new, blank workbook appears in the Excel window.
34
Roll # _______________
To open an existing workbook:

2. Select Open. The Open dialog box appears.
3. Select your desired workbook, and then click Open.
INTRODUCTION TO CELLS AND CELL CONTENT

Cells are the basic building blocks of a worksheet. Cells can contain a
variety of content such as text, formatting attributes, formulas,
and functions. To work with cells, you'll need to know how to select
them, insert content, and delete cells and cell content.
The Cell:
Each rectangle in a worksheet
is called a cell. A cell is the
intersection of a row and a column.
Each cell has a name, or a cell
address based on which column and
row it intersects. The cell address of
a selected cell appears in the Name
box. Here you can see that C5 is
selected. You can also select multiple
cells at the same time. A group of
cells is known as a cell range. Rather
than a single cell address, you will
refer to a cell range using the cell
addresses of the first and last cells in
the cell range, separated by a colon.
For example, a cell range that included
cells A1, A2, A3, A4, and A5 would be
written as A1:A5.
To select a cell:
1. Click on a cell to select it. When a cell is selected, you will notice that
the borders of the cell appear bold and the column heading and row
heading of the cell are highlighted.
2. Release your mouse. The cell will stay selected until you click on another cell
in the worksheet.
To select multiple cells:

1. Click and drag your mouse until all of the adjoining cells you want are
highlighted.
2. Release your mouse. The cells will stay selected until you click on another
cell in the worksheet.
35
Roll # _______________
To insert content:
1. Click on a cell to select it.
2. Enter content into the
selected cell using your
keyboard. The content
appears in the cell and in
the formula bar. You also
can enter or edit cell content
from the formula bar.
To delete content within cells:

1. Select the cells containing
content you want to delete.
2. Click the Clear command on the Ribbon. A dialog box will appear.
3. Select Clear Contents.
You can also use your keyboard's Backspace key to delete content from a single
cell or the Delete key to delete content from multiple cells.
To delete cells:
1. Select the cells you want to delete.
2. Choose the Delete command from the Ribbon.
To copy/ cut & paste cell content:

1. Select the cells you wish to copy.
2. Click the Copy/ Cut command. The border of the selected cells will change
appearance.
3. Select the cell or cells where you want to paste the content.
4. Click the Paste command. The copied content will be entered into the
highlighted cells.
To Drag and Drop Cell:

1. Select the cells you want to move.
2. Position your mouse on one of the outside edges of the selected cells. The
mouse changes from a white cross to a black cross with 4 arrows
3. Click and drag the cells to the new location.
4. Release your mouse, and the cells will be dropped there.
36
Roll # _______________
Modifying Columns, Rows, and Cells:
By default, every row and column of a new workbook is always set to the
same height and width. Excel allows you to modify column width and row height
in many different ways.
To modify column width:
1. Position your mouse over
the column line in the column
heading so the white cross
comes a double arrow.
2. Click and drag the column to
the right to increase the column width or to the left to decrease the column
width.
3. Release the mouse. The column width will be changed in your spreadsheet.
To set column width with a specific measurement:

1. Select the columns you want to modify.
2. Click the Format command on the Home tab. The format drop-down menu
appears.
3. Select Column Width.
4. The Column Width dialog box appears. Enter a specific measurement.
5. Click OK. The width of each selected column will be changed in your
worksheet.
Select AutoFit Column Width from the format drop-down menu and Excel will
automatically adjust each selected column so all of the text will fit.
To modify the row height:

1. Position the cursor over the row line so the white cross becomes
a double arrow
2. Click and drag the row downward to increase the row height or upward
decrease the row height.
3. Release the mouse. The height of each selected row will be changed in your
worksheet.
To set row height with a specific measurement:

1. Select the rows you want to modify.
2. Click the Format command on the Home tab. The format drop-down menu
appears.
3. Select Row Height.
4. The Row Height dialog box appears. Enter a
specific measurement.
5. Click OK. The selected rows heights will be
changed in your spreadsheet
Select AutoFit Row Height from the format drop-down menu and Excel will
automatically adjust each selected row so all of the text will fit.
To insert rows:
37
Roll # _______________

1. Select the row below where you want the new row to appear.
2. Click the Insert command on the Home tab.
3. The new row appears in your worksheet.
To insert columns:
1. Select the column to the right of where you want the new column to
appear. For example, if you want to insert a column between A and B, select
column B.
2. Click the Insert command on the Home tab.
3. The new column appears in your worksheet
To delete rows / columns:

1. Select the rows / columns you want to delete.
2. Click the Delete command on the Home tab.
3. The rows / columns are deleted from your worksheet.
Wrapping text and merging cells

If a cell contains more text than can be displayed, you can choose to wrap the
text within the cell or merge the cell with empty, adjoining cells. Wrap text to
make it display on multiple lines of the cell. Merge cells to combine adjoining
cells into one larger cell.
To wrap text:
1. Select the cells with text that you want to wrap
2. Select the Wrap Text command on the Home tab
3. The text in the selected cells will be wrapped in your worksheet
** If you change your mind, re-click the Wrap Text command to unwrap the
text.
To merge cells using the Merge & Center command:
1. Select the cells you want to merge together
2. Select the Merge & Center command on the Home tab
3. The selected cells will be merged, and the text will be centered.
** If you change your mind, re-click the Merge & Center command to unmerge
the cells.
To format Numbers and Dates:

1. Select the cells you want to modify.
38
Roll # _______________

2. Click the drop-down arrow next to the Number Format command on the
Home tab.
3. Select the number format you want. For some number formats, you can
then use the Increase Decimal and Decrease Decimal commands (below
the Number Format command) to change the number of decimal places that
are displayed.
Simple Formulas
A formula is an equation that performs a calculation. Like a calculator,
Excel can execute formulas that add, subtract, multiply, and divide. One of the
most useful features of Excel is its ability to calculate using a cell address to
represent the value in a cell. This is called using a cell reference.
Creating simple formulas:

Excel uses standard operators for equations, such as a plus sign for
addition (+), minus sign for subtraction (-), asterisk for multiplication
(*), forward slash for division (/), and caret (^) for exponents. The key thing
to remember when writing formulas for Excel is that all formulas must begin with
an equals sign (=). This is because the cell contains, or is equal to, the formula
and its value.
1. Select the cell where the answer will appear (B4, for example).
2. Type the equals sign (=).

3. Type in the formula you want Excel to calculate. For example,
"75/250".
4. Press Enter. The formula will be calculated, and the value will be displayed
in the cell.
** If the result of a formula is too large to be displayed in a cell, it may appear

as pound signs (#######) instead of a value. This means that the column is
not wide enough to display the cell content. Simply increase the column
width to show the cell content.
Creating formulas with cell references

When a formula contains a cell address, it is called a cell reference.
Creating a formula with cell references is useful because you can update data in
your worksheet without having to rewrite the values in the formula.
39
Roll # _______________
1. Select the cell where the answer will appear (B3, for example).
2. Type the equals sign (=).
3. Type the cell address that contains the first number in the equation (B1).
4. Type the operator you need for your formula. For example, type
the addition sign (+).
5. Type the cell address that contains the second number in the equation (B2,
for example).
6. Press Enter. The formula will be calculated, and the value will be displayed
in the cell.
** If you change a value in either B1 or B2, the total will automatically
recalculate.
Working with Charts

Excel workbooks can contain a lot of data, and that data can often be difficult to
interpret. For example, where are the highest and lowest values? Are the
numbers increasing or decreasing? The answers to questions like these can
become much clearer when the data is represented as a chart. Excel has many
different types of charts, so you can choose one that most effectively represents
the data.
To create a chart:
1. Select the cells you want to chart,
including the column titles and row
labels. These cells will be
the source data for the chart.
2. Click the Insert tab.
3. In the Charts group, select the
desired chart
category (Column, for
example).
4. Select the desired chart
type from the drop-down menu
(Clustered Column, for example).
5. The chart will appear in the worksheet.
40
Roll # _______________
Q #1: Each Excel file is called a workbook, because?
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
Q #2: Which types of charts can excel produce?
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
Q #3: How are data organized in a spreadsheet?
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
Remarks:
41
Roll # _______________
Practical # 07
Objective:
To become familiar with Microsoft PowerPoint
Introduction:
PowerPoint 2010 is presentation software that allows you to create dynamic
slide presentations that may include animation, narration, images, videos, and
more. In this lab, you will learn your way around the PowerPoint 2010
environment, in addition to learning how to create new
presentations and open existing files.
The Ribbon:
The Ribbon contains multiple tabs, each with several groups of

commands. Some tabs, like "Drawing Tools" or "Table Tools", may appear only
when you are working with certain items like images or tables. In addition, you
can add your own customized tabs that contain your favorite commands.

commands you want.
1. Right-click the Ribbon, and select Customize the Ribbon. A dialog

box will appear
2. Click New Tab. A new tab will be created with a new group inside it.
3. Make sure the new group is selected.
4. Select a command from the list on the left, then click Add. You can
also drag commands directly into a group.
5. When you are done adding commands, click OK.
If you do not see the command you want, click on the Choose commands drop-
down box, and select All Commands.
Creating and opening presentations:
42
Roll # _______________

PowerPoint files are called presentations. Whenever you start a new
project in PowerPoint, you'll need to create a new presentation. You'll also
need to know how to open an existing presentation
To create a new/ blank presentation:

2. Select New.
3. Select Blank presentation under Available Templates and
Themes. It will be highlighted by default.
4. Click Create. A new, blank presentation appears in the PowerPoint
window
To open an existing presentation:

2. Select Open. The Open dialog box appears.
3. Select your desired presentation, then click Open.
If you have opened the existing presentation recently, it may be easier to

choose Recent from the File tab instead of Open to search for your
presentation.
SLIDE BASICS
Every PowerPoint presentation is composed of a series of slides. To begin
creating a slide show, you'll need to know the basics of working with slides. You'll
need to feel comfortable with tasks such as inserting a new slide, changing the
43
Roll # _______________

layout of a slide, arranging existing slides, changing slide view, and adding
notes to a slide.
Slides contain placeholders, which are areas on the slide that are enclosed by
dotted borders. Placeholders can contain many different items, including text,
pictures, and charts. Some placeholders have placeholder text, or text that you
can replace. They also have thumbnail-sized icons that represent specific
commands such as Insert Picture, Insert Chart, and Insert ClipArt.
Placeholders are arranged in different layouts that can be applied to existing

slides, or chosen when you insert a new slide. A slide layout arranges your
content using different types of placeholders, depending on what kind of
information you might want to include in your presentation.
CUSTOMIZING SLIDE LAYOUT

To change the layout of an existing slide:
1. Select the slide you wish to change

2. Click the Layout command in the Slides group on the Home tab. A menu
will appear with your options
3. Choose a layout from the menu. The slide will change in the presentation
44
Roll # _______________

To delete a placeholder:
You can easily customize your layout by deleting unwanted or "extra"

placeholders from any slide.
1. Position your mouse on the dotted border of the placeholder so it changes

to a cross with arrows
2. Click the border to select it.

3. Press Backspace or Delete on your keyboard. The placeholder will be
removed from the slide.
To add a text box:
Text boxes allow you to add to your current layout, so you can place text
wherever you want on your slide.
1. From the Insert tab, click the Text Box command
2. Your cursor will turn into an upside-down cross
3. Click, hold, and drag your mouse to draw a text box. A text box will appear.
To copy and paste a slide:
1. On the Slides tab in the left pane, select the slide you wish to copy.
2. Click the Copy command on the Home tab. You can also right-click your
selection and choose Copy.
3. In the left pane, click just below a slide (or between two slides) to choose
the location where you want the copy to appear. A horizontal insertion
point will mark the location.
4. Click the Paste command on the Home tab. You can also right-click and
choose Paste. The copied slide will appear.
To select multiple slides, press and hold Ctrl on your keyboard, and click the
slides you wish to select.
To delete a slide:
1. Select the slide you wish to delete.

2. Press the Delete or Backspace key on your keyboard.
45
Roll # _______________
Applying a Theme:
A theme is a predefined combination of
colors, fonts, and effects that can be applied to your
presentation. PowerPoint includes built-in themes that
allow you to easily create professional-looking
presentations without spending a lot of time
formatting.
You've already been using a theme, even if
you didn't know it: the default Office theme, which
consists of a white background, the Calibri font, and
primarily black text. Themes can be applied or
changed at any time.
Theme elements
Every PowerPoint theme, including the default Office theme, has its own theme
elements. These elements are:
 Theme Colors (available from every Color menu)
 Theme Fonts (available from the Font menu)
 Shape Styles (available in the Format tab when you click on a shape
To apply a theme:
1. Go to the Design tab.

2. Locate the Themes group. Each image represents a theme.
3. Click the drop-down arrow to access more themes.

4. Hover over a theme to see a live preview of it in the presentation. The
name of the theme will appear as you hover over it.
5. Click a theme to apply it to the slides.
Applying transitions:
Transitions are motion effects that, when in Slide Show View, add
movement to your slides as you advance from one slide to another. There are
many transitions to choose from; each one allows you to control the speed and
even add sound.
There are three categories of unique transitions to choose from, all of which can
be found on the Transitions tab:
1. Subtle (slight transitions)
2. Exciting (strong transitions)
3. Dynamic Content (strong transitions that affect only the content, such as
text or images)
46
Roll # _______________
To apply a transition:
1. Select the slide you wish to modify.
2. Click the Transitions tab.
3. Locate the Transition to This Slide group. By default, None is applied to
each slide.
4. Click the More drop-down arrow to display all of the transitions.

5. Click a transition to apply it to the selected slide. This will automatically
preview the transition as well.
To preview a transition:
You can preview the transition for a selected slide at any time, using
either of these two methods:
1. Click the Preview command on the Transitions tab.
2. Click the star Play Animations icon. The icon appears on the Slides tab in
the left pane beside any slide that includes a transition.
To modify the duration:

1. Select the slide that includes the transition you wish to modify.
2. In the Duration field in
the Timing group, enter the amount of
time you want the transition to take. In
this example, we will specify the length
as 2 seconds, or 02.00.
To add sound:
1. Select the slide that includes the transition you wish to modify.
2. Click the Sound drop-down menu in the Timing group.
3. You will hear the sound and see a live preview of the transition as
you hover over each sound.
4. Click a sound to apply it to the selected slide.
To remove a transition:
1. Select the slide you wish to modify.

2. Choose None from the gallery in the Transition to This
Slide group.
3. Repeat this process for each slide you want to modify.
To remove transitions from all slides, select a slide that uses None, and
click the Apply to All command.
47
Roll # _______________

Presenting Slide Show
To present your slide show, you'll need to know how to start it. PowerPoint
allows you to start your slide show from the first slide or from any slide within the
slide show.
To start a slide show:

1. Select the Slide Show tab.
2. Click the From Beginning command in the Start Slide Show group to
start the slide show with the first slide.
You can also start the slide show from the slide you prefer by selecting the slide
and clicking on From Current Slide from the Start Slide Show group. This option
is convenient if you only want to view or present certain slides.
Another option for starting the slide show is to select Slide Show view at
the bottom of the window.
Saving and Printing

Whenever you create a new presentation in PowerPoint, you'll need to
know how to save it in order to access and edit it later. PowerPoint allows you to
save your presentations in a number of ways.
Once you've created your document, you may want to print it to view. It's easy
to preview and print a document in Word using the Print pane
To use the Save As command:

Save As allows you to choose a name and location for your presentation.
It's useful if you've first created a presentation or if you want to save a different
version of a presentation while keeping the original.
1. Click the File tab.
2. Select Save As.
3. The Save As dialog box will appear. Select the location where you wish to
save the presentation.
4. Enter a name for the presentation, then click Save.
To use the Save command:

1. Click the Save command on the Quick Access Toolbar.
2. The presentation will be saved in its current location with the same file
name
** If you are saving for the first time and select Save, the Save As dialog box
will appear.
48
Roll # _______________
To view the Print pane:

1. Click the File tab to go to Backstage view.
2. Select Print. The Print pane appears, with the print settings on the
left and the Preview on the right.
To Print:
1. Go to the Print pane.
2. Determine and choose how you want the slides to appear on the page.
3. If you only want to print certain slides, you can type a range of slides.
Otherwise, select Print All Slides.
4. Select the number of copies.
5. Select a printer from the drop-down list.
6. Click the Print button.
Animating Text and Objects:

PowerPoint offers a variety of animations you can use to enhance your
presentation. Animations can be used to make text or objects appear on a
slide, exit a slide, or emphasize the text or objects already on a slide. You can
even use motion paths to create a customized animation.
There are many different animation effects that you can choose from, and they
are organized into four types:
 Entrance: These control how the object enters the slide. For example,
with the Bounce animation, the object will "fall" onto the slide and then
bounce several times.
 Emphasis: These animations occur while the object is on the slide, often
triggered by a mouse click. For example, you can set an object
to Spin when you click the mouse
49
Roll # _______________
 Exit: These control how the object exits the slide. For example, with
the Fade animation, the object will simply fade away.
 Motion Paths: These are similar to Emphasis effects, except that the
object moves within the slide along a predetermined path, like a circle.
To apply an animation to an object
1. Select an object.
2. Click the Animations tab.
3. In the Animation group, click the More drop-down arrow to view the
available animations.
4. Select the desired animation effect.
5. The object will now have a small number next to it to show that it has an
animation. Also, in the Slide pane, the slide will now have a star symbol
next to it.
50
Roll # _______________
Q #1: What is a motion path?
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
Q #2: In the context of animations, what is a trigger?
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
Q #3: what are called special effects used to introduce slides in a

presentation?
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
Remarks:
51
Roll # _______________

ICT - PR Book - BSCS - Part - 1 PDF

Uploaded by

Copyright:

Available Formats

ICT - PR Book - BSCS - Part - 1 PDF

Uploaded by

Document Information

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

ICT - PR Book - BSCS - Part - 1 PDF

Uploaded by

Copyright:

Available Formats

PRACTICAL WORKBOOK

Introduction to Information &

Roll No: _______________________________________

ENGR. MIR MUHAMMAD

DEPARTMENT OF COMPUTER SCIENCE

DEPARTMENT OF COMPUTER SCIENCE

This is to certify that Mr. / Miss __________________________________

necessary practical as per course of studies Introduction to

Information & Communication Technologies for the 1st Semester 1st

Year as above in practical schedule of his/her journal.

LAB INSTRUCTOR ________________

COURSE TEACHER _______________

Introduction to Information & Communication Technologies

2. Assembling and disassembling the hardware components of PC 07

3. Installation of MS Windows 10 operating system 12

6. To become familiar with MS Excel 33

7. To become familiar with MS Power Point 42

Introduction to Information & Communication Technologies

BLOCK DIAGRAM OF COMPUTER

Introduction to Information & Communication Technologies

a. It is used to install all hardware devices

Introduction to Information & Communication Technologies

10. RAM Slots and RAMs:

Introduction to Information & Communication Technologies

11. North Bridge:

12. South Bridge:

13. CMOS Battery:

14. Primary & Secondary (IDE-1 & IDE-2) :

15. BIOS Chip:

Introduction to Information & Communication Technologies

16. Input & Output ports:

17. Bus Cables or Data cables:

18. Hard Disk Drive:

19. CD ROM Drive & CD-Writer:

20. Floppy Disk USB Drive:

Introduction to Information & Communication Technologies

Introduction to Information & Communication Technologies

 The CPU heat sink fan is to be

 The metal/plastic clips provided

 Once the CPU het sink fan is fixed

Introduction to Information & Communication Technologies

5. Hard Disk Drive Installation:

Introduction to Information & Communication Technologies

Note: Use the same procedure for installing the CD-ROM

6. Switches and LEDs Connections:

Review Questions / Exercise:

Q #1: What is difference between Primary storage and Secondary

Introduction to Information & Communication Technologies

Q #3: You want to upgrade your PC because it is slow. What components

Q #5: Differentiate b/w PATA and SATA Drives.

Teacher / Lab Engineer

Introduction to Information & Communication Technologies

Minimum Hardware requirements of Windows 7:

• 1 GHz CPU with 32 bits or 64 bits.

Step – 1: Turn your

Introduction to Information & Communication Technologies

Step – 3: Press F10 to save the

Step – 4: Insert Windows 7 DVD into

Step – 5: Select these parts: Language