Community RiskBase User's Guide
Contents
1. CAN YOU RISK IT Community RiskBase Users Guide Introduction It is important to have the right tools for the job So to help you to record and report on the risks associated with your day to day activities RiskCover has developed Community RiskBase This resource is also available to download online from www icwa wa gov au It is a simple resource made even easier because we have based it around Microsoft Excel Most community groups that have access to computers for administration will be familiar with Microsoft Excel which means you may already have a head start on your risk management process Community RiskBase has been developed to complement the five step risk management process outlined in Can You Risk It An introduction to risk management 1 Establish the context 2 Identify risk 3 Assess Risks 4 Treat risks 5 Ongoing monitoring and review It also supports the Australian New Zealand Standard 4360 1999 Risk Management The database is made up of five options that include e A data entry form that allows you to enter your relevant data e A form to edit and update the Qualitative Consequence And Likelihood Risk Reference Tables and e Three reports Risks by Level of Risk Risks by Action Status and Risks by Activity Event RiskCover does not claim that Community RiskBase is a finished product nor does it accept any liability resulting from the use of the database It is on this b2. NOTE You must select the consequence category before you select the consequence rating Select from the drop down list Select a rating that reflects the severity of the risk event Select a rating that reflects the probability of this risk event happening This automatically calculates multiplying consequences and likelihood so your risks sit on a scale of 1 25 1 lowest 25 highest For risk levels determined as unacceptable what else can you do to reduce this level of risk Please enter a date by which the action needs to be completed in day month year dd mm yy format Select from the drop down list where you are up to with your action Select a rating now taking into account the Actions What can you do about it Select a rating now taking into account the Actions What can you do about it The revised ratings will automatically calculate the Revised Level of Risk and you will have to decide whether this level of risk is acceptable for this activity If not you should revisit What can you do about it and see what else you might look at doing to reduce the level of risk to an acceptable level If the level of risk remains unacceptable then you will have to decide whether you continue with the Activity or Event Please enter the name of the person who has identified and assessed the risk Please enter the date on which risk was identified entered in the database Once you have entered yo
3. Categories and Likelihood button and follow steps as described on pages 32 to 33 Throughout each step it is essential that there is consultation and communication with those within your organisation who are involved in its functions activities and events 7 1 Open Data Entry Form This button opens up the data entry form If you are entering your first record in this database all of the fields will be blank If you have previously entered records you will have to choose from the following five options Add a new record will give you a blank Risk Identification Form Save new record will save the new record that you have just entered previously entered record and amend the data contained within that record Delete a record will delete the current record that you are viewing Close Form will take you back to the Main Menu zeiz 2 fle Edt View Insert Format Tools Data window Help IDMS lal x D Sos ASR s B lo B gt BAQGga Prai zo e zu Fle 83 A 2 Community Riskbase Business Association Chub Group Activity or Event Risk hat can go wrong Rick Ret No Existing preventative measures Controis Consequence if Risk occurs Select area that it wil have most impact on pa eon a Poa Likethood Rating Pa BW Level of Risk Select from list Select from list Due Date dmm Select status What can you do about t Acti
4. _ Medical certificates waivers insurance make sure what is covered 1 Identified the risks associated with the e o specific activity or event e g Accident cag Consequence if Risk occurs to competitor member of public Select area that it will have most impact on Injuries Death z e o z 7 Consequence Rating Likelihood Rating Level of Risk 8 official leading to adverse publicity Gesa tom et Sean E Due Date Select status What can you do about it Actions ddmnvyy trom list 2 Identified what existing preventative A qualified fret aid person at event and a first aid plan 150503 1n progress E measures are currently in place e g Course closed to vehicles and liaise with Police regarding 15 05103 in progress medical certificates waivers insurance a Level of Risk after Actions Revised Likelihood Revised Level Revised Consequence 4 z Rating Select from 1 z of Risk 4 se Rating Select from list list 3 Identified the potential consequences Aiha Name l Sporting Club Date l 28 04 03 or impacts of this risk happening i e injuries deaths financial impacts etc 6 Serene cow S wows goes eet gos 4 The committee has discussed the potential consequences of the risk in terms of the consequence rating tables and agreed on the the potential consequences of this risk Consequence Rating 4 In addition the committee considers how likely this event is wit
5. asis that Community RiskBase is made freely available to community groups You are then able to develop the database as required to meet your specific requirements RiskCover does not offer any ongoing support or training in either Community RiskBase or Microsoft Excel 25 Using your Community RiskBase package Main Menu Please check the security setting in Microsoft Excel by following the procedure given below to ensure optimum performance of the Community RiskBase Click on Tools 2 Select Options 3 4 Select Macro Se Select Security in your Toolbar curity On completion of the above the following screen will be displayed 26 Type a question for hep ll a x dop C High Only signed macros from trusted sources will be allowed Chart to run Unsigned macros are disabled Medium You can choose whether or not to run potentially unsafe macros c j Ye not from Virus scanning software installed or you are sure all documents you open are safe No virus scanner installed i gt PiN Sheet1 Sheet Z Sheets lal me Ready NUM Pstart Kvovel deivered Appica GB Novell Groupwise Mai comBase O7Feb03 doc Imicrosoft Excel Boo PE 12 44PM SSSamec If your security is set at High then on opening Community RiskBase Excel database your system will automatically disable the macros and hen
6. ce you will not be able to use the database If your security is set at Medium then on opening Community RiskBase excel database will display a message box as shown below Click Enable Macros view Insert Format Tools Data Window Help ay Set Be Slo am l a 4 2 moe z d a Ka a W fe Y Reply with Changes End Review Jes z vl SSzels x 08 3 8 b i Le i Microsoft Excel E G Rmsg 4gencies SmallBusiness RiskBase ComRiskBase xls contains macros Macros may contain viruses It is always safe to disable macros but if the macros are legitimate you might lose some Functionality il Enable Macros More Info If your security is set at Low then on opening Community RiskBase Excel database the system opens the database automatically enabling all macros CAN YOU RISK IT An introduction to risk management Main Menu Screen The main menu screen will be displayed as shown below You will see that there are five main menu options m ES show Bes es e There is also an About button which contains all of the Conditions of Use for Community RiskBase You should read this information carefully Before you start to identify risk it is important to establish the context Step 1 in the Risk Management process To do this you must set the Risk Reference Tables by defining the Qualitative Measurement Criteria for Consequences and Likelihood Click on Edit Consequence
7. h that level of consequence Likelihood Rating 2 The multiplication of the two entries gives the risk a Level of Risk of 8 5 The committee has then looked at the risk and its level of risk and considered if there is anything else that can be done to reduce the consequences or likelihood of this risk They decided to have a A qualified first aid person at event and a first aid plan and b Course closed to vehicles and liaise with Police The Revised Level of Risk after adding these controls was then determined as 4 derived from a Revised Consequence Rating of 4 and a Revised Likelihood Rating of 1 Once a risk analysis has been completed for a number of activities events a report can be generated to show the risk issues associated with all of the activities events of this sporting club This report is sorted by Level of Risk to show the priority items the actions being taken and a Revised Level of Risk after the actions are implemented 34 CAN YOU RISK IT An introduction to risk management
8. her message box will be displayed asking you whether you wish to clear the form E Microsoft Excel Community RiskBase xls SE file Edt view Insert Format Tools Data Window Help Type a question for help EE Pe B IEMs Conseavence and iketinood Risk Reference Tables EG ta u ag T Arial gt eee Likelihood l B2 X Qualitative Measures of Consequence lmpact Consequence Category Level Rank Definition 1 Insignificant Less than 1 000 Minor 1 000 to 10 000 Moderate 10 000 to 50 000 Major 50 000 to 150 000 Catastrophic More than 150 000 M 4 gt bil Sheet3 Sheet Sheet2 Id Ready CAPS NUM Mstart R novel delivered Novel croupiise E ComBase 11Feb0 f microsoft Excel Microsoft visual PO m 32 CAN YOU RISK IT An introduction to risk management To change Likelihood Frequency Select the Likelihood Tab if you wish to make changes to this category This will display the sample qualitative measurement criteria set for Likelihood Description and Frequency You may modify the Likelihood measurement criteria the probability frequency to meet your group s measurement criteria Once you have made your modifications please click on the Save button When you click on the Save button a message box will ask you to click OK if you wish to save the changes If you click no another message box will be displayed asking you whether you wish to clear the form R Microsoft E
9. nt facilities Facilities and 3 1 2 Inadequate Supervision 11 11 02 In progress Refresher 15 01 03 In equipment instruction and course progress management guidance on monitoring safe use 0 equipment Human 4 1 1 Non Monitoring 20 1 03 In progress Resources compliance to OSH Act Standards Budget 5 1 1 Grossly under Supervision 20 1 03 Completed over estimate and income and monitoring expenditure of Association Budget 1 1 2 Loss of akey Business 01 10 03 In progress Succession 15 01 03 Completed management adviser planning resource 30 CAN YOU RISK IT An introduction to risk management 4 Report Risks by Activity Event This button gives you the choice of viewing the report by all Activities Events or a specific Activity Event If you wish to view the report for a specific activity you must type in a specific activity event in the Activity Filter box and select Run Report If you run a report without typing in a specific activity event the whole report is sorted by Activity Event in alphabetical order E Microsoft Excel Community RiskBase xls G Ele Edit View Insert Format Tools Data Window Help OSR OY Sa s BA Slo o amp 4G FB A Ye Repy wit 4 B u eases Arial E1 v Ready Astart Rnovel delivered QH Novell GroupWise X Microsoft Excel E comBase 27Nov0 S End Re fe Communi
10. ons from list Level of Risk after Actions Revised Likeshood Revised Level Rating Select from O E Rating select trom 0 orris ist ist Name te Scrol Ta Addanew Savenew S508 Update Delete Dose Form record record w record record K 4 gt pi Sheet3 Sheeti Z Sheet 7 p eed NN r Ready start contacts document Erre Arenas fE microsoft en morovesoesa BO RAOD ha zsm 28 CAN YOU RISK IT An introduction to risk management Scroll records Update record will enable you to scroll through the database to find a Data Entry Form The Data Entry Form has the following fields that need to be filled Business association club group Activity Event Risk Reference number Risk Existing preventative measures Consequence if risk occurs Consequence rating Likelihood rating Level of Risk What can you do about it Actions Due Date Status of Action Revised Consequence Rating Revised Likelihood Rating Revised Level of Risk Name Date This is simply the name of your club or group A description of the particular activity or event you are undertaking Allocate each risk a unique identification number Describe what might prevent you from successfully completing the activity or event List what you currently do to prevent this risk Select consequence category from the drop down list
11. ries and Likelihood Tables button you have the choice of changing the Definitions of the Qualititative Measures of Consequences and Frequency of Likelihood Examples are displayed below R Microsoft Excel Community RiskBase xls ae Te Dena dmir xi i ta ta Arial z Qualitative Measures of Consequence lmpact ES Consequence Category x Level Rank Definition Insignificant 2 Minor Moderate 4 Major 5 Catastrophic Save Close Form M 4 gt MN Sheet3 Sheet Z Sheet2 Jal j D Ready CAPS NUM Astart R Novel detvered Novell Groupwise 2 comBase 11Feb0 R Microsoft excel P Mirosoft visual PO imaa To change Consequence Definition If you wish to change Consequence click on the Consequence Tab located at the top left hand corner of the form This will display the sample qualitative measurement criteria set for Consequence Category Please select a Consequence Category from the drop down list and you may change it to meet your group s measurement criteria For example we have selected Financial Impact in the Consequence Category box and modifications may be made in the Definition box as displayed below You may wish to change the values based on your Agency s budget Once you have made your modifications please click on the Save button When you click on the Save button a message box will ask you to click OK if you wish to save the changes If you click no anot
12. ty Riskbase RiskCover Community Riskbase Report Risks by Action Status Report Risks by Activity Event Be Type a que f p a ex ALZI ih 4 100 ee BEDA xi s or Events NUM PO 143m Report Sample Risks by Activity Event Activity Ref Risk Level of Risk Action 1 Revised Level of Name Date Risk Financial Non compliance 6 Business 20 12 02 13 2 03 with FAAA adviser Facilities and Inadequate Maintenance 15 12 02 15 1 03 equipment site security at program management facilities Facilities and 3 1 2 Inadequate 12 Supervision 11 11 02 Refresher 15 1 03 20 3 03 equipment instruction and course management guidance on safe monitoring use of equipment Human 4 1 1 Non compliance 9 Monitoring 20 1 03 19 1 03 Resources to OSH Act Standards Budget 5 1 1 Grossly under 12 Supervision 20 1 03 13 2 03 over estimate and income and monitoring expenditure of Association Budget 1 1 2 Loss of a key 12 Business 01 10 03 Succession 15 1 03 15 1 03 management adviser planning resource SISNAUUING faites sn ES a ee ee aonaain fl 5 Edit Consequence Categories and Likelihood Tables This is the first step in the risk management process that you need to complete before you start to identify risks When you click on Edit Consequence Catego
13. ur data click Save New Record 7J 2 Report Risks by Level of Risk When you click this button the risks are sorted with the highest risk at the top Risk Risk level Predicted Activity Event Ref What can go wrong of Risk Action 1 Action 2 Action 3 Level of No Risk Human Resources 1 1 2 Loss of a key management 12 Business adviser Succession 4 resource planning Facilities and 3 1 1 Inadequate site security at 12 aintenance 4 equipment facilities program management Facilities and 3 1 2 Inadequate instruction 12 Supervision and 6 equipment guidance on safe use of monitoring management equipment Budget 5 1 1 Grossly under over 12 Supervision and Refresher course 2 estimate income and monitoring expenditure of Association Health and Safety 4 1 1 Non compliance of OSH 9 onitoring 2 Act Standards Finance 2 1 1 Non compliance with FAAA 6 Business adviser 4 3 Report Risks by Action This button sorts the risks by status of action starting with the actions in progress followed by actions completed Due P Due Activity Risk Action 1 Date Status 1 Action 2 l DEUS Aea Date 1 ate 2 2 3 3 Financial 2 1 1 Non Business 20 12 02 In progress compliance adviser with FAAA Status 3 Facilities and 3 1 1 Inadequate Maintenance 15 12 02 In progress equipment site security at program manageme
14. xcel Database xls ae 18 T file Edt View Insert Format Tools Data Window Help Type a question for help MAE X a u om a l bas ate v Consequence and Likelihood Risk Reference Tables xi l ta ta a a G F arial Consequence Likelihood B2 X Qualitative Measures of Likelihood RiskCo Example Detail Level Descriptor Description feqsency 1 Insignificant The event may occur in exception Less than once in 15 years The event could occur at some tir At least once in 10 years Minor The event should occur at some ti At least once in 3 years Moderate The event will probably occur inm At least once a year Major Catastrophic The event is expected to occur in More than once per year eae Close Form O N w a Ready NUM start R novel delivered Novel Groupwise R Microsoft Excel S comBase 11Febo PFO sam 33 Case Study A sporting club undertakes a number of activities or events during the course of the year including e a Fun Run e aClubrooms upgrade e a visit to Country Week e a Raffle For each activity or event the committee x Y Business Association of the sports club has completed a risk ClubGroup Sporting Club Activity or Event amn gt O analysis refer example below regarding R yi Risk Accident to competitor member of public official a fun run activity where they have No Sener leading to adverse publicity Existing
Download Pdf Manuals
Related Search