SC 6183, Name? cs WASSCE (SC) 2022 COMPUTER STUDIES 3 Index Number: Practical 2 hours ‘THE WESTAFRICAN EXAMINATIONS COUNCIL, ‘West African Senior School Certificate Examination (WASSCE) for School Candidates, 2022 SC 2022 COMPUTER STUDIES 3 2hours PRACTICAL [45 marks} INSTRUCTIONS TO CANDIDATES Answer all the questions. Write your name and index number in ink in the spaces provided above. The paper consists of three questions Each candidate: @ is provided with a computer system installed with word-processing, spreadsheet, graphic, database and presentation packages, (®) taust create a folder on the desktop of his/her computer and name it* WAEC= CANDIDATE'S INDEX NUMBER? (c.g. WAEC - 4251102068, where 4251102068 is the index number ofa candidate); (©) must save hissher workin the folder created in (b) above; (@) is required to wrige his/her name and index number on every printout duly signed by the Supervisor, (@) is allowed additional five minutes at the end of the examination to print his/her finished/unfinished solutions; D smust delete hishher folder created in (b) above afier printing, (@) must submit all the printouts to the Supervisor immediately afier the examination; (h) maust not bring any storage media (e,g. flash drive, compact disk, etc) into the examination hall. cosine © 2022 The West fpican Examinations Counctl2 Answer all the questions. 1.>-Use Microsoft PowerPoint application to ereate the presentation on the topic “Computer Systems”. @ co) © (@) © @ @ a a Use title slide and type “Computer Systems” with font type Arial Black and size 44 points, Use title and content layout slide and ¢ype the following passage with font type: (title in Algerian and size 40 points: Gi) content in Times New Romaa and size 30 points. Passage DEFINITION OF COMPUTER ‘Acomputer is a device that accepts information inthe form of digitized data and manipulates it for some results based on a program or sequence of instructions on how the data isto be processed, Insert next slide and type the following using tie same font type and size as in 1(6). CLASSIFICATION OF COMPUTERS. (i) By type Gi) By Size Gi) By Purpose Gv) By Generation Insert next slide and type the following using the same font typesand size as in 1/6). CLASSIFICATION BY TYPE Digital Computer ‘Analogue Computer Hybrid Computer (Notes use bullet list for the items) Insert next slide and type the following using the same font type and size as in 1(b) CLASSIFICATION BY SIZE Micro Computer Mini Computer Mainframe @omputer Super Computer (Note? ise a different lst ype for the items) Insert next slide and type the following using the same font type and size as in 1(b). CLASSIFICATION BY GENERATION First Generation eg UNIVAC Second Generation eg HAVARD MARK II Third Generation eg IBM 360 Fourth Generation eg Microcomputer (Notes use at different list type for the items) Using Footer tool, insert your full name and index number with font size of 14 points and bold. Save your work in the folder created on the desktop using your full name as the filename, Print your work and submit to the supervisor. [15 marks} 2. Daniel James and three of his friends came up with the idea of starting a travel agency for college students in Nigeria, They invested sixty thousand naira each and started their dream company, SUMMER BREAK TRAVELS INC. As sales continued to grow, the management of Summer Break Travels Inc. realised they need a better tracking system for First Quarter Sales. Prepare a First Quarter Sales Worksheet that shows the sales for the first quarter using the details in Table 1.3 i Table1 Location Marketing Ovdets (¥) (Vacation Place) Mail Campus Telephone __|Internet Bar Beach Lagos 5,297.23 3,871.35 4.72045 | 2,998.65 ‘Trans Amusement Parke [2,823.23 | 4,840.53 2,703.56 | 4,911.16 Thadan ‘Agodi Gardens 6256.25 [7,256.12 2,435.86 ),709.32 (Obudu Park Calabar 2,856.15, 437.20 4,997.60 [1,201.45 Total @ io) Using funetion or formula, compute the total: (i) sales at each marketing outlet; (ii) amount of money made for each vacation place. (Note: create carother column “total”) Format the table using the instruction below: (i) the title “Summer Break Travels, Ine. First Quarter Sales” should be Bold and in Upper Case; (ii) under locations, all cells should be aligned left but total should be aligned right: Gii) fill the table with “white background I darker - 25”. (c) Create two charts forthe first quarter sales: (i) apie chart stating the most effective sales method; (ii) a bar chart stating the most popular vacation place. (Type in the formula used in calculating total for each location below your table (enclosed in “”). (e) Save, printout your work and submit to the supervisor. [15 marks] 3. (a) Create a: (i) database and save as WASSCE in the folder on the desktop. (i) table with headings as shown in Table 2 (11 rows). Define the fields appropriately. Save the table as thlcustomers. Set CustomID as primary key. Table 2 CustomID” FirstName LastName. Telephone. Address (ii) form from tblcustmers and save as RFORM. (b) Enter ten records of your choice using the Form created in Sai). fo) Write a query to retrieve the FirstName and Telephone. (a) Design a report using 3/6). Ye) Insert a footer and type in your full name and index number. (D Print the report and submit to the supervisor. [15 marks]