List of Practicals

Lab. NO. Title of Practical

1 Getting familiar with basic computer hardware: peripheral devices.

2 Getting familiar with system unit rear panel: ports and connectors.

3 Looking inside the system unit and getting familiar with internal
components.
4 Un-Cabling and Cabling the system unit.

5 Installing windows operating system and disk partitioning

6 Working with Microsoft Disk Operating System (MS-DOS)

7 Understanding BIOS and POST operation.

8 Getting familiar with windows 7 desktop operating system.

9 Creating and editing documents with Microsoft Word.

10 Creating documents with advance formatting operations of Microsoft

Word.
11 Creating and editing multimedia presentations with Microsoft
PowerPoint.
12 Creating presentations with advance operations of Microsoft
PowerPoint.
13 Creating and editing spreadsheets with Microsoft Excel.

14 Creating spreadsheets with advance operations of Microsoft Excel.

Evaluation

Roll Number: _______________

S.NO. Practical NO. Marks (05) Signature

1 Practical 01

2 Practical 02

3 Practical 03

4 Practical 04

5 Practical 05

6 Practical 06

7 Practical 07

8 Practical 08

9 Practical 09

10 Practical 10

11 Practical 11

12 Practical 12

13 Practical 13

14 Practical 14

Total (Average)
Lab 01: Getting familiar with basic computer hardware: peripheral devices | 10

EXERCISE

Exercise 1.1: What different input and output devices you found in the lab. For each
of the device fill in the following format:

Device Name Brand Name Type/Mechanism Type of Data Input/Output

Device Name = Name of Input or Output device.

Brand Name = Company Name device manufactured by.

Type/Mechanism = Type of device or working mechanism. For example: For mouse specify whether it
is optical or mechanical, for monitor specify whether it is Cathode Ray Tube or Flat panel Display.
Type of Data = Specify the type of data, the device inputs or output. For example: Image, Text, or Sound.

Input / Output = Specify whether the device is an input device or output device.

Exercise 1.2: For each of the following devices list few names of the software
applications that use them intensively:

• Keyboard • Printer
• Mouse • Speaker
• Microphone • Webca
m
• Scanner • Joystick
• Digital Camera

Exercise 1.3: Unscrew the mechanical mouse and with the help of a diagram describe
its working mechanism.
Exercise 1.4: Unscrew the optical mouse and with the help of a diagram describe its
working mechanism.

Exercise 1.5: Unscrew a standard keyboard and with the help of a diagram describe
its working mechanism.

Computer Fundamentals by Ali Asghar Manjotho

Lab 02: Getting familiar with system unit rear panel: ports and connectors | 16

EXERCISE

Exercise 2.1: Label each of the following ports and connectors:

Computer Fundamentals by Ali Asghar Manjotho

Lab 02: Getting familiar with system unit rear panel: ports and connectors | 17

Computer Fundamentals by Ali Asghar Manjotho

Lab 02: Getting familiar with system unit rear panel: ports and connectors | 18

Exercise 2.2: What different ports and connectors do you found in the lab? For each,
fill in the following:

Port/Connector name NO. of pins Device attached to

Computer Fundamentals by Ali Asghar Manjotho

Lab 02: Getting familiar with system unit rear panel: ports and connectors | 19

Exercise 2.3: Fill in the following table:

Port/Connector No. of pins Input/output Serial/Parallel

DIN5
PS/2
Serial
Parallel
VGA
USB
Firewire
RJ11
RJ45
S/PDIF
HDMI
DVI
S-Video

Exercise 2.4: Identify and label the ports in the motherboard shown below.

Computer Fundamentals by Ali Asghar Manjotho

Lab 02: Getting familiar with system unit rear panel: ports and connectors | 20

Exercise 2.5: Identify and label the ports in the motherboard shown below.

Exercise 2.6: Identify and label the ports in the motherboard shown below.

Computer Fundamentals by Ali Asghar Manjotho

Lab 03: Looking inside the system unit and getting familiar with internal components | 32

EXERCISE

Exercise 3.1: Label the name for each of the following PSU connector:

A. _________________________________________ B. _________________________________________

