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

(ai) Outline the steps taken in MS words to:
      create a table with 4 columns and 6 rows
(aii) Outline the steps taken in MS words to:
       insert a hyperlink on a text
(b)
 
State the function of the parts labeled I to V in figure above

(a) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five colunms/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address

Highlight the procedures the captain will follow to create the database

(b) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five colunms/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address

List the steps the captain would take to create the table in Design View

(c) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five colunms/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address

Give the data type suitable for each column/field provided

(d) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five colunms/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address

Which field can be used as the primary key?

(e) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five colunms/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address

Mention one importance of primary keys

(f) A class captain was asked to create a database in MS Access for all the student 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

List three SQL command statements the class captain can perform on the database

(g) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five colunms/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address

Give the SQL query the captain will use to display all the columns in table Students

(a) 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’ account. 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.

State two hardware changes required on the photographer’s computer to achieve the planned innovation

(bi) 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’ account. 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.

Give one reason:
for each of the changes above

(bii) 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’ account. 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.

why the photographer should use an external hard disk instead of a floppy disk to store data

(c) State two advantages of switching from analogue to digital camera

(ai) What is a presentation package?
(aii) Give two examples of presentation package
(aiii) State three features of a presentation package
(b) Highlight the steps followed to find and replace data in MS Excel

(ai) 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.
what is database?
(aii) 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.List three DBMS the firm can use to achieve the stated objectives
(bi) 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
Mention two tasks that can be performed on staff photographs using graphic packages
(bii) 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.
Give three examples of graphic packages that can be used for the tasks above

(a) Define information transmission
(bi) Differentiate between internet and intranet
(ii) Differentiate between LAN and WAN
(c) List four devices used in a LAN environment

Which of the following practices is a safety measure?

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

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

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?

Frequent backup of computer files helps to

Arrange the following steps in the correct order for editing data type in data sheet view of a Microsoft Access database
I. Click the type of data that 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

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

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

The standard way of arranging information is known as

The subdivision of tracks in a hard disk is called

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

Computer virus replicates itself into

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

One application of ICT in education is

A file organization method that has reference which identifies a record in relation to other records is called