All 8 questions from the West African Examinations Council (WAEC) Data Processing 2023 Theory paper, with the correct answer and a full explanation for each. Free, no signup needed.
Advertisement
6(a). Explain the steps in changing orientation and printing a document in MS Word.
Model answer
Steps: Click on the 'Home' tab; Click on 'Page Layout'; Click on 'Orientation'; Select 'Landscape'; Select A4 under (paper) size; Click on file; Click on Print/Ctrl+P; Select printer; Click Ok/Print button.
6(b)(i). Name the concept used to keep the headings of a worksheet fixed while scrolling. 6(b)(ii). State the steps to keep the headings fixed.
Model answer
(i) Name of concept used: Freeze pane. (ii) Steps to keep the headings fixed: Select the heading row to freeze; Select Freeze pane on the View tab; Select Freeze Top Row from the drop-down menu.
6(a)(iii). State the actions to display each student record at the same time on both versions of the result file. 6(a)(iv). State the steps to achieve the named actions in 6a(iii).
Model answer
(iii) Actions to display each student record at the same time on both versions of the result file: I. View side-by-side; II. Synchronous scrolling. (iv) Steps to achieve the named actions: Open the two files (revisions); While on the current file, click on view side-by-side on the view tab.
[MS Word/PowerPoint General] What are the concepts of a laptop, computer, and audience aids in an auditorium?
Model answer
Concept of a laptop/computer to an audience in an auditorium includes: Projector; Smart board/Smart TV; White board/plain wall/projection screen; VGA cable; HDMI cable; Casting devices/wireless adapter; USB cable; Audio System; Laptop stand; Presenter/Laser pointer.
[WAEC Data Processing 2] 1. State the functions of the following Utility Software: (a) Disk space analyzer; (b) Backup utility; (c) Register cleaner; (d) File manager; (e) Uninstaller.
Model answer
(a) Functions of Disk space analyzer: Provides a display of summary of disks/drives, folders and files, and sizes; Provides information on used and available space on the disks/drives; Identify/indicate old/redundant files for optimization; Scan the computer to generate a report detailing everything that uses disk space; Monitor disk usage; issue alerts about low disk space. (b) Functions of Backup Utility: Create duplicate/copies of data/file/applications for recovery/retrieval in the event of data failure/accidental deletion; Allow the user to copy selected files on the entire hard disk/tape content to desired location; Compresses the duplicate of copied files/folders; Monitors the copying process and prompts the user of additional disk if required. (c) Functions of Registry cleaner: Scans/Cleans windows registry; Optimizes windows registry; Removes redundant items from the windows registry. (d) Functions of File manager: Creates, opens and closes files/folders; Writes data to files, and read data from files; Creates directories, determines characteristics of files and directories, and copy files; Provides a user interface to manage/organise files and folders; Provides a convenient way of performing routine tasks. (e) Functions of Uninstaller: Removes installed programs/applications; Removes other software or parts of it from a computer; Removes profile files of a program.
[WAEC Data Processing 2] 2(a)(i). What is Malware in computing? 2(a)(ii). List 8 types of Malwares. 2(b). Mention six effects of Malware to the computer system. 2(c). Mention six ways of removing Malware from a computer system.
Model answer
(a)(i) Malware in computing: It is a malicious software/any software/program that disrupts computer operations; any software that gains access to a private computer system to gather sensitive information or display unwanted/unsolicited adverts; a malicious software that is harmful to the computer or its user. (ii) Types of Malware: Multipartite virus; Resident virus; Browser Hijacker; Webscripting virus; Macro virus; Computer Virus; Overwrite virus; Direct Action virus; Polymorphic/Metamorphic virus; Rogueware; Backdoor (Trapdoor); Computer virus; Worm; Spyware; Adware; Scareware. (b) Effects of Malware infection: Increased CPU usage; Network connection problems; Modification or deletion of files; Unusual behaviour of running programs; Appearance of strange files/programs/Glitching of programs or desktop icons/tools; Slow computer speed/strange computer behaviour/performance; Unusual popups; Freezing; Unusual error messages. (c) Ways of preventing/removing malware infection: Installation of antivirus/antimalware/antispyware program; Regular update of installed antivirus/antimalware program; Do not visit suspicious sites; Do not click on suspicious links; Do not download suspicious email attachment; Use secure WiFi/Internet access; Do not accept unknown friendship request; Configuration/installation of firewall; Updating of software and operating system; Scanning of files before downloading.
[WAEC Data Processing 2] 3(a). Mention five group of people making use of a computer system. 3(b)(i). Mention five tools found in Corel Draw. 3(b)(ii). Mention the functions of the tools in 3b(i). 3(c). Mention five uses of Corel Draw.
Model answer
(a) Computer professionals using CorelDraw in the performance of their duties: Graphic artist/designer; Web designer; Computer teacher/Educator; Computer operator; Technical writers. (b) Tools in the CorelDraw Tool box include (five examples): Pick Tool — used to select, size, skew, and rotate objects; Shape Tool — used to edit the shape of objects; Rectangle Tool — used to draw rectangles and squares; Ellipse Tool — used to draw ellipses and circles; Text Tool — used to type words directly on the screen as artistic or paragraph text. (Other tools include the Table Tool, used to draw and edit tables; Smart Fill Tool, used to create objects from enclosed areas and apply a fill to them; Zoom Tool, used to change the magnification level in the drawing window.) (c) Uses of CorelDraw as application software: Design of magazine; Design of newspaper; Design of books/brochures; Making illustration; Designing of logo; Design of calendar/almanac; Design of post cards; Design of Invitation Cards; Design of Complimentary Cards; Design of Art works; Design of posters; Design of Handbills/Labels; Design of Letterheads; Design of Banner/Flexes; Layout design; Conversion of Bitmap images to vector objects; Edit images/Photographs.
[WAEC Data Processing 2] 4(a)(i). State the difference between Fragmentation and Replication in Database management system. 4(a)(ii). State two advantages of replications. 4(b)(i). State the types of fragmentation. 4(b)(ii). Outline the examples of relational database management system.
Model answer
(a)(i) Difference between Fragmentation and Replication: Fragmentation: Refers to the breaking down of a relation into fragments/small portions. There is no duplication of data, database objects, or databases. The splitting up of parts of the overall database across different sites. Replication: Refers to duplication of data or database objects or database from one database to another. There is duplication of data, database objects, or databases. The process of maintaining up-to-date data across different sites. (ii) Two advantages of replication: Improved availability of data; Faster query evaluation/retrieval; All resources are equally replicated regardless of their popularity/same across locations; Replicas have utilization rate proportional to their query rates, Improved scalability; Improved fault tolerance; Simplified backup and disaster recovery; Localised access. (b)(i) Types of fragmentation: Horizontal fragmentation; Vertical fragmentation; Hybrid fragmentation. (ii) Examples of Relational Database Management System: Oracle; MySQL; MSQL; Microsoft SQL server; DB2/IBM DB2; PostgreSQL; SQLite; MariaDB; Microsoft Access; Oracle Database; IBM Informix; Apache Derby; H2 Database Engine; Amazon Relational Database Service (Amazon RDS); Sybase ASE.
Advertisement
…and/or go further with premium services and No Ads.