C. ______________________________ D. __________________________ E.
__________________________

H.
F. ______________________________ G. __________________________ __________________________

I. __________________________

Computer Fundamentals by Ali Asghar Manjotho

Lab 03: Looking inside the system unit and getting familiar with internal components | 33

Exercise 3.2: Identify the following system unit internal components:

A. _________________________________________ B. _________________________________________

C. _________________________________________ D. _________________________________________

E. _________________________________________ F. _________________________________________

Computer Fundamentals by Ali Asghar Manjotho

Lab 03: Looking inside the system unit and getting familiar with internal components | 34

Exercise 3.3: Identify the following RAM modules: (SIMM, SDR DIMM, DDR1 DIMM,
DDR2 DIMM. DDR3 DIMM, DDR4 RIMM, SO-DIMM, RIMM, SO-RIMM)

A. _________________________________________

B. _________________________________________

C. _________________________________________

D. _________________________________________

Computer Fundamentals by Ali Asghar Manjotho

Lab 03: Looking inside the system unit and getting familiar with internal components | 35

E. _________________________________________

F. _________________________________________

G. _________________________________________

H. _________________________________________

Computer Fundamentals by Ali Asghar Manjotho

Lab 03: Looking inside the system unit and getting familiar with internal components | 36

I. _________________________________________

Exercise 3.4: Identify and label different expansion slot in the following
motherboard:

Computer Fundamentals by Ali Asghar Manjotho

Lab 03: Looking inside the system unit and getting familiar with internal components | 37

Exercise 3.5: Label different components of the following motherboard:

Computer Fundamentals by Ali Asghar Manjotho

Lab 03: Looking inside the system unit and getting familiar with internal components | 38

Exercise 3.6: What is the orientation of your PC’s System Unit? What other
orientations are available?

Exercise 3.7: Check in your PC, and specify the number of following PSU
connectors:
a) Molex: __________
b) Mini-Molex: __________
c) SATA: __________
d) P4: __________
e) PCIE: __________
f) ATX: __________

Exercise 3.8: Check in your PC, and specify the followings:

a) Number of RAM slots: __________
b) Type of RAM modules (SIMM, DIMM or RIMM) : __________
c) Size of Each of the RAM module: ________________
d) Number of PCI Slots: __________
e) Number of PCIE Slots: __________
f) Number of PCI-X Slots: __________
g) Number of ISA Slots: __________
h) Number of AGP Slots: __________
i) Type of CPU Chip (LGA, PGA, SECC) : __________
j) Number of Heat Sinks and associated components: ___________
k) BIOS Manufacturer: _______________________
l) Number of HDDs attached: __________
m) Number of FDDs attached: __________
n) Types of HDD (IDE, SATA) : __________
o) Types of CD/DVD ROM (IDE/SATA) : _____________
p) Number of IDE Connectors on motherboard: __________
q) Maximum number of IDE devices supported by motherboard:
__________
Computer Fundamentals by Ali Asghar Manjotho
Lab 04: Disassembling and assembling system unit | 46

EXERCISE

Exercise 4.1: Disassemble the system unit and specify the followings:

a. Describe the entire procedure step by step.

b. With every step, capture and place in the image.

c. Capture the image of each of the internal component separately,

label it with its name and describe its functionality briefly.

Exercise 4.2: Assemble the system unit and specify the followings:

a. Describe the entire procedure step by step.

b. With every step, capture and place in the image.

Computer Fundamentals by Ali Asghar Manjotho

Lab 05: Installing windows operating system and disk partitioning | 54

EXERCISE

Exercise 5.1: Create a bootable Windows 10 USB. Note: use any tool other than
Rufus.

a. Describe the entire procedure step by step.

b. With every step, capture and place in the screenshots.

Exercise 5.2: Download windows 10 ISO image and install it through bootable USB:

a. Describe the entire procedure step by step.

b. With every step, capture and place in the screenshots.

Computer Fundamentals by Ali Asghar Manjotho

Lab 06: Working with Microsoft Disk Operating System (MS-DOS) | 60

EXERCISE

Exercise 6.1: Write MS DOS commands for the followings (Use wildcard Characters).

