BECE 2014 ICT Past Questions Paper 2 (Essay)

June 2014
INFORMATION AND COMMUNICATION TECHNOLOGY 2
PAPER 2  –   ESSAY

1 ¼ hours
[60 marks]

SECTION A
[24 marks] Answer Question 1

1. (a)

Use the diagram above to answer questions (i) to (iv)
(i) Name the application program used for the above figure [2 marks] ………………………………………………………………………………………………………………………..

(ii) Write the formula/ function used to calculate the profit for cell D7 [2 marks] ………………………………………………………………………………………………………………………..
………………………………………………………………………………………………………………………..

(iii) Write the formula/function used to calculate the total expenses for cell C7.[2 marks] ………………………………………………………………………………………………………………………..
………………………………………………………………………………………………………………………..

(iv) Name the parts labelled A, B and C [3 marks] A ……………………………………………………………………………………………………………
B ……………………………………………………………………………………………………………
C ……………………………………………………………………………………………………………

(b) Complete the table below
[12 marks]

(c) In a word processing application, what is the command button print preview used for?
[3 marks] …………………………………………………………………………………………………………….
…………………………………………………………………………………………………………….

SECTION B
[36 marks] Answer three questions only from this section

2. (a) State the data types for the following characters as used in a spreadsheet application:
(i) 13.65 ……………………………………………………..[2 marks] (ii) 24.04’ ………………………………………………….. [2 marks] (iii) =SUM(A5:G5) …………………………………….[2 marks] (iv) =A4 + C8 – G25 ………………………………..[2 marks] (v) +233244971100 ………………………………..[2 marks]

(b) Formatting a disk refers to …………………………………………………………………………………………………………….
…………………………………………………………………………………………………………….
[2 marks]

3. List
(a) two toggle keys on a standard computer keyboard [2 marks] …………………………………………………………………………………………………………….
…………………………………………………………………………………………………………….

(b) three features of a web browser [3 marks] …………………………………………………………………………………………………………….
…………………………………………………………………………………………………………….

(c) two components of the central processing unit. [2 marks] …………………………………………………………………………………………………………….
…………………………………………………………………………………………………………….

(d) two operating system software [2 marks] …………………………………………………………………………………………………………….
…………………………………………………………………………………………………………….

(e) three health hazards associated with prolonged use of computers and ICT tools [3 marks] …………………………………………………………………………………………………………….
…………………………………………………………………………………………………………….

4. (a) Give two examples of a typing software. [2 marks] …………………………………………………………………………………………………………….
…………………………………………………………………………………………………………….

(b) Certain books are published both in hard copies and soft copies (e-books). Give two reasons for using
(i) hard copies formats; [4 marks] …………………………………………………………………………………………………………….
…………………………………………………………………………………………………………….
(ii) soft copies formats [4 marks] …………………………………………………………………………………………………………….
…………………………………………………………………………………………………………….
(c) Arrange the storage devices, compact disc, hard disk and pen drive in descending order of
(i) access speed; [1 mark] …………………………………………………………………………………………………………….
…………………………………………………………………………………………………………….
(ii) storage capacity. [1 mark] …………………………………………………………………………………………………………….
…………………………………………………………………………………………………………….

5. State the purpose of the following commands on an email application such as yahoo or gmail:

(a) My account;    [3 marks] …………………………………………………………………………………………………………….
…………………………………………………………………………………………………………….

(b) Compose;        [3 marks] …………………………………………………………………………………………………………….
…………………………………………………………………………………………………………….

(c) Attach;             [3 marks] …………………………………………………………………………………………………………….
…………………………………………………………………………………………………………….

(d) Sign up;           [3 marks] …………………………………………………………………………………………………………….
…………………………………………………………………………………………………………….

END OF PAPER 2