WAEC Data Processing 2017 past questions and answers

One characteristic feature of the second generation computers is the presence of

1. A.vacuum tubes.
2. B.transistors.
3. C.micro-chips.
4. D.integrated circuit.

Convert 4₁₀ to a number in base two.

1. A.10
2. B.11
3. C.100
4. D.110

Data processed into its useful form is referred to as

1. A.unique data.
2. B.raw data.
3. C.knowledge.
4. D.information.

Which of the following is an example of qualitative data?

1. A.Colour
2. B.Height
3. C.Length
4. D.Shoe size

Which of the following is not a characteristic of a personal computer?

1. A.Automation
2. B.Complex
3. C.Digital
4. D.High speed

The gap between ownership, access and benefits from computer and its application is termed digital

1. A.separation.
2. B.divide.
3. C.deprivation.
4. D.annihilation.

Magnetic Ink Character Recognition (MICR) are used to read codes on

1. A.postal orders.
2. B.Multiple Choice Examination answer sheets.
3. C.bank tellers.
4. D.bank cheques.

The device that sends information to the CPU is the

1. A.bus.
2. B.input device.
3. C.output device.
4. D.processor.

Which of the following is not a procedure for information processing?

1. A.Segregation
2. B.Organization
3. C.Interpretation
4. D.Collation

The assembling of data according to a predetermined order is known as

1. A.collation.
2. B.interpretation.
3. C.organization.
4. D.summarization.

Information transmission medium from location P to location Q in space is called

1. A.wireless transmission.
2. B.wired transmission.
3. C.cabled transmission.
4. D.asynchronous transmission.

Which of the following is not a type of wireless transmission?

1. A.Bluetooth
2. B.Fibre optic
3. C.Infrared
4. D.WiFi

The basic criterion for classifying a network is

1. A.psychological consideration.
2. B.geographical scope.
3. C.equipment availability.
4. D.economic reason.

Which of the following measures are used to secure data on-line? I. Password II. Encryption III. Personal Identification Number (PIN)

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

In e-mail context, bcc stands for

1. A.backup carbon copy.
2. B.blank carbon copy.
3. C.blind carbon copy.
4. D.bulk carbon copy.

An internet-based system that allows people of different geographical locations to have in-person meeting is known as

1. A.voice messaging system.
2. B.video conferencing system.
3. C.on-line mailing system.
4. D.fax system.

In Word processing applications, the symbols B, I and U are commonly used buttons found on the

1. A.standard toolbar.
2. B.menu bar.
3. C.formatting toolbar.
4. D.drawing toolbar.

Bola intends to evoke the synonym of a certain word during Word processing. What is the most appropriate tool to use?

1. A.Assistant
2. B.Change case
3. C.Grammar checker
4. D.Thesaurus

In a worksheet, which of the following actions would select non-contiguous cells?

1. A.Holding down the Shift key
2. B.Holding down the Crtl key
3. C.Holding down the Alt Key
4. D.Holding down Ctrl+Shift key

Which of these formulas will not be executed in MS Excel?

1. A.=SUM(examscore)
2. B.=SUM(Examscore)-12
3. C.=SUM(exam_score)*8
4. D.=SUM(exam score)/3

MS Access is an example of a

1. A.relational model.
2. B.network model.
3. C.hierarchical model.
4. D.flat file model.

When a database recovery manager is invoked after a crash, restart proceeds in the following three phases: I. Undo; II. Redo; III. Analysis. Arrange these phases in the right order.

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

During presentation, slide transition can be activated by

1. A.right-click.
2. B.mouse drag.
3. C.mouse click.
4. D.double-click.

Planning and creating of websites is called web

1. A.analysis.
2. B.design.
3. C.maintenance.
4. D.publishing.

Magazines and brochures can be produced using a

1. A.data processing software.
2. B.graphics software.
3. C.presentation software.
4. D.web authoring software.

Which of the following is one of the tools used to maintain the computer?

1. A.Blower
2. B.Calliper
3. C.Cotton wool
4. D.Kerosine

Which of the following is not a good computer maintenance practice?

1. A.Blowing the system unit with a blower
2. B.Blowing the keyboard with a blower
3. C.Cleaning the screen with wet cloth
4. D.Cleaning the CD-ROM drive with lens cleaner

Commonly accepted practices, rules or methods in computing are called

1. A.Conventions.
2. B.Habits.
3. C.Laws.
4. D.Standards.

Which of the following is a safety measure in the computer laboratory?

