KCSE COMPUTER PROJECT_2024

NAME: BEATRICE WAIRIMU

INDEX NO: 36635024023

SCHOOL: WEBUYE DEB SECONDARY SCHOOL

YEAR: 2024

TITLE: UZIMA BOREHOLE DRILLING SYSTEM

UNDER SUPERVISION OF: WANGILA AMBROSE

i
DEDICATION
I dearly Dedicate my project to my mother miss Nancy Nduta for providing me with

ii
ACKNOWLEDGEMENT
I would like to thank God for the life he has given me so as carry out my project this year. I
thank various guys for their inputs towards the success of my project. The people include: my
computer teacher MR. WANGILA AMBROSE for his guidance and technical advice in every
move till the end of my project which I used in development of my system, the principal MRS
OMBOLO SARAH for his financial support by ensuring the required resources are available to
facilitate the development and run of the project, My mother miss Nancy Nduta for their love
and guidance toward s me where by they ensured the payment of the school fee and providing
me with the required resources to carry out the project . I would like also to thank my fellow
students for their support and the understanding nature throughout the project.

iii
DECLARATION
I declare that this report and entire project is my original work and has never been presented in
Kenya National Examination Council before.

NAME OF THE STUDENT:

DATE Friday, May 10, 2024

SIGN…………………………………………………………………………….

NAME OF COMPUTER TEACHER: DAVID W BARASA

DATE: Friday, May 10, 2024

SIGN…………………………………………………………………………..

NAME OF THE PRINCIPAL: EUGENE O JUMA

DATE: Friday, May 10, 2024

SIGN……………………………………………………………………….

iv
Contents
DEDICATION.................................................................................................................................................ii
ACKNOWLEDGEMENT.................................................................................................................................iii
DECLARATION.............................................................................................................................................iv
CHAPTER ONE..............................................................................................................................................1
Introduction.............................................................................................................................................1
CHAPTER TWO.............................................................................................................................................2
SYSTEM ANALYSIS....................................................................................................................................2
Problem definition...............................................................................................................................2
CHAPTER THREE..........................................................................................................................................4
Information gathering.............................................................................................................................4
FINDINGS AFTER DATA COLLECTION.......................................................................................................6
CONCLUSION...........................................................................................................................................6
3.3 REQUIRED SPECIFICATION............................................................................................................7
3.3.1 OUTPUT SPECIFICATION.................................................................................................................7
3.3.2 INPUT SPECIFICATION.....................................................................................................................7
3.3.3 FILE/ DATA STORE...........................................................................................................................7
3.3.4 HARDWARE AND SOFTWARE..........................................................................................................7
HARDWARE REQUIREMENT.....................................................................................................................8
SOFTWARE REQUIREMENTS....................................................................................................................8
CHAPTER FOUR............................................................................................................................................9
SYSTEM FLOWCHART............................................................................................................................9
VARIABLES AND DATA TYPES.....................................................................................................................13
Clients Table design...............................................................................................................................13
DH table Design....................................................................................................................................13
Drilling Services table Design...............................................................................................................13
Items table Design.................................................................................................................................13
INPUT SCREENS.........................................................................................................................................14

v
 CLIENTS FORM.......................................................................................................................................14
DEPTH AND HEIGHT IN METERS FORM.................................................................................................15
DRILLING SERVICES FORM....................................................................................................................16
ITEMS FORM.........................................................................................................................................17
OUTPUT REPORTS......................................................................................................................................18
CLIENTS REPORT....................................................................................................................................18
DH TAX REPORT.....................................................................................................................................19
DRILLING SERVICE REPORT....................................................................................................................20
SYSTEM CONSTRUCTION...........................................................................................................................21
CLIENTS TABLE.......................................................................................................................................21
DEPTH AND HEIGHT TABLE.......................................................................................................................21
DRILLING SERVICES TABLE.....................................................................................................................21
ITEMS TABLE..........................................................................................................................................22
PLUMBING SERVICES TABLE..................................................................................................................22
RELATIONSHIP...........................................................................................................................................23
QUERIES.....................................................................................................................................................24
DH TAX QUERY.......................................................................................................................................24
DRILLING TAX QUERY.............................................................................................................................24
PUMPS TAX QUERY................................................................................................................................24
USER MANUAL...........................................................................................................................................26
INSTALLATION GUIDE AND REQUIREMENTS.............................................................................................27
LOADING PROCESS....................................................................................................................................28
NAVIGATION GUIDE..................................................................................................................................29
PROCEDURE OF PRINTING/GENERATING OUTPUTS..................................................................................30
CONCLUTION.............................................................................................................................................31
RECCOMMENDATION................................................................................................................................32
BIBLIOGRAPHY...........................................................................................................................................33
APPENDICES..............................................................................................................................................34
Appendix 1: Workers Form....................................................................................................................34
Appendix 2: Workers report..................................................................................................................35

