WAEC Data Processing 2024 past questions and answers

The Stepped Reckoner was developed by.

1. A.Gottfied Leibnitz.
2. B.Herman Hollerith.
3. C.John Von Neumann.
4. D.William Schickard.

The binary number 100101₂ can be written in denary as

1. A.25.
2. B.37.
3. C.45.
4. D.211.

The first stage in computer data processing procedure is

1. A.collection of data.
2. B.communication of information.
3. C.conversion of data
4. D.manipulation of data

One advantage of electronic data processing is that it

1. A.involves special skill.
2. B.deals only with simple data.
3. C.is completely error-free.
4. D.handles complex data.

The type of computer that has the ability of counting in discrete form is referred to as.

1. A.analogue computer.
2. B.digital computer.
3. C.hybrid computer.
4. D.versatile computer

One reason for using Computer Aided Design in manufacturing is that.

1. A.it uses few system resources.
2. B.manufacturing time is reduced.
3. C.designers do not need training to use it.
4. D.3D designs are easily produced with it.

Which one of the following statements is true about Voice Over IP? It.

1. A.converts voice and video data into a digital signal and transfers it over the Internet.
2. B.converts voice and video data into a digital signal and broadcasts it via a transmitter.
3. C.is a voice over communication system which is cyber-attack proof.
4. D.is a circuit-switched data communication system.

Which one of the following sets of devices can be used to store data during processing?

1. A.Cache, RAM and Register
2. B.Cache, Register and ROM.
3. C.Flash Drive, ROM and Hard Disk Drive.
4. D.RAM, Register and Zip Drive.

The process of inspecting, transforming and modeling data to get useful information is known as

1. A.collation.
2. B.interpretation.
3. C.execution.
4. D.analysis.

One disadvantage of using computer for information processing is.

1. A.need for staff retraining.
2. B.increased running cost in the long run.
3. C.the increase in storage space.
4. D.redundancy of computers in the long run

The diagram in figure 1 illustrates a process called

1. A.Information processing.
2. B.information transmission.
3. C.modulation.
4. D.synchronization.

The transmitter in communication is the component that

1. A.decodes sender's signal by interpretation.
2. B.encodes interpreted data by using machine language.
3. C.broadcasts synchronous signals.
4. D.launches signal into air.

Which of the following resources is not usually shared in a network?

1. A.VGA projector.
2. B.Laserjet printer.
3. C.Folder.
4. D.File

Factors to be considered when creating a backup system in a computer network include

1. A.amount of RAM, amount of data and time of backup.
2. B.amount of RAM, type of data and frequency of backup.
3. C.media to use, amount of data and frequency of backup.
4. D.media to use, type of data and time of backup.

The URL www. exams.edu.ng represents the website of

1. A.an examination body.
2. B.a Nigerian-based learning institution.
3. C.an educational institution in Niger.
4. D.a research institution in Niger.

The Post Office Protocol (POP) is used to

1. A.interconnect devices on the Internet.
2. B.retrieve email from a mail server.
3. C.transfer file from a server to a client.
4. D.send email from one user to another.

Header and Footer are added to a document in MS Word by just clicking on the.

1. A.Edit menu.
2. B.Format menu
3. C.Insert menu
4. D.View menu

A typist positioned the insertion point at the beginning of a line of text in a word processor and then pressed down the Shift key and clicked at the opposite end of the text. What would be the result of this action? The text will be.

1. A.copied into the clipboard
2. B.cut into the clipboard.
3. C.deleted from the storage.
4. D.highlighted on the screen.

The Microsoft Excel menu bar icon shown in Figure 2 is used to

1. A.automatically add up selected values.
2. B.create label that spans multiple columns.
3. C.spot trends and patterns in user's data using bars, columns and icons.
4. D.organize data for easy analysis.

To add a new column to the right of the IGR column on the interface in Figure 3, the user would.

1. A.right-click on cell C1 and then click on insert.
2. B.right-click on cell D1 and then click on insert.
3. C.right-click on column C and then click on insert.
4. D.right-click on column D and then click on insert.

The function of the foreign key in a database is to

1. A.uniquely identify tuples in a table.
2. B.provide a link between data in two tables.
3. C.uniquely identify an entity occurrence.
4. D.uniquely identify each record in a table.

Use Figure 4 to answer questions 23 and 24.
Which of the following lists contains the primary keys in Figure 4?

1. A.Customers, Orders and Products.
2. B.customerId, OrderId, ProductId.
3. C.CustomerId, FirstName, LastName and DateCreated.
4. D.Customers, CustomerId, FirstName, LastName and DateCreated.

One precautionary measure taken when cleaning a monitor is

1. A.covering the monitor with antiglare.
2. B.cleaning the monitor with alcohol.
3. C.unplugging the power supply cable.
4. D.using a vacuum cleaner to dust the monitor casing

