HSE ANALYSIS TOOL: Management standards for tackling
Contents
1. x uestion 8 I am given supportive feedback on Q Page 2 the work I do C Never Seldom C Sometimes Often C Always C No Answer m stion 9 Ihave to work very intensively Soe C Never Seldom Sometimes C Often Always No Answer Thave a say in my own work Sen speed C Never Seldom Sometimes C Often C Always C No Answer 1 Tam clear what my duties and SSUES responsibilities are C Never Seldom Sometimes C Often C Always C No Answer m Question 12 Thave to neglect some tasks 3 because I have too much work to C Never C Seldom C Sometimes Often C Always C No Answer do I am clear about the goals and eee objectives for my department C Never Seldom Sometimes C Often C Always C No Answer westion 14 There is Friction or anger between a colleagues C Never C Seldom C Sometimes C Always C No Answer lt gt Select Questions Saye New Record Delete Last Record Cat 1 7 8 14 15 21 2228 29 35 New Record Number 36 Figure 4 Scores Entry input form questions 8 14 You can use the gt and lt buttons to step from one screen to the next Or you can go directly to a page by using the Select Questions buttons The Save New Record button will be activated when you open the last page Figure 5 below Click it when you have finished entering the replies for a questionnaire You will be prompted to confirm that you wish to save the record If you select Yes a message box will say Record Added showing that the record2. 44 London Consultant Male 21 30 42 Cardiff Management Female 31 40 43 Cardiff Technical Female 31 40 44 Cardiff Admin Female 41 50 45 Edinburgh Technical Male 21 30 e EEEN O ETTE Ee 5 4 4 gt hI 4 Enter Questionnaire Scores Summary of Results Question by Question Raw Data Ia Dip Figure 10 Highlighting Row Heading numbers for deleting If the records that you have deleted are the last records in the Raw Data worksheet then the New Record Number will be updated on the Enter Questionnaire Scores worksheet If the records you have deleted come from earlier in the series you can use Excel s Series Fill feature to revise the record numbers found in the Record Number 9 Column AJ of the Raw Data worksheet In Excel the Series Fill feature can be accessed by selecting the Edit menu then selecting Fill gt Series IMPORTING DATA You can import and collate raw data from other copies of the HSE Analysis Tool To do this first collect all the source files you wish to import data from into one folder Put the target file the one you wish to import data into in a separate folder Ensure that all other workbooks are closed before proceeding Go to the Raw Data worksheet and find the Import button to the right of the final columns of data Click on the button and select the folder that contains the xls files yo
3. lt 2 gt 28 amp lt 4 gt 4 amp lt 4 95 gt 4 95 work problem 29 I can talk to my line manager about something that lt 3 gt 3 amp lt 4 gt 4 amp lt 4 95 gt 4 95 has upset or annoyed me about work 33 am supported through emotionally demanding lt 3 gt 3 amp lt 4 gt 4 amp lt 4 95 gt 4 95 work 35 My line manager encourages me at work lt 3 gt 3 amp lt 4 gt 4 amp lt 4 95 gt 4 95 Peer Support 7 If work gets difficult my colleagues will helo me lt 3 gt 3 amp lt 4 gt 4 amp lt 4 95 gt 4 95 24 get help and support need from colleagues lt 4 gt 4 amp lt 4 95 None gt 4 95 Not possible to set cut offs for the 50 ngo percentile range 27 I receive the respect at work deserve from my lt 4 gt 4 amp lt 4 95 None gt 4 95 Not possible to set cut offs for the 50 go percentile range colleagues 31 My colleagues are willing to listen to my work lt 4 gt 4 amp lt 4 95 None gt 4 95 Not possible to set cut offs for the 50 ngo percentile range related problems Relationships 5 am subject to personal harassment in the form of lt 4 gt 4 amp lt 4 95 None gt 4 95 Not possible to set cut offs for the 50 ngo percentile range unkind words or behaviour 14 There is friction or anger between colleagues lt 3 gt 3 amp lt 4 None gt 4 Not possible to set cut offs for the 50 ngo percentile range 21 I am subject to bullying at work lt 5 None None 5 Anything lt 5 fa
4. has been added successfully x mM Question 29 I can talk to my line manager 3 Page 5 about something that has upset or C Strongly Disagree Disagree C Neutral Agree Strongly Agree C No Answer annoyed me about work z stion 30 My working time can be flexible Sai C Strongly Disagree C Disagree Neutral Agree Strongly Agree C No Answer mM Question 31 My colleagues are willing to listen R to my work related problems C Strongly Disagree Disagree C Neutral C Agree C Strongly Agree No Answer Question 32 When changes are made at work Q Tam clear how they will work out Strongly Disagree Disagree Neutral Agree C Strongly Agree No Answer in practice M Question 33 I am supported through R i 3 emotionally demanding work C Strongly Disagree Disagree C Neutral Agree C Strongly Agree No Answer Question 34 Relationships at work are strained Q C Strongly Disagree Disagree C Neutral Agree C Strongly Agree No Answer tr stion 35 7 My line manager encourages me at qie s work C Strongly Disagree Disagree Neutral C Agree C NoAnswer lt Select Questions Delete Last Record Cat 1 7 8 14 15 21 22 28 203 Figure 5 Scores Entry input form last page Now click the New Record button This takes you directly to the first page of the Scores Entry input form resets the questions to No Answer and increments the New Record Number by 1 You
5. 4 25 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 11 am clear what my duties and responsibilities are 3 4 4 4 4 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 13 am clear about the goals and objectives for my 2 3 4 4 4 4 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 department 17 understand how my work fits into the overall aim 2 3 4 4 4 4 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 of the organisation Change 1 5 10 15 20 25 30 35 40 45 50 55 60 65 70 75 80 85 90 95 99 26 have sufficient opportunities to question 1 1 2 2 2 3 3 4 4 4 4 4 4 4 4 4 5 5 5 5 5 managers about change at work 28 Staff are always consulted about change at work 1 1 2 2 2 2 2 3 3 3 4 4 4 4 4 4 4 4 5 5 5 32 When changes are made at work am clear how 1 2 2 2 2 3 3 3 3 3 4 4 4 4 4 4 4 4 5 5 5 they will work out in practice 16 Table 4 Question by Question Worksheet Rules Governing Colour Coding Cut offs for Each Question Red Yellow Aqua Green Comments lt 20 Percentile gt 20 amp lt 50 Percentile gt 50 amp lt 80 Percentile gt 80 Percentile Demands 3 Different groups at work demand things from me lt 3 gt 3 amp lt 4 gt 4 amp lt 4 95 gt 4 95 that are hard to combine 6 have unachievable deadlines lt 3 gt 3 amp lt 4 gt 4 amp lt 4 95 gt 4 95 9 have to work very intensively lt 2
6. 5 5 5 5 5 5 a work problem 29 can talk to my line manager about something 1 2 3 3 3 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 5 that has upset or annoyed me about work 33 am supported through emotionally demanding 1 2 2 3 3 3 3 3 4 4 4 4 4 4 4 4 5 5 5 5 5 work 35 My line manager encourages me at work 1 2 2 2 3 3 3 4 4 4 4 4 4 4 5 5 5 5 5 5 5 Peer Support 1 5 10 15 20 25 30 35 40 45 50 55 60 65 70 75 80 85 90 95 99 7 If work gets difficult my colleagues will help me 1 1 2 3 3 3 3 3 4 4 4 4 4 4 5 5 5 5 5 5 5 24 get help and support need from colleagues 1 2 3 3 4 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 27 receive the respect at work deserve from my 1 2 3 3 4 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 colleagues 31 My colleagues are willing to listen to my work 2 2 3 3 4 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 related problems Relationships 1 5 10 15 20 25 30 35 40 45 50 55 60 65 70 75 80 85 90 95 99 5 am subject to personal harassment in the form 2 3 3 4 4 4 4 4 5 5 5 5 5 5 5 5 5 5 5 5 5 of unkind words or behaviour 14 There is friction or anger between colleagues 1 2999 2 2 3 3 3 3 3 3 3 3 4 4 4 4 4 4 5 5 5 5 21 am subject to bullying at work 2 4 4 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 34 Relationships at work are strained 1 2 2 2 2 0926 3 3 4 4 4 4 4 4 4 4 4 4 9074 5 5 5 5 Role 1 5 10 15 20 25 30 35 40 45 50 55 60 65 70 75 80 85 90 95 99 1 am clear what is expected of me at work 3 4 4 4 4 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 4 know how to go about getting my job done 3 4 4 4 4
7. 80 percentile figures in Table 1 QUESTION BY QUESTION WORKSHEET Table 3 shows the scores by cumulative percentiles of the score distributions for each of the individual questions grouped together under the factors Demands Control Managerial Support Peer Support Relationships Role and Change This data is taken from the HSE survey Psychosocial Working Conditions in Great Britain 2004 Table 4 shows the rules governing the colour coding cut offs used in presenting the results in the Question by Question worksheet These rules are derived from the data in Table 3 Note e Please note the caveats in Appendix 1 on use and interpretation of the results for individual questions e For many of the questions including all of the Role questions and most of the Peer Support and Relationships questions it was not possible to set cut offs for the 50 80 percentile range e Question 21 am subject to bullying at work is treated differently to the other questions in that o anything less than 5 triggers a red colour coding o if any members of staff score 1 2 or 3 on this question the worksheet returns a message highlighted in red to the effect that x number of your staff report that they are always often or sometimes bullied This is in response to comments received during the Management Standards Pilots and in the course of consultations with various stakeholders Many people considered that any level of bullying was u
8. Health and Safety Management Standards kli Executive for Tacklin Work Related Stress HSE ANALYSIS TOOL USER MANUAL INTRODUCTION There is one spreadsheet analysistoolv xls designed for users of Microsoft Excel 2000 or Microsoft Excel 97 LAUNCHING THE SPREADSHEET To make the analysis tool work save a copy to your computer Launch the spreadsheet and select Enable Macros If the Enter Questionnaire Scores worksheet is empty you should verify that your security settings will allow macros to be run To do this you should go to the Tools menu and select Macro Then select Security Ensure that security is set to either Medium or Low Medium is the recommended option You can restore security settings when you have finished using the application You should close and reopen the application if it is already open We recommend that you restore the original setting as soon as you have finished using the application Note these instructions on security settings do not apply to users of Excel 97 At the bottom of the first screen you will see a series of tabs see Figure 1 below Clicking on the tabs allows you to move to different worksheets Please do not change the names of any of the worksheets as this will affect the operation of the analysis tool G File Edit View Insert Format Tools Data Window Help HSE Analysis Tool Before you start We recommend that you refer to the full ins
9. Now click on the gt button to continue with the rest of the questionnaire The 35 questions are distributed over 5 pages For each question click on the option button that corresponds to the answer in the questionnaire HSE Indicator Tool Scores Entry x Question 1 I am clear what is expected of me Page 1 at work C Never Seldom C Sometimes Often C Always No Answer g I can decide when to take a break Question 2 C Never Seldom C Sometimes Often Dito WEST Different groups at work demand Question 3 hes trem WER SCE BE ees C Never C Seldom Sometimes C Often C Always No Answer T know how to go about getting Question 4 mae ope C Never Seldom C Sometimes Often C Always No Answer I am subject to personal Question 5 harassment in the form of unkind C Never Seldom Sometimes C Often C Always C No Answer words or behaviour Thave unachievable deadlines pose C Never Seldom Sometimes C Often Always No Answer If work gets difficult my ce T colleagues will help me C Never Seldom C Sometimes C Often C Always No Answer lt gt Select Questions Delete Last Record Cat 1 7 e14 15 21 22 28 29 35 New Record Number 36 Figure 4 Scores Entry input form questions 1 7 When you have entered the replies to the first five questions click the gt button to move to questions 8 to 14
10. can then use the drop down menus to make any changes required in any of the four Categories and start entering your results for the next questionnaire The New Record Number box on the Enter Questionnaire Scores worksheet allows you to specify the questionnaire number for a new record The record number is stored in the Raw Data worksheet The numbers normally start at 1 and are incremented automatically However you can change the number in the box if you want to and this number is the one that will be saved You may realize that you have entered the wrong answers for a questionnaire The Delete Last Record button will remove the last record that you have saved OBTAINING A SUMMARY OF YOUR RESULTS When you want to see a summary of the results you have entered select the Summary of Results worksheet Figure 6 below from the tabs at the bottom of the screen users of Excel 97 will need to click the Close button before they can exit the Enter Questionnaire Scores worksheet The Your Results column gives the average value for the responses to each of the stressors covered in the 35 questions The Suggested Interim Target column gives the target score that we suggest would be a reasonable target for you to aim for next time for example in 6 months to a year s time The way this is calculated is described in Appendix A The Suggested Longer Term Target is the value achieved by the top 20 of workers in a national survey of working condition
11. ct the Raw Data worksheet from the tabs at the bottom of the screen and then select the records you wish to delete by clicking and dragging on the Row heading numbers the numbers in the extreme left hand column of the records you wish to delete This will highlight the rows you wish to delete see Figure 10 below Then select Delete from the Edit menu to delete the rows you have selected Fle Edit view Insert Format Tools Data Window Help l8 xi A B c D E F G H a RecordNo x Category A lt CategoryB CategoryC Category D Question1 Question2 x Question 3 x 1 London Admin Male 41 50 4 Cardiff Management Female 31 40 1 Cardiff Technical Female 51 60 Cardiff Admin Male 21 30 Edinburgh Technical Female 41 50 Edinburgh Consultant Female 41 50 London Admin Male 31 40 London Admin Male 41 50 Carditt Admin Female 21 30 Edinburgh Technical 3 oouons on af Technical London Admin Male 31 40 Cardiff Admin Female 41 50 2 Edinburgh Technical Female 21 30 27 London Admin Male 31 40 28 London Admin Male 41 50 29 London Admin Male 31 40 30 Edinburgh Management Male 41 50 3 London Technical Female 31 40 32 London Admin Female 31 40 33 London Consultant Male 31 40 34 Cardiff Management Female 31 40 35 Cardiff Technical Female 51 60 36 Cardiff Admin Male 21 30 37 Edinburgh Technical Female 41 50 38 Edinburgh Consultant Female 41 50 39 London Technical Female 31 40 40 London Admin Female 21 30
12. ested at Step 3 of the Stress Management Standards Website Evaluate the risks and take action we recommend that you confirm all your survey results with your employees This is particularly important when you are considering responses to individual questions The comparisons of such responses with the national survey results should be interpreted as suggestive or as a prompt for discussion only 12 APPENDIX B TECHNICAL INFORMATION AND PROCEDURES USED IN THE CALCULATION OF CURRENT PERFORMANCE AND TARGETS SUMMARY OF RESULTS WORKSHEET Table 1 contains data from the HSE survey Psychosocial Working Conditions in Great Britain 2004 Table 1 shows the scores by cumulative percentiles of the score distributions for Demands Control Managerial Support Peer Support Relationships Role and Change Please note that the order of these factors differs from the order given in Table 5 of the above survey report in that Relationships appears before Role in Table 1 Your Results Table 2 shows the rules governing the colour coding cut offs used in presenting the results in the Your Results column of the Summary of Results worksheet These rules are derived from the data in Table 1 Note e The survey results for the Role stress factor were very positively skewed a large number of people scored 5 on the questions relating to Role One consequence of this is that an organisation may achieve what appears to be a
13. esults H m Suggested InterimTarget 1D Suggested Longer Term Target 2 00 150 100 Compared with results from a representative national survey of employees see the HSE Analysis Tool User Manual for more information Idi 41 gt MlZ Enter Questionnaire Scores Summary of Results Question by Question Z Raw Data 7 Figure 9 Summary of Results for group selected SAVING RESULTS FOR DIFFERENT GROUPS OF STAFF You may wish to keep all your results together in the one Results analysis file or you may wish to split data to create separate files for different groups of staff An easy way to do this is to start by using the filter function as described above to filter the data for the first group e g Management Then select Save As from the File menu and save as a new file You can now use the Extract button to the left of the Import button in the Raw Data worksheet to delete all the other rows of data from this file Warning Please note that this process is irreversible it is important to save the original spreadsheet first under a different name otherwise you will lose data Note the Extract function may not function correctly in Excel 97 DELETING ONE OR MORE RECORDS The Enter Questionnaire Scores screens allow you to delete the last record in the Raw Data worksheet In addition to this you can delete a record or a series of records in the following way Sele
14. fairly high score on Role e g 4 2 and yet find that they fall below the 20 percentile for that factor Suggested Interim Target The procedure for working out the Suggested Interim Target for any given stressor is a pragmatic rule of thumb procedure The procedure is described below e The percentiles from 5 to 80 at intervals of 5 and their associated values are stored in an array these are derived from the data in Table 1 e The average score for the results entered to date the figure in the Your Results column of the Summary of Results worksheet is compared with the percentile values and the nearest value is selected the highest value is selected in the case of ties e The percentile associated with that value is subtracted from 100 the difference divided by 5 e The value obtained is added to the original percentile that value is then rounded to the nearest 5 e The value associated with the resulting percentile is the Suggested Interim Target e The procedure ensures that scores that fall below the 20 percentile are always set a Suggested Interim Target at least equivalent to the 25 percentile score e If an organisation scores at or above the 80 percentile on one of the stress factors the procedure returns a message suggesting that they set their own interim and longer term targets for continuous improvement 13 Suggested Longer Term Target The Suggested Longer Term Target scores are derived from the
15. gt 2 amp lt 3 None gt 3 Not possible to set cut offs for the 50 80 percentile range 12 I have to neglect some tasks because have too lt 2 09 gt 2 09 amp lt 3 gt 3 amp lt 4 gt 4 Approx much to do 16 am unable to take sufficient breaks lt 3 gt 3 amp lt 4 gt 4 amp lt 4 95 gt 4 95 18 am pressured to work long hours lt 2 gt 2 amp lt 4 gt 4 amp lt 4 95 gt 4 95 Approx 20 I have to work very fast lt 2 gt 28 lt 3 gt 3 amp lt 4 gt 4 Approx 22 I have unrealistic time pressures lt 3 gt 3 amp lt 4 gt 48 amp lt 4 95 gt 4 95 Approx Control 2 can decide when to take a break lt 3 gt 3 amp lt 4 95 None gt 4 95 Not possible to set cut offs for the 50 80 percentile range 10 have a say in my own work speed lt 3 gt 3 amp lt 4 gt 4 amp lt 4 95 gt 4 95 15 have a choice in deciding how do my work lt 2 gt 2 amp lt 3 gt 4 amp lt 4 95 gt 4 95 19 have a choice in deciding what do at work lt 3 gt 3 amp lt 4 gt 4 amp lt 4 95 gt 4 95 25 have some say over the way work lt 4 gt 4 amp lt 4 95 None gt 4 95 Not possible to set cut offs for the 50 80 percentile range 30 My working time can be flexible lt 2 gt 28 amp lt 4 gt 4 amp lt 4 95 gt 4 95 Managers Support 8 am given supportive feedback on the work do lt 2 gt 28 amp lt 3 gt 3 amp lt 4 95 gt 4 95 23 I can rely on my line manager to help me out with a
16. he seven stressors which in turn relate to the respective Management Standards Demands Control Managerial Support Peer Support Relationships Role and change The items are based on the best available evidence linking work design to health outcomes The scores provided by the HSE Indicator Tool are based on employee responses to the questionnaire They indicate how you are performing against each of the Management Standards The scores range from 1 to 5 A lower score indicates poor performance or a potential problem area See HSE Indicator Tool User Manual for information on use of the HSE Indicator Tool and interpretation of results The Your Results column on the Summary of Results worksheet gives the average score for your responses to the questions that relate to each of the stressors The colour coding allows you to assess how you are currently performing when compared with the top 20 average and bottom 20 of the scores of employees responding to the same questions as part of a nationwide survey of psychosocial working conditions Suggested Interim Target The Suggested Interim Target column gives the target score that we suggest that you aim for in the short term for example the next 6 to 12 months when you next measure your performance using the Indicator Tool It is calculated using a rule of thumb formula that relates your scores to the scores from the national survey The formula suggests that proportionately
17. ing up the categories has chosen to enter results using the categories of location grade of staff sex and age If you wish to use the Categories facility you must do this before entering any results Tp TbIIN Before You Start Cateaories Enter Questionnaire Scores Z Summary of Results Question by MESSE Deel Figure 2 HSE Analysis Tool Categories screen ENTERING YOUR QUESTIONNAIRE SCORES Select the Enter Questionnaire Scores worksheet from the tabs at the bottom of the screen The first page of the Scores Entry input form is shown in Figure 3 below If the questionnaire results you are about to enter have been categorised into groups use the drop down menus to indicate the group s to which the results you are entering belong HSE Indicator Tool Scores Entry E x The coordinator of the risk assessment may have specified that the organisation be categorised to provide meaningful information e g by location role or department Tf the organisation has been divided into groups for this purpose please indicate which group s you belong to as advised by the coordinator Category A London z Category B Management 0 Category C CH Category D feo Click here to continue with the rest of this questionnaire gt gt Select Questions Delete Last Record aa l eaa 1521 2a 29 35 New Record Number fe Sa Figure 3 Scores Entry input form categories drop down menus
18. larger improvement steps are required the lower your initial scores compared with the national survey scores and proportionately smaller improvement steps are required the higher your initial scores Suggested Longer Term Target The Suggested Longer Term Target represents the score for each of the stressors recorded by the top 20 of the national survey respondents If you have reached this target score we suggest that you continue to set your own targets for continuous improvement QUESTION BY QUESTION SCREEN In addition to the information on the Summary of Results screen the Question by Question screen allows you to obtain a more detailed picture of how the average scores of those responding to each question in the Indicator Tool compare with the average responses of the national survey respondents to the respective questions It is suggested that this may prove helpful as a prompt to discussions 1 Health and Safety Executive 2004 Psychosocial Working Conditions in Great Britain in 2004 This was a nationally representative household survey of nearly 2000 current workers conducted in March and April of 2004 The survey included the 35 question items representing the 6 Stress Management Standards areas The full survey report is available on the HSE website at www hse gov uk statistics causdis pwc2004 pdf 11 within focus groups but should not be interpreted as a definitive assessment of your performance As sugg
19. lls below 20 percentile 34 Relationships at work are strained lt 2 09 gt 2 09 amp lt 4 gt 4 amp lt 4 91 gt 4 91 Role 1 am clear what is expected of me at work lt 4 gt 4 amp lt 4 95 None gt 4 95 Not possible to set cut offs for the 50 80 percentile range 4 know how to go about getting my job done lt 4 gt 4 amp lt 4 95 None gt 4 95 Not possible to set cut offs for the 50 ngo percentile range 11 I am clear what my duties and responsibilities are lt 4 gt 48 amp lt 4 95 None gt 4 95 Not possible to set cut offs for the 50 ngo percentile range 13 am clear about the goals and objectives for my lt 4 gt 4 amp lt 4 95 None gt 4 95 Not possible to set cut offs for the 50 go percentile range department 17 I eaa how my work fits into the overall aim of lt 4 gt 4 amp lt 4 95 None gt 4 95 Not possible to set cut offs for the 50 80 percentile range the organisation Change 26 have sufficient opportunities to question managers lt 2 gt 2 amp lt 4 gt 4 amp lt 4 95 gt 4 95 about change at work 28 Staff are always consulted about change at work lt 2 gt 2 amp lt 4 gt 4 amp lt 4 95 gt 4 95 32 When changes are made at work am clear how lt 2 gt 2 amp lt 4 gt 4 amp lt 4 95 gt 4 95 they will work out in practice 17
20. nacceptable and should be highlighted as an issue that might warrant further exploration for example during focus groups 14 Table 1 Psychosocial Working Conditions in Great Britain 2004 Report Percentile Figures for Each Standard Percentiles Table 2 Summary of Results Worksheet Rules Governing Colour Coding Cut offs for Each Standard Factor Red Yellow Aqua Green lt 20 percentile gt 20 amp lt 50 gt 50 amp lt 80 gt 80 percentile percentile percentile Demands lt 2 875 gt 2 875 amp lt 3 5 gt 3 5 amp lt 4 25 gt 4 25 Control lt 2 666667 gt 2 666667 amp lt 3 5 gt 3 5 amp lt 4 333333 gt 4 333333 Managers support lt 3 gt 3 amp lt 3 8 gt 3 8 amp lt 4 6 gt 4 6 Peer support lt 3 333333 gt 3 333333 amp lt 4 gt 4 amp lt 4 75 gt 4 75 Relationship lt 3 75 gt 3 75 amp lt 4 25 gt 4 25 amp lt 4 75 gt 4 75 Role lt 4 4 gt 4 4 amp lt 5 No aqua 5 Change lt 2 666667 gt 2 666667 amp lt 3 666667 gt 3 666667 amp lt 4 gt 4 15 Table 3 Percentile Figures for Each Question Grouped by Standard Percentiles Demands 1 5 10 15 20 25 30 35 40 45 50 55 60 65 70 75 80 85 90 95 99 3 Different groups at work dema
21. nd things from me 1 2 2 2 3 3 3 3 3 3 4 4 4 4 4 4 5 5 5 5 5 that are hard to combine 6 have unachievable deadlines 1 2 2 3 3 3 3 3 3 4 4 4 4 4 5 5 5 5 5 5 5 9 have to work very intensively 1 1 1 1 2 2 2 2 2 2 3 3 3 3 3 3 3 3 4 5 5 12 have to neglect some tasks because have too 1 1 2 2 2 09 3 3 3 3 3 3 3 3 4 4 4 4 4 5 5 5 much to do 16 am unable to take sufficient breaks 1 2 2 3 3 3 3 4 4 4 4 4 4 5 5 5 5 5 5 5 5 18 am pressured to work long hours 1 1 2 2 2 3 3 3 3 3 4 4 4 4 7 5 5 5 5 5 5 5 20 have to work very fast 1 1 1 2 2 2 2 3 3 3 3 3 3 3 3 3 4 4 5 5 5 22 have unrealistic time pressures 1 2 2 2 3 3 3 3 3 3 4 4 4 4 4 4 5 5 5 5 5 Conirol 1 5 10 15 20 25 30 35 40 45 50 55 60 65 70 75 80 85 90 95 99 2 can decide when to take a break 1 1 1 2 3 3 3 4 4 4 5 5 5 5 5 5 5 5 5 5 5 10 have a say in my own work speed 1 2 2 3 3 3 3 3 3 08 4 4 4 4 4 5 5 5 5 5 5 5 15 have a choice in deciding how do my work 1 1 1 1 2 2 3 3 3 3 3 3 4 4 4 4 5 5 5 5 5 19 have a choice in deciding what do at work 1 2 3 3 3 3 3 4 4 4 4 4 4 4 5 5 5 5 5 5 5 25 I have some say over the way work 1 2 3 3 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 30 My working time can be flexible 1 1 1 2 2 2 3 4 4 4 4 4 4 4 5 5 5 5 5 5 5 Managers Support 1 5 10 15 20 25 30 35 40 45 50 55 60 65 70 75 80 85 90 95 99 8 am given supportive feedback on the work do 1 1 2 2 2 3 3 3 3 3 3 4 4 4 4 4 5 5 5 5 5 23 can rely on my line manager to help me out with 1 1 2 2 2 3 3 3 3 4 4 4 4 4 5
22. ondon Admin Female 41 50 1 3 3 44 London Technical Male 1 4 3 45 Edinburgh Management Female 51 60 5 2 2 46 Female 51 60 2 5 1 m 4141 MIZ Enter Ouestionnaire Scores Z Summary of Results Z Ouestion bv Ouestion Raw Data KIE l You can now select the Summary of Results or the Question by Question worksheets to examine the results for the group you have selected In the example in Figure 9 below the Category Filter message above the Key indicates that the user has chosen to examine the results for London based male administrative staff File Edit View Insert Format Tools Data Window Help Summary of Results Your Suggested Suggested Category Filter A London B Admin C Male Results Interim Longer Term Target Target O Doing very well need to maintain performance Represents those at above or close to the 80th percentile Good but need for improvement Represents those better than average but not get at above or close to the 80th percentile O Clear need for improvement Represents those likely to be below average but not below the 20th percentile O Urgent action needed Represents those below the 20th percentile You are doing very well on the following stress factors Control Peer Support you are above the 80th percentile for these stress factors We suggest that you set your own interim and longer term targets for continuous improvement 5 00 450 4 00 T C 350 3 00 250 5 Your R
23. questionnaires you have entered to date grouped by main stressors allows you to compare them with the results from a large national survey of employees and suggests Interim Targets and Longer Term Targets Question by question This worksheet shows your results broken down by individual questions Please note caveats on interpretation in HSE Analysis Tool User Manual Raw data A table of raw scores that enables you to filter data If you want to create results for different categories of staff please see instructions in the HSE Analysis Tool User Manual Troubleshooting Ifthe Entar Qnactinnnaira Senrac workehaat ic aronty cou chould verify that cour cocurity fala bibih before You Start Z esteamos Ao Enter Obestiomave Scores 22 Summa oF Rests Z TOUSSER B Il fee Figure 1 HSE Analysis Tool first screen CHECKING FOR OLD OR UNWANTED RECORDS Before you begin to enter your questionnaire scores for the first time it is advisable to check that the spreadsheet does not contain any old or unwanted records see DELETING ONE OR MORE RECORDS below CATEGORISING EMPLOYEES INTO DIFFERENT GROUPS You may wish to identify the main issues affecting different groups of employees The Categories tab allows you to set up the analysis tool to enter results for different groups of staff You can use this to set up your own choice of group identifiers in up to four categories In the example in Figure 2 below the coordinator or person sett
24. rmat Tools Data window Help Figure 8 Raw Data worksheet A B D E F G H a Record No Category A Category CategoryD v Question1 v Question2 v Question 3 v E i Male 2 3 4 2 London Top 10 Female 51 60 2 1 2 Custom Male 2 3 4 Edinburgh Admin 31 40 5 2 4 Edinburgh Female 5 5 3 London Male 41 50 4 2 2 Edinburgh Male 51 60 3 5 a 21 30 2 2 2 Edinburgh Male 41 50 5 5 3 10 Carcitt Admin 3 4 2 1 Consultant Female 31 40 2 3 1 12 London Male 4 4 1 13 Cardiff Admin 21 30 3 5 2 14 Carcitt Management Female 51 60 2 4 2 15 London Technical 2 3 4 16 Admin Female 41 50 3 4 2 7 London Male 21 30 3 5 2 18 Technical Male 31 40 4 3 3 19 London Management Female 41 50 4 2 5 20 London Technical Female 5 4 5 2 Management Male 5 4 5 2 London Technical Female 21 30 4 5 2 23 London Management Male 51 60 3 5 4 24 Edinburgh 41 50 3 4 4 25 Cardiff Management Male 41 50 4 1 1 26 Cardiff Consultant Female 41 50 5 4 5 rtd 51 60 5 2 4 28 Cardiff Admin Female 51 60 3 1 2 23 Edinburgh 1 3 2 30 London Consultant Female 4 5 2 a Cardiff Consultant Female 31 40 3 5 5 32 Carcitt Male 31 40 3 3 4 33 Technical Female 3 5 3 34 Edinburgh Consultant Female 21 30 5 5 5 35 21 30 4 3 1 36 Edinburgh Management 51 60 4 4 2 37 Technical Male 3 4 4 38 London Technical Male 21 30 4 3 4 39 Cardiff Admin Female 31 40 1 3 4 40 41 50 5 3 5 s Management Female 31 40 3 1 2 42 London Admin 41 50 2 3 1 43 L
25. s in Britain see Appendix A for more details G Eile Edit view Insert Format Tools Data Window Help 18 ALES Summary of Results Your Suggested Suggested Results Interim Longer Term Target Target to the 80th percentilet ge but not get at above or close to the 80th percentile Key Doing very well nee i Demands EE ipese osea a Control CL Good need Managers Support Represents tho n Peer Support ent Relationships avera Role Change Represents those below the 20th percentile o be below ge but not below the 20th percentile O Suggested Longer Term Target Compared with results from a representative national survey of employees see the HSE Analysis Tool User Manual for more information co ld 4 gt pif Cateaories Z Enter Questionnaire Scores Summary of Results Question by Question Z Raw Da 4 BIE Ee I Figure 6 Summary of Results worksheet INDIVIDUAL QUESTION RESULTS The Question by Question worksheet Figure 7 below shows you the average score for each question The colour coding gives an indication of how your performance for that question relates to the responses given by employees taking part in a national survey see Appendix A please note in particular the caveats concerning use and interpretation of results Elle Edit view In
26. sert Format Tools Data Window Help laj x The results are grouped by stressor and the average score is n for each question associated with that stressor Average Kes ay Compared with recults from a representative national survey of employees cee instructions for using the HSE Analysis Tool for me ol for more formation T41 MlZ Cateaories Z Enter Ouestionnaire Scores Z Summary of Results Question by Question Raw Da 4 L Figure 7 Question by Question worksheet results for individual questions SAVING RESULTS After you have finished entering all your results save them by selecting Save from the File menu You may want to save the results under a name such as Whole organisation or another name that is familiar to you Do this by selecting Save As from the File menu and change the file name accordingly To prevent you accidentally overwriting or deleting some of your results it is advisable to copy this file and save it as a working file called Results analysis file or some such title EXAMINING RESULTS FOR DIFFERENT CATEGORIES OF STAFF Open the Results analysis file and select the Raw Data worksheet Figure 8 below Click on the small button to the right of the category heading to use the auto filter function In the example below the user is choosing to filter on Management File Edit wiew Insert Fo
27. tructions in the HSE Analysis Tool User Manual before you start using the Analysis Tool Important To make the analysis tool work save a copy to your computer When you opened the file you may have been asked whether you wished to enable or disable the macros If you clicked the Enable Macros button you may proceed If you clicked Disable Macros close the file and reopen it selecting the Enable Macros button Brief instructions We suggest that you print these instructions before using the application At the bottom of the screen you will see a series of tabs Clicking on the tabs allows you to move to different worksheets A brief summary of the content of these worksheets is described below Please do not change the names of any of the worksheets as this will affect the operation of this analysis tool Categories The Categories tab allows you to set up the analysis tool to enter results for different groups of staff You can use this to set up your own choice of group identifiers in up to 4 Categories If you wish to use this facility you must do this before entering any results Enter Questionnaire Scores Enter your results by clicking on the Enter Questionnaire Scores tab at the bottom of this worksheet This opens a form that allows you to enter the answers to the 35 questions in a series of screens Summary of Results The Summary of Results worksheet gives an overall summary of your results the results for all the
28. u wish to process When you click OK each xls file will be opened and any raw data contained in it added to the Raw Data worksheet of the target file The success of processing depends on matching column headings e g Question 35 between source and target Raw Data sheets Warning Depending on how many xls files are being processed and the size of the files importing raw data may be a lengthy operation SCREEN LAYOUT AND TITLES Please do not change the layout on any of the screens as this may affect the operation of the Analysis Tool In the Summary of Results and Question by Question worksheets the graphs are dependent on data that appears in fixed locations on the worksheet and if for example you insert a line for a title then the numbers will be in the wrong places If you want to give a title to the spreadsheet select Page Setup from the File menu select Header Footer from the tabs at the top of the dialog box and then Custom Header and type your header title in there It will show up in Print Preview and on the printout TECHNICAL APPENDICES Appendix A contains a brief explanation of the approach taken to the calculation of current performance and targets Appendix B contains more detailed technical information on the basis for these calculations 10 APPENDIX A CALCULATION OF CURRENT PERFORMANCE AND TARGETS SUMMARY OF RESULTS SCREEN Each of the 35 questions in the HSE Indicator Tool relates to one of t
Download Pdf Manuals
Related Search