PRACTICAL FILE

DEPARTMENT OF COMPUTER SCIENCE

NAME

FATHER NAME

CLASS

ROLL NO

SECTION

BATCH

CERTIFIED BY INCHARGE

SHAHEED MOHTARMA BENAZIR BHUTTO

GOVT. GIRLS COLLEGE
AZAM TOWN

SMBB Govt. Girls College

Azam Town
 TABLE OF CONTENTS

PRACTICAL INITIALS
OBJECTIVE
NO.

Word: Create a simple .txt file applying text formatting

(Font-Name, Style, Size) and copy-paste functions.
1.
Excel: Create a Payroll calculating Medical Allowance, House
Rent, Gross Pay, Tax, Net Pay, and Grade using IF() function.

Word: Write a letter requesting money for books and insert a

table.
2.
Excel: Create a spreadsheet computing Gross Amount and
Income Tax (2%) for workers, and find the Average Gross
Amount.

3. Word: Create vertically dotted margins and apply paragraph

justification, borders, and shading.

Excel: Create an Attendance Register computing Total

Attendance using COUNTIF() and calculate percentages.

4. Word: Create a document using headers/footers, date/time,

page numbers, dual columns, drop caps, and clipart.

Excel: Generate an electricity utility bill calculating units

consumed, surcharge, and amount due.

5. Word: Prepare an invitation card with page borders, event

graphics, and landscape orientation.

Excel: Assign student grades using nested IF() functions, sort by

marks, and create a Bar Chart.
6. Word: Create an A4 pamphlet utilizing the drawing menu, fonts,
and borders.

Excel: Generate a Marks Certificate computing total marks

(SUM), percentages, and assigning grades (A+ to F).

7. Word: Create a weekly college time table using the Table

feature.

Excel: Create a database of 15 students, apply cell borders, and

sort descending by Name and Marks Obtained.

8. Word: Create an Award Certificate with landscape orientation,

page border, and graphic insert.

Excel: Create a Column Chart comparing provincial department

expenditures and display chart legend.

9. Word: Create a Curriculum Vitae using tabs, formatting tools,

tables, and bullets.

Excel: Compute marks and percentages, then assign remarks

(Excellent, V. Good, etc.) using IF() function.

10. Word: Write a 6-day leave application to the Principal using

specific font settings and single spacing.

Excel: Calculate Total Expenditure (SUM) and create a Pie Chart

showing provincial contributions.

11. Word: Write an application for a leaving certificate applying

'Book Antiqua' font and textured background.

Excel: Calculate quarterly expenditure totals, grand total, MIN(),

MAX(), and AVERAGE() costs.

12. Word: Format a passage into three columns with different fonts
and drop caps.
 Excel: Generate a Sui gas utility bill computing unit charges via
IF() function, sales tax, and amount payable.

13. Word: Write a book issue application to the librarian, inserting a

formatted table.

Excel: Calculate Gross/Net Amounts, Sale Price, and Profit for an

automobile inventory spreadsheet.

14. Word: Format duplicated paragraphs with varied fonts/colors, borders,

clipart, headers, and footers.

Excel: Create a scholarship statement computing tiered scholarship

amounts and counting recipients (COUNT).

15. Word: Type mathematical and scientific formulas using

superscripts/subscripts, borders, and headers.

Excel: Generate a PTCL utility bill calculating call charges, taxes, and
conditional dues based on dates.

16. Word: Design a birthday invitation with borders, event graphics, and
landscape orientation.

Excel: Calculate Accumulated Loan Amounts using POWER() and

Monthly Installments using ROUND().
 Practical # 01
(a) Word Create a simple .txt file using MS-Word document. Type three or four lines
paragraph and then, Copy one time and paste five times. Also apply text formatting
including Font-Name, Font-Style, and Font- Size to each paragraph, Save and also print.

(b) Excel Create a Pay Roll of employees according to the instructions:

Name Basi Medical Hous Gross Tax Net Grade

c Allowanc e Pay Pay
Pay e Rent
Madiha 16000
Umama 10800
Shaheer 16500
Mustafa 20300

i.​ Calculate Medical Allowance = 12 % of Basic Pay and House Rent = 40 % of Basic
Pay.
ii.​ Calculate: Gross Pay = Basic Pay + Medical Allowance + House Rent
iii.​ Develop an IF( ) Function to compute Tax which is 4% of the Gross Pay if Gross pay
is greater than 15000 otherwise it is 3%.
iv.​ Compute Net Pay by Subtracting Tax from Gross Pay.
v.​ Using IF( ) Function, Assign Grade-1 if Net Pay is greater than 15000 otherwise assign
Grade- 2.
 Practical # 02
a) Word Write a letter to your father, requesting him to send Rs. 14000/- for purchasing
books. Insert a table containing [Link]. ,Name of Books, Quantity and Price. Save and also
print.

(b) Excel Create and print a spread sheet following the given instructions:

work Incom
Hours Total
Emp Emp Days Charge e Tax
Worker Worked Hours Gross
# Name Worke s
Type per day worke Amoun
d per
d t
hour
A 0221 Madiha 20 9 100
B 0222 Umama 19 7 120
C 0223 Shaheer 24 10 90
D 0224 Mustafa 21 8 125

i.​ Total Hours worked=days worked * Hours worked per day

ii.​ Gross Amount = Total Hours worked * work charges per hour
iii.​ Calculate Two Percent ( 2%) Income Tax of each employee.
iv.​ Use AVERAGE( ) Function , Calculate separately Average Gross Amount in a cell
below the above work sheet.
v.​ Save and also print.
 Practical # 03
(a) Word Using “Word Processor” create vertically dotted line representing left and right
margin on the paper for different paragraph Alignments. Use a paragraph for justification
and also use the Borders and Shading. Save and also print.

(b) Excel Using Spreadsheet, Create & Print Attendance register showing 10 days
[Link]:

Roll Total
%
No Attendance
Name 1 2 3 4 5 6 7 8 9 10 Age
001 Kaleem P P P P P P A P P P 9 90
002 Amina A A A A A A A A P P
003 Hasan P P A P A A A P P A
004 Maaz A P P P P P P P P P
005 Huma P P P P A P A P P P
006 Rizwan P P P P P P P P P P
007 Noor P P P P A A A P P A
008 Roshan A A A P P P A P P A
009 Abdullah P P A P A P A P P P
010 Hunaina P P P P P P P P P P

i.​ Calculate Total Attendance using COUNTIF( ) function.

ii.​ Enter a formula to calculate Percentage.
iii.​ Sort the table on Total Attendance and Name.
 Practical # 04
(a) Word Write a passage from your book. Using Word Processor create any document
using header and footer. Save and also print.
▪​ Insert Date & Time in header.
▪​ Insert page number in footer.
▪​ Convert the document in two columns.
▪​ Use Drop caps in the document.
▪​ Insert clipart in the document.
(b) Excel​Using Spreadsheet, Create a Utility bill of electricity according to the instructions:
Meter Previous Current Units Electricity Amoun
Number Units Units Consumed Charge Surcharge t
Payable
HU-2201 12536 12750
HU-4202 1230 1523
HU-1203 96312 96642
HU-5620 5853 5996
i)​ Enter a formula to calculate units consumed.
ii)​ Cost of one unit of electricity is Rs. 8.25.
iii)​ Compute the Surcharge as 15% of Electricity Charges.
iv)​ Compute the Amount Due as
Amount Due = Electricity Charges + Surcharge
and round up the amount payable to one decimal place using ROUND( ) function.
Save and also print.
 Practical # 05
