BECE 2013 ICT Past Question Paper Two
(a) ABC Supermarket has acquired an application to generate cash receipts for goods purchased by its customers as shown in the diagram below.
The amount for each item is obtained by multiplying the unit price and quantity of goods purchased. The subtotal is a summation of the amounts obtained for all purchased items. The tax payable is computed at the rate of 10% of the subtotal.
The total amount to be paid is the summation of the subtotal and the tax payable on purchased items.
Using the diagram below, answer the questions that follow
(i) Name the application program used in creating the above.
(ii) Identify the parts labeled I, II and III.
(iii) Provide the formula used in calculating the following cells.
D2………………………………………………………………………………
D5………………………………………………………………………………
D6………………………………………………………………………………
(b) Use the diagram below to answer questions (i), (ii) and (iii)
(i) Identify the diagram above.
(ii) Name the parts labeled A, B, C, D and E
(iii) State one function each of the parts labeled B and C in the diagram in (b) above.
(c) State one function of the diagram identified in (b) (i)
(a) (i) Application program used a Spreadsheet application / Microsoft Excel /Lotus 1-2-3 /Open Office / Visi Calc / Libra Office / Super Calc
(ii) Parts Labeled are:
I – Column
II – Cell
III – Row
(iii) Formulae used in the cells
D2 = B2*C2
D5 = SUM(D2:D4) or =D2+D3+D4
D6 = 10%*D5 or =0.1*D5 or =D5/10
(b) (i) The diagram is a computer keyboard
(ii) Parts
A – SHIFT Key
B – Space bar
C – Arrow keys / Directional Keys / Movement Keys
D – Enter key / Return Key
E – Function keys
(iii) Functions of the Keys
B – To create spaces in a text
C – To control the movement of cursor or in the navigation(scrolling) of documents
(c) The function of diagram in b (i) : To input data and/or commands into a computer or
To enter data characters (numbers, letters and/or symbols) and commands into a computer
(a) State two:
(i) positive uses of the internet;
(ii) negative uses of the internet.
(b) List four storage media
2. (a) (i) positive uses of the internet
• Advertisement – One can promote their business online
• Education – through distance learning, e-books, e-learning centers, etc
• Entertainment – through music, sports, movies, and games
• Information – Easy dissemination of and access to information – through search engines, blogs, news websites, etc
• Communication – through emails, chats, social networks, etc
• Trading (buying and selling) – through credit or debit cards, money transfer services, etc
• Payment of bills – through credit or debit cards, money transfer services, etc • Advertising of products and services.
(ii) negative uses of the internet
• Stealing / Theft – through hacking, impersonation, deception or other means.
• Creation of malicious software (malware), such as viruses, worms or Trojan horses, to damage or disrupt a computer system
• Copyright infringement – Violating the rights of others by unauthorized use or copying of their creative works.
• Hacking / Cracking – Tapping into confidential data in the computer systems of others without permission for various reasons.
• Pornography – publishing or viewing pornographic pictures or movies.
• Infringement of privacy – Accessing other people’s private information without their permission.
• Fraud – For fraudulent activities or Sakawa or 419
(b) Examples Of Storage media
• Hard disc drive
• External hard drive
• DVD
• CD
• Flash drive (pen drive)
• Memory card
• Magnetic tape
• Zip drive
• Floppy disk
(a) Explain communication as used in the computer industry
(b) Video conferencing refers to: …………………………………………………………………………………
(c) List two devices associated with video conferencing.
(d) State four media for sending and receiving information
3. (a) Communication as used in the computer industry is the transfer or exchange of information between or among two or more persons via a media, such as the mobile phone or a communication network
Or
Sending and/ or receiving information through a given media, such as telephone or the internet.
(b) Video conferencing – Holding a meeting through video and audio signals
Or
A meeting in which the participants are in different places but are connected by video and audio links
Or
Using video and audio signals to link participants at different and remote locations
Or
Live video and audio communication between three or more locations
(c) Devices associated with video conferencing
INPUT DEVICES
• Video camera
• Webcam
• microphones
• CD/ DVD player
• Cassette player
OUTPUT DEVICES
• Computer monitor
• television
• projector
• loudspeakers
• headphones
DATA PROCESSING
• Computer
DATA TRANSFER
• A Network, such as the internet
(d) Media for sending and receiving information
• Mobile phones
• Landline telephones
• Radio
• Television
• Internet
• Local Area Network (LAN)
• Newspapers
• Magazines
(a) In word processing application, when is it appropriate to use:
(i) copy-and-paste;
(ii) cut-and-paste;
(b) (i) What is a font?
(ii) List three font styles
4. (a) When it is appropriate to use in word processing,
(i) copy-and-paste – When data is being duplicated from one part to another.
(ii) cut-and-paste – When data is to be moved/ transferred to another part to another.
(b) (i) A font – A set of letters, numbers and symbols that share a unified design
Or
A complete set of type or printed or screen characters of the same design
(ii) Font styles
Times New Roman
Arial
Tahoma
Cambria
Calibri
Brush Script
Verdana
Monotype Corsiva
Britannic Bold
Broadway
Georgia
Castellar
Lucida Calligraphy
Algerian
(a) What is:
(i) motherboard
(ii) ergonomics
(iii) menu bar
(b) What is copyright used for?
5. (a) (i) Motherboard – The main circuit board of a computer containing the primary components of a computer system.
(ii) Ergonomics – The design of workplace or equipment for comfort, efficiency, safety, and productivity or the study of people’s efficiency in their working environment.
(iii) Menu bar – A horizontal bar usually displayed at the top of a computer screen or window, listing available menus for an application
(b) What copyright is used for
to promote the progress of science, technology, and the arts
to encourage the creation of new and improved intellectual works
to prevent the unlawful/unauthorized use and/or duplication of creative works
to protect the interests of the authors/creators of intellectual property
End Of Paper
End of BECE 2013 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