Home

HSE Management Standards Analysis Tool User Manual

1. Ady A B C i Ie F G H J K L M N 0 B Q R 8 n Record No CategoryA CategoryB CategoryC CategoryD CategoryE Category Category G CategoryH Category CategoryJ Category Category Q1 Q2 Q3 o4 Q5 Q6 Qr 2 1 1 3 5 1 1 3 4 0 4 4 5 4 2 4 3 2 3 3 5 1 1 3 4 0 4 5 3 4 2 3 4 3 3 2 3 1 3 3 3 0 4 4 3 4 1 2 E 4 3 1 1 1 3 3 3 5 5 4 5 1 2 6 5 3 3 6 1 1 3 4 4 5 5 5 1 3 7 6 3 1 3 1 3 2 3 3 4 4 2 4 4 8 7 3 2 5 1 1 3 4 0 4 5 2 5 2 g 8 1 2 5 1 6 1 3 3 5 5 3 4 1 1 10 9 3 3 1 1 2 3 4 0 4 4 3 4 2 3 1 10 3 3 3 1 2 1 3 4 4 3 4 1 2 12 M 3 3 1 1 6 3 4 4 5 4 5 1 3 13 12 3 1 1 1 3 1 3 3 4 3 3 5 1 3 14 13 3 3 4 1 2 3 3 5 3 4 4 2 2 15 14 3 2 5 1 4 1 3 3 0 5 4 2 5 1 2 16 15 3 3 5 1 1 3 3 0 5 5 3 5 1 2 17 16 3 6 1 2 1 1 3 0 3 4 3 3 1 2 18 17 3 1 3 1 4 3 3 0 4 5 3 4 1 2 19 18 3 2 4 1 3 1 3 3 0 0 0 3 3 4 3 1 3 20 18 3 2 6 1 5 4 4 0 4 4 3 4 1 2 21 20 3 3 6 1 2 1 2 4 0 0 0 0 5 5 4 4 1 3 2 21 2 3 2 1 2 2 3 0 0 4 5 3 4 1 2 23 24 25 26 P 28 28 30 3l Figure 19 Example of the format required for the csv file If the csv file is not formatted correctly the following error messages may appear UG ISS UI LIS IIcluo qi c U GI IO ICI I CU AS I gt LU LS YYUI ROI IOCCL I C HU ICy ac Error 91 occurred in routine Procedure ProcessTextFile Please inform your system administrator The error message is Object variable or With block variable not set SA Cnlnn If this error message is shown it indicates that a
2. Gade of stalt lt Nore gt M Sex None Click here to continue with the rest of this questionnaire gt gt Select Questions Delete Last Record das ets asm za 2s New Record Number fier 1 Figure 5 Scores entry input form categories drop down menus If the questionnaire results you are about to e nter have been categor ised into groups the Enter Questionnaire Scores worksheet will display drop do wn menus corresponding to the Categories that you have set up on the Categories workshe et Use the drop down menus to indicate the group s to which the results you are entering belong Now click on the gt button to contin ue 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 See Figure 6 HSE Indicator Tool Scores Entry x Question 1 Lam clear what amp expected of me Page DIST C Never C Seldom C Sometimes C Often C mers C No Arewer E Lean decide when totaka a break Question 2 C Neve C Seldom C Sometimes C Often mays C No newer Offerect groups at work demand Question 3 things from me that aee hard to C Never C Seldom C Sometimes C Often Almays C No Arewer T know how to go about getting Question 4 ary ob done C Never C Sedom C Sometimes C Often Amays C No Anewer Lam aiject to persona Question harassment in c Cc cS E Cc Cc un
3. Managing the causes of work related stre ss Astep by step approach using the Management Standards HSE Books HSG218 25 4 CONTACT HSE If you need assistance with any aspect of the HSE Management Standards Analysis Tool or if you wish to provide f eedback about your ex perience using these to ols please contact HSE For more information please visit the HSE web site at http www hse gov uk contact index htm 26 5 APPENDIX A QUESTION amp ANSWER In this section we anticipate questions users might have about the changes made My organisation completed its risk assessment using the old benchmark Is the analysis invalid No the analysis is valid The anal ysis tool is designed to support employers in engaging a dialogue with their staff Discussions with staff should be used to steer the process towards the real issues regardless of which version of the tool has been used My organisation used the old benchmark in a previous survey We are now ready to run the survey again to assess progress which benchmark should I use The analysis tool s primary use should be to direct future activity rather than t o evaluate past activity Therefore the most appropriat e benchmark touse would bethene w benchmark However if you do wish to identify changes in working conditions between the two surveys you should use the same benchmark for each phase Furthermore there is no problem with using one set of benchmark to assess p
4. Data has also been kindly supplied by The University of Portsmouth Psychology Department http www port ac uk departments academic psychology Health and Safety Executive Northern Ireland http www hseni gov uk 36
5. Vesn tai to mg ine manc dient porate p hen pret or arapi me d rs LD DAPA Cuff Edy 660 ein wat Figure 21 Totals worksheet results for individual factors 23 3 INTERPRETATION OF RESULTS The scores provided by the HSE Analysis Tool are organisation S responses to the questionnaire They indicate ho w employees are per forming against each ofthe Management Standards The scor es range from 1 to 5 A lower score indicat es poor performance or a potential problem area Employees scores ar e then co mpared to benc hmark scores that are expressed in percentiles and are colour coded to ease their reading Results that fall below the 20 percentile are coloured red and indicate that the average of employees score s falls in the bottom 20 of those surveyed in the benchmark data Results that are below average i e below the 50 percentile but are ab ove the 20 percentile are coloured amber Scores that are above average i e higher than the 50 percentile but n ot above the 80 percentile are colour coded aqua Results that are above the 80 percentile are coloured green indicating that the average of employees scores falls in the top 20 of those surveye d in the benchmark data Each percentile r ank requires a follow u p action from urgent action to good performance to be maintained A summary is given below Percentile key Below 20 percentile bottom 2096 of benchmark scores Urgent action required Below averag
6. gt 3 23 amp lt 3 46 gt 3 46 28 Staff are always consulted about change at work 2 51 gt 2 51 amp lt 2 82 gt 2 82 amp lt 3 05 gt 3 05 32 When changes are made at work am clear how they will work out in practice 2 82 gt 2 82 amp lt 3 06 gt 3 06 amp 3 21 gt 3 21 32 Table 5 2004 Survey Data Set Percentile Figures for each Standard Percentiles Percentiles O o o o O EFESEJEACACAEIEIT AEAEE EAEEREN Demands Control Management Support Peer Support 1 e cpu i233 ee SEC 3 67 67 Table 6 2004 Survey Data Set Summary of Results Worksheet Rules Governing Colour Coding Cut offs for each Standard Factor Red Yellow Aqua Green 20 percentile gt 20 amp lt 50 percentile gt 50 amp lt 80 percentile gt 80 percentile Demands 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 46 gt 4 6 Peer support lt 3 333333 gt 3 333333 amp 4 gt 48 amp lt 4 75 gt 4 75 Relationship lt 3 75 gt 3 75 amp 4 25 gt 4 25 amp 4 75 gt 4 75 Role 44 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 Table 7 20
7. 11 IMPORTING DATA FROM THIRD PARTY SURVEY APPLICATIONS Where other software applications have been used users are required to export data from their application in a format suitable for imp ort into the HSE Man agement Standards Analysis Tool The import raw data from text file facility on the option s worksheet can be used for users wishing to export data from other software applications in a format suitable for import into the HSE Management Standards Analysis Tool As the tool takes the fo rm of a Microsoft excel spreadsheet the most suitable export format is a csv file Excel spreadsheets save as xls files as default Users will have to change the format of the excel spreadsheet To do this go t o file choose save as and then in the save as box go to save as type Change the save as type to CSV comma delimited csv Before you import the csv file you must config ure the categories Please see the configure categories section above for instructions on how to do this The csv file must con form to the format explained belo w The fir st row is th e record number followed by the twelve cate gories and then the 35 questions See Figure 19 for an example Please note that all blanks need to be filled in with a 0 This can be done by using the find and replace facility in excel Press control and F in the find box leave it blank and in the replace box type 0 Click the replace all all empty cells should now have a 0 entered 19 S
8. 3 05 3 27 3 36 3 41 3 48 3 50 3 55 3 56 3 59 3 63 3 67 3 71 3 74 3 78 3 83 3 86 3 88 3 93 4 00 5 19 have a choice in deciding what do at work 174 2 32 2 54 2 65 2 67 2 71 2 77 2 82 2 86 2 91 2 94 2 96 3 00 3 05 3 08 3 13 3 19 3 23 3 29 3 42 5 25 I have some say over the way work 2 92 3 21 3 49 3 55 3 60 3 62 3 67 3 69 3 71 3 76 3 78 3 81 3 85 3 87 3 90 3 95 3 97 3 99 4 08 4 14 5 30 My working time can be flexible 2 120 246 2 72 2 82 2 90 3 00 3 07 3 13 3 18 3 24 3 29 3 39 3 48 3 56 3 61 3 64 3 72 3 83 3 95 4 11 5 Managers Support 99 8 am given supportive feedback on the work do 2 27 2 54 2 73 2 79 2 88 2 91 2 96 3 03 3 04 3 08 3 11 3 15 3 18 3 21 325 3 30 3 34 3 37 3 45 3 57 5 23 can rely on my line manager to help me out with a work problem 2 64 3 15 3 30 3 43 3 48 3 51 3 60 3 63 3 68 3 70 3 73 3 76 3 80 3 83 3 87 3 90 3 94 3 98 4 02 4 19 5 29 can talk to my line manager about something that has upset or annoyed me about work 2 82 3 32 342 3 52 3 59 3 62 3 65 3 68 3 70 371 3 7 4 3 77 3 80 3 84 3 87 3 91 3 93 3 96 4 00 4 08 5 33 I am supported through emotionally demanding work 2 69 2 79 2 92 2 99 3 03 3 04 3 09 3 11 3 13 3 18 3 20 3 23 3 26 3 28 3 31 3 33 3 38 3 46 3 50 3 56 5 35 My line manager encourages me at work 2 83 4 11 4 22 4 25 4 25 4 29 4 33 4 34 4 35 4 37 4 39 4 40 4 43 4 46 4 47 4 50 4 51 4 52 4 55 4
9. 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 4 5 23 can rely on my line manager to help me out with a work problem 1 1 4 4 29 can talk to my line manager about something that has upset or annoyed 1 2 3 3 5 me about work 33 am supported through emotionally demanding work 1 2 2 3 4 5 35 My line manager encourages me at work 1 2 2 2 4 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 24 get help and support need from colleagues 1 2 3 3 27 receive the respect at work deserve from my colleagues 1 2 3 3 31 My colleagues are willing to listen to my work related problems 2 2 3 3 4 4 4 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 haras sment in the form of unkind w ords or 2 3 3 4 4 4 4 4 5 5 5 5 5 5 5 5 5 5 5 5 5 behaviour 14 There is friction or anger between colleagues 1 2999 2 2 3 3 4 4 4 4 21 am subject to bullying at work 2 4 4 5 5 5 34 Relationships at work are strained 1 2 2 2 2 0926 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 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 4 know how to go about getting my job done 3 4 4 4 4 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
10. 5 5 5 5 5 5 13 am clear about the goals and objectives for my department 2 3 4 4 4 4 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 17 understand how my work fits into the overall aim of the organisation 2 3 4 4 4 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 Change 1 5 10 15 20 25 30 35 40 45 50 55 60 65 70 75 80 85 90 95 99 26 l due sufficient opportu nities to question mana gers about change at 1 1 2 2 2 3 3 4 4 4 4 4 4 4 4 4 5 5 5 5 5 worl 28 Staff are always consulted about change at work 1 1 2 2 32 When changes are made at work am clear how they will work out in 1 2 4 4 4 4 5 practice 34 Table 8 2004 Survey Data Set Question by Question Worksheet Rules Governing Colour Coding Cut offs for each Question Red Yellow Aqua Green Comments 20 Percentile gt 20 amp 50 Percentile gt 50 amp lt 80 Percentile 80 Percentile Demands 3 Different groups at work demand things from me that are hard to combine 3 gt 3 amp lt 4 gt 4 amp lt 4 95 gt 4 95 6 have unachievable deadlines lt 3 gt 38 lt 4 gt 4 amp lt 4 95 gt 4 95 9 have to work very intensively lt 2 gt 28 lt 3 None gt 3 Not possible to set cut offs for the 50 80 percentile range 12 have to neglect some tasks because have too much to do
11. 64 5 Peer Support 99 7 If work gets difficult my colleagues will help me 3 26 3 45 3 51 3 59 3 63 3 67 3 71 3 73 3 75 3 76 3 79 3 80 3 83 3 85 3 87 3 89 3 93 3 96 4 00 4 11 5 24 I get help and support need from colleagues 3 10 3 56 3 65 3 67 3 71 3 73 3 76 3 79 3 84 3 85 3 89 3 91 3 93 3 95 3 98 4 00 4 03 4 04 4 09 4 14 5 27 I receive the respect at work deserve from my colleagues 3 18 3 36 3 43 3 49 3 51 3 53 3 57 3 61 3 61 3 63 3 66 3 67 3 69 3 70 3 73 377 3 79 3 82 3 86 3 96 5 31 My colleagues are willing to listen to my work related problems 3 31 3 45 3 53 3 56 3 62 3 65 3 69 3 71 3 74 3 75 3 76 3 80 3 82 3 83 3 86 3 88 3 89 3 90 3 94 3 97 5 Relationships 5 am subject to personal harassment in the form of unkind words or behaviour 1 57 2 76 3 65 3 80 3 93 3 96 4 01 4 000 4 08 4 12 4 14 4 18 4 21 424 4 26 4 29 4 35 4 37 4 47 4 56 5 14 There is friction or anger between colleagues 2 31 2 63 2 95 3 07 3 14 324 329 3 33 3 37 341 343 3 48 3 50 3 55 3 59 3 61 3 64 3 68 3 76 3 86 5 21 I am subject to bullying at work 1 36 2 36 4 08 4 22 4 31 4 37 4 41 4 44 447 4 50 4 53 4 56 4 58 4 61 4 63 4 64 4 66 4 69 4 73 4 81 5 34 Relationships at work are strained 2 33 2 60 2 73 2 91 3 03 3 10 3 20 324 3 29 3 31 3 34 3 36 3 38 341 344 3 53 3 55 3 62 3 67 3 76 5 Role 99 1 am clear what is expected of me at work 1 91 3 92 4
12. 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 80 percentile range 11 am clear what my duties and responsibilities are 4 gt 48 lt 4 95 None gt 4 95 Not possible to set cut offs for the 50 80 percentile range 13 am clear about the goals and objectives for my department lt 4 gt 48 amp lt 4 95 None gt 4 95 Not possible to set cut offs for the 50 80 percentile range 17 understand how my work fits into the overall aim of the organisation 4 24 amp 4 95 None gt 4 95 Not possible to set cut offs for the 50 80 percentile range Change 26 have sufficient opportunities to question managers about change at work lt 2 gt 28 lt 4 gt 4 amp lt 4 95 gt 4 95 28 Staff are always consulted about change at work lt 2 gt 28 amp lt 4 gt 48 amp lt 4 95 gt 4 95 Approx 32 When changes are made at work am clear how they will work out in practice lt 2 gt 28 amp lt 4 gt 48 amp lt 4 95 gt 4 95 Approx 35 7 ACKNOWLEDGEMENTS HSE owes thanks to the following organisations who have kindly provided data to enable us to update the benchmarks Health e Solutions http www health e solutions co uk have provided one third of the data used to generate the new benchmarks This data was collected fro m organisations using their StressMeter risk assessment system
13. Doing very well seed to maintain performance Pepe semis those al sheer m cione to the SAA pereeetie Good bat peed ior ampiceemeat Tegresents those better then average bet mot get s shove or ofc io the SPA peret Cheat ered Voi ingroenmmet Tiegee sens those help to be below average bet not below the 26th preseerste ere sete seeded Fiegeotemts those below the 28th peccencibe f are doing vet well ce che bakowing oe CE AA2 t Ma agent Support Pret Suppan Petaicarhipe po Me aces the Or percetrle Fee bee errer Ve C Wi Dag ge CI Ch ou CH pod Drs OMY DEIGA AAT LAGA CA COM Maca E UTE Ct Td OQ YosPeis m Sie he aet Tan O 2ugge red Longer Tem Target 1 Compared vit notr eon Organs ador al Pos bger nee the MOE ING Aralyris Tool Ure Masud fot rears inkormurioe Md Kor ciat regarding Peor ation of ceci ale MIU Data Sets Summary of Resuta Gamin iv Gusition fotak RawDeta J Oca Jf Im SSS Figure 15 Summary of Results for group Selected 16 E Ble pde yew pent Forest Took Qsta Window Help 18i x The reselic aee grouped by omesso ated the average conie Is Shown foe each question scsociated wi that sires soe 2 T 5x od the ciati insbaded in this queis amd who responded report hat thes ace alvags 25 ata Set Ovgaeiestionst Aecciger degennp Pahar LneatinwsClangew Grade al shulicAduis 2440 23 3 Consol TCT DESEE Simms of Resis Question bv Question Totals Raw Dets O
14. Please note that if you wish to use the Categories facility you must do this before entering any results Your organisation may have been categorise d into diffe rent groups of employees e g b y location role or Department Select the Categories worksheet from the tabs at the bottom of the screen see Figure 4 q g aS Categories If the organe ston has bee catgorited to provide nieningrud ietonmilbon a p By locaton role or segtinent bt ha caegones in fe tabis below Liring categories here wil aloe thew melanie vw Competing the querburnare oe nest work she Raple thee ken e Untbesd with tre tbe 01 Te Category 9 Loco le A category endties Urn o white Hte Ven Caw not condere oon une iv Phe HSE MS araisa Toot AM thes special citirier shonas to sea roong Pa ure 13 peor a green caegory Sore mant bathe tet Ben in category it Mote i you ane mna fe HGE MG Aat Tool in coniuncton wih MSOOrndre e onire version ot te NGI MG indicator Tool passe cortgurs Categories bry rooting the conniguansion tan VOO See Tre NEDO Au wr wy and he Cations wor sihet for rore nonet Category A Category B Category C im Mone eem w vas 25 4 NN Soa Soc Start LCatenanes Eriw Cunticrnaie Score J Cuba Sete 0 Surwarvc Figure 4 The Categories worksheet The special identifier None mus t appear as the first item in a category list and mus t appear exactly as it appears in Figu re 3 i e as lt N
15. all the other rows of data from this file 2 9 IMPORTING DATA FROM OTHER VERSIONS OF THE HSE MANAGEMENT STANDARDS ANALYSIS TOOL To do this first colle ct 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 Options worksheet and find the Import button un der the heading Import Raw Data from Excel see Figure 17 Click on the button and select the folder that contains the xls 17 files you 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 depen ds on matching column headings e g Que stion 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 A Bile pdt vw Insert Foret Took Qeta Window Me lel xj w wol Tevivw Ties ac v slopers Ist noc rio the C 7 Tht feciity requires Ecce 2000 or tater Categories worksheet NB It a category set contano fao os the first option an index A of 1 salects Ihi second entry for a calegory 2 selects Hh Dens and 20 on Input The resi of the fakit ace transferred as amp do dur worksheet ie thery are atsumesto be ctus queston responses Estratt Sclected Category Use fre
16. is too limited to represent the area of concern Several questions tapping one particular dimension are deemed more robust in evaluating that particular are a For example 8 questions are used to assess De mands For Question 21 am su bject to bullying at work If any members of staff score 1 2 or 3 on question 21 the worksheet returns a message hig hlighted in red to the effect that x number plus percentage of respondents of your st aff report that they are always often or someti mes bullied This above feature of the HSE Management Standards Analysis Tool is included in response to 24 comments received d uring the Management Standards Pilots and inthe course of consultations with various stakeholders Many people considered that any level of bullying was unacceptable and that any reported bullying should be highlighted as an issue that might warrant further exploration for example during focus groups These data can be used in a number of ways to indicate your performance e Across standards to identify those standards which need improvement and those which you are currently performing well on e Across different parts of your organisation with a view to identifying good parts that may have practices that would be benef icial for other parts to adopt and for identifying hot spots and It is worth remembering that the results only provide an indication of performance against the Management Standards For step 2 of the Manage
17. lt 2 09 gt 2 09 amp lt 3 gt 3 amp lt 4 gt 4 Approx 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 have to work very fast 2 gt 2 amp lt 3 gt 3 amp lt 4 gt 4 Approx 22 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 48 amp lt 4 95 gt 4 95 Approx 15 have a choice in deciding how do my work lt 2 gt 28 lt 3 gt 3 amp lt 4 95 gt 4 95 Approx 19 have a choice in deciding what do at work lt 3 gt 38 amp lt 4 gt 48 amp lt 4 95 gt 4 95 Approx 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 48 amp lt 4 95 gt 4 95 Approx Managers Support 8 am given supportive feedback on the work do 2 gt 2 amp lt 3 gt 3 amp lt 4 95 gt 4 95 23 can rely on my line manager to help me out with a work problem 2 gt 28 lt 4 gt 4 amp lt 4 95 gt 4 95 29 can talk to my line manager about something that has upset or annoyed me abo
18. 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 und er a name such as Wh ole organisation or another name that is familiar to yo u 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 Alternative method of data entry for numerical data This alternative data entry facility allows more rapid data entry It requires that responses on the paper questionnair e that you are processing be labe lled with numbers 1 5 The method of data input is most efficient when used in conjunction with a numeric keypad and is therefore not suited for use with a laptop computer The facility requires Excel 2000 or later Go to the Options worksheet and find the Input button under the heading Input Numerical Data see Figure 9 ee Dok ve bmj oet Doe Gi Arom cep l ad Input Piurmericad Data The follwing facility provides for mare rapid data entry It requires that responsas on the paper questienrraines ral you are processing be labeled will numbers 1 16 5j The maellag of data input is most efficient when used in conjunci n with a numeric key pad and is lherefore not suited for use with a laptop computer This Tacility requires Excel
19. ucted within 136 organisations and is constituted of organisational averages Health and Safety Executive 2004 Ps ychosocial Working C onditions in Gre at Britain in 2 004 This was a nationally representative household survey of approximately 1800 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 2 The reasons for this change are outlined in the box below IMPORTANT CHANGES TO THE HSE MANAGEMENT STANDARDS ANALYSIS TOOL When the HSE Manage ment Standards Analysis Tool was first designed in 2004 the only data available to HSE for deriving the benchmarks was from a national survey of individuals since no organisations had yet administered the full survey to their employees However it is important for organisations to be able to compare their average results with the average results fro m other organisations r ather than with responses from a survey of individuals HSE has now gathered data from 136 organisations that have completed the survey using the HSE Indicator Tool This has been used to generate the new organisational benchmark HSE recommends that the new benchmark based on organisational data should be used in the majority of ca ses However if you have completed a previous analysis exercise using the 2004 benchma
20. 04 4 08 4 10 4 14 4 16 4 20 422 425 426 428 429 431 4 34 4 37 440 445 4 48 4 54 5 4 know how to go about getting my job done 3 50 3 91 4 01 4 07 4 11 4 14 4 15 4 19 421 4 23 425 428 4 31 4 34 4 33 7 440 442 4 44 448 4 55 5 11 am clear what my duties and responsibilities are 2 82 347 3 59 3 66 374 3 80 3 83 3 85 3 89 3 92 3 95 4 00 4 01 4 02 4 05 4 08 4 14 421 426 4 41 5 13 am clear about the goals and objectives for my department 3 63 3 72 3 77 3 82 3 87 3 90 3 93 3 97 3 99 4 01 4 03 4 05 4 08 4 10 4 11 4 13 4 18 4 24 4 31 4 46 5 17 I understand how my work fits into the overall aim of the organisation 191 3 92 4 04 4 08 4 10 4 14 4 16 4 20 422 425 426 428 429 431 4 34 437 440 445 448 4 54 5 Change 26 have sufficient opportunities to question managers about change at work 2 32 2 71 2 82 2 98 3 02 3 07 3 11 3 14 3 17 3 20 3 23 3 27 3 31 3 34 3 39 3 44 3 46 3 55 3 59 3 68 5 28 Staff are always consulted about change at work 2 11 2 28 2 38 245 2 51 2 58 2 66 271 275 2 79 282 2 86 2 94 2 97 3 00 3 03 3 05 3 09 3 18 3 37 32 When changes are made at work am clear how they will work out in practice 2 38 2 58 2 64 2 77 2 82 2 86 2 89 2 93 2 97 3 02 3 06 3 11 3 13 3 15 3 17 3 19 3 21 3 27 3 31 3 44 5 31 Table 4 Organisational Data Set Question by Question Worksheet Rules Governing Col
21. 04 Survey Data Set 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 demand things from me thatare hard to 1 2 3 3 3 3 3 3 4 4 4 4 4 4 5 5 5 5 5 combine 6 have unachievable deadlines 1 2 2 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 3 3 3 3 3 3 3 3 4 5 5 12 have to neglect some tasks because have too much to do 1 1 2 2 2 09 3 3 3 3 3 3 3 3 4 4 4 4 4 5 5 5 16 am unable to take sufficient breaks 1 2 2 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 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 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 4 4 4 4 4 4 5 5 5 5 5 Control 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 2 3 3 4 4 4 5 5 5 5 5 10 have a say in my own work speed 1 2 2 3 3 08 4 4 4 4 5 15 have a choice in deciding how do my work 1 1 1 1 3 33 19 have a choice in deciding what do at work 1 2 4 5 5 25 have some say over the way work 1 2 4 30 My working time can be flexible 1 1 1 2 3 4 4 4 5 5 Managers Support 1
22. 2000 ar later Input Extract Selected Category If you ve applied a titer to select rows whose cabegorys you re inberesbed in press the Extract button Ec remove ihe girar roan Caution The process ix irreversible You should save Ihe original preadeheet first under diferent file name or you may lose data Extract 4 RM umma Reus OuucerbeluRroa J Kx 1 Ries bane L iui wi Figure 9 Options worksheet Alternative method of data entry for entering numerical data 11 Click on the button and follow the detailed on screen instructions for entering questionnaire data see Figure 10 Questionnaire Data Input a x Use the box below to enter questionnaire categories and responses as numerical input Separate numbers using a plus character For instance if there are three categories corfigured typical input For categories would be Cats 2 9 3 Input for Q1 35 i Formatted similarly except there vill always be 35 numbers separated using characters Enter a category option using is position in the list For example F your location category is set up to be to lt None gt London Cardiff Belfast Edinburgh enter 0 for none 1 for London 2 for Cardiff and so on A zero always converts to none even if None is not present in a category If the Corvert option is checked numerical input For question responses is assumed to be 1 Never 2 Seldom 3 Sometimes 4 Often 5 Always or 1 Strongly di
23. 3 07 3 13 3 18 322 3 25 333 3 52 5 6 have unachievable deadlines 2 37 2 65 307 322 326 331 3 33 337 3 39 342 347 348 3 50 3 50 3 54 3 59 3 64 370 3 77 3 88 5 9 have to work very intensively 174 1 95 2 05 2 13 2 15 2 16 221 222 225 227 231 235 237 242 246 2 48 2 56 2 65 275 3 64 5 12 have to neglect some tasks because have too much to do 2 000 2 50 2 75 2 80 284 2 87 2 89 2 92 294 2 97 2 99 301 3 00 3 07 3 11 3 16 3 20 3 23 3 31 3 54 5 16 I am unable to take sufficient breaks 2 16 2 56 2 93 3 05 3 10 3 16 3 19 324 327 331 3 38 344 3 49 3 56 3 62 3 63 3 68 3 72 3 76 3 83 5 18 am pressured to work long hours 2 22 2 72 3 18 3 38 3 44 3 50 3 54 3 60 3 64 3 67 3 68 3 72 3 76 3 79 3 81 3 88 3 94 4 02 4 16 4 35 5 20 I have to work very fast 1 82 4 2 14 2 31 241 244 249 2 51 2 56 2 59 2 62 2 65 2 68 2 70 274 277 2 81 2 87 2 99 3 08 3 34 5 22 I have unrealistic time pressures 2 46 2 60 2 89 2 98 3 14 3 17 321 3 27 3 31 3 32 3 35 3 39 3 42 345 349 3 52 3 58 3 65 3 73 3 86 5 Control 2 can decide when to take a break 1 94 2 51 3 05 3 24 3 33 341 346 3 52 3 58 3 66 3 76 3 79 3 84 3 90 3 94 4 04 4 10 4 18 4 24 4 37 5 10 jI have a say in my own work speed 2 27 2 76 3 02 3 12 3 21 3 29 3 31 3 33 3 35 3 38 3 41 3 46 3 52 3 57 3 61 3 64 3 66 3 67 3 72 3 88 5 15 I have a choice in deciding how do my work 2 52
24. 3 3365 3 431 Table 2 Organisational Data Set 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 percentile gt 50 amp lt 80 percentile gt 80 percentile Demands 2 9387 gt 2 9387 amp 3 1024 gt 3 1024 amp lt 3 2937 gt 3 2937 Control lt 3 2240 gt 3 2240 amp lt 3 4741 gt 3 4741 amp lt 3 7208 gt 3 7208 Managers support lt 3 2720 gt 3 2720 amp lt 3 4603 gt 3 4603 amp lt 3 6500 gt 3 6500 Peer support lt 3 6270 gt 3 6270 amp lt 3 7800 gt 3 7800 amp lt 3 8892 gt 3 8892 Relationship lt 3 6115 gt 3 6115 amp lt 3 8499 gt 3 8499 amp lt 4 0381 gt 4 0381 Role lt 4 0356 gt 4 0356 amp lt 4 1803 gt 4 1803 amp lt 4 3117 gt 4 3117 Change lt 2 7910 gt 2 7910 amp lt 3 0428 gt 3 0428 amp lt 3 2400 gt 3 2400 30 Table 3 Organisational Data Set 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 demand things from me that are hard to combine 177 2 58 2 75 2 83 2 85 2 88 2 93 296 2 98 3 02 3 03 3 004 3 005
25. 51 amp lt 3 66 gt 3 66 amp lt 3 79 gt 3 79 31 My colleagues are willing to listen to my work related problems lt 3 62 gt 3 62 amp lt 3 76 gt 3 76 amp lt 3 89 gt 3 89 Relationships 5 am subject to personal harassment in the form of unkind words or behaviour lt 3 93 gt 3 93 amp lt 4 14 gt 4 14 amp lt 4 35 gt 4 35 14 There is friction or anger between colleagues lt 3 14 gt 3 14 amp lt 3 43 gt 3 43 amp lt 3 64 gt 3 64 21 am subject to bullying at work lt 4 31 gt 4 31 amp lt 4 53 gt 4 53 amp lt 4 66 gt 4 66 34 Relationships at work are strained lt 3 03 gt 3 03 amp lt 3 34 gt 3 34 amp lt 3 55 gt 3 55 Role 1 am clear what is expected of me at work lt 4 10 gt 4 10 amp lt 4 26 gt 4 26 amp lt 4 40 gt 4 40 4 know how to go about getting my job done 4 11 gt 4 11 amp lt 4 25 gt 4 25 amp lt 4 42 gt 4 42 11 am clear what my duties and responsibilities are 3 74 gt 3 74 amp lt 3 95 gt 3 95 amp lt 4 14 gt 4 14 13 am clear about the goals and objectives for my department 3 87 gt 3 87 amp 4 03 gt 4 03 amp lt 4 18 gt 4 18 17 understand how my work fits into the overall aim of the organisation lt 4 10 gt 4 10 amp lt 4 26 gt 4 26 amp lt 4 40 gt 4 40 Change 26 have sufficient opportunities to question managers about change at work lt 3 02 gt 3 02 amp 3 23
26. Data Sats Select the becchmark survey data against which you wish 2 campare scares Summery of Resets The Summary of Perute workeheet gwes an ceerall summary of your results the r Sts for ad the quectioneares yo 10 date grouped by man sults from s large safonad nurmy of tire of s yoy to comoww e wh th employees and suggests Interen Tagsta and Langer Term Targets r M 4 b biDelore Yoa Start Catecurer Erte Cusstornaie Sco Data els J Srwarv oi Rmus del it Figure 2 HSE Management Standards Analysis Tool first screen 2 2 CHECKING FOR OLD OR UNWANTED RECORDS Warning Please do not delete any unused columns as this will cause errors within the spreadsheet 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 unwant ed records You can delete a record or a series of records in the f ollowing way Select 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 3 Then select Delete from the Edit menu to delete the rows you have selected If the records that you have deleted are the last re cords in the Raw Data worksheet then the New Record Number will be updated on the Enter Que
27. Detrder sting below to tet he ASCE character code of he dinte uzedin your fie The cone version ot ihe HSE Indicalor Tool uses fe dainte 44 certa The Y youve applied a riter Lo select rows whose category s youre interested in prese Pe Hokowing is 0 Vt of sone cher conrmoniy used codes E irnct button to remove tha other rows 3 Tab Cention The process is irrerrersitte You thous save the oriana zspremithori test 32 Space under a different fle name oc you may lose deta 44 Comme 58 Colon Exil 49 Sermcoton RM Delmker 44 root import Raw eta from Excet Fite Giada from other copies of the analysis tool can be colated using fs facit y Press the bution below and select the solder that contaira tne xia fies you with to process Vihen you cick OK each ode fle vel be opened acd any rw cata contwned n t Aod to this worksneet The success of processing depends on munching column headings e g Question 15 between soros and larget ive Duby sheets H importeg trom versions of the wishes ool price to 1 4 you must go to the Categories worksheet and tenporariy ater the title of Category Ato Category A Category Bto Category Ef tc E a cxtegorec contiguraton fle i5 avaliable wou can use tis 10 restore the ostegory 1865 once the import hae been wid cut Sae the HSE MS Ansiysit Tool Utne Manus tor further information For bert result ana fastest processing collect ail the zore Het you with Lo process in lone folder Put f e target th
28. Health and Safety Management Standards Executive for Tackling Work Related Stress HSE Management standards Analysis tool 153 User manual CONTENTS 1 Introduction 2 1 1 Changes to analysis tool 2 2 Using the Analysis Tool 4 2 1 Launching the spreadsheet 4 2 2 Checking for old or unwanted records 5 2 3 Catergories 6 2 4 Entering your questionnaire scores 8 2 5 Selecting data sets 12 2 6 Obtaining a summary of your results 13 2 7 Examining results for different categories of staff 15 2 8 Saving results for different groups of staff 17 2 9 Importing data from other versions of the HSE Management Standards Analysis Tool 17 2 10 Importing data from older versions of the HSE Management Standards Analysis Tool 18 2 11 Importing data from third party survey applications 19 2 12 Additional features 22 3 Interpretation of Results 24 4 Contact HSE 26 5 Appendix A Question amp Answer 27 6 Appendix B Technical Information and Porcedures Used in the Calculation of Current Performance and Targets 28 6 1 Organisational data set 28 6 2 2004 Survey data set 29 7 Acknowledgements 36 1 INTRODUCTION The HSE Management Standards Analysis Tool is designed to e Accommodate manual data entry of records e Import electronic records from other versions of the Analysis Tool inclu ding earlier versions e Import data from 3rd party survey applications e g SNAP Survey Monkey The analysis tool utilise s one spreadsheet msanalysistool
29. a choice in deciding how do my work lt 3 41 gt 3 41 amp lt 3 63 gt 3 63 amp 3 86 gt 3 86 19 have a choice in deciding what do at work lt 2 67 gt 2 67 amp lt 2 94 gt 2 94 amp lt 3 19 gt 3 19 25 have some say over the way work lt 3 60 gt 3 60 amp lt 3 78 gt 3 78 amp lt 3 97 gt 3 97 30 My working time can be flexible lt 2 90 gt 2 90 amp lt 3 29 gt 3 29 amp lt 3 72 gt 3 72 Managers Support 8 am given supportive feedback on the work do lt 2 88 gt 2 88 amp lt 3 11 gt 3 11 amp lt 3 34 gt 3 34 23 can rely on my line manager to help me out with a work problem 3 48 gt 3 48 amp 3 73 gt 3 73 amp lt 3 94 gt 3 94 29 can talk to my line manager about something that has upset or annoyed me about work lt 3 59 gt 3 59 amp lt 3 74 gt 3 74 amp lt 3 93 gt 3 93 33 am supported through emotionally demanding work lt 3 03 gt 3 03 amp lt 3 20 gt 3 20 amp lt 3 38 gt 3 38 35 My line manager encourages me at work lt 4 25 gt 4 25 amp lt 4 39 gt 4 39 amp 4 51 gt 4 51 Peer Support 7 If work gets difficult my colleagues will help me lt 3 63 gt 3 63 amp lt 3 79 gt 3 79 amp lt 3 93 gt 3 93 24 get help and support need from colleagues lt 3 71 gt 3 71 amp lt 3 89 gt 3 89 amp 4 03 gt 4 03 27 receive the respect at work deserve from my colleagues 3 51 gt 3
30. cell is blank please check the csv file and add aO in the cell Invalid Data Found Cell 0 1 contains response out of range If this error message is shown it indicates that there have been a data inputting err or e g instead of a cell reading 4 it reads 44 Please recheck the csv file and add the correct response 20 2 11 1 How to select the appropriate delimiter if the default comma 44 is not used The instructions on how to do this are included at the bottom of the Import Raw Data from Text File You will need to go to th e box marked Delimiter delete the 44 in this b ox then enter the number that corresponds to the delimiter you are using In the example below the user wanted to use the delimiter Space so has entered 32 in the delimiter box Import Raw Data from Text File Raw data from a delimited text file can be imported using this facility Press the button below and select the text file that you wish to process The format of the text file must conform to strict guidelines similar to those for a comma separated value CS file The first line in the file wehich usually contains column headings is ignored by this facility Each subsequent line represents one record or one row of this worksheet The first field in the row is assumed to be an ordinal and is ignored The next twelve fields are integers that index into the categories columns found on the Categories worksheet HB If a category set contains lt Non
31. chearts ens from s nation paver of individunls snos no organisations had yet workers Howewer ib more approgriate for rganisalbona 15 compare ther average results with the aver lorgar zationa rather than retpermes iror a survey of iniividusir The reason for thit bes in atat rat the doetrisutien of renponseg from individuals deeem from across s number of crgarerations yo that of responses from indiidumis dram from ain a singe organisation HSE hae now gathered Analysis Tool data from 136 organisaona who have completed the surv ginerale few benichenaro 0 that now crgatetations using the tool can Compare theraetves from other organeations and net agani a zrpls of ndvidualr MWh the changes mean in practice Firsty tne how benchenarks are more appropriate than the previous benchmarks as Ley allow compa new tar gels are rover and therefore easier to achieve see QLA below wis are the new bescivouka working conditicns under fe Feng of Hol ses QUA below does Dic expleio wy my noi nent The toot will ctl slow use of the oid benchmarks with users required 15 select the benchwrarks wysintt L Ihericetoec HSE recortenencis fhe Lhe nee benchenarks based on organisational dala sads be used in the marito w lal b MN Before Vou Stat Caecones Enter Questionnaire Scores Data Sets Summa of Resuts T 14 mum gt i Figure 11 The Data Sets worksheet 2 6 OBTAINING A SUMMARY OF YOUR RESULTS Please do not change the la
32. ctore I z BLXOGEROE GEI Figure 16 Question by Question worksheet for group selected If you use the Category Filter fa cility and there are fewer t han 10 people in the group you have selected the Category Filter facility will return the me ssage The filter returned too few results to analyse Yo ur filter selection has been cancelled To pro tect the anonymity of respondents when reporting results the filter does not allow for analysis of results f or fewer than 10 participants However it is possible to access such information using the Raw Data worksheet of the HSE Manage ment Standards Analysis Tool Itis recommen ded that survey coordinators within organisations exercise discretion in providing wider access to the Raw Data worksheet 2 8 SAVING RESULTS FOR DIFFERENT GROUPS OF STAFF Warning Please note that this pr ocess is irreversible it is important to save th e original spreadsheet first under a different name otherwise you may lose data You may wish to keep all your res ults 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 functio n 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 be found under the heading Extract Selected Category on the Options worksheet to delete
33. ds Analysis Tool Tre HSE NS Anaiyels Tool is configured with s nunber of dle sets Dolore you analyse your Becker ound survey dala use the drop down let below to select the data set with which you wish to compare scores The aratyris tool Mowe ups to meret the pertoerance of ther ongartssten in reistion to rete of wor potential syeczors includes n tacky To compere the orgsninations reads wih responses tron anat Crganietional Arme workers taken in 2004 when the Management Standards aggrosch was bunched The toot a3239 colour Codes Lo seven sett of working condiSora Derant Corto Mariger Support Desotgtion and Changs wth the colour dencting perio rance retires to fe rexpormes Inthe national mangle The For 136 organ tions ris date super sae stie 2008 Gate e penes to the night oar bry comparing fe orgscmation s responsas to banchrarke inthe natoni tewnple ne follows fre detaia Green Better than or equsito tre 0 percentile 01 the national aata Bese Getter than ce equatto he SO percentile ol the national dala bul not as good a the B0 percent Aker Geter than or equa tothe 20 percertie of the natora date but not ax good sz the 50 percert Wed Mot as good avt the 20 percartie of fe nation di s Changes made The geinoeles above 11 appe However ite benchrsarks wach undip fe colour coding i the an reasons ate cofines in the box beira Phen the HSE Managerert Standard Arakea Tool was frat dengred n 200 the onty cate av ben
34. e but above or at 20 percentile Improvement needed Above or at average but below 80 percentile Good performance but potential improvement Above or at 80 percentile top 2096 of benchmark Doing very well Need to maintain performance It is important to focus on the percentiles and colour coding as well as the average figures for the responses as the percentile bound aries vary f or each Standard Appendix B describes the technical information and procedures use d in the calculation o f current performance and targets for both the Organisational Data Set and the 2004 Survey Data Set This is because t he benchmark data ha s indicated that there are some areas that organisations find easier to manage more effectively than others By only focusing on the average response an organisation may be distracted by a lower average score even though achieving this Standard is actually harder and therefore by co mparison to others may be performing relatively better on that Standard In addition to the Overall Results the Individual Question Results provide a detaile d picture of the findings The Individual Question Results gives the a verage score for each question The colour coding gives an indicat ion of how the scoref or that question relate s to the benchmark A single question resu It may prove helpful as a promptt o discussions within focus groups but should not be interpreted as a definitive assessment of your performance since it
35. e gt as the first option an index of 1 selects the second entry for a category 2 selects the terc and so on The rest of the fields are transferred as is to this worksheet i e they are assumed to be actual question responses Use the Delimiter setting below to set the ASCII character code of the delimiter used in your file The folowing is a list of some commonly used codes 9 Tab 32 Space 44 Comma 58 Colon 59 Semicolon Delimiter 32 Import 21 2 12 ADDITIONAL FEATURES The Totals worksheet a worksheet providing addition patterns of responses The Totals worksheet records for each of the questions al information on respondents Response Counts the numbers of respondents selecting each of the response categories Response Counts the percentage of respondents excluding non respondents selecting each of the response categories see Figure 20 me pd em pomt Pare rods Dota Window feb BP Fase weite Metctes M Ten Laa ideni shad K pein G Pe ad vot ILI a a a liveru iw ta po dnd pirg ty ph durer omo here rar tirs tls dear LP d E A ets Capo vm Ped oA in wart 1o hem V0 SO gn aaa Iam a sag eee Eaa id aid eq dmi ad indir dini am I hien O Mt 20 140 bec pane have 100 r2 40 V ars aar secat the goals ancipactay ncm bpene Tet mboinn u age betwee sabe pert Hem HORA Oei PO YO BOM eo ars ee o td pci E T peu EVO wom Obat eee q Poked indere vr ido ac eot Iba to em
36. entile 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 Note The procedure ensures that score s that fall b elow the 2 0 percentile are alwa ys seta Suggested Interim Target at least equivalent to the 25 percentile score If an organisation score s at or abo ve the 80 percentile on one of the stress fa ctors the procedure returns a message sug gesting that they set their own interim and longer term targets for continuous improvement Suggested Longer Term Target The Suggested Longer Term Target scores are derived from the 80 percentile figures in Table 1 28 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 Thisd ata is ba sed on the Organisational Data Set average results from 136 organisations that have completed the survey using HSE s Management Standards Indicator Tool Table 4 shows the rules governing the colour coding cut offs used in presenting the results in the Question by Ques
37. 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 activat ed when you open the last page Figure 8 Click it wh en you have finished entering the replies for a question naire You will be 9 prompted to confirm that you wish to save the record If you select Yes a message box will say Record Added showing that the record has been added successfully x Question 29 I can tak tomy line mansger P 5 about something that hasupsetor C Songy Disagree C Disagree C Neid C Agme Strongy Agree No Answer sne annoyed me about work Question 30 M time can be flexible ae C Strongly Disagree C Desagree C Neutra ages C Stroogy Agree C No Answer Question 3t My colleagues are willing to istan to mrg moro related problenis C Strongly Disagree C Disagee C Netra C agree C Strongly Agree No Answer Question 32 When changes are made at work T aet che hos they will work out C Strongly Disagree C Dsagee C Neutra C Agree Sticogy Agree No Answer in practice j Lem supported through emotionally demanding work C Strongly Disagree C Osages C Nedra C Agee Strongy Agree C No Answer Question H Relebiorchips st work are strained C Strongly Disagrees Disagree C Netra C Ages C Strongly ree C No Answer Question 35 My line mansger encourages me ar work C fho
38. epport E lm gie operis hichd oo de vei de 23 Von rds so mg Bae nnn irte do ma iden 38 Males mener imme ge me t Overen Pen Seppon T Ws gio diVele mp colcgeo wi kem 24 Lope help d reperti end rem Congired with vesti jt Organiska Amer ism es WUE M Axdycit Tost Uses Murat fet mete iM tiit tad foh Cii Veg age L ot reca M4 vH DstaSets 7 Summer of Resis Ouestion bv Question Totals Raw Dats Octiore 7 lal EEEN Figure 13 Question by Question worksheet results for individual questions 2 7 EXAMINING RESULTS FOR DIFFERENT CATEGORIES OF STAFF Open the Results analysis file and select the Raw Data worksheet Figure 14 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 You can now select the Summary of Results or the Ques tion by Question worksheets to examine the results for the group yo u have selected Time taken to analyse records when using the Category Filter facility If you use the Category Filter facility to analyse large numbers of records and then select the Summary of Results or Question by Question worksheets there will be a short delay while the HSE Management Standards Analysis Tool processes the data and updates the figures in the worksheets 19 I pia dt ew not Format ook Qata Widow Hep ls A Second Sin 1 2 3 4 5 8 Ll a a Swarces Swarces Ca
39. is le i a seperate folder end ensure all other workbooks are deaed betore proceeding Mar trig Depending upon how marry 51 es are berg processed eperling raw dala M4 gt Surmerv of Rests Ouestiontw Question Tots Rew Data Lotions Isi Figure 17 Options worksheet Import Raw Data from Excel 2 10 IMPORTING DATA FROM OLDER VERSIONS OF THE HSE MANAGEMENT STANDARDS ANALYSIS TOOL You may use the Import Raw Data from the Excel facility on the Options worksheet to import data from versions of the analysis tool prior to version 1 4 To find out the version of the Analysis Tool you are currently using right click on the r elevant Excel file and then select Properties and the n the Summary tab Version infor mation is contained under Comments If no version information is disp layed this indicates that you are usin g an earlier version of the Analysis Tool 1 3 or earlier The early versions version 1 0 supported a maximum of 3 categories input as part of the Enter Questionnaire Scores worksheet Versions 1 1 to 1 3 supported a maximum of 4 categories and a separate Categories worksheet To import data from versions of the analysis tool prior to version 1 4 go to the Cat egories worksheet and alter the title of Category A to Category A Category B to Category B etc see Figure 18 Then follow the same procedures describe d in the section above to import raw data 18 Once the import has be en carried out yo
40. kind Neve Sakon Sonwtirs Often Aar No Arwe I have unachievable deadines que 3 C Neve C Saim C Sometimes C Often C Amars C Wo eoe If work gets difficult my ganny colesgues wil help me C Neve C Seldom C Sometimes C Often C imss C No freer AA Select Questlons EH coe iz ena isei zeza a9ss mownocoamanene e5 Figure 6 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 See Figure 7 HSE Indicator Tool Scores Entry Question 8 L am given supportive feedback on the work I do C Merve C Seldom C Sometimes Often C Ades C No Arewer Page 2 Question 9 I have to work irkensively m Never C Seldom C Sometimes Often aimes C No Arewer Ihave a say in my oon work m Question 10 speed C Never C Seldom Sometimes C Often mays C No Arewer Quesbon 11 Lam clear ahat my duties and Y mm C Never Sektom C Sometimes Often Always C No Arower Question 12 L have to neglect tasks Eechuse have boa Po eck ts C Neve C Seldon CO Sometimes Often C Almays C No Arwe do Lam deer about the goals and mns objectives For my department C Neve C Seion C Sometimes Often Almays C ho Arewer Question 14 ees 3 C Never Seldom C Sometimes C Often C Ameys C No Arewer lt gt Select Questions pateetatrecod cae a ous saif 22 zoos mewnacordtinter Ee Figure 7 Scores
41. ment Standards approach other relevant data should also be co nsidered For example absence data and turnover are t wo other important indications of the prevalence of work related stress in your organisation It is important to appreciate that the results of the survey alonec an only pro vide an indication of performance in managing work related stress You will need to sh are and discuss the outcomes of the survey and other data collected with employees and explore any issues raised in more detail for example in focus groups As suggested at step 3 of the Management Standards approach Evaluate t he risks Explore problems and develop solutions we recommend that you confirm all y our survey results with your employees for example in focus groups to assess whether the results highlight a potential problem area for your organisation This is particularly im portant when you are considering responses to individual questions Caveats for the Psychosocial Data set The survey results for the Role stress factor indicate that avery larg e proportion of the people responding to the national survey score d 5 on the questions re lating to Role One consequence of this is that an org anisation may achieve what appears to be a f airly high score on Role e g 4 2 and yet find that they fall below the 20 percentile for that factor when compared with the national survey results Further information is available from http www hse gov uk stress
42. ngy Desoree C Osagree C Neutral Cages C Strongy Agee C No Arewer za Select Questions _ Debt Recor cot J ar ons ise 222 cos NewRecordtianber M New Record Figure 8 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 can then use the drop down menus to indicate the group s to which the next questionnaire s results belong and start entering your results for the next questionnaire The New Record Numb er box on th e 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 numbersn ormally 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 realise that you have entered the wrong answers for a questionnaire The Delete Last Record button will remove the last record that you have saved Limitation on numbers of records The HSE Management Standards Analysis Tool is not desig ned to cope with more than 40 thousand records If yo u need to a nalyse more than 40 th ousand records then you must split the records into se parate batches and analyse each batch using a separate version of the HSE Management Standards Analysis Tool 10 Saving
43. one gt not as lt none gt or None This allows the user to record instances when respondents to the questionnaire may have failed to provide a selection for a particular category Beginning with Category A replace the identifier Untitled with the tit le of the category In the example in Figure 2 above the coordinator or person setting up the categories h as chosen to enter results using the categories of Location Grade of Staff Sex and Age Please note thatac ategory entitled Untitled or whos e title is left blank will not be considered configured by the Management Standards Analysis Tool i e it will be ignored To enter items in the c ategory list simply t ype them in as you wish them to app ear e g Swansea Glasgow 2 4 ENTERING YOUR QUESTIONNAIRE SCORES Select the Enter Questionnaire Scores workshe et from the tabs at the b ottom of the screen The first page of the HSE Management Standards Indicator Tool Scores Entry input form is shown in Figure 5 HSE Indicator Tool Scores Entry XJ The coordinator of the rick assessment may have specified that the organisation be categorised to meaningful information e g by location role of department If the organisation has been divided into groups for this purpose please use the drop down lists below to indicate the groupis to which the questionnaire results you are entering belong as advised by the coordinator Location lt Nore gt
44. ore security settings when you have finished using the HSE Management Standards Analysis Tool We recommend that you restore the original setting as soon as you have finished using the application At the bottom of the first screen you will see a series of tabs see Figure 2 Clicking on the tabs allows you to move to different worksheets Please read the before you start tab for more information about the other tabs Mjm GM Wee pest Former Ines Qo Wedow Hep PEIE HSE Management Standards Analysis Tool m Belore you start Ae recommend hat you refer To Ihe fob estructiar in the HSE Management Srasdants MS Acabysia Tool Usar Manual before you start using the HSE MS Analysis Tool importas To make the MSL MS Analysis Tool werk save copy to your computer nee and reaper Excel ifii is abd y open oy hire Grithed uung the Brief instrections We suggest that you pret these instructior before using the HSE MS Analysis To Ad the bottom of the screen you see 3 cones of tabs Clicking on the tabs allows you te ts us described so wil affect the Categories The Categories tab s To enter resutts for difiovant groupa a ca of group Gortfars in up to twelve catego J 1 batore onang any results Enter Questionnaire Scores Erte your resulte by clicking on the Ester Queetoonare Scones tab at the bottom of the workaheet This opens a Seem that sliows you te veter the atewers 10 the 35 questus ifi tenes of screen
45. our Coding Cut offs for each Question Red Yellow Aqua Green 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 that are hard to combine lt 2 85 gt 2 85 amp lt 3 03 gt 3 03 amp lt 3 22 gt 3 22 6 have unachievable deadlines lt 3 26 gt 3 26 amp lt 3 47 gt 3 47 amp lt 3 64 gt 3 64 9 have to work very intensively 2 15 222 15 amp lt 2 31 gt 2 31 amp lt 2 56 gt 2 56 12 have to neglect some tasks because have too much to do lt 2 84 gt 2 84 amp lt 2 99 gt 2 99 amp lt 3 20 gt 3 20 16 am unable to take sufficient breaks lt 3 10 gt 3 10 amp lt 3 38 gt 3 38 amp lt 3 68 gt 3 68 18 am pressured to work long hours 3 44 gt 3 44 amp 3 68 gt 3 68 amp 3 94 gt 3 94 20 have to work very fast lt 2 44 gt 2 44 amp lt 2 65 gt 2 65 amp lt 2 87 gt 2 87 22 have unrealistic time pressures lt 3 14 gt 3 14 amp lt 3 35 gt 3 35 amp lt 3 58 gt 3 58 Control 2 can decide when to take a break lt 3 33 gt 3 33 amp lt 3 76 gt 3 76 amp lt 4 10 gt 4 10 10 have a say in my own work speed 3 21 gt 3 21 amp lt 3 41 gt 3 41 amp lt 3 66 gt 3 66 15 have
46. ows 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 7 29 Table 1 Organisational Data Set Percentile Figures for each Standard if gt gt PP Pe Pe P PPP PPP PS P Demands 2 4530 2 6854 2 8489 2 8977 2 9387 2 9769 3 0017 3 0314 3 0600 3 0796 3 1024 13 1300 3 1424 3 1700 3 2073 3 2300 3 2937 3 3485 3 4214 13 5081 5 Control 2 3081 2 8074 3 0169 3 1395 3 2240 3 2857 3 3410 3 3799 3 3983 3 4253 3 4741 3 4975 3 5557 3 6000 3 6378 3 6685 3 7208 3 7600 3 8130 3 9304 5 2 6394 3 0407 3 1099 3 2158 3 2720 3 3135 3 3412 3 3822 3 4113 3 4338 3 4603 3 4805 3 5085 3 5305 3 5670 3 6281 3 6500 3 7008 3 7302 3 7953 5 Management Support Peer Support 3 3589 3 4745 3 5295 3 5889 3 6270 3 6600 3 6810 3 7121 3 7300 3 7482 3 7800 3 7988 3 8124 13 8300 3 8438 3 8608 3 8892 3 9158 3 9506 3 9959 5 Relationships 1 8993 2 7120 3 4733 3 5315 3 6115 3 6638 3 7179 3 7630 3 8008 3 8249 3 8499 13 8813 3 9018 3 9390 3 9698 4 0040 4 0381 4 0494 4 1037 4 2007 Roe 34537 3 8485 3 9584 4 0069 14 0356 4 0701 4 0900 4 1199 4 1490 4 1700 4 1803 4 1855 4 2100 4 2449 4 2638 4 2787 4 3117 4 3300 4 4024 4 5296 Change 22925 2 5447 2 6630 2 7243 2 7910 2 8400 2 9046 2 9329 2 9874 3 0287 3 0428 3 0763 3 1200 3 1410 3 1754 3 2121 3 2400 3 2740
47. regen Uverpoor Swanes Gargow Cintgow Sarrea wuuuwmizszaarcoiie Wie o no EJ Uverpoot a Gargow 2 Swarces 2 Sanes 25 E Moto warnen Ari Ferae 0 a x Lrvarpoot Techrical Ferai an 7 CA geo Adee Vine ERE 2 utum Adea we 41 50 2 Gorgon Aen Mee 5 3 x 3 ware Maret Vine on x x CA goo Teche Teran EE n R a tar Adnan Feran mu E E bt Reste on E 5 2 x Glasgow Magret Ferae n x Swarces Techrical Ferais St amp aver Swanten Adnan Van na 3 y Saree Tarewa Ferae 43 58 Swores Meteo Ferae on LJ E Gargow Techrical Ferais 3 LU 40 TAa ger Adnan Feras zm 4 t uy tato Reste o v 2 a a oxen Mar vyyerent Ferae 5 3 LM 43 Gargow Teche Ferate EE LJ 4 Swarces Adare Forais a LA 4t Swann Techem Vis na g a Gorgon Aone ve on M 4 MZ Date Sate J SawuuvciRands J GuedionSyOuedon uut i Raw Data Octa Ma finis Figure 14 Raw Data worksheet In the example in F igure 15 and F igure 16 the Category Filter message abovet he Key indicates that the user has chosen to examine the results for Glasgow based administrative staff It also indicates the number of su ch staff and the percentage they represent of the total group responding to the survey Ege Gd ew pat Format Took Gata Window Heb Summary of Results Your Suggested Suggested Cita Set Qug aat Med Average Results mem Longe Tem Cregos Pher Location Glasgow Grade of sta Admin w 48 22 21 Target Tange Key 1
48. represents of respondents to the question who reported that they were always often or sometimes bullied 14 Gl Ble pdt wew pent Fomet Took Qsta Window Hep lsi xj The tewelix aco grouped by ztiezzor and the average roore ix shown fee each question azzocialed with that strexror est rg Gestion Aeeiege Key fy Doing nny wem sed t mut pronun s Retacion Nps Wepresewhs tape wt shane vm aleve te the BB perenne 3 Devore gepi y mt domin as S Ian ist tp parten evitan ia the E foam ot vidied word or baleiros Iba wwnchiwabe animes M Teoxcio fiction we vagus bon bisce n d 28 tom rhon ing eet m 7 pire dre Bl 07s percentile AD tees 00 wegheet votes ects Berta 34 Pil icedepi V eon we oed Mors n th bo do IG Fon ered te ribs atidan bare Doecalt gr 12 6 7 of the stait who sesposded report that thes are abwags offen OF sometimes belled 20 Iharcne sort very Inet Note 22 Pared tome prem IDE Date Set Ovquascwtieonl Aeeriger Overt A Dam bow Vo ge disi gutting meg jb iva du ibat irba ud n fua fuv hou Ga quur vet stc Carat fet me sowie 2 Henn deti eon t th v he LAE xn in v te onn rene VO there s rmi mpm wet spend Deerat d ihana odoris i ding bomi do my pan f aes a dece decas what do ut pery Change 25 Ihoa cona cop caw the wag l eo 26 ihon orte iar eppermidem quiu p Alan ot vet 28 Pip orina tins co be faci 28 tot Seer ems ow den V t 32 Vaven esh v meth adw Dora bow as wil work cr in proce Deera Managers S
49. rganisational Avereges Results Interim Longar Tene Target Target Key CI Doing vory well need to malntain performance Demands Represents those at above or ekose to the B percent Control Good but need for improvement Managers Support d Sxprexents those better than average but not yet at aby Peer Support i Clear cand for improvement Relationships Represents those Bkety to be below average but not be Role Urgent action needed Change Represents those below the Mh percemiec You we doing very wel onthe tolowing sress factors Managers Support Peer Support vou are above the OiRh percertile for there rirers tectors We cupgedt that you pet your owe intern and bagarie targets for Continuous inprowensent O Yor Rents 8 Suggested Interim Tant Suggested Longer Term Target 1 Cortgered wih result Ion Orgareabonal Averages See the HOE NS Analysis Tool User Manus tor rore ffonmabion and Sor Caveats regarding nterpeetaon or result lal MN Bslore Voz Stt Cateoores d Enter Questionnaire Scores J Data Sets Summae of Results lal es Figure 12 Summary of Results worksheet Individual question results The Question by Question worksheet Figure 13 shows you the average score for each question The colour coding gives an indicatio n of how your performance for that question relates to the results from the chosen data set For Question 21 the worksheet hig hlights in red the number of staff plus the percentage this
50. rk and wish to make comparisons between your two surveys you may wish to use again the same benchmark toa ssess progress See Appendix one for more information 2 USING THE ANALYSIS TOOL The following sections of the HSE Manage ment Standards Analysis Tool Use r Manual describe the content of the analysis tool in more detail When using the Analysis Tool please do not change the names of any of the worksheets as this will affect the operation of the Analysis Tool 2 1 LAUNCHING THE SPREADSHEET To make t he HSE Management Standards Analys is Tool work save a copy to your computer You can save a copy of the HSE Analysis Tool to your computer by first clicking on the highlighted link to highlight hover your mouse over the analysis tool text when the text turns green it is hig hlighted with the right hand button of your mouse From t he drop down menu select save target as now follow the instru ctions on screen and select a location on your computer our network drive to save the file Launch the spreadsheet and sele ct Enable Macros If the Enter Questionnaire Score s 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 You should check with your organisations security policy or IT de partment before changing your security setting s You can rest
51. rogre ss and another to direct future activity Because you now have two sets of results you c an use your first set of results as your own internal or historical benchmark The second set of results and any subsequent surveys can be compared against your first set of results if required 27 6 APPENDIX B TECHNICAL INFORMATION AND PORCEDURES USED IN THE CALCULATION OF CURRENT PERFORMANCE AND TARGETS 6 1 ORGANISATIONAL DATA SET Summary Of Results Worksheet Table 1 contains data from 136 organisations that have completed the survey using HSE s Management Standards Indicator Tool Table 1 shows the scores by cumulative percentiles of the score distributions for Demands Control Managerial Support Peer Support Relationships Role and Change Table 2 shows the rules governing the colour coding cut off s used in presenting the results in the Your Results colu mn of the Summary of Results worksheet These rules are derived from the data in Table 1 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 Re sults worksheet is co mpared with the perc
52. sagree 2 Disagree 3 Neutral 4 Agree 5 Strongly agree Categories 0 0 Responses 0 35 Once you have entered the data for a questionnaire press the Parse button below Your data wil be processed and displayed Check the output and F you are satisfied that k is correct press the Commit button to save your inputs to the Raw Data worksheet Parse Reset I Convert Commit Close Figure 10 On screen instructions for alternative method of data entry for entering numerical data 2 5 SELECTING DATA SETS The HSE Management Standards Analysis Tool is conf igured with a number of data sets The Data Sets tab allo ws you to s elect the benchmark survey data with which you wish to compare your results Select the Data Sets worksheet from the tabs at the bottom of the screen see Figure 11 Before selecting a data set please read the information in the box titled Important changes to the HSE Management Standards Analysis Tool this provides detailed information on the benchmark data sets and HSE s recommendations on selection of a data set 12 In the example in Figure 11 the da ta set selected is Organisational Averages This is the default data set If you wish to select a different data set use the drop down list on the left hand side of the worksheet to select an alternative data set BE the gdt ew pest umet Tools Qa Window teo alaj xj E Data Set Selection Important changes to the HSE Management Standar
53. stionnaire 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 Column A of the Raw Data worksheet In Excel the Se ries Fill feature can be accessed by selecting the Edit menu then selecting Fill gt Series LA Blo pdt vew pet Fumat ook Data Medow Hep JE 1 2 3 4 5 6 7 8 3 10 26 28 M ni X Sw T jz x CAsegow Techical Tete 3140 Glasgow Ati Fetal 51 40 Gsegow Research m 40 35 E Ghagow Wanagernent Fora 31 40 EJ 5 Swansea Techical ferrets 51 A over Ea 36 Swansea Wale 2130 EJ y Swine terree Fete 41 0 38 3 Swansea Resewch Feral 4 50 40 Casgow Tecteicul Fata 5140 M 40 Glstgow Adi Fere 21 30 42 4 a gow Research Wake 21 30 ia e Gbrgow Tere 3140 44 43 Glasgow Teornical Fata 31 40 45 Swansea tore Foras m 46 45 Swansea Tecrrical Wale 21 30 a Gsegow dere Msh nt 4 win DataSets Summe of Reais l CusstinbyOusstin Tos Raw Data Octore A laf LEEXEAEZERZEED Figure 3 Highlighting row heading numbers for deleting 2 3 CATERGORIES 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 youro wn choice of group identifie rs in each of up to twelve categories Listing categories here will make them available to you when you move to the next worksheet to enter your questionnaire scores
54. t em at af nnd V edil woe Ihm Ye Fe pa EUM T Lean ti on mm ina manages to taip me mr vtt a rt prob Dri Oe Ney and taper red bare cda gere em BOR Duy Dvd P ng nos imanan he ers gn ad vert dme un Form dira prs SOM i abrupt LOO Hd abs Odi M at Ay Ore tne cv fe Pdl AN ool q2u90 qe allg ta Ron some eos adnot prooem p ee eode ee d Fekat m vot emret ym ph uuHtuwuuuuuvyhEHuHzWuds osn39 iu dec da mem acer nm Orem gap e wc tum nid thane borna Pa oe heed vocem Ph DAE AO ptr OA he ICD n MORS OF and eoe CE oF Ob pio Lures iani sans mr verd Ma ris dor cm al arm cd Per m pts rns Ven sutetare nogerur rtea to qur pton marea dicont Ohempt v vert OMA M I n4 negar os pomerdins nh hee qot or rot ne v vot Visa shares ar made ad wert Lum sha a oriundi vor ent m prae fusgonss Comer ae d a o4 Se det mm g x R aA E o x z w w 1 os o x amp 3n o5 o 9 Ld w a0 9 LI x n mw OM oo L cn n in os a ri i a0 95 xy nn mw u oim 05 L x ww n 23 o x n nt ILU Hu x x a x An o L o L HN iM on L o 4 x c6 ff o5 x 4 S hee o5 gt x m ie on cu o m t fs os LI Ly x 9 ow gt uw 05 o n 3 as LI EJ 2s oo i 9 bi w im o LI LI LI 3w o L 1 45 o u x LL o 6 LI in o2 n m 4 o2 o 9 Ll LE H n w u 05 L oO o m oo LI 0 R
55. t153 xls designed for users of Microsoft Excel 2000 or later The tool assigns colour codes to seven sets of working conditions Demands Control Manager Support Peer Support Relationships Role and change with the colour d enoting performance relative to a user sele ctable benchmark The tool determines the ap propriate colour by comparing the organisation s survey responses to a benchmark as follows Key E 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 yet at above or close to the 80th percentile Clear need for improvement Represents those likely to be below average but not below the 20th percentile Urgent action needed Represents those below the 20th percentile Figure 1 Key to colour coding 1 1 CHANGES TO ANALYSIS TOOL This version of the Ana lysis Tool contains important changes from previous versions It contains a facility to allow you to select the benchmark survey data wi th which you wish to compare your scores There are 2 benchmarks available One is based on the psychosocia working conditions in Britain in 2004 It compares the organisatio n s results with responses from a nationally representative sample of workers taken in 2004 when the Management Standards approach was launched A new benchmark which supersedes the 2004 data is also available It is based on surveys cond
56. tion worksheet These rules are derived from the data in Table 3 6 2 2004 SURVEY DATA SET Summary Of Results Worksheet Table 5 contains data from the HSE survey Psychosocial Working Conditions in Great Britain 2004 Table 5 shows the scores by cumulative percentiles o f the score distributions for Demands Control Managerial Support Peer Support Relationship s Role and Change Please note that the o rder of these factors d iffers from the order given in Table 5 of the above survey report in that Relationships appears before Role in Table 5 Table 6 shows the rules governing the colour coding cut offs used in presenting the results in the Your Results colu mn of the Summary of Results worksheet These rules are derived from the data in Table 5 Suggested Interim Target The procedure for working out the Suggested Interim Target for any given stressor is a pragmatic rule of thumb procedure as described above for the Organisational Data Set Suggested Longer Term Target The Suggested Longer Term Target scores are derived from the 80 percentile figures in Table 5 Question By Question Worksheet Table 7 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 Relationship s Role and Change This data is taken from the HSE survey Psychosocial Working Conditions in Great Britain 2004 Table 8 sh
57. to 05 L LI a om o2 x a oa 9 o m o 0 oc E a os LJ x a E o p w d ae zhi Li 5s ziejxi xe t Herpes Cows Hideg sorer pedir 4 s mu uu na LII oe E A sua u we os Lr n D a xa LZ at LT LII sr ae su ab H ne wr z ns n ma B3 ut a ws D a as st LZ LII n e we w s e ma 2 ne LI aa a as ne ni nas z ns Du a tee pe 175 a as es as m nt Po gmet I Cnepered 04 Fono 78 dress mes sponso 165 8 daresay higher to imm rat Rete Oi SOCIO M EPOADA T Ong Wi b Ww drm Ouen Sores Samus d Reds o OvemonivOueson Tops aeuo 14 0 Figure 20 Totals worksheet results for all factors The worksheet also provides this information broken down by individual factors see 21 22 Figure i Ore GORI M vod demand Sag Form e 9 M anm batonta Vt ih pL Aem abi o biben t era Ven Corps Ll LELA c habt ure NS kb Ld Vai halb VO Lahn dm rai Iaa primi icu d V sib aj ina I hame mer ded rn e4 5 eneuwelf CEECEE U cogzoggz z og z gj Tem Ven eride when ize abro eee bey m onn wort pee Vase p ibokot n deciding hoo do mp vot Ibase p haios n ecifing var ide M vod haee rome La Coe the wag leor jte ar Ce Fete thee ee eel jiso assole Ajo t ny onj amp S 2zzu v E Snzsrtisxst fsss rsr arm quove papper tive erdissnh orobe weet Ibe Ven val rim ine manages oe Pel ree one wth acr poshin
58. u can restore the titles of Category A Category B etc to their previous titles Location Role etc You can do this manually or if a category configuration file is available you can use t his to restore the category titles once the import has been carried out 3 Bie tdt wem rect Fumar Jods Quia Window Deb B 1 c 1 D ERI H Categories 4 ja the cegartsabon has been categorized to provide meaningful rforeaton e by bestion roe or departrert isi the calegcrez in the latte bekrw Linting calegeriez here wil make hen naiai when compiating he questotemre 208 mai worksheet z me Lidos with the Lite 01 the category e g Locabor Rok A category entitled Linttie or whose je is left blank i not considered configured by the Anahsis Tool LJ 2 the Special Wendie hone 10 avoid forcing the user 30 Specify a given category Hone rust be he dest tanin category fet M siete it you ore using the HSE WS Anaivels Tool in conjunction with MEOOnke Thes online version of the HSE Indicator Tool please configure Categories ry imoorieg the configuration tron MS QOn ne See the MOQO Admin page and the Options worksheet for more intoenebion 12 13 Category A Category C ESREEEEEEREEE 4 b M Before You Stat 1 Categories Enter Ouessonnaire Scores Sonar of Rests Question be Figure 18 Categories worksheet altering category titles to import from older versions of the HSE Management Standards Analysis tool 2
59. ut work 3 gt 3 amp lt 4 gt 4 amp lt 4 95 gt 4 95 33 am supported through emotionally demanding work lt 3 gt 3 amp lt 4 gt 48 amp lt 4 95 gt 4 95 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 help me lt 3 gt 3 amp lt 4 gt 48 amp lt 4 95 gt 4 95 24 get help and support need from colleagues 4 gt 48 lt 4 95 None gt 4 95 Not possible to set cut offs for the 50 80 percentile range 27 receive the respect at work deserve from my colleagues lt 4 gt 48 lt 4 95 None gt 4 95 Not possible to set cut offs for the 50 80 percentile range 31 My colleagues are willing to listen to my work related problems lt 4 gt 48 amp lt 4 95 None gt 4 95 Not possible to set cut offs for the 50 80 percentile range Relationships 5 am subject to personal harassment in the form of unkind words or behaviour 4 gt 48 lt 4 95 None gt 4 95 Not possible to set cut offs for the 50 80 percentile range 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 80 percentile range 21 am subject to bullying at work 5 None None 5 Anything 5 falls below 20 percentile 34 Relationships at work are strained 2 09 gt 2 09 amp lt 4 gt 4 amp lt 4 91 gt 4 91 Role am clear what is expected of me at work 4 gt 4 amp lt 4 95 None gt 4
60. yout o n any of the screens as this may affect the operation of the HSE Management Standards 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 spreadsh eet 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 When you want to see a summary of the results you have entered select the Summary of Results worksheet Figure 12 from the tabs at the bottom of the screen In the example in Figure 12 the Data Set message above the Key indicates that the user has chosen to use the Organisational Averages data to compare their results 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 targ et 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 Sugg ested Longer Term Target is the value achieved by the top 20 of the scores in the chosen benchmark data set 13 tie tdt ye pemt Pomet Took Date Window to pire Summary of Results Your Suggested Suggested Deta Set O

HSE Management Standards Analysis Tool User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents