ABSTRACT
It is general belief that
computer, a multipurpose machine can perform any function without exception.
The achievement of its task is based on how the system has been programmed to
accomplish the task. Graphs charts are pictorial ways or methods of presenting
data; it is not convenient to represent manually. For us to get the best in
data presentation and also to draw the meaningful conclusion from data, we need
to present it in a graphical or pictorial from. The programming language to be
used to implement this project is visual basic 6.0 and Microsoft access as its
database, which serve as the back engine of the database, the programming
language is use because it is object oriented and user’s friendly.
TABLE OF CONTENTS
Title page
Certification ii
Dedication iii
Acknowledgement iv
Tables
of content v
Abstract vii
1.0
Introduction 1
1.1
Statement of problem 2
1.2
Purpose of the project 3
1.3
Significance of the project 5
1
.4 Scope of the project 7
1.5
Limitation of the project 8
1
.6 Definition of terms 9
CHAPTER TWO
2.0
Prologue 11
2
.1 Electronic spread sheet 13
2
.2 Historical background of an automated graph wizard 14
2.2
1 Legal battle 16
2.3
Microsoft excel 19
CHAPTER THREE
3
.0 System analysis 21
3
.1 Analysis of the existing system 21
3
.2 Inadequacy of the existing system 22
3.3
Analysis of the proposed system 23
3.4
Graphs and charts 24
3.4.1
Bar charts 24
3.4.2
Pie charts 25
3.4.3
Construction of pie charts 26
3.4.4
Graphs 26
3.5
Comparison between the existing and the new system 27
3.6
System specification 27
CHAPTER FOUR
4.0
System design and implementation 29
4.1
System design 31
4.2
Data input design 31
4.3
Output design 32
4.4
File design 33
4.5
System implementation 34
4.6
System documentation 35
4.7
System installation 26
4.8
System user guide 36
4.9
System change over 37
CHAPTER FIVE
5.0
Summary, Recommendation and Conclusion 38
5.1
Summary 39
5.2
Recommendation 40
5.3
Conclusion 41
Appendix
one: Screenshots 42
Appendix
two: Source Code 44
Appendix
Three: System Flowchart 48
Reference: 50
CHAPTER ONE
1.0 INTRODUCTION
Data
must be tabulated or presented in tables before being use for analysis professor
Bonly refers to tabulation as “the intermediate process between the
accumulation of data in whatever from they are obtained and the final reasoned
account of the result shown by the statistics” it is quite obvious and worth to
note that the tables are dependent of the information to be presented and the
purpose of which they are prepared.
Manually graph and charts are created
with the use of rule, graph papers, and protractors e.t.c. the accuracy of the
information obtained from the result of reading the corresponding value from
the graph and charts manually created are comparatively low computer to when
obtain from or by the use of an automated graph and chart wizard.
Computer being an electronic device that
accepts data as input, process it and bring out result of the processed data as
an output or information, its use, need and relevance in the implementation of
an automation graph and chat wizard cannot be disputed in statistical and data
analysis in particular.
1.1 STATEMENT
OF THE PROBLEM
The
main problem encountered in the existing system is that alteration of the point
generated due to the supplied data is not possible in the graph directly and at
the same time, the effect of the alteration does not reflect in the data input
table created simultaneously. That is to say that any change to be made on the
graph must be done by changing the data supplied on the data table.
1.2 PURPOSE OF THE PROJECT
There
are numerous purpose and objectives that can be derived from this study.
but
for the purpose of this project work and research the main purpose and
objective include the following.
1. To
research into the graph and chart.
2. To
design a reliable automation method of creating various graph and charts.
3. To
analyze the manual method of creating graph charts.
4. To
develop and implement a computer software application for dynamic generation of
graph and charts as output to the satisfaction of the users. The computer
software application is tagged “Automated
graph and chart wizard”
1.3 SIGNIFICANCE OF THE PROJECT
This
project has a wide range of significance to the staticians and other
researchers
that intend to analyze their data pictorially.
1.4 SCOPE OF THE PROJECT.
This
project work is limited to the generation of line graph bar charts, pie charts
and
curves.
1.5 LIMITATION OF THE PROJECT
Limitations
has to do with constraints, problems that were encountered in carrying out
there research work. There limitation include:
1. TIME CONSTRAINT: - Taking
into consideration all other academic activities, the time to work on the
project and carrying out these research was hindered inadequate.
2. FINANCE: - The
limit availability of the supply and source of found to the research affects
the project to some extent or even extensively.
3. POOR RESPONSE: - The
staticians were not favorably disposed to giving information and details
required from them to carryout a thorough research work on the project.
1.6 DEFINITION OF TERMS
GRAPH: - graph
is a drawing that uses a line or lines to show how two or more set of
measurements are related to each other.
BAR CHART:
There rectangular bars of equal widths but heights proportional to the
magnitude of their corresponding constituent of the total to be displayed.
AUTOMATED: -
this has to do with using machine to do job or industrial process.
COMPUTER:
An electronic device that accept data as input, process the given data and
produce the output of there processed data as information.
LINE GRAPH:
- A line graph is a chart, which displays how the different components of a set
of data vary with time.
SPREAD SHEET: - A
program that allows the user to create a large, two dimensional table on the
computer screen, and to manipulate the data in the table in many ways.
DATA:
-A representation of facts, concept, or instruction in a formalize manner
suitable for communication, interpretation, or processing by humans or by
automation means.
Buyers has the right to create
dispute within seven (7) days of purchase for 100% refund request when
you experience issue with the file received.
Dispute can only be created when
you receive a corrupt file, a wrong file or irregularities in the table of
contents and content of the file you received.
ProjectShelve.com shall either
provide the appropriate file within 48hrs or
send refund excluding your bank transaction charges. Term and
Conditions are applied.
Buyers are expected to confirm
that the material you are paying for is available on our website
ProjectShelve.com and you have selected the right material, you have also gone
through the preliminary pages and it interests you before payment. DO NOT MAKE
BANK PAYMENT IF YOUR TOPIC IS NOT ON THE WEBSITE.
In case of payment for a
material not available on ProjectShelve.com, the management of
ProjectShelve.com has the right to keep your money until you send a topic that
is available on our website within 48 hours.
You cannot change topic after
receiving material of the topic you ordered and paid for.
Login To Comment