Data Journalism: for final Project ( Md. Abdullah Sheikh (181012073 )

Assignment on final project

Submitted to: Sarkar Barbaq Quarmal,

Assistant Professor,ULAB

 

Submitted By: Md Abdullah Sheikh( 181012073)

Course Name: Data Journalism

Introduction:

 

Political violence has been reported frequently in Bangladesh in recent times.  At the same time, the opposing political parties complain that there is no democratic environment in Bangladesh.  From that place, I have tried to know the overall political situation of the country with the various data of the current 11th parliamentarians of Bangladesh.  At the same time, I tried to know about the educational qualifications of the parliamentarians and the profession of the parliamentarians.  I have also tried to bring up the overall participation of women politicians in the country. 

Data Extraction

 

To do this data story, I first collect data from the official website of the eleventh parliament of Bangladesh through data scraper on Google.  Then export it to Excel file, do data cleaning.  I collect as much data as I need there.

Raw Data Link

https://docs.google.com/spreadsheets/d/1YQ2D_t3O_1oRScR0JI3ZQuLqref1EM_2/edit?usp=share_link&ouid=115075254164194406265&rtpof=true&sd=true

Data Cleaning

 

After collecting the data through data scraper, I clean the data as per my requirement from the Excel file. There, by deleting the unnecessary data, increasing the number of sheets in Excel and keeping the necessary data, from there, arrange the data through the pivot table of Excel.  Then create a chart from there through flourish data visualization.

Putting together data story

 

I have used pie charts, bar charts and column charts to represent the number of MPs and educational qualifications and other data.

After reviewing the total number of seats in the 11th Parliament, it was found that Awami League has the highest number of seats.  Jatiya Party is in second position.  Although BNP is popular as a political party, its number of seats in the 11th Parliament was not noticed much.

Similarly, the educational qualifications of all MPs were verified, with bachelor degree holders being the most.  Besides, there is a post graduate degree holder in the second position.  Also, there are many with SSC and HSC qualifications.  There are many people who have not passed secondary school in this eleventh parliament.

Among the eleven parliamentarians, the male majority is much more noticeable.  The lack of women politicians in Bangladesh politics is clear here.

The majority of businessmen among politicians is one of the most noticeable aspects of the 11th Parliament.  Outside of politics, a large part is involved in business.  Among the total members of Parliament, 191 are directly involved in business.  Also there are total 47 people of legal profession.  Beyond this, doctors and political professions; The number of such parliamentarians is also significant.

Self-Reflection

Before starting this course, I knew a lot about data stories, how to create them.  However, in the end, it seems that if the work of Microsoft ECEXL was known in advance, it would have been easier to create a data story.  Having no prior knowledge of the workings of Excel, faced a difficult situation.  But, I think that what I have learned from this course will help me in my future career.  I also got an idea about the work of several websites including Floris, Google Studio, which can be used to make data stories.  I think that it can be useful in television media as well.  By easily applying these tasks in video editing software, a quality story can be created, which will be communicative for the audience.

 Drive Link :

1. BD 11 Perliament.

https://docs.google.com/spreadsheets/d/1YQ2D_t3O_1oRScR0JI3ZQuLqref1EM_2/edit?usp=share_link&ouid=115075254164194406265&rtpof=true&sd=true

2. PDF File :

https://drive.google.com/file/d/1ibc0FuRLFBIXn-uRi-Z3Ueh0I5odAr5T/view?usp=share_link