easytvet.com 1920/1028 ‘COMPUTER APPLICATIONS I (PRACTICAL) Nowember 2017 Time: 2 hours THE KENYA NATIONAL EXAMINATIONS COUNCIL CRAFT CERTIFICATE IN INFORMATION TECHNOLOGY MODULE! COMPUTER APPLICATIONS 1 (Practical) 2 hours INSTRUCTIONS TO-CANDIDATES You have tem mimetes to read through the instructions and questions before starting the examination. Any problem with the computer should be reported o the invigilatar immediately. Direct any question(s) to the tnvigilator only. Canversing with fellaw students may lead to disqualification, Write your mame and index number on the answer booklet anc the rewritable CD. Type your name as a header on each sheet used. Answer all the four questions, Each question carries 15 marks Read the instructions of each question carefilly. Print on one side of the paper(s) only and use a fresh sheet of paper for each question. Hand aver your printouts and the rewritabte CD to the invigilator. ‘This paper consists of 9 printed pages. Candidates should check the question paper to ascertain that all the pages are printed as indicated and that no questions are missing. (02017 The Kenya National Examinations Council. ‘Turn overeasytvet.com SPECIFIC INSTRUCTIONS TO CANDIDATE, 1, Create a folder named KNECEXAM oo the desktop to store sit the werk done in this paper. 2, Ensure that the KNECEXAM folder created and all its cootent is burnt onto the Rewritable CD at the end of the examination. 1920/1028 November 2017 2 TTTeasytvet.com TASK 1 The management of Wimbo Tiles Company wishes to invite clients fora tiles exhibition in their premises. You have been tasked to prepare invitation letters using the mail merge feature in a word processor. (a) Open 4 word processing program and create a data source file of the invited clients as shown in Table 1. Save the document as siledatasource in the KNECEXAM folder to print ‘out later. (4 marks) E | SECONDNAME | BUSINESS NAME, TE RENNY TILES, 11/10/2018 JCY DURIY TILES 06/20 [JOHN I SIDDY TILES [MICHEAL | RINNY _| CHIGGY TIL Table 1 () Open a new blank word processing document and type the following main document letter. Save the document as winba in the KNECEXAM to print out later, (8 marks) P.O BOX 23456 NAINA MOBILE: 0464744935 « FIRST NAME » « SECOND NAME » « BUSINESS NAME » ‘You are invited to aticnd the tiles exhibition that is to be held on « DATE » at 8 a.m. A 50% discount will be given to those who will attend and purchase the iterns that will be on display, Yours faithfully ARINA ALOICE MARKETING MANAGER 1920/1028 Turn over November 2047 wDIRECTION TO WIMBO THES jl To wimibo Winks Tiles (©) Create a customised letter for each recipient, Save the document as individialmail in the: KNECEXAM folder to print out later. (G marks) 1920/1028 November 2017 4easytvet.com TASK 2 Wimbo Tiles Limited has a chain of branches in town. The management of the company intends to use spreadsheet to computerise transactions in the branches. (a) Opema spreadsheet program and type the information in sheet 1 as it appears in Figure | Save the workbook as tiles in the KNECEXAM folder, (6 marks) SIDDY TILES S001 2300 KE | 1700 60 CHIGGY TILES | Cool | 7000 CH] 2000 70 TYPE CODE PRICE PER BOX CH 1400 KE 1600 7 Figure 1 (6) (Copy the content of sheet | to shect 2 in the range A1;G9, (% mark) (ii) Rename sheet? as tilesales. (4 mark) (©) ()__Imsert s row above the column headings in the sheet named tilesales and insert the text "WIMBO TILE SALES” (1 mark) (ii) Apply the following format to the column headings in the sheet named sifesales as follows: 1 text orientation: 45°; (14 mark) I font type : Arial Narrow; size: 13; (0% mark) I Fill colour: tight grey; (4 mark) IV Fant color: white, (4 mark) (d) Using a funetion and absolute cell references only, calculate the cost of tiles using their corresponding prices per box for tiles that are not damaged in column G. (2 marks) (e) (2) Create an embedded pie chart named tilechart in a new sheet showing the cost of not damaged for each branch, (1 mark) 1920/1028. ‘Turn over November 2017 5easytvet.com (ii) Apply the following properties to the chart created in 1 Chart tile: % proportion of tiles not damaged; (% mark) IL Data labels: Show in percentages (%). (4 mark) (Save the changes and print out later: (1 mark) (@_tilesales sheet; Gi) tilechart chart. | | 1920/1026 November 2017 6 $$easytvet.com TASK3 The management of Wimbo Tiles would like to manage information about the tiles using a database. You have been tasked to ereate the database that will be used to manage this information. (@) Open a database program and create a database file named #imbotiles in the KNECEXAM folder (14 mark) (b) Create the following tables named fifeseades,cusidetaily and purchase respectively in the database created in (a) using appropriate data types. (9 marks) TILESCODES TILECODE|_TILENAME _| PRICE PER BOX BOO BATHROOM TILES 1700.00 Kool KITCHEN TILES 2300.00 MOOT MOSAIC TILES 3500.00 _ PURCHASE TABLE | TY TRANS| TILE | CUST DATE o cope | cope | cope | purcHasep [PURCHASED ROOL 12/16/2015 1000 sool | 9/15/2015 2000 Toor | 10/12/2015 3000 ‘Co0i 10/14/2015 3500 (c) Set appropriate primary key for each table, (1 mark) (d) Create relationship between the tables, (4 mark) (€) Create a query named roral that would display the fields transcode, tilecode and the calculated field fotalpaid for each transaction. (1 mark) (8 Create « column report for the query created in (e) and save it as toxalreport. (1 mark) (g) Print out later each of the following: (1% mark) (i) Alltables; «oy Gi 1920/1028 ‘Turn over November 2017 7 SEEeasytvet.co TASK 4 (@ Open a presentation program and use the outlines shown in Table 2 to create a presentation, Save the presentation as tilepresentation in the KNECEXAM folder. Usc appropriate slide layouts. (10 marks) z Content io WIMBO TILES COMPANY | By ARINA ALOICE | Marketing Officer 2 | Our Values: Y Customer certification Y Quality Services ¥ Integrity services 3 TYPES OF TILES ‘Bathroom tiles Kitchen tiles ‘> Mosaic tiles % Outdoor tiles 4] PRICES OF TILES AMOUNT AMOUNT/PER TILE BOX 5000 + 4000 + BATHROOM | 1700 3000 KITCHEN 2300 2000 . 1000 MOSAIC 3500 ° { & i OUTDOOR 4500 oe? =e ! - = | 3 \ END. Table 2 1920/1028 November 2017 8 = LLeasytvet.com b>) (i) Insert a blank slide after the slide 4. (4 mark) (ii) Create the following chart in the slide inserted, (18 marks) Wimbo ats Grading (cs) Apply slide animation of your choice to slide 2. (i mark) (dd) Animate the objects in slide 5 so that it introduces one object at a time. (1 mark) (e) Save the changes to print out later as handouts of three slides per page. (1 mark) ‘THIS 1S THE LAST PRINTED PAGE, 1920/1028 Navember 2017 9