HSE Management Standards Analysis Tool User Manual
Contents
1. 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 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 28 amp lt 4 gt 48 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 Approx 15 have a choice in deciding how do my work lt 2 gt 2 amp lt 3 gt 3 amp lt 4 95 gt 4 95 Approx 19 have a choic2. oyod soo a al aso H t wor 3 00 eB o 250 H T I work gete difficult my colleagues 150 help t support need from 100 Pa Pa e Pa TET eg oA sam bain a R See e a e b a ene Enter Ouestionnaire Scores Summary of Results Question by Question Totals 4 Mi gt l i Id 41 gt IMIZ Cateaories 5 lam form i 14 8 3 of the staff include in this querg and in this que report that theg ai Control Figure 11 Question by Question worksheet for group selected For Question 21 the worksheet highlights in red the number of staff from the group selected plus the percentage this respresents of respondents to the question from the group selected who reported that they were always often or sometimes bullied If there are fewer than 10 people in the group you have selected the Category Filter facility will return the message in Figure 12 below Data Insufficient x Filter returned too few results to analyse Your filter selection has been cancelled Figure 12 Fewer than 10 results for the 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
3. 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 doing so will affect the operation of this spreadsheet Categories The Categories tab allows you to set up the HSE MS 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 twelve 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 questionnaires you have entered to date grouped by main stressors allows you to cornpare them with the results from a large national survey of employees and suggests Interim Targets and Longer Term Targets AStart analysistoolmanual micr Microsoft Excel msan e St us RUSWEVRDR n14 Figure 1 HSE Management Standards Analysis Tool first screen CHECKING FOR OLD OR UNWANTED RECORDS Before you begin to enter your questionnaire scores for the first time it i
4. 136 0 0 258 0 0 00 43 581 00 00 35 My line manager encourages me at work o 14 ne 70 30 4 255 0 0 60 496 29 9 128 Ww 30 362 456 268 40 2 94 12 26 312 39 3 234 35 Peer Support I 1 Question Response Counts Avg Non x Response Counts excluding non responde 1D Text Os 1s 2s 3s 4s 5s respondents 1 3 4 414 1b bil Enter Questionnaire Scores Summary of Results Z Question bv Question Totals Raw Data Z fil oll Figure 22 Totals worksheet results for individual factors ALTERNATIVE METHOD OF DATA ENTRY FOR NUMERICAL DATA This alternative data entry facility provides for more rapid data entry It requires that responses on the paper questionnaire that you are processing be labelled 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 23 below E tile Ede yew poet Format Jois Qia Window tin alti xi Input Numerical Data The following facility provides for more rapid data entry It requires that responses on the paper questionnaires that you are processing be labelled with numbers 1 to 5 The method of data input is most efficient when used in conjunction with a numeric key pad and is therefore not suited
5. 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 25 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 demand 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 wh
6. Help l l Ill Summary of Results Your Suggested Suggested Results Interim Longer Term Target Target Key Oo Doing very well need to maintain performance Demands Represents those at above or close to the 80th percentil Control O Good but need for improvement Managers Support Represents those better than average but not yet at abo Peer Support Oo Clear need for improvement Relationships Represents those likely to be below average but not belc Role Urgent action needed Change Represents those below the 20th percentile 5 00 450 4 00 3 50 m Your Results 3 00 E Suggested InterimTarget 2 50 O Suggested Longer Term Target 2 00 1 50 1 00 Compared with results from a representative national survey of employees see the HSE MS Analysis Tool User Manual for more information and for caveats regarding interpretation of Id 4l gt IMN Before You Start Z Cateaories Z Enter Questionnaire Scores Summary of Results Question bv 4 bee im Figure 7 Summary of Results worksheet INDIVIDUAL QUESTION RESULTS The Question by Question worksheet Figure 8 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
7. O 14 14 16 16 16 17 18 19 19 20 22 28 31 INTRODUCTION There is one spreadsheet msanalysistoo 15x xls designed for users of Microsoft Excel 2000 or later The HSE Management Standards Analysis Tool is designed to accommodate manual data entry of records records downloaded from MSQOnline import of electronic records from other versions of the Analysis Tool including earlier versions or a combination of these different forms of data entry LAUNCHING THE SPREADSHEET To make the HSE Management Standards Analysis Tool work save a copy to your computer Launch the spreadsheet and select Enable Macros lf 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 HSE Management Standards Analysis Tool You should close and reopen Excel if it is already open 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 1 below Clicking on the tabs allows you to move to different worksheets The following sections of the HSE Management Standards Analysis Tool User Manual describe the con
8. a message highlighted in red to the effect that x number plus percentage of respondents of your staff report that they are always often or sometimes bullied o This above feature of the HSE Management Standards Analysis Tool is included in response to comments received during the Management Standards Pilots and in the course of consultations with various 23 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 24 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
9. assumed to be 1 Never 2 Seldom 3 Sometimes 4 Often 5 Always or 1 Strongly disagree 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 will be processed and displayed Check the output and if you are satisfied that it is correct press the Commit button to save your inputs to the Raw Data worksheet Parse Reset I Convert Gommit Figure 24 On screen instructions for alternative method of data entry for entering numerical data SCREEN LAYOUT AND TITLES Please do not change the layout on 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 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 18 CONTACT HSE If you need assistance with any aspect of MSQOnline or the HSE Management Standards Analysis Tool or if you wish to provide feedback about your experience using these tools please
10. contact HSE To obtain technical support for issues relating to MSQOnline or to provide HSE with welcome feedback of your experience using this software please send a message to msqonline hsl gov uk For technical support relating to the HSE Management Standards Analysis Tool or for any other query concerning HSE s Management Standards and supporting tools please call the HSE Infoline on 0845 345 0055 For more information please visit the HSE web site at http www hse gov uk contact index htm 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 Appendix C contains information on the CSV format requirements for users wishing to export data from other software applications in a format suitable for import into the HSE Management Standards Analysis Tool Appendix D contains some known issues or frequently asked questions 19 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 the 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 prov
11. 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 be found under the heading Extract Selected Category on the Options 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 may lose data 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 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 13 below Then select Delete from the Edit menu to delete the rows you have selected File Edit view Insert Format
12. htm Any of these digits may be replaced by a zero 0 this would indicate that the participant did not answer the question Finally note that the digits are separated using commas Another separator may be used provided it can be represented with an ASCII code APPENDIX D KNOWN ISSUES FREQUENTLY ASKED QUESTIONS Limitation on numbers of records The HSE Management Standards Analysis Tool is not designed to cope with more than 40 thousand records If you need to analyse more than 40 thousand records then you must split the records into separate batches and analyse each batch using a separate version of the HSE Management Standards Analysis Tool 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 31
13. instance the address of MSQOnline obtained by removing admin admin aspx is http myintranet msqonline Now go to the HSE Management Standards Analysis Tool Options worksheet and find the Download button under the heading Download from MSQOnline see Figure 14 below In the field labelled URL enter the address of MSQOnline in the example given above this would be http myintranet msqonline E ix Eile Edit View Insert Format Tools Data Window Help gt File Download from MSQOnline I file can be imported using this facility Use this facility to download data directly from MS Online the online version of the HSE Indicator Tool lect the text file that you wish to process In the URL field enter the address of MS Online as it appears in your web browser s conform to strict guidelines similar to those for a comma address bar For instance when viewing the Admin page in MS Online in your web browser the address might be http myintranet msqonline adminJadmin aspx In this instance http myintranetimsqonline would be entered into the URL field isually contains column headings is ignored by this facility Select Configure categories if before downloading and populating survey data the s one record or one row of this worksheet Analysis Tool should first download and configure categories so that they match those configured in MS Online med to be an ordinal and is ignored Select Append data if you wish downloaded su
14. much to do 0 0 0 70 132 3 3 84 00 00 00 29 9 564 B7 8 Jam clear about the goals and objectives for my department o o o 4 w2 ne 453 oo oo oo 17 4368 547 Noe 0 4 4 104 38 4 3 40 00 60 WwW hand us 6 0 5 0 18 30 168 347 00 77 128 60 ne Ww 6 0 e a Oo m 438 00 es 77788 n 0 68 2 w o 2 422 00 77 88 eo oo 78 8 0 s 0 3 0 oO 182 00 239 598 W2 oo 00 9 6 0 1 ne 70 4 09 68 00 83 64 532 321 20 fast 0 18 o 84 38 4 3 56 00 77 00 35 9 3 45 a lam subje bullying at work 0 4 28 0 6 186 4 50 00 WwW 12 0 00 68 795 22 Ihave unrealistic time pressures 0 0 o n 106 4 3 57 00 00 00 487 453 6 0 23 Joan rely on my line manager to help me out with a work problem o 4 60 38 18 3H 60 00 20 0 27 3 5 82 24 I get the help and support need from colleagues o o 4 30 ne 74 4 07 oo 00 60 128 436 316 25 0 o 32 100 88 4 04 00 00 137 60 427 376 26 0 o 1 88 38 4 3 65 00 00 6 0 376 s 45 27 B 0 w Oo 168 465 77 oo es oo B 78 28 o 4 7 70 58 358 00 60 77 325 29 29 29 0 34 60 140 0 3 45 0 0 0 0 45 25 6 59 8 0 0 30 0 18 o 0 62 154 443 00 at 00 00 265 65 8 a 0 18 o 48 o 168 4 28 00 7 00 205 00 ne 32 0 6 36 70 56 56 343 00 68 54 29 9 23 9 23 9 33 0 0 98 w o oO 268 00 oo as os oo o0 3 0 B 4 w W we 439 00 77 7 so rse ns 35 o 4 te 70 30 4 255 00 60 496 23 9 128 17 70 388 1020 1588 2344 2780 375 Cx 48 12 5 19 5 28 9 34 3 No of records 234 isk Categorised by Factor 4 4 T4 IIZ Enter Questionnaire Scores Z Summary of Results Z Ouestion by Question Totals Raw
15. replies to the first five questions click the gt button to move to questions 8 to 14 Question 8 lan feedback on Lal ma Corr Seddon C Sedme Ofen sees C Hocem Page 2 the work I Question 9 T have to work intensive biel C Newer C Seldom C Sometimes C Often C Always C No Answer Ihave a say n my Own work ch speed C Newer C Seldom C Soenatimes C Often Always No Anewer Question 11 1am dear what my duties and NARS ao C News C Sain C Scormtions C Olten C Always C No Answer Question 12 I have to neglect some tasks becouse Ihave too much workto C Never Seldom C Sometimes C Often C Aways No Answer a Question 13 1 am deer about the goals ard objectives for my department C Never C Seldom C Sometimes Often C aways C No Answer M Question 14 E C he G saii C Somtises C Often C Always C No Answer J gt Select Questions _eattotanrecrd ca ar ois swat zoe aoas onneamme p senres Figure 5 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 6 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 record has been added successf
16. the import has been carried out Eile Edit View Insert Format Tools Data Window Help laj x B E The followi 2 Categories 3 4 it the organisation has been categorised to provide meaningful information e g by location role or department list the categories in the table below Listing categories here will make them Categc 5 available when completing the questionnaire see next worksheet 6 7 8 Replace the identifier Untitled with the title of the category e g Location Role A category entitled Untitled or whose title is left blank is not considered configured by the Analysis Tool 9 Use the special identifier None to avoid forcing the user to specify a given category None must be the first item in a category list Edinburgh 10 11 Note if you are using the HSE MS Analysis Tool in conjunction with MSQOnline the online version of the HSE Indicator Tool please configure categories by importing the configuration from 12 MS Online See the MS Online Admin page and the Options worksheet for more information 13 14 15 CategoryA Category C 16 C A c 17 lt None gt 18 Cardiff m i London 20 2 22 23 24 25 26 vid 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 s 4 4 ibA Before You Start Cateaories Enter Ouestionnaire Scores Summarv of Results Ouestion bv 4 Figure 18 Categories worksheet altering category titles to import from older
17. versions of the HSE Management Standards Analysis tool IMPORTING DATA FROM PREVIOUSLY SAVED MSQONLINE RESULTS FILES Go to the Options worksheet and find the Import button under the heading Import Raw Data from Text File see Figure 19 below 14 File Edt View Insert Format Tools Data Window Help Import Category Configuration Import Raw Data from Text File 2 Press the button below to import from a categories configuration file downloaded from Raw data from a delimited text file can be imported using this facility the online Management Standards questionnaire Press the button below and select the text file that you wish to process Import The format of the text file must conform to strict guidelines similar to those for a comma separated value CSV file Input Numerical Data The first line in the file which usually contains column headings is ignored by this facility The following facility provides for more rapid data entry It requires that responses on the paper questionnaires that you are processing be labelled with numbers 1 to 5 The Each subsequent line represents one record or one row of this worksheet method of data input is most efficient when used in conjunction with a numeric key pad and is therefore not suited for use with a laptop computer Th
18. you are about to enter have been categorised into groups the Enter Questionnaire Scores worksheet will display drop down menus corresponding to the Categories that you have set up on the Categories worksheet 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 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 3 Lam dear nts of me EMAR C Newer Seion C Scerntimes C Often G inays C No Answer Paga 1 1ean decide when totaka abreak Quston Z C Newer C Seldom Sometimes C Often C Aways C No Answer Diferent groups at work demand m Questioni 3 Medes Bee Soak ore adta C newer C Seldom Sometimes C Often C Always 7 No Answer Throw how to go about getting Question 4 my kb done C Ne C Sakon Scenntionns C Olten Aways C No Answer ae aaa es assent in the Cc G Cc cr Cc ro Never Seldom Sometimes Often Always No Anewer 1 have unachievable doodines Quatins C Never Seldom C Sonatinas C Often C Aways C No Answer H work gots difficult my Question 7 colleagues rll help me C Neve C Seldom C Scermtionns C Often Rimes C No Answer lt gt Select Questions _tebtetamecrd ca ir vig asa zeam aoas nentecminnter p serre Figure 4 Scores Entry input form questions 1 7 When you have entered the
19. 0 5 2 28 Cardiff Admin Female 51 60 3 1 23 Edinburgh 1 3 30 London Consultant Female 4 5 a Cardiff Consultant Female 31 40 3 5 32 Carcitt Male 31 40 3 3 33 Technical Female 3 5 34 Edinburgh Consultant Female 21 30 5 5 35 21 30 4 3 36 Edinburgh Management 51 60 4 4 a7 Technical Male 3 4 38 London Technical Male 21 30 4 3 39 Carcitt Admin Female 31 40 1 3 40 41 50 5 3 4 Management Female 31 40 3 1 42 London Admin 41 50 2 3 43 London Admin Female 41 50 1 3 44 London Technical Male 1 4 45 Edinburgh Management Female 51 60 5 2 46 Female 51 60 2 5 14141 PIZ Enter Ouestionnaire Scores Z Summary of Results 7 Ouestionby Question Raw Data lat In the example in Figures 10 and 11 below the Category Filter message above the Key indicates that the user has chosen to examine the results for London based male administrative staff It also indicates the number of such staff and the percentage they represent of the total group responding to the survey File Edit view Insert Format Tools Data Window Help Summary of Results Your Suggested Suggested Results Interim Longer Term Target Target Demands Control Managers Support Peer Support ig Relationships Role Change You ate 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 Category Filter Locati
20. 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 go 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 falls 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 Masana 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 i percentile range the organisation Change 26 ha
21. Data Z MUE fees Figure 21 Totals worksheet results for all factors The worksheet also provides this information broken down by individual factors see Figure 22 below 16 Eile Edit View Insert Format Tools Data Window Help Categorised by Factor Demands Question Response Counts Avg Non _ Response Counts excluding non responde 1D Text Os Is 2s 3s 4s 5s respondents 1 2 3 4 5 3 Different groups at work demand things from me that are hard to combine 0 24 4 4 136 56 3 79 0 0 10 3 6 0 W 581 23 9 6 Ihave unachievable deadlines 0 0 38 ne 0 20 275 0 0 0 0 u3 49 6 0 0 85 3 Ihave to work very intensively 0 18 4 70 38 4 3 24 0 0 77 5 29 9 u3 60 2 Ihave to neglect some tasks because have too much to do 0 0 0 70 132 32 3 84 0 0 00 0 0 29 9 56 4 B7 6 Jam unable to take sufficient breaks 0 16 1 0 28 We 4 38 0 0 68 77 0 0 12 0 735 18 lam pressured to wor
22. Health and Safety Executive HSE MANAGEMENT STANDARDS ANALYSIS TOOL USER MANUAL CONTENTS INTRODUCTION LAUNCHING THE SPREADSHEET CHECKING FOR OLD OR UNWANTED RECORDS CATEGORISING EMPLOYEES INTO DIFFERENT GROUPS ENTERING YOUR QUESTIONNAIRE SCORES OBTAINING A SUMMARY OF YOUR RESULTS INDIVIDUAL QUESTION RESULTS SAVING RESULTS EXAMINING RESULTS FOR DIFFERENT CATEGORIES OF STAFF SAVING RESULTS FOR DIFFERENT GROUPS OF STAFF DELETING ONE OR MORE RECORDS DOWNLOADING RESULTS FROM MSQONLINE IMPORTING CATEGORY CONFIGURATIONS AND DATA e IMPORTING CATEGORY CONFIGURATIONS e IMPORTING DATA o Importing data from other versions of the HSE Management Standards Analysis Tool o Importing data from older versions of the HSE Analysis Tool o Importing data from previously saved MSQOnline results files o Importing data from other text files ADDITIONAL FEATURES e TOTALS WORKSHEET e ALTERNATIVE METHOD OF DATA ENTRY FOR NUMERICAL DATA SCREEN LAYOUT AND TITLES CONTACT HSE TECHNICAL APPENDICES APPENDIX A CALCULATION OF CURRENT PERFORMANCE AND TARGETS APPENDIX B TECHNICAL INFORMATION AND PROCEDURES USED IN THE CALCULATION OF CURRENT PERFORMANCE AND TARGETS APPENDIX C CSV FORMAT REQUIREMENTS FOR USERS WISHING TO EXPORT DATA FROM OTHER SOFTWARE APPLICATIONS IN A FORMAT SUITABLE FOR IMPORT INTO THE HSE MANAGEMENT STANDARDS ANALYSIS TOOL APPENDIX D KNOWN ISSUES FREQUENTLY ASKED QUESTIONS Page ONN DO DWN ND ee ee See See 6 own
23. IZ Summary of Results Z Question bv Ouestion Z Totals Raw Data Ontions KL e bi Figure 14 Downloading into Analysis Tool from MSQOnline Before you download and populate survey data you may wish to download and configure categories so that the categories in the Analysis Tool match those configured in MSQOnline You can do this by selecting Configure categories If you wish to add the downloaded survey data to any existing data select Append data If you would like to clear any existing data before downloading takes place please uncheck this option Press the Download button to begin You will be notified when the process is complete Please note the Technical notes that appear immediately below the Download button IMPORTING CATEGORY CONFIGURATIONS AND DATA The above method is the simplest method of downloading category configurations and survey data from MSQOnline into the Analysis Tool 11 It is also possible to import category configurations and survey data from category configuration files and survey results files previously downloaded from MSQOnline The following sections describe a number of different types of import facility supported by the HSE Management Standards Analysis Tool IMPORTING CATEGORY CONFIGURATIONS If you are using the Analysis Tool in conjunction with MSQOnline the online version of the HSE Management Standards Indicator T
24. Tools Data Window Help laj xi A B ra D E F G 1 RecordNo Location z Role x Sex x Age Untitled x Untitled 2 1 London Admin Male 41 50 3 2 Cardiff Management Female 31 40 4 3 Cardiff Technical Female 51 60 5 4 Cardiff Admin Male 21 30 cal 5 Edinburgh Technical Female 41 50 7 6 Edinburgh Consultant Female 41 50 8 ii London Admin Male 31 40 3 8 London Admin Male 41 50 10 9 Cardiff Admin Female 21 30 11 10 Edinburgh Technical Female 41 50 12 1 London Admin Male 31 40 12 Cardiff Admin Female 41 50 Edinburgh Technical Male 21 30 London Admin Male 41 50 Cardiff Admin Female 41 50 Edinburgh Technical Male 21 30 London Admin Male 31 40 London Admin Male 31 40 0 Cardiff Management Female 31 40 Cardiff Technical Female 51 60 London Admin Male 41 50 Cardiff Management Female 31 40 Cardiff Technical Female 51 60 London Admin Male 31 40 Cardiff Admin Female 41 50 Edinburgh Technical Female 21 30 London Admin Male 31 40 9 London Admin Male 41 50 30 23 London Admin Male 31 40 a 30 Edinburgh Management Male 41 50 32 a London Technical Female 31 40 33 32 London Admin Female 31 40 34 33 London Consultant Male 31 40 35 34 Cardiff Management Female 31 40 36 35 Cardiff Technical Female 51 60 37 36 Cardiff Admin Male 21 30 38 37 Edinburgh Technical Female 41 50 Es 38 Edinburgh Consultant Female 41 50 40 39 London Technical Female 31 40 40 London Admin Female 21 30 42 4 London Consultant Male 21 30 43 42 Car
25. Z Totals Raw Data Options lal otf Figure 19 Options worksheet Importing raw data from MSQOnline results CSV files Click on the button and select the output file from MSQOnline This will be a file similar to the file shown selected in Figure 20 below History a gt My Documents Favorites BA BW e o My Network Places Files of type esv Fis o o ce Figure 20 Selecting an MSQOnline results CSV file When the import is complete a message similar to the following will display Success Imported 12 lines of data 15 IMPORTING DATA FROM OTHER TEXT FILES The Import Raw Data from Text File facility on the Options worksheet can be used to import data from other comma separated value CSV files in addition to those downloaded from MSQOnline The Options worksheet provides further information More detailed information on the CSV format requirements is contained in Appendix C This import facility can also be used to import data from text files using other delimiter settings apart from 44 comma The Options worksheet provides further information ADDITIONAL FEATURES Additional features include o The Totals worksheet a worksheet providing additional information on respondents patterns of responses o An alternative method of data entry for numerical data TOTALS WORKSHEET The Totals worksheet records for each of the questions e Response Counts the
26. 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 22 Note 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 Suggested Longer Term Target The Suggested Longer Term Target scores are derived from the 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 Psy
27. at 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 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 behaviou
28. chosocial 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 A on use and interpretation of the results particularly the results for individual questions e For many questions it was not possible to set precise cut offs those provided should be interpreted as rough approximations 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 any cut offs for the 50 80 percentile range e For Question 21 am subject to bullying at work o ascore of anything less than 5 triggers a red colour coding since this falls below the 20 percentile of the scores recorded by the respondents to the 2004 national representative household survey see footnote 1 Appendix A o Please note the strong recommendation in Appendix A on the importance of confirming your survey results with your employees Please note in particular the caveat regarding interpretation of results for individual questions o Appendix A recommends that comparisons of such responses with the national survey results should be interpreted as suggestive or as a prompt for discussion only o If any members of staff score 1 2 or 3 on question 21 the worksheet returns
29. cond entry for a category 2 selects the third and so on Input The rest of the fields are transferred as is to this worksheet i e they are assumed to be actual question responses Extract Selected Category Use the Delimiter setting below to set the ASCII character code of the delimiter used in your file The on line version of the HSE Indicator Tool uses the delimiter 44 comma The If you ve applied a fitter to select rows whose category s you re interested in press the Htollowing is a list of some other commonly used codes Extract button to remove the other rows 9 Tab Caution The process is irreversible You should save the original spreadsheet first 32 Space under a different file name or you may lose data 144 Comma 58 Colon Extract 59 Semicolon Import Raw Data from Excel Delimiter 44 Import Raw data from other copies of the analysis tool can be collated using this facility Press the button below and select the folder that contains the xis files you wish to process When you click OK each xls file will be opened and any raw data contained in it added to this worksheet The success of processing depends on matching column headings e g Question 15 between source and target Raw Data sheets If importing from versions of the analysis tool prior to 1 4 you must go to the Categories worksheet and temporarily alter the title of Category A to Category A Category B to Category B etc I
30. diff Management Female 31 40 44 43 Cardiff Technical Female 31 40 45 44 Cardiff Admin Female 41 50 46 45 Edinburgh Technical Male 21 30 47 46 London Admin Male 41 50 F 14141 IMIZ Summary of Results Guestion bv Ouestion 7 Totals Raw Data Ootions 7 E ee oi Figure 13 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 Column A of the Raw Data worksheet In Excel the Series Fill feature can be accessed by selecting the Edit menu then selecting Fill gt Series DOWNLOADING RESULTS FROM MSQONLINE If you are using the HSE Management Standards Analysis Tool in conjunction with MSQOnline the online version of the HSE Management Standards Indicator Tool you can download your results directly from MSQOnline into the HSE Management Standards Analysis Tool 10 First go to the Admin Home page of MSQOnline and make a note of the address of MSQOnline as it appears in your web browser s address bar For example when you are viewing the Admin Home page the address might appear as http myintranet msqonline admin admin aspx In this
31. e first field in the row is assumed to be an ordinal and is ignored This facility requires Excel 2000 or later The next twelve fields are integers that index into the categories columns found on the Categories worksheet NB If a category set contains lt None as the first option an Input index of 1 selects the second entry for a category 2 selects the third 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 Extract Selected Category n Use the Delimiter setting below to setthe ASCII character code ofthe delimiter used in Ifyouve applied a filter to select rows whose category s you re interested in press the your file The on line version of the HSE Indicator Tool uses the delimiter 44 comma Extract button to remove the other rows The following is a list of some other commonly used codes Caution The process is irreversible You should save the original spreadsheet first 9 Tab under a different file name or you may lose data 32 Space 44 Comma Extract 58 Colon 59 Semicolon Delimiter 44 Import Import Raw Data from Excel Raw data from other copies ofthe analysis tool can be collated using this facility Press the button below and select the folder that contains the xls files you wish to process When you click OK each xls file will be opened and any raw data contained in it added to this worksheet X lalale IMIZ Summary of Results Z Ouestion by Ouestion
32. e in deciding what do at work lt 3 gt 3 amp lt 4 gt 4 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 4 amp lt 4 95 gt 4 95 Approx Managers Support 8 I am given supportive feedback on the work do lt 2 gt 2 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 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 go 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 ngo percentile range colleagues 31 My SoICaaIEE are willing to listen to my work lt 4 gt 4 amp lt 4
33. egory B Category C Category D Category E Category F Category G Category H Category Category J Category K Category L Question 1 Question 2 Question 3 Question 4 Question 5 Question 6 Question 7 Question 8 Question 9 Question 10 Question 11 Question 12 Question 13 Question 14 Question 15 Question 16 Question 17 Question 18 Question 19 Question 20 Question 21 Question 22 Question 23 Question 24 Question 25 Question 26 Question 27 Question 28 Question 29 Question 30 Question 31 Question 32 Question 33 Question 34 Question 35 Each subsequent row is ordered as follows lt ord gt lt cat 1 gt lt cat 2 gt lt cat n gt lt resp 1 gt lt resp 2 gt lt resp m gt where ord is simply a counter usually starting with 1 cat is an integer that refers to an option in a set for a given category resp is an integer equivalent to a response number for an Indicator Tool question For versions of the HSE Management Standards Analysis Tool up to and including 1 3 n the number of categories is 4 For later versions nis currently 12 m the number of questions is 35 28 EXAMPLE There follows an example of a typical category set up completed questionnaire and resulting CSV row The survey coordinator requires the ability to filter data according to participants location and pay grade A participant can optionally not specify their location but must specify their pay grade In the HSE Management Standards Analysis Tool ca
34. f a categories configuraton file is available you can use this to restore the category titles once the import has been carried out See the HSE MS Analysis Tool User Manual for further information For best results and fastest processing collect all the source files you wish to process in lone folder Put the target this file in a separate folder and ensure all other workbooks are closed before proceeding Warning Depending upon how many xls files are being processed importing raw data may be a lengthy operation Import Ilale ll Summary of Results Z Question by Question Totals Z Raw Data Options Ia IT Figure 17 Options worksheet Import Raw Data from Excel 13 IMPORTING DATA FROM OLDER VERSIONS OF THE HSE MANAGEMENT STANDARDS ANALYSIS TOOL You may use the Import Raw Data from Excel facility on the Options worksheet to import data from versions of the analysis tool prior to version 1 4 To do this you must go to the Categories worksheet and alter the title of Category A to Category A Category B to Category B etc see Figure 18 below Then follow the same procedures described in the section above to import raw data Once the import has been carried out you 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 this to restore the category titles once
35. for use with a laptop computer This facility requires Excel 2000 or later Input Extract Selected Category If you ve applied a filter to select rows whose category s you re interested in press the Extract button to remove the other rows Caution The process is irreversible You should save the original spreadsheet first under a different file name or you may lose data Extract Mid blpill Somaya Resuts GuestionbeGuestion 2 Totals J Rew fests Lotions vit Figure 23 Options worksheet Alternative method of data entry for entering numerical data 17 Click on the button and follow the detailed on screen instructions for entering questionnaire data see Figure 24 below Questionnaire Data Input 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 configured typical input For categories would be Cats 2 9 3 Input for Q1 35 is Formatted similarly except there will always be 35 numbers separated using characters Enter a category option using its position in the list For example if 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 4 zero always converts to hone even if lt None gt is not present in a category If the Convert option is checked numerical input for question responses is
36. get 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 It enables you to see 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 1 Health and Safety Executive 2004 Psychosocial Working Conditions in Great Britain in 2004 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 20 discussions within focus groups but should not be interpreted as a definitive assessment of your performance IMPORTANCE OF CONFIRMING RESULTS WITH YOUR EMPLOYEES As suggested 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 for examp
37. he identifier Untitled with the title of the category e g Locetion Role A category entitled Untitled or whose title is left blank is not considered configured by the Analysis Tool Londe Use the special identifier lt None gt to avoid forcing the user to specify a given category lt None gt must be the first item in a category list Edinb Note if you are using the HSE MS Analysis Tool in conjunction with MS Online the online version of the HSE Indicator Tool please configure categories by importing the configuration from MS Online See the MS Online Admin page and the Options worksheet for more information Category A Category C Location None gt Cardiff Edinburgh London 41 gt MN Before You Start Cateaories Enter Questionnaire Scores Summary of Results Ouestion by 4 Figure 2 HSE Management Standards Analysis Tool Categories screen Please note that a category entitled Untitled or whose 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 category list simply type them in as you wish them to appear e g Cardiff Edinburgh The special identifier lt None gt must appear as the first item in a category list and must appear exactly as it appears in Figure 2 i e as lt None gt not as lt none gt or None This allows the user to record instances when respondents to the questi
38. hows 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 indicate that a very large proportion of the people responding to the national survey scored 5 on the questions relating to Role e One consequence of this is that an organisation may achieve what appears to be a fairly 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 e As noted in Annex A it is important to confirm your organisation s survey results with your employees This is particularly strongly recommended for results for the Role stress factor where the national survey results are so heavily skewed 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
39. ided 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 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 Tar
40. k long hours 0 56 140 38 0 0 192 0 0 23 9 59 8 16 2 0 0 00 20 Ihave to work very fast 0 18 0 84 38 Ki 3 56 0 0 1 0 0 35 9 u3 45 22 Ihave unrealistic time pressures o 0 0 4 106 4 357 0 0 0 0 0 0 48 7 45 3 60 9 132 304 496 598 342 338 0 0 7A 16 2 26 5 31 9 18 3 Control Question Response Counts Avg Non x Response Counts excluding non responder 1D Test Os Is 2s 3s 4s 5s respondents 1 2 3 4 5 2 Iean decide when to take a break 0 0 36 16 56 126 416 0 0 0 0 54 68 23 9 53 8 10 Ihave a sayin my own work speed 18 1 0 30 70 102 A WW 65 0 0 8 9 324 472 5 Ihave a choice in deciding how to do my work 0 18 30 kad 168 4 347 0 0 7 28 6 0 ne WwW 9 Ihave a choice in deciding what do at work 16 0 18 4 ne 70 4 09 68 0 0 83 64 53 2 321 25 Ihave some say over the way work 0 0 32 100 88 4 04 0 0 0 0 37 6 0 427 37 6 30 My working time can be flexible 0 18 0 0 62 154 443 0 0 77 0 0 0 0 265 65 8 Kad 50 ne 88 572 544 405 24 3 6 84 6 5 418 39 7 Managers Support Question Response Counts Avg Non z Response Counts excluding non responder iD Test Os Is 2s 3s 4s 5s respondents 1 2 3 4 5 8 Lam given supportive feedback on the work I do o 16 70 130 o 18 272 0 0 68 29 9 55 6 00 Tw 23 Lean rely on my line manager to help me out with a work problem a 0 4 60 98 18 on 6 0 0 0 20 0 273 445 82 29 Lean talk to my line manager about something that has upset or annoyed me at work o o Ka 60 140 0 345 0 0 0 0 45 25 6 59 8 0 0 RB 1am supported through emotionally demanding work 0 0 38
41. le in focus groups to assess whether the results highlight a potential problem area for your organisation 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 APPLYING THE CATEGORY FILTER TO RESULTS FOR SMALL NUMBERS OF EMPLOYEES If you use the Category Filter facility and there are fewer than 10 people in the group you have selected the Category Filter facility will return the message The filter returned too few results to analyse Your filter selection has been cancelled To protect the anonymity of respondents when reporting results the filter does not allow for analysis of results for fewer than 10 participants However it is possible to access such information using the Raw Data worksheet of the HSE Management Standards Analysis Tool It is recommended that survey coordinators within organisations exercise discretion in providing wider access to the Raw Data worksheet Appendix B describes the technical information and procedures used in the calculation of current performance and targets 21 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 s
42. nagement Standards Analysis Tool from older copies of the HSE Analysis Tool or from previously saved Results CSV files downloaded from MSQOnline the online version of the HSE Management Standards Indicator Tool IMPORTING DATA FROM OTHER VERSIONS OF THE HSE MANAGEMENT STANDARDS 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 Options worksheet and find the Import button under the heading Import Raw Data from Excel see Figure 17 below Click on the button and select the folder that contains the xls 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 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 S Eile Edit view Insert Format Tools Data Window Help je next twelve fields are Integers that index into the categories columns found on the This facilty requires Excel 2000 or later Categories worksheet NB If a category set contains lt None gt as the first option an index lof 1 selects the se
43. national survey Please see Appendix A for more details Please note in particular the caveats concerning use and interpretation of results for individual questions Eile Edit View Insert Format Tools Data Window Help 18 x The results are grouped by stressor and the average score is shown for each question associated with that stressor Qu Relationships Tin T Compared uith results fram aroprorentative natianalrurvey af emplayees ree instructions far uring the HSE MS Analysis Tool far mare information and far caveats reqarding inter l4 14l il Cateaories Z Enter Questionnaire Scores Z Summary of Results Question by Question Totals 4 4 Figure 8 Question by Question worksheet results for individual questions For Question 21 the worksheet highlights in red the number of staff plus the percentage this respresents of respondents to the question who reported that they were always often or sometimes bullied 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 re
44. numbers of respondents selecting each of the response categories e Response Counts the percentage of respondents excluding non respondents selecting each of the response categories see Figure 21 below G Eile Edt view Insert Format Tools Data Window Help 18 x All Factors Question Response Counts Avg ZNon _ Response Counts excluding non responder Question No Text Os is 2s 3s 4s 5s respondents 1 2 3 4 5 1 lam clear what is expected of me at work 4 24 0 38 56 n 4 01 i 10 4 00 16 5 243 487 4 ide when to take a k 0 0 3 1 56 126 4 16 00 00 64 68 23 9 538 3 1d things from me that are hard to combine 0 24 L 4 136 56 379 00 10 3 60 17 58 1 239 4 b done 0 0 48 o 60 126 4 13 00 00 205 00 25 6 538 5 ment in the Form of unkind words or behaviour 0 18 0 4 n 88 4 03 00 7 00 60 487 376 6 0 o 38 ne o 20 275 00 00 ng 496 00 85 a 0 28 22 16 0 168 410 00 12 0 34 68 00 ne 8 0 6 m w o e m 00 6s 299 s6 o 17 3 0 18 34 70 98 4 3 24 00 77 45 29 9 3 6 0 10 8 4 0 30 70 102 4i 77 65 00 13 9 324 472 lam clear what my duties and responsibilities are J 4 16 32 56 128 421 00 WwW 68 137 23 9 538 2 Ihave to neglect some tasks because have too
45. on London Role Admin Sez Male n 168 71 8 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 percer 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 5 00 4 50 4 00 3 50 4 3 00 2 50 2 00 150 1 Your Results m Suggested InterimTarget O Suggested Longer Term Target 100 Compared with results from a representative national survey of employees see the HSE MS Analysis Tool User Manual for mare information and for caveats regarding interpretation of results lalale PiN Before You Start Z Cateaories Z Enter Questionnaire Scores Summary of Results Question by 4 Figure 10 Summary of Results for group selected 8 E Bile Edit view Insert Format Tools Data Window Help The results are grouped by stressor and the average score is shown for each question associated with that stressor Question Relationships ie Average s its demand things from combine am ake Overal 20 Ihave to work very fast Role 22 Ihave unrealistic time pressures Overall Overal m Change t h eral tive feedback on the jer to help me G jer about 450
46. onnaire 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 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 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 7 below from the tabs at the bottom of the screen 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 conditions in Britain Please see Appendix A for more details and note in particular the caveats on interpretation of results and the strong recommendation on the importance of confirming results with your employees File Edit view Insert Format Tools Data Window
47. onnaire may have failed to provide a selection for a particular category If you are using the HSE Management Standards Analysis Tool in conjunction with MSQOnline the online version of the HSE Management Standards Indicator Tool please configure categories by importing the configuration from MSQOnline Please see the MSQOnline Admin page and the Analysis Tool Options worksheet for more information The content of the Options worksheet is described in more detail in later sections of the Management Standards Analysis Tool User Manual ENTERING YOUR QUESTIONNAIRE SCORES Select the Enter Questionnaire Scores worksheet from the tabs at the bottom of the screen The first page of the HSE Management Standards Indicator Tool Scores Entry input form is shown in Figure 3 below HSE Indic ator Tool Scores Entry xj The coordinator of the risk assessment may have specified that the organisation be categorised bo provide moaning ul information e g by location role Or department D the organisation has been divided into groups for thes purpose please uve the drop down ists below to indicate the groupis to which the questionnaire reaks you are entering belong as advised by the coordinator Click here to continue with the rest of this questionnaire gt gt Select Questions Deion ocerd cx ix or seas saan aras nonnerne es Figure 3 Scores Entry input form categories drop down menus If the questionnaire results
48. ool and wish to import a category configuration using this facility rather than using the Download facility described above please ensure that you have downloaded the configuration file from MSQOnline see MSQOnline Admin page for more information Go to the Options worksheet and find the Import button under the heading Import Category Configuration see Figure 15 below le at yew post Format Too Date Window Heb ale x Import Category Configuration Press the button below to import from a categories configuration file downloaded from the online Management Standards questionnaire Import Input Numerical Data The following facility provides for more rapid data entry It requires that responses on the paper questionnaires that you are processing be labelled with numbers 1 to 5 The method of data input is most efficient when used in conjunction with a numeric key pad and is therefore not suited for use with a laptop computer This facility requires Excel 2000 or later Input Extract Selected Category Figure 15 Options worksheet Importing Category Configuration Click on the button and select from the desktop the category configuration file that you wish to import see Figure 16 below Select Category Config File kd xj Jen QX CE Th Figure 16 Selecting a category configuration file from the desktop 12 IMPORTING DATA You can import and collate raw data from other copies of the HSE Ma
49. r 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 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 26 Table 4 Question by Question Worksheet Rules Governing Colour Coding Cut offs for Each Question
50. rvey data to be added to any existing ers that index into the categories columns found an the data Uncheck this option if you would like any existing to be cleared before downloading category set contains lt one gt as the first option an index takes place jor a category 2 selects the third and so on Press the Download button to begin You will be notified when the process is complete jerred as is to this worksheet ie they are assumed to be URL http imyintranetimsqonline to set the ASCII character code of the delimiter used in the HSE Indicator Tool uses the delimiter 44 comma The Configure categories V commonly used codes Append data m Download Import Technical Hotes This facility requires Excel 2000 or later An error may occur when using this facilty if Microsoft Internet Explorer version 5 5 or earlier is installed on your machine If this is the case the missing system components required for this facility can be installed by downloading and installing Microsoft XML Core Services MSXML For more information contact your system administrator or visit http msdn micrasoft com XML XMLDownlloads detault aspx If you are using any version of Microsoft Internet Explorer you may need to clear the temporary Internet files from your machine before using this facility In Internet Explorer select the Tools internet Options menu then on the General tab click the Delete Files button lalale P
51. s 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 Your organisation may have been categorised into different groups of employees e g by location role or Department 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 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 Please note that if you wish to use the Categories facility you must do this before entering any results Select the Categories worksheet from the tabs at the bottom of the screen see Figure 2 below Beginning with Category A replace the identifier Untitled with the title of the category In the example in Figure 2 below the coordinator or person setting up the categories has chosen to enter results using the categories of Location Role Sex and Age Eie Edt view Insert Format Tools Data Window Help Categories If the organisation has been categorised to provide meaningful information e g by location role or department list the categories in the table below Listing categories here will make them available when completing the questionnaire see next worksheet Replace t
52. sults 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 9 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 You can now select the Summary of Results or the Question by Question worksheets to examine the results for the group you have selected Eie Edt view Insert Format Tools Data window Help Figure 9 Raw Data worksheet B D E F G F Category A Category C Category D x Questioni Male 2 London Top 10 Female 51 60 2 1 Custom Male 2 3 Edinburgh 31 40 5 2 Edinburgh Female 5 5 London Male 41 50 4 2 Edinburgh Male 51 60 3 5 21 30 2 2 Edinburgh Male 41 50 5 5 10 Carcitt Admin 3 4 1 Consultant Female 31 40 2 3 12 London Male 4 4 13 Cardiff Admin 21 30 3 5 14 Carditt Management Female 51 60 2 4 15 London Technical 2 3 16 Admin Female 41 50 3 4 7 London Male 21 30 3 5 18 Technical Male 31 40 4 3 19 London Management Female 41 50 4 2 20 London Technical Female 5 4 a Management Male 5 4 2 London Technical Female 21 30 4 5 23 London Management Male 51 60 3 5 24 Edinburgh 41 50 3 4 25 Cardiff Management Male 41 50 4 1 26 Cardiff Consultant Female 41 50 5 4 x 51 6
53. tegories would be set up like this Category A Category B lt None gt Band 1 London Band 2 Cardiff Band 3 Belfast Edinburgh A participant completes the questionnaire online using the following responses Belfast Band 1 Never Seldom Sometimes Often Always Never Seldom Sometimes Often Always Never Seldom Sometimes Often Always Never Seldom Sometimes Often Always Never Seldom Sometimes Often Always Never Seldom Sometimes Agree Strongly agree Strongly disagree Disagree Neutral Agree 29 Strongly agree Strongly disagree Disagree Neutral Agree Strongly agree If using version 1 4 or later of the HSE Management Standards Analysis Tool the CSV row will be this 1 13 1 0 0 0 0 0 0 0 0 0 0 1 2 3 4 1 5 2 3 2 5 1 4 3 2 5 5 2 3 4 1 5 4 3 4 5 1 2 3 4 5 1 2 3 2 5 The first digit 1 is the ordinal and could be any positive number in a sequence The next 12 digits 3 1 0 0 0 0 0 0 0 0 0 0 are indices into the survey coordinators category configuration So 3 is the third item in the location category A 1 is the first item in the pay grade category B Note that the option lt None gt is always identified with zero 0 as is an unused category The final 35 digits are question response numbers Refer to the HSE Indicator Tool to view how these numbers equate to actual responses the HSE Indicator Tool is available as a download at http www hse gov uk stress standards downloads
54. tent of these worksheets in more detail Please do not change the names of any of the worksheets as this will affect the operation of the Analysis Tool fie Edit view Insert Format Tools Data window Help 181 x E b HSE Management Standards Analysis Tool Before you start We recommend that you refer to the full instructions in the HSE Management Standards MS Analysis Tool User Manual before you start using the HSE MS Analysis Tool Important To make the HSE MS 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 macros If you clicked the Enable Macros button you may proceed If you clicked Disable Macros close Excel and reopen the HSE MS Analysis Tool selecting the Enable Macros button Ifthe Enter Questionnaire Scores worksheet is empty you should verify that your security settings will allow macros to be run To do this 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 HSE MS Analysis Tool You should close and reopen Excel if it is already open We recommend that you restore the original setting as soon as you have finished using the application Brief instructions We suggest that you print these instructions before using the HSE MS Analysis Tool
55. ully HSE Indic ator Tool Scores Entry 4 xj Question 29 Size AAIE D Wile Raa ag C Strongly Deagee C Desyee C Netra Agee Strongly Agee C No Arner konala Question W working tine can be Hebe id i C Srongy Disagree C Otsagree Neutral C Agee C Strongly Agree C No Arswer Question 31 Colleaques are willing to kiten va Spe anrika ee Stroy Deagee Oitegree Neutral C Agee Strongly Agree C No Answer Question 32 When changes are made at work 1 am daar how they wal work out C Strongly Deagee C Desyee C Neutral C Agee C Strongly Agee No Arner prectee Question 33 1 am supported through x E Piahana ea C Sromgy Osage C Osegee C Neutral Agee Strongly Agree C No Answer Question 34 Relationships at work arad z masa C Strongly Deagree Ousyee Neutral C Agee Strongly Agree C No Arewer My tem manag encourages me at a Kar work Strongy Daagee C Dusyee C Neutral gree C Strongly Agee C No fenwer lt Select Questions Delete Lat Record Cat 1 7 ei4 16 21 az New Record Number Jess Save New Record Figure 6 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 questi
56. ve 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 Approx 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 Approx they will work out in practice 27 APPENDIX C CSV FORMAT REQUIREMENTS FOR USERS WISHING TO EXPORT DATA FROM OTHER SOFTWARE APPLICATIONS IN A FORMAT SUITABLE FOR IMPORT INTO THE HSE MANAGEMENT STANDARDS ANALYSIS TOOL INTRODUCTION This is a note for users of online data gathering software that has been used to emulate the HSE Management Standards Indicator Tool questionnaire Where there is a requirement to process and analyse questionnaire data using the HSE Management Standards Analysis Tool users of the software will be required to export data from their application in a format suitable for import into the HSE Management Standards Analysis Tool As the tool takes the form of a Microsoft Excel spreadsheet the most suitable export format is CSV The HSE Management Standards Analysis Tool includes a facility for importing and processing CSV data The processing includes validation of inputs and conversion of category indices FORMAT The facility expects one or more rows in the CSV file The first row which is ignored typically looks like this Record No Category A Cat
Download Pdf Manuals
Related Search