WAEC Data Processing 2019 past questions and answers

The modern definition of a computing machine is based on a concept known as

1. A.circuit switching.
2. B.digital circuit.
3. C.packet switching.
4. D.stored program.

Arrange the following ICT tools in the order of invention from the earliest to the latest: cell phone, Internet, satellite and radio.

1. A.Cell phone, satellite, radio, Internet
2. B.Internet, satellite, cell phone, radio
3. C.Radio, satellite, Internet, cell phone
4. D.Radio, cell phone, satellite, Internet

The process of gathering facts and statistics from different sources is known as data

1. A.analysis.
2. B.collection.
3. C.collation.
4. D.retrieval.

A chart is a graphical representation of

1. A.data.
2. B.map.
3. C.process.
4. D.transmission.

The use of transistors in circuits was a major advancement in the

1. A.first generation computers.
2. B.second generation computers.
3. C.third generation computers.
4. D.fourth generation computers.

An ICT-based service that uses telecommunication devices to hold meeting among many participants in two or more locations is known as

1. A.broadcasting.
2. B.multimedia.
3. C.pod casting.
4. D.teleconference.

Which of these devices does not support wireless communication?

1. A.GSM phone
2. B.Mouse
3. C.Router
4. D.Telephone

The following hardware devices are used for output operations except.

1. A.monitor.
2. B.microphone.
3. C.plotter.
4. D.projector.

The manipulation of digitized information by computer or other digital electronic equipment is known as

1. A.data collation.
2. B.data manipulation.
3. C.information manipulation.
4. D.information processing.

Which of the following statements explains information processing?

1. A.Saving documents in a device
2. B.Changing information detectable by an observer
3. C.Data upload to server
4. D.Transfer of information between devices

The information transmission medium from location A to location B in space is called

1. A.asynchronous transmission.
2. B.guided transmission.
3. C.synchronous transmission.
4. D.wireless transmission.

What is the role of the part labelled II in Figure 1?

1. A.Interpreter
2. B.Medium
3. C.Receiver
4. D.Source

Which of these technologies allows wireless connectivity in a Personal Area Network?

1. A.Bandwidth
2. B.Bluetooth
3. C.Broadband
4. D.Satellite

Use Figure 3 to answer questions 15 and 16.
The title of the web page being accessed on the interface in Figure 3 is displayed on the part labelled

1. A.I.
2. B.II.
3. C.III.
4. D.IV.

The shortcut key combination for adding a new tab in Figure 3 is

1. A.Alt + N.
2. B.Alt + T.
3. C.Ctrl + N.
4. D.Ctrl + T.

A program that enables the computer hardware to communicate and function effectively is

1. A.translator.
2. B.liveware.
3. C.operating system.
4. D.application software.

A Word document can have any of these file extension except.

1. A..doc.
2. B..docx.
3. C..jpg.
4. D..rtf.

Which of the following command shortcuts can be used to display the dialog box in Figure 4 when the application is running?

1. A.Ctrl + O
2. B.Ctrl + S
3. C.Ctrl + Y
4. D.Ctrl + Z

The first step taken in editing a chart in MS Excel is

1. A.click and drag the chart object.
2. B.click the chart object.
3. C.copy the chart object.
4. D.drag the chart object.

By default, numeric values in a worksheet are

1. A.centered.
2. B.left-aligned.
3. C.right-aligned.
4. D.unaligned.

The diagram in Figure 5 depicts a

1. A.flat file database.
2. B.hierarchical database.
3. C.network database.
4. D.parallel database.

Which of the following sets are available when creating a table in “Design View” in Microsoft Access?

1. A.DataType, Description and Field Name
2. B.Description, Criteria and Field Property
3. C.Field Name, DataType and Field Property
4. D.Criteria, Field Name and Description

The MS Power Point feature which can be used to change the appearance of the entire presentation is the

1. A.Add slide option.
2. B.Design template.
3. C.Online view.
4. D.Slide Layout option.

One example of web design package is

1. A.MS FrontPage.
2. B.MS Outlook.
3. C.Peachtree.
4. D.SPSS.

The part labelled II in Figure 6 is used to

1. A.shape objects.
2. B.select and transform objects.
3. C.draw lines and cures.
4. D.create texts.

In computer maintenance, the dampen material can be used on the following devices except.

1. A.DVD lens.
2. B.keyboard.
3. C.mouse.
4. D.screen.

Dust from the system unit casing can be removed using