1. A.Eating in the computer laboratory
2. B.Illumination in the computer laboratory
3. C.Opening up the monitor by unauthorized persons
4. D.Poor ventilation in the computer laboratory

Safety measures to be observed when using the computer include all of the following except

1. A.use of anti-glare protector.
2. B.sitting posture.
3. C.maintaining a dust-free environment.
4. D.dropping liquids in the computer room.

Which of the following is not an anti-virus?

1. A.Avast
2. B.AVG
3. C.Compaq
4. D.Norton

Which of the following is used to retrieve specific information from database tables?

1. A.Index
2. B.Query
3. C.Report
4. D.Table

Which of these methods would delete a relationship defined between two tables in MS Access?

1. A.Selecting Delete relationship from the Edit menu dialog box
2. B.Selecting the relationship line and pressing Delete key
3. C.Selecting Delete from the relationship menu
4. D.Selecting Delete relationship from the file drop down menu

Which of the following is not an effect of computer virus? It

1. A.distorts the computer screen.
2. B.interferes with computer operation.
3. C.damages the computer.
4. D.corrupts the computer.

What file organization would require that all the five (5) records be read before the 6th record is written?

1. A.Direct-access file
2. B.Index sequential file
3. C.Random access file
4. D.Sequential access file

Which of the following is not an advantage of file organization?

1. A.Faster processing of data input
2. B.Post data retrieval
3. C.Prevention of data failure and data loss
4. D.Safety of data and information in a storage medium

Maintaining the value and content of data is part of data

1. A.coding.
2. B.integrity.
3. C.secrecy.
4. D.security.

Which of these operations would not improve the performance of a parallel database system?

1. A.Building indexes
2. B.Deleting unwanted data
3. C.Evaluating queries
4. D.Storing data across several sites

Paper 2, Section A: Essay
(a) State four classes of computer based on size. (b) Define the term Information and Communication Technology (ICT). (c) Highlight three ways (ICT) has impacted on the society.

Paper 2, Section A: Essay
(a)(i) What is Computer Ethics? (ii) State three computer room management ethics.
(b) List five laboratory rules and regulations.

Paper 2, Section A: Essay
Mr. Okafor has a company that specializes in the production of beverages with headquarters in Abuja. He intends to monitor the sales and transactions in the company's branches across Nigeria as well as interact with his customers. (a) Through what platform can Mr. Okafor achieve his intentions? (b) What computer professional should Mr. Okafor hire to design the platform in 3(a)? (c) State two software packages needed to create the platform for Mr. Okafor. (d) If Mr. Okafor decides to connect all the offices within the headquarters in Abuja in a single network: (i) what type of network is appropriate? (ii) mention three reasons to support his decision. (e) Mention two transmission media that can be used to implement the network in 3(d)(i).

Paper 2, Section A: Essay
(a) Define the term Software Maintenance. (b) List four types of software maintenance.
(c) State four importance of software maintenance.

Paper 2, Section B
(a) A teacher asked a student to capture and print out a one-slide presentation assignment using, MS word, showing everything on the screen. (i) What keys or combination of keys can be used to carry out this operation? (ii) Describe the procedure to be followed by the student in carrying out this assignment using the keyboard.
(b) A system analyst was hired to set up a computer laboratory for Bofe International School. (i) Mention three hardware devices the analyst would need to set up the laboratory. (ii) List three database application packages likely to be recommended by the analyst. (iii) State three Word processing packages likely to be installed.
(c) Complete Table 1 on keyboard shortcuts.

Paper 2, Section B
(a) Use Fig. 1 to answer question (i) to (iv). (i) What does Fig. 1 represent? (ii) Identify two output components in Fig.1. (iii) Give the names for the parts labelled III, VI and VII. (iv) State one precautionary measure that should be taken to protect the set-up from power fluctuations while in use. (v) Data entry into the system can be achieved through the parts labelled: (vi) Mention one device that can be used to access the part labelled VII.
(b) Figures 2 and 3 represent mass storage media. Use the figures to answer questions (i) to (iv). (i) Identify the media represented by: Fig. 2 ______ Fig. 3 ______ (ii) The transaction files of a company are to be recorded and accessed in the order which they arrive. Which of the media is most suitable for the purpose? (iii) In which media will the stored data be accessed faster? (iv) State the file access method for each medium. Fig. 2 ______ Fig. 3 ______
(c) A CCTV camera system has a 300 MB storage device. Each image size is 300 kB. (i) How many images can be stored by the CCTV? (ii) If the storage device is full, mention one measure that should be taken to ensure that the system continues to capture and store images without losing the already stored images.