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                                                        1

1.2 Purpose of the project                                                        2

1.3 Significance of the project                                                  2

1 .4 Scope of the project                                                          2

1.5 Limitation of the project                                                    3

1 .6 Definition of terms                                                            3

CHAPTER TWO

2.0 Prologue                                                                            5

2 .1 Electronic spread sheet                                                     5

2 .2 Historical background of an automated graph wizard      7

2.2 1 Legal battle                                                                     7

2.3 Microsoft excel                                                                   8

CHAPTER THREE

3 .0 System analysis                                                                10

3 .1 Analysis of the existing system                                         10

3 .2 Inadequacy of the existing system                                    10

3.3 Analysis of the proposed system                                        11

3.4 Graphs and charts                                                             11

3.4.1 Bar charts                                                                       11

3.4.2 Pie charts                                                                        12

3.4.3 Construction of pie charts                                              12

3.4.4 Graphs                                                                           13

3.5 Comparison between the existing and the new system      15

3.6 System specification                                                          16

CHAPTER FOUR

4.0 System design and implementation                                   18

4.1 System design                                                                             18

4.2 Data input design                                                              18

4.3 Output design                                                                             19

4.4 File design                                                                         19

4.5 System implementation                                                     20

4.6 System documentation                                                      20

4.7 System installation                                                            20

4.8 System user guide                                                             21

4.9 System change over                                                           21

CHAPTER FIVE

5.0 Summary, Recommendation and Conclusion                    22

5.1 Summary                                                                           22

5.2 Recommendation                                                               22

5.3 Conclusion                                                                        22

Appendix one

Appendix two

Appendix three

Reference:

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.

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 form 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 have to do with constraints, problems that were encountered in carrying out there research work. There limitation includes:

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 carry out 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.