AVE-AFIADENYIGBA E. P.

BASIC SCHOOL
FEBRUARY 2020 M0CK EXAMINATION
INFORMATION AND COMMUNICATION TECHNOLOGY 2&1
ESSAY (1 HR 20 MINUTES)
SECTION A (24 MARKS)
Answer question 1 (compulsory)
1. 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 of 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 the
purchased item.
Using the diagram below, answer the questions that follow.

A B C D

1 Item Quantit Unit Amount III

y Price
2 Milk 15 2 30

3 25 3 75

4 5 1 5

5 Subtota 110
l
6 Tax 11
Payable
7 Total 121
Amount

I II
i. Name the application used in creating the above. [2 marks]
ii. Identify the parts labelled I, II and III. [3 marks]
iii. Provide the formula used in calculating the following cells [6 marks]
a) D2
b) D5
c) D6
b. Identify the following ICT tools: [6 marks]

1
 (i) (ii) (iii)

c. Explain the following software:

[4 marks]
i. System software
ii. Application software
d. State the function of each of the following buttons as used in application software:
[3 marks]
i. Minimize;
ii. Maximize
iii. Close
SECTION B (36 MARKS)
Answer three questions only from this section.
2. a. State two [4 marks]
i. positive uses of the internet
ii. negative used of the internet
b. List four storage media [4 marks]
c. State the purpose of the following commands on an e-mail application such as Yahoo mail or
Gmail. [4 marks]
i. My account
ii. Compose
iii. Attach
iv. Sign Up
3. a. Explain the following terms: [8 marks]
i. motherboard
ii. ergonomics
iii. menu bar
iv. copyright
b. Arrange the following storage devices: compact disc, hard disk and pen drive in descending
order of [4 marks]
i. access speed
ii. storage capacity
4. a. State the data types for the following as used in spreadsheet application: [5 marks]
i. 13.64
ii. 24.04’
iii. =SUM(A5:G5)
iv. =A4+C8-G25
v. +233244971100
b. Formatting disk refers to ………………………. [3 marks]
c. Certain books are published in both hard copies and soft copies (e-books). Give one reasons for
doing using [4 marks]
i. Hard copies format

2
 ii. Soft copies format
5. a. List [10 marks]
i. Two toggle keys on a standard computer keyboard
ii. Three features of a web browser
iii. Two operating systems
iv. Three component of the central processing unit (CPU)
b. Write down two examples of typing software. [2 marks]

OBJECTIVE TEST
45 minutes
1. The brain of the computer is the 6. A folder within another folder is called
A. monitor B. system software A. file B. subfolder
C. read only memory C. inside folder D. innermost folder
D. central processing unit 7. Processed material which is meaningful
2. An example of output device is the to the user in computing is called
A. keyboard B. mouse A. data B. file
C. printer D. scanner C. information D. record
3. One byte is equal to 8. The copyright laws protect the works of
A. two bits B. eight bits an author for a period of his life time and
C. sixteen bits D. one thousand bits A. 40 years after his death
4. To boot a computer means to B. 50 years after his death
A. put it off B. put it on C. 60 years after his death
C. restart it D. take it away D. 70 years after his death
5. The horizontal bar that normally lies at 9. An example of a function key on a
the bottom of a computer desktop screen computer keyboard is
is called A. F1
A. taskbar B. start button B. Q
C. horizontal ruler D. quick launch C. @
toolbar D. NmLk

3
10. Entry of data into a computer is termed A. Internet B. Input devices
A. input B. output C. Computer network
C. process D. distribution D. Removable storage devices
11. The following are hardware components 21. The following are features of a word
except processing application window except
A. keyboard B. monitor A. desktop B. font
C. mouse D. windows C. print D. zoom
12. The following devices can be found in the 22. Which of the following is not a
system unit except component of a uniform resource locator
A. ports B. memory (URL)?
C. motherboard D. scroll wheel A. Web protocol B. Name of browser
13. The method of reproducing copies of a C. Name of web server
document is termed D. Name of the file with the directory
A. copying B. pasting 23. The speed of modem is measured in
C. photocopying D. printing A. baud B. bit
14. Storage media that are similar to C. byte D. hertz
compact discs but store more data are 24. A special software that is used to access
known as the internet is called
A. pen drives B. hard disks A. address bar B. search engine
C. floppy disks D. digital versatile C. web browser D. windows xp.
discs. 25. One billion bytes is approximately one
15. To boot a computer system, the user A. gigabyte B. kilobyte
needs C. megabyte D. terabyte
A. printer attached 26. Changing the desktop wall paper of a
B. operating system computer is termed
C. virus checking program A. background change
D. word processing software B. editing the desktop
16. The number of command buttons on the C. customizing the desktop
control menu are D. formatting the desktop
A. 2. B. 3. 27. The use of ICT in learning and teaching is
C. 4. D. 5. to make it
17. The location where a file is stored is A. interesting and boring
called B. uninteresting but not boring
A. folder B. icon C. interesting but students do not learn
C. page D. website at their pace
18. Viewing television for long periods can D. easy and interesting, students learn at
damage an individual’s their pace.
A. eye B. head 28. To create a space between characters,
C. mouth D. nose words and sentences, use the
19. Which of the following is an effect of loud A. backspace key B. enter key
ringing tone of mobile phone? C. shift key D. spacebar key
A. Headache B. Wrist pain 29. Which computer keyboard key allows
C. Bleeding nose D. Damage to users to erase characters to the left of
hearing the cursor?
20. Which of the following cannot cause A. Backspace key B. Delete key
computer virus infection? C. Insert key D. Tab key
4
30. The process that is used to recall a 35. Which of the following options is used to
document previously saved is termed access a message from an Inbox in an
A. Copy B. Enter electronic mailing?
C. Open D. Save as A. Mail B. Send/ Receive
31. Double-clicking on a program icon on a C. Import / Export D. Create New
computer desktop Account
A. cuts the program’s window 36. Which of the following should a user
B. copies the program’s window bypass before accessing an email?
C. closes the program’s window A. Gmail and password
D. opens the program’s window B. Yahoo and username
32. Which of the following steps will open, C. Password and username
check and correct errors, and submit the D. Computer name and password.
file for safe keeping under a word 37. Which of the following command buttons
processing application? in the browser enables a user to fetch the
A. File, Open, Edit and Save latest copy of the webpage?
B. Open, File, Edit and Save A. Backward B. Forward
C. Open, File, Close and Save C. Refresh D. Stop
D. Start, Open, Edit and Save 38. A spreadsheet cell name is referenced by
33. The process of a user placing the cursor a
at one end of a text, holds down the left A. letter B. number
mouse button and drag to the other end C. letter and number
of the text is referred to as D. number and letter.
A. copying B. cutting 39. Mathematical calculations in a
C. moving D. selecting spreadsheet application are called
34. Previewing a document before printing is A. labels B. formulae
necessary because it C. numbers D. values
A. formats the document. 40. 40. In a spreadsheet application, which of
B. displays the name of the document. the following can be identified by a
C. displays copy and paste of documents. letter?
D. displays how the document will look A. Cell B. Column
after printing. C. Range D. Row