BECE 2014 ICT Past Question Paper Two
(a)
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)
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
(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.
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
(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
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