(a) Word Prepare an invitation card for friends, invite them to your birthday party. Give a
Page Border in this invitation card, insert graphic objects from event category. Set
Landscape as orientation. Save and also print.
(b) Excel Using Spread Sheet, Generate the following output.
Roll No Name Marks Grade
1 Madiha 80
2 Umama 76
3 Shaheer 71
4 Mustafa 56
5 Kashaan 97
6 Nadeem 45
7 Shabnum 81
8 Saima 65
i)​ Use IF( ) function assign Grade according to the following
criteria:
a.​ If the Marks is greater than 80 Grade=A-1
b.​ If the Marks is Less than 80 or equal to 70 Grade=A.
c.​ If the Marks is Less than 70 or equal to 60 Grade=B.
d.​ If the Marks is Less than 60 or equal to 50 Grade= C
ii)​ Sort the list by Marks
iii)​ Using Bar Chart show each student’s bar according with its
marks.
iv)​ Save and also Print.
 Practical # 06

(a) Word Using “Word Processor” create a pamphlet of A4 size paper / letter. Use
complete drawing menu, Fonts and Boarders. Save and also Print.

(b) Excel Use Spreadsheet to create and print Marks Certificate according to the
following instructions.

Computer
Marks
Name Maths Science Physics English Urdu Percentage Grade
Obtained
Madiha 70 37 49 69 40
Umama 86 73 53 61 85
Shaheer 63 50 63 33 55
Hunaina 52 46 67 52 69
Mustafa 43 48 52 65 39

i.​ Use SUM ( ) Function to find out the marks obtained of each student.
ii.​ Calculate Percentage of each student with Total Marks=500.
iii.​ Use IF() function assign Grade according to the following criteria:
iv.​ If Percentage is greater than or equal to 80, print A+
v.​ If Percentage is greater than or equal to 70, print A
vi.​ If Percentage is greater than or equal to 60, print B
vii.​ If Percentage is greater than or equal to 50, print C else Print F.
viii.​ Save and also print
 Practical # 07

(a) Word Use Table to Create a time table of your college.

TIME TABLE
Periods Mon Tue Wed Thu Fri Sat
1
2
3
4
5
6

(b) Excel Use Spreadsheet to create database of 15 students which include the fields Roll
No. , Name, Father’s Name and Marks Obtained Apply cell Border. Sort the sheet by
Name and Marks Obtained in descending order. Save and also print.
 Practical # 08

(a) Word Create an Award Certificate, Choose Landscape orientation, use a Page Border
and insert graphic from leisure category. Save and also print.

(b) Excel Create spreadsheet with the following data and follow the instructions:

Different Expenditures by the Province in Year 2024 (Rs. in Million)

Department 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr

Education 4.3 6 6.1 6.4

Health 6.87 7.51 7.81 78.6

Law & Order 1.47 2.49 3.64 3.91

Welfare 50.5 53.7 60.12 78.5

i.​ Select the rows and columns consisting of numbers only to create a
Column Chart showing comparison among the Expenditure by
different Department using chart wizard. Title the chart “Expenditure in
Year 2024”. Title Y –Axis “( Rs. In Million)”
ii.​ Display legend of chart.
iii.​ Print both the worksheet and Chart.
 Practical # 09
(a) Word Create a Curriculum Vitae. Save and Print.
a.​ PERSONAL using Tab Keys and Format Tools.
b.​ ACADEMIC QUALIFICATIONS using Tables.
c.​ WORKING EXPERIENCES using Bullets.
d.​ HOBBIES using simple Format.
(b) Excel​Use Spreadsheet, create and print Marks Certificate according to the
following instructions.
Name Math Computer Physics English Urdu Marks Percentage Remarks
Science Obtained
Asaad 98 67 89 79 421
Zainab 86 67 78 82 366
Moosa 61 50 33 55 244
Hooriya 52 46 52 68 285
Abdulla 43 48 65 39 247
h
i.​ Develop a formula to find out physics marks of each student.
ii.​ Calculate the Percentage of each student.
iii.​ Using IF( ) function assign remarks according to the following criteria:
a.​ If Percentage is greater than or equal to 80, print “Excellent”
b.​ If Percentage is greater than or equal to 70, print “V. Good”
c.​ If Percentage is greater than or equal to 60, print “Good”
d.​ If Percentage is greater than or equal to 50, print “Fair” else “poor”
iv.​ Save and also print.
 Practical # 10