1. A.antistatic wipes.
2. B.cotton wool.
3. C.static wipes.
4. D.wet cloth.

Indiscriminate sending of unsolicited e-mails to many e-mail addresses is known as

1. A.plagiarism.
2. B.phishing.
3. C.pharming.
4. D.spamming.

In computing, ergonomics is a term associated with computer

1. A.ethics.
2. B.maintenance.
3. C.malware detection.
4. D.safety measure.

A novice is discouraged from opening the CRT monitor for maintenance because

1. A.it cannot be appropriately reassembled after opening.
2. B.it may habour pests carrying infectious diseases.
3. C.it may contain high static voltage.
4. D.the tube is fragile.

Computer professional bodies in Nigeria include the following except

1. A.Internet Service Providers Association of Nigeria.
2. B.Nigerian Computer Society.
3. C.Nigerian Information Technology Development Agency.
4. D.Nigeria Internet group.

The malware which appears as a harmless object but attacks its victims at the slightest opportunity is called

1. A.worm.
2. B.trojan horse.
3. C.macro virus.
4. D.logic bomb.

Virus effect can be prevented by

1. A.installing and updating antivirus.
2. B.installing new operating system.
3. C.purchasing new computer.
4. D.using external disks on public computer system.

The part of the object in Figure 7 labbeled II are called

1. A.attributes.
2. B.entities.
3. C.models.
4. D.relations.

The arrangement that gives the correct order of magnitude of the database elements is

1. A.character, field, record, table, database, file.
2. B.character, field, record, table, file, database.
3. C.database, table, file, record, field, character.
4. D.database, record, file, field, table, character.

One unique feature of index file is that it contains

1. A.reference number.
2. B.relative number.
3. C.sequence number.
4. D.static number.

Which of the following file organizations requires a primary key?

1. A.Indexed file organization
2. B.Random file organization
3. C.Serial file organization
4. D.Sequential file organization

Ensuring the correctness and consistency of data is referred to as data

1. A.security.
2. B.reliability.
3. C.productivity.
4. D.integrity.

In distributed database management system, breaking a relation into smaller relations is known as

1. A.replication.
2. B.fragmentation.
3. C.indexing
4. D.normalization.

Paper 2, Section A: Essay
(a) What is teleconferencing? (b) State four uses of Automated Teller Machine (ATM). (c)(i) Give the function of a modem. (ii) List the two means of transmitting information.

Paper 2, Section A: Essay
Hamza, Emeka, Funsho, Fejiro and Idongesit were friends from secondary school. Now, Hamza is a pilot, Emeka is a businessman, Funsho is a banker, Fejiro is a manufacturer while Idongesit is a teacher. State two ways in which each of these friends can apply ICT in their respective professions.

Paper 2, Section A: Essay
(a) A secondary school has over twenty personal computers. The school management intends to connect the computers in a network. Give four reasons that must have motivated the school management into connecting the computers together. (b) List four network devices required to accomplish the task in 3(a). (c) State one function each for any two of the devices listed in 3(b).

Paper 2, Section A: Essay
(a) Explain the following database management terms: (i) entities (ii) attributes; (iii) relationships. (b)(i) Define cardinality in database management. (ii) Mention three cardinality relationships in database management.

Paper 2, Section B
(a) Figure 1 illustrates a part of a computer system. (i) Identify the part labelled Y. (ii) State: I. the technology used in the part labelled Z. II. the function of the part labelled X. III. one maintenance practice for the part labelled Z.
(b) Figure 2 shows a setup of a computer system. State one function of each of the parts labelled P, Q, R, S, and T.
(c) Outline the steps taken to perform the following tasks in CorelDraw application: (i) insert a circular shape; (ii) add the caption “Happy Birthday” around the circular shape; (iii) change the colour of the caption to green.

Paper 2, Section B
Table 1 shows the list of items and the quantity of the item needed by a student. The table was created on an MS Excel worksheet. Use the table to answer questions 6(a)(i) - (iv)
(a) Outline the steps to: (i) create a bar chart on the worksheet such that the items would be labeled on the chart and the percentage of each item included. (ii) add to the table, a new; A. column; B. row. (iii) State one function in MS Excel that can be used to determine the item with the highest quantity.
(b) Outline the steps to add page border to a document using Art Design Tool in MS Word application.
(c) An MS Word document contains the phrase “WAEC Exam”. Highlight the steps to link the phrase above to the WAEC website. (http://www.waec.org.ng)