ICT BECE 2014 Essay - Paper 2

BECE 2014 ICT QUESTIONS

INFORMATION AND COMMUNICATION TECHNOLOGY

ICT – ESSAY (Paper 2)

1 hr 15mins

SECTION A

[24 marks]

Answer Question 1 [Compulsory]

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]

[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]

............................................................................................................................................................................................................................................................................................................................................................................................................

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

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

(d) Sign up; [3 marks]