Project

CENTRAL BOARD OF SECONDARY
EDUCATION
DR. VIRENDRA SWARUP PUBLIC SCHOOL
BAKEWAR, BINDKI
Session - 2024 – 25
SUBJECT – Informatics Practices
(065)
A Project Report On:
Olympic Analysis System
Submitted to : Mr. Roshan Pandey
Submitted by : Kushal Omar
Class : 12th
Roll No. :
INDEX
1) Certificate
2) Declaration
3) Acknowledgement
4) Preface
5) Objective of Project
6) Requirement and Analysis
7) Coding and programs
8) Output Screens
9) Limitations of Project and
conclusion
10) References
CERTIFICATE
This is to certify that Kushal Omar of class XIIA,
has prepared the report on the project
entitled ‘OLYMPIC ANALYSIS SYSTEM’. The
report is the result of his effort and
endeavours. The report is found worthy of
acceptance as final project report for the
subject of Informatics Practices (065) of class XII
under the CBSE curriculum 2024-25. He has
prepared the report under my guidance.
Mr. Roshan Pandey

PGT(Informatics Practices)
DECLERATION
I hereby declare that the project work entitled
‘OLYMPIC ANALYSIS SYSTEM ’ submitted
to Department of Informatics Practices, Dr.
Virendra Swarup Public School is prepared by
me. All the coding and Project report is result
of my personal effort.
Name: Kushal Omar

Class: XIIA
Roll No:
Acknowledgement
I would like to express a deep sense of thanks

& gratitude to my project guide Mr.Roshan
Pandey Sir , for guiding me immensely through
the course of the project. He always evinced
keen interest in my work. His constructive
advice & constant motivation has been
responsible for the successful completion of
this project.
My sincere thanks go to Mrs. Urmila
Sharma ,Our principal Mam, for her co-
ordination in extending every possible support
and IT infrastructure for the completion of this
project.
I also thanks to my parents for their
motivation & support. I must thanks to my
classmates for their timely help & support for
compilation of this project.
Last but not the least, I would like to thank all
those who had helped directly or indirectly
towards the completion of this project. .
Name: Kushal Omar
Class: XII-A
PREFACE
The sole reason of making this project is to
celebrate India’s best ever Olympic
performance in Tokyo Olympics 2020.
The purpose of this project was to develop the

Management Information System (MIS) and to
automate the record keeping me medals with
respective countries. It mainly consists of
computerized database, a collection of inter
related tables/CSV files, capable to produce
different reports according to the user. Using
Application program (Python) or front-end, we
can store, manage, retrieve all information in
proper way. The software being simple in
design and working, does not require any
prerequisite training to users, and can be
used as a powerful tool for automating our
“Olympic Analysis System”. To make
analysis much easier a user friendly interface
was used to keep records of countries in most
detailed and coordinated manner.
OBJECTIVE OF PROJECT :
The main objective of the project
including the following:
*Goals to be achieved by this project?

Answer : This Analysis system is capable
of analysing performance of all countries in
Olympic, Number of medal won, Number of
times country participated in Olympics
visually as well as in tabular form.
* How it will be helpful to people

associated to the work?
Answer: It helps us to answer question

such as:
•What effect does the host country have in
the medals won at the Olympics?
•Is the performance of countries in Olympics
games affected by the economic factors of
the country?
•Is the performance of countries in Olympics

games affected by the economic factors of
the country?
REQUIREMENT AND ANALYSIS :

a)Aim: To Develop Olympic Games Analysis
System.
b)Front End:
a.) Sublime Text Editor
b.) Microsoft Code Studio
c.) Python 3.8.2
c) Back End: My SQL Server 5.1
d)Operating System: Windows 10
e)Minimum Hardware and Software

Requirements:
a.) x86 64-bit CPU (Intel / AMD architecture)
b.) 4 GB RAM
c.) 5 GB free disk space
f) Open Source Software being used:

a.) Python 3.8.2
i. Pandas
ii. Matplotli
b
PYTHON LIBRARIES USED

(PANDAS)
Pandas is a high-level data manipulation tool

developed by Wes McKinney. It is built on the
Numpy package and its key data structure is
called the Data Frame. Data Frames allow you
to store and manipulate tabular data in rows
of observations and columns of variables.
(MATPLOTLIB)
The Matplotlib Python library, developed by
John Hunter and many other contributors, is
used to create high quality graphs, charts,
and figures. The library is extensive and
capable of changing very minute details of a
figure.
ABOUT OLYMPICS
INTRODUCTION
According to historical records, the first
ancient Olympic Games can be traced back
to 776 BC. They were dedicated to the
Olympian gods and were staged on the
ancient plains of Olympia. They continued
for nearly 12 centuries and still continuing.
THE GAME AND THE RELIGION

The Olympic Games were closely linked to
the religious festivals of the cult of Zeus,
but were not an integral part of a rite.
Indeed, they had a secular character and
aimed to show the physical qualities and
evolution of the performances .
ABOUT OUR ANALYSIS SYSTEM

