Tips for data entry in Excel

This post provides a few tips for collecting higher quality and more usable data when using Excel as a data entry tool.

Let’s talk about joins

An review of horizontal and vertical joins with examples from education research.

Creating unique participant study identifiers

A review of varying ways to assign unique participant identifiers in educational research studies

Cleaning sample data in standardized way

Part 3 in a series on creating a data cleaning workflow

Creating a data cleaning workflow

Part 2 in a series on creating a data cleaning workflow

Data cleaning for data sharing

Part 1 in a series on creating a data cleaning workflow

Four simple ways to integrate your data dictionary into your data cleaning process

An introduction to four ways you can integrate your data dictionary into your #rstats data cleaning process to make your work less tedious, less error prone, and more reproducible.

How to export analysis-ready survey data

Tips for building a Qualtrics survey that exports quality, usable data.

Using a data dictionary as your roadmap to quality data

An introduction into why and how to build a data dictionary.