WAEC Data Processing 2022 past questions and answers

The concept of stored program for electronic devices was introduced by

1. A.Ada Augusta Lovelace
2. B.Charles Babbage
3. C.John Von Neumann
4. D.Tim Berners Lee

High level programming languages such as COBOL and FORTRAN were first used in the

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

Any meaningful fact and knowledge item that can be expressed in words and numbers is called

1. A.data
2. B.database
3. C.information
4. D.knowledge base

The category of computers used for weather forecasting is known as

1. A.general purpose computers
2. B.microcomputers
3. C.special purpose computers
4. D.super computers

One application of ICT in education is

1. A.Automated Teller Machine
2. B.Electronic Fund Transfer
3. C.Magnetic Ink Character Recognition
4. D.Optical Mark Reader

An application of ICT which allows a person to participate in a meeting from a remote location is called

1. A.blogging
2. B.broadcasting
3. C.podcasting
4. D.telepresence

The subdivision of tracks in a hard disk is called

1. A.cluster
2. B.record
3. C.row
4. D.sector

The standard way of arranging information is known as

1. A.classification of information
2. B.collection of information
3. C.organization of information
4. D.validation of information

One disadvantage of using computer for information processing is

1. A.low productivity
2. B.reduced running cost in the long term
3. C.the increase in processing speed
4. D.the need for staff retraining

The process of sending and receiving information from one place to another is called information

1. A.technology
2. B.transfer
3. C.transmission
4. D.synchronization

The capacity of a communication channel is referred to as

1. A.bandwidth
2. B.baud rate
3. C.bit flow
4. D.data flow

The type of network which has a restricted coverage within an enterprise is called

1. A.internet
2. B.intranet
3. C.ethernet
4. D.extranet

One of the major differences between WAN and MAN is that

1. A.WAN uses routers while MAN uses switches
2. B.WAN connects countries while MAN connects continents
3. C.WAN has no limited coverage while MAN has limited coverage
4. D.WAN incorporates servers while MAN does not incorporate servers

Use Figure 1 to answer questions 15 and 16.
To search for information using the interface in Figure 1, the key words of the search subject is typed into the part labelled

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

To access a website, the URL of the website is typed into the part labelled

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

A user working on a computer that is running on Windows 7 issued the command: Ctrl + Alt + Del while typing a document. What interface is expected to be displayed on the screen?

1. A.Restart windows
2. B.Shutdown windows
3. C.Windows hibernate
4. D.Windows task manager

The following computer files will open on a computer that has only Microsoft Office 1997-2003 installed except

1. A.exam.doc.
2. B.exam.docx.
3. C.exam.ppt.
4. D.exam.rft

The part labelled I in Figure 2 is used in Microsoft Word to

1. A.close current document
2. B.enlarge current document
3. C.minimize current document
4. D.highlight current document

Table 1 is a portion of a Microsoft Excel Worksheet which shows the marks obtained by some students in an examination.
Which of the following formulas can be used to find the average score for ENEH GRACE?

1. A.=AVERAGE(B4:B6)
2. B.=AVERAGE(B5:F5)
3. C.=AVERAGE(B4:F4)
4. D.=AVERAGE(A4:F4)

The following statements are steps used in creating a new workbook in a Microsoft Excel application. I. Click on New II. Click on the Microsoft Office button III. Choose blank document.
Which of the following arrangements shows the correct order of operation from the steps above?

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

The database tool that allows the user to select and filter data from multiple tables is referred to as

1. A.form
2. B.query
3. C.report
4. D.table

Arrange the following steps in the correct order for editing data type in data sheet view of a Microsoft Access database. I. choose the type of data that will be entered into the fields II. Click the data sheet tab on the ribbon III. Click the field you wish to define IV. Click the ‘down’ arrow next to the data type.

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

In Microsoft PowerPoint application, the command: ctrl + m is used to create

1. A.an animation
2. B.new PowerPoint document
3. C.new presentation
4. D.new slide

Figure 3 shows CorelDraw tool bar.
The part labelled III in Figure 3 is used to

1. A.shape objects
2. B.select and transform objects
3. C.search for objects
4. D.change the viewing windows

Corrective maintenance of software refers to