Which one of the following practices is considered ethical?

1. A.Gaining access into school database to change one's grades.
2. B.Gaining access into government database to alter personal details.
3. C.Logging into a friend's social media account to read inbox messages.
4. D.Signing into school e-library to read e-books.

Proper network implementation and good ICT policies are types of

1. A.adaptive measures.
2. B.corrective measures.
3. C.perfective measures.
4. D.preventive measures.

Preventive maintenance measures in the computer room include the following options except

1. A.good ventilation.
2. B.proper illumination.
3. C.the use of rugs.
4. D.the use of tiles.

A database administrator is responsible for the following tasks except

1. A.controlling and monitoring user access to the database.
2. B.enrolling users and maintaining system security.
3. C.maintaining archived data.
4. D.maintaining connection between local network and the Internet.

A malware that copies and replicates itself using computer network and security flaws is

1. A.Rootkit virus.
2. B.Spyware.
3. C.Trojan horse.
4. D.Worm

The entities in Figure 6 are named

1. A.RegNo, Name and Age.
2. B.Musa, Uche and Bayo
3. C.Student and Subject.
4. D.Maths, Eng and DP

Which one of the following statements is true about database tables?

1. A.All the tables in a database have a common name.
2. B.A table may contain repeating groups.
3. C.Entries in a column are from different domains based on datatype.
4. D.There are no duplicate rows in a table.

The major difference between serial and sequential files is that sequential files are.

1. A.given a key.
2. B.sorted in a particular order.
3. C.stored as they come.
4. D.recorded in any storage medium

Which one of the following pairs contains computer file classification?

1. A.Master file and Serial file.
2. B.Random file and Master file.
3. C.Reference file and Random file.
4. D.Transaction file and Master file

Which of the following statements support the goals of data backup? I. Need for duplication. II. Need for future reference. III. Protection against data loss.

1. A.I and II only.
2. B.I and III only
3. C.II and III only.
4. D.I,II and III

Which of the following characteristics is associated with the architecture of parallel database?

1. A.Communication cost and problems cannot be ignored
2. B.Machines can be far from each other.
3. C.Machines are physically close to each other.
4. D.It is usually associated with shared-nothing architecture.

Paper 2, Section A
(a) State four benefits of Internet in Education. (b) Explain the following types of maintenance in computing. (i) corrective; (ii) adaptive; (iii) preventive.

Paper 2, Section A
(a) (i) Define the term file organization. (ii) Group the following file organization attributes under the appropriate heading as shown in Table I. (I) It does not support use of tapes. (II) Records are inserted one after the other. (III) It does not generate random keys to identify location. (IV) It generates random key to identify location.
(b) (i) State two safety rules observed in a computer laboratory. (ii) List three internet browsers.

Paper 2, Section A
(a) Explain the use of Custom Slide Show in Microsoft Power Point application.
(b) State two functions of Rehearse Timings in Microsoft Power Point.
(c) List four types of illustrations that can be added to the presentation from the insert tab of Microsoft Powerpoint.

Paper 2, Section A
The Local Area Network (LAN) in a certain school is connected to the Internet. The school also has a Management Information System (MIS) which is used to enroll staff and students in the school. The system requires that users be authenticated before access is granted. Students are also allowed to use computers in the network during their leisure time. (a) (i) State two problems associated with an uncontrolled access to the internet by the students. (ii) How can the problem stated in 4a(i) be prevented? (b) Give one reason for users' authentication before access to the system is granted. (c) To use the MIS a staff is expected to log in using a registered username and password. Table 2 shows login activities and the login steps to the MIS. Specify the correct order or steps in the login process in column Y using the letter A-E attached to the login activities in column X.

Paper 2, Section B: Test of Practical Work
Highlight the steps to perform the following: (a) creating a new table; (b) generating a query; (c) creating a split form; (d) printing a report.

Paper 2, Section B: Test of Practical Work
(a) A document is created in MS Word but the user realizes that parts of the document are cut off when it is print previewed in portrait orientation. Highlight the steps to change the orientation to landscape and print the document on A4 paper.
(b) A teacher working on student's results broadsheet in Microsoft Excel needed to keep the headings in “view” while scrolling through the results. The teacher also needed to compare each student's record with a version of the file earlier submitted to the Head of Department (HOD) to effect all suggestions. (i) Name the concept of keeping the headings visible while scrolling through a worksheet in Microsoft Excel. (ii) Outline the steps to keep the headings fixed while scrolling in Microsoft Excel Worksheet. (iii) Identify two actions to display each student's record at the same time on both versions of the result file. (iv) Highlight the steps to achieve the named actions in 6b(iii).
(c) List two gadgets needed to display the contents of a laptop computer to an audience in an auditorium.