- For each and every type of evaluation tool category, an Excel spreadsheet has been set up for you to analyze evaluation data. These Excel spread sheets have been coded similar to the code of Evaluation tools. Select the appropriate data analyzing Excel spreadsheet template for your evaluation tool.
- Modify the selected Excel spreadsheet to match with the content of your evaluation survey tool. If you need any help for modification, you may review the sample Excel spreadsheet in the selected Excel Template category.
- Important! When you modify Excel Templates make sure that you change only the items in the green area. Don’t do any change in the red areas because if you make any change in the red area the setup codes for data analysis will be changed.
- After you make the needed changes into the Excel spreadsheet, enter your evaluation data into the file as shown in the example. You can enter up to 250 training evaluation surveys into this file. If you are evaluating a 4-H camp or conducting a media evaluation, you will be able to enter 2500 evaluation surveys into the Excel spreadsheet set up for those evaluations.
- Once you complete your data entry, you will be able to get the summary of data analysis by clicking on Excel sheet 2 (Bottom left corner of the Excel spreadsheet). Your data analysis summary will be available in graphical form on Excel sheet 3.
- If you use Qualtrics to conduct your survey online, Qualtrics provides the analysis of your survey data.
Tools and Guidelines for Analyzing Evaluation Data
Written By
Contributors