8_3_3

Activity 1 - READ and WATCH

Data can be analysed and used in many different ways. You may not have imagined that data could be used to create a ballet. Take a look at these two videos. The first one is a comprehensive talk of how this is achieved. The second one is the full performance.

A visualization of the data and the code that was required to make it can be viewed on this website:

http://www.datadrivendance.org/datastorm/datavis4.html

Activity 2 - READ

Data can be used to analyse your social media accounts. Twitter has it's own included analytics element for you to view. This was @CompTextBook's twitter analytics when the account was just starting out:

The most interesting part of the analytics is the spikes in the graphs. A social media entrepreneur would want to pay close attention to these spikes so that they could track how certain campaigns were going.

You can also view the engagement rates to see how many people are engaging with your tweets before moving on to the next one.

Google Analytics...

Google Analytics is a powerful tool to analyse the audience traffic for your own website. This was computingtextbook.co.uk in the early days. The data began to spike when I started my Twitter and Instagram campaigns. I can use the analytics to track which campaigns work better than others.

Activity 3

The office for national statistics has this website: https://www.nomisweb.co.uk/

It allows you to download data from the Census for the UK. The last census took place in 2016. I have created a very simple query to download some employment data for Manchester, London and Birmingham. You can download the .csv file from that search here: https://drive.google.com/open?id=0B5fLtQ0Xgr2PZEduVnRTNDNqUDQ

Import the data into a spreadsheet so that you can start to analyse it. You should know how to do this from outcome 8_3_1.

Activity 4

Create a bar/column chart that compares "% of economically inactive males who want a job" with "% of economically inactive females who want a job" across the three major cities.

Not sure how to do this? Watch the video:

In Microsoft Excel...

In Google Sheets...

Activity 5

What judgements can you now make about the information that you have created?

Study the chart...

This chart shows that a higher percentage of economically inactive males want to find a job in London and Manchester, but in Birmingham it is the females that have the higher percentage. It also shows that there is a much lower percentage overall of economically inactive males and females who want a job.

If you worked for a government initiative that was trying to get economically inactive males and females into work, you might choose to start a project in Birmingham as this is where there is the greatest need.

There are lots of options here for analysing data. Choose one from the list:

• Create a survey for your peers and gather data that you can then analyse
• Download some new data from https://www.nomisweb.co.uk/ and analyse it yourself - the site takes some getting used to!
• Set up a sensor that monitors noise levels, analyse the data
• Download some weather data and try to predict what might happen this time next year with the weather

To work on a project similar to this you could use the resources available at: http://www.datadrivendance.org/datastorm/resources.html as a starting point.