(a) Word Write an application to the Principal, requesting him to grant you 6 days leave.
Use the single spacing and left alignment. Change the formatting Font- size 12 point and
Font –Name “Arial”. Save and also print.

(b) Excel Create spread sheet with the following data and Follow the instructions:

Expenditure by Different Provinces in Year 2024 (Rs. in Million)

Province 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Year

Sindh 542.5 561.5 643.4 796.2

Punjab 887 835.8 930.5 936.5

Balochistan 244.81 261.5 301.7 299.3

KPK 391.5 424.5 377.6 300.5

i.​ Use the SUM ( ) function to find the Total Expenditure by province in year.
ii.​ Select the columns enclosed in the rounded rectangle to create a Pie
Chart showing Contribution of each province in Total Expenditure
using Chard Wizard.
iii.​ Display Legend of Chart.
iv.​ Print both the worksheet and Cha
 Practical # 11

(a) Word Write an application to your principal, asking him/her for leaving certificate.
Change the type face of the entire document to 15 point Book Antiqua. Change the page
background using File effects with Texture Save and also print (without back ground).

(b) Excel Using the spreadsheet with the following data and follow the instruction :
Pakistan Printing Press (Expenditure2024)
Department 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Total
Engineer 25356 45451 67735 45451
Marketing 67735 46421 47881 69421
Computer 4881 56421 84221 55568
Sales 84221 785621 25356 45451
Purchase 59006 58000 67735 605981
Production 8887 99956 4881 56421
Grand Total
Minimum
Maximum
Average

i.​ Calculate department wise Total, Apply currency Format with 2 decimal places.
ii.​ Use the SUM ( ) function to calculate Grand Total.
iii.​ Find the Minimum, Maximum and Average expenditure for each quarter using
statistical functions = MIN( ), MAX( ), and AVERAGE( ).
 Practical # 12

a) Word Write a passage from your book, Use MS – Word to create three columns in each
column apply different Font sizes, Font name and in first column apply Drop Cap. Save
and also print.

(b) Excel Use spreadsheet to Create a utility Bill of Sui gas according to the instructions:

Meter Previous Curren Units Gas Amoun

Number Units t Consumed Charges Sales Tax t
Units Payable
SS-7290 69236 69452
SS-7291 7382 7399
SS-7292 33842 33998
SS-7293 45732 45795
SS-7294 82556 82715
SS-7295 5699 5754
i.​ Develop a formula to calculate Unit Consumed.
ii.​ Using IF( ) function, compute Gas charges which are Rs. 1.85/unit if the
Units consumed are less than 200, otherwise charges are Rs. 2.85/ units.
iii.​ Compute the Sales Tax as 15% of Gas Charges.
iv.​ Compute the Amount due to
a.​ Amount Due = Gas Charges + Sales Tax.
v.​ Save and also print.
 Practical # 13

(a) Word Write an application to the librarian requesting him/her to issue you some books
from lending library. Insert a table containing [Link]. , Book Name, Author Name &
Edition. Save and also print.

(b) Excel Create a spreadsheet according to the instructions:

Pak Motors (Ptv.)
Item Labour Capita Miscellaneous Gross Net Sale Profit
Cost l Cost Cost Amoun Amoun Pric
t t e
Motor Bike 500 10500 1000 1200 11640 15132 3492
Car Mehran 1200 140000 2000
Luxury Car 1500 450000 8000
High Roof 1600 150000 4000
i.​ Calculate Gross amount by adding labour, capital, Miscellaneous.
ii.​ Calculate:​ Net Amount = Gross Amount -2% of Gross Amount.
iii.​ Calculate:​ Sale Price = 30 % Net Amount + Net Amount.
iv.​ Find out profit by subtracting Net Amount from sale Price.
v.​ Save and also print.
 Practical # 14

