ROLL NO 36

OBJECT 5(A) MS WORD:-

Write an application to the librarian requesting him to issue you some
books from lending library insert a table containing
S.NO , BOOK , NAME , AUTHOR NAME & EDITION
Save it and print it.

PROCEDURE:
1- Double click on ms word.
2- Choose a new document.
3- Write an application to the librarian.
4- Insert a table of list of books.
5- Save the file and print it.

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36

OUTPUT

To,
The librarian,
Adamjee Government Science
College, Karachi.

Sub: request him to issue following given list of books

Respected sir,
With due respect it is stated that we are the students of
Adamjee Govt Science College and want to request you to
issue the following books to our college.
Sir as you are familiar too that our exams are nearer and we are
suffering from the shortage of our course books . We come to
college for group studies but due to shortage of books we go
home regretting our day.
Sir we would be highly thankful to you if you will arrange the
following books to our college.

S.NO BOOKS AUTHOR NAME EDITION

NAME
1 Mathematics Dr. Abdul Sattar Somroo Test edition
2 Physics Dr . Mazhar Ali Abbasi Test edition
3 Computer Gul Shahzad Sarwar Test edition
4 English Prof . Somia Kazim Test edition

Yours faithfully,
Adamjee Govt Science College.

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36

OBJECT 5(B) MICROSOFT EXCEL

Create save and print saving certificate using spreadsheet .
INSTRUCTIONS
1. Using if ( ) AND ( ) function, calculate interest rate
according to the following criteria.
a. 5%, if amount is 10000 or more and year is 10.
b. 4%, if amount is 10000 or more and year is 5.
c. 3%, if amount is 10000 or more and year is less than
5.
2. Calculate annual profit by adding amount and intrest
rate.
FORMULA
I. =If(AND(A2>=10000,B2=10),5,IF(AND(A2>=10000,B
2=5),4,3))
II. =A2+C2
TABLE
AMOUN YEAR INTREST AMOUN
T RATE T
PROFIT
10000 3
10000 5
10000 10
10000 2

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36

OBJECT 6(a) MICROSOFT WORD

