Work book post DJ2

Visualizing data

Visualisation of data shown by:

Static infographics ( print and web)

Standalone charts / charts as stories

Interactive charts

Interactive data visualisation

Scrolling stories / scrollitelling

Interactive tools and dashboards

Animation

Coursework 1 : 80% 500 word feature with an infographic

Coursework 2 : 20 % punctuality and attendance

Introduction to Lynda.com- https://www.lynda.com

Important to know what subject you are going to cover and how you are going to show it

Facts , stats and lies

week 3 -11/02/18

Visualising data

Don’t just publish raw data

TELL A STORY!

DATA TERMINOLOGY

Datapoint  –one  piece of data – this apple costs 20p

Dataset  –a  whole  array of data -Cost  of all the fruit +  veg in the supermarket

Variable  –one  dimension  of the dataset- Cost  of apples in the supermarket

Raw data – unprocessed, detailed , has not been manipulated or analysed

Aggregated data – grouped or combined from several measurements

AVERAGE –MEAN –MEDIAN  –MODE

AVERAGE  -(ARITHMETIC)   MEAN -Add all and  divide by number of  entries

MEDIAN -The  middle number  or, if even number,  the sum of the two middle  divided by 2

MODE- Most  frequent or  common value.

Example

Quiz  results of nine  students: 91, 84,  56, 90, 70, 65, 90,  92, and 30

FIND  THE AVERAGE  -(ARITHMETIC) MEAN:    Add all and divide by  number of entries 74

FIND  THE MEDIAN:  The middle number  or, if even number,  the sum of the two middle  divided by 2= 84

FIND  THE MODE:  Most frequent  or common value = 90

Salaries  in a finance  department:

1. £38,000

2. £40,000

3. £40,000

4. £40,000

5. £44,000

6. £50,000

7.£55,000

8. £59,000

9. £68,000

10. £88,000 (Very  long serving accountant)

11. £88,000 (Very  long serving accountant)

12. £120,000 (CFO)

Different stories

Total:  730,000

• Average(Total/12): £60,833

• Median(Middle:  50k+55K/2): £52,500

• Mode(Most common): £40,000

Per cent v percentage point

20% of adults are smokers

The number of smokers increased by 5%

21% of adults are smokers

The number of smokers increased by 5 percentage points

25% of adults are smokers

“All  statistics  are a summary  of a more complicated  truth”

Tim  Harford

Check the data

Always make sure that you are aware of context of the data

week 4- telling business data stories

We learnt to look at business data and how we can use it to tell a story though a more visual means.

We also looked at different sources of finding business and other data stories.

We were also tasked to:

Find a story in the news this week and:

• Write how you would use data to develop it

• Explain the angle you want to take

• Research and find the data sets you want to include

Basic excel data manipulation

how to manipulate data

We also learned which charts are more compatible to which type of data concerned.

week 5- finding data sets

We looked at how to find data sets and the sources included were:

ONS ( Office for national statistics)

EU Sources

And other international source and projects.

We were also tasked to:

• CHOOSE A DATASET FOR YOUR ASSESSMENT PROJECT

• WRITE AND PUBLISH 200 WORDS ON WHY We CHOSE IT

• PRESENT Our DATASET AND INITIAL THOUGHTS ON POSSIBLE ANGLES

Excel data manipulation part 2- further data manipulation skills and pivot tables

We also learned to narrow down data and also sort out specific information out from lots of results.

Week 6- fighthoax

We were introduced to fighthoax and also that we are going to work with the fighthoax in relation to fake news and other events.

Our news topic of working with the fighthoax engine is Brexit and We are looking at Brexit from different sources.

Week 7

Fighthoax continued

Ryerson event

Dataset work continuing along nicely, found further data set on police numbers to correlate along side knife crime stats. Looking to include use of police time ,cuts and cuts to youth services in article piece.

Week 8

Working with data sets

With regard to this consider dataset I have chosen from an editorial perspective and judge how information can be used in relation to my news story.

I will read more on backround information for issues in my article to produce ( police cuts , youth services and police time )