WAEC Data Processing 2020 past questions and answers

The use of Visual Display Unit was a major breakthrough in the

1. A.First generation computers.
2. B.second generation computers.
3. C.third generation computers.
4. D.fifth generation computers.

In hexadecimal system, D is equivalent to

1. A.15.
2. B.14.
3. C.13.
4. D.10.

A teacher computed the average score of students in a given test. The result of the computation describes

1. A.record.
2. B.information.
3. C.data.
4. D.file.

The sum of 110₂ and 101₂ is

1. A.1101₂.
2. B.1110₂.
3. C.1100₂.
4. D.1011₂.

One advantage of the first generation computers is

1. A.processing speed.
2. B.portability.
3. C.heating effect.
4. D.burglar-proof.

Magnetic Ink Character Recognition is applied on

1. A.voice recognition devices.
2. B.mobile devices.
3. C.large data capturing machines.
4. D.bank cheques.

Internet banking entails

1. A.applying computer networks in banking operations.
2. B.applying computers to automate banking operations.
3. C.generating tokens and One-Time-Passwords for online payments.
4. D.using ATM for banking operations.

Which of the following parts of the computer ensures the smooth operation of its hardware?

1. A.Main memory.
2. B.Control unit.
3. C.Auxiliary storage.
4. D.Arithmetic and Logic Unit.

Basic computer operations include the following except

1. A.control.
2. B.input.
3. C.output.
4. D.process.

One disadvantage of electronic data processing is

1. A.handling complex computation.
2. B.medium for effective storage.
3. C.processing data at a phenomenal speed.
4. D.vulnerability to attack.

Which of the following sources of information is received by the user in visual mode only?

1. A.Television.
2. B.Radio.
3. C.Photograph.
4. D.Computer.

Which of the options A to D is not a medium of information transmission?

1. A.Cable.
2. B.Satellite.
3. C.Television set.
4. D.Wireless channel.

A company has four computer systems, one printer and one scanner for its daily operations. One factor that can motivate the company to connect all the devices in a network is the need to

1. A.provide efficient services.
2. B.save running cost.
3. C.share software only.
4. D.use a wireless connection.

One similarity between the internet and intranet is that they both

1. A.were invented by the same company.
2. B.use the same technology.
3. C.have the same coverage.
4. D.are open to the public.

The process of copying data or information from the internet to a personal computer is termed

1. A.browsing.
2. B.downloading.
3. C.retrieving.
4. D.surfing.

An entrepreneur who wishes to send digital data over a telephone line would need a

1. A.hub.
2. B.modem.
3. C.router.
4. D.switch.

Graphical User Interface is considered user-friendly because of the following reasons except that it

1. A.compels the user to learn all the commands before operating the system.
2. B.displays all the options available to the user for easy access.
3. C.is easier for users to operate and understand.
4. D.makes the icons and menus familiar to the user.

The symbols dialog box of MS Word application is located on the

1. A.format menu.
2. B.help menu.
3. C.insert menu.
4. D.view menu.

Pressing the key combination Ctrl + J on a selected text in a Microsoft Word document would

1. A.align the text.
2. B.deselect the text.
3. C.justify the paragraph.
4. D.juxtapose the text.

The Merge button in Spreadsheet application is used to

1. A.combine adjacent tables.
2. B.convert selected cells into a single cell.
3. C.merge two tables.
4. D.split a cell into two or more cells.

If cell A20 in MS Excel contains the value 5, then the formula “=A20^3” will return a value equal to

1. A.15.
2. B.25.
3. C.75.
4. D.125.

A database contains list of customers and their phone numbers. What type of relationship describes a customer having multiple phone numbers?

1. A.Many-to-many.
2. B.Many-to-one.
3. C.One-to-many.
4. D.One-to-one.

The DBMS statement, select* from Marksheet in table Marksheet will display all records in the fields:

1. A.ID and Name only.
2. B.ID, Score and Grade only.
3. C.Score and Grade only.
4. D.ID, Name, Score and Grade.

Which of the following objects is not located on the slide layout tab?

1. A.Animations.
2. B.Charts.
3. C.Lists.
4. D.Titles.

The following programming tools are employed by a web developer except

1. A.COBOL.
2. B.CSS.
3. C.HTML.
4. D.PHP.

Graphics can be captured using the following devices except

1. A.webcam.
2. B.scanners.
3. C.joystick.
4. D.digital camera

Which of the following substances is used for cleaning the mouse ball?

1. A.Distilled water.
2. B.Engine oil.
3. C.Isopropyl alcohol.
4. D.Kerosene.

One characteristic of a dirty mouse is that the mouse

1. A.is not recognized by the system.
2. B.unmounts itself from the system.
3. C.pointer changes appearances.
4. D.pointer moves erratically.

