Hi, this is Taj Carson, CEO at Inciter, a firm focused on helping clients change the world by using data. Many evaluators are caught flat-footed when they analyze data and run reports. Data are missing, they can’t find a client in the system because key information wasn’t entered, or the numbers just don’t add up. …
My name is Samantha Theriault, and I am the Research Assistant at Randi Korn & Associates (RK&A), a research, evaluation and intentional planning company that specializes in museums and informal learning. Lesson Learned: As a research assistant, I spend much of my time entering and processing data. Data entry and clean-up is time consuming and …
Labor Day Week: Cleaning Up Data: Turning the Dirt by Samantha Theriault Read More »
My name is Lisa R. Holliday, and I am a Data Architect with The Evaluation Group. Cleaning data is a large part of my job. For studies that need to match participants’ names or IDs, it is critical to ensure that information is entered consistently from one data collection cycle to the next. However, depending …
2-for1 Week: Lisa R. Holliday on Data Cleaning and Fuzzy Matching Read More »
I’m Jennifer Ann Morrow, a faculty member in Evaluation, Statistics, and Measurement at the University of Tennessee. I created a 12 Step process evaluators can follow to ensure their data is clean prior to conducting analyses. Hot Tip: Evaluators should follow these 12 steps prior to conducting analyses for evaluation reports: 1. Create a data …
Hello, my name is Juan Paulo Ramírez, independent consultant, sole owner of “GIS and Human Dimensions, L.L.C.” How many times have you used spreadsheets or sophisticated statistical software (i.e., SAS, SPSS) to estimate frequencies of a population and you asked yourself: is it really necessary to do this using very expensive and sophisticated software? Or, …
Juan Paulo Ramírez on Google Refine – The tool of the year for evaluators! Read More »
My name is Philippe Buteau and I am an analyst at my own small co-owned firm, Buteau and Lindley. Back in May, Susan Kistler briefly wrote about Google Refine on aea365 and prompted me to take a look. Since then, I have used Refine in a number of ways and thought that I would submit …
Philippe Buteau on Using Google Refine for Data Cleaning Read More »