Create a document using header and footer with following
steps:
a) Automatically insert date /time at top left of page(header)
b) Automatically insert page number in footer.
c) Convert the source document into two column
d) Use the drop cap.
e) Insert a picture from clip art.
f) Save and print.
PROCEDURE
 Create a word document
 Insert header and footer as instructions.
 Insert clip art.
 Break the page into two column.
 Save and print the document.

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OBJECT 6(B) MICROSOFT EXCEL
Create and print payrole of employee according to the
following instructions.
INSTRUCTIONS
I. Calculate medical allowance = *% of basic pay and
house rent= 40 % of basic pay.
II. Calculate gross pay = basic pay +medical allowance +
house rent.
III. Using if ( )function calculate, tax which is 4 % , if gross
pay is greater than 1500, other wise 3%.
IV. Calculate net pay by subtracting tax from gross pay.
V. Using if ( ) function, assign “grade1”, if net pay is
greater than 15000,other wise “grade 2”.
FORMULA
1. =8/100*b2
2. =40/100*b2
3. =b2+c2+d2
4. =if(e2>=15000,e2*4/100,e2*3/100)
5. =e2-f2
6. =if(g2>=15000,”grade-1”,”grade-2”)

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OBJECT 7(a) MICROSOFT WORD
Write a letter to your father requesting Him to send you rupees
9000 for hostel expenditure insert a table containing hotel
charges, charges, washing clothes, bus fare and daily
expenditure.
PROCEDURE
1. Open Microsoft word.
2. Create a text file.
3. Write a letter to your father.
4. Insert the expenditure table.
5. Insert expenses.
6. Save file and print.

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OUTPUT
Sector 14
Orange town
Karachi
16th feb 2024
My dear father,
Assalam o alikum, I hope this letter finds you well. I
wanted to provide you with an update regarding the recent
hotel expenses. I understand the importance of transparency
and want to ensure that you are informed about how the funds
were utilized during my stay.
I have attached the detailed invoice and receipts for your
reference. The breakdown includes the nightly rate, taxes, and
any incidentals incurred during my stay. Rest assured that I
made an effort to minimize any unnecessary expenses and
adhered to a prudent spending approach.
hostel mess Washing Bus fair Daily
charges charges cloths expenditure.
2100 3400 1000 1500 1000
If you have any questions or concerns about the
expenses, please feel free to reach out. I am more than willing
to discuss any aspect of the trip and provide additional
information as needed.
Thank you for your understanding and support. I look
forward to hearing from you soon.
Your loving son
Xyz.

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OBJECT 7(B) MICROSOFT EXCEL
Create an print a spread sheet according to the given
instructions.
INSTRUCTIONS:
1. Calculate gross amount = labour cost + capital cost +
miscellaneous cost.
2. Calculate the net amount = gross amount – 2% of gross
amount.
3. Sale price = 30% of net amount + net amount.
4. Calculate profit = sale price – net amount.
TABLE:
ITEM LABOU CAPITA MISCCELLANEOU GROSS NET SALE PROFIT
R COST L COST S COST COST AMOUN PRIC
T E
Motor 5100 95000 5000
bike
Car 15000 200000 20000
Cultus 20000 300000 30000
Wagon 22000 350000 28000
R
High 19000 290000 18000
roof
PROCEDURE:
1. Double click on ms excel.
2. Choose a new document.
3. Now create a spread sheet.
4. Fill the blank columns using formulas.
5. Save the file and print it.
FORMULAS:
1. gross amount = labour cost + capital cost + miscellaneous
cost.
2. net amount = gross amount – 2% of gross amount.
3. Sale price = 30% of net amount + net amount.
4. Calculate profit = sale price – net amount.

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OBJECT 8(a) MICROSOFT WORD
Write an application to your principal asking him for leaving
certificate change the typeface of the entire document to 14
points, “Time new Roman” change the page background using
fill effect with picture save and print it.
PROCEDURE
1. Open Microsoft word.
2. Create a text file.
3. Write an application to your principal.
4. Change font to Time new roman.
5. Change the font to 14
6. Insert a background using fill effect.
7. Save file and print.

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OBJECT 8(B) MICROSOFT EXCEL
Create a marksheet slash certificate of internal exam by
following instruction.
INSTRUCTIONS
1. Use sum ( ) function to find out the total marks of each
student.
2. Calculate the percentage of each student.
3. Using if ( ) function assign the grade according to the
falling criteria.
a. If percentage is greater than is equal to 70, print “A-
grade”.
b. If percentage is greater than is equal to 60, print “B-
grade”.
c. If percentage is greater than is equal to 50, print “C-
grade”.
TABLE
Nam Compu Physi Engli Urd Tota Percenta Grad
e ter Mat cs sh u l ge e
Science h
Asad 89 78 97 93 87
Imra 65 97 77 77 98
n
Farha 79 78 98 33 68
n
Yosu 97 67 69 74 98
f
Izhan 99 79 63 82 58
PROCEDURE:
1. Double click on ms excel.
2. Choose a new document.
3. Now create a spread sheet.
4. Fill the blank columns using formulas.
5. Save the file and print it.

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
FORMULA
1. =SUM(B3:F3)
2. =G3*100/500
3. =IF(H3>=70,"A-Grade",IF(H3>=60,"B-Grade","C-Grade"))

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OBJECT 9(A) MS WORD:
Write a letter to your uncle thanking him for your birthday gift and apply a page
border to your document and give date at the top centre of the page along with the
time at the bottom centre of your page and use double spacing line left for your
document and use the font TAHOMA 11.

