BECE 2014 ICT Past Questions Paper 2 (Essay) – Answers

June 2014
INFORMATION AND COMMUNICATION TECHNOLOGY 2

Paper 2  –  ESSAY

ANSWERS

1. (a) (i) The application program used for the above figure
Microsoft Excel 
(ii) The formula / function used to calculate the profit for cell D7
=B7–C7 or =D3+D4+D5 or =SUM(D3:D5)
(iii) The formula / function used to calculate the total expenses for cell C7
=C3+C4+C5 or =SUM(C3:C5)
(iv) Names of the parts
A – Name box
B – Formula bar
C – worksheet/ worksheet window

(b)

(c) What print preview is used for
It shows exactly what a printed copy of the document will look like.
OR
It shows exactly what will be printed if the print command is given.

2 (a) Data types for the following as used in a spreadsheet application
(i) 13.65                   Value
(ii) 24.04’                  Label
(iii) =Sum(A5:G5)     Function
(iv) =A4+C8–G25       Formula
(v) +233244971100      Value

(b) Formatting a disk refers to
Organizing a disk / storage device in such a way that data can be stored on it.
Formatting a disk would delete all data which was previously stored on it.

3. (a) Toggle keys on a standard computer keyboard
CAPS LOCK, NUM LOCK, SCROLL LOCK

(b) Features of a web browser
 Navigation buttons (forward and back butttons)
 Address bar
 Search bar
 Stop button
 Refresh/ Reload button
 Print button

(c) Components of the central processing unit
 The Arithmetic and Logic Unit (ALU), which performs all calculations.
 The Control Unit (CU), which controls the flow of data around the computer.
 *Modern central processing units may also have a Memory component, which is used to stores data

(d) Operating system software (examples of)
 Linux,
 Windows (95/ 98/ ME/ 2000/ XP/ Vista/ 7/ 8)
 Macintosh System (Mac OS)
 Micro-soft Disk Operating System (MS-DOS)
 OS/2 Warp,
 Unix,
 Android
 etc

(e) Health hazards associated with prolonged use of computers and ICT tools
 Eye problems
 Back ache,
 Neck ache
 Wrist pain
 Ear problems / Hearing impairment
 *Cancer

4 (a) Examples of typing software
 Mavis Beacon Teaches Typing
 Life typing tutor
 Touch typist typing tutor
 Mac typing software
 TypingMaster pro
 Rapid Typing
 Letter Chase Typing Tutor
 TypeSmart typing tutor

(b) Reasons for books in
(i) hard copies formats
 Can be used without an electronic device
 Actual notes can be written and highlights made on its pages for easy reference.
 Can be accessed and used without electricity
 Can be used in areas where there is no electricity
 Information can be shared without using an electronic device
 Could be more portable than some computers

(ii) soft copies formats
• Searching for a particular information is easier and faster – using the search feature
• Sharing information across long distances is faster and easier – using the internet or intranet or removable storage media such as pendrives, compact discs, etc
• Saves space – Several e-books can be loaded onto a computer or other portable device
• Cheaper – due to its electronic format it costs less than equivalent books in hard copy formats
• Versatile – It is possible to change the font size, convert to audio, etc to suit the preference of the user.
• Can be read even in the dark without light
• Maintains its state, no matter how old – does not get old or dirty or torn, etc

(c) Arranging Compact disc, hard disk and pen drive in descending order of
(i) access speed
Hard disk, pendrive, compact disc
(ii) storage capacity
Hard disk, pendrive, compact disc

5. Purpose of the following commands on email applications such as yahoo or gmail
(a) My account
To keep a private record of all mails/ messages sent, received and drafted
(b) compose
To create a new message/ document / mail to be sent
(c) Attach
To add/ fix an already existing document on a storage media to a current message to be sent
(d) sign up
To register for the first time on an email application OR
To create a new email account