WAEC Data Processing 2018 past questions and answers

The first generation computers made use of

1. A.low level programming language.
2. B.high level programming language.
3. C.object-oriented programming language.
4. D.procedural programming language.

Microprocessor was used as the main electronic component of the

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

The act of producing information from figures, text or images is called data

1. A.collation.
2. B.conversion.
3. C.preparation.
4. D.processing.

The following are primary sources of information except

1. A.questionnaire.
2. B.publication.
3. C.observation.
4. D.interview.

Which of these channels would enable business transactions between a buyer from Nigeria and a seller from Ghana?

1. A.e-portal
2. B.e-library
3. C.e-commerce
4. D.Podcasting

The main components of the central processing unit (CPU) of the computer are

1. A.register and memory.
2. B.control unit and register.
3. C.control unit and ALU.
4. D.ALU and BUS.

Stages in data processing cycle include the following except data

1. A.collation.
2. B.gathering.
3. C.parsing.
4. D.processing.

The media which enable electromagnetic signals to be transmitted through free space is known as

1. A.unguided media.
2. B.intranet.
3. C.guided media.
4. D.ethernet.

Information that stimulates both the senses of hearing and sight is called

1. A.audio information.
2. B.audio-visual information.
3. C.video information.
4. D.visual information.

The following are advantages of networking except

1. A.spamming.
2. B.sharing of resources.
3. C.communication.
4. D.backup.

Which of the following devices would not transmit signals from one point to another?

1. A.Telephone line
2. B.Modem
3. C.Fibre optics
4. D.Coaxial cable

Another term for Uniform Resource Locator (URL) is

1. A.website address.
2. B.IP address.
3. C.domain name.
4. D.data link.

The website “www.google.com” indicates that Google is

1. A.a commercial organization.
2. B.a non-profit organization.
3. C.a research organization.
4. D.an educational organization.

Identify an operating system from the following software.

1. A.Writer
2. B.MS One note
3. C.MS Access
4. D.Linux

Which of the following commands would undo the last operation carried out in Microsoft Word?

1. A.Crtl + Z
2. B.Crtl + Y
3. C.Crtl + W
4. D.Crtl + U

While typing, a series of letters were highlighted and the keyboard key combination “Ctrl + B” was executed. The highlighted letters would be

1. A.underlined.
2. B.italicized.
3. C.deleted.
4. D.bold.

Table 1 is a part of MS Excel worksheet which shows the marks obtained by some students in an examination.
Which of the following formulas would calculate the average score of the students in Mathematics?

1. A.=Average (C2: C6)
2. B.=Average (C2: F2)
3. C.=Average (C1: C6)
4. D.=Average (C1: F1)

Table 1 is a part of MS Excel worksheet which shows the marks obtained by some students in an examination.
Which of the following formulas would calculate the total score of ONYEBUEKE DEBORAH in the five subjects?

1. A.=SUM(B2: B6)
2. B.=SUM(A6: G6)
3. C.=SUM(A2: A6)
4. D.=SUM(B6: F6)

The following are advantages of a Database Management System (DBMS) except

1. A.restriction of unauthorized access to data.
2. B.provision of multiple interfaces to different classes of users.
3. C.provision of backup and recovery services.
4. D.compromise of data integrity.

Extracting information in Database Management System (DBMS) involves

1. A.sorting.
2. B.querying.
3. C.editing.
4. D.cross-referencing.

A special effect that controls the way slides appear in PowerPoint presentation is called

1. A.Word Art.
2. B.Transition.
3. C.Theme.
4. D.Clip Art.

A reference to another page or resource on a website is done by

1. A.FTP.
2. B.Hyperlinks.
3. C.SMTP.
4. D.Web page.

The design output of a graphic package can be in the following file formats except

1. A..rtf.
2. B..jpg.
3. C..gif.
4. D..bmp.

The proactive maintenance of computer equipment before a fault or failure occurs is called

1. A.corrective maintenance.
2. B.predictive maintenance.
3. C.preventive maintenance.
4. D.preservative maintenance.

A good computer maintenance practice entails

1. A.washing the dusty computer parts with soap and water.
2. B.keeping computers exposed to sunlight to dry the body.
3. C.cleaning the display unit with methylated spirit.
4. D.blowing the system unit with blower.

Set of moral principles that regulate the use of computers and concerns professional and social conduct is known as

1. A.computer ethics.
2. B.computer misuse act.
3. C.computer use act.
4. D.safety measure.

Which of the following programs is a computer virus?

1. A.Kaspersky
2. B.NOD 32
3. C.Norton
4. D.Tuareg

Precautionary measures on computer do not include

1. A.handling all files with care.
2. B.giving access to unauthorized persons into the computer room.
3. C.avoiding smoking in the computer room.
4. D.avoiding dirts and dust in the computer room.

