Data
90 mins
Cleaning and Analysing Data
- Abstract:
- This course will introduce you to the practical skills needed to analyse data using spreadsheets, allowing you to start looking for stories in data if you’re a journalist or analysing your data for advocacy or social development if you’re an activist.
- About this course:
- This course is designed for human rights activists and journalists who would like to use data to support their advocacy work or tell stories. Starting with how to do basic math in a spreadsheet this course covers the most important tools and methods for analysing data and aims to leave you with the practical skills to start exploring your own data. We understand the idea of working with spreadsheets and data can be intimidating, so don’t worry, we’ll be gentle!
- What do I learn:
- By the end of the course you will have been introduced to some of the most important practical skills for wrangling – using spreadsheets. You will be able to analyse data by sorting and filtering and using formulae and pivot tables. You’ll learn what can go wrong with data and how to avoid this with some data cleaning techniques.
- What do I need to know:
- This course is suitable for anyone who is interested in getting started with data and all you need to take this course is a computer and internet access.
Trainers
Milena Marin
Since 2009 Milena Marin has worked at the intersection of technology, data and social good. She is a true data wrangler who has collaborated with countless organisations from around the world to help them make the most of of their data and reach new audiences.
Hannah Williams
Hannah is a graphic designer working in both web and print. She also does copy writing now and again and have worked on a couple of public art projects. Recently she has been trying to focus more on doing work that has a positive social impact.
- 1.1 Introduction to Cleaning and Analysing Data1.2 Examining data: range, count and distribution1.3 Averages: Mean, median and mode1.4 Normalising data: Comparing things1.5 Quiz
- 2.1 Spreadsheets: An overview2.2 Creating a spreadsheet and uploading data2.3 Navigating and using the Spreadsheet2.4 Sorting Data2.5 Filtering Data2.6 Quiz
- 3.1 Introduction to formulae3.2 Using a formula to add, subtract and multiply values3.3 Using the built-in functions3.4 Visualising data - Creating basic charts3.5 Screencast: Creating basic charts3.6 Quiz
- 4.1 Introduction to advanced formulae and pivot tables4.2 More complex formulae4.3 Retrieving data: the vlookup function4.4 Summarising data: Pivot Tables4.5 Quiz: Formulae and pivot tables
- 5.1 Introduction to data cleaning5.2 What can go wrong?5.3 Summary and best practices5.4 Quiz: Cleaning Data
- 6.1 Conclusion
Related courses
60 mins
School of Data60 mins
School of Data
Infotimes
30 mins
Infotimes
Suggested reading
Blog
Evaluating the Efficacy of State-Imposed Telecom Shutdowns in Northwest Nigeria
This article casts doubt on the shutdowns' effectiveness in curbing banditry, exposing alternative explanations for any temporary decrease in attacks. It questions the legitimacy of justifying these shutdowns as effective counter-terrorism measures, advocating for alternative approaches that prioritize community engagement, human rights, and development initiatives to address the root causes of insecurity and foster lasting peace in Northwestern Nigeria and Nigeria at large.
Blog
Impact of the Twitter Ban in Nigeria
This post is a research study on the impact of the Twitter ban in Nigeria on Human Rights Monitoring, Advocacy and Creativity. Read more.
Blog
Four Free Toolkits to Fight Internet Shutdowns
Let’s tell you a little bit more about each toolkit!
Blog
The Impact of Internet Disruptions on Farmers in Nigeria
In Nigeria’s Northwestern Sokoto State, farm workers grapple with geopolitical challenges, shifting climate realities, and economic turbulence. However, they now face a new, growing threat: a troubling rise in internet disruptions, which threatens their ability to work in an increasingly digitally connected world. Read more.
Blog
Central Asian Network of Internet Activists
Central Asian Network of Internet Activists (CANIA) is a network of dedicated researchers and activists with a passion for digital rights, security, and development. Originating from Central Asia, they understand the challenges of internet accessibility and the pivotal role of the internet in economic advancement. CANIA’s efforts centre around increasing awareness of pressing issues like data privacy, internet accessibility, digital literacy... read more.
Blog
Investing in the Fight Against Digital Authoritarianism in Senegal
On February 3, Senegal’s President Macky Sall announced a delay of the much-anticipated presidential elections, originally planned for February 25, in what some are calling a “constitutional coup.” Protests erupted, and the government imposed a mobile internet shutdown. Read more...