COMPUTER STUDIES FORM 2 APRIL ASSIGNMENT 2025
NAME:………………………………………………………….. CLASS………………………………….
1. Give an example of a: (3 marks)
a) i) Device that reads data.
ii) Pointing device.
iii) Voice input device.
b) What are computer scanning devices? Name the type of scanner used: (3 marks)
i) To capture prices of goods at points of sale terminals in supermarkets and superstores.
ii) To grade multiple choice examination
c). Briefly describe how each of the following I/O devices work. (3 marks)
i) Tracker ball. ii) Touch screen.
iii) Light pen.
iv) Graphic (Digitizing) Tablet.
v) MICR.
vi) OCR.
vii) Speech (voice) recognition device.
2 Explain the role/use of the following features in a word processor: (2 marks)
(a) Find and Replace.
(b) Undo and Redo.
(c) Thesaurus.
(d) AutoCorrect.
ii. Differentiate between bolding and highlighting text. (1 mark)
iii Name and explain the use of any three buttons found in a Spell-check dialog box.
iv. List the steps that you would use to correct wrongly-spelled words in a document using the spell-
checking feature. (3 marks)
3. Clearly explain the meaning of the following terms as used in word processing: (3 marks)
(a) Blocking text.
(b) Word wrap.
(c) Italicizing text.
b Apart from Microsoft Excel, give any two other application programs classified as spreadsheets.
b. Explain five application areas where spreadsheet software can be used.(3 marks)
c. Describe any five features (advantages) of electronic spreadsheet software.
d Explain the following terms as used in spreadsheets. (3 marks)
i. Columns.
ii. [Link]
iii. iii Cell.
Page 1 of 4
iv. [Link].
v. v. Automatic recalculation.
e. Explain the concept of ‘What if’ analysis. Ii. Explain the term ‘Range’. (3 marks)
(f) State two actions that can be performed on ranges in Microsoft Excel. ` (2 marks)
4. The following information shows the income and expenditure for “Bebayote” matatu for five
days. The income from Monday to Friday was Kshs. 4,000, 9,000, 10,000, 15,000, and
12,000 respectively while the expenditure for the same period was Kshs. 2,000, 3,000, 7,000,
5,000, and 6,000 respectively.
(i) Draw a spreadsheet that would contain the information. Indicate the rows as 1, 2, 3 ….
and the columns as A, B, C ….. (3 marks)
5. State the expression that would be used to obtain:
a. Monday’s profit
b. Total income
c. highest expenditure
.
A worksheet contains the data as shown below. A B C D E F G 1 5 10 2 7 15 3 10 17 4 5 6 7 8 9 10
b. (a) The formula =COUNTIF (C1:C3, “> 10”) was entered at G1. Write down the value that was displayed. (3
marks)
c. (b) Write down the formula that would be entered at cell B7 to sum the values in column A whose
values are greater or equal to 5.
d. (c) The formula = $C2 + C$3 is entered in cell C5 and then copied to D10. Write down the formula as
it appears in the destination cell. (3 marks)
e. (d) What is a Chart wizard in spreadsheets? (ii) Give two examples of charts that you know
6. Explain the following terms as used in computer science: (2 marks)
(a) Data.
(b) Program.
(c) Data processing.
(d) Information.
7. What role(s) does each of the following units of a computer play during data processing?
i). Input unit. (3 marks)
ii). Output unit.
iii). Central processing unit.
8. List down four characteristics of a computer. (4 marks)
[Link] four different parts that make up a computer. (2 marks)
10 (a) Explain the term System Unit.
(b) Name four components found in the System unit. (4 marks)
(c) Outline three features of a computer’s System Unit. (3 marks)
11. (a) What are peripheral devices? (1 mark)
(b) Give two examples of peripheral devices. (1 mark)
12. Highlight the five generations of computer and their technologies used
Page 2 of 4
(b) Computers have evolved through a number of generations. List any 4 characteristics of the First
generation of computers. (4 marks)
(c) Give four differences between today’s computers and the first generation computers. (4 marks)
12.(a) State and explain five factors considered when classifying computers according to generations.
(5 marks)
13. Explain four methods of classifying computers. (4 marks)
14. Giving two points in each case, state the difference between the following types of computers.
(a) Supercomputer and Mainframe computer. (2 marks)
(b) Digital computer and Analogue computer. (2 marks)
(c) Special-purpose (dedicated) computer and a General-purpose computer. (2 marks)
(d) Desktop computers and Laptop computers.
15. (a) Explain the emerging trends in Microcomputer technology in relation to size. (1 mark)
(b) Give two reasons why smaller computers like Laptops tend to be more expensive than Desktop
computers. (2 marks)
15. (i) Explain four reasons which make laptop computers suitable for personal computing work.
(ii) Recommend any two application areas that would require the use of laptop computers. (2 mrks)
16. Give three reasons why a Mobile phone is regarded to be a computer. (3 marks)
17. State a specific example where each of the following types of computers can be used.
(a) Supercomputer(1 mark)
(b) Mainframe computer. (1 mark)
(c) Minicomputer. (1 mark)
(d) Microcomputer / Personal computer. (1 mark)
18. (a) Differentiate between a Minicomputer and a Personal Computer.(2 marks)
(b) List three factors to be considered when purchasing a microcomputer.(3 marks)
(c) Explain four reasons which make microcomputers suitable for personal computing work.
19. (a). Explain how computers are used in the following areas to process data. (10 marks)
i). Supermarket.
ii). Hospitals.
iii). Banks.
iv). Hotels.
v). Homes.
vi). Schools/education centres.
vii). Industries.
viii). Police station.
ix). Transport industry.
x). Offices.
(b) Give three advantages of using computers for data processing over other types of office
and business equipment. (3 marks)
20. (a) Define the term ‘Computer laboratory’ and give three factors to be considered when preparing
a computer laboratory. (4 marks)
(b) Mention any FOUR features which a standard computer laboratory should have.
Page 3 of 4
21. (a) State and explain three safety precautions and practices in a computer laboratory. (3
(b) State four precautions that should be taken when handling diskettes. (4 marks)
22. Njeru the lab technician wants to buy a fire extinguisher for the computer lab. Which type of
extinguisher is the most suitable for the computer laboratory? (1 mark)
23. (a) Give one major environmental and one energy problem Kenya faces as far as computer
installations are concerned. (1 mark)
(b) How could these problems be avoided? (2 marks)
24. What actions should be taken in case of a fire outbreak in the computer laboratory? (4 marks)
22. Describe the ideal environment for a computer to work properly. (3 marks)
23. A worksheet contains the data as
shown below.
(a) The formula =COUNTIF (C1:C3, “> 10”) was entered at G1. Write down the value that
was displayed. (2 marks)
(b) Write down the formula that would be entered at cell B7 to sum the values in column A
whose values are greater or equal to 5. (3 marks)
(c) The formula = $C2 + C$3 is entered in cell C5 and then copied to D10. Write down the
formula as it appears in the destination cell. (3 marks
Page 4 of 4