WAEC Data Processing 2021 past questions and answers

The main component of the first generation computer was

1. A.microchip.
2. B.transistor.
3. C.integrated circuit.
4. D.electronic valve.

The number 101100101₂ in denary is

1. A.753.
2. B.653.
3. C.357.
4. D.356.

The term Garbage-In-Garbage-Out is used to explain the characteristic of the computer in terms of

1. A.storage.
2. B.speed.
3. C.power.
4. D.accuracy.

Which of the following statements is true?

1. A.Data leads to information and information leads to knowledge
2. B.Data leads to knowledge and knowledge leads to information
3. C.Information leads to data and data leads to knowledge
4. D.Knowledge leads to information and information leads to data.

The type of computer that counts in discrete form only is referred to as

1. A.analog computer.
2. B.digital computer.
3. C.hybrid computer.
4. D.mainframe computer.

Which of the following media involves point-to-point communication?

1. A.Radio
2. B.Satellite
3. C.Telephone
4. D.Television

Fourth generation computer application can execute the following operations except

1. A.digging of drainages.
2. B.drainage channel design.
3. C.management of recreational facilities.
4. D.payroll management.

The joystick is mainly used for

1. A.clicking on links on web pages.
2. B.drawing and playing computer games.
3. C.erasing of unwanted graphics.
4. D.typing of document in a word processor.

Which of the following actions is not a source of computer virus?

1. A.Checking of e-mail
2. B.Downloading programs
3. C.Reading from CD/DVD
4. D.Uploading data

When information is conveyed from one space to another, it is referred to as information

1. A.retrieval
2. B.translation.
3. C.transmission.
4. D.transportation.

The protocol for transferring files from one machine to another is

1. A.SNMP.
2. B.SMTP.
3. C.FTP.
4. D.FAT.

Mr. Francis has an office complex with 20 rooms. What type of network is suitable for connecting all the computers in their various rooms into a single network?

1. A.LAN
2. B.MAN
3. C.PAN
4. D.WAN

The following software are web browsers except

1. A.Firefox.
2. B.Google Chrome.
3. C.Linux.
4. D.Opera.

To visit the previous page using the interface in Figure 1, the user will click on the part labelled

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

An operating system that enables more than one user to access the same data is called

1. A.multi-tasking OS.
2. B.multi-user OS.
3. C.single user OS.
4. D.virtual memory OS.

The feature of a word document that shows the page, number of words and errors found in a document is the

1. A.menu bar.
2. B.scroll bar.
3. C.status bar.
4. D.title bar.

Figure 2 shows a dialog box from Microsoft Word application. Use it to answer question 19.
Which of the following command shortcuts can be used to display the dialog box in Figure 2 when the application is running?

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

Figure 3 is an excerpt of a company's sales record on an MS Excel worksheet. Use it to answer question 20.
The highest sale by Joy is recorded in cell

1. A.F1.
2. B.B4.
3. C.H3.
4. D.E2.

The formula to calculate the average of a given range of data from cell B2 to cell D4 in a Microsoft Excel worksheet is

1. A.=AVERAGE(B2+D4).
2. B.=AVERAGE(B2:D4)
3. C.=AVERAGE(B2, D4)
4. D.=AVERAGE(B2:D4).

The field in a database which uniquely identifies each record is called a

1. A.composite key.
2. B.foreign key.
3. C.local key.
4. D.primary key.

The correct order of the steps taken in creating a database from the database template in MS Access 2007 is

1. A.click on the Office button → click New → choose a database of your choice.
2. B.click New → click on Office button → choose a database of your choice.
3. C.click on database of your choice → click New → click on Office button.
4. D.click New → choose database of your choice → click on Office button.

To show the whole presentation in Microsoft PowerPoint 2007, select slide show from the

1. A.design tab.
2. B.home tab.
3. C.title bar.
4. D.menu bar.

Web design packages include the following except

1. A.Macromedia Dreamweaver
2. B.iWeb
3. C.Front Page.
4. D.Adobe PageMaker.

Figure 4 shows CorelDraw tool bar. The part labelled I is used to

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

One precautionary measure taken when cleaning a monitor is

1. A.plugging of power supply cable.
2. B.spraying a windows cleaner on the monitor.
3. C.unplugging the power supply cable.
4. D.using a vacuum cleaner to clean the monitor casing.

The erratic movement of the mouse pointer is usually caused by