This Analysis system is capable of analyzing
performance of all countries in Olympic, No.
of medal won, No. of times country
participated in Olympics visually as well as in
tabular form. And it also helps to answer
question such as:
•What effect does the host country
have in the medals won at the
Olympics?
•Is the performance of countries in

Olympics games affected by the
economic factors of the country?
•Is the age of winning Olympics
changing?
USES OF OUR PROJECT
This program can be used to analyse the
performance of different countries in
Olympics till now. This program can also be
used for a predictive model as to which
country is likely to fetch the highest number
of gold in a particular sports category (just
an example), etc. This project consists of
various graphs to analyse and represent data
which helps the user to draw a comparison
between, and having a glimpse of, different
groups. It also helps get analysed
information in a structured format making it
easy to understand.
HYPOTHESIS
In this project of python programming

function was used to make it look more
attractive and beautiful and connectivity of
Python and MySQL was much easier to
understand in this way of programming.
Features:
1. Free from technical errors.
2. Time Saving.
3. Reduces manual work.
4. Data is analyzed through various
methods – sort(), group by, mean,
median, mode etc.
5. Visualized data, e.g. Bar Chart, Pie
Chart, Histogram etc.
6. User – friendly interface
DEMAND IN REAL WORLD

It gives detailed analysis of the following:
1. Countries VS Total Medal
2. Countries VS Total no. of times
participated (In Summer & Winter)
3. Countries VS Total no. of Gold Medals.
4. Countries VS Total no. of Silver Medals.
5. Countries VS Total no. of Bronze Medals.
6. Distribution of Gold, Silver & Bronze
Medals.
7. Country wise Gold, Silver & Bronze
Medals.
8. Countries VS Total no. of Medals (In
Summer & Winter)
9. Number of Countries (Gold, Silver and
Bronze Medals)
BUILT-IN FUNCTION USED

PANDAS
1.read_csv(): This function is used to read data
from csv files to form a dataframe.
2.head(): Head function is used to fetch n
number of rows from Pandas object.
3.tail(): Tail function returns last n rows from
Pandas object.
4.append(): The append method adds an item to
the end of the list.
5.drop(): drop function is used to drop specified
labels from rows and columns
6.rename(): Rename function is used to change
name of any row or column.
7.min(): Min function finds out the minimum
value from given set of data.
8.max(): Max function finds out the maximum
value from given set of data.
9.sort(): Sort function arranges value in Pandas
object ascending and descending order.
10.info(): Info Function is used to print a concise
summary of dataframe.
MATPLOTLIB
1. bar(): It is used to plot a bar chart in
matplotlib for a given set of data.
2. hist(): Hist function allows us to create
and plot histogram for a given set of data.
3. xlabel(): It is used to set label for X axis.
4. ylabel(): It is used to set label for Y axis.
5. title(): Title function is used to add title to
the plot.
6. show(): It is used at the end to show plot
as per given specification.
CODING AND PROGRAMS
DATABASE AND TABLE DESIGN
OUTPUT SCREENS
#1
#2
#3
#4
#5
LIMITATIONS
Despite being best efforts of the developer,
the following limitations and functional
boundaries are visible, which limits the
scope of this application.
1. The software can store records and
produce reports in pre-designed format
in soft copy. There is no facility to
produce customized reports.
2. This is an offline project.
The module or function can be designed and
embedded to handle the user need in future.
Any part of the project can be modified
without much effort.
CONCLUSION
Python is one of the simplest programming
languages that are used for variety of
applications. We can also focus on the areas
for regular updates and version
advancements in future of this project.
Completing this project I have received a lot
of useful knowledge.
REFERENCES
• Book Used: SUMITRA ARORA
Informatics Practices Python, Class 12
• www.python4csip.com
• www.stackoverflow.com
• www.github.com
• www.w3schools.com
• www.geeksforgreeks.com

Project

Uploaded by

Copyright:

Available Formats

Project

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Project

Uploaded by

Copyright:

Available Formats

CENTRAL BOARD OF SECONDARY

Mr. Roshan Pandey

Name: Kushal Omar

I would like to express a deep sense of thanks

The purpose of this project was to develop the

*Goals to be achieved by this project?

* How it will be helpful to people

Answer: It helps us to answer question

•Is the performance of countries in Olympics

REQUIREMENT AND ANALYSIS :

c) Back End: My SQL Server 5.1

d)Operating System: Windows 10

e)Minimum Hardware and Software

f) Open Source Software being used:

PYTHON LIBRARIES USED

Pandas is a high-level data manipulation tool

THE GAME AND THE RELIGION

ABOUT OUR ANALYSIS SYSTEM

•Is the performance of countries in

In this project of python programming

DEMAND IN REAL WORLD

BUILT-IN FUNCTION USED

You might also like