PROCEDURE:

 Double click on ms word.

 Now choose a new document.
 Write a letter.
 Apply date in header at top center.
 Apply time in footer center.
 Use font TAHOMA 11.
 Give a border to your document.
 Use double line spacing.
 Save the file and print it.

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OUTPUT:
ABC road,

Karachi.

Date: 3/4/204

Dear uncle,

I am fine here by the grace of Allah and hope same for you . Uncle I received your last
letter along with the birthday gift that you send to me.

I was really glad when I opened it , you know I had saved money to buy those football
shoes and you gifted me the same one . I really want to thank you for that , I cant define
my happiness level for these shoes .

Now I want to give you a surprise too as you gave me , Uncle we are coming to Dubai this
week end along with grandma. Dad just informed me this the day before and I was like
wooww! So uncle be ready we will leave on 5/3/2024 and will reach to you around
6/3/2024.

Now give me permission to leave and pay my regards to aunt and ali and thank you so
much again for that gorgeous gift.

Allah Hafiz!

Yours truly,

xyz

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OBJECT 9(b) MS EXCEL
Create and print a spread sheet with the following data
instructions:
INSTRUCTIONS:
 Use sum() function , calculate departmantive total.
 Use sum() function , calculate grand total.
 Find minimum , maximum , & average expenditure for
each quarter using statistical function , average() , min() ,
max().
TABLE:
PAKISTAN ENGINEERING BOARD (EXP : 2024)
DEPARTMENT 1ST QTR 2ND QTR 3RD QTR 4TH QTR TOTAL
Engineering 25676 45451 61660 55335
Marketing 67567 43434 66554 54545
Sales 64219 56564 21222 32121
Purchase 35651 21312 23122 88323
Production 12323 15432 77622 76543
Grand total
Minimum
Maximum
Avearge
PROCEDURE:
 Double click on ms excel.
 Choose new document.
 Create spread sheet using given ins and formulas.
 Save the file and print it.
FORMULAS:
 Sum() to calculate total.
 Sum() to calculate grand total.
 Min(B2 : B6).
 Max(B2 : B6).
 Average(B2 : B6).

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OBJECT 10(A) MS WORD
Using word processor create a vertically dotted line
representing left and right margin on paper for different
paragraphs.

PROCEDURE:
 Double click on ms word.
 Choose new document.
 Create the document from given ins.
 Save the file and print it.

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OUTPUT

Real Madrid, is a Spanish professional football club based in Madrid. The

club competes in La Liga, the top tier of Spanish football.
Founded in 1902 as Madrid Football Club, the club has traditionally worn a white
home kit since its inception. The honorific title real is Spanish for "royal" and was
bestowed to the club by King Alfonso XIII in 1920 together with the royal crown
in the emblem. Real Madrid have played their home matches in the 83,186-
capacity Santiago Bernabéu in central Madrid since 1947. Unlike most European
sporting entities, Real Madrid's members (socios) have owned and operated the
club throughout its history. The official Madrid anthem is the "Hala Madrid y nada
más", written by RedOne and Manuel Jabois.[6] The club is one of the most
widely supported in the world, and is the most followed football club on social
media according to the CIES Football Observatory as of 2023[7][8] and was
estimated to
be worth $6.07 billion in 2023, making it the world's most valuable football club.
[9] In 2024, it was the highest-earning football club in the world, with an annual
revenue of
€831.4 million.[10]

In domestic football, the club has won 70 trophies; a record 35 La Liga titles,
20 Copa del Rey, 13 Supercopa de España, a Copa Eva Duarte and a Copa de la
Liga.[11] In International football, Real Madrid have won a record 32 trophies: a
record 14 European Cup/UEFA Champions League titles, a joint record five
UEFA Super Cups, two UEFA Cups, a joint record two Latin Cups, a record
one Iberoamerican Cup, and a record eight FIFA Club World championships.
[note 1] Madrid was ranked first in the International Federation of Football
History &
Statistics Club World Ranking for 2000, 2002, 2014, 2017.[15] In UEFA, Madrid
ranks first in the all-time club ranking.[16][17]

Being one of the three founding members of La Liga that have never
been relegated from the top division since its inception in 1929 (along
with Athletic Bilbao and Barcelona), Real Madrid has many long-
standing rivalries, most
notably El Clásico with Barcelona and El Derbi Madrileño with Athletico madrid.

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OBJECT 10(b) MS EXCEL
Create and print utility bill of SUI gas with the following data
instructions:
INSTRUCTIONS:
Calculate the nits consumed.
Using if() , calculate the gas charges as 10.5/unit if the units
consumed are less than 200 , otherwise 15.50/unit.
Calculate sales tax on 10% of gas charges.
Calculate amount payable = gas charges + sales tax
TABLE:
SUI GAS UTILITY BILL EXP(2024)
METER PREVIOU CURRENT UNITS GAS SALE AMOUNT
UNIT S UNIT UNITS CONSUMED CHARGES TAX PAYABLE
3001 7382 7393
3002 88829 88840
3003 454512 454902
3004 13900 1400
3005 93248 92583
PROCEDURE:
Double click on ms excel.
Choose new document.
Create utility bill of suii gas using given ins and formulas.
Save the file and print it.
FORMULAS:
C2-B2.
IF(D2<200 , D2*10.5 , D2*15.5).
10/100*E2.
E2+F2.

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OBJECT 11(a) MS WORD
Write an invitation to a friend invited her to your birthday Party.
Give page border to your invitation inside graphic from event
category set page orientation at landscape.
PROCEDURE
 Double click on ms word.
 Choose new document.
 Create the document from given instruction.
 Set page orientation to land scape.
 Save the file and print it.

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OBJECT 11(b) MS EXCEL
Create, save and print marksheet of internal exams using given
instructions.
INSTRUCTIONS
1. Calculate percentage of each student .
2. Using if ( ) function assign remarks according to the
following criteria.
a. If percentage is greater than equal to 80, print
“EXCELENCE”
b. If percentage is greater than equal to 70, print “V
GOOD”
c. If percentage is greater than equal to 60, print
“GOOD”
d. If percentage is greater than equal to 50, print “FAIR
else POOR”
TABLE
MARKSHEET
NAME COMP PHYS ENGL MA UR TOT PERSEN REMA
UTER ICS ISH TH DU AL TAGE RKS
ASAD 89 78 78 89 76
ALI 90 98 86 99 84
AHME 47 87 34 76 55
D
AMMA 78 92 47 89 65
R
SHAH 67 87 86 88 85
MEER

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36

OBJECT 12(a) MS WORD

Draw a 3D box in your document, write “computer science” in it
using word art.
PROCEDURE
 Double click on MS WORD.
 Choose new document.
 Create the document from given instruction.
 Insert 3d box and write computer science.
 Save the file and print it.

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36

Comput
er
The Evolution and Impact of Computer Science
Science
Computer science, a discipline that has revolutionized the
modern world, encompasses a vast array of theories,
algorithms, and technologies. From its humble beginnings as a
niche field in mathematics and engineering, computer science
has grown into a pervasive force shaping every aspect of
human life. This essay delves into the evolution and impact of
computer science, tracing its journey from theoretical concepts
to practical applications that permeate our daily existence.

Foundations of Computer Science:

The foundations of computer science can be traced back to the