1. A.damaged driver.
2. B.dirty mouse ball.
3. C.improper connection of mouse cable.
4. D.outdated driver.

The use of the internet to perform illegal activities is generally called

1. A.cyber crime.
2. B.packet sniffing.
3. C.phishing.
4. D.spamming.

One safety measure to consider in a computer room is

1. A.arranging the chairs in the room together.
2. B.keeping liquid within the room.
3. C.closing the door always.
4. D.maintaining a dust-free environment.

Security breaches in computing cannot be prevented through the use of

1. A.antivirus.
2. B.encryption.
3. C.firewall.
4. D.firmware.

A system analyst is a person who

1. A.designs flowchart.
2. B.designs and implements new solutions.
3. C.trains computer users.
4. D.writes complex computer programs.

The malware which is programmed to initiate at a specific date or when a specific event occurs is called

1. A.directory virus.
2. B.logic bomb.
3. C.polymorphic virus.
4. D.root kit virus.

One advantage of information processing is that

1. A.face-to-face interaction among staff may be reduced.
2. B.initial investment cost can be high.
3. C.running cost becomes lower in the long run.
4. D.it encourages the training/retraining of staff.

The function of the SQL statement SELECT Student ID, Surname, House Name FROM Student, is that it

1. A.retrieves the listed fields from student table.
2. B.highlights the listed fields from student table.
3. C.hides the selected fields from student table.
4. D.deletes the listed fields from student table.

A file organization that contains a reference number is called

1. A.direct access.
2. B.indexed access.
3. C.random access.
4. D.sequential access.

The following media are used for information transmission except

1. A.diary.
2. B.magazine.
3. C.radio.
4. D.television.

To prevent the loss of data in the computer, it is better to implement file

1. A.access.
2. B.maintenance.
3. C.checks.
4. D.backup.

Which of the following terms is not a feature of distributed database?

1. A.Fragmentation
2. B.Multiple storage
3. C.Replication
4. D.Single server.

Paper 2, Section A: Short-structured questions
(a) Define the following terms: (i) disk formatting. (ii) data backup. (iii) virus scan. (b) State four uses of the Automated Teller Machine (ATM).

Paper 2, Section A: Short-structured questions
(a) Complete Table 1 with the appropriate criteria for each storage medium.
(b) List three examples of spreadsheet applications.

Paper 2, Section A: Short-structured questions
(a) (i) State three ways of classifying computers. (ii) Differentiate between digital and analog computers. (b) List three positive impacts of ICT on the society. (c) Give two types of information transmission medium.

Paper 2, Section A: Short-structured questions
A certain business centre provides computer and internet services to the public. The owner is concerned that there is no restraint on consumption of food and drinks by the customers and also about possible health hazards to the computer users. (a) Give two safety precautions that must be put in place to protect the workstations in the business centre from foods and drinks. (b) State two ways the computers can be maintained to ensure efficiency in serving the customers. (c)(i) Name three possible health risks to the customers while using the computers in the centre. (ii) How can the risks in 4(c)(i) be reduced?

Paper 2, Section B: Test of Practical Work
A student was given an assignment which involved typesetting a passage at home using a laptop computer. The student was required to bring the soft copy of the assignment in a flash drive with volume label STUDENT_ASSIGNMENT to the school. Highlight the steps the student would take to: (a) save the typeset work in the flash drive; (b) create a folder named ASSIGNMENTS on the desktop of a computer in the school's computer laboratory and save the typeset assignment in the folder; (c) print the assignment from the folder created in 5(b).

Paper 2, Section B: Test of Practical Work
Figure 1 shows the schematic procedure of an information processing system. Input into the system are biometric based data as other details had been captured. Use the figure to answer questions 6(a) to 6(c).
(a) List: (i) two biometric data capturing devices at the data entry point; (ii) two transmission media for sending the output to the internet; (iii) one output device to give out audio output from the system; (iv) two types of data that can be viewed in the display.
(b) Give one: (i) difference between information stored in the part labelled storage and the part labelled internet in terms of access; (ii) reason the biometric data is foolproof.
(c) If data already captured into the system include: student's scores, state of origin and age; outline the two operations possible at the processing unit.
(d) Figure 2 represents the interface of an application software. Use the figure to answer questions 6(d)(i) and (ii). State one: (i) use of the parts labelled I to V: (ii) difference between the parts labelled II and III.