vi
CHAPTER ONE
Introduction
Uzima Company is one of the leading borehole service providers in Kenya. They provide

borehole drilling services to industrial, commercial and domestic clients.

The company offers either symmetric drilling, or core drilling, or geo-technical drilling. After

the drilling, they install a water pump. Water pumps are of various types such as submersible

electric pumps, solar pumps and hand pumps. The pumps are charged according to; the depth

of the borehole, height of the tank above the ground and the type of the pump. They also install

tanks and charge depending on the capacity of the tank in litres. The company also offers other

services such as plumbing and pump maintenance. The plumping services are charged according

to the type of pipes, diameter of the pipes in inches, length of the pipes and the number of outlets.

Clients who are interested in these services are required to apply. The company then records their

details which include: Name, address, telephone number and details of the intended borehole

location among other details

1
CHAPTER TWO
SYSTEM ANALYSIS
Problem definition
The manual system for Uzima Borehole Drilling System had various problems.

i. High data duplication

ii. It’s not easy to update records
iii. Inaccurate records maybe produced.
iv. Waste of time due to searching of farmers records

 To overcome these challenges, we need to develop a computerized system that will

enable Uzima Borehole Drilling System to perform the following:

(a) Register and maintain a list of clients.

(b) Register items and services provided by the company.
(c) Computer each of the following:
(i) Total amount to be paid by each client.
(ii) Total amount charged on plumbing.
(iii) Tax paid by each client.
(iv) Total fees charged for survey and local authority.
(v) Total revenue generated by the company from each service from all clients.
(d) Generate appropriate reports. Existing system
Operation of current system for Uzima Borehole Drilling System has been manual which made
records in the company be processed manually. Therefore there is need of developing a new
computerized system that will increase level of accuracy and reduce time in operation

Proposed system
The proposed system is a computerized system for Uzima Borehole Drilling
System which will be using database i.e. Ms. Access
2.3.1 Objective of new computerized system
 Increase the accuracy in records for Drilling services.
 To reduce data duplication
 To reduce paper work in the company

2
2.3.2 Scope of new system

 The proposed new system solves the manual record like

reducing errors in calculation.

2.3.3 Benefits of new system

 Fast in retrieval of new record than manual.
 Saves on space compared paper work.
 Reduction of double data entry
 Reduction in errors
 It’s cheap to maintain and acquire

2.3.3.4 Feasibility study

I. Schedule feasibility- the time given out to develop new system

was enough to accomplish developing it.
II. Technology feasibility study- the technology available its
suitable for the establishment of the system.
III. Operation feasibility study-the operation that was carried out to
find out whether the user was friendly with the new system
IV. Economic feasibility study- the new system will be cheap to
acquire and cheap to maintain and the minute he or she
acquires the system and the required equipment to enable the
system to operate the will be no cost required again.

3
CHAPTER THREE
Information gathering
The new system was developed through several data collection methods such as;

 Observation- this was done by visiting the club members to know how they carry their
sports activities
 Interview- clients were interviewed
 Questionnaires- questions were prepared and sent to clients of the Uzima Borehole
Drilling System as shown below

The following is a sample interview that was used to get information

UZIMA BOREHOLE DRILLING SYSTEM INTERVIEW GUIDE

Interviewee Name…………………………………
Interviewer…………………………………

Date…………………………………time………………………..ID……………

Topic………………………………………………………………………………

Time Interview
1 to 2 minutes Introduction: Your name and purpose of the interview
.
2 to 4minutes Q1. . How do you record name of workers? Response

2 to 3 minutes Q2. How long is Uzima Borehole Drilling System?

4 to 5 minutes Q3. What are some of limitation you usually encounter

when generating Reports for Tax? Response.

7 to 8 minutes Q4 how many workers do you have in the company?

2 minutes Q5. Do you experience any loss case during record

