Waec Data Processing Paper 2,Essay May/June 2015 Questions

Waec Data Processing Paper 2,Essay  May/June 2015 Questions

1.
a.
(i) Define an operating system
(ii) State two functions of an operating system
(iii) List two differences between an operating system and application software
b. Starting from the Save As dialogue box, outline the steps involved in passwording a document in a word processing package.


2.
a. Define the following
(i)Database (ii)Database Management System
b. Mention three functions of a database management system
c. Mention two ways through which data can be destroyed
d. State three precautionary measures to prevent data loss.

3.
a.
(i) Define application package
(ii) State one use each of any four application packages
b. List two benefits of a presentation package.
c. Outline three guidelines for creating a good MS PowerPoint presentation

4.
a. Define:
(i) Data security (ii)Data risk assessment
b. (i) Explain the term access control in database security
(ii) List two access control methods in database security
c. State three roles of a database administrator.

5.
Given an internet connected computer, outline a step by step procedure for carrying out the following operations:

a. how to log on to www.mybooks.com and obtain the prices of books W, X, Y, Z and M.
b. how to tabulate the prices in a worksheet, showing the prices in dollars and the naira equivalent, for each book and save the workbook as “Prices of Books”.
Assume that the prices of the books are given in dollars, [use $1.00 = N120.00]
c. how to send the workbook in 5(b) as an attachment to your father’s email address ( myfather@yahoo.com ) with the subject “Prices of Books”.

6.
A student was asked to record the type of vehicles that entered the school compound through the school’s main gate on a Monday morning. The passage below is an excerpt from the student’s report on the assignment.

“Report on the vehicular traffic at the gate on Monday. 1. Introduction: I was directed by the school principal to sit at the main gate and record the type and number of vehicles that passed through the gate on Monday morning. 2. Observation: I arrived the gate at about 8.00 am and left at 12 noon. During this period, I made the following observations: car, bus, bus, car, car, lorry, motorcycle, bus, bus, car, car, car, lorry, motorcycle, tricycle, motorcycle, car, tricycle, motorcycle, bus, bus” .

a.
 Beginning from the desktop, outline a step by step procedure of how to type the passage in MS Word using A4 paper size and portrait orientation.

b. State the procedure for carrying out the following operations in the passage:

i) Begin the second and third sentences in new paragraphs;
ii) Write the first sentence in capital letters, underline it and bold it;
iii) Begin the first letter of a sentence with capital letters;
iv) Represent the student’s observation in a table with three columns under the headings: Serial Number, Type of Vehicle, Number of vehicle.
v) Merge the first two cells of the last row of the table, type “Total” and give the total number of vehicles observed in the column for number of vehicles.
vi) Save the document
vii) Merge the first two cells of the last row of the table, type “Total” and give the total number of vehicles observed in the column for number of vehicles.
viii)Save the document with the name “vehicular traffic”;
ix)Print the document with the name “vehicular traffic”;
x)Print the document.