Data Processing Past Questions and Answers

(a) Use the information in the spreadsheet to answer questions s(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 fir 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 short cut on the desktop.
(iv) After launching the application, what is the name of the slide taht appears by default?
(v) Identify the oart labeled I.
(vi) Write the keyboard shortcut that would also perform the function labeled I.
(vii) Mention three functions that can be performed by the insert button.

(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)

Field	Data Types
Full Name	Text
Mat No.	Text
Date of Birth	*
Fees	*
Address	Memo

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

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

Convert 4\(_2\) to a number in base two

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