keeping? Response.
3 minutes What is the mode do you use when collecting
registration fees?
Response

4
Questionnaires- question were printed for the purpose of getting information from Uzima Borehole
Drilling System. The following samples were used.

Please take few minutes to fill these questions and return it back. Use a tick to check the box.

Date…………………………………………………..

Q1: How is registration of clients done?

Computerized

Manual

Q2: how does the organization keep all record?

COMPUTERIZED:

MANUAL:

Q3. Do you think it serves best?

YES NO

Q4. Do you think method mentioned in (Q2) above is the best way?

YES NO

Q5. How long does it take to calculate TAX on services offered?

30 MINUTES

5 HOURS

5
 1 DAY

2 DAYS

Q6. How is the registration mode?

EXTREAMLY GOOD

GOOD

FAIR

FINDINGS AFTER DATA COLLECTION

After data collection the following were the findings
i. High loss of data due to improperly filling of documents.
ii. There was a lot of writing work (paper work).
iii. Delay & lack of resources like pens and books
iv. High cost of purchase of stationaries
v. Record keeping was done in files& books which led to time wasting during
searching for; farmers, retail traders and drivers.
vi. Errors occurred due to untidiness of record.
vii. The method is slower than computerized method

CONCLUSION
There is need to develop a computerized system that overcome these problems. Hence the system
is efficiently to use since it has greatly achieved our goals in terms of time and space occupied by
recorded data in record

6
 3.3 REQUIRED SPECIFICATION.

3.3.1 OUTPUT SPECIFICATION

 These are the design of both screen and printed out put requirements for
Uzima Borehole Drilling System, having all details of members, patrons,
games items and games.

3.3.2 INPUT SPECIFICATION

 What you input determines what you will output as GIGO says. Properly
designed screens and forms should be easy to use, effectively and appealing.
The screen for data entry of Uzima Borehole Drilling System should be
clearly captioned and easy to use. Some of data entry forms for this system
are; Clients form, Workers form, Drilling services and Pumping Services form
etc.…

3.3.3 FILE/ DATA STORE

After designing the input, the last designed step in that of file or data stores. In our
system there are two type of data storage in computer;

I. Database system

A database is a centrally store of data. This method of storage eliminates the

validation problem of flat system in Uzima Borehole Drilling System. The database
approach is used. This will ensure the objective of system is achieved.

II. Flat file system

This is where records are stored in separate file each with particular details. The use
of such separate file means that some data is often stored in more than one place.

3.3.4 HARDWARE AND SOFTWARE

After studying the detail system designed specification and management of Uzima
Borehole Drilling System I decided to settle for computerized system, therefore the
designing and developing must start looking for the requirement (hardware&
software).

7
 The table below shows the requirement specification.

HARDWARE REQUIREMENT
HARDWARE Model Price
REQUIREMENTS
Laptop/computer HP/dell/Lenovo/ Samsung 30000/-
Storage device CD’s, flash disk(8GB and above) 1,000/=
PRINTER EPSON L1138 23,000/=
Router Safaricom 5000/-
Binding facilities XUk 2500/-
Table 1

SOFTWARE REQUIREMENTS
SOFTWARE EXAMPLE ESTIMATED
COMPONENTS COST
APLICATION Ms office 2010 2000/-
PROGRAM
OS Windows 7 and 1500/-
above
ANTI-VIRUS SMADAV, avast, 1500/-
kersperskey
Table 2

8
CHAPTER FOUR

SYSTEM FLOWCHART

START

3
Registration
Request
Update
Details

com ndust
Register YES NO Input type of
merc rial
drilling
Clients details ial

NO YES
Solar YES
Input clients
Input clients details pump
YES dom records
?
estic

NO
NO Register
Register solar
Input survey and LAF
pump type
fees

Register Update
1
Details

Update
Details

9
 Core Update
drilli
NO Order as a clients Register Client
1
ng Group Records

YES 7 Installation
service
Down payment 6
fees
YES NO

Assign Paid Is
Installation Task ? NO Input Reg. No, Car client YES
Type, Cost per km serve
d

Update
Fees

Sola Sub Hand Pay fes?

NO electri NO NO NO
3 r? pump
c?

YES YES YES YES

Cost=90000 Cost=65000 Cost=30000 Go to step 3

Update
8
Records

10
 5

Depth Geo Core Syme

and NO Drilli NO drillin NO tric
Heigh ng g Drilli
t ng

