FORM THREE ANNUAL JOINT MARKING SCHEME 2024
036/1 INFORMATION AND COMPUTER STUDIES 1
1. Multiple choices 10 MARKS
i ii iii iv v vi vii viii ix x
B A B D A B C B B D
2. Matching items 6 MARKS
LIST A i ii iii Iv v vi
LIST B F A C H G E
SECTION B (54 MARKS)
3. Advancement of technology has bring positive changes in both social and economic
aspects, explain the following in relation to economic development:
i. Electronic banking
● Is a system of banking though which financial transactions are done by
an exchange of electronic signals in place of transactions that were
formerly done through cash and cheque. 2 MARKS
ii. Electronic marketing
● Is a process of advertises or marketing goods and services. Tools that
facilitates marketing are TV, Radio, Mobile phone 2 MARKS
iii. Electronic ticketing
● Is a digital system of paying services such as booking for transport (air
and marine) and social events (games and sports) 2 MARKS
iv. Electronic learning
● Is a system of learning through internet 1 MARK
v. Mobile banking
● Is a service that allows customers to perform banking transactions
using cellular device. 2 MARKS
4. You have been appointed to teach form three student the topic of “web development”
as starting the session
a) Explain four importance of webpage design
● Creating competitiveness
● Consistency in branding your online business
● Impressing your audience
● Creating trust to your audience
4 MARKS
b) Mention two examples of web browser which can be used to view web page.
1
● Mozilla Firefox, Google chrome, Safari, Opera. Any two 1 MARK
c) Explain the html document structure
● <html>
● <head>
● <title>
● </title>
● </head>
● <body>
● </body>
● </html> 4 MARKS
5. Computer is an electronic device used to input data, process and give out information
according to the set of instructions.
i. Explain five characteristics of computer which makes it differ from other
electronic devices.
● Speed
● Accuracy
● Storage
● Tirelessness
● Automation 5 MARKS
ii. Briefly explain the use of computer in
a) Hospital
● Diagnosis, Research for medicine, Treatments, ICT and
Medicine, Medical records. 2 MARKS
b) Educational
● E-learning
● Helps in school administration and management
● Promote inclusive education 2 MARKS
6. Computer hardware is categorized based on their operations, namely input, processing,
storage and output.
i. Describe them briefly and give one example each
● Input devices – are those devices used to enter data in a computer
example keyboard, mouse 1 MARK
● Processing device- is a device used to manage and control all operation
in a computer. Example Central Processing Unit 1 MARK
● Storage devices – are those devices used to store data in a computer.
example Hard disk, Floppy disk, CD/DVD 1 MARK
● Output devices- are those devices used to give out data/information.
Example monitor, Printer, Speaker 1 MARK
ii. With aid of diagram, explain three functional elements of CPU 5 MARKS
2
• Contro Unit (CU) – coordinates all processing activities in the CPU as well as input,
storage and output operations. It determines which operation or order of the
instructions should be executed. To coordinate these activities, the control unit uses a
system clock.
• ARITHMETIC AND LOGIC UNIT (ALU) - This deal with all arithmetic and logic
operations. The basic arithmetic operations include: Addition (+), Subtraction(-),
Multiplication (*) and division (/).
• Main memory – are devices that is capable of storing information. There are two
types of computer memory
7. A) What is data processing?
● Is a process through which facts, figures and other related raw data are collected,
assigned meaning for future use. 2 MARKS
B) In population census, a lot of data is collected which needs processing. Which type
of data processing systems is most appropriate for such processing? Explain it.
• Electronic data processing – because this types use computer program to enter,
summarize, analyze or convert data into usable information. 2 MARKS
C) Why is data processing important? Five points (5)
• Speed and accuracy
• Storage facility
• Low cost
• Information costs
• Reports are created easily 5 MARKS
8. Makambako University offers the course of Information Technology (IT) in academic
year 2024-2025. Study the following snap shoot and then answer the question bellow:
3
a) What are the cell references of DB,Kasusu, Subject, Columan Kibamba
● DB – E4
● Kasusu – B9
● Subject – E3
● Columan Kibamba – D7 05 @ = 02 MARKS
b) Give out the function used to compute Full name
● = CONCATENATE(B5," ",C5) 01 MARK
c) Suppose you are required to generate a pie chart that displays full name and
Pass Marks. Which steps would you follow to generate the pie chart?
● Select full name then press control key without release click average
● Click insert menu
● Click chart, then select type of chart,
● Click it. 05 @ = 02 MARKS
d) It is noted that if the average is greater than 70 the remarks should be “Pass”
otherwise “repeat”. State the formula to compute the Remarks.
● =IF(I5>70,"PASS","FAILURE") 01 MARK
e) Mention the name of the active cell
● N8 01 MARK
f) If the value in cell F8 is to be changed to 80, how many cells altogether will
change?
● Three (3) cells will change 01 MARK
g) What formatting feature is applied in E4?
● Alignment – rotation 01 MARK
SECTION C (30 MARKS)
4
Answer two (2) questions from this section
9. Information dissemination is a process of transmit information from source to the
receiver. It reduces time wasting in sending data, although there are some barriers which
hinder effective information dissemination. Explain four (4) barriers.
● Selecting the medium which that is not understandable to the audience
or receiver
● Using knowledge beyond the receiver’s level of understanding
● Language barriers
● Noise
● Faults in mass media
Any four related to it 3@ marks= 12 MARKS
Introduction 1.5 MARKS
Conclusion 1.5 MARKS
10. A school management decided to shift from manual way of processing data in a
school to electronic system. Explain four importance of database systems.
● Easy sharing of data
● Controlling redundancy
● Efficiency
● Easy data validation
● Easy access
● Easy to link
Any four related to it 3 @ marks = 12 MARKS
Introduction 1.5 MARKS
Conclusion 1.5 MARKS
11. Briefly explain the applications of word processing in your school and community.
● Lesson preparation
● Teaching and learning process
● Admistrative issues
● Preparation of exams
● E – content generation
● Teaching aids
Any four related to it 3 @ marks = 12 MARKS
Introduction 1.5 MARKS
Conclusion 1.5 MARKS
