BECE 2014 ICT Past Question Paper Two

1

(a) 
2014-Ict-bece-past-question-1a-image

Use the diagram above to answer questions (i) to (iv)
(i) Name the application program used for the above figure
(ii) Write the formula/ function used to calculate the profit for cell D7
(iii) Write the formula/function used to calculate the total expenses for cell C7.
(iv) Name the parts labelled A, B and C

(1b) Complete the table below

(c) What print preview is used for

(i) Microsoft Excel
(ii) =B7–C7 or =D3+D4+D5 or =SUM(D3:D5)
(iii) =C3+C4+C5 or =SUM(C3:C5)
(iv) A – Name box
B – Formula bar
C – worksheet/ worksheet window

1(b)
2014-Ict-bece-past-question-1b-answer-image

1(c)Print preview is a function provided for displaying a page, document or any other material before it is sent to a printer. Print preview is a useful function to users as it helps them to see how the final printed material will appear.

SECTION B

1

 (a) State the data types for the following characters as used in a spreadsheet application:

(i) 13.65
(ii) 24.04’
(iii) =SUM(A5:G5)
(iv) =A4 + C8 – G25
(v) +233244971100

(1b) Formatting a disk refers to………………………………………………………… 

(i) Value
(ii) Label
(iii) function
(iv) formula
(v) Value

Disk formatting is the configuring process of a data storage media such as a hard disk drive, floppy disk or flash drive for initial usage. Any existing files on the drive would be erased with disk formatting.

2

 List two toggle keys on a standard computer keyboard

(2b) List three features of a web browser

(2c) List two components of the central processing unit.

(2d)List two operating system software

(2e)List three health hazards associated with prolonged use of computers and ICT tools

a)
CAPS LOCK, NUM LOCK, SCROLL LOCK

b)
Basic internet browser features

Navigation buttons.
Refresh button.
Stop button.
Home button.
Web browser’s address bar.
Integrated search.
Tabbed browsing.
Bookmark buttons.

c)
The arithmetic logic unit (ALU), which performs arithmetic and logical operations.
The control unit (CU), which extracts instructions from memory and decodes and executes them, calling on the ALU when necessary.

d)
Microsoft Windows (like Windows 10, Windows 8, Windows 7, Windows Vista, and Windows XP)
Apple’s macOS (formerly OS X)
Linux
Chrome OS
BlackBerry Tablet OS

e)
 Eye problems
 Back ache,
 Neck ache
 Wrist pain
 Ear problems / Hearing impairment
 Cancer due to Radiation

3

(a) Give two examples of a typing software.

(3b) Certain books are published both in hard copies and soft copies (e-books). Give two reasons for using
(i) hard copies formats
(ii) soft copies formats

(3c) Arrange the storage devices, compact disc, hard disk and pen drive in descending order of
(i) access speed;
(ii) storage capacity.

a)
 Mavis Beacon Teaches Typing
 Life typing tutor
 Touch typist typing tutor
 Mac typing software
 Typing Master pro
 Rapid Typing
 Letter Chase Typing Tutor
 Type Smart typing tutor
 Mavis Beacon Teaches Typing
 Life typing tutor
 Touch typist typing tutor
 Mac typing software
 Typing Master pro
 Rapid Typing
 Letter Chase Typing Tutor
 TypeSmart typing tutor
 KeyBlaze
 Klavaro Touch Typing Tutor
 Typing Trainer
 Rapid Typing Tutor
 Max Type Pro
 Type Faster
 Bruce’s Unusual Typing Wizard
 Stamina Typing Tutor

b)
(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
b)
(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)
(i) access speed: Pendrive, Hard disk, compact disc
(ii) storage capacity: Hard disk, Pendrive, compact disc



4

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

(a) My account

(b) Compose

(c) Attach

(d) Sign up

(a) My account : To keep a private record of all mails/ messages sent, received and drafted

(b) Compose : To create a new email to be sent.

(c) Attach : To add media or document to the email to be sent

(d) Sign up : To create an account

End Of Paper

End of BECE 2014 ICT Past Question Paper Two, Thank you for visiting this page, if any spelling mistake or wrong answers are spotted kindly notice us in the comment section below remember to share page to friends and famillies who may need it

0 0 vote
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments

BECE

Answers