Data analysis is sometimes the weak link in an evaluation plan. Answering key evaluation questions requires thoughtful analysis - and this needs appropriate tools.
Specialist software is available for data analysis, such as SPSS and SAS (originally designed for analyzing quantitative data but now with capacity to analyze qualitative data), NVivo or HyperResearch (originally designed for analyzing qualitative data but now with capacity to analyze quantitative data).
But many organizations don't have this specialist software and can't afford to buy it. Instead commonly available software, such as Microsoft Word and Excel (or their OpenSource alternatives such as Google Drive Spreadsheets, OpenOffice.org, Zoho sheet, and Excel Web App - software discovered via SmallBusinessComputing) can be used for analysis.
Using Excel for data analysis in evaluation
Ann Emery's Excel for Evaluation page provides a range of short videos explaining how to use Excel for data analysis, from importing datasets and cleaning data (checking data quality), sorting and arranging it, and doing numeric and graphical analysis.
More Excel resources
Using Word for data analysis in evaluation
Word can also be used for data analysis, especially of qualitative data.
Here are two useful resources on using Word:
Jenna Condie explains how the features of Word support more detailed coding, including developing detailed definitions of the codes, and keeping track of comments and emerging ideas about the data.
Nancy LaPelle explains how Word can be used for coding, retrieving, semi-automated coding, creating hierarchies of codes, counting the number of responses for each code, and annotating text.
Pros and cons
Potential advantages of using commonly available software are:
- Reduced learning time, since it builds on existing knowledge
- Makes it easier for local units to engage in data analysis and exploring findings
Potential disadvantages of using commonly available software are:
- some functions are not available
- devolving analysis increases risks of errors - systems for error checking (including protecting calculation cells is needed)