1920/102B COMPUTER APPLICATIONS I (PRACTICAL) Paper 2 March/April 2023 Time: 2 hours THE KENYA NATIONAL EXAMINATIONS COUNCIL, CRAFT CERTIFICATE IN INFORMATION TECHNOLOGY MODULEI COMPUTER APPLICATIONS I (PRACTICAL) Paper 2 2 hours INSTRUCTIONS TO CANDIDATES You have ten minutes to read through the instructions and the tasks before starting the examination. Any problem with the computer should be reported to the invigilator immediately. Direct any question(s) to the invigilator only. Conversing with fellow students may lead to disqualification. Write your name and index number on the answer booklet and the rewritable CD. Type your name as a header on each sheet used. This paper consists of four tasks. Perform all the tasks Each task carries 15 marks Read the instructions of each task carefully Print on one side of the paper(s) only and use a fresh sheet of paper for each task Hand over your printout and the rewritable CD 10 the invigilator at the end of the examination. Candidates should perform the tasks in English. This paper consists of 7 printed pages. Candidates should check the question paper to ascertain that all the pages are printed as indicated and that no questions are missing. ©2023 The Kenya National Examinations Council Turn overSPECIFIC INSTRUCTIONS TO CANDIDATE 1. Create a folder named KNECEXAM on the desktop to store all the work done on this, paper. 2. Ensure that the KNECEXAM folder and all its content is burnt onto the Rewritable CD at the end of the examination. 1920/102B 2 ‘March/April 2023,4 TASK 1 (a) Open a word processing program and create the following document as it appears. Save the document as oriena in the KNECEXAM folder. (8 marks) ORIENA JUICE Oriena Juice is a company located in Kenya and was founded in 2001. The company specializes in processing and sale of fresh fruit juices such as mango juice, orange juice, strawberry juice amongst others to different parts of the country. MISSION VISION GOAL We are dedicated to To be the leading company in We are committed to supplying healthy beverages production and supply of achieving the set goals and at reasonable prices to all healthy essential beverages focusing on end results. people of different walks of life PRICES FOR THE JUICES TYPE OF JUICE LITRES | KSHS MANGO 500ml 70.00 Mitre 120.00 | ORANGE: 500ml 80.00 litre 140.00 (>) @)_— Open a new blank word processing document and create the following data source as it appears. Save the document as orienadata in the KNECEXAM folder. (2 marks) COMPANY NAME | ADDR’ Marion Company P.O. BOX 4056-00300 Kenrita Company P.O. BOX 3456-02002 Rinna Company P.O. BOX 6734-00401 (ii) Open a new word processing document and create the invitation letter as it appears. Save the document as main in the KNECEXAM folder (2 marks) 1920/102 B 3 ‘Turn over MarcWApril 2023ORIEN JUICE COMPANY BOX 273-NAIROBL TO : «Company Name» «Address» RE: SENSITIZATION SEMINAR We invite you for a sensitization seminar on 04/07/2021 at 9.00 a.m The objective of the seminar is launching of our new juice products. Your presence will be appreciated. ‘Thanks in advance. Jared Tonny Managing Director (iii) Merge the data source in (i) with the main document in (ii) and save the merged document as orienamerged in the KNECEXAM folder. (1% marks) Save the changes to print out later each of the following: @ — oriena; (ii) orienadata; (iii) orienamerged. (14 mark) 1920/102B 4 ‘March/April 2023TASK 2 ‘The management of an organisation intends to use a spreadsheet program to computerise the earnings generated by each truck and the commission paid to each truck driver between the months of Jan to March as shown in Figure 1 TRUCK — | TRUCK FEB | MARCH DRIVERS, DRIVERS | NO TOTAL | COMMISSION Harun KIT_123__[35700| 43500 | 23000 John KRY 345 [33000] 25000] 21000 Eunia KZZ_467__| 45000 | 18000 | 17000 - Aloice KUT 383__| 45200 [33000 [22000 Martin KGG 234 [32000 | 12000| 23000 i Emest KLM 123 14500 | 23400 14500, Figure 1 7 (a) Opena spreadsheet program and key in the information in Sheet! as it appears in Figure 1 Save the workbook as TruckEarn in the KNECEXAM folder. (5 marks) (>) Perform each of the following in sheet (Insert a row above row 1; (mark) (ii) Merge and centre cells Al TO F1; (% mark) (ili) Key in the text” TRUCKS AND DRIVERS EARNINGS?” in the merged cells.(1 mark) (©) Using a function and cell addresses only compute: (i) grand total for each truck for the three months; (1 mark) (ii) the commission for each truck driver based on the following criteria (3 marks) Criteria Percentage of Grand - Total Less than or equal to 700,000 5% Greater than 700,000 10% (4) Create an embedded bar graph that compares the Earnings of all trucks for the three months and insert the chart title as “Truck Earnings”. (3 marks) (@) Save the changes to print out later the worksheet, (1 mark) 1920/102 B 5 Turn over March/April 2023TASK 3 Peacock Delivery Services Company intends to computerise its operations. You have been tasked to create a database for the company. (@) —@_—_Opema database program and create a database file named Peacock in the KNECEXAM folder. (1 mark) ii) Create the following tables in the database created in (i). Save the tables as Customer, Item and Delivery respectively. (7 marks) Customer Table Customerld | CustomerName CTOOL Fransisca CT002 John CT003 Eunice Item Table Htemld | ItemName ChargesPerKg ITOO1 | Letters 20.00 1T002_| Perishable foods 60.00 TT003_| Non-perishables 100.00 Delivery Table ‘Customerld | DeliveryDate | Itemld | Weight(kg) CTOO1L 5/17/2021 ITOO1 10 croo2 [4/19/2021 [1T001 [15 ‘CT003 @72072021 | 1ro02__| 20 CTO02 7/06/2021 JT003, 30 7 cr002 gisiz021 | 1roo1 | 15 TOOL 9/18/2021 | 1T003 [40 (iii) Create appropriate relationships between the tables. (1 mark) (b) Create forms that could be used to enter data into the Customer and Item table, Save the forms as frmeustomer and frmitem respectively. (1 mark) (©) Create a query to display the fields: CustomerName, ItemName, DeliveryDate, ChargesPerKg anda calculated field named Amountpaid given that Amount paid is the product of ChargesPerKg and Weight(Kg). Save the query as qrycharges. (3 marks) (@) Create a column report for the query created in (c). Save the report as rptcharges. (1 mark) (©) Print out later each of the following; (tables; (ii) pteharges. (1 mark) 1920/1028 6 March/April 2023TASK 4 (@) Open a presentation program and create the slides as they appear in Figure 2 using appropriate slide layouts. Save the presentation as delivery in the KNECEXAM folder. (8 marks) { Slide ‘Content No 1 PEACOCK DELIVERY SERVICES COMPANY P.O.BOX 51718-0700 NAIROBI 2 | ABOUT Us - Peacock Delivery Services Company offers delivery services to different parts of the country. We major on delivery of perishable and non-perishable goods and parcels to various parts of the country. Our main office is located along Lungalunga road Nairobi. 3 TOTAL DELIVERIES TO DIFFERENT AREAS IN THE MONTH OF APRIL AREAS DELIVERY Kisumu 15,000 Eldoret Nyeri Mombasa 4 | DELIVERIES MADE TO DIFFERENT PARTS OF THE COUNTRY : Thank You For Being a Customer Figure 2 2 (b) Insert a column bar chart in slide 4 to display the information in slide 3. (3 marks) (©) Apply each of the following to all the slides: (i) slide design of your choice; (1 mark) (ii) slide show set to loop continuously until escape key is pressed; (1 mark) (ii) insert a slide number as the footer. (1 mark) (d) Save the changes to print out later delivery as a handout of three slides per page. (1 mark) THIS IS THE LAST PRINTED PAGE. 1920/102 B a ‘March/April 2023