Data Processing JAMB, WAEC, NECO AND NABTEB Official Past Questions

Table 1 shows the list of items and the quantity of the items needed by a student. The table was created on an MS Excel worksheet.

Use the table to answer questions 6(a)(i)-(iv)

                                                Table 1

(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 WAEC website (http://www.waec.org.ng).

a. Figure 1 illustrates a part of a computer system,

(i) Identify the part labeled Y. 

(ii) Sate;

I. The technology used in the part labeled Z.

II. The function of the labeled X.

III. one maintenance practice for the part labeled Z.

(b) Figure 2 shows a setup of a computer system. State one function of each of the parts labeled 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 caption “Happy Birthday” around the circular shape.

(iii) change the colour of the caption to green.

(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 database management.

a. A secondary school has over twenty personal computers. The school management intends to connect all the computer 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 of any two of the devices listed in 3(b).

Hamza, Emeka, Funsho, Fejiro and Idongesit were friends from secondary school. Now, Hamza is a pilot, Emeka is a businessman, Funsho is banker, Fejiro is a manufacturer while Idongesit is a teacher. State two ways by which any of these friends can apply ICT in their respective professions.

(a)What is teleconferencing?

(b) State four uses of automated Teller Machine (ATM)

(c)(i) Give the function of a modem

(ii) List two means of transmitting information.

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

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

Which of the following file organization requires a primary key 

One unique feature of index file is that it contains 

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

The parts of the object in Figure 7above labeled II are called 

Virus effect can be prevented by

The malware which appears as a harmless object but attack it’s victims at the slightest opportunity is called

Computer professional bodies in Nigeria include the following except 

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

In computing, ergonomics is a term associated with computer 

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

Dust from the system unit casing can be removed using 

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

The part labeled II in Figure 6 ABOVE is used to