Skip Main Navigation
Page Content

Save This Event

Event Saved

2-day intensive: Spreadsheets for data handling & statistics

Goldsmiths, University of London

Wednesday, 20 September 2017 at 09:30 - Thursday, 21 September 2017 at 16:30 (BST)

2-day intensive: Spreadsheets for data handling &...

Ticket Information

Ticket Type Sales End Price Fee Quantity
Standard ticket
20% discount for Goldsmiths students and staff. 100% discount for MA/MSc Digital Journalism students. Email p.fry@gold.ac.uk for the discount codes.
4 Sep 2017 £275.00 £0.00

Share 2-day intensive: Spreadsheets for data handling & statistics

Event Details

This two-day intensive at Goldsmiths focussed on handling data with spreadsheets, and managing statistics with spreadsheets.

Day 1: Handling data with spreadsheets
10am-5pm Wednesday 20 September 2017

Spreadsheets are the basic tool of data analysis and investigation for a range of professions from social marketing through to data science. Good data handling skills are essential for the public researcher or marketer and in this course we cover the three central skills, sorting, filtering and pivots that are required to analyse data sets. Although our emphasis is on using Excel we will also look at using Google Sheets to perform the same level of analysis.

Participants will learn how to:

  • use shortcuts in order to navigate large data sets effectively
  • use correct formatting in order to represent numbers, money and percentages
  • use formulas in order to calculate new columns
  • use formulas to calculate percentage change, rates and per capita values
  • use sorting in order to find outliers in data sets
  • use filtering in order to produce subsets of data for further analysis
  • use pivot tables to summarise and analyse data sets
  • use export and import functions to produce or consume other common file types.

Day 2: Statistics with spreadsheets
9.30am-5pm Thursday 21 September 2017

Data ‘evidence’ is the fundamental principle of many contemporary decision making processes in various levels of business or government. Whatever your opinions on this trend, a lack of data skills can hamper your engagement with the issues. Building on Day 1, we look at the central principles of modern descriptive statistics such as measures of centrality and distribution. We also take a brief look at the world of inferential statistics and probability. Throughout the day we will use current data sets involving crime, health and the census.

Participants will learn how to:

  • use a spreadsheet to produce and check summary statistics from large data sets
  • use a measures of centrality in order to describe large datasets
  • use a spreadsheet to calculate measures of spread
  • use charts in a spreadsheet to do visual analysis of data sets
  • use a spreadsheet to perform basic trend analysis
  • identify tools to manage very large datasets used in Big Data.

Part of Goldsmiths' 8-day intensive Digital Bootcamp

Course tutor

Andy Freeman has 30 years of experience with corporates, startups, non-profits and arts organisations, from Apple Computers to Islington Council. He now teaches award-winning students on Goldsmiths’ Digital Journalism, Digital Sociology, Creative Computing and Computer Science degree programmes. Andy Freeman on LinkedIn

Do you have questions about 2-day intensive: Spreadsheets for data handling & statistics? Contact Goldsmiths, University of London

Save This Event

Event Saved

When & Where


Goldsmiths, University of London
New Cross
SE14 6NW London
United Kingdom

Wednesday, 20 September 2017 at 09:30 - Thursday, 21 September 2017 at 16:30 (BST)


  Add to my calendar

Organiser

Goldsmiths, University of London

Goldsmiths, known for its excellence in creative and cultural arts, humanities and social sciences, is launching an exciting range of adult education and short training courses, giving busy people the chance to work towards new opportunities and a more fulfilling future. We are presenting a diverse, new range of evening and weekend courses, taught by the same experts that teach our ground-breaking degree programmes. This is a chance for you to get a taste of the challenging courses that has made our graduates so successful in creative, cultural and business communities.

So whether you want to learn a new career skill, enhance your job prospects or just discover a new hobby, and at the same time develop your networks, then our short courses are a great opportunity to enrich your life and join the vibrant learning community at a world-class university.

What are we offering? Short courses in Business, Innovation and Marketing, Creative Computing, English & Comparative Literature, Music, Dance and Drama, as well as Social Science subjects applied to real life such as Anthropology, Psychology, Social , Therapeutic and Community Studies.

Goldsmiths is also home to the only Confucius Institute, whereby professional arts platforms are used to promote Chinese language and culture.

 

 

  Contact the Organiser
2-day intensive: Spreadsheets for data handling & statistics
Things to do in London Course Family & Education

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.