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

(a) Folders are used for storing files in the computer. List the steps for carrying out the following operations; (i) creating a folder on the desktop (ii) giving name on the folder (iii) sending a file from “My Documents” folder into the folder created in 6 (a)(i), (iv) Changing the name of the folder in 6(a)(ii) to “RESULTS”.

(b) The table below shows selected fields and Data Types in MS Access. Use it to answer questions 6(b)(i) and 6(b)(ii)

(i) What is the appropriate data type for; (I) Date of Birth (II) Fees Fields

(ii) If MS Access is running, describe the procedure to; I. Create a table with the fields as given above using design view II. Set the Mat. No. Field as the primary key. III. Set the Full Name Fieldto a maximum of 50 characters.

(a) Use the information in the spreadsheet above to answer questions 5(a)i-v

(i) Write the formula to calculate the total score in Mathematics.

(ii) Write two spreadsheet formulas to calculate Paul’s average score in the four subjects.

(iii) What spreadsheet function can be used to determine the highest score in English.

(iv) Outline the procedure for calculating Vera’s total score in all subjects and give the result in cell H8.

(v) If the minimum pass mark is an average score of 60, write a formula to determine if Etta passed or failed.

(b) Use the diagram below to answer b(i-vii)

(i) What is the name of the application shown in the diagram?

(ii) State one use of the application mentioned in 5 (b) (i)

(iii) Outline the procedure to launch the application from its shortcut on the desktop.

(iv) After launching the application, what is the name of the slide that appears by default?

(v) Identify the part labeled I.

(vi) Write the keyboard shortcut that would also perform the function of the part labeled I.

(vii) Mention three functions that can be performed by the insert button.

(a) Mention four qualities of a good computer professional.

(b) List four computer professional bodies in Nigeria.

(c) Write the full meaning of the following ; (i) Wifi (ii) GUI

(a)(i) With the aid of a simple diagram, explain information transmission.

(ii) Give one example of information transmission.

(b) Give one example of each of the following;

(i)single user single tasking operating system.

(ii) single user multitasking operating system.

(iii) multi user operating system.

(c) List four features of a Graphical User Interface.

(a) Define Information Processing.

(b) State four steps involved in information processing.

(c) Mention three advantages of using computers for information processing.

(d) Highlight three disadvantages of using computers for information processing.

(a) Describe data handling.

(b) Explain two ways of handling data.

(c) State four factors to consider when handling data electronically.

Which of the following defines heterogeneous distributed database?

The prevention of data from corruption and unauthorized access is a function of data

The records of students in a school are kept in order of their arrival. What files access method would be used to access a student’s record if the latest record would first be retrieved?

Computers store data as

Relationship between tables in a relational model are created by

In relational model, a tuple is a?

A program designed to detect and prevent malicious programs from a computer system is

Computer virus cannot be transmitted by 

Acomputer pofessional who studies an existing system with a view to evolving a computer based system from it is

Which of the following operations prevent file loss?

A technician can protect itself from electronic discharge by using

The moral principles that regulates the use of computers, its accessories and environment are called

The perfomance of the computer can be enhanced by 

Routine checks operations on computers in order to ensure its continuous functioning is known as computer

In graphic packages, the process of removing unwanted part of an image is known as