My name is Lisa R. Holliday, and I am an Evaluation Associate with The Evaluation Group in Columbia, SC. I was recently cleaning survey data and preparing it to be uploaded into a database. The survey had been offered multiple times, and I wanted to track the responses of participants who had completed the survey …
Lisa R. Holliday on Creating a List of Unique Values with Power Query Read More »
Hi, I’m Harlan Luxenberg from Professional Data Analysts, Inc., a public he alth evaluation firm in Minneapolis, and I’d like to share some thoughts about certain situations where databases may be more useful than Microsoft Excel. Excel is great for quickly crunching data and managing small datasets; however, using Excel in the wrong situations can …
Harlan Luxenberg on When to Use a Database Solution instead of Excel Read More »
Hi! I’m Mallory Johnson, an Evaluation Specialist with the UC Davis Schools of Health Evaluation Unit. Have you been frustrated by webpages that allow you to view data in a browser, but don’t have export or download functions? Government websites in particular often post useful evaluation information in useless formats. After all, that table is …
I am Shirah Hecht and am an independent researcher and non-profit program evaluator. Qualitative data can be overwhelming, and challenging to reach valid conclusions. Here is the first of two methods to move qualitative data efficiently from analysis to presentation using common desktop software. Excel’s Pivot tables lets you flexibly create subgroups and report standard …
Hi, my name is Jennifer Bain, and I am an Evaluation Consultant. This post contains a couple of basic tips regarding data visualization I picked up and how to easily apply these tips to your Excel charts without spending a lot of time formatting individual charts. Lessons Learned: Formatting Visually Appealing Charts Since I work …
Hi, I am Miranda Yates, Director of Program Evaluation and Planning (PEP) at Good Shepherd Services (GSS), a youth and family development, multi-service agency in New York City. My PEP colleagues, Barbara Alcantara, Nora Casey, and Cathleen Mitchell, and I have developed a visually engaging report template that keeps staff focused on the key outputs …
Hello. I’m Sara El Choufi, and I work in Results-based Management at the Global Environment Facility (the GEF), an agency within the World Bank. While most of the work relies on qualitative analysis and pulling out results from ongoing projects, no assessment can ever be complete without numbers. Among other things, I work on data …
EPE Week: Sara El Choufi on Why Excel is the Coolest Program Ever! Read More »
Greetings aea365 community! I’m Ann Emery and I’ve been both an external evaluator and an internal evaluator. Today I’d like to share a few of the reasons why I absolutely love internal evaluation. Lessons Learned: Internal evaluation is a great career option for fans of utilization-focused evaluation. It gives me opportunities to: Meet regularly with Chief Operating Officers and Executive …
IE Week: Ann Emery on Why I love Internal Evaluation Read More »
Cheers aea365 readers! My name is Alex da Silva from Brazil. While I may be able to undertake analyses in SAS, I find myself turning more frequently to Microsoft Excel because so many people can then use it. If I set up something in Excel I can be more confident that my collaborators are going …
Alex da Silva on Expanding Your Capacity With Excel Read More »
Our names are Lindsey Dunn and Lauren Fluegge and we are PhD. students at The University of North Carolina at Greensboro. Recently, we have been involved with a project in which the data come from many different sources and often include hundreds of thousands of cases. We used primarily three programs to organize and merge …
Lindsey Dunn and Lauren Fluegge on Organizing Data Read More »
