Dirty Data Dojo - Data Collection

Data collection is one of the most important aspects of any project that involves data.

In this course you’re going to learn how to collect and enter your data into Excel effectively and efficiently.

Why? Because if you don’t observe a few basic rules of data collection then you’re in a world of hurt when it comes to preparing and cleaning your data. If you’ve been there, then you know what I’m talking about.

In this course, we’re going to give you the best start possible, introducing you to some of the best tricks you’ll ever learn, saving you weeks of misery!


Video lessons

Articles

Downloadable resources

Certificate of completion

Interactive experience

Perfect for beginners


  • Description
  • Content
  • Outcomes
  • FORUM
  • CertificatE
  • 14D2C2

If you are a newbie to collecting and managing data, then congratulations! You are here at the right place because we are going to introduce you to one of the most important aspects of any project that involves data: data collection.

Sure, it’s not sexy, and this process is often overlooked by most researchers, but I can’t stress how important it is. I mean, how hard can it be to collect data?

Well, it’s not difficult to collect, but if you don’t observe a few basic rules of data collection then you’re in a world of hurt when it comes to preparing and cleaning your data. If you’ve been there, then you know what I’m talking about.

In this course, we’re going to give you the best start possible, introducing you to some of the best tricks you’ll ever learn, saving you weeks of misery.

Here's what you'll learn:

1.

you’ll learn how to import data into Excel from a variety of sources – including entering data manually – gaining practical experience along the way

2.

you’ll learn how to record data on paper, observing some simple but crucial data entry rules. This is a very important, but often overlooked, step in data collection

3.

you’ll learn the anatomy of a good worksheet, ensuring that the structure of your data is correct right from the start

4.

you’ll learn to use Excel’s Data Entry Form. This is one of Excel’s best kept secrets – hardly anybody knows about it!

5.

you’ll learn to set up and use Data Validation in Excel to ensure your data are clean and error-free

6.

you’ll learn all the best data entry tips and tricks that money can buy, slashing days and weeks off your data entry

Your Curriculum

1

Introduction to Data Collection

An introduction to this course and to the 14 Day Data Cleaning Challenge!

Open Access

CHAPTER HIGHLIGHTS

2

Importing Data into Excel

In this chapter you'll how to get data into Excel from various sources and manually

Open Access

Free Plan

CHAPTER HIGHLIGHTS

3

Manually Enter Data into Excel

The focus in this chapter is on how to manually enter your data into Excel efficiently

Free Plan

Premium

CHAPTER HIGHLIGHTS

4

Data Collection Recap

In this chapter you'll recap everything you've learnt and practice it all again!

Premium

CHAPTER HIGHLIGHTS

How to analyse categorical survey data in Excel and in R
Chi-Squared Innovations