3 BOARD OF INTERMEDIATE EDUCATION, KARACHI HLS.C. PART 1 COMPUTER SCIENCE PRACTICA (a) Ward Create a simple ty MS-Word document Paragraph and then, Copy one time and paste five times. Also apply text formatt Foni-Name, Font-Siyle, and Font. Size to each paragraph, Save and also print 1. (b) Excel Create a Pay Roll of employees according to the instructions EXAMINATION, 2022 K Type three four lines ncluding House | Gross nce | Rent | Pay ey e ) cae ite Medical Allowance MW Caleuiat UI) Dey 12 % of Basic Pay and Hose Rent = 4 Basie P Basic Pay + Medical Allowance + House Rent n IF( ) Function to compute n 15000 otherwise it is 3%. TV) Compute Net Pay by Subt VY) Using IFC) Function, Assi Grade Gross Pay x which is 4% of the Gross P. Tax from Gross Pay Grade-1 if Net Pay is g1 15000 otherwise assign (a) Word Write a letter to your father, requesting him to send Rs. 14001 books. insert a table containing S.No. . Name of Books, Quantity and Price. 5: print (b) Excot Create and print a. spread sheet following the given instructions: ‘work Charges Hours emp | Days rotal prea | wes Keel worked oe Amount a ‘ Madiha 20 100 Be Umama 120 1D) Total Hours worked=days worded * Hours worked per day 11) Gross Amount = Total Hours worked * work charges per hour 111) Calculate Two Percent ( 2%) Income Tax of each employee. IV) Use AVERAGE ) Function , Calculate separately Average Gross Amount in « cc! tye above work sheet. V)_ Save and also print.Margin and Name Kashif wve and also print. Using Spreadsheet, Create & Print attendance register shoy attendance, @) Word Using “Word Processor” create vertically dotted line representing left and right ‘on the paper for different paragraph Alignments. Use a paragraph for justification ae \s i the Borders and Shading. nee Ainy Nasan Maaz Moma Ruwan, Noor Roshan Abdullah Hunaina, quer tN a > 2|?) >> Pee PPPPE Spee ele] 9 (>| />/2 1) Calculate Total Attendance « 1) Entera formula to calculate Percentage. MW) Sort the table on total Att ©) Word Write a passa, using header and footer, Save ing COUN’ whanece and Name, at Insert Date & me in header number in footer. = Ansert pa + Convert the docum nt in wo columns, Use drop caps in the document Insert clipart in the document (by Excel _Using Spreadsheet, Cre *() function. from your book. Using Word Processor ereate any document nd also p a utility bill of electricity according to the instructions: Meter] Previous | Current Flectricity Amount Number | Units v med | Charge | Surcharge He wU2201 12750 We a2 1523, nur 96642 = TU-s620 5853, 5996 Tormula to calculate units consumed: unit of electricity is Rs. 8.2 Amount Due {1 round up the Ny Sa anid also print1) Word Prepare an invitation card for friends, Page mane in this invitation card, insert graphic as orientation. Save and also print, Generate the following output, Grade : \ invite them to your birthday party. Give a objects from event category, Set Landscape Kashaan \ 6 ‘Nadeem 1 Shabnum si 8 = ieee | J) Use FL) functton assign Grade aecording to the following criteria: ‘). Ifthe Marks is greater than 80 Grade=A-1 1) Ifthe Marks is Less than 80 or equal to 70 Grade” A c) Ifthe Marks is Less. than 70 or equal to 60 Grade=B. a) Ifthe Marks is Less. than 60 or equal to 50 Grade~ 1) Sort the list by Marks Il) Using Bar Chart show ea IV) Saye and also Print Jy student's bar according with its » rks. (a) Word Using “Word Processor” ereate a pamphlet of A4 size paper / letter. rawing menu, Fonts and Boarders, Save and also Print. {by Excel Use Spreadsheet to create and prin instructions. Use complete it Marks Certificate according to the following ‘Computer eee Marks : = Maths|- Seience | Physies | Eagtish | Udra | op tained | PETS M HS Grade 0 37 B o | 39 yams SS. OL ‘82 so | 6&3 33 55 ag mn 67 52 68 oublenn48 | SP | 39) a ET) Function to find out the marks obtained of each student. “caintidte Percentage of exch student with Total Marks=500. Grade according to the following criteria: ‘than or equal to 80, print AY ‘than or equal to 70, print A han or equal to 60, print B print else Print F IV) 1FO Fanetion assign apt Percentage is greater {b) If Percentage is greater (©) If Percentage is greater t than or equal to 50,Use Table to Create atime table of your college, IME TABLE, 7. _(b) Excet__Use Spreadsheet to create database of 15 students which include the fields Rott ‘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. ‘ 8. @) Word Create an Award Certificate, Choose Landscape orientation, use a Page Border and insert graphic from leisure category, Save and also print. 8. (b) Excel Create spreadsheet with the following data and follow the instructions: ‘elect 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 2021”. Title ¥ —Axis Million)” Ay Display legend of chart. Pint both the worksheet and Chart,rriculum Vitae, Save and Print. PERSONAL using Tab Keys and Format Tools. HCDEMIC QUALIFICATIONS using Tables. : WORKING EXPERIENCES using Bullets: = HOBBIES using simple Format —— &) Excel Use Spreadsheet, create and print ‘Marks Certificate according to the following : Instiuctions. TIy Develop a formula vo find out phy Ses marks of Wy Calculate the Percentage of each student AM) Using 1F() funetion assign, remarks Ur percentage is greater than oF equal 10 50, print “Fair” else poor Vly Save and also print. 10, G@) Word Write an application to (he Principal, requesting him to grant you 7 G83 leave. Tice the single spacing and left aligament. Change cigs eatging, Foot: sie I2-pali Sai Name“Atiat”. Save and also print. MO. qh) Excel Create spread sheet with the {following data and Follow 1 ses in Million) Expenditure by Different Prov the instructions: ‘Balochistan NWEP Usethe SUM) ihe Toul Expenditure by province Year. fate a Pie Chart showing: Tanetion to Fin ne rounded rectangle to cre » ww, Select the columns enclosed int ‘Contribution ofeach province in Toxsl ‘Expenditure using Chard Wizard mm splay Legend of Chart Wy pata both the worksheet and Chart Page No. 9}(a) Word Write an application to your principal, asking him/her for leave certificate. Change the type face of the entire document 10 15 point Book Antiqua, Charnes the page background using Pile effects with Texture Save and also print (without back ground). spreadsheet with the following data and follow the instr ress (Expenditure2021 on AL. (hb) Facet Using the ‘Pakistan Printing P ~ Department ‘Engineer apply currency Format with 2 decimal places: culate Grand Total rage expenditure AVERAGEQ- 1) Calculate department wise Total. WW) Use the SUM () funetion to « TH) Find the Minimum, Maximum and A‘ statistical functions = MING), MAX(), and for each quarter using our book, Use MS - Word to create three columis Cap. Save n first column apply Drop fa passage from ly different Font sizes. Pe 12. (@) Word Writ each column app! and also print. (b) Exec! Use spreadshe xt name and in according to the instructions 2 Jet to Create a utility Bill of Sui Meter Number I) Develop a formula to calculate Unit Consumed. 1 Using TF) Fonetion, compa {Gas charges which are ‘consumed are less than Rs, 1.75/unit af the Units ° 200, otherwise charges are Rs. 2.75/ units. 1) Compute the Sales Tax as 15% of Gas Charges. 1V) Compute the Amount due to 1. Amount Due = Gas Charges + Sales Tax. Vy) Save and also print.Taleulate Gross amount by adding labour, 3 Calculate: Net Amount = Gross Amount + Calculate: _ Sale Prince = 30% Net Amount + Net Amount. aout profit by subtracting Net Amount from sale Price. Save and also print. 1 book -Copy one time and paste three times 5 ty Boardet ond Write a paragraph from you 4 Font Color, in the first paragraph 4 parsuraph change Font-style . Font size as vl in the second paragraph insert the picture from ‘clip art category. set Roll No. and an tion 2015 in Header and set Page No. in Footer. Save and also print. 14, (b) Excel Use spreadsheet to Create the following. ‘scholarship statement. “larship on the following range of marks, ents who obtained marks below 500, Apply formula to calculate the Scho .d to those who obtained marks No Scholarship for those st 30% Scholarship of Full Fee will be awardet between 500 10 600. ©) 40% Scholarship of Full Fee benseen 600 to 700. §) 60% Scholarship of Full Fee will be awarded to those whose secured marks © above 700. 1h Count the number of students gained Scholarship using COUNT( ) function and display in a cell below the above worksheet. Save and also print. ») will be awarded to those who obtained marks(a) Word Type the given phrase Area of circle = 2a? , Mean(n)=EX0 ae -Sin@ + Cos see f Give a border to the phrase. Copy it three changing different uy ae ae ri uterine Soe 5 @)Excel Create and print a utility bill of PTCL by following the given instructions: Where Due date is 25/6/2016 and Line rent is 174 eon Pay date | Local |Towl | Total [Mobile [CLI [Total | Ta Tora Call | Local wee | Charges: Call Es Charges | Duration | Charges: UO1 [2862016167 _—_—-| 140.7 166.0 420.7 | ae peste 8 T 02/7/2016 | 785 ae W041 09:7/2016 1) Calculate Total Local Charges @iRs. 2.10 per call WW) Calculate Total Mobile Charges @Rs. 3.0 per minute UW) Calculate Total Call Charges as: 4 f Total Call charges = total Local Charges ~ Mobile Charges + Line rent > cu Be WW) Calculate tax as 17%of Total Call Charges a Vy Using IFO function. Compute total dues if pay date is within due date as: Total Dues =Total Call Charges + Tax, Otherwise id pay date is after Due date. Total Dues = Total Call Charges + Tax + 5.01% of Surcharge Marks Distribution iva Vice tical file____ [College theory/Practic UMS Word Procedure. ee Head Examiner SHAHZADA WASEEM SHAHID “Associate Professor in Computer Se. ‘Govt, Deerce College for Boys 7 D/2 forth, Kaichi ‘