The computer professional responsible for designing and maintaining a database is called database

1. A.programmer.
2. B.operator.
3. C.instructor.
4. D.administrator.

Computer virus is not transmitted through

1. A.formatting of documents.
2. B.e-mail
3. C.external storage device.
4. D.Internet.

The following are attributes of computer virus except the ability to

1. A.modify other files.
2. B.replicate itself in order to spread to other files and systems.
3. C.execute without the user's approval.
4. D.warn the user before execution.

A relational database model is designed according to set of rules known as

1. A.Normalization.
2. B.Isolation.
3. C.Grouping.
4. D.Enumeration.

Which of the following statements about relational database model is not correct?

1. A.A file is sequence of related records
2. B.A record consists of a row of data containing single value from each column
3. C.Data in the column of a table are of the same data type
4. D.Data in the rows of a table are of the same data type

Arranging records in a file according to a particular order is referred to as

1. A.matching.
2. B.merging.
3. C.sorting.
4. D.updating.

One advantage of indexed sequential file organization is that

1. A.index tables are small and can be searched quickly.
2. B.it is cost effective.
3. C.it is suitable for dynamically changing files.
4. D.it requires less storage space.

The protection of database against compromise is known as

1. A.data passwording.
2. B.data protection.
3. C.database encoding.
4. D.database security.

Which of the following is a characteristic of parallel databases?

1. A.There can be shared-memory or shared-disk
2. B.They are connected using public purpose networks
3. C.Machines in this environment are in different locations
4. D.It has local autonomy

Paper 2, Section A: Essay
(a)(i) What is data model? (ii) State three types of data model. (b)(i) List three approaches to data modelling. (ii) Explain any one approach listed in 1(b)(i).

Paper 2, Section A: Essay
(a) Vera, a secretary to the manager of the organization is saddled with the responsibility of typing a confidential report. She is also instructed to insert the word “CONFIDENTIAL” diagonally in the background of every page of the report. (i) State the most suitable application software needed by Vera to produce the report. (ii) What feature of the application software can be used to insert the word “CONFIDENTIAL” as instructed? (iii) Mention one measure that can be taken to ensure the confidentiality of the soft copy of the report in the computer. (b) Explain the following terms: (i) icon (ii) browser.

Paper 2, Section A: Essay
(a) Outline the steps involved in printing the first five pages of a Word document from the print dialog box on a computer with two printers installed. (b) Sadiq complained that a pop-up usually appears on the screen of his personal computer thereby disturbing him while using the computer. (i) What is the possible cause of the pop-up? (ii) State a possible source of the element causing the pop-up? (iii) What measure would be necessary to stop the pop-up from reoccurring? (c) Mr. Aneke is billed to address a large audience in an audiorium. (i) What computer application package is suitable to prepare and deliver his speech? (ii) State the output device that can be used to transmit Mr. Aneke's speech note from his computer to a large screen in the auditorium. (d) Give two types of computer network.

Paper 2, Section A: Essay
(a) Outline the steps involved in creating the Query By Example (QBE) in figure 1 assuming the table tblcustomer exists already. (b) Write the steps to generate the SQL statement for the action in 4(a).

Paper 2, Section B
(a) Itoro was tasked with the responsibility of producing the report of his group project. He is to submit both the soft and hard copies of the report to his form teacher. The soft copy must be sumbitted to the email: formteacher@school.edu.ng. (i) List two: I. applications required to carry out the task; II. hardware required to carry out the task. (ii) Identify two conditions to be satisfied by Itoro to submit the electronic copy of the report. (iii) On the first attempt to send the soft copy of the report, Itoro observed a ‘spinning wait cursor’/‘spinning disc pointer’ on the screen for a long time. Identify three possible reasons for the observation. (iv) State one output device that can be used to produce the hard copy of the report.
(b) Figure 2 is an interface of an application software. (i) Name the type of application software represented in figure 2 (ii) List three examples of the application in 5(b)(i). (iii) Given that the application in figure 2 is running on a computer that has Internet access, outline the steps to follow in creating an email addresss/account.

Paper 2, Section B
Figure 3 is created using a Word Processor. Use the figure to answer question 6(a).
(a)(i) What is the name given to the feature on the first character in the document in figure 3? (ii) Highlight the steps to: I. achieve the feature on the first character in 6(a)(i); II. obtain the two columns as shown in figure 3.
(b) Give two objects that can be placed on a document using the ‘Insert mean’ on MS Word application.
(c) Outline the steps to perform the following actions in CorelDraw application: (i) inserting a circular shape; (ii) adding the caption ‘Happy Birthday’; (iii) changing the colour of the caption to Red; (iv) fitting the caption around the circular object.