1. A.modifications initiated due to defects in software
2. B.making the software easier to understand
3. C.enhancement aimed at making the product faster
4. D.deploying the software to a different hardware platform

A desktop computer is switched on and the monitor displays an error message which reads: No input signal. The likely cause of this error is

1. A.defective monitor
2. B.disconnected VGA
3. C.low memory
4. D.power failure

The legal right given to the owner of an intellectual property to prevent others from duplicating or using the work freely is known as

1. A.trademark
2. B.ownership right
3. C.legal right
4. D.copyright

Which of the following practices is a safety measure?

1. A.Wearing hand gloves while typing
2. B.Opening up the computer while still connected to the power supply
3. C.Maintaining a dust-free environment
4. D.Eating and typing at the same time

Preventive maintenance measures in the computer room do not include

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

One quality of a computer programmer is

1. A.ability to teach
2. B.excellent analytical thinking
3. C.friendliness
4. D.punctuality to work

Which of the following malware does not replicate itself?

1. A.Boot sector virus
2. B.Memory resident virus
3. C.Trojan horse
4. D.Worm

Computer virus replicates itself into other programs or certain areas on the disk during the

1. A.dormant phase
2. B.execution phase
3. C.propagation phase
4. D.trigger phase

Use Tables 2 and 3 to answer questions 35 and 36.
A suitable application software for creating Tables 2 and 3 is

1. A.CorelDraw
2. B.MSAccess
3. C.MS Powerpoint
4. D.Notepad

When choosing a file organization method, a system administrator will not consider

1. A.file access method
2. B.file activity
3. C.file medium
4. D.frequency of update

Frequent backup of computer files helps to

1. A.archive files
2. B.modify records in files
3. C.prevent virus attacks
4. D.protect files

Shared-memory is an architecture in

1. A.distributed database
2. B.parallel database
3. C.relational database
4. D.trusted distributed database.

Paper 2, Section A: Short-structured questions
(a) Define information transmission. (b) Differentiate between: (i) internet and intranet; (ii) LAN and WAN. (c) List four devices used in a LAN environment.

Paper 2, Section A: Short-structured questions
A medium scale enterprise intends to create a database to manage its staff records with the following fields: Staff ID, Name, Address, Photograph and Department. (a)(i) What is a database? (ii) List three DBMS the firm can use to achieve the stated objectives. (b)(i) Mention two tasks that can be performed on staff photographs using graphic packages. (ii) Give three examples of graphic packages that can be used for the tasks in 2(b)(i).

Paper 2, Section A: Short-structured questions
(a)(i) What is a presentation package? (ii) Give two examples of presentation package. (iii) State three features of a presentation package. (b) Highlight the steps followed to find and replace data in MS Excel.

Paper 2, Section A: Short-structured questions
A professional photographer uses analogue cameras and a computer system for his business. The computer is used to prepare documents and keep records of clients' accounts. Copies of these documents are stored in CD-ROMs and Floppy disks. The photographer now plans to innovate by using digital cameras and the computer for taking, editing and printing photographs. (a) State two hardware changes required on the photographer's computer to achieve the planned innovation. (b) Give one reason: (i) for each of the changes in 4(a). (ii) why the photographer should use external hard disk instead of floppy disk to store data. (c) State two advantages of switching from analogue to digital camera.

Paper 2, Section B: Test of Practical Work
A class captain was asked to create a database in MS Access for all the students in the class without using any template and name it Student_Record. The table created is to be named Students and should have five columns/fields with the following names: ID_Number, Full Name, Date of Birth, Age, Home_Address. (a) Highlight the procedures the captain will follow to create the database. (b) List the steps the captain would take to create the table in Design View. (c) Give the data type suitable for each column/field provided. (d) Which field can be used as the primary key? (e) Mention one importance of primary keys. (f) List three SQL command statements the class captain can perform on the database. (g) Give the SQL query the captain will use to display all the columns in table Students.

Paper 2, Section B: Test of Practical Work
(a) Outline the steps taken in MS word to: (i) create a table with 4 columns and 6 rows; (ii) insert a hyperlink on a text.
(b) Figure 1 is a portion of Microsoft Word interface. State the function of the parts labelled I to V in Figure 1.