One responsible way of using the computer is

1. A.software piracy.
2. B.phishing.
3. C.pharming.
4. D.ethical hacking.

Any activity carried out to protect the user from hazards while using the computer is called

1. A.computer ethics.
2. B.computer maintenance.
3. C.laboratory rules.
4. D.safety measure.

In order to protect a computer on the world wide web from threats, the user should

1. A.install the latest operating system version.
2. B.install a single user antivirus software.
3. C.implement an internet security software.
4. D.deploy online transaction applications.

Responsibilities of a database administrator include the following except performing

1. A.database backup.
2. B.data recovery.
3. C.network maintenance.
4. D.user authentication.

The following tools are used for protecting the computer against virus attack except

1. A.Avast anti malware.
2. B.Kaspersky.
3. C.Norton.
4. D.Trojan horse.

Which of the following software replicates itself without being executed by the user?

1. A.worm.
2. B.Trojan.
3. C.Plug-ins.
4. D.Driver.

In the model: Furniture (Table, Chair, Wardrobe), Furniture is

1. A.a relation.
2. B.a schema.
3. C.a tuple.
4. D.an attribute.

Which of the following database operations does not require a Data Manipulation language?

1. A.Modification of information.
2. B.Insertion of new information.
3. C.Deletion of information.
4. D.Creation of information.

The file organization method which allows records to be accessed in any sequence is

1. A.index.
2. B.random.
3. C.sequential.
4. D.serial.

A file organization that has reference which identifies a record in relation to other records is called

1. A.indexed file organization.
2. B.random file organization.
3. C.sequential file organization.
4. D.serial file organization.

Providing access control to a school record is the responsibility of a

1. A.database administrator.
2. B.programmer.
3. C.systems administrator.
4. D.system analyst.

Figure 1 depicts

1. A.a distributed database.
2. B.a parallel database.
3. C.an extranet.
4. D.an intranet.

Paper 2, Section A: Short-structured questions (answer three)
(a) What is a function in MS Excel?
(b) List two categories of functions in MS Excel.
(c) What is cell referencing in MS Excel?
(d) (i) State two types of cell referencing in MS Excel. (ii) Give one example of each type in 1 (d) (i).

Paper 2, Section A: Short-structured questions (answer three)
Ciroma Chukwuma Adekunle has just opened a computer business centre within a school environment.
(a) State three computer services that may be provided in the business centre.
(b) List three devices required in the business centre.
(c) Give two application software needed in the business centre.
(d) Outline two precautions that must be taken by Ciroma Chukwuma Adekunle to ensure the safety of his computers if he must accept documents in movable devices from his customers.

Paper 2, Section A: Short-structured questions (answer three)
(a) State the keyboard shortcut keys to: (i) rotate an object in CorelDraw; (ii) position an object in CorelDraw; (iii) navigate to cell A1 in MS Excel worksheet.
(b) Give one reason for including the plus sign (+) in the search texts in a search engine.
(c) With the aid of diagrams, differentiate between LAN and WAN.

Paper 2, Section A: Short-structured questions (answer three)
A school decides to harmonize the operations of its two campuses using a distributed database system as well as install air conditioners and uninterruptible power supply in the computer laboratory.
(a) State three: (i) importance of using the distributed database system; (ii) disadvantages of using computers to process information in the school.
(b) Give two reasons for installing the: (i) air conditioners; (ii) Uninterruptible power supply devices.

Paper 2, Section B: Test of Practical Work
A Director gave a manuscript to the secretary for typesetting. The secretary is expected to provide the total number of words, lines of text, number of pages and number of paragraphs contained in the document. After proofreading the printout, the Director effected certain corrections on the printout and instructed that the corrected version be saved with the filename “updated” while the original document be saved with the filename “initial”. (a) Outline the steps the secretary would take to display the number of words, lines of text, number of pages and number of paragraphs contained in the corrected version of the document. (b) Highlight the steps the secretary would take to display the original and corrected versions of the document as well as the corrections effected on the document on the screen for the Director to see at the same time for comparison. (c) List the steps to secure the document with password in order to prevent unauthorized access to the document.

Paper 2, Section B: Test of Practical Work
You are provided with a computer system that has a Microsoft PowerPoint application running. Outline the steps to be followed in performing the following tasks; (a) creating a four-slide presentation; (b) modifying the presentation to show the following on the Footer of all slides except the title slide: A. Today's date; B. Slide number; C. Your surname. (c) inserting a picture saved in the picture folder of your computer hard drive on the second slide. (d) typing your name as the main title and personal profile as the subtitle. (e) making each slide to run for five seconds continuously until the “Esc” key is pressed during slide show.