How to use Workshop Evaluation Spreadsheets and Report Templates

Download How to Use Template

Workshop evaluation questionnaires have been developed with a corresponding spreadsheet and report template.  These questionnaires may be downloaded, modified and used to meet the user’s evaluation needs.

The first, “Workshop Evaluation Questionnaire 1: Impact” is designed for use immediately after a professional development inservice or workshop.  The second, "Follow Up Questionnaire", is designed to be completed after participants have had a chance to implement what they learned (e.g., in a follow up session).  Because both questionnaires ask participants to rate anticipated impact on classroom outcomes, these questionnaires would be used when participants are likely to apply what they learned to a school setting.

 Steps to using spreadsheets

1. Number your workshop questionnaires by writing a number in the top right hand corner.  This will help you to keep track of questionnaires you are working on.

 2. Input numerical data from completed questionnaires. 

a) Open the Microsoft Excel spreadsheet file that corresponds with the questionnaire used.  Use the table below to identify corresponding questionnaires, spreadsheets and report templates.

 b) Look at the tab on the bottom left hand corner.  Click on the tab ‘1-4 ratings’  so that you can enter numbers from Likert-type rating items.

c) Enter numbers, working down the column, for each questionnaire item.  For example the first item on your first questionnaire will be entered in cell B2, second question in B3.

d) As you input questionnaire data, averages are automatically computed and graphed on the spreadsheet.

 e) If you enter a number out of the questionnaire’s 1-4 rating  (e.g., 7), you will be prompted to make a correction.   This helps to reduce errors in data input.

3. Input text from open-ended questions

If you want to enter text from open-ended questions, click on the second tab on the bottom left hand corner of the spreadsheet file named ‘Open-ended’.  You can type in as much text as you want in each cell. 

Hint:  It is more efficient and easier to communicate findings by summarizing or providing a synopsis of individual comments from respondents.   Prior to entering open-ended information you may want to examine questionnaires for themes mentioned by various respondents.  You may label and record responses as these themes.  For example, respondents may express in many different ways that they need an internet connection in their classroom before implementation.  Label this ‘Need internet connection”.  This way you can indicate how many people reported this need.  Open-ended responses are then reported in the order of most reported to least reported (although not necessarily least important).

4. Enter evaluation information from the spreadsheet into the corresponding ‘Workshop Report Template’.  This template is designed for those who need to organize all collected information for audiences as efficiently as possible.

a) Places where information needs to be input is designated with a ‘#’. 

Hint: Before printing, do a ‘find’ command for the ‘#’ symbol.  This way you can make sure that you have input all necessary data. You should feel free to edit and make this document your own.

 b) Copy and paste the graph that was generated after the input of Likert-type ratings.  First click on the graph and do a ‘copy’ command.   Second, open the corresponding Report Template file and ‘paste’ the graph into the text box.  The text box helps the graph to keep the proper size and format.

 c) Copy and paste open ended items.  First, endorse and ‘copy’ the column you want to paste into the Report Template.  Then paste contents of the column (all of the text input for that item) into the template under the corresponding question.  You may want to combine multiple responses that essentially say the same thing into a single descriptor and indicate the number of times participants endorsed that theme.  For example:  “Need internet connection in classroom (11)”