a) Change the current directory to C:\Windows\System32\

____________________________________________________________________________________________

b) Display all files whose name begin with “a”

____________________________________________________________________________________________

c) Display all files whose name end with “a”

____________________________________________________________________________________________
d) Display all files whose name contain “a”

____________________________________________________________________________________________
e) Display all files whose name contain “a” and “b”

____________________________________________________________________________________________
f) Display all files whose extension start with “d”

____________________________________________________________________________________________
g) Display all the files whose name contain “c” and extension of “.exe”

____________________________________________________________________________________________
h) Display all files whose name contain 2 letters

____________________________________________________________________________________________
i) Display all “.exe” files whose name contain 2 letters

____________________________________________________________________________________________
j) Display all files whose extension contain 2 letters

____________________________________________________________________________________________

Exercise 6.2: Write MS DOS commands for the followings

a) Change the current directory to C:\Windows\System\

____________________________________________________________________________________________
b) Create three folders named Folder1, Folder2 and Folder3 in your D:

____________________________________________________________________________________________

Computer Fundamentals by Ali Asghar Manjotho

Lab 06: Working with Microsoft Disk Operating System (MS-DOS) | 61

c) Copy files, file1.txt and file2.txt to Folder2

____________________________________________________________________________________________
d) Move Folder2 in to Folder3

____________________________________________________________________________________________
e) Rename Folder1 to MyFolder
____________________________________________________________________________________________
f) Move Folder3 in to MyFolder

____________________________________________________________________________________________
g) Delete MyFolder

____________________________________________________________________________________________

h) View all hidden files in D:\MyFolder\Folder3

____________________________________________________________________________________________

i) Create the folders named TextFiles, EXEFiles and BMPFiles in to D:

____________________________________________________________________________________________
j) Copy all text files from C:\Windows\System32 in to D:\TextFiles
____________________________________________________________________________________________

k) Copy all exe files from C:\Windows\System32 in to D:\EXEFiles

____________________________________________________________________________________________

l) Copy all bmp files from C:\Windows\System32 in to D:\BMPFiles

____________________________________________________________________________________________
m) Create a folder D:\Dummy
____________________________________________________________________________________________

n) Copy all text files (whose name begin with a) from C:\Windows\System32 in to
D:\Dummy
____________________________________________________________________________________________

o) Copy all text files (whose name begin with ab) from C:\Windows\System32 in to
D:\Dummy

____________________________________________________________________________________________
p) Copy all files (whose name begin with z) from C:\Windows\System32 in to D:\Dummy

____________________________________________________________________________________________

Computer Fundamentals by Ali Asghar Manjotho

Lab 06: Working with Microsoft Disk Operating System (MS-DOS) | 62

q) Copy all files (whose name begin with b and end with b) from C:\Windows\System32 in
to D:\Dummy
____________________________________________________________________________________________

r) Delete all files from D:\Dummy whose extension start with a

____________________________________________________________________________________________
s) Delete all files from D:\Dummy whose name start with a extension start with z
____________________________________________________________________________________________

t) Delete all files from D:\Dummy whose name contain aa in their name
____________________________________________________________________________________________

u) Delete the entire directory D:\Dummy

____________________________________________________________________________________________

v) Quick Format USB drive (Write drive letter according to USB drive letter assigned in
your PC)

____________________________________________________________________________________________
w) Change the label of D: to MyDrive

____________________________________________________________________________________________
x) Change USB drive label to CF USB

____________________________________________________________________________________________
y) Check the memory of the PC

____________________________________________________________________________________________
z) Close the Command prompt window

____________________________________________________________________________________________

Computer Fundamentals by Ali Asghar Manjotho

Lab 07: Understanding BIOS and POST operation | 71

EXERCISE

Exercise 7.1: Launch BIOS configuration program in your PC and specify how you done
it?

Exercise 7.2: Look in to your system BIOS and name its manufacturer, version number
and its manufacturing date.

Exercise 7.3: Change the system Date and Time from the BIOS configuration program.

Exercise 7.4: Create and remove a password for BIOS configuration program in to your
PC.

Exercise 7.5: For your PC specify the followings:

a. Number of CPUs ___________________

b. Clock speed of CPUs ___________________
c. Number of RAM modules attached ___________________
d. RAM size ___________________
e. Number of HDD attached ___________________
f. HDD capacity ___________________
g. Number of FDD attached ___________________
h. Number of CD/DVD ROMs attached ___________________
i. Current Boot Order ___________________

Exercise 7.6: Change the boot order of your system to have CD/DVD drive as first
bootable device and HDD as second.
Computer Fundamentals by Ali Asghar Manjotho
Lab 08: Getting familiar with Microsoft Windows 7 Desktop operating system | 79

EXERCISE

Exercise 8.1: What are the system requirements for Windows 7, and how will it perform
on your computer?

Exercise 8.2: How to open Control Panel in Windows 7?

Exercise 8.3: Describe major operation you can perform on control panel.

Exercise 8.4: What is the purpose of Task Manager? How will you launch it in Windows
7?

Exercise 8.5: What is screen resolution? How do you the change screen resolution in
Windows 7?

Exercise 8.6: How to create libraries in Windows 7?

Exercise 8.7: Describe what happens when you:

• Turn the computer on Sleep

• Turn the computer on Hibernate

Computer Fundamentals by Ali Asghar Manjotho

Lab 09: Creating and editing documents with Microsoft Word | 87

EXERCISE

Exercise 9.1: Create and format the following MS WORD document page:

Computer Fundamentals by Ali Asghar Manjotho

Lab 09: Creating and editing documents with Microsoft Word | 88

Exercise 9.2: Create and format the following MS WORD document page:

Exercise 9.3: Create and format the following MS WORD document page:

Computer Fundamentals by Ali Asghar Manjotho

Lab 09: Creating and editing documents with Microsoft Word | 89

Exercise 9.4: Create the following lists in MS WORD:

• Classification of Computers
o On the basis of Purpose
o On the basis of Size
o On the basis of Working Mechanism
• Classification of Computers (Purpose)
o General Purpose
o Special Purpose
• Classification of Computers (Size)
o Super Computers
o Mainframe Computers
o Mini Computers
o Micro Computers
▪ Desktop Computers
▪ Workstations
▪ Notebook Computers
▪ Tablet PCs
▪ Handheld Computers
▪ Smartphones
• Classification of Computers (Working Mechanism)
o Analog Computers
o Digital Computers
o Hybrid Computers

1. Software
2. Types of Software
a. System Software
i. System Management
ii. System Support
iii. System Development
b. Application Software
i. General Purpose
ii. Application Specific

Computer Fundamentals by Ali Asghar Manjotho

Lab 10: Creating documents with advance formatting operations of Microsoft Word | 95

EXERCISE
Exercise 10.1: Create the following tables in MS Word:

Shopping Bill

Customer Name: Ali

Customer Number: CN2501

S. #. Item Brand Price/Unit Units Price

1 Dress Pants Oxford Rs. 4500 2 Rs. 9000
Dinners Rs. 2200 1 Rs. 2200
2 Jeans Levis Rs. 5100 2 Rs. 1200
3 Tie Dinners Rs. 550 3 Rs. 1650
Oxford Rs. 3500 1 Rs. 3500
4 Shirt Dinners Rs. 1850 1 Rs. 1850
Cambridge Rs. 4000 1 Rs. 4000
5 Belt Cambridge Rs. 1800 2 Rs. 3600
Total Price Rs. 27000
Discount Rs. 3500
Net Bill Rs. 23500

PROVISIONAL LIST OF CLASS ATTENDANCE

DEPARTMENT OF COMPUTER SYSTEMS ENGINEERING - I
31
C.F 24
A.C
29
F.E
31 29
ES. ENG 33 31
B.E.E 30
238Conducted
Pe rcen
tage

Mr. Ali Asghar Mr. Mr. Ms. Saba Mr. Aijaz

Ayaz Jam
T.L

Manjotho Baloch Rajpar

Siyal Khan
S.# Roll #
T.Lec T.Prac T.Lec T.Lec T.Lec T.Prac T.Lec T.Prac