mid-20th century with the advent of electronic computers.
Pioneers such as Alan Turing, Claude Shannon, and John von
Neumann laid the groundwork for the theoretical underpinnings
of computing. Turing's concept of the Turing machine,
Shannon's work on digital circuits and information theory, and
von Neumann's architecture for stored-program computers
provided the theoretical foundation upon which modern
computers are built.

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OBJECT 12(b) MS EXCEL
Create, save and print a spreadsheet with the following data
and instructions.
INSTRUCTIONS
1. Use sum( ) to find out the total expenditure of province in
year.
2. Select the rows enclosed in rounded rectangle to create a
line chart showing the trend in the expenditure over the
year using chart wizard. Title the chart “Total expenditure”.
TABLE
Expenditure of different province (2024).
Province 1st qtr 2nd qtr 3rd qtr 4th qtr Total
s
Sindh 442.5 521 453.4 396.1
Punjab 867 735.8 630.1 776
Baluchist 235.83 361.8 301 307.3
an
KPK 399.5 405 363 286.4

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OBJECT 13(a) MS WORD
Write an application to principal requesting him to sanction
rupees 3000 For the purchase of sports item inside a table
containing serial number, items, quantity and price.
PROCEDURE
 Double click on MS WORD.
 Choose new document.
 Create the document from given instruction.
 Insert table infill with the given instructions
 Save the file and print it.

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OUTPUT
To,
The principal,
AGSC,
Karachi.

Subject: Request for Financial Assistance for Purchase of

Sports Items

Dear principal,
I hope this letter finds you in good health and high spirits.
As a dedicated member of the community, I am writing to
request financial assistance for the purchase of sports items
essential for the enhancement of our school's athletic program.

As you are aware, physical education and extracurricular sports

activities play a crucial role in the holistic development of
students. They promote teamwork, discipline, and a healthy
lifestyle among our students.i am inserting the table according
to need.
S.NO Item Quantity Price
1 Badminton 2 pair 1200
2 NET 1 200
3 NET stand 1 pair 600
4 Shuttle cork 12 pices 1000
Thank you for your attention to this matter. I eagerly await your
positive response.
You’re sincerely.
XYZ
DATE: 29 February 2024 Class XI

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OBJECT 13(b) MS EXCEL
Create save and print a spreadsheet with the following data
and instructions.
INSTRUCTIONS
1. Use sum( ) to find out the total expenditure of province in
year.
2. Select the rows enclosed in rounded rectangle to create
Pie chart showing the trend in the expenditure over the
year using chart wizard. Title the chart “Total expenditure”.
TABLE
Expenditure of different province (2024).
Province 1st qtr 2nd qtr 3rd qtr 4th qtr Total
s
Sindh 442.5 521 453.4 396.1
Punjab 867 735.8 630.1 776
Baluchist 235.83 361.8 301 307.3
an
KPK 399.5 405 363 286.4

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OBJECT 14(a) MS WORD
Write an application to your principal requesting him to grant
you leave for seven days you single spacing and left alignment
Change the typeface of the entire document to 12 point Arial
save and print your documents
PROCEDURE
 Double click on MS WORD.
 Choose new document.
 Create the document from given instruction.
 Change the typeface of the entire document to 12 points,
Ariel.
 Save the file and print it.

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OUTPUT
To,
The principal
AGBC
KARACHI
Subject: Request for Seven Days Leave

Dear Principal

I hope this letter finds you in good health and spirits. I am writing to request a leave
of absence from school for seven days. Because I have some word due to my big
brothers weeding

During my absence, I will ensure that I catch up on any missed assignments or

coursework to minimize any disruption to my academic progress. I will also
coordinate with my teachers to obtain any necessary materials and ensure a smooth
transition upon my return.

I understand the importance of consistent attendance and academic engagement,

and I assure you that I will prioritize my studies upon my return to school. I am
committed to maintaining high academic standards and contributing positively to the
school community.

Thank you for considering my request. I kindly request your approval for the
aforementioned leave of absence. If you require any further information or
documentation, please do not hesitate to contact me.