(a) Word Write a paragraph from your book .Copy one time and paste three times each
paragraph change Font-style , Font size and Font Color, in the first paragraph apply
Boarder and in the second paragraph insert the picture from clip art category. Set Roll No.
and Examination 2024 in Header and set Page No. in Footer. Save and also print.

(b) Excel Use spreadsheet to Create the following scholarship statement.

Rol Marks Total Ful Scholarshi Payabl

Name
l Obtained Marks l p e Fee
No. Fee Amount
PE-7601 Talha 599 900 80000
PE-7602 Mumtaz 488 900 80000
PE-7603 Kashaf 787 900 80000
PE-7604 Hamza 667 900 80000
PE-7605 Najaf 782 900 80000
PE-7606 Mahad 663 900 80000
i.​ Apply formula to calculate the Scholarship on the following range of marks.
a.​ No Scholarship for those students who obtained marks below 500.
b.​ 30% Scholarship of Full Fee will be awarded to those who obtained marks
between 500 to 600.
c.​ 40% Scholarship of Full Fee will be awarded to those who obtained marks
between 600 to 700.
d.​ 60% Scholarship of Full Fee will be awarded to those whose secured
marks above 700.
ii.​ Count the number of students gained Scholarship using COUNT( ) function and
display in a cell below the above worksheet.
iii.​ Save and also print.
 Practical # 15

(a) Word
Type the given phrase Area of circle = 2πr2 , Mean(n)=∑Xn, SinƟ + CosƟ=1, Formula of
water = H2O Give a border to the phrase. Copy it three times changing different colors.
Write Formula as heading on header and page number in footer. Save and print.

(b)Excel
Create and print a Utility bill of PTCL by following the given instructions:
Where Due date is 25/6/2024 and Line rent is 174.

Use Pay date Loca Total Total Mobile CLI Total Tax Total
r ID l Call Local Mobile Charge Call Dues
Charge Duration s Charge
s s
1101 28/6/2024 67 140.7 22 66.0 40 420.7 71.52 492.22
1102 20/5/2024 389 76 40
1103 02/7/2024 785 213 0
1104 09/7/2024 113 20 0

i)​ Calculate Total Local Charges @Rs. 2.10 per call

ii)​ Calculate Total Mobile Charges @Rs. 3.0 per minute
iii)​ Calculate Total Call Charges as:
Total Call charges = Total Local Charges + Mobile Charges + Line rent + CLI
iv)​ Calculate tax as 17% of Total Call Charges
v)​ Using IF() function, Compute Total dues if pay date is within Due date
as: Total Dues =Total Call Charges + Tax, Otherwise if pay date is after
Due date: Total Dues = Total Call Charges + Tax + 5.01% of Surcharge.
 Practical # 16
(a) Word
Type an invitation to a friend; invite him to your birthday party. Give a page Border to your
invitation. Insert graphic from event category. Set landscape as orientation.
Save and also print.

(b)Excel
Using Spreadsheet, Create House building loan statement according to the following
instructions. House Building Loan

LOAN INTERES MONTHLY

YEARS ACCUMULATED
AMOUNT T RATE INSTALLMENT

100000 5 7%
250000 6 7%
500000 8 7%
80000 2 7%

INSTRUCTIONS:
(i)​Use POWER( ) function and calculate:
Accumulated Amount = Loan Amount (1 + Interest Rate)years.
(ii)​Determine: Monthly Installment = Accumulated amount / (years *12)
(iii)​Use ROUND( ) function and round Monthly Installment to two decimal places.

(iv)​Save and also print.