31 30 29 31 29 33 31 27 241
1 L. Att P. Att L. Att L. Att L. Att P. Att L. Att P. Att T.L Att
17CS01 30 24 29 31 29 30 31 30 234 98
2
17CS05 30 24 29 31 29 30 31 30 234 98
3
17CS07 30 24 28 29 29 30 31 30 231 97
4
17CS09 28 24 25 27 26 24 31 30 215 90
5
17CS11 30 24 23 28 24 30 30 27 216 91

Computer Fundamentals by Ali Asghar Manjotho

Lab 10: Creating documents with advance formatting operations of Microsoft Word | 96

Exercise 10.2: Create the following smart art graphics in MS Word:

Purpose General Purpose

Special Purpose

Super

Mainframe Desktop
Classification of Size Workstation
Mini

Computers Notebook
Micro
Tablet
Analog
Type of Handheld

Data/Working Digital
Mechanism Smart Phone

Hybrid

Computer Fundamentals by Ali Asghar Manjotho

Lab 10: Creating documents with advance formatting operations of Microsoft Word | 97

Exercise 10.3: Insert the following equations in MS Word document:

3
= √sin cos − sin cos +
2

−
2

( + ) =∑()
=0

( )=

2 1⁄
( ) = ∫ (1 + | Ω
| ) 2 1, …
′
=
1
2
√1 −
2
+ −

−
cos = { }=

−
= { }=

Computer Fundamentals by Ali Asghar Manjotho

Lab 11: Creating and editing multimedia presentations with Microsoft PowerPoint | 104

EXERCISE
Exercise 11.1: Create the following presentation in MS PowerPoint, also apply the
transitions.

Computer Fundamentals by Ali Asghar Manjotho

Lab 11: Creating and editing multimedia presentations with Microsoft PowerPoint | 105

Computer Fundamentals by Ali Asghar Manjotho

Lab 11: Creating and editing multimedia presentations with Microsoft PowerPoint | 106

Computer Fundamentals by Ali Asghar Manjotho

Lab 12: Creating presentations with advance operations of Microsoft PowerPoint | 113

EXERCISE
Exercise 12.1: Create the following presentation in PowerPoint, use animations and
transitions as well.

Computer Fundamentals by Ali Asghar Manjotho

Lab 12: Creating presentations with advance operations of Microsoft PowerPoint | 114

Computer Fundamentals by Ali Asghar Manjotho

Lab 12: Creating presentations with advance operations of Microsoft PowerPoint | 115

Computer Fundamentals by Ali Asghar Manjotho

Lab 12: Creating presentations with advance operations of Microsoft PowerPoint | 116

Computer Fundamentals by Ali Asghar Manjotho

Lab 13: Creating and editing spreadsheets with Microsoft Excel | 124

EXERCISE
Exercise 13.1: Create the following account worksheet in MS Excel:

Exercise 13.2: Create the following simple student test results worksheet in MS Excel:

Computer Fundamentals by Ali Asghar Manjotho

Lab 13: Creating and editing spreadsheets with Microsoft Excel | 125

Exercise 13.3: Create the following single-entry bookkeeping cashbooks in MS Excel:

Computer Fundamentals by Ali Asghar Manjotho

Lab 14: Creating spreadsheets with advance operations of Microsoft Excel | 137

EXERCISE
Exercise 14.1: Create the following worksheet for marksheet generation:

Exercise 14.2: Create the following worksheet for implementing general formulas:

Computer Fundamentals by Ali Asghar Manjotho

Lab 14: Creating spreadsheets with advance operations of Microsoft Excel | 138

Exercise 14.3: Create the following business worksheet:

Exercise 14.4: Create the following worksheet and insert bar charts:

Computer Fundamentals by Ali Asghar Manjotho

Lab 14: Creating spreadsheets with advance operations of Microsoft Excel | 139

Exercise 14.5: Create the following worksheet and insert pie chart:

Computer Fundamentals by Ali Asghar Manjotho

Lab 14: Creating spreadsheets with advance operations of Microsoft Excel | 140

Exercise 14.6: Create the following worksheet and insert scattered charts:

Computer Fundamentals by Ali Asghar Manjotho