Yours sincerely,
XYZ
Class XI

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OBJECT 14(b) MS EXCEL
Create and print a utility bill of electricity.
INSTRUCTIONS
1. Enter a formula to calculate units consumed.
2. Cost of one unit of electricity is 2.06.
3. Compute Surcharge as 15% of electricity Charges.
4. Calculate the Amount Payable as: Amount Payable =
Electricity Charges + Surcharge.
5. Round up the amount payable to one decimal place using
round () function.
TABLE
Meter Previou Current Unit Electric Surchar Amount
Number s unit unit consum ity ge tax payable
ed charges
MN- 69236 7000
1101
MN- 14011 14638
1102
MN- 76321 76428
1103
MN- 38476 38890
1104
MN- 4853 4996
1105

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OBJECT 15(a) MS WORD
Create a simple dot TXT file using WordPad type some text
then copy one time and past five times also apply text
formatting including font name font style and font size to each
line save and also print.
PROCEDURE
 Double click on MS WORD.
 Choose new document.
 Create the document from given instruction.
 Type any text then copy one time and paste 5 times.
 Save the file and print it.

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OUTPUT
Computer science, a discipline that has revolutionized the modern world, encompasses a vast array of theories,
algorithms, and technologies. From its humble beginnings as a niche field in mathematics and engineering,
computer science has grown into a pervasive force shaping every aspect of human life. This essay delves into
the evolution and impact of computer science, tracing its journey from theoretical concepts to practical
applications that permeate our daily existence.

Computer science, a discipline that has revolutionized the modern world,

encompasses a vast array of theories, algorithms, and technologies. From its
humble beginnings as a niche field in mathematics and engineering, computer
science has grown into a pervasive force shaping every aspect of human life. This
essay delves into the evolution and impact of computer science, tracing its journey
from theoretical concepts to practical applications that permeate our daily
existence.Line 1: Arial, Regular, 12pt

Computer science, a discipline that has revolutionized the modern world, encompasses a vast array of theories, algorithms, and technologies. From its humble
beginnings as a niche field in mathematics and engineering, computer science has grown into a pervasive force shaping every aspect of human life. This essay
delves into the evolution and impact of computer science, tracing its journey from theoretical concepts to practical applications that permeate our daily
existence.Line 2: Times New Roman, Italic, 7pt

Computer science, a discipline that has revolutionized the modern world, encompasses a vast array
of theories, algorithms, and technologies. From its humble beginnings as a niche field in
mathematics and engineering, computer science has grown into a pervasive force shaping every
aspect of human life. This essay delves into the evolution and impact of computer science, tracing its
journey from theoretical concepts to practical applications that permeate our daily existence .Line 3:
Calibri, Bold, 11pt

Computer science, a discipline that has revolutionized the modern world, encompasses a vast array of theories,
algorithms, and technologies. From its humble beginnings as a niche field in mathematics and engineering,
computer science has grown ino a pervasive force shaping every aspect of human life. This essay delves into
the evolution and impact of computer science, tracing its journey from theoretical concepts to practical
applications that permeate our daily existence.Line 4: Verdana, Underline, 8pt

Computer science, a discipline that has revolutionized the modern world, encompasses a vast array of theories, algorithms,
and technologies. From its humble beginnings as a niche field in mathematics and engineering, computer science has grown
into a pervasive force shaping every aspect of human life. This essay delves into the evolution and impact of computer
science, tracing its journey from theoretical concepts to practical applications that permeate our daily existence.Line 5:
Courier New, Regular, 9pt

ADAMJE GOVT SCIENCE COLLEGE

 ROLL NO 36
OBJECT 15(b) MS EXCEL
Create save and print a spreadsheet with the following data
and instructions.
INSTRUCTIONS
1. Use sum( ) to find out the total expenditure of province in
year.
2. Select the rows enclosed in rounded rectangle to create
bar showing the trend in the expenditure over the year
using chart wizard. Title the chart “Total expenditure”.
TABLE
Expenditure of different province (2024).
Province 1st qtr 2nd qtr 3rd qtr 4th qtr Total
s
Sindh 442.5 521 453.4 396.1
Punjab 867 735.8 630.1 776
Baluchist 235.83 361.8 301 307.3
an
KPK 399.5 405 363 286.4

ADAMJE GOVT SCIENCE COLLEGE