mid term-presentation
TRANSCRIPT
![Page 1: Mid term-presentation](https://reader034.vdocuments.us/reader034/viewer/2022050801/554f3e94b4c905471e8b4c01/html5/thumbnails/1.jpg)
EDUCATIONAL DATA MINING IN REFRENCE TO EDUCATIONAL
STATISTICS OF NEPAL
MID TERM PRESENTATION
Presenters
Roshan Bhandari
Sijan Bhandari
Sujit Maharjan
![Page 2: Mid term-presentation](https://reader034.vdocuments.us/reader034/viewer/2022050801/554f3e94b4c905471e8b4c01/html5/thumbnails/2.jpg)
Data Extraction
EDI Analyzer
Data Source
API Call Interface
Relationship Mining
Clustering
Visualization
Classification
Forecasting
DB
API Cache
![Page 3: Mid term-presentation](https://reader034.vdocuments.us/reader034/viewer/2022050801/554f3e94b4c905471e8b4c01/html5/thumbnails/3.jpg)
Data Extractio
n
Data Source
API Call Interface Visualization
DB
![Page 4: Mid term-presentation](https://reader034.vdocuments.us/reader034/viewer/2022050801/554f3e94b4c905471e8b4c01/html5/thumbnails/4.jpg)
Data Extraction
![Page 5: Mid term-presentation](https://reader034.vdocuments.us/reader034/viewer/2022050801/554f3e94b4c905471e8b4c01/html5/thumbnails/5.jpg)
Data Source
# Excel Formats with many sheets
# Unformatted
# Incomplete
# Data Missing
![Page 6: Mid term-presentation](https://reader034.vdocuments.us/reader034/viewer/2022050801/554f3e94b4c905471e8b4c01/html5/thumbnails/6.jpg)
EXTRACTION PROCESS
# Validate data# Cleaning# Fill missing Value# Load Database
![Page 7: Mid term-presentation](https://reader034.vdocuments.us/reader034/viewer/2022050801/554f3e94b4c905471e8b4c01/html5/thumbnails/7.jpg)
API CALL INTERFACE
![Page 8: Mid term-presentation](https://reader034.vdocuments.us/reader034/viewer/2022050801/554f3e94b4c905471e8b4c01/html5/thumbnails/8.jpg)
API Call Interface
CSV Format
JSON Format
XML Format
![Page 9: Mid term-presentation](https://reader034.vdocuments.us/reader034/viewer/2022050801/554f3e94b4c905471e8b4c01/html5/thumbnails/9.jpg)
API call format
http://abc.com/parameterName/api/api_type/year/year_value/district/district_name/factor_name/
Parameter Name “Schooled”
“Enrollment”
“Physical”
“Teacher”
api_type Csv
json
Xml
![Page 10: Mid term-presentation](https://reader034.vdocuments.us/reader034/viewer/2022050801/554f3e94b4c905471e8b4c01/html5/thumbnails/10.jpg)
Year Numerical value in yy format
District “Nepal “ to get the representative of whole country
“Kaski”, “Gorkha”, etc
Factor_Name Various factors such as “totalschoolbylevel”, “totalSchoolByGrade” etc
![Page 11: Mid term-presentation](https://reader034.vdocuments.us/reader034/viewer/2022050801/554f3e94b4c905471e8b4c01/html5/thumbnails/11.jpg)
DATA VISUALIZATION
![Page 12: Mid term-presentation](https://reader034.vdocuments.us/reader034/viewer/2022050801/554f3e94b4c905471e8b4c01/html5/thumbnails/12.jpg)
MAPPING# Geo Spatial Data
# KML, Shape
#Geojson
# Openstreet Map
# Leaflet
![Page 13: Mid term-presentation](https://reader034.vdocuments.us/reader034/viewer/2022050801/554f3e94b4c905471e8b4c01/html5/thumbnails/13.jpg)
Works Remaining
EDI Analyzer
Relationship Mining
Clustering
Visualization
Classification
Forecasting
DB
API Cache
![Page 14: Mid term-presentation](https://reader034.vdocuments.us/reader034/viewer/2022050801/554f3e94b4c905471e8b4c01/html5/thumbnails/14.jpg)
Tools Used