Opinion Poll Template - Excel by bxv10865

VIEWS: 88 PAGES: 4

More Info
									Below is an assesment tool which can be used to analyse the results of the MTA
Ecomapping Eco-Opinion Poll. Table 1 is the template for the survey and is where you need
to fill in your results. See the instructions below for information on how to fill out table 1 and
an explanation on table 2 and the graph below.

                                         Instructions
Step 1. Enter in the blue box the number of people who filled out the survey.

Step 2. Enter the results from your survey into table 1. For example if 5 people answered
question 1 with excellent and 3 answered average, type 5 into the excellent box for
question 1 and 3 into the average box.

Step 3. Scroll down the page to see Table 2. this calculates the weighting of each answer
and gives you a total score. (You do not need to fill in this table)

Step 4. Scroll down further to look at the graph, the yellow box shows the best possible
score you could have, this is what you should be aiming for.

Number of people who filled out the survey                     0

                     TABLE 1
Issue
Effective use of consumable products &                Excellent     Good       Average
resources
Effective use of energy (fuel, electricity)
Effective use of water
Separation of wastes and recycling
Are air pollution, dust and odours minimized
Are noise levels controlled and minimized
Secure storage of products
Degree of green purchasing - products & services
Level of personal security
Level of health and safety in the workplace
Prevention of environmental accidents
Environmental policy information-internal
Neighborhood relations
Motivation of senior managers
Motivation of employees

                     TABLE 2
Issue
Effective use of consumable products &                Excellent     Good       Average
resources                                                      0           0          0
Effective use of energy (fuel, electricity)                    0           0          0
Effective use of water                                         0           0          0
Separation of wastes and recycling                             0           0          0
Are air pollution, dust and odours minimized                   0           0          0
Are noise levels controlled and minimized                      0           0          0
Secure storage of products                                     0           0          0
        Degree of green purchasing - products & services   0   0   0
        Level of personal security                         0   0   0
        Level of health and safety in the workplace        0   0   0
        Prevention of environmental accidents              0   0   0
        Environmental policy information-internal          0   0   0
        Neighborhood relations                             0   0   0
        Motivation of senior managers                      0   0   0
        Motivation of employees                            0   0   0

        The best score you should be aiming for is         0


                                    1

                                   0.9

                                   0.8

                                   0.7

                                   0.6
Score




                                   0.5

                                   0.4

                                   0.3

                                   0.2

                                   0.1

                                    0
esults of the MTA
urvey and is where you need
n on how to fill out table 1 and




out the survey.

ample if 5 people answered
 the excellent box for


he weighting of each answer
e)

x shows the best possible




                         Bad       Terrible




                         Bad       Terrible   Total
                               0          0           0
                               0          0           0
                               0          0           0
                               0          0           0
                               0          0           0
                               0          0           0
                               0          0           0
0   0   0
0   0   0
0   0   0
0   0   0
0   0   0
0   0   0
0   0   0
0   0   0

								
To top