YES YES YES YES

Fees=130000 Fees=225000 Fees=335000

0-
NO
100?

Cost=2500 Update records Update records Update records

YES

Cost per
meter=1000

Cost=2000

Go to step 5

Compute cost
per meter 9

11
 4

1 7

2 DATABASE 8

3
BANK
9

Calculate Total TAX for all services

Compute Tax = 16% Revenue

Compute Total TAX=16%*Cost

Generate various
reports

STOP

12
VARIABLES AND DATA TYPES
Clients Table design

Figure 1

DH table Design

Figure 2

Drilling Services table Design

Figure 3

Items table Design

13
Figure 4

INPUT SCREENS
CLIENTS FORM.

Figure 5

14
DEPTH AND HEIGHT IN METERS FORM

Figure 6

15
DRILLING SERVICES FORM

Figure 7

16
ITEMS FORM.

Figure 8

17
OUTPUT REPORTS
CLIENTS REPORT

Figure 9

18
DEPTH AND HEIGHT REPORT

Figure 10

19
DH TAX REPORT

Figure 11

20
DRILLING SERVICE REPORT

Figure 12

21
SYSTEM CONSTRUCTION
CLIENTS TABLE

Table 3

DEPTH AND HEIGHT TABLE

Table 4

DRILLING SERVICES TABLE

Table 5

22
ITEMS TABLE

Table 6

PLUMBING SERVICES TABLE

Table 7

23
RELATIONSHIP

24
QUERIES
DH TAX QUERY

DRILLING TAX QUERY

PUMPS TAX QUERY

25
TANK QUERY

TAX ON AMOUNT TO BE PAID QUERY

TOTAL AMOUNT TO BE PAID QUERY

26
USER MANUAL
Troubleshooting data entry related errors in the UZIMA BOREHOLE DRILLING SYSTEM

 Invalid and wrong data entry resulting to errors message being prompted on the screen.
Some of the messages are;

1. Error message: the changes you requested to the table were not successful
because they would create duplicate values in the index, primary key or
relationship.

 Description-you are trying to enter the same item twice

 Solution-avoid double entry

2. Error message:-the field contains null value because the required property in
the field is set true.

 Description-you are trying to proceed to another record or field yet

you have not typed the record required.

 Solution-type the record before proceeding to the next record.

3. Error message:-the value entered is not valid for the field.

 Description-you are trying to enter an invalid data type in the field. For
example, you are entering text in a numeric field such as number.

 Solution-enter the correct data type.

27
INSTALLATION GUIDE AND REQUIREMENTS
Insert the CD in the disk drive and open it by clicking on Computer icon then CD drive (D)

Or open the flash drive with the system and the double click it to open

28
LOADING PROCESS
 Click to start button

 Point to All programs

 Point to Microsoft office

 Click Microsoft access 2010, access home window will be displayed.

 On the file menu click open

 From the dialog box displayed, select Drive D (the CD) and double
click to open, Select Uzima Borehole Drilling System

 Or open from the USB drive if available

29
NAVIGATION GUIDE
 To open any record, output or form on the software, select the buttons from the
Dashboard below that contain the information you want.

Figure 13

Figure 14

30
PROCEDURE OF PRINTING/GENERATING OUTPUTS
Select the item you want to print

 Click print button and customize details on the print dialog box shown below

Figure 15

 Click print

31
CONCLUTION
The new system is efficient in working and its user friendly. The system will enhance the record
keeping. The system will also reduce the errors encountered in the record management and
reduce time of recording information.

32
RECCOMMENDATION
The system would result in efficient of processing of Uzima BoreHole Drilling System .It will
replace the manual system therefore it is recommended to be use by Uzima BoreHole Drilling
System. The system should be carefully handled and be free from viruses that can damage the
system.

33
BIBLIOGRAPHY
The following books and reference material were used to develop Uzima BoreHole Drilling
System.

 S. Mburu and G. Chemwa (2009) Secondary Computer studies book, four Longhorn
publishers-Nairobi

S. Mburu and G. Chemwa (2009) Secondary Computer book three, longhorn publishers-
Nairobi.

S. Mburu and G. Chemwa (2009) Secondary Computer book two, longhorn publisher-Nairobi.

34
APPENDICES
Appendix 1: Workers Form

APPENDICES 1

35
Appendix 2: Workers report

APPENDICES 2

36