Assignment 1 – Understanding Data by Xu Guang

on 23|11|2014
Filled under: Assignment 1

A. World Alcohol Consumption 2003 —— Visualization Task

bar chart 2 bar chart  stepped area chart

(please click the figures if they are too blurry to get details)

Short Description

The data is from a reliable online source website —-” ” and I found that there have been some other applications of this data online so I would trust this data.

The only information I could directly acquire from this data is the Alcohol Consumption in each country all around the world for the whole year (2003), therefore there maybe no possibility for me to divide the database into different sectors and then do some other relevant analyses, such as how the world alcohol consumption fluctuates within a specified amount of time.


Geo chart - markers

Fig.00 Geo chart – markers

I found some subtle distinctions among all the countries/continents all over the world are quite interesting within this dataset especially after visualizing it, and that is to say there is a obvious phenomenon that people in European countries tend to consume more alcohol than that in other continents, Asian in particular.

Some things we could learn from my visualization other than the original database is that the alcohol consumption or say eating habitat can in some way be categorized via culture difference and geographical diversity.



For Source, please click the link here:

Download: please click here: CSV file. (8.0KB)



B. Three Online Data Sources —— Online Source Task


Fig.01 Public spending on education, total (% of government expenditure)


Short Description

Public expenditure on education as % of total government expenditure is the total public education expenditure (current and capital) expressed as a percentage of total government expenditure for all sectors in a given financial year. Public education expenditure includes government spending on educational institutions (both public and private), education administration, and subsidies for private entities (students/households and other privates entities). UNESCO Institute for Statistics | Catalog Sources World Development Indicators



For Source, please click the link here:

Download: please click here: zip file containing three CSV files and one XML file. (30.0KB)



02. |

Community Health Status Indicators

Fig.02 CHI×IND – Meningitis Interactive Info-graphics


Short Description

The objective of data visualization is to inform and warn people about the disease epidemic that are not remembered.

Focus Areas: Access to Quality Health Services, Cancer, Chronic Kidney Disease ,Diabetes, Disability and Secondary Conditions, Heart Disease and Stroke, HIV, Immunization and Infectious Diseases, Injury and Violence Prevention, Maternal Infant and Child, Health, Mental Health and Mental Disorders, Nutrition and Overweight, Oral Health, Physical Activity and Fitness, Respiratory’ Diseases, Sexually Transmitted Diseases, Substance Abuse, and Tobacco Use.



The original data source: CDC |


For Source, please click the link here:

Download: please click here: zip file containing one XLS file, one TEXT file, and eleven CSV files and one XML file. (5.00MB)


03 Languages Spoken by Pupils, Borough & MSOA |

Languages Spoken by Pupils, Borough & MSOA

Fig.03 Interactive Maps: Languages Spoken by Pupils

(please click the figure if it is too blurry to get details)


Short Description

Data from the 2008 Annual School Census shows for the first time the distribution of different languages spoken in London. 2008 represents the first year in which this data was available for all state schools.

Data for both Borough and MSOA level are shown in the same map. To switch between the two geographies click on the ‘choose geography’ button at the top left of the screen.

Then choose a language under the ‘most recent data’ heading.

At Middle Super Output Area (MSOA) data for the main languages are best presented at using the interactive maps.



Please click the link here:



Borough data (Excel) (78kB)

Data for all languages above a threshold of 50 across London are presented at borough level. Numbers are rounded to ten. Percentages are rounded to 0.1.

Note: Within ‘Others’ there was at least one speaker from 118 different languages.

MSOA data (Excel) (410kB)

Middle Super Output Area (MSOA) data is shown in the spreadsheet by the range which it belongs to in the map. Due to restrictions on use of the data, it is not possible to distribute the actual numbers (rounded or unrounded) down to MSOA level.


Thank you for your time :)


Comments are closed.