{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Blank Template","Risk Summary Table","Scoring Matrix","Abbreviations","Financial Sustainability","Estates and Facilities","Student Recruitment ","Education (UG and PGT)","Research and PGR","Digital & Information Services","People","Health, Safety, Wellbeing & Res","International Partnerships","Reputation","External Environment","Environmental Sustainability","Leadership and Governance","AUSA and Other Third Parties"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":17,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Blank Template","index":0,"n_rows":27,"n_cols":20,"rows_kept":27,"cut":false,"hidden":true,"merged":[[2,8,2,10],[2,16,2,18],[0,3,0,5],[0,1,0,2]]}
[null,"Strategic Risk Area:"]
[]
[null,"No.","Risk  (what could happen)","Risk Owner","Risk Manager","Consequences (how would this affect the University)","Likelihood","Impact","Unmitigated Score\n(gross)",null,null,"Response","Mitigations (what is being/has been done to control the risk) ","Status (in place/in progress/under consideration)","Likelihood","Impact","Mitigated Score\n(net)",null,null,"Risk Movement"]
[null,null,null,null,null,null,null,null,"n",{"$f":"IF(K4<4,\"GREEN\",IF(AND(K4>3,K4<7),\"YELLOW\",IF(AND(K4>7,K4<10),\"AMBER\",IF(AND(K4>9,K4<17),\"RED\",\"ERROR\"))))","v":"GREEN"},{"$f":"G4*H4","v":0},null,null,null,null,null,"n",{"$f":"IF(S4<4,\"GREEN\",IF(AND(S4>3,S4<7),\"YELLOW\",IF(AND(S4>7,S4<10),\"AMBER\",IF(AND(S4>9,S4<17),\"RED\",\"ERROR\"))))","v":"GREEN"},{"$f":"O4*P4","v":0},"Up"]
[null,null,null,null,null,null,null,null,"n",{"$f":"IF(K5<4,\"GREEN\",IF(AND(K5>3,K5<7),\"YELLOW\",IF(AND(K5>7,K5<10),\"AMBER\",IF(AND(K5>9,K5<17),\"RED\",\"ERROR\"))))","v":"GREEN"},0,null,null,null,null,null,"n",{"$f":"IF(S5<4,\"GREEN\",IF(AND(S5>3,S5<7),\"YELLOW\",IF(AND(S5>7,S5<10),\"AMBER\",IF(AND(S5>9,S5<17),\"RED\",\"ERROR\"))))","v":"GREEN"},{"$f":"O5*P5","v":0},"Down"]
[null,null,null,null,null,null,null,null,"n",{"$f":"IF(K6<4,\"GREEN\",IF(AND(K6>3,K6<7),\"YELLOW\",IF(AND(K6>7,K6<10),\"AMBER\",IF(AND(K6>9,K6<17),\"RED\",\"ERROR\"))))","v":"GREEN"},0,null,null,null,null,null,"n",{"$f":"IF(S6<4,\"GREEN\",IF(AND(S6>3,S6<7),\"YELLOW\",IF(AND(S6>7,S6<10),\"AMBER\",IF(AND(S6>9,S6<17),\"RED\",\"ERROR\"))))","v":"GREEN"},0,"No Change"]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0,"New Risk"]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0,"Up"]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]

{"sheet":"Risk Summary Table","index":1,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,2,1,5],[1,1,2,1],[1,0,2,0],[0,0,0,6]]}
["University of Aberdeen: Strategic Risk Register (SRR)"]
[null,"Risk Areas","Count of Risks"]
[null,null,"Green","Yellow","Amber","Red","Total","% of Total"]
[{"$f":"ROW()-4","v":0},null,{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B4,31)&\"'!$S$4:$S$27\"),\"<4\",INDIRECT(\"'\"&LEFT($B4,31)&\"'!$S$4:$S$27\"),\">0\"),0)","v":0},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B4,31)&\"'!$S$4:$S$27\"),\"<7\",INDIRECT(\"'\"&LEFT($B4,31)&\"'!$S$4:$S$27\"),\">3\"),0)","v":0},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B4,31)&\"'!$S$4:$S$27\"),\"<10\",INDIRECT(\"'\"&LEFT($B4,31)&\"'!$S$4:$S$27\"),\">6\"),0)","v":0},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B4,31)&\"'!$S$4:$S$27\"),\"<17\",INDIRECT(\"'\"&LEFT($B4,31)&\"'!$S$4:$S$27\"),\">9\"),0)","v":0}]
[{"$f":"ROW()-4","v":1},{"$f":"LEFT('Financial Sustainability'!D1,31)","v":"Financial Sustainability"},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B5,31)&\"'!$S$4:$S$27\"),\"<4\",INDIRECT(\"'\"&LEFT($B5,31)&\"'!$S$4:$S$27\"),\">0\"),0)","v":0},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B5,31)&\"'!$S$4:$S$27\"),\"<7\",INDIRECT(\"'\"&LEFT($B5,31)&\"'!$S$4:$S$27\"),\">3\"),0)","v":9},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B5,31)&\"'!$S$4:$S$27\"),\"<10\",INDIRECT(\"'\"&LEFT($B5,31)&\"'!$S$4:$S$27\"),\">6\"),0)","v":6},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B5,31)&\"'!$S$4:$S$27\"),\"<17\",INDIRECT(\"'\"&LEFT($B5,31)&\"'!$S$4:$S$27\"),\">9\"),0)","v":0},{"$f":"SUM(C5:F5)","v":15},{"$f":"G5/G20","v":0.12396694214876033}]
[{"$f":"ROW()-4","v":2},{"$f":"LEFT('Estates and Facilities'!D1,31)","v":"Estates and Facilities"},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B6,31)&\"'!$S$4:$S$27\"),\"<4\",INDIRECT(\"'\"&LEFT($B6,31)&\"'!$S$4:$S$27\"),\">0\"),0)","v":0},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B6,31)&\"'!$S$4:$S$27\"),\"<7\",INDIRECT(\"'\"&LEFT($B6,31)&\"'!$S$4:$S$27\"),\">3\"),0)","v":1},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B6,31)&\"'!$S$4:$S$27\"),\"<10\",INDIRECT(\"'\"&LEFT($B6,31)&\"'!$S$4:$S$27\"),\">6\"),0)","v":5},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B6,31)&\"'!$S$4:$S$27\"),\"<17\",INDIRECT(\"'\"&LEFT($B6,31)&\"'!$S$4:$S$27\"),\">9\"),0)","v":2},8,{"$f":"G6/G20","v":6.6115702479338845E-2}]
[3,{"$f":"LEFT('Student Recruitment '!D1,31)","v":"Student Recruitment "},2,8,5,2,17,{"$f":"G7/G20","v":0.14049586776859505}]
[4,{"$f":"LEFT('Education (UG and PGT)'!D1,31)","v":"Education (UG and PGT)"},1,9,0,0,10,{"$f":"G8/G20","v":8.2644628099173556E-2}]
[5,{"$f":"LEFT('Research and PGR'!D1,31)","v":"Research and PGR"},0,9,0,0,9,{"$f":"G9/G20","v":7.43801652892562E-2}]
[6,{"$f":"LEFT('Digital & Information Services'!D1,31)","v":"Digital & Information Services"},1,6,3,1,11,{"$f":"G10/G20","v":9.0909090909090912E-2}]
[7,{"$f":"LEFT(People!D1,31)","v":"People"},1,6,0,0,7,{"$f":"G11/G20","v":5.7851239669421489E-2}]
[8,{"$f":"LEFT('Health, Safety, Wellbeing & Res'!D1,31)","v":"Health, Safety, Wellbeing & Res"},0,{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B12,31)&\"'!$S$4:$S$27\"),\"<7\",INDIRECT(\"'\"&LEFT($B12,31)&\"'!$S$4:$S$27\"),\">3\"),0)","v":5},0,0,5,{"$f":"G12/G20","v":4.1322314049586778E-2}]
[9,{"$f":"LEFT('International Partnerships'!D1,31)","v":"International Partnerships"},2,3,2,3,10,{"$f":"G13/G20","v":8.2644628099173556E-2}]
[10,{"$f":"LEFT(Reputation!D1,31)","v":"Reputation"},3,5,2,0,10,{"$f":"G14/G20","v":8.2644628099173556E-2}]
[11,{"$f":"LEFT('External Environment'!D1,31)","v":"External Environment"},0,2,1,1,4,{"$f":"G15/G20","v":3.3057851239669422E-2}]
[12,{"$f":"LEFT('Environmental Sustainability'!D1,31)","v":"Environmental Sustainability"},0,4,1,1,6,{"$f":"G16/G20","v":4.9586776859504134E-2}]
[13,{"$f":"LEFT('Leadership and Governance'!D1,31)","v":"Leadership and Governance"},0,3,2,0,5,{"$f":"G17/G20","v":4.1322314049586778E-2}]
[14,{"$f":"LEFT('AUSA and Other Third Parties'!D1,31)","v":"AUSA and Other Third Parties"},0,2,2,0,4,{"$f":"G18/G20","v":3.3057851239669422E-2}]
[]
[{"$f":"COUNTA(RiskTable[[#All],[Column1]])","v":14},"Total",{"$f":"SUM(C5:C18)","v":10},{"$f":"SUM(D5:D19)","v":72},{"$f":"SUM(E5:E19)","v":29},{"$f":"SUM(F5:F18)","v":10},{"$f":"SUM(C20:F20)","v":121}]
[null,"% of Total",{"$f":"C20/G20","v":8.2644628099173556E-2},{"$f":"D20/G20","v":0.5950413223140496},{"$f":"E20/G20","v":0.23966942148760331},{"$f":"F20/G20","v":8.2644628099173556E-2},{"$f":"SUM(C21:F21)","v":1}]

{"sheet":"Scoring Matrix","index":2,"n_rows":9,"n_cols":18,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,1,8,1],[3,3,3,6]]}
[]
[]
[]
[null,null,null,"Impact"]
[null,null,null,"Low (1)","Moderate (2)","High (3)","Critical (4)",null,null,null,null,null,null,null,null,null,null,"Avoid"]
[null,"Likelihood","Highly Likely (4)",4,8,12,16,null,null,null,null,null,null,null,null,null,null,"Treat"]
[null,null,"Likely (3)",3,6,9,12,null,null,null,null,null,null,null,null,null,null,"Tolerate"]
[null,null,"Feasible (2)",2,4,6,8,null,null,null,null,null,null,null,null,null,null,"Transfer"]
[null,null,"Unlikely (1)",1,2,3,4]

{"sheet":"Abbreviations","index":3,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Risk Owners and Managers: abbreviations"]
[]
["SVP","Senior Vice-Principal"]
["US & COO","University Secretary and Chief Operating Officer"]
["CFO","Chief Financial Officer"]
["DD ER","Deputy Director External Relations"]
["DoAS & OE","Director of Academic Services & Online Education"]
["DoDDIS","Director of Digital and Information Services"]
["DoDT & Alumni","Director of Development Trust & Alumni "]
["DoEF","Director of Estates and Facilities"]
["DoER","Director of External Relations"]
["DoPlanning","Director of Planning"]
["DoR&I","Director of Research & Innovation"]
["HoSD","Head of Sustainable Development"]
["VP E","Vice-Principal Education"]
["VP R ","Vice-Principal Research"]
["VP RR","Vice-Principal Regional Engagement"]
["VP GR","Vice-Principal Global Recruitment"]

{"sheet":"Financial Sustainability","index":4,"n_rows":18,"n_cols":20,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,8,2,10],[2,16,2,18],[0,3,0,5],[0,1,0,2]]}
[null,"Strategic Risk Area:",null,"Financial Sustainability"]
[]
[null,"No.","Risk  (what could happen)","Risk Owner","Risk Manager","Consequences (how would this affect the University)","Likelihood","Impact","Unmitigated Score\n(gross)",null,null,"Response","Mitigations (what is being/has been done to control the risk) ","Status (in place/in progress/under consideration)","Likelihood","Impact","Mitigated Score\n(net)",null,null,"Risk Movement"]
[null,1,"Failure to meet loan covenants and associated impact on going concern assurance.","SVP","CFO","The University would need to open discussions with loan providers, the SFC and USS if covenant tests were not met. In an extreme situation, lenders may require repayment of loans which would also trigger loan break penalty costs. It is not possible to estimate these costs as each lender / stakeholder will have different responses. ",3,4,"n",{"$f":"IF(K4<4,\"GREEN\",IF(AND(K4>3,K4<7),\"YELLOW\",IF(AND(K4>7,K4<10),\"AMBER\",IF(AND(K4>9,K4<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"G4*H4","v":12},"Treat","Lobbying Universities Scotland (US), UUK, USS\n\nThe USS members have recently accepted a short term settlement which has capped the Pension contributions by employers for the next three years, subject to the 2023 valuation, thereby reducing the largest recent risk in this area.\n\nFinance prepare modelling tests for compliance with covenants at least twice a year; If a breach was anticipated from such modelling, we would negotiate with lenders and other stakeholders (eg SFC and USS) to develop solutions. \nInvestment Committee manages asset allocation using fund management experts to achive a balanced risk profile.","In place \n\n\n\n\n                                                                                                                                                                                                                                                                                                                ",2,4,"n",{"$f":"IF(S4<4,\"GREEN\",IF(AND(S4>3,S4<7),\"YELLOW\",IF(AND(S4>7,S4<10),\"AMBER\",IF(AND(S4>9,S4<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"O4*P4","v":8},"Down"]
[null,2,"Surging inflation restricts our capacity to invest. ","CFO","CFO","Inflation erodes our purchasing power and more resource is consumed with operating the estate (including energy, construction and repair materials). Market pressure pushes up recruitment and staff costs. ",4,4,"n","RED",16,"Treat","Tuition fees were increased at an early stage as inflation appeared to be increasing. National pay bargaining arrived at an affordable increase as inflation projections were rising. The three eyar plan includes apprpriate inflation adjustments on sources of income and on expenditure. ","In place.",2,3,"n","YELLOW",6,"Down"]
[null,3,"Geopolitical disruptions could cut off student income from one or more markets with little warning. ","CFO","CFO","Outstanding income could be at risk of non payment (eg as happened with fees due from a government sponsoring agency in Ghana) or students are prevented from attending",2,4,"n","AMBER",8,"Treat","the student recruitment team are careful to ensure that we have diversity across countries for overseas recruitment. ","In place.",2,3,"n","YELLOW",6,"Down"]
[null,4,"Pension Schemes (USS being the largest exposure) experience significant deficits and annual cost of provison rises .","SVP","CFO","Future pension payment unaffordable with impact on ability to invest. \n\n",4,4,"n","RED",16,"Treat","3 year and 10 year plans prepared with cash flow forecasts and risk analysis\n\nMonthly monitoring of actual Income and Expenditure vs budget with quick identification of any variances\n\nSetting aside contingency in budgets\n\nUASLAS latest valuation and the USS 2020 valutaions have been concluded at an acceptable cost to the University.","In place",2,4,"n","AMBER",8,"Down"]
[null,5,"The pandemic continues or new variants cause further disruption to Education & Research resulting in the depletion of cash reserves","SVP","CFO","Inability to:\n\nMeet payroll commitments, pay suppliers, deliver teaching, complete research and invest  in the 2040 commitments",2,3,"n","YELLOW",6,"Treat","3 year and 10 year plans prepared with cash flow forecasts and risk analysis\n\nMonthly monitoring of actual Income and Expenditure vs budget with quick identification of any variances\n\nIn extremis, sale of assets, severance or additional borrowing can be carried out\n\nHolding cash reserves which are a buffer against system shocks","In Place. \n\nThe annual plan update will recommmend the appropriate levels of cash reserves to Court. \n",2,2,"n","YELLOW",4,"Down"]
[null,6,"Land sales (Rowett) unsuccessful or value reduced and asset sales fail to raise planned capital receipts. ","SVP","CFO","Financial impact\n\nFuture capital projects delayed\n\nCash flow worsens",2,4,"n","AMBER",8,"Treat","Reduced investment  in strategic priorities\n\nEstates Committee reviewing progression of UOA land sales and monitoring developments in the construction industry.\n\nAlternative asset sales identified","In Place",2,3,"n","YELLOW",6,"Down"]
[null,7,"Brexit leads to loss of funding streams and research income\n","SVP","R&I","Ability to meet minimum target to break-even and associated impact on investment",2,3,"n","YELLOW",6,"Treat","EU fee structure agreed with scholarships in place\n\nLiaison with all areas of UoA re supply chain\n\nResearch strategy to access Horizon funding","In place\n\nIn place\n\nIn place",2,2,"n","YELLOW",4,"Down"]
[null,8,"SFC funding declines in the medium to long term due to economic pressures ","SVP","CFO","Financial impact",4,3,"n","RED",12,"Treat","Plan to reduce dependence on SFC funding streams through diversification to overseas student markets . Three year plan reviews demonstrate gradual reduction in SFC Income as share of total income. ","In place.  \n",4,2,"n","AMBER",8,"No Change"]
[null,9,"Failure to generate sufficient surpluses to fund strategic ambition (Inability to fund the 2040 plan & commitments).","SVP","CFO","Strategic plan implementation  is delayed or downgraded.\n\nReputational damage & associated implications for education & research",3,3,"n","AMBER",9,"Treat","Improve transparency in the planning process. Increase challenge to budget holders to increase net income and reduce or redeploy cost to increase its positive impact. ","In progress",3,3,"n","AMBER",9,"Up"]
[null,10,"Sustained loss of research income above sector average","SVP","VPR","Reduction in REG (b) and (c) ",3,3,"n","AMBER",9,"Treat","Greater focus on how Schools can increase Research Income with Directorate support. Increase transparency in regular performance monitoring of leading indicators for research success. ","In progress\n\n\n\n",2,3,"n","YELLOW",6,"No Change"]
[null,11,"Tuition fee income drops below  plans over a sustained period, particularly international students at PGT level","SVP","CFO","Sustained loss of revenue\n\nLoss of new entrant tuition fee income\n\nImpact on School strategies and financial position\n\nLoss of income for existing students not returning",3,3,"n","AMBER",9,"Treat","See risk 3.2 under Student Recruitment","See risk 3.2 under Student Recruitment",2,3,"n","YELLOW",6,"No Change"]
[null,12,"Business-critical projects not delivered which are required for revenue growth (planned projects or existing project milestones not met e.g. Business School, King’s College) ","SVP","CFO","Financial impact\n\nReputational damage\n\nStudent and staff experience\n\nFuture student recruitment\n\nFuture staff recruitment",3,3,"n","AMBER",9,"Treat","Improved governance and project management is being put in place to manage strategic projects\n\nBusiness plan, timeline and risk register prepared for each project","In progress \n\n\n\nIn progress",2,3,"n","YELLOW",6,"No Change"]
[null,13,"Supply chain impacted for critical goods and financial stability of suppliers reduces","SVP","CFO","Inability to carry out research or key operational activities\n\nPotential for capital works to be significantly impacted by lack of availability of key building materials.  This could impact programme and cost",3,3,"n",{"$f":"IF(K16<4,\"GREEN\",IF(AND(K16>3,K16<7),\"YELLOW\",IF(AND(K16>7,K16<10),\"AMBER\",IF(AND(K16>9,K16<17),\"RED\",\"ERROR\"))))","v":"AMBER"},9,"Treat","APUC reviewing supply chain identification of key framework suppliers\n\nAdditional credit checks on suppliers\n\nImporting and exporting guidelines issued to community following Brexit\n\nIdentify contingencies for critical supply chains e.g.  building materials\n\nProvide adequate contingencies in projects for time and cost overruns\n\nSelective use of building materials where supply chain is more stable\n\nConsideration of procurement methods that reduce the above risks","In progress\n\nIn progress\n\nComplete\n\nIn progress\n\nFor future Estates Committee \n\nProject Boards to consider\n\nProject Boards to consider",3,3,"n",{"$f":"IF(S16<4,\"GREEN\",IF(AND(S16>3,S16<7),\"YELLOW\",IF(AND(S16>7,S16<10),\"AMBER\",IF(AND(S16>9,S16<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"O16*P16","v":9},"No Change"]
[null,14,"Reduction in student halls and catering income longer term due to market forces and less physical presence on campus & resilience at Hillhead","SVP","US&COO/CFO","Financial Impact and inability to invest to modernise or refurbish properties\n\nReduction in campus footfall (e.g. due to homeworking).",3,3,"n",{"$f":"IF(K17<4,\"GREEN\",IF(AND(K17>3,K17<7),\"YELLOW\",IF(AND(K17>7,K17<10),\"AMBER\",IF(AND(K17>9,K17<17),\"RED\",\"ERROR\"))))","v":"AMBER"},9,"Treat","Adapting catering offering available on campus\n\nMarket driven pricing accommodation packages\n\nMarketing strategy\n\nReview long-term budgeting and income projections\n\nFurlough staff and restructuring/redeploying staff","In progress\n\nTo be implemented in 2022/23\n\n\nIn place\n\nIn progress",3,3,"n",{"$f":"IF(S17<4,\"GREEN\",IF(AND(S17>3,S17<7),\"YELLOW\",IF(AND(S17>7,S17<10),\"AMBER\",IF(AND(S17>9,S17<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"O17*P17","v":9},"No Change"]
[null,15,"Unable to deliver major fundraising campaign","SVP","DoDT & Alumni","Could have a signficant and adverse impact across a range of areas, including inability to deliver major capital projects, loss of financial support for research projects and for students. ",3,3,"n",{"$f":"IF(K18<4,\"GREEN\",IF(AND(K18>3,K18<7),\"YELLOW\",IF(AND(K18>7,K18<10),\"AMBER\",IF(AND(K18>9,K18<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"G18*H18","v":9},"Treat","Ensure fundraising projects and appeals are attractive to donors, develop a case for support\nEnsure staffing and resource meets the needs of delivering a comprehensive campaign\nExpansion of prospect pool and diversification of income streams (individuals, corporates, Trusts & foundations, regular giving, legacy)\nEnsure appropriate marketing and communications including digital and personalised communications\nEffective leadership and governance\nFunding of an ongoing programme of alumni engagement and fundraising activity ","In progress\n\n",2,2,"n",{"$f":"IF(S18<4,\"GREEN\",IF(AND(S18>3,S18<7),\"YELLOW\",IF(AND(S18>7,S18<10),\"AMBER\",IF(AND(S18>9,S18<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O18*P18","v":4},"No Change"]

{"sheet":"Estates and Facilities","index":5,"n_rows":19,"n_cols":20,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,5],[2,8,2,10],[2,16,2,18]]}
[null,"Strategic Risk Area:",null,"Estates and Facilities"]
[]
[null,"No.","Risk  (what could happen)","Risk Owner","Risk Manager","Consequences (how would this affect the University)","Likelihood","Impact","Unmitigated Score\n(gross)",null,null,"Response","Mitigations (what is being/has been done to control the risk) ","Status (in place/in progress/under consideration)","Likelihood","Impact","Mitigated Score\n(net)",null,null,"Risk Movement"]
[null,1,"Failure to adequately manage future Estate development including lack of key strategic frameworks e.g. Estate Strategy, Masterplan, and effective Space Management procedures.\n","SVP","DoEF","Estate unable to support institutional strategy (Aberdeen 2040).\n\nCapital project planning and development portfolio disrupted or fails to deliver on time, budget or quality.\n\nEstate poorly aligned to support onsite functions e.g. research, teaching, accommodation, greenspace, sport, events, community access.\n\nFocus on buildings rather than people and activities\n\nReputational impact \n\nProject governance processes not followed\n\nProject finance interrupted or lost",3,4,"n",{"$f":"IF(K4<4,\"GREEN\",IF(AND(K4>3,K4<7),\"YELLOW\",IF(AND(K4>7,K4<10),\"AMBER\",IF(AND(K4>9,K4<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"G4*H4","v":12},"Treat","Estates Committee oversight\n\nConsistent project management methodology and governance\n\nEffective Space Management processes\n\nEstate Strategy / Masterplan consultation and development\n\nRegular review of capital planning\n\nDesign Team structure adopted and applied consistently","In place\n\nIn place\n\n\nUnder consideration\n\nUnder consideration\n\n\nIn place\n\nIn place\n\n\n",3,4,"n",{"$f":"IF(S4<4,\"GREEN\",IF(AND(S4>3,S4<7),\"YELLOW\",IF(AND(S4>7,S4<10),\"AMBER\",IF(AND(S4>9,S4<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"O4*P4","v":12},"No Change"]
[null,2,"Multiple impacts of geopolitical unrest, Covid and Brexit continue to magnify problems within the supply chain (both cost and availability)\n","SVP","DoEF","Small and medium suppliers fail\n\nKey suppliers lost or staffing reduced\n\nExtensive re-tendering\n\nDelays in critical parts lead to equipment offline e.g. CPH engine\n\nLarge contractor failure\n\nContractors and supply chains disrupted and/or  significant price increases on key materials\n",3,4,"n",{"$f":"IF(K5<4,\"GREEN\",IF(AND(K5>3,K5<7),\"YELLOW\",IF(AND(K5>7,K5<10),\"AMBER\",IF(AND(K5>9,K5<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"G5*H5","v":12},"Treat","Government initiatives and mitigation\n\nMost operational suppliers are via APUC and as such are large/established entities\n\nRe-tendering would normally be by APUC\n\nCHP/ District main is a ‘risk’ but UoA can operate without it (at a cost). Contract in place for maintenance with some critical part help on campus and some held by maintenance company\n\nPayments are retrospective to works \n\nParent Company Guarantee \n\nHorizon scanning e.g. of construction trade\n\nNote: we are not in a position to mitigate or manage the geopolitical aspects of this risk.\n","Under consideration\n\nIn place\n\n\nIn place\n\nIn place\n\n\n\n\nIn place\n\nIn place\n\nIn place",3,4,"n",{"$f":"IF(S5<4,\"GREEN\",IF(AND(S5>3,S5<7),\"YELLOW\",IF(AND(S5>7,S5<10),\"AMBER\",IF(AND(S5>9,S5<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"O5*P5","v":12},"No Change"]
[null,3,"Failure to ensure appropriate Estate utilisation","SVP","DoEF","Assets are under-utilised\n\nSpace is poorly used\n\nImpact on delivery of services\n\nLack of suficient, accessible storage impacts service delivery and key activities e.g. exams, sport, engagement etc.\n\nUser satisfaction\n\nReputational\n\nConsequences of increased home working",3,4,"n","RED",12,"Treat","Effective Space Management processes\n\nIntroduction (and ongoing analysis of impacts) of Homeworking Policy\n\nEstate Strategy / Masterplan consultation and development\n\nSpace benchmarking data reviewed ","Under consideration\n\nIn progress\n\n\nUnder consideration\n\n\nIn progress",3,3,"n","AMBER",9,"No Change"]
[null,4,"Deterioration in material condition and/or functional obsolescence of the estate (including teaching, research and support functions)","SVP","DoEF","Inability to deliver core activity\n\nHealth & Safety risk\n\nReputational damage\n\nRepeated failures in key buildings\n\nSome buildings in poor state of repair and/or inoperable",3,4,"n","RED",12,"Treat","10-year cash flow plan\n\nEstates Committee management, with consideration given to research, teaching and support facilities\n\nRegular review of capital spend\n\nRegular review of maintenance spend and programme\n\nRegular review of relative performance against sector IRV metrics\n\nOngoing programme of refurbishment and upgrade works\n\nCondition surveys to be undertaken","In place\n\nIn place\n\n\n\nIn place\n\nIn place\n\n\nIn place\n\n\nIn progress\n\n\nIn progress",3,3,"n","AMBER",9,"No Change"]
[null,5,"Business continuity systems fail to identify potential risks to assets or to ensure appropriate operational resilience of assets, systems or utilities\n\nSee also Environmental Sustainability Risks","SVP","DoEF","Reputational impact\n\nSignificant cost implications (regardless of insurance position)\n\nDisruption to aspects of campus activity e.g. teaching, research professional support\n\nLoss of an asset / assets resulting in significant business continuity problems e.g. due to fire, flood\n\nLoss of key systems e.g. K2, door entry\n\nLoss of utilities \n\n",3,4,"n","RED",12,"Treat","Business continuity processes\n\nKey business continuity risks identified as part of Business Continuity Plan\n\nRegular maintenance and servicing of key mitigation systems e.g. fire suppression\n\nAppropriate insurance in place\n\nHealth & Safety practices e.g. lab safety measures\n\nDevelopment of appropriate investment programme for critical systems, assets & utilities\n\nMaintenance and development schedules for critical infrastructure e.g. CHP\n\nLong-term plans for replacement of key infrastructure e.g. CHP, District Heat Network\n\nProject Board to review campus heating options","In place\n\nIn progress\n\n\nIn place\n\n\nIn place\n\nIn place\n\n\nIn progress\n\n\nIn progress\n\n\nIn progress\n\n\nIn place",3,3,"n","AMBER",9,"No Change"]
[null,6,"Failure to manage energy consumption and carbon management including lack of structural investment required to drive down emissions baseline leads to uncontrolled energy costs.\n\nSee also Environmental Sustanability Risks","SVP / US & COO","DoEF","Inability to manage utilities budgets\n\nMultiplier effect of cost of carbon\n\nReputational damage\n\nReduces capacity for investment to drive down emissions and costs\n\nCOVID mitigations e.g. enhanced fresh-air cooling, exacerbate challenge\n\nGlobal energy price rises magnify other impacts\n\nEnergy security issues affected by ongoing war in Ukraine\n",4,3,"n","RED",12,"Treat","Carbon Management Plan\n\nNet-Zero Strategy\n\nEnergy efficiency embedded in projects\n\nConsideration of micro-renewables\n\nConsideration of networked solutions e.g. local heat network\n\nConsideration of alternative fuels\n\nControls measures including Monitoring & Targeting \n\nAdvance purchasing through sector procurement routes\n\nBudgetary impacts of volatile global energy markets being monitored\n\nProject Board reviewing campus heating options","In place\n\nIn progress\n\nIn progress\n\nIn progress\n\nIn progress\n\n\nIn progress\n\nIn place\n\n\nIn place\n\n\nIn place\n\n\nIn place",3,3,"n","AMBER",9,"No Change"]
[null,7,"Failure to achieve targeted income from commercial and residential activities\n\nSee also Financial Sustainability Risks","US & COO","DoEF","Financial impact\n\nRisk to subsidy of other business activity\n\nReduced student numbers impact on residential and catering income\n\nImpact on third party and other site support e.g. shop, bus service\n\nChanges in legislation governing student tenancies gives ability to leave at short notice and/or University offers rent rebates (both COVID related)\n\nRecovery delayed by ongoing Covid restrictions, with reduced footfall/income and limiting scope to mitigate impact\n\nLimited/reduced commercial activities undermining revenue generating opportunities ",3,4,"n","RED",12,"Treat","Scenarios have been prepared under which financial impacts are budgeted \n\nOperating costs reviewed\n\nWorking with other HE / FE providers to generate new accommodation business e.g. SRUC, NESCOL\n\nExtensive marketing activity and working with student recruitment to opimise offer e.g. virtual open days with student recruitment, incentives for students staying over summer etc\n\nRolling programme of accommodation upgrades\n\nExtensive on-site support for students compared to private sector\n\nPlan to recruit to a Business Development Exec post to generate new income\n\nWeekly monitoring of transaction levels and income against resource to deliver activity\n","In progress\n\n\nIn progress\n\nIn progress\n\n\n\nIn progress\n\n\n\n\nIn place\n\nIn place\n\n\nIn progress\n\n\nIn place",2,4,"n","AMBER",8,"No Change"]
[null,"TEMP","Impact of prolonged pandemic mitigation measures, notably ventilation / air purification on capacity to return to 'normal' teaching capacity.\n\nNote: inclusion of a stand alone 'pandemic' risk following discussion at Estates Committee in February 2022. Intended to reflect immediate concerns around ventilation and limitations this may place on a return to 'normal', as well as longer-term issues related to further pandemics or any resurgence of COVID-19.","SVP","DoEF","Concern that, despite societal relaxation of Covid-19 restrictions, ventilation requirements for universities may restrict capacity to extend in-person teaching\n\nShort-term impacts (prior to September 2022) but also risk of longer term impacts if ventilation requirements become more permanent\n\nCosts associated with installation of mechanical ventilation\n\nIncreased utilities costs associated with heating ventilated spaces\n\nImpact on student experience\n\nReputational damage\n\nPossible impact on Scottish FHE as RUK teaching returns to normal\n\nResourcing impact due to self-isolation for those who cannot work from home",3,3,"n","AMBER",9,"Treat","Campus Planning Group continues to meet and respond to discuss national guidance.\n\nInstitutional Health & Safety colleagues reviewing ventilation guidance.\n\nVentilation solutions being idetified and implemented.\n\n","In place\n\n\nIn place\n\n\nIn progress",2,2,"n","YELLOW",4,"New Risk"]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]

{"sheet":"Student Recruitment ","index":6,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,5],[2,8,2,10],[2,16,2,18]]}
[null,"Strategic Risk Area:",null,"Student Recruitment ",null,null,"(UG, PGT, PGR)"]
[]
[null,"No.","Risk  (what could happen)","Risk Owner","Risk Manager","Consequences (how would this affect the University)","Likelihood","Impact","Unmitigated Score\n(gross)",null,null,"Response","Mitigations (what is being/has been done to control the risk) ","Status (in place/in progress/under consideration)","Likelihood","Impact","Mitigated Score\n(net)",null,null,"Risk Movement"]
[null,1,"Staffing capacity does not keep pace with increased enquiry and application volumes and/or changing market expectations, leading to delays in applications processing and responses to prospective student enquiries","VP GR","DD ER","Applicant expectations not met resulting in a poor prospective student experience.\n\nLoss of new entrant international and home tuition fee income\n\nImpact on staff workload and resulting wellbeing",4,4,"n",{"$f":"IF(K4<4,\"GREEN\",IF(AND(K4>3,K4<7),\"YELLOW\",IF(AND(K4>7,K4<10),\"AMBER\",IF(AND(K4>9,K4<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"G4*H4","v":16},"Treat","Review staffing requirements to match applicant volumes\n\nAdmissions statistics regularly monitored to identify and address areas of lag and flex resources accordingly\n\nStaff from other areas drafted in to support Admissions function during peak pressure period\n\nEnquiry statistics monitored to identify and address areas of lag\n\nOther Directorate staff trained and moved into enquiry support as and when required during peak pressure periods\n\nContinuously seek for opportunities to enhance processes through continual monitoring of workload pressures and seeking feedback from staff for improvement\n\nImplement new admissions system to increase the efficiency of prcoessing and applicant experience\n\nExplore means of augmenting capacity using a thrid party provider(s)\n","In place\n\nIn place\n\n\nIn progress\n\n\nIn place\n\n\nIn place\n\n\nn place\n\n\nIn progress\n\n\nUnder consideration",3,4,"n",{"$f":"IF(S4<4,\"GREEN\",IF(AND(S4>3,S4<7),\"YELLOW\",IF(AND(S4>7,S4<10),\"AMBER\",IF(AND(S4>9,S4<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"O4*P4","v":12},"Up"]
[null,2," Postgraduate research student recruitment levels continue to be out of line with competitor benchmark group","VP GR","Dean for Postgraduate Research","Adverse impact on research capacity\n\nAdverse impact on the research culture and environment and resulting student experiences \n\nImpact on PGR metrics used to drive SFC research funding\n\nContinued loss of market share which is challenging to rebuild\n\nImpact on gross tuition fee income\n\n",4,4,"n",{"$f":"IF(K5<4,\"GREEN\",IF(AND(K5>3,K5<7),\"YELLOW\",IF(AND(K5>7,K5<10),\"AMBER\",IF(AND(K5>9,K5<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"G5*H5","v":16},null,"Establishment of sector benchmarks to inform intake targets and allow performance to be monitored.\n\nImplementation of enhancements to PGR selection and admissions processes. \n\nEnhancement of staff research profiles and promotion of specific research topics on web pages\n\nEnhancement to PGR marketing campaigns and applicant conversion activity. ","In place\n\n\nIn progress\n\n\nIn progress\n\n\nIn progress",3,4,"n",{"$f":"IF(S5<4,\"GREEN\",IF(AND(S5>3,S5<7),\"YELLOW\",IF(AND(S5>7,S5<10),\"AMBER\",IF(AND(S5>9,S5<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"O5*P5","v":12},"Up"]
[null,3,"UK Postgraduate taught recruitment levels continue to be out of line with competitor set. ","VP GR","Dean of Portfolio Development & Programme Engagement","Negative impact on fee income\n\nPotential adverse impact on the student experience of international students seeking a UK university experience\n\nLoss of contribution to economic regeneration and upskilling\n\nAdverse impact on the balance of UG to PG numbers in the population\n\nContinued loss of market share which is challenging to rebuild.\n\n\nPotential loss of throughput to PGR study in those disciplines where this is the recognised progression path.\n",4,3,"n",{"$f":"IF(K6<4,\"GREEN\",IF(AND(K6>3,K6<7),\"YELLOW\",IF(AND(K6>7,K6<10),\"AMBER\",IF(AND(K6>9,K6<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"G6*H6","v":12},"Treat","Establishment of sector benchmarks to inform intake targets and allow performance to be monitored.\n\nLaunch of a new UK PGT campaign informed by latest market insights.\n\n\nNew campaign to promote PGT study to existing undergraduates\n\nPromotion of scholarships targeted at UK PGT including alumni discount, and community discount","Under consideration\n\n\nIn progress\n\n\nIn place\n\n\nIn place",3,3,"n",{"$f":"IF(S6<4,\"GREEN\",IF(AND(S6>3,S6<7),\"YELLOW\",IF(AND(S6>7,S6<10),\"AMBER\",IF(AND(S6>9,S6<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"O6*P6","v":9},"No Change"]
[null,4,"Failure to meet growth targets for international PGT and international UG student numbers  \n","VP GR","Dean for International Stakeholder Engagement","Loss of tuition fee income and income shortfalls against budgets \n\nAdverse impact on the net fee income per student FTE\n\nReduced ability to sustain other areas of activity that do not recover their full cost.\n\nIn respect of PGT, adverse impact on the balance of UG to PG numbers in the population\n\n\nLoss of market share which is challenging to rebuild \n\nOver-reliance on a small number of key markets",3,4,"n",{"$f":"IF(K7<4,\"GREEN\",IF(AND(K7>3,K7<7),\"YELLOW\",IF(AND(K7>7,K7<10),\"AMBER\",IF(AND(K7>9,K7<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"G7*H7","v":12},"Treat","Use of market intelligence to drive awareness of market positional and applicant motivations. \n\nBrand review project, which will include messaging appropriate to each market in support of student recruitment.\n\n\nTargeted incentives and scholarships in response to the price-sensitivity of the individual market.  \n\nImplementation of plan to enhance conversion rates in key markets.\nEnsuring brand promotion fully optimises ranking credentials in rank-sensitive markets. \n\n\nTask and finish groups established to review strategic approaches for international recruitment and market diversification\n\nDevelopment of new programmes and employability focus to meet market demand \n\nContinue to deliver programme of in-person and virtual recruitment events for prospective students.  targeted at key audiences and attending recruitment fairs domestically and internationally to support lead generation and to nurture potential applicants\n\n\n\n","In place\n\n\nIn progress\n\n\n\nIn place\n\n\nIn place\n\n\n\n\nIn place\n\n\nIn progress\n\n\nIn place\n\n\n",3,3,"n",{"$f":"IF(S7<4,\"GREEN\",IF(AND(S7>3,S7<7),\"YELLOW\",IF(AND(S7>7,S7<10),\"AMBER\",IF(AND(S7>9,S7<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"O7*P7","v":9},"New Risk"]
[null,5,"Failure to meet growth targets for RUK UG student numbers  \n","VP GR","DD ER","Loss of tuition fee income and income shortfalls against budgets \n\nAdverse impact on the net fee income per student FTE\n\nReduced ability to sustain other areas of activity that do not recover their full cost.\n\nLoss of market share which is challenging to rebuild \n\n",3,3,"n","AMBER",9,null,"Use of market intelligence to drive awareness of market positional and applicant motivations. \n\nBrand review project, which will include messaging appropriate to each market in support of student recruitment.\n\n\nTargeted incentives and scholarships \n\nImplementation of plan to enhance conversion rates \n\n\nContinue to deliver programme of in-person and virtual recruitment events for prospective students.  \n\n\nFor RUK UG planning our approach to Clearing and Confirmation, overseen by the Clearing and Confirmation TFG, to support growth in this area\n\nMaintain awareness of UK-wide discussions in relation to post qualification admissions for the undergraduate market, and the potential impact this could have on undergraduate recruitment. \n\n","In place\n\n\nIn progress\n\n\nIn place\n\n\nIn place\n\n\nIn place\n\n\n\nIn progress\n\n\n\nIn place\n\n\n",3,2,"n","YELLOW",6,"New Risk"]
[null,6," Over-reliance on key markets increases exposure to international student recruitment risk.\n","VP GR","Head of International Recruitment","\nExposure to the impact of geopolitical tensions, conflict, economic downturn and other global events.  \n\nLoss of tuition fee income and income shortfalls against budgets\n\nReduced ability to sustain other areas of activity which do not recover their full-costs \n\n\nInability to respond to changing prioritisations of rank sensitive and price sensitive markets. \n\n\nExposure to changes in market sentiment or affordability in individual markets.  \n\nAdverse impact on the net fee income per student FTE\n\nReduced ability to sustain other areas of activity that do not recover their full cost.\n\nAdverse impact on the balance of UG to PG numbers in the population\n\n\nLoss of market share which is challenging to rebuild \n\nOver-reliance on a small number of key markets\n\n\n\n",4,4,"n","RED",16,null,"Use of market intelligence to drive awareness of market positional and applicant motivations. \n\nTargeted incentives and scholarships in response to the price-sensitivity of the individual market.  \n\nImplementation of plan to enhance conversion rates in key markets.\nEnsuring brand promotion fully optimises ranking credentials in rank-sensitive markets. \n\n\nTask and finish groups established to review strategic approaches for international recruitment and market diversification\n\nDevelopment of new programmes and employability focus to meet market demand \n\nEnhance in-country presence in key markets\n\nContinue to deliver programme of in-person and virtual recruitment events for prospective students. \n","In place\n\n\nIn place\n\n\nIn place\n\n\nIn place\n\n\nIn progress\n\n\n\nIn place\n\nIn place\n",3,3,"n","AMBER",9,"New Risk"]
[null,7,"Changes in the external environment obstructs/interrupts recruitment of international students (geopolitics, international travel, changes to immigration policy global health) ","VP GR","Dean for International Stakeholder Engagement","\nLoss of tuition fee income and income shortfalls against budgets\n\nReduced ability to sustain other areas of activity which do not recover their full-costs \n\nAdverse impact on the net fee income per student FTE\n\nReduced ability to sustain other areas of activity that do not recover their full cost.\n\nAdverse impact on the balance of UG to PG numbers in the population\n\n\nLoss of market share which is challenging to rebuild \n\nOver-reliance on a small number of key markets\n\nLoss of market share which is challenging to rebuild \n ",3,4,"n","RED",12,"Treat","Provide clear messaging to applicants and key stakeholders\n\nEnsure flexibility in enrolment dates to accommodate delays and obstruction. \n\nOffer January entry points to allow applicants to defer to a later entry point in the same academic year. \n\nReview and reiterate our commitments to supporting incoming students as part of ongoing engagement and communication activity\n\nCoordination of activity across teams to ensure use of external intelligence and survey data to inform approaches to conversion\n\nProgramme of digital engagement and events across a range of platforms and providers to provide offer-holder support and guidance\n\n","In place\n\nUnder consideration\n\nIn place\n\n\nIn place\n\n\nIn place\n\n\nIn place\n\n\nIn place\n\n\n\n",3,3,"n","AMBER",9,"No Change"]
[null,8,"Failure to satisfy SFC student number controls in relation to the home fees population","VP GR","DD ER","Financial penalties for over-recruiting or under-recruiting against SFC thresholds for the student population\n\nSpecifically, a financial penalty for over or under recruitment against SFC population thresholds for Medicine, Dentistry, Initial Teacher Education\n\nLoss of tuition fee income in the event of over-recruitment in the form of the SFC financial penalty resulting in a drop of fee income per FTE.\n\nClawback of grant by SFS in the event of under-recruitment against funded student places.\n\nLoss of market share which is challenging to rebuild",3,3,"n",{"$f":"IF(K11<4,\"GREEN\",IF(AND(K11>3,K11<7),\"YELLOW\",IF(AND(K11>7,K11<10),\"AMBER\",IF(AND(K11>9,K11<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"G11*H11","v":9},"Treat","Development of a portfolio of programmes appropriate to the market.\n\nBrand re-positioning project, which includes a focus on support for student recruitment.\n\nContinued engagement with prospective students at events (virtual and face-to-face) both on-campus and in school.\n\nImplementation of a comprehensive conversion plan\n\nProvision of materials for applicants and their influencers (guidance teachers, parents/guardians).\n\n\nPlanning our approach to Clearing and Confirmation, overseen by the Clearing and Confirmation TFG, to support growth in this area \n\n","In place\n\nIn progress\n\n\nIn place\n\n\nIn place\n\nIn place\n\n\n\nIn place\n\n\n\n\n",2,2,"n",{"$f":"IF(S11<4,\"GREEN\",IF(AND(S11>3,S11<7),\"YELLOW\",IF(AND(S11>7,S11<10),\"AMBER\",IF(AND(S11>9,S11<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O11*P11","v":4},"No Change"]
[null,9,"Failure to achieve student numbers agreed with SFC in support of Scottish Government priorities \n","VP GR","Dean for Widening Access, Articulation and Outreach","SFC Outcome & Impact Framework targets relating to access, articulation and STEM are not met impacting\nimpact on relationship with SFC and possible SFC sanctions and financial penalties. \n\nReputational damage as a result of perceived failure to offer widening access opportunities. \n\nInability to meet Aberdeen 2040 commitments on Inclusivity.\n\n\n\n",4,3,"n","RED",12,"Treat","Establishment of a comprehensive framework of metrics for widening access.\n\nWorking with SFC and Commissioner for Fair Access to ensure that we can implement metrics appropriate to our regional context.\n\nImplement a transparent contextualised admissions policy. Continue to review entry qualifications to ensure these are attractive to prospective students but do not impact on overall standards\n\nTargeted incentives and scholarships, such as widening access scholarships in partnership with the Development Trust, and free accommodation offering for SIMD20 students\n\nMaintaining existing FE College partnerships and seeking opportunities for new articulation pathways.\n\nContinued engagement with target school pupils at events (virtual and face-to-face) both on-campus and in school.\n\nProvision of materials for prospective widening access applicants and their influencers (guidance teachers, parents/guardians).\n\nPlanning our approach to Clearing and Confirmation, overseen by the Clearing and Confirmation TFG, to support growth in this area \n\nNew undergraduate STEM campaign","In place\n\n\nIn progress\n\n\nIn place\n\n\n\nIn place\n\n\n\nIn place\n\n\nIn place\n\n\nIn place\n\n\nIn progress\n\n\nIn place\n\n\n\n\n\n\n\n\n\n\n\n",3,2,"n","YELLOW",6,"No Change"]
[null,10,"Failure to mitigate a potential reduction in student numbers and loss of fee income as a result of  the UK's withdrawal from the EU.  ","VP GR","Dean for International Stakeholder Engagement","Financial impact if EU numbers are not substituted by Scottish-domiciled numbers.\n\nLoss of diversity in our population.\n\nA reduced international student experience for home students.\n\nAdverse impact on performance measures/league tables which use the proportion of non-UK students as an internationalisation metric.\n",4,4,"n","RED",16,"Treat","Growing  Scottish-domiciled student  entrants to compensate for the loss of home fees EU numbers.\n\nDevelop the recruitment of international fee-paying students from the EU\n\n Based on market insights, establish a priority list of EU countries for the implementation of a brand awareness and conversion campaign.\n\nImplement and Monitor the effectiveness of the EU scholarship scheme for UG, PGT and PGR,\n\n","In place\n\n\nIn place\n\n\n\n\nIn progress\n\n\n\n\nIn progress",2,2,"n","YELLOW",4,"Down"]
[null,11,"Continuing impact of Coronavirus pandemic for international student recruitment","VP GR","Head of International Recruitment","Potential disruption to recruitment from markets impacted by renewed pandemic outbreaks across all study levels and fee categories (and in future years)\n \nContinuing obstruction to in-country logistical arrangements required to enable student registration (e.g. Visa processing, English Language testing, prior qualification verification; travel restrictions) \n\nContinuing impact on mobility of students from China in particular. \n\nLoss of brand awareness amongst future students as result of reduced activity in-country.\n\nReduced confidence in international study mobility amongst prospective students and influencers (families, agents, sponsors) ",4,4,"n","RED",16,"Treat","Maintain marketing campaigns and generate leads in country wherever possible.\n\nImplement a programme of digital engagement and events across a range of platforms and providers to provide offer-holder support and guidance\n\nContinue  programme of (a) internally delivered University-led virtual events and (b) external partner-delivered recruitment fairs where required  to replace in-country/ in-person recruitment events both in the UK and internationally\n\nContinuing diversification of markets to reduce reliance on those markets suffering longer-term pandemic consequences. \n\nPreparations for potential resurgences when pandemic conditions and mobility restrictions ease. \n\n","In place\n\n\nIn place\n\n\n\nIn place\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nIn place\n\n\nUnder consideration",2,3,"n","YELLOW",6,"Down"]
[null,12,"Potential growth opportunities for online student recruitment are not identified and/or fully realised. ","VP GR","DoAS & OE"," growth opportunities are not realised\n\nRecruitment diversification opportunities are not realised.  \n\nMarket share remains below potential.\n\nRestricted ability to address upskilling and economic regeneration needs. ",3,3,"n",{"$f":"IF(K15<4,\"GREEN\",IF(AND(K15>3,K15<7),\"YELLOW\",IF(AND(K15>7,K15<10),\"AMBER\",IF(AND(K15>9,K15<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"G15*H15","v":9},"Treat","Develop clear strategy for developing online portfolio of courses and programmes.\n\nEnhancement to the Online Education Management System to improve the  purchase of online courses and the learner experience\n\nReview opportunities to work with third party providers to help grow online student numbers\n\nDevelop in-house capacity to further broaden the On-Demand platform provision of short courses and programmes. \n\nRespond proactively to upskilling/reskilling opportunities and identify potential for  growth","In progress\n\n\n\nIn place\n\n\n\n\nIn place\n\n\nIn progress\n\n\n\n",2,3,"n",{"$f":"IF(S15<4,\"GREEN\",IF(AND(S15>3,S15<7),\"YELLOW\",IF(AND(S15>7,S15<10),\"AMBER\",IF(AND(S15>9,S15<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O15*P15","v":6},"Up"]
[null,13,"Reform of pre-university qualifications affecting school and College sectors and potential reform to university admissions","VP GR","DD ER","Disruption to undergraduate recruitment\n\nLimited time to implement changes to accommodate any reforms to the UCAS application process impacting on workload and the applicant experience. \n\nConsequences for entry tariff arising from SQA-driven changes to Scottish School examinations. \n\nPossible impact on our competitiveness in market and resulting fee income\n\n",3,3,"n","AMBER",9,"Treat","Continue to keep ongoing reform proposals under review and lobby against change which would damage recruitment.\n\nMonitor political debates and sentiment to assess likelihood of significant  reform to admissions and pre-entry qualifications. S  \n\n","In place\n\n\nIn place\n\n\n",1,2,"n","GREEN",2,"Down"]
[null,14,"Changing patterns in demand for academic disciplines or modes of study ","VP GR","DD ER","Instability in student numbers by discipline \n\nUncertainty around financial viability of areas. \n\nMisalignment of our current and planned provision with applicant preferences and student demand. \n",3,4,"n","RED",12,"Treat"," Use of market intelligence to understand applicant demand and inform portfolio planning.\n\nActive diversification of provision across study modes and disciplines to respond to changing patterns of demand. \n\nEngagement with academic Schools to ensure that new product development is aligned to market opportunities and identified demand. \n\nWork with academic school and Directorate of Planning to ensure School and University programme portfolios are optimised.\n\nPut in place processes to deliver proactive management of the University's portfolio of programmes of study.\n\nProcess of setting discipline-based targets which is mapped to budget planning round and informed by market insights.\n\n\n","In progress\n\n\nIn place\n\n\nIn place\n\n\nIn progress\n\n\nUnder consideration\n\n\nIn progress",2,3,"n","YELLOW",6,"Up"]
[null,15,"Inability to provide timely and informed student recruitment projections","VP GR","DD ER","Inability to project workload and plan staffing requirements\n\nImpact on projections for planning an budget purposes meaning that academic areas are not equipped of resources to support increased student numbers. \n\nPotential negative impact on the student experience.\n\nPotential negative impact on future student recruitment.",3,3,"n","AMBER",9,null,"Monitoring and regular updating of conversion rates of application/offer/acceptance to registered student\n\nImplementation of a methodology to develop range-based projections.\n\nCross working between External Relations (new entrants); Planning (student population planning); and Finance (budgetary impact) to enhance robustness of projections available.\n\n","In place\n\nIn place\n\nIn progress\n\n\n",2,2,"n","YELLOW",4,"New Risk"]
[null,16,"Increading diversity of student intake creates processing challenges and consequent compliance risks","VP GR","DD ER","Risk of issuing CAS to non-credible applicants resulting in a risk to our UKVI Licence\n\nWe are unable to provide applicants with a full and timely response on action required by them\n\nInsufficient market knowledge to scrutinise and understand complex documentation",4,4,"n","RED",16,null,"Ensure staff receive appropriate training\n\nEnsure staff capacity in place (risk 1)\n\nAgree and transparently set out clear deadlines for University and applicant decision-making\n\nMonitor UKVI visa refusal rates and other market behaviours\n\nClose working  between University's Admissions and Immigration Compliance Teams","In place\n\nIn progress\n\nIn place\n\n\nIn place\n\nIn place\n",3,3,"n","AMBER",9,"New Risk"]
[null,17,"Programme promotion materials and web matter are inaccurate and ineffective","VP GR","Head of Marketing & Brand Development","Failure to attract interest from, and engage with, prospective students and applicants\n\nNegative impact on conversion rates from prospective, to registered, student\n\nRisk of complaints from prospective students\n\nRisk of failure of compliance with Consumer Markets Authority (CMA ) guidance\n\n",3,3,"n","AMBER",9,null,"Timely updating of promotional materials\n\nClearly articulate information about programmes on offer; tuition fees; entry requirements; and deadlines in a timely manner\n\nEnsure programme information is centrally managed and co-ordinated through the Marketing & Brand Development Team.\n\nEnsure programme information is updated at least annually","In place\n\nIn place\n\n\nIn place\n\n\nIn place\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n",1,2,"n","GREEN",2,"New Risk"]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]

{"sheet":"Education (UG and PGT)","index":7,"n_rows":19,"n_cols":20,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,5],[2,8,2,10],[2,16,2,18]]}
[null,"Strategic Risk Area:",null,"Education (UG and PGT)"]
[]
[null,"No.","Risk  (what could happen)","Risk Owner","Risk Manager","Consequences (how would this affect the University)","Likelihood","Impact","Unmitigated Score\n(gross)",null,null,"Response","Mitigations (what is being/has been done to control the risk) ","Status (in place/in progress/under consideration)","Likelihood","Impact","Mitigated Score\n(net)",null,null,"Risk Movement"]
[null,1,"Interruption or changes to planned approach to teaching, learning and assessment due to any changes to national sector guidance related to Covid-19 and staff or student Covid-related absence (e.g. reduced on campus contact time, impact on practical teaching such as labs and performance, continuation of placement activity, student mobility etc)","VP E\n","Director of Academic Services & Online Education","Student performance and progression decreases\n\nStudents unable to fulfil requirements for graduation\n\nReputational damage\n\nDrop in national and international rankings School visiting programmes impacted",3,3,"n",{"$f":"IF(K4<4,\"GREEN\",IF(AND(K4>3,K4<7),\"YELLOW\",IF(AND(K4>7,K4<10),\"AMBER\",IF(AND(K4>9,K4<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"G4*H4","v":9},"Treat","Schools have prepared for teaching with contingency plans in place (e.g., ability to delivery online for students who cannot be on campus); Student Services continue to be available online so that there is access to these services for all students, no matter their circumstances.\n\nAlternative assessment is in place for the entire academic year (except where accreditation requirements require exams)\n\nNamed contact from the Centre for Academic Development for each School – to support the development of online teaching and alternative assessments\n\nSchool-based and Medical / Dentistry placement situation continue to be monitored proactively; all other placement requirements continue to be monitored proactively and will be managed appropriately\n\nHardship Fund in place to support students who require IT facilities\n\nSupport and training for 'dual delivery' (i.e., delivery of teaching to students in the classroom and online at the same time) in place\n\nAccess to increased online texts through the Reading Lists project and resources through the Library with additional support from the Library team provided to Schools\n\nDetailed guidance re. Erasmus opportunities and assoc. travel given to students and their individual study plans facilitated through Erasmus coordinators and central Erasmus Office\n","In place for 2HS\n\n\n\n\nIn Place for 2HS\n\n\nIn place\n\n\nIn place\n\n\n\nIn place  \n\nIn place\n\n                                                                                                                                         In progress (ongoing work)\n\n\n\nIn place",2,2,"n",{"$f":"IF(S4<4,\"GREEN\",IF(AND(S4>3,S4<7),\"YELLOW\",IF(AND(S4>7,S4<10),\"AMBER\",IF(AND(S4>9,S4<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O4*P4","v":4},"Down"]
[null,2,"Inadequate quality of teaching, learning and assessment in AY21/22 due to ongoing requirements for blended learning in the context of the ongoing Covid-19 pandemic, and student expectations around on campus and online learning.","VP E\n","Director of Academic Services & Online Education","Student satisfaction decreases\n\n\n",2,3,"n",{"$f":"IF(K5<4,\"GREEN\",IF(AND(K5>3,K5<7),\"YELLOW\",IF(AND(K5>7,K5<10),\"AMBER\",IF(AND(K5>9,K5<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},6,"Treat","Schools have pplans in place for the delivery of teaching, learning and assessment for 1HS in line with the Principles for Blended Learning and the Timetabling Principles\n\nSchools will ensure they have plans in place for the delivery of 2HS and the rest of the academic year in an appropriate timeframe\n\nSchool Education Committees will monitor preparations and support staff where necessary to complete the preparations (workload issues will be raised with ALMs)\n\nArrangements for 2HS will be similar to 1HS for AY21/22 except that on campus sessions will not have an equivalent online session in the timetable, unless students have exceptionally been granted permission to study fully online (in which case those students will be offered online learning) [NB a staff communication has provided details on this]\n\nCommunications wil be provided to students and staff (student communications will be agreed with AuSA) so that the community is up-to-date\n","Complete\n\n\n\nIn place for 2HS\n\n\nIn place for 2HS\n\n\n\nIn place\n\n\n\n\n\n\nOngoing",2,2,"n",{"$f":"IF(S5<4,\"GREEN\",IF(AND(S5>3,S5<7),\"YELLOW\",IF(AND(S5>7,S5<10),\"AMBER\",IF(AND(S5>9,S5<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O5*P5","v":4},"No Change"]
[null,3,"Assessment and feedback on assessment is not of a high quality and / or provided within the required timeframes.\n","VP E\n","Director of Academic Services & Online Education","Impact on student performance and progression\n\nNSS Assessment and Feedback results do not improve with impact on League Table rankings",4,3,"n",{"$f":"IF(K6<4,\"GREEN\",IF(AND(K6>3,K6<7),\"YELLOW\",IF(AND(K6>7,K6<10),\"AMBER\",IF(AND(K6>9,K6<17),\"RED\",\"ERROR\"))))","v":"RED"},12,"Treat","Put in place an approach to monitoring the timeliness of providing student feedback at School level so that Heads of School / Directors of Education can intervene where necessary\n\nPut in place an approach that ensures that all students are provided with all information about assessment (including but not limited to: type of assessment, criteria for marking, timelines for submission and return of grades/feedback)\n\nTake forward actions at institutional level that supports Schools to improve feedback (e.g., provision of training)\n\nTake forward a pilot of the use of TESTA (Transforming the experience of students through assessment) in one or more School\n\nIdentify good practice in assessment at course, discipline and / or School levels and disseminate appropriately\n\nEach School will review the NSS results at discipline level and will put in place action plans at discipline level\n\nQuality assurance processes in place to ensure appropriate assessment is in place, including liaison with external examiners\n\nGuidance in place on assessment: development of assessment, inclusivity, integrity with continued work on matters of integrity (e.g., essay mills)","In place for 2HS\n\n\n\n\nIn place for 2HS\n\n\n\nIn place\n\n\nIn progress\n\n\nIn progress\n\n\nIin place\n\n\nIn place\n\n\n\nOngoing",2,3,"n",{"$f":"IF(S6<4,\"GREEN\",IF(AND(S6>3,S6<7),\"YELLOW\",IF(AND(S6>7,S6<10),\"AMBER\",IF(AND(S6>9,S6<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},6,"Down"]
[null,4,"Non-continuation of students with some student groups being more at risk of non-continuation","VP E\n","Director of Academic Services & Online Education","Impact on individual students\n\nLoss of tuition fee income\n\nImpact on completion rates and League Table position\n\nReputational impact\n\n",3,3,"n",{"$f":"IF(K7<4,\"GREEN\",IF(AND(K7>3,K7<7),\"YELLOW\",IF(AND(K7>7,K7<10),\"AMBER\",IF(AND(K7>9,K7<17),\"RED\",\"ERROR\"))))","v":"AMBER"},9,"Treat","Continued development of transition into university support, orientation and induction approaches to support the needs of students\n\nAnalysis of non-continuation data that enables targeted initiatives to be developed as necessary at institutional, School and discipline levels\n\nMonthly review of withdrawal data to enable 'real-time' understanding of any trends or concerns\n\nAnalysis of particular demographic groups to determine if there are issues associated with particular groups, and take action to address the issues\n\nOngoing equality impact assessment of teaching, learning and assessment and take action where necessary\n\n","In place for 2HS\n\n\nIn progress\n\n\nIn progress\n\n\nIn progress\n\n\nOngoing",2,2,"n",{"$f":"IF(S7<4,\"GREEN\",IF(AND(S7>3,S7<7),\"YELLOW\",IF(AND(S7>7,S7<10),\"AMBER\",IF(AND(S7>9,S7<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},4,"No Change"]
[null,5,"No increase in the level of student mobility / students' opportunity to engage with an international experience","VP E\n","Director of External Relations","Impact on student experience due to lack of opportunity to undertake international placements\n\nImpact on recruitment\n\nImpact on the achievement of the Aberdeen 2040 Commitment 11\n",3,3,"n","AMBER",9,"Treat","Put in place a group to take forward planning that aims to increase the number of opportunities for study abroad\n\nTake forward a pilot of COIL (Collaborative Online International Learning) that aims to enable students to have an international experience without travel\n\nCommunicate the existing opportunities appropriately\n\nContinue to work with networks (e.g., Aurora, Curtin) to progress increased opportunities for student mobility\n\nContinue to work at a national level to influence the approach to the funding for study abroad","In place\n\n\nIn progress\n\n\nIn place\n\nIn place\n\n\nIn place",2,2,"n","YELLOW",4,"No Change"]
[null,6,"Quality assurance arrangements are not in place or not adhered to in our TNE (transnational education) partnerships in Qatar and for the Joint Institute with South China Normal University\n\n","VP E\n\nQAC","Director of Academic Services & Online Education","Impact on the student experience\n\nImpact on our reputation\n\nImpact on our external quality assurance outcomes\n\nImpact on the process of Ministry of Education relicencing (for AFG) in relation to the QA requirements for that process",3,3,"n","AMBER",9,"Treat","Produce a quality assurance report for each Quality Assurance Committee meeting for each partnership, identifying any risks or issues\n\nUtilise the robust committee structures that are in place to monitor and intervene as necessary\n\nEnsure that TNE partners have all necessary information and support to enable the implementation of our required quality assurance processes\n\nTFG is in place for the QA-related aspects of the relicensing process","In place\n\n\nIn place\n\n\nIn place\n\n\nComplete",2,2,"n","YELLOW",4,"New Risk"]
[null,7,"Students are unable to access work placements or go on to employment after graduation \n\n","VP E\n\nEEC","Head of Careers","Negative impact on graduate outcomes \n\nNegative impact on our graduates\n\nImpact on the achievement of Aberdeen 2040 Commitment 12",3,3,"n","AMBER",9,"Treat","Analysis of graduate outcome data at School and discipline levels to identify areas that require targeted action with Schools putting in place action plans\n\nPut in place a Group to develop approaches, policy and actions that increase the opportunities for work placements (or alternatives) as part of an overall approach to support employability\n\nWork with the Development Trust to identify opportunities that will support the development of placement opportunities\n\nUpscale and widen co-curricular internship opportunities through new ABDNConnect Internship programme (Communications to include engagement with alumni)\n\nEncourage UG students to undertake appropriate PG study with the University of Aberdeen","In progress\n\n\nIn place\n\n\n\nIn place\n\n\nIn progress\n\n\n\nIn place",3,2,"n","YELLOW",6,"No Change"]
[null,8,"Inability to complete the requirements for ELIR (Enhancement-Led Institutional Review) for QAA Scotland due to resources required to take this extensive piece of work forward","VP E\n","Director of Academic Services & Online Education","Negative impact on reputation\n\nIncreased monitoring required by QAAS\n\nMissed opportunity to promote the good practice in teaching, learning and assessment\n\nNegative impact on our condition of grant",1,4,"n","YELLOW",4,"Treat","Identify how resources can be allocated to enable the ELIR process to take place over 2022-2023 in a robust way. Update: 03 April 2022 - it is likely that similar arrangements will be in place for AY22/23 as the current year and therefore it is unlikely that a full-scale ELIR will be taking place in 22/23. Once confirmed this risk will be updated and / or removed.","In progress",1,2,"n","GREEN",2,"Down"]
[null,9,"Inability to complete the Aberdeen 2040 strategic work for Education relating to the following (some of this covered in sepeate risks):\n\n- Pastoral support\n- Monitoring, absence and engagement processes\n- Assessment and Feedback\n- Non-continuation and success\n- Education policy project\n- Enhancement-Led Institutional Review\n- Decolonising the Curriculum\n- Aberdeen 2040 Graduate Attributes and Skills\n- Aberdeen 2040 Delivery of Education\n- The International student experience\n- Employability and graduate outcomes\n","VP E\n","Director of Academic Services & Online Education and\nDirector of People\n\n\n\n\n\n\n\n\n","Missed opportunity to enhance Education following the learning that has emerged from blended learning and the wider student experience during Covid-19\n\nNegative impact on the League Tables",3,4,"n","RED",12,"Treat","Action plan for Education, with associated workstreams in place\n\nResource implications of the extensive work addressed\n\nConsultation approach embedded as part of all of the work (our colleagues, students, wider stakeholders)\n\nMonitoring through the University Education Committee structure","In progress\n\nI n progress\n\nIn progress\n\n\nIn place",2,3,"n","YELLOW",6,"No Change"]
[null,10,"Failure to adhere to requirements of Professional & Statutory Regulatory Bodies (PSRB) leading to risk of loss of accreditation","VP E","Director of Academic Services & Online Education","Reputation damage\n\nNegative impact on student employability\n\nRisk of litigation",2,4,"n","AMBER",8,"Treat","Ensure close oversight by Schools of PSRB requirements\n\nQAC oversight of PSRB accreditation reports","In place\n\nIn place",1,4,"n","YELLOW",4,"No Change"]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]

{"sheet":"Research and PGR","index":8,"n_rows":17,"n_cols":20,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,5],[2,8,2,10],[2,16,2,18]]}
[null,"Strategic Risk Area:",null,"Research and PGR"]
[]
[null,"No.","Risk  (what could happen)","Risk Owner","Risk Manager","Consequences (how would this affect the University)","Likelihood","Impact","Unmitigated Score\n(gross)",null,null,"Response","Mitigations (what is being/has been done to control the risk) ","Status (in place/in progress/under consideration)","Likelihood","Impact","Mitigated Score\n(net)",null,null,"Risk Movement"]
[null,1,"Failure to grow research income \n\n(see also Financial Sustainability, risk No. 4 (Sustained loss of research income above sector average))","VP R","D of R&I","Reduced ICC income;\n\nReduced ability to invest in research;\n\nLoss of track record impacts on ability to attract funding;\n\nAdverse impact on league tables;\n\nReduction of REG year on year\n\nImpact on REF metrics",3,3,"n",{"$f":"IF(K4<4,\"GREEN\",IF(AND(K4>3,K4<7),\"YELLOW\",IF(AND(K4>7,K4<10),\"AMBER\",IF(AND(K4>9,K4<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"G4*H4","v":9},"Treat","-  Alignment of institutional research themes in Aberdeen 2040 to national funding priorities and the UN Sustainable Development Goals;\n\n-  The team of Directors of interdisciplinary challenges, recruited to focus on excellent research and interdisciplinary education, supported by the Business Development Team/Grants Academy and the Impact and Knowledge Exchange Team in Research & Innovation;\n\n- New V-P for Regional Engagement and Regional Recovery, working with the research Deans and R&I for the delivery regional recovery agenda. \n\n-  Creation of a dedicated space to support the work within the interdisciplinary themes underway;\n\n-  Provision of pump-priming opportunities as well as matched/co-funding for strategically important projects;\n\n-  Increased and dedicated support of very high value bids through Research & Innovation;  \n\n-  Further improvements to pre- and post-award management system\n\n- Provision of benchmarking research income information to schools to aid income planning\n","In place \n\n\n\n\nIn place\n\n\n\n\n\n\n\nIn place\n\n\n\n\nIn progress\n\n\n\nIn place\n\n\n\nIn place\n\n\n\nIn progress\n\n\nIn place",2,3,"n",{"$f":"IF(S4<4,\"GREEN\",IF(AND(S4>3,S4<7),\"YELLOW\",IF(AND(S4>7,S4<10),\"AMBER\",IF(AND(S4>9,S4<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O4*P4","v":6},"No Change"]
[null,2,"Reduced/insufficient quality of research","VP R","D of R&I","Decline in citations, number and percentage of highly cited papers;\n\nReduced ability to attract funding;\n\nReduced ability to publish in competitive journals or with competitive publishers;\n\nAdverse impact on league tables\n\nReputational damage",4,3,"n",{"$f":"IF(K5<4,\"GREEN\",IF(AND(K5>3,K5<7),\"YELLOW\",IF(AND(K5>7,K5<10),\"AMBER\",IF(AND(K5>9,K5<17),\"RED\",\"ERROR\"))))","v":"RED"},12,"Treat","-  Continued peer support  through interdisciplinary themes,  Grants Academy and School processes;\n\n-  Aberdeen 2040  promotes challenge based research through IDR themes, engagement with research users and partnership working to enable project proposals likely to attract competitive funding and to yield high quality outputs;\n\n-  Staff development/training programmes for staff and PGRs available through the Researcher Development Unit;\n\n-  In-School processes include mentorship and engagement/staff development through discipline and professional associations;\n\n-  Membership of UK Research Integrity Office and UK Reproducibility Network commits us to working to nationally recognised standards of research integrity and reproducibility;\n\n- Implementation of the San Francisco Declaration on Research Assessment - regular assessments of research quality outside of national assessment exercises;\n \n-  Increased and dedicated support for very high value bids likely to produce very high quality outputs \n\n- monitoring of rates of outputs and consideration of workload adjustment to academics if required\n","In place\n\n\n\nIn progress\n\n\n\n\n\n\n\nIn place\n\n\n\nIn place\n\n\n\nIn place\n\n\n\nIn progress\n\n\n\n\nIn progress \n\n\n\nUnder consideration",3,2,"n",{"$f":"IF(S5<4,\"GREEN\",IF(AND(S5>3,S5<7),\"YELLOW\",IF(AND(S5>7,S5<10),\"AMBER\",IF(AND(S5>9,S5<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O5*P5","v":6},"No Change"]
[null,3,"Reduced/insufficient KE activity; failure to grow our portfolio of enterprise, entrepreneurship and spin outs","VP R and VP RERR\n","D of R&I","Reduced income from KE\n\nFailure to generate impact to report to funders or REF\n\nInability to contribute to recovery effort and attract funds that enable generation of further impact/KE activities\n\nInability to develop a portfolio of new spin out and start up opportunities for the innovation hubs in the region\n\nReputational damage",3,3,"n",{"$f":"IF(K6<4,\"GREEN\",IF(AND(K6>3,K6<7),\"YELLOW\",IF(AND(K6>7,K6<10),\"AMBER\",IF(AND(K6>9,K6<17),\"RED\",\"ERROR\"))))","v":"AMBER"},9,"Treat","- Work with regional partners on industry needs; \n\n- Promote breadth of university assistance to industry recovery;\n\n- Promote collaboration beyond academia and partnership working through interdisciplinary themes;\n\n- Encourage work with non-academic partners on industry solutions\n\n- Develop new strategy for entrepreneurship,  programmes for generating new spin outs/start ups and an enhanced physical location\n\n- Review incentives and promotion opportunities relating to KE\n\n- Engage with regional partners on strategic bids eg Freeport bid and working with NESA partners","In place\n\n\nIn place\n\n\nIn place\n\n\n\nIn place\n\n\n\nIn progress\n\n\n\nIn progress\n\n\nIn progress",3,2,"n","YELLOW",6,"No Change"]
[null,4,"Failure to attract PGR students; failure to retain, progress PGRs, low rates of completion; failure to provide a positive PGR experience\n\n (see also Student Recruitment risk register, risk No. 1 (Failure to meet Recruitment Targets) and risk No. 2 (International Students))","VP R and VP GR\n","GN","Reduction of research capacity\n\nReduction of annual SFC PGR grant\n\nImpact on REF metrics\n\nImpact on PGR income where students fail to complete or fail to complete on time (non-compliance with UKRI 4-year rule)\n\nReduced ability to recruit PGR students\n\nReduced ability attract studentships and DTP funds and international applications",3,4,"n","RED",12,"Treat","- Implement findings of the PGR Task and Finish Group\n\n-Increased student support via PGR School;\n\n- Specific guidance for supervisors and PGR School co-ordinators around engagement; \n\n- Provision of mandatory training for PGRs and supervisors, core and generic training online;\n\n- Promotion of 'Engage the World' of staff profile changes including PGR recruitment button and update of study here pages;\n\n- Continued engagement with International funders/partnerships;\n\n- Ensure DTP applications are promoted and supported by institutional commitment required to match/co-fund;\n\n","In progress\n\n\nIn place\n\nIn place\n\n\nIn place\n\n\nIn place\n\n\n\nIn place\n\n\nIn place\n\n",3,2,"n","YELLOW",6,"No Change"]
[null,5,"Failure to attract and retain high quality T&R /R staff\n\n(see also:  Staffing risk register, risk No. 1 (Recruitment) and risk No. 6 (Retention))\n\n","VP R","D of R&I and Director of People","Reduced research capacity\n\nReduced ability to attract external funding and PGR candidates\n\nReduced ability to engage with industry/KE agenda\n\nReduced visibility with adverse impacts on student and staff recruitment\n\nLonger term reduction of REG",3,4,"n","RED",12,"Treat","- Implement findings from Research Culture Task and Finish Group \n\n- Ensure rolling programme of facilities review to main high quality research facilities\n\n- Close engagement with and support to researchers;\n\n- Dedicated support to commercialisation and enterprise;\n\n- Monitoring of research metrics by protected characteristic to ensure inclusive approach to support;\n\n- Ensure high visibility of  and celebrate research success through Comms, PERU, web content and social media","In progress\n\n\nIn place\n\n\nIn place\n\n\nIn place\n\n\n\nIn place\n\n\n\nIn place",2,3,"n","YELLOW",6,"No Change"]
[null,7,"Failure to maintain high standards of ethics and governance; failure to comply with regulatory and statutory requirements","VP R","D of R&I","Clawback or financial penalities\n\nStatutory obligations not met\n\nRegulatory or statutory penalties\n\nReputational damage\n\nFunder(s) refusing to accept applications from individual researchers \n\nFunder(s) refusing to accept applications from institution\n\nLoss of research data (linked to Cybersecurity risk)\n\nLoss of IP through espionage or unauthorised/harmful use of research outcomes\n",2,3,"n","YELLOW",6,"Treat","- Regular review and update of Research Governance Handbook to ensure compliance of processes and policies with funder requirements and integrity standards;\n\n- Mandatory online training introduced (for research integrity, fundamental ethics and research data management);\n\n- Mandatory in depth ethics training for ethics  applicants and reviewers;\n\n- Continued membership and engagement with UK Research Integrity Office and UK Reproducibility Network;\n\n- Establishment of an institutional ethics group (as sub-group of the University Research Committee) to discuss and share good practice:\n\n- Implmentation of a new University wide ethics system (Worktribe) to ensure consistency of ethics processes\n\n- Continued close partnership with NHS on clinical studies involving human participants;\n\n- Continued close scrutiny of Home Office regulated research involving animals to ensure compliance;\n\n- Develop guidance and process for registration of projects/partnertships under the National Security Investment Act 2021 (retrospective to 2020)","In place\n\n\n\n\nIn place\n\n\n\nIn place\n\n\nIn place\n\n\n\nIn place\n\n\n\n\nIn progress\n\n\n\nIn place\n\n\n\nIn place",2,2,"n","YELLOW",4,"No Change"]
[null,7,"Failure to plan effectively for the next national Research Assessment Framework","VP R","D of R&I","Poor performance in the assessment period\n\nFurther loss of REG funding\n\nImpact of league tables\n\nReputational damage\n\nRecruitment and retention of staff and PGR students\n\nIncreased number of outputs/impact case studies marked 'unclassified' impacting negatively on quality profiles;\n\nIncreased effort for REF2028; policy and potential investment decisions taken too late in the assessment cycle to impact positively on the outcome of the next exercise",3,3,"n","AMBER",9,"Treat","- Implementation of findings of REF lessons learnt exercise\n\n- Engagement through a variety of formal and informal networks, V-P Research and REF manager participating in round table discussion as part of Research England's FRAP project, ongoing engagement through RKEC and Scottish REF Managers Group\n\n- Increase resilience and capacity for key roles\n\n- Improve processes and support for generating and capturing impact\n\n- Improve research data management and reporting (grant activity, income, citations and benchmarking) ","In progress\n\n\n\n\nIn place\n\n\n\n\n\nIn progress\n\nIn progress\n\n\nIn place",2,2,"n","YELLOW",4,"No Change"]
[null,8,"Further significant disruption due to COVID or other pandemic/calamity","VP R","D of R&I and Dean for Interdisciplinary Research and Impact","Loss of research income\n\nFailure to progress students\n\nInability to obtain funding\n\nInability to complete ongoing research or publish",3,3,"n","AMBER",9,"Treat","- Early logging of any potential issues with funders, included potential for costed extensions;\n\n- Early identification of external and internal funding to assist in mitigating impact and delivery of original research projects and monitoring of impact and funding requirements during potential further restrictions;\n\n- PGR campaigns and scholarship schemes to mitigate potential negative impact on PGR recruitment; enhanced online and at distance offering; flexible start dates","In place/ready to be deployed\n\n\n\n\n\nIn place/ready to be deployed\n\n\n\n\n\nIn place/ready to be deployed",2,2,"n","YELLOW",4,"No Change"]
[null,9,"Failure to comply with funders' t's and c's","VP R","D of R&I","Clawback or financial penalities;\n\nFunder(s) refusing to accept applications from individual researchers;\n \nFunder(s) refusing to accept applications from institution;\n\nDepending on nature of breach, regulatory or statutory consequences;\n\nReputational damage",3,3,"n",{"$f":"IF(K12<4,\"GREEN\",IF(AND(K12>3,K12<7),\"YELLOW\",IF(AND(K12>7,K12<10),\"AMBER\",IF(AND(K12>9,K12<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"G12*H12","v":9},"Treat","- Monitoring of funders' conditions and policy requirements (including funders' penalty policies);\n\n- Early engagement with funders and third parties with a view to mitigate potential claims where appropriate;\n\n- Ensure communication with partners via PIs and Research & Innovation;\n\n- Support compliance with relevant training for researchers and PGRs","In place\n\n\nIn place\n\n\nIn place\n\nIn place",2,2,"n",{"$f":"IF(S12<4,\"GREEN\",IF(AND(S12>3,S12<7),\"YELLOW\",IF(AND(S12>7,S12<10),\"AMBER\",IF(AND(S12>9,S12<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O12*P12","v":4},"No Change"]
[null,null,null,null,null,null,null,null,"n","GREEN",0,"Treat",null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,"Treat",null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,"Treat",null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,"Treat",null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,"Treat",null,null,null,null,"n","GREEN",0]

{"sheet":"Digital & Information Services","index":9,"n_rows":15,"n_cols":20,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,5],[2,8,2,10],[2,16,2,18]]}
[null,"Strategic Risk Area:",null,"Digital & Information Services"]
[]
[null,"No.","Risk  (what could happen)","Risk Owner","Risk Manager","Consequences ","Likelihood","Impact","Unmitigated Score\n(gross)",null,null,"Response","Mitigations (what is being/has been done to control the risk) ","Status (in place/in progress/under consideration)","Likelihood","Impact","Mitigated Score\n(net)",null,null,"Risk Movement"]
[null,1,"A failure, absence or compromise of Information Governance procedures or IT Security controls results in loss, destruction or unauthorised access to data or inability to meet accountability obligations.","SVP","DoDIS","Data security breaches\n\nDisruption to business activities\n\nFinancial impact\n\nReputational damage",4,4,"n",{"$f":"IF(K4<4,\"GREEN\",IF(AND(K4>3,K4<7),\"YELLOW\",IF(AND(K4>7,K4<10),\"AMBER\",IF(AND(K4>9,K4<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"G4*H4","v":16},"Treat","Ensure significant proactive focus and staffing, including Information Security Manager and Data Protection Officer, in this area to identify and manage risk,  and drive improvement. \n\nRemote monitoring of organisation by security team, including weekends where specific threat intelligence warrants (if volunteers available).\n\nInformation champions group for staff / student education with meetings in the diary to highlight key developments in Information Governance/Information Security practices. \n\nMFA now rolled out across all alumni, staff and students. Microsoft 365, VDI and VPN are covered by MFA with MyHR and external account work underway.\n\nMulti-layered technical controls in place and continually assessed and improved (vulnerability management, email auto-forwarding, mobile  management) to reduce risk.\n\nReview and improve security tools (SIEM, MS tools) to ensure that security and performance are optimal in the changing working environment.\n\nInstallation of immutable data store to help protect data from ransomware attack.\n\nInformation Governance Committee, Information Risk Working Group and Operation Security Group in place to provide policy, governance, prioritise risk mitigation activities.\n\nAdherence to Scottish Governance  Action Plan and Cyber Resilience Framework\n\nActive participation in external networks and threat intelligence sharing groups and forums\n\nRegular audits, security assessments and penetration testing.\n\nImprovement of information security and data protection training and development for staff and students with the development of new mandatory training modules for staff.\n\nProcurement of  Incident Response retainer  to  support incident response activities.\n","In place\n\n\nIn place\n\n\nIn place\n\n\nIn place\n\n\nIn place\n\n\nIn progress\n\n\nIn progress\n\nIn progress\n\n\nIn progress\n\nIn place\n\nIn place\n\nIn progress\n\n\nIn progress",4,3,"n",{"$f":"IF(S4<4,\"GREEN\",IF(AND(S4>3,S4<7),\"YELLOW\",IF(AND(S4>7,S4<10),\"AMBER\",IF(AND(S4>9,S4<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"O4*P4","v":12},"Upwards"]
[null,2,"Inability to deliver work requests and system changes due to multiple, competing high level priorities and consistently high workload levels in particular areas.\n\nIncludes contributory impact of loss of subject matter experts and workload capacity due to resignations, failure to attract staff or posts on hold for a prolonged period.","US & COO","DoDIS","Disruption to day-to-day activities\n\nStudent experience\n\nStudent progression\n\nStudent completion\n\nReputational impact\n\nFinancial impact\n\nRegulatory Compliance\n\nSecurity posture degradation\n",4,4,"n",{"$f":"IF(K5<4,\"GREEN\",IF(AND(K5>3,K5<7),\"YELLOW\",IF(AND(K5>7,K5<10),\"AMBER\",IF(AND(K5>9,K5<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"G5*H5","v":16},"Treat","D&IS prioritisation process\n\nEscalation to SMT and relevant task and finish groups\n\nFinancial case submitted to DSC for 21/22 and 22 / 23 onwards setting work priorities.\n\nPriority cases for recruitment submitted to Senior Management\nContinue discussion at a national level regarding support pools.  \n\nUtilise contractor / agency market if business critical.\n\nAd hoc use of retention arrangements or market premiums for staff attraction.\n\nSalary and benefits review for major  risk areas\n\nConsideration and definition of the Employee Value Proposition","In place\n\nIn place\n\nIn place\n\nIn place\n\n\nIn place\n\nIn place\n\nIn place\n\nIn progress",3,3,"n",{"$f":"IF(S5<4,\"GREEN\",IF(AND(S5>3,S5<7),\"YELLOW\",IF(AND(S5>7,S5<10),\"AMBER\",IF(AND(S5>9,S5<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"O5*P5","v":9},"No change"]
[null,3,"Inability to meet teaching requests / requirements for digital and non-digital  content (books / journals / other online information resources, items in museums and special collections). Related Inability to provide content to support research and risk of non-compliance of research outputs.\n\n","US & COO","DoDIS","Reduced Student experience\n\nStudent progression\n\nReputational impact\n\nFinancial impact\n\nWithdrawal of research funding\n\nReduction in grant income\n\nIncreased costs for access to content",3,3,"n",{"$f":"IF(K6<4,\"GREEN\",IF(AND(K6>3,K6<7),\"YELLOW\",IF(AND(K6>7,K6<10),\"AMBER\",IF(AND(K6>9,K6<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"G6*H6","v":9},"Treat","Close and early liaison with relevant academic and professional service groups \n\nParticipate in national strategic networks and planning conversations, especially Jisc Collections, Research Libraries UK and SCURL, covering both research publishing and eTextbooks\n\nFunding agreed with Development Trust for targeted digital content\n\nEnsure students in remote locations can access required resources\n\nFurther develop Reading List service functionality and scale of resource provision\n\nEngage with the national transition to open access, including major publisher negotiations and sector approaches to rights retention\n\nDevelopment of multi-year scholarly communications plan\n\nResources deployed for DORA implementation\n\nIdentify solutions to address UKRI compliance risk including revised University Open Access policy\n\nReview of research information systems relating to research output management and dissemination\n\nReprioritise resources towards increasing support for research publishing and impact.\n\n\n","In place\n\nIn place\n\n\n\nIn place\n\nIn progress\n\nIn place\n\nIn place \n\n                                                         In place\n\nIn progress\n\nIn progress\n\n\nUnder consideration\n\n\nUnder Consideration\n\n\n\n                                                   ",2,2,"n",{"$f":"IF(S6<4,\"GREEN\",IF(AND(S6>3,S6<7),\"YELLOW\",IF(AND(S6>7,S6<10),\"AMBER\",IF(AND(S6>9,S6<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O6*P6","v":4},"No change"]
[null,4,"Constrained service improvement, service reduction  due to inability to afford escalating revenue costs of provision. \n\nApplies to software license, maintenance and replacement of digital systems.and applications.","SVP/US & COO","DoDIS","Financial impact\n\nTeaching failure and effect on student journey\n\nAdministration service levels\n\nResearch capacity\n\nCyber / Governance risk",3,4,"n",{"$f":"IF(K7<4,\"GREEN\",IF(AND(K7>3,K7<7),\"YELLOW\",IF(AND(K7>7,K7<10),\"AMBER\",IF(AND(K7>9,K7<17),\"RED\",\"ERROR\"))))","v":"RED"},12,"Treat","Consider reduced license levels in a planned manner\n\nClose focus on license levels required. Contract cost reduction where possible \n\nStimulate and engage at national level in negotiations to reduce prices\n\nBring briefing and proposals on negotiations and University consultation to Digital Strategy Committee\n\n\nClose liaison with Finance Directorate and University Senior Management.\n\nDevelopment of appropriate financial plans in keeping with planning cycles.\n\nProgramme of digitisation of items in musuems and special collections includign colcultation with academic staff\n","In place\n\nIn place\n\nIn progress\n\nIn place\n\n\n\nIn place\n\nIn place\n\nIn place\n\n\n",3,3,"n",{"$f":"IF(S7<4,\"GREEN\",IF(AND(S7>3,S7<7),\"YELLOW\",IF(AND(S7>7,S7<10),\"AMBER\",IF(AND(S7>9,S7<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"O7*P7","v":9},"No change "]
[null,5,"Failure of digital delivery platforms due to fault, capacity or other issue. Widespread impact on Teaching, Research and administration.","SVP/US & COO","DoDIS","Disruption to business activities\n\nReputational damage\n\nFinancial impact\n\nReduced student experience / progression\n\nReduced grant income / research outputs",3,3,"n",{"$f":"IF(K8<4,\"GREEN\",IF(AND(K8>3,K8<7),\"YELLOW\",IF(AND(K8>7,K8<10),\"AMBER\",IF(AND(K8>9,K8<17),\"RED\",\"ERROR\"))))","v":"AMBER"},9,"Treat","Utilise expanded, multiple platforms where appropriate and affordable.\n\nPurchases alternative solutions when requirement is identified.\n\nRFC protocol in place to reduce internal errors when maintenance and change actions are undertaken\n\nAccessibility / captioning guidance in place\n\nVDI/ VPN system have undergone significant compute and licence expansion\n\nMonitoring of system performance with alerts in place via Nagios\n\nLobbying of suppliers through local and national contacts/ bodies\n\nFinancial case for relevant technology provision submitted via DSC for service recovery / augmentation\n     \nRe-configure University systems to minimise traffic impact. This is being monitored on an ongoing basis.\n\nSystem expansion considered on a case by case basis, e.g. VDI, VPN, Microsoft licenses (CRM, Security / PowerBI etc)\n\nUse of expandable technology stacks (VM, SAN store, cloud) and ability to escalate to senior management / DSC for funds to augment.\n\nCapacity Management a focus of operational management\n\nGenerator backup at Data Centres and split site redundant infrastructure for a number of core systems.\n","In place\n\nIn place\n\n\nIn place\n\nIn place\n\nIn place\n\nIn place\n\nIn place\n\nIn place\n\n\nIn progress\n\n\nIn place\n\n\nIn place\n\n\nIn place\n\nIn place\n\n",2,3,"n",{"$f":"IF(S8<4,\"GREEN\",IF(AND(S8>3,S8<7),\"YELLOW\",IF(AND(S8>7,S8<10),\"AMBER\",IF(AND(S8>9,S8<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},6,"No change"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Consulting with key research leaders and groups to better understand demand\n\nMore effective translation of demand into either universal or bespoke services\n\nGreater engagement at pre-award to offer innovative solutions and build in cost and expertise\n\nGreater emphasis on tracking technologies offered to researchers in other universities\n\nImplementing more on-demand/JIT solutions","In place\n\nIn progress\n\nIn progress\n\n\nIn progress\n\nIn progress\n\n\n\n"]
[null,6,"Campus internet performance degradation due to capacity issues or failure. ","TS","DoDISS","Disruption to business activities\n\nReputational damage\n\nFinancial impact",3,4,"n","RED",12,"Treat","Re-configure University systems to minimise traffic coming on to campus. This is being monitored on an ongoing basis but may require further significant work for Home Working Policy implementation.\n\nHave dual resilient links for major buildings and Aberdeen inter-campus traffice .\n\nRemove  on campus dependencies for major services (email / Teams) for emergency situations.\n\nDirect students to hardship fund to provide funding for local internet where relevant\n\nDeploy “data dongle” to staff for internet connectivity where appropriate\n\nGenerator backup at Data Centres and split site redundant infrastructure for a number of core systems. .","In progress\n\n\n\nIn place\n\nIn progress\n\nIn place\n\nIn place\n\nIn place\n",2,2,"n","YELLOW",4,"No change"]
[null,7," Loss of institutional competitiveness through under-investment in digital initiatives and content, due to prolonged  under-investment or poor strategic technology choices.\n\nThis includes the risk of failing to appropriately manage and deliver Application Transformation initiatives.","SVP/US & COO","DoDISS","Disruption to business activities\n\nFinancial impact\n\nReputational impact\n\nReduced student experience\n\nReduced research income\n\n",4,3,"n","RED",12,"Treat","Ensure that ROI perspective is taken on project decisions. Work that may support income generation and new ways of working to retain / attract students given full consideration. \n\nDirectorate and Digital funding bids completed for required duration (multi-year) \n\nIn consultation with senior colleagues and school plans, development of long term project / technology roadmaps to inform financial planning.\n\nProduction of well researched and detailed business cases in close collaboration with academic and professional services colleagues\n\nClose liaison with academic, professional service colleagues including DSC, forums and specific meetings \n\nProject Methodology, PID & scope documentation to ensure appropriate consultations\n\nUse of external knowledge bases such as Gartner for market / technology research to inform decision making\n\n\n\n\n\n","In place\n\n\nIn place\n\nIn progress.\n\n\nIn place\n\n\nIn place\n\nIn place\n\nIn place\n\n\n\n",3,3,"n","AMBER",9,"Upwards"]
[null,8,"Technology replacement programme or capacity management stops for extended period due to supply / resource issues leading to failures and poor back office and user technology. This includes facilitation of institutional home working policy (HWP).","SVP/US & COO","DoDISS","Impact on longer term business continuity\n\nFinancial impact\n\nReputational impact\n\nDisruption to business activities",3,3,"n","AMBER",{"$f":"G12*H12","v":9},"Treat","Ensure appropriate warranty packages are in place to maximise lifespan\n\nUtilisation of break / fix model and limited budget in the medium term.  \n\nUtilise unspent budget allocations to ensure sustainability of operation\n\nDevelop desktop replacement strategy to move to mobile provision\n\nFinancial case for HWP technology provision submitted to DSC. \n\nSubmission of orders in timely and bulked manner to try and ensure supply\n\nLobbying of suppliers at local and national level\n\n","In place\n\nIn place\n\nIn place\n\nIn place\n\nIn place\n\nIn place\n\nIn place",1,2,"n","GREEN",2,"No change"]
[null,9,"Inappropriate service provision to staff / students with particular & specific requirements (location / disability / accessibility / digital divide)","US & COO","DoDIS","Student Experience undermined\n\nFinancial impact\n\nReputational impact ",3,3,"n","AMBER",9,"Treat","Utilise technical solutions to overcome issues of location and access to infrmation.  Increased use of VDI (purchase of expanded computer/licence complete) and implementation of scalable and secure VPN for all remote/ home working\n\nConsider purchase of equipment and / or internet for students. SFC monies allocated to hardship fund for specific student technology requirements.\n\nCaptioning service for lecture capture\n\nDigital Accessibility Workgroup continues to champion increased adherence to WCAG regs and specific disability areas, e.g. dyslexia\n\nUse of internal and external hardship funds, equipment and content  to help reduce digital poverty\n\nDigital Accessibility Policy in place with clear roles & responsibilities for management and relevant staff roles.  \n\nReview of study spaces to include accessibility and inclusion.","In place\n\n\n\nIn place \n\n\nIn place\n\nIn place\n\n\nIn place\n\n\nIn progress\n\n\nUnder consideration",2,2,"n","YELLOW",4,"No change"]
[null,10,"Loss of digital content (corporate/research/heritage) due to lack of digital archiving and preservation service and systems","US & COO","DoDIS","Regulatory claims\n\nInability to comply with research funder policies\n\nReputational damage\n\nIrretrievable loss of unique materials\n",3,3,"n","AMBER",9,"Treat","External review to inform plans\n\nAcquisition of digital curation and preservation systems via DSC bid\n\nDevelopment of service and staffing\n\nIdentify and implement archiving solution introducing resilience to existing infrastructure through cloud provision","In progress\n\nIn progress\n\nUnder consideration\n\nIn progress",2,2,"n","YELLOW",4,"No change"]
[null,11,"Failure to adequately manage the  collections and special collections.","US & COO","DoDIS","Irretrievable loss or damage to unique materials \n\n\nFailure to retain museum  Accreditation and Recognition status \n\nLoss of SFC Museums Galleries and Collections grant \n\nReputational Impact",4,4,"n",{"$f":"IF(K15<4,\"GREEN\",IF(AND(K15>3,K15<7),\"YELLOW\",IF(AND(K15>7,K15<10),\"AMBER\",IF(AND(K15>9,K15<17),\"RED\",\"ERROR\"))))","v":"RED"},16,"Treat","Ensure building maintenance, and security systems and protocols, including regular checking of onsite and offsite stores, effective disaster prevention procedures and business continuity plans, and risk assessments for relevant activities \n\nFulfil expectations of Accreditation and Recognition schemes, including approval of policies and governance arranegments by Museums Galleries Scotland and anual reporting\n\nFulfil deliverables set by SFC, including annual reporting; engage with SFC through University Museums in Scotland group\n\nEnsure robust research and a transparent and consultative apprpoach underpins activity, particuarly when addressing issues such as decolonisation, slavery and repatriation; adherence to Museums Association Code of Ethics; close liaison with External Affairs\n","In place\n\n\n\nIn place\n\n\nIn place\n\n\nIn place\n\n\n                                                         \n\n\n\n                                                   ",2,2,"n","YELLOW",4,"Upwards \n\n(SFC reviewing grant scheme)"]

{"sheet":"People","index":10,"n_rows":22,"n_cols":20,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,5],[2,8,2,10],[2,16,2,18]]}
[null,"Strategic Risk Area:",null,"People"]
[]
[null,"No.","Risk  (what could happen)","Risk Owner","Risk Manager","Consequences (how would this affect the University)","Likelihood","Impact","Unmitigated Score\n(gross)",null,null,"Response","Mitigations (what is being/has been done to control the risk) ","Status (in place/in progress/under consideration)","Likelihood","Impact","Mitigated Score\n(net)",null,null,"Risk Movement"]
[null,1,"Inabiltiy to recruit staff, including as a result of an economic skills shortage in specialist ares, required to meet strategic priorities in Aberdeen 2040 and deliver a positive staff and student experience","DoPeople","Head of HR Business Partnering","Staff shortages\n\nCritical shortage in some disciplines and impact on UG and PGT teaching\n\nImpact on professional services delivery/ support\n\nImpact on REF\n\nResentment, following the need to review staffing complement and shift staff to business critical areas\n\nInability to delivery in speciality areas as a consequence of economic environment and skills shortages.\n\n\n\n ",4,3,"n",{"$f":"IF(K4<4,\"GREEN\",IF(AND(K4>3,K4<7),\"YELLOW\",IF(AND(K4>7,K4<10),\"AMBER\",IF(AND(K4>9,K4<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"G4*H4","v":12},"Treat","Review of R&S Policy including Relocation Package to make more attractive \n\nPost of Senior HR Partner (Resourcing) to provide specialist recruitment support including for senior and hard to recruit to posts\n\nDevelopment of proposals for market supplements and other incentives to attract staff where recruitment difficulties \n\nReview of reward practices (including promotion and career pathways, senior staff salary banding)\n\nDevelopment of homeworking policy and hybrid working guidance.\n\nDevelopment of annual programme learning & development activity to support internal upskilling.\n\n                                                                                       ","In progress\n\n\nComplete \n\n\n\nIn progress\n\n\nIn progress \n\n\nComplete\n\n\nIn progress\n\n\n",3,2,"n",{"$f":"IF(S4<4,\"GREEN\",IF(AND(S4>3,S4<7),\"YELLOW\",IF(AND(S4>7,S4<10),\"AMBER\",IF(AND(S4>9,S4<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O4*P4","v":6},"No Change"]
[null,2,"Inability to retain the high quality staff required to lead, develop and implement key strategic and operational priorities","DoPeople","Head of HR Business Partnering","Brain drain\n\nStaff shortages leading to excessive workloads for those remaining\n\nDrop in quality of education or research standards among academics, or of outputs and support in Directorates.\n\nReputational damage.",3,3,"n",{"$f":"IF(K5<4,\"GREEN\",IF(AND(K5>3,K5<7),\"YELLOW\",IF(AND(K5>7,K5<10),\"AMBER\",IF(AND(K5>9,K5<17),\"RED\",\"ERROR\"))))","v":"AMBER"},9,"Treat","Staff Survey\n\nReview of Probation Procedures\n\nComprehensive programme of staff development & leadership opportunities.\n\nReview of Contribution procedures and other Recognition practices\n\nAddition of home working/hybrid working to range of flexible working procedures.","Complete\n\nTo be undertaken\n\nIn place\n\n\nIn progress\n\n\nComplete",2,2,"n",{"$f":"IF(S5<4,\"GREEN\",IF(AND(S5>3,S5<7),\"YELLOW\",IF(AND(S5>7,S5<10),\"AMBER\",IF(AND(S5>9,S5<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O5*P5","v":4},"No Change"]
[null,3,"Overseas working - risk of staff working overseas and not notifying the University. Risk of fines due to tax etc implications ","DoPeople","Head of HR Business Partnering","Reputational damage\n\nFinancial impact ",3,2,"n",{"$f":"IF(K6<4,\"GREEN\",IF(AND(K6>3,K6<7),\"YELLOW\",IF(AND(K6>7,K6<10),\"AMBER\",IF(AND(K6>9,K6<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},6,"Treat","Guidance in place for staff and managers on the employment of staff overseas\n\nGlobal Mobility Policy to be implemented\n\nWorking with external specialist to ensure country specific guidance and advice is in place as required ","In place\n\nIn progress\n\nIn place ",2,2,"n",{"$f":"IF(S6<4,\"GREEN\",IF(AND(S6>3,S6<7),\"YELLOW\",IF(AND(S6>7,S6<10),\"AMBER\",IF(AND(S6>9,S6<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O6*P6","v":4},"No Change"]
[null,4,"Failure in adhering to legal compliance, especially in relation to immigration","DD","Head of HR Business Partnering","Reputational damage\n\nInability to recruit international staff as a consequence of loss of UKVI license if legal breach occurs and license revoked.",3,3,"n",{"$f":"IF(K7<4,\"GREEN\",IF(AND(K7>3,K7<7),\"YELLOW\",IF(AND(K7>7,K7<10),\"AMBER\",IF(AND(K7>9,K7<17),\"RED\",\"ERROR\"))))","v":"AMBER"},9,"Treat","Continued subscription to UKVI premium service and continuing to seek their advice on a case by case basis where appropriate  \n\nEnsuring guidance issued by the UKVI is communicated and cascaded through HR and relevant University teams.  ","In place\n\n\n\nIn place",2,2,"n",{"$f":"IF(S7<4,\"GREEN\",IF(AND(S7>3,S7<7),\"YELLOW\",IF(AND(S7>7,S7<10),\"AMBER\",IF(AND(S7>9,S7<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O7*P7","v":4},"No Change"]
[null,5,"Deterioration in Employee Relations including potential of industrial dispute.","DoPeople","DoPeople /\nCFO","Adverse impact on student experience \n\nDetrimental impact on University's  reputation \n\nAdverse impact on industrial relations/ partnership working with the Campus Trade Unions ",3,3,"n",{"$f":"IF(K8<4,\"GREEN\",IF(AND(K8>3,K8<7),\"YELLOW\",IF(AND(K8>7,K8<10),\"AMBER\",IF(AND(K8>9,K8<17),\"RED\",\"ERROR\"))))","v":"AMBER"},9,null,"Meetings of the Industrial Action Working Group to manage the impact\n\nRegular meetings between management and the Campus Trade Unions \n\nGuidance and FAQ for staff and managers \n\nReward Consulation and Negotiation Group established","In progress\n\nIn progress \n\nIn progress      \n\n\n\nIn progress    ",2,2,"n",{"$f":"IF(S8<4,\"GREEN\",IF(AND(S8>3,S8<7),\"YELLOW\",IF(AND(S8>7,S8<10),\"AMBER\",IF(AND(S8>9,S8<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O8*P8","v":4},"No Change"]
[null,6,"Transition to hybrid working arrangements and return to campus impacting on staff performance/outputs, staff morale, staff engagement and student experience. \n","DoPeople","Head of HR Business Partnering/\nHead of Organis. Developm. HR","Loss of output\n\nProjects stall\n\nStaff satisfaction drops\n\nIncreased stress for staff concerned about not being able to deliver all aspects of role\n\nImpact on service delivery and student experience ",3,3,"n","AMBER",9,"Treat","Staff survey undertaken and action plans being taken forward.  Planning for next survey commencing\n\nWorkload Planning Review Group\n\nOngoing consideration of adjusting priorities/delaying activity as appropriate\n\nFlexibility offered to staff (method and extent informed by survey results, sectoral and government advice\n\nA range of wellbeing support available (Wellbeing Toolkit)\n\nStrategies to manage user expectations (staff, students, community) and/or to adapt (or buy in) services to suit availability of staff","Ongoing\n\nOngoing\n\n\nIn place\n\n\nIn place\n\n\nIn place\n\nIn progress",2,2,"n","YELLOW",4,"No Change"]
[null,7,"Compliance with EDI legal and regulatory obligations, including Public Sector Equality Duty and SFC requirements and the development of a fully inclusive environment for staff and students.","DoPeople","Head of Organis. Developm. HR","Non-compliance with legislation\n\nNon-compliance with E&D policies",3,3,"n","AMBER",9,"Treat","Equality, Diversity and Inclusion Committee continues to meet ensuring progress against the Aberdeen 2040 action plan/inclusive theme and wider strategic matters relating to EDI.\n\nProduce Mainstreaming and Equality Outcome Reports biannually\n\nAthena SWAN awards, Race Equality Charter, Stonewall Workplace Equality Index\n\nBSL Policy \nGender Pay Gap Reporting\n\nSFC iGAP -  now not required by SFC\n\nE&D training (incl. Unconscious bias)\n\nEmbed E&D in all activities\n\nProtected Characteristics data collection and reporting\n\nPromote internal diversity networks\n\nSupport AUSA\n\nMental health and wellbeing Strategy implementation\n\nDevelopment of Gender Based Violence policy and action plan and implemtation of the Equally Safe in HE toolkit\n\nDignity at Work and Study Toolkit\n\nCompliance with REF E&D requirements\n\nAntiracism Strategy  approved by Court and implementation to be undertaken\nTackling Racial Harassment Action plan","In place\n\nIn place\n\n\nIn place\n\n\nIn place \n\n\nIn place\n\nIn progress\n\nIn progress\n\nIn progress\n\nIn progress\n\nIn progress\n\nIn progress\n\nIn progress\n\nIn progress\n\nIn place\n\nIn progress                    \n\n\nIn progress                                                   ",1,2,"n","GREEN",2,"No Change"]
[null,null,null,null,null,null,null,null,"n","GREEN",{"$f":"G11*H11","v":0},null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]

{"sheet":"Health, Safety, Wellbeing & Res","index":11,"n_rows":16,"n_cols":20,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,5],[2,8,2,10],[2,16,2,18]]}
[null,"Strategic Risk Area:",null,"Health, Safety, Wellbeing & Resilience",null,null,"(Staff and Students)"]
[]
[null,"No.","Risk  (what could happen)","Risk Owner","Risk Manager","Consequences (how would this affect the University)","Likelihood","Impact","Unmitigated Score\n(gross)",null,null,"Response","Mitigations (what is being/has been done to control the risk) ","Status (in place/in progress/under consideration)","Likelihood","Impact","Mitigated Score\n(net)",null,null,"Risk Movement"]
[null,1,"Failure to progress day-to-day health and safety management (including fire safety)","US & COO","DoPeople","Non-compliance",3,3,"n",{"$f":"IF(K4<4,\"GREEN\",IF(AND(K4>3,K4<7),\"YELLOW\",IF(AND(K4>7,K4<10),\"AMBER\",IF(AND(K4>9,K4<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"G4*H4","v":9},"Treat","Estates and Facilities will continue to carry out statutory checks as far as possible (partially dependent on contractors)","In progress",2,2,"n",{"$f":"IF(S4<4,\"GREEN\",IF(AND(S4>3,S4<7),\"YELLOW\",IF(AND(S4>7,S4<10),\"AMBER\",IF(AND(S4>9,S4<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O4*P4","v":4},"No Change"]
[null,2,"Failure to complete or review fire risk assessments for all University-owned or occupied premies","US & COO","DoPeople","Non-compliance",3,3,null,{"$f":"IF(K5<4,\"GREEN\",IF(AND(K5>3,K5<7),\"YELLOW\",IF(AND(K5>7,K5<10),\"AMBER\",IF(AND(K5>9,K5<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"G5*H5","v":9},"Treat","Health and Safety Adviser continues to carry out assessments to agreed priorities.  ","in progress",2,2,"n",{"$f":"IF(S5<4,\"GREEN\",IF(AND(S5>3,S5<7),\"YELLOW\",IF(AND(S5>7,S5<10),\"AMBER\",IF(AND(S5>9,S5<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O5*P5","v":4},"New Risk"]
[null,3,"Students with disabilities do not have appropriate adjustments at home to be able to study effectively","TS","VP E","Drop in grades or unable to complete work\n\nImpact on health and wellbeing",3,3,"n",{"$f":"IF(K6<4,\"GREEN\",IF(AND(K6>3,K6<7),\"YELLOW\",IF(AND(K6>7,K6<10),\"AMBER\",IF(AND(K6>9,K6<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"G6*H6","v":9},"Treat","Survey to students has been issued\n\nFurther survey to disabled students considered\n\nFunding available to students through Hardship Fund to purchase additional equipment\n\nExisting support and access to DSA is still available and has been enhanced with additional staffing in Dec.2020.","In place\n\nUnder consideration\n\nIn place\n\n\nIn place",2,2,"n",{"$f":"IF(S6<4,\"GREEN\",IF(AND(S6>3,S6<7),\"YELLOW\",IF(AND(S6>7,S6<10),\"AMBER\",IF(AND(S6>9,S6<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O6*P6","v":4},"No Change"]
[null,4,"Significant Failure of Health and Safety Management leading to fatality, injury or illhealth arising from University activities on campus and elsewhere. ","US & COO","DoPeople","Injury, work related illhealth, enforcement action, civil claims and reputational damage. ",3,3,"n","AMBER",9,"Treat","Health and safety management overseen by quarterly H&S Committee meetings (and sub-committees)\n\nH&S Risk Register in place\n\nH&S Policy Review Programme\n\nRegular H&S communications to staff and students\n\nMandatory induction and training undertaken\n\nMonitoring of accidents and incidents in place\n\nH&S audit programme\n\n","Ongoing\n\n\nIn place\n\nIn place\n\nIn place\n\nIn place\n\nIn place\n\nin place",2,2,"n","YELLOW",4,"No Change"]
[null,5,"Insufficient business continuity and emergency response arrangements","US & COO","DoPeople","Failure to meet duty of care in an emergency\n\nLoss of income\n\nReputational damage",3,3,"n","AMBER",9,"Treat","Resilience Advisory Group oversees arrangements\n\nBusines Impact Assessments carried out\n\nBC Plans in place\n\nPlans exercise to agreed programme","In place\n\nin place\n\nin place\n\nin place",2,2,"n","YELLOW",4,"No Change"]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]

{"sheet":"International Partnerships","index":12,"n_rows":25,"n_cols":20,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,5],[2,8,2,10],[2,16,2,18]]}
[null,"Strategic Risk Area:",null,"International Partnerships"]
[]
[null,"No.","Risk  (what could happen)","Risk Owner","Risk Manager","Consequences (how would this affect the University)","Likelihood","Impact","Unmitigated Score\n(gross)",null,null,"Response","Mitigations (what is being/has been done to control the risk) ","Status (in place/in progress/under consideration)","Likelihood","Impact","Mitigated Score\n(net)",null,null,"Risk Movement"]
[null,1,"Inadequate response to the management of international security risks, outside interference with research and academic discourse, and challenges to the protection of human rights and the University's core values.","VP GR","TNE Manager","Failure to protect intellectual proprerty rights\n\nExposure to the potential actions of politically or ideologically motivated individuals and state influence. \n\nFailure to safeguard the transfer of personal data in international partnerships\n\nFailure  to recognise the need for the protection of the rights and privacy of staff and students in the use of their data. \n\nFailure to comply with anti-bribery and anti-corruption measures\n\nFailure to safeguard the acdemic freedom of the University and its staff \n\nFailure to protect the human rights of students and staff.",4,4,"n",{"$f":"IF(K4<4,\"GREEN\",IF(AND(K4>3,K4<7),\"YELLOW\",IF(AND(K4>7,K4<10),\"AMBER\",IF(AND(K4>9,K4<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"G4*H4","v":16},"Treat","Establish TFG to scope immediate actions and project work to implement UUKi guidelines for the management of international security risk.\n\nProactive management of cyber security attack risk\n\nIntellectual Property policies in place and incorporated into partnership agreements\n\nPolicies in place on freedom of speech and academic freedom, for incorporation into partneship agreements\n\nIncorporation of international security issues in transnational project approval and monitoring\n\nDevelop guidance and process for registration of projects/partnertships under the National Security Investment Act 2021 (retrospective to 2020)\n\nSafeguards for international data transfers in agreements with partners and liaison with data protection professionals when formulating agreements.\n\nEnsure all partnership agreements have sufficient termination clauses, that due diliegence is refreshed on their consideration for renewal, and that a dedicated exit strategy exists and is regularly reviewed.","In progress (target July 2022)\n\n\nIn place\n\nIn place\n\n\nUnder consideration\n\n\nUnder consideration \n\n\nUnder consideration\n\n\n\nIn progress (target July 2022)\n\n\nIn progress (target July 2022). ",3,4,"n",{"$f":"IF(S4<4,\"GREEN\",IF(AND(S4>3,S4<7),\"YELLOW\",IF(AND(S4>7,S4<10),\"AMBER\",IF(AND(S4>9,S4<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"O4*P4","v":12},"No Change"]
[null,2,"Existing partnerships are impacted by changes in higher education policy emanating from governmental organisations (such as the Chinese Ministry of Education) ","VP GR","Dean for International Student Pathways & Progression","Obstruction to partnership operating models and business plans\n\nInability to deliver or contribute to academic programmes  \n\nDamage to relationships with policy authorities, partner institutions and other stakeholders\n\nDamage to reputation and future relationships\n\nLoss of income",4,4,"n","RED",{"$f":"G5*H5","v":16},"Treat","Develop stronger and more formal relationships with key government stakeholders.\n\nWork in partnership with other Scottish universities through Universities Scotland to strengthen relationships with international government organisations.\n\nMaintain strong communication links with partners.\n\nContinually review external environment informed by market intelligence\n\nWork with Universities Scotland and partners incuding SCNU to respond to changes in CSCSE policy regarding 'one third rule'.\n\nEnsure all partnership agreements have sufficient termination clauses, that due diliegence is refreshed on their consideration for renewal, and that a seperate exit strategy exists and is regularly reviewed.\n\n\n","In progress \n\n\nIn place\n\n\n\nIn place\n\nIn place\n\n\nIn progress (target August 2022)\n\n\nIn progress (target August 2022)",4,3,"n",{"$f":"IF(S5<4,\"GREEN\",IF(AND(S5>3,S5<7),\"YELLOW\",IF(AND(S5>7,S5<10),\"AMBER\",IF(AND(S5>9,S5<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"O5*P5","v":12},"Up"]
[null,3,"Instability in the external environment, due to economic, geopolitical, military, or public health factors causing disruption to partnership activity in affected parts of the world, and to wider international relationships. ","VP GR","TNE Manager","Inability to undertake international travel for visits to international partners for partnership governance, recruitment and conversion purposes\n\nDisruption to political and and business relationships in key markets, impacting on business continuity \n\nObstructions to financial payments from patners due to financial or currency controls, and/or exchange rate fluctuations\n\nLoss of income and/or access to student recruitment in key markets\n\nDeleterious impact on the student experience, and potential disruption to student progression and completion",2,4,"n",{"$f":"IF(K6<4,\"GREEN\",IF(AND(K6>3,K6<7),\"YELLOW\",IF(AND(K6>7,K6<10),\"AMBER\",IF(AND(K6>9,K6<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"G6*H6","v":8},"Treat","Monitoring of international diplomatic, military and geopolitical tensions and their potential consequences \n\nMonitoring of the regional political, economic and socio-cultural conditions in areas of significant partnership activity \n\nMaintaining strong communication links with partners to provide early awareness of changes in their external environments.\n\nMonitoring of the external environment informed by market intelligence and liaison with FCDO, UUKi and other bodies.\n\nDiversification of international partnership activity by georaphical region, gepoloitical alignment, and ecomonic interdependency.\n\nEnsure all partnership agreements have sufficient termination clauses, that due diliegence is refreshed on their consideration for renewal, and that a seperate exit strategy exists and is regularly reviewed for each.\n","In place\n\n\nIn place \n\n\n\nIn place\n\n\n\nIn place\n\n\nUnder consideration\n\n\n\nIn progress (target August 2022)\n",3,4,"n",{"$f":"IF(S6<4,\"GREEN\",IF(AND(S6>3,S6<7),\"YELLOW\",IF(AND(S6>7,S6<10),\"AMBER\",IF(AND(S6>9,S6<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"O6*P6","v":12},"Up"]
[null,4,"Objectives and projected growth for the AFG College with the University of Aberdeen partnership in Qatar are not fully realised.","VP GR","TNE Manager","Failure to deliver student recruitment growth and broadening of academic portfolio\n\nDisruption to academic provision and deleterious impact on the student experience.\n\nDisruption to the recruitment of potential future students.\n\nReputational damage in-country with Ministry of Education and Higher Education (MoEHE)\n\nProblems in the relationship with AFG College.\n\nInability to approve or proceed with the planned Phase 2 expansion of activity.\n\nFailure to realise potential income growth.",4,3,"n",{"$f":"IF(K7<4,\"GREEN\",IF(AND(K7>3,K7<7),\"YELLOW\",IF(AND(K7>7,K7<10),\"AMBER\",IF(AND(K7>9,K7<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"G7*H7","v":12},"Treat","Establishment of new governance structures and  Partnership Management Group.\n\nEstablish Partnership Develpoment Plan and associated KPIs, and close monitoring of student recruitment outturns and projections.\n\nRegular contact between senior representatives of the University and AFG College.\n\nConclusion of new Academic Cooperation Agreement and updating of due diligence prior to resigning.\n\nIdentify additional market relevant programmes supported by market research and local intelligence for applications to MoEHE. \n\nSecure critical path timeline from AFG College for Phase Two New Premises construction and campus opening\n\nRefreshing of exit strategy, and careful attention to termination clauses in ACA, for enactment if required.","In place \n\n\nIn place\n\n\n\nIn place\n\n\nIn progress (target June 2022)\n\nIn place\n\n\n\nIn progress (target June 22)\n\nUnder Consideration (exit strategy)\n\n\n\n\n",3,3,"n",{"$f":"IF(S7<4,\"GREEN\",IF(AND(S7>3,S7<7),\"YELLOW\",IF(AND(S7>7,S7<10),\"AMBER\",IF(AND(S7>9,S7<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"O7*P7","v":9},"No Change"]
[null,5,"Failure to develop existing partnerships and deliver new partnerships for the recruitment of international undergraduate students through articulation arrangements.","VP GR","Dean for International Student Pathways & Progression","Loss of tuition fee income \n\nFailure to diversify articulation opportunities across academic disciplines and subject areas\n\nIncreased exposure to dependence on articulation from a small number of parrtnerships \n\nIncreasing exposure to shifts in geopolitical tensions, economic circumstances, and student demand\n\nLoss of goodwill with international partners and government stakeholders\n\nNegative impact on reputation and future relationships\n\n",3,3,"n","AMBER",{"$f":"G8*H8","v":9},"Treat","Processes in place to ensure appropriate partnership governance and regular communication \n\nEngagement with articulation partner senior staff to maintain positive strategic relationships \n\nLiaising with partners to ensure appropriate information is available to partners and prospective students\n\nPartner engagement and student outreach to encourage conversion of students to transfer to Aberdeen for study \n\nMaintaining regular communication with articulation partners for the purposes of forward student number projections\n\nExplore new pathways and routes to study with existing partners through regular and open dialogue\n\nWork with third parties such as the British Council to explore new articulation markets and partners","In place\n\n\nIn place\n\n\nIn place\n\n\nIn place\n\n\nIn progress\n\n\nIn progress\n\n\nUnder consideration",2,2,"n",{"$f":"IF(S8<4,\"GREEN\",IF(AND(S8>3,S8<7),\"YELLOW\",IF(AND(S8>7,S8<10),\"AMBER\",IF(AND(S8>9,S8<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O8*P8","v":4},"No Change"]
[null,6,"Failure to deliver the full implementation of the Joint Institute for Data Science and Artificial Intelligence with SCNU.","VP GR","SCNU Project Sponsor (G Gordon)","Loss of income under revenue sharing arrangements\n\nLoss of goodwill with partners and government stakeholders \n\nCompromised ability to further develop activity with the partner\n\nDamage to relationship with Chinese Ministry of Education and prospects of approval for future activity in China\n\nReputational damage and negative impact on appetite for future collaborative opportunities\n\nDeleterious impact on the student experience.",4,3,"n","RED",{"$f":"G9*H9","v":12},"Treat","Liaising with the partners to ensure appropriate information is available to support the recruitment and conversion of prospective students\n\nEffective governance arrangements in place with appropriate committee structure and regular monitoring of student numbers projections\n\nRelationship management involving direct engagement at a senior and distributed management level with counterparts across the partner institutions.\n\nPlanning for the recruitment of academic and professional support staff at both SCNU and Aberdeen for the full delivery of the three programmes of study\n\nMembership of the UK-China Joint Institute Alliance for the sharing of experience and effective practice in the operation of JIs.\n\n","In place\n\n\n\nIn place \n\n\n\nIn place \n\n\n\nIn progress (target September 2022)\n\n\n\nIn place",2,2,"n",{"$f":"IF(S9<4,\"GREEN\",IF(AND(S9>3,S9<7),\"YELLOW\",IF(AND(S9>7,S9<10),\"AMBER\",IF(AND(S9>9,S9<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O9*P9","v":4},"No Change"]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n",{"$f":"IF(S10<4,\"GREEN\",IF(AND(S10>3,S10<7),\"YELLOW\",IF(AND(S10>7,S10<10),\"AMBER\",IF(AND(S10>9,S10<17),\"RED\",\"ERROR\"))))","v":"GREEN"},{"$f":"O10*P10","v":0}]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,7,"Fundamental failings in the partnership relationship, or in delivery by the partner, which undermine the effective functioning of the University's operations in Qatar.\n","VP GR","TNE Manager","Unilateral actions by major stakeholders are destabilising or pose existential threat to the partnership\n\nFailure of AFG College staff to engage with University staff to support the partnership\n\nFailure of University staff to engage with UoA staff to support the partnership\n\nColleagues at all levels of the partnership do not deliver their responsibilities in accordance with the Agreement and for the mutual benefit of the partnership.\n\nNegative consequences for the staff and student experience, and for student outcomes\n\nNegative impact and reputational damage \n\nPotential loss of income to the University from Phase 1 of the relationship with AFG.\n\n",3,4,"n",{"$f":"IF(K22<4,\"GREEN\",IF(AND(K22>3,K22<7),\"YELLOW\",IF(AND(K22>7,K22<10),\"AMBER\",IF(AND(K22>9,K22<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"G22*H22","v":12},"Treat","Robust governance structures that are fit for purpose and circumscribe the latitude for unilateral actions by either party. \n\nClose joint working between the partners through QSPB and QPMG and their co-chairing, with regular well-structured and well-documented discussions and decisions\n\nEffective relations are maintained at all levels of the partnership through ongoing liaison to ensure a close\ncollaborative working relationship.Inclusion of AFG colleagues in appropriate decision-making structures of the University\n\nAcademic Cooperation Agreement (ACA; the contract) ensures roles and responsibilities and lines of communication are clearly articulated in all aspects of operation (e.g. quality, financial, operational etc.)\n\nACA stipulates issue resolution processes and grounds for the exercise of break clauses, which are clearly defined and clarify teaching out arrangements in the event of early termination.\n\nRefreshing of exit strategy, and careful attention to termination clauses in ACA, to be ready for enactment if required.\n\n","In place\n\n\n\nIn place\n\n\n\n\nIn place\n\n\n\n\n\nIn progress (target July 2022)\n\n\n\nIn place\n\n\n\n\nIn progress (target August 2022)",3,3,"n",{"$f":"IF(S22<4,\"GREEN\",IF(AND(S22>3,S22<7),\"YELLOW\",IF(AND(S22>7,S22<10),\"AMBER\",IF(AND(S22>9,S22<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"O22*P22","v":9},"Up"]
[null,8,"Failure to deliver maximum benefit from foundation study pathway arrangements with Study Group for the progression of international students. ","AS","Dean for International Stakeholder Engagement","Los of potential tuition fee revenue from foregone articulations to the University's full programmes\n\nFailure to deliver business case objectives for the foundation pathway partnership with Study Group \n\nNegative consequences for the working relationship with StudyGroup, and existential threat to continuation of the relationship.\n\nLack of recovery on the University's investment to enable Study Group operations on campus.\n\nDeleterious impact on the student experience from small cohort sizes",3,3,"n",{"$f":"IF(K23<4,\"GREEN\",IF(AND(K23>3,K23<7),\"YELLOW\",IF(AND(K23>7,K23<10),\"AMBER\",IF(AND(K23>9,K23<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"G23*H23","v":9},"Treat","International Study Centre in operation and suported by effective staffing resorce from both Study Group and the University \n\nEffective governance arrangements in place with appropriate committee structure and regular monitoring of student numbers projections.\n\nClose liaison with regard to market conditions, horizon scanning, and new devopment opportunities. \n\nContinually seeking new pathways and routes with existing partners\n\n","In place\n\n\n\nIn place\n\n\n\nIn place\n\n\n\n\n\n",1,2,"n",{"$f":"IF(S23<4,\"GREEN\",IF(AND(S23>3,S23<7),\"YELLOW\",IF(AND(S23>7,S23<10),\"AMBER\",IF(AND(S23>9,S23<17),\"RED\",\"ERROR\"))))","v":"GREEN"},{"$f":"O23*P23","v":2},"No Change"]
[null,9,"Failure to secure appropriate and effective bilateral agreements to support the international mobility of students. ","VP E","DoER","Impairment of employability enhancing opportunities for current and future students \n\nInability to deliver programme experience options as advertised, with potential regulatory and legal consequences. \n \nLoss of goodwill with partners and  stakeholdersimpacting negatively on reputation and future relationships\n\nMobility arrangements are not effectively governed leading to potential legal and  insurance risk consequences.\n\nDeleterious impact on the student experience.",3,3,"n",{"$f":"IF(K24<4,\"GREEN\",IF(AND(K24>3,K24<7),\"YELLOW\",IF(AND(K24>7,K24<10),\"AMBER\",IF(AND(K24>9,K24<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"G24*H24","v":9},null,"Identify scale and scope of mobility arrangements previously governed by Erasmus+ arrangements that require to be replaced.\n\nEstablish most efficient yet robust approach and timescales for replacing collective mobility agreements with bilateral agreements with partner institutions\n\nEnsure mobility agreements set clear expectations (strategic intent) for the relationship, and review dates for agreement review and renewal.\n\nEnsure mobility agreements reflect degree of exposure to risk, and provide for safe facilitation of matters such as data exchange.","In place \n\n\n\nIn place \n\n\n\nIn progress (target August 2022)\n\n\nIn progress (target August 2022)\n\n\n",2,3,"n",{"$f":"IF(S24<4,\"GREEN\",IF(AND(S24>3,S24<7),\"YELLOW\",IF(AND(S24>7,S24<10),\"AMBER\",IF(AND(S24>9,S24<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O24*P24","v":6},"New Risk"]
[null,10,"Failure to develop and maintain existing strategic alliances ","KL","TNE Manager","Reputational impact\n\nFailure to benefit from income-generating partnerships that may arise from strategic alliances\n\nPoor communication/strained relationship between the partners",2,3,"n",{"$f":"IF(K25<4,\"GREEN\",IF(AND(K25>3,K25<7),\"YELLOW\",IF(AND(K25>7,K25<10),\"AMBER\",IF(AND(K25>9,K25<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"G25*H25","v":6},"Treat","Reputational impact\n\nFailure to benefit from income-generating opportunities that may arise from strategic alliances\n\nPoor communication/strained relationship between the partners","Ongoing\n\n\nOngoing\n\n\nOngoing\n\n\nIn progress (target TBC)",1,1,"n",{"$f":"IF(S25<4,\"GREEN\",IF(AND(S25>3,S25<7),\"YELLOW\",IF(AND(S25>7,S25<10),\"AMBER\",IF(AND(S25>9,S25<17),\"RED\",\"ERROR\"))))","v":"GREEN"},{"$f":"O25*P25","v":1},"No Change"]

{"sheet":"Reputation","index":13,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,5],[2,8,2,10],[2,16,2,18]]}
[null,"Strategic Risk Area:",null,"Reputation"]
[]
[null,"No.","Risk  (what could happen)","Risk Owner","Risk Manager","Consequences (how would this affect the University)","Likelihood","Impact","Unmitigated Score\n(gross)",null,null,"Response","Mitigations (what is being/has been done to control the risk) ","Status (in place/in progress/under consideration)","Likelihood","Impact","Mitigated Score\n(net)",null,null,"Risk Movement"]
[null,1,"Lack of ownership and understanding of reputation at an institutional and School level","DoER","TBC - Head of Marketing and Brand Development","Impact on league table performance\n\nSchools and Directorates do not recognise the challenge associated with reputation and do not embed it in decision making and planning.\n\nLack of governance, ownership and co-ordination\n\nLack baseline data to measure performance and understand the historical context",2,3,"n",{"$f":"IF(K4<4,\"GREEN\",IF(AND(K4>3,K4<7),\"YELLOW\",IF(AND(K4>7,K4<10),\"AMBER\",IF(AND(K4>9,K4<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"G4*H4","v":6},"Treat","Data gathering and research to support understanding of reputation and provide evidence to support action planning\n\nBenchmarking of reputational data\n\nSchool and Directorate planning process   \n\nTraining and development to support understanding reputation management and brand messaging\n\nIncreased visibility of External Relations team","In progress\n\n\nIn progress\n\nIn progress\n\nUnder consideration\n\n\nIn progress\n\n\n",1,1,"n",{"$f":"IF(S4<4,\"GREEN\",IF(AND(S4>3,S4<7),\"YELLOW\",IF(AND(S4>7,S4<10),\"AMBER\",IF(AND(S4>9,S4<17),\"RED\",\"ERROR\"))))","v":"GREEN"},{"$f":"O4*P4","v":1},"No Change"]
[null,2,"Failures to perform in League Tables","SVP","Director of Planning / Director of External Relations","Impacts on the institutions ability to attract and retain the best staff and students\n\nUndermines strategic priorities of the institution, including financial sustainability and fundraising",2,3,"n",{"$f":"IF(K5<4,\"GREEN\",IF(AND(K5>3,K5<7),\"YELLOW\",IF(AND(K5>7,K5<10),\"AMBER\",IF(AND(K5>9,K5<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"G5*H5","v":6},"Treat","Further review and proactive monitoring of HESA data from planning\n\nContinue analytical work to understand research data more fully, with investigation of opportunities for international benchmarking\n\nPlanning will proactively engage with individual schools and will offer School meetings/presentations discuss league table results in greater detail. \n\nFurther enhance league table reporting beyond what is provided in 2020/21 so as to provide as much insight as possible.\n\nContinued consideration of Reputational scores through (i)  maximising QS contact lists for academics and employers and (ii) engagement with ER re. external data analysis to be carried out on promotional activities relating to academic and research reputation.\n\nPlanning to support Schools and Professional Services through providing context to the league table analytics appropriate to their area.","In progress\n\nIn progress\n\n\nIn progress\n\n\n\nIn progress\n\n\nIn progress\n\n\n\n\nIn progress\n\n\n",1,1,"n",{"$f":"IF(S5<4,\"GREEN\",IF(AND(S5>3,S5<7),\"YELLOW\",IF(AND(S5>7,S5<10),\"AMBER\",IF(AND(S5>9,S5<17),\"RED\",\"ERROR\"))))","v":"GREEN"},{"$f":"O5*P5","v":1},"New Risk"]
[null,3,"Reputational damage resulting from the behaviours or actions of a staff member, student,  alumni or associated 3rd party (e.g. AUSA or AFG), single incident e.g. data breach or wider issue with non-compliance with good governance or legal requirements.","DoER","JP (Head of Comms)","Refocuses narrative with key stakeholders, including the press and political stakeholders, impacting negatively on the perception of the institution's reputation\n\nUndermines wider institutional achievements\n\nImpacts the institutional ability to attract and retain the best staff and students, and potential partners\n\nUndermines strategic priorities of the institution, including financial sustainability and fundraising",3,3,"n",{"$f":"IF(K6<4,\"GREEN\",IF(AND(K6>3,K6<7),\"YELLOW\",IF(AND(K6>7,K6<10),\"AMBER\",IF(AND(K6>9,K6<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"G6*H6","v":9},"Treat","Encourage culture of openness and transparency such that staff / students / alumni to surface any issues early, and proactively develop strategy to respond to any reputational issues.\n\nFirefighting to support rapid response to issues which may arise\n\nUtilise social media listening tool to support horizon scanning.\n\nConsolidate and enhance relationships with media contacts","Ongoing\n\nOngoing\n\nIn place\n\nOngoing",3,3,"n",{"$f":"IF(S6<4,\"GREEN\",IF(AND(S6>3,S6<7),\"YELLOW\",IF(AND(S6>7,S6<10),\"AMBER\",IF(AND(S6>9,S6<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"O6*P6","v":9},"No Change"]
[null,4,"External environmental factors impact on the HE sector, and reputational challenge at a sector level impacts on the specifically the University reputation (e.g. Brexit)  ","DoER","Head of Public Affairs and Stakeholder Engagement","Impact on the ability to attract funding\n\nNegative impact on the policy environment",2,3,"n",{"$f":"IF(K7<4,\"GREEN\",IF(AND(K7>3,K7<7),\"YELLOW\",IF(AND(K7>7,K7<10),\"AMBER\",IF(AND(K7>9,K7<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"G7*H7","v":6},null,"Ensure proactive horizon scanning to ensure the institution is live to sector wide issues and challenges\n\nEnsure proactive engagement with policy makers to ensure understanding of the impact and societal benefit the University supports\n\nLink across with the regional agenda and civic university agreement.","In progress\n\n\nIn progress\n\n\n\nIn progress",1,1,"n",{"$f":"IF(S7<4,\"GREEN\",IF(AND(S7>3,S7<7),\"YELLOW\",IF(AND(S7>7,S7<10),\"AMBER\",IF(AND(S7>9,S7<17),\"RED\",\"ERROR\"))))","v":"GREEN"},{"$f":"O7*P7","v":1},"New Risk"]
[null,5,"A gap develops between the institutional reputation i.e. how the University is perceived - either positively or negatively - by different stakeholder groups, and the underlying reality.","DoER","TBC - Head of Marketing and Brand Development","Impact on league table performance\n\nLack brand recognition and wider awareness\n\nReputation does not positively reflect reality of institutional position, impacting reach, recognition, access to funding and ability to attract and retain both staff and students\n\nFinancial sustainability",2,3,"n",{"$f":"IF(K8<4,\"GREEN\",IF(AND(K8>3,K8<7),\"YELLOW\",IF(AND(K8>7,K8<10),\"AMBER\",IF(AND(K8>9,K8<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"G8*H8","v":6},"Treat","Stakeholder map to understand our audiences\n\nReview ownership of Stakeholder map to ensure it proactively owned as a live document\n\nBuild data to measure perception of reputation for different stakeholder groups to build understanding of gaps.  This should include sentiment analysis\n\nBenchmark reputation data against peers to understand UoA reputational performance against that of benchmark group to inform decision making. \n\nCreate engagement toolkit\n\n\nReview brand portal and assets to support effective and consistent use of the brand\n\nRoll out stakeholder engagement programme ","In progress\n\nIn progress\n\nIn progress\n\n\nIn progress\n\n\nIn progress and ongoing\n\nIn progress\n\nIn progress and ongoing",3,3,"n",{"$f":"IF(S8<4,\"GREEN\",IF(AND(S8>3,S8<7),\"YELLOW\",IF(AND(S8>7,S8<10),\"AMBER\",IF(AND(S8>9,S8<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"O8*P8","v":9},"No Change"]
[null,6,"Predominant culture and focus on crisis communications to protect reputation, rather than proactive management of reputational risk i.e. a reactive approach to reputational issues which have already surfaced rather than a proactive approach to protect or advance reputation.","DoER","JP (Head of Comms)\nAM (Head of PASE)\nTBC (Head of Marketing and Brand Development)","Short-termism, reducing focus on longer terms planning to support reputational management \n\nLack of trust in UoA\n\nReduces credibility of strategic vision and its deliverability\n\nUndermines strategic priorities of the institution, including financial sustainability and fundraising",3,3,"n",{"$f":"IF(K9<4,\"GREEN\",IF(AND(K9>3,K9<7),\"YELLOW\",IF(AND(K9>7,K9<10),\"AMBER\",IF(AND(K9>9,K9<17),\"RED\",\"ERROR\"))))","v":"AMBER"},9,"Treat","Directorate and School planning process\n\nReview of data sharing to understand impact of reputational management (or lack of)\n\n\nTraining and development to build understanding of stakeholder holder engagement, reputational management and brand messaging","In progress\n\nUnder consideration\n\nUnder consideration",2,3,"n",{"$f":"IF(S9<4,\"GREEN\",IF(AND(S9>3,S9<7),\"YELLOW\",IF(AND(S9>7,S9<10),\"AMBER\",IF(AND(S9>9,S9<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},6,"No Change"]
[null,7,"Lack of brand awareness and brand integrity ","DoER","TBC (Head of Marketing and Brand Development)","Reduced ability to amplify institutional voice\n\nLack of differentiation and clear sense of University's purpose and benefits to different stakeholder groups\n\nFinancial impact \n\nInability to meet student recruitment targets\n",3,4,"n",{"$f":"IF(K10<4,\"GREEN\",IF(AND(K10>3,K10<7),\"YELLOW\",IF(AND(K10>7,K10<10),\"AMBER\",IF(AND(K10>9,K10<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"G10*H10","v":12},"Treat","Review brand \n\n\nConsider approach to digital, including University website and social media\n\nRoll out updated brand portal including toolkit of assets which be used\n\nMaintain visibility range of different tools - both digital and in person","Under consideration\n\nIn place\n\nIn progress\n\nOngoing",2,3,"n",{"$f":"IF(S10<4,\"GREEN\",IF(AND(S10>3,S10<7),\"YELLOW\",IF(AND(S10>7,S10<10),\"AMBER\",IF(AND(S10>9,S10<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O10*P10","v":6},"No Change"]
[null,8,"Failure to progress Aberdeen 2040, and to ensure appropriate and co-ordinated storytelling to demonstrate progress to both internal and external stakeholder groups.","DoER","JP (Head of Comms)\nAM (Head of PASE)\nTBC (Head of Marketing and Brand Development)","Lack of trust in UoA\n\nReduces credibility of strategic vision and its deliverability\n\nReduces institutional buy into strategic vision, undermining is deliverability\n\nUndermines strategic priorities of the institution, including financial sustainability and fundraising",3,3,"n","AMBER",9,"Treat","Aberdeen 2040 5-year planning process\n\n\nDirectorate and School planning process\n\n\nInternal training of brand training / messaging ","In progress and ongoing\n\nIn progress and ongoing\n\nUnder consideration",2,2,"n","YELLOW",4,"No Change"]
[null,9,"Lack of understanding at an institutional and departmental level of the key stakeholder groups, and as a consequence, an impaired ability to manage their associated expectations.","DoER","AM (Head of PASE","Inability to meet expectations of stakeholders as to role the University can play (e.g. regional stakeholders associated with regional economic regeneration)\n\nReduced ability to leverage external funding \n\nImpact on place-making aspect of Aberdeen e.g. loss of key festivals which support message around Aberdeen as a good place to live, work and study",2,2,"n","YELLOW",4,"Treat","Complete Stakeholder map and role out across Schools and Directorates\n\nIn conjunction with the VP Regional Engagement and Regional Recovery, ensure comprehensive programme of stakeholder engagement.  This will include the development and subsequent implementation of Civic University agreement.\n\nOngoing commitment to events programme which supports Aberdeen 2040 and wider regional engagement and profile.  \n\nRemain alert to funding and recovery packages made available and initiate early partnerships /collaborations.\n\nTraining and development to build understanding of stakeholder holder engagement, reputational management and brand messaging\n\n","In progress\n\nIn progress\n\n\nIn place\n\n\nOngoing\n\n\nUnder consideration\n",2,2,"n","YELLOW",4,"No Change"]
[null,10,"Reputational damage by association with unsuitable funder","US & COO","DoDT & Alumni","Loss of trust in University",3,3,"n","AMBER",9,null,"Ensure appropriate governance and due diligence of prospects and donors using existing structures – Compliance Committee, Board of Trustees, Gift Acceptance Policy, Ad hoc committee on gift acceptance, communication between Trust and University, and University’s Governance and Nominations Committee and naming of assets policy ","In place",2,2,"n","YELLOW",4,"New Risk"]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]

{"sheet":"External Environment","index":14,"n_rows":25,"n_cols":20,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,5],[2,8,2,10],[2,16,2,18]]}
[null,"Strategic Risk Area:",null,"External Environment"]
[]
[null,"No.","Risk  (what could happen)","Risk Owner","Risk Manager","Consequences (how would this affect the University)","Likelihood","Impact","Unmitigated Score\n(gross)",null,null,"Response","Mitigations (what is being/has been done to control the risk) ","Status (in place/in progress/under consideration)","Likelihood","Impact","Mitigated Score\n(net)",null,null,"Risk Movement"]
[null,1,"Global geo-political or health disruptions","US & COO","DoPlanning","Potential for multi-dimensional impacts on the University - students unable to access financial resources, disruption to supply chains, limitations on mobility of staff and students\n",3,4,"n",{"$f":"IF(K4<4,\"GREEN\",IF(AND(K4>3,K4<7),\"YELLOW\",IF(AND(K4>7,K4<10),\"AMBER\",IF(AND(K4>9,K4<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"G4*H4","v":12},"Treat","Risk assessment of recruitment markets                     \n\nIncreased contingency in project budgets.     \n\nDevelopment of framework for support for impacted individuals.      ","Under consideration       \n\nUnder consideration                       \n\nIn progress",3,4,"n",{"$f":"IF(S4<4,\"GREEN\",IF(AND(S4>3,S4<7),\"YELLOW\",IF(AND(S4>7,S4<10),\"AMBER\",IF(AND(S4>9,S4<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"O4*P4","v":12},"New Risk"]
[null,2,"Major constitutional change ","US & COO","DoPlanning","Potential for significant disruption to supply chains, mobility of students and distraction of policy makers or repriortisation of public funding.\nDistruptive impacts possible in run up to any referenda.\n",2,3,"n","YELLOW",6,"Treat","Active contingency planning in relation to supply chains and the potential for staffing and student recruitment impacts.\n\nReinforced promotion of University profile.","In progress",2,2,"n",{"$f":"IF(S5<4,\"GREEN\",IF(AND(S5>3,S5<7),\"YELLOW\",IF(AND(S5>7,S5<10),\"AMBER\",IF(AND(S5>9,S5<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O5*P5","v":4},"New Risk"]
[null,3,"SG review of the purpose of Tertiary Education fails to recognise HE wider contributions","US & COO","DoPlanning","Potential impact on funding for the sector and consequentially for UoA.     Potential for longer-term policy impacts if sector ambitions not seen to be aligned",2,4,"n","AMBER",8,"Treat","Regular communication with SFC, US, aiming to ensure sector engages\n\nScottish Planners and other sector bodies;\nDiscussions with regional partners","In place\n\n\nIn place\n\n",2,4,"n",{"$f":"IF(S6<4,\"GREEN\",IF(AND(S6>3,S6<7),\"YELLOW\",IF(AND(S6>7,S6<10),\"AMBER\",IF(AND(S6>9,S6<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"O6*P6","v":8},"New Risk"]
[null,4,"Significant UK policy changes impacting on staff or student recruitment, fees, or research funding.","US & COO","DoPlanning","Impact on student numbers and/or ability to recruit staff                      Reduction in fee income per head\nChange in access to research funding ",3,2,"n",{"$f":"IF(K7<4,\"GREEN\",IF(AND(K7>3,K7<7),\"YELLOW\",IF(AND(K7>7,K7<10),\"AMBER\",IF(AND(K7>9,K7<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"G7*H7","v":6},"Treat","Active engagement in relevant policy forums                                                  Active horizon scanning and contingency planning","In progress\nIn progress",2,2,"n",{"$f":"IF(S7<4,\"GREEN\",IF(AND(S7>3,S7<7),\"YELLOW\",IF(AND(S7>7,S7<10),\"AMBER\",IF(AND(S7>9,S7<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O7*P7","v":4},"No Change"]
[null,null,null,null,null,null,null,null,"n",{"$f":"IF(K8<4,\"GREEN\",IF(AND(K8>3,K8<7),\"YELLOW\",IF(AND(K8>7,K8<10),\"AMBER\",IF(AND(K8>9,K8<17),\"RED\",\"ERROR\"))))","v":"GREEN"},0,null,null,null,null,null,"n",{"$f":"IF(S8<4,\"GREEN\",IF(AND(S8>3,S8<7),\"YELLOW\",IF(AND(S8>7,S8<10),\"AMBER\",IF(AND(S8>9,S8<17),\"RED\",\"ERROR\"))))","v":"GREEN"},{"$f":"O8*P8","v":0}]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]

{"sheet":"Environmental Sustainability","index":15,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,5],[2,8,2,10],[2,16,2,18]]}
[null,"Strategic Risk Area:",null,"Environmental Sustainability"]
[]
[null,"No.","Risk  (what could happen)","Risk Owner","Risk Manager","Consequences (how would this affect the University)","Likelihood","Impact","Unmitigated Score\n(gross)",null,null,"Response","Mitigations (what is being/has been done to control the risk) ","Status (in place/in progress/under consideration)","Likelihood","Impact","Mitigated Score\n(net)",null,null,"Risk Movement"]
[null,1,"Emissions: Failure to make anticipated progress against institutional net-zero target e.g. campus fabric investment fails to deliver decarbonisation ambitions.\n\nLinks to Estates & Facilities capital programme and infrastructure resilience risks.\n\nNote: progress on the key mitigations (see *) should result in the mitigated risk score decreasing.","SVP","Dir E&F","Reputational impact if carbon reduction targets are not met\n\nLoss of credibility with external stakeholders, staff, students\n\nAssociated energy,  operational and lifecycle cost impacts / carbon taxes / off-setting charges\n\nNew builds fail to attain sufficiently robust environmental & emissions standards\n\nHard to treat old building stock is neglected\n\nOpportunities to participate in city-wide initiatives are missed e.g. district networks\n\nReliance on fossil fuels into the longer term",4,4,"n",{"$f":"IF(K4<4,\"GREEN\",IF(AND(K4>3,K4<7),\"YELLOW\",IF(AND(K4>7,K4<10),\"AMBER\",IF(AND(K4>9,K4<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"G4*H4","v":16},"Treat","Development of a net-zero definition and Implementation Plan *\n\nDevelopment and active management of a long-term net-zero project risk register *\n\nDevelopment of a Business Travel policy to target emissions reduction\n\nIdentification of and investment in appropriate expertise to take forward net-zero planning and projects *\n\nInitial allocation of net-zero project funding identified\n\nSustained investment over multiple years *\n\nWider review of Estate Strategy to include sustainability and stategic energy issues\n\nDiscussions with local partners about district heating and alternative heat sources e.g. hydrogen\n\nCampus Heating Project Board established\n\nHeating & Energy strategies being reviewed *\n\nDevelopment of Management Information to allow improvements works to be brought forward eg Condition Survey / Energy Survey","in progress\n\n\nin progress\n\n\nin progress\n\n\nin progress\n\n\n\nin place\n\n\nunder consideration\n\nin progress\n\n\nin progress\n\n\n\nin place\n\nin progress\n\nunder consideration\n\n\n",4,4,"n",{"$f":"IF(S4<4,\"GREEN\",IF(AND(S4>3,S4<7),\"YELLOW\",IF(AND(S4>7,S4<10),\"AMBER\",IF(AND(S4>9,S4<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"O4*P4","v":16},"No Change"]
[null,2,"Resourcing: Failure to adequately resource sustainability commitments or to secure staff with required expertise\n\nLinks to both the Staffing and Health, Safety & Wellbeing risks.","KL","Dir E&F","Inability to progress key projects\n\nInsufficient expertise to understand / address key technical challenges\n\nImpact on wellbeing and retention of existing staff",4,3,"n",{"$f":"IF(K5<4,\"GREEN\",IF(AND(K5>3,K5<7),\"YELLOW\",IF(AND(K5>7,K5<10),\"AMBER\",IF(AND(K5>9,K5<17),\"RED\",\"ERROR\"))))","v":"RED"},12,"Treat","Consideration given to appropriate resourcing by University Secretary / COO and SVP with authority to proceed given.\n\nIdentification of appropriate training for existing staff\n\nEmbedding of sustainability as part of job descriptions and appraisal process\n","in progress\n\n\n\nin progress\n\n\nin progress",3,3,"n",{"$f":"IF(S5<4,\"GREEN\",IF(AND(S5>3,S5<7),\"YELLOW\",IF(AND(S5>7,S5<10),\"AMBER\",IF(AND(S5>9,S5<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"O5*P5","v":9},"No Change"]
[null,3,"Reputation: Inability to demonstrate meaningful commitment to sustainability\n\nLinks to Reputation risk.","SVP","Hd of SD","Impact on staff and student recruitment and retention\n\nNegative media commentary\n\nDamage to local, national & international partnerships\n\nStudent protest and/or challenge\n\nLack of a co-ordinated approach to the Sustainable Development Goals\n\nImpacts negatively on SFC Outcome Agreement\n\nFailure to capitalise on opportunities e.g. regional colaboration, student engagement etc",3,3,"n",{"$f":"IF(K6<4,\"GREEN\",IF(AND(K6>3,K6<7),\"YELLOW\",IF(AND(K6>7,K6<10),\"AMBER\",IF(AND(K6>9,K6<17),\"RED\",\"ERROR\"))))","v":"AMBER"},9,"Treat","High visibility of senior leadership and key oversight role of Sustainable Development Committee\n\nAberdeen 2040 implementation plan to 2025 in place and evolving\n\nEnhanced capacity for sustainabiliy endorsed\n\nConsultation arrangements e.g. climate assembly, business travel focus groups\n\nFirst annual SDG Report published ('21)\n\nCommitment to THE Impact Ranking exercise\n","in place\n\n\n\nin place\n\n\nin progress\n\nin progress\n\n\nin place \n\nin place\n",2,3,"n",{"$f":"IF(S6<4,\"GREEN\",IF(AND(S6>3,S6<7),\"YELLOW\",IF(AND(S6>7,S6<10),\"AMBER\",IF(AND(S6>9,S6<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O6*P6","v":6},"No Change"]
[null,4,"Reporting: Failure to meet statutory and/or voluntary sectoral reporting requirements.","SVP","Hd of SD","Censure e.g. by SFC re Outcome Agreements\n\nMissed deadlines or weak submission e.g. PBCCD\n\nPoor league table performance e.g. THE Impact Ranking",3,3,"n",{"$f":"IF(K7<4,\"GREEN\",IF(AND(K7>3,K7<7),\"YELLOW\",IF(AND(K7>7,K7<10),\"AMBER\",IF(AND(K7>9,K7<17),\"RED\",\"ERROR\"))))","v":"AMBER"},9,"Treat","Horizon scanning and membership of sector bodies e.g. EAUC\n\nSustainable Develoment Goals (SDG) group established (covers THE Impact)\n\nSustainability content embedded in Annual Reporting / SDG Report published\n\nConsideration being given to appropriate resourcing (addressing single points of failure)","in place\n\n\nin place\n\n\nin place\n\n\nin progress",2,3,"n",{"$f":"IF(S7<4,\"GREEN\",IF(AND(S7>3,S7<7),\"YELLOW\",IF(AND(S7>7,S7<10),\"AMBER\",IF(AND(S7>9,S7<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},6,"No Change"]
[null,5,"Insufficient management of environmental standards\n\nLinks to Estates & Facilities compliance risks.","KL","Dir E&F","Inability to achieve emissions targets\n\nRisk of regulatory breaches e.g. pollution.\n\nSFC challenge\n\nReputational damage",3,3,"n",{"$f":"IF(K8<4,\"GREEN\",IF(AND(K8>3,K8<7),\"YELLOW\",IF(AND(K8>7,K8<10),\"AMBER\",IF(AND(K8>9,K8<17),\"RED\",\"ERROR\"))))","v":"AMBER"},9,"Treat","Sustainable Design Guide \n\nInfrastructure projects embed environmental sustainability e.g. via BREEAM\n\nRobust waste contracts \n\nRegular audits and external validation e.g. waste, energy","in progress\n\nin progress\n\n\nin place\n\nin place",2,3,"n",{"$f":"IF(S8<4,\"GREEN\",IF(AND(S8>3,S8<7),\"YELLOW\",IF(AND(S8>7,S8<10),\"AMBER\",IF(AND(S8>9,S8<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O8*P8","v":6},"No Change"]
[null,6,"Integration & Engagement: Failure to fully engage staff and student community in supporting institutional sustainability commitments.\n\nLinks to Education risk.","SVP","H of SD","Unable to adopt a genuinely shared responsibility for sustainability initiatives\n\nNecessary behaviour change is not secured\n\nStaff and students feel left out of process\n\nAberdeen 2040 commitments are not achieved\n",2,3,"n",{"$f":"IF(K9<4,\"GREEN\",IF(AND(K9>3,K9<7),\"YELLOW\",IF(AND(K9>7,K9<10),\"AMBER\",IF(AND(K9>9,K9<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},6,"Treat","Role of Sustainable Development Commiittee in ensuring shared responsibility \n\nConsultation and communication mechanisms being considered (e.g. climate assemblies)\n\nEnhanced capacity for sustainabiliy endorsed e.g. of behaviour change \n","in place\n\n\nin progress\n\n\nin progress",2,2,"n",{"$f":"IF(S9<4,\"GREEN\",IF(AND(S9>3,S9<7),\"YELLOW\",IF(AND(S9>7,S9<10),\"AMBER\",IF(AND(S9>9,S9<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O9*P9","v":4},"No Change"]
[]
[null,null,null,null,null,null,null,null,"n",{"$f":"IF(K11<4,\"GREEN\",IF(AND(K11>3,K11<7),\"YELLOW\",IF(AND(K11>7,K11<10),\"AMBER\",IF(AND(K11>9,K11<17),\"RED\",\"ERROR\"))))","v":"GREEN"},0,null,null,null,null,null,"n",{"$f":"IF(S11<4,\"GREEN\",IF(AND(S11>3,S11<7),\"YELLOW\",IF(AND(S11>7,S11<10),\"AMBER\",IF(AND(S11>9,S11<17),\"RED\",\"ERROR\"))))","v":"GREEN"},{"$f":"O11*P11","v":0}]
[null,null,null,null,null,null,null,null,"n","GREEN",{"$f":"G12*H12","v":0},null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]

{"sheet":"Leadership and Governance","index":16,"n_rows":16,"n_cols":20,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,5],[2,8,2,10],[2,16,2,18]]}
[null,"Strategic Risk Area:",null,"Leadership and Governance"]
[]
[null,"No.","Risk  (what could happen)","Risk Owner","Risk Manager","Consequences (how would this affect the University)","Likelihood","Impact","Unmitigated Score\n(gross)",null,null,"Response","Mitigations (what is being/has been done to control the risk) ","Status (in place/in progress/under consideration)","Likelihood","Impact","Mitigated Score\n(net)",null,null,"Risk Movement"]
[null,1,"Lack of effective engagement with Scottsh Government results in delayed removal of sector level Covid restrictions/loss of competitive advantage for the Scottish sector/University of Aberdeen","Principal","US & COO","Staff and student dissatisfaction\n\nLack of engagement\n\nDrop in motivation\n\nDrop in staff productivity\n\nReputational damage",2,4,"n",{"$f":"IF(K4<4,\"GREEN\",IF(AND(K4>3,K4<7),\"YELLOW\",IF(AND(K4>7,K4<10),\"AMBER\",IF(AND(K4>9,K4<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"G4*H4","v":8},"Treat","Engagement with Covid-leads network and on testing/vaccination/ventilation groups with Scottish Government.                                                                                                                                                                                                                                                                                                         Coronavirus Steering Group set up with sub-groups (replaced in end of April with a Covid-19 Campus Planning Group and various sub-groups) to manage effective implementation of covid restrictions\n\nRegular communication with staff and dedicated webpage set up\n\n\n","All in place                      ",2,3,"n",{"$f":"IF(S4<4,\"GREEN\",IF(AND(S4>3,S4<7),\"YELLOW\",IF(AND(S4>7,S4<10),\"AMBER\",IF(AND(S4>9,S4<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O4*P4","v":6},"Down"]
[null,2,"Delivery of the Aberdeen 2040 Strategy delayed due to staff workload and time pressures, or disrupted by external environment factors.","Principal","SVP","Reputational damage\n\nFinancial impact\n\nStaff satisfaction",4,3,"n","RED",12,"Treat","Institutional risk management and mitigations in place across the university to ensure that adequate resource is in place in all key areas to take forward delivery, and to facilitate effective management of staff workloads; ultimately reducing any potential impacts on the 20-year strategy.\n\nFor external factors, the University is engaged in horizon scanning on an ongoing basis, and undertakes scenario planning as part of its wider planning arrangements. As shown with Covid, the University has proven agile and effective in responding to disruptive changes in the external environment.\n\nAll mitigations associated with this risk will be kept under review to ensure effectiveness.  ","In progress        ",3,3,"n","AMBER",9,"Up"]
[null,4,"Membership of Court not sufficiently diverse to effectively reflect and govern the University community","US & COO","Head of Governance (TBC)","Lack of informed and constructive challenge to strategy development from perspective of diverse community. Reputational Damage ",2,2,"n","YELLOW",4,"Treat","Regular review of diversity of Court Membership  via Governance and Nominations Committee.  Prioritisation of greater diversity in Court recruitment has been agreed and commitments made in Court' Statement of Intent on Diversity","In Place",2,2,"n","YELLOW",4,"No Change"]
[null,5,"Failure to prioritise key measures (Widening Access) within the SFC Outcome Agreement process","US & COO","DoPlanning","Potential financial impact as funding is offered on condition that and OA meet the required standard\n\nImpact on the relationship with the SFC and the SG\n\nReputational impact\n",3,4,"n",{"$f":"IF(K7<4,\"GREEN\",IF(AND(K7>3,K7<7),\"YELLOW\",IF(AND(K7>7,K7<10),\"AMBER\",IF(AND(K7>9,K7<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"G7*H7","v":12},"Treat","Explicitly addressed as part of planning round considerations and at relevant Committees considering policy implementation.               Regular communication with SFC, US, \n\nScottish Planners and other sector bodies;\nDiscussions with regional partners","in place\n\n\nin place\n\n\nin place\n\nin place",3,2,"n",{"$f":"IF(S7<4,\"GREEN\",IF(AND(S7>3,S7<7),\"YELLOW\",IF(AND(S7>7,S7<10),\"AMBER\",IF(AND(S7>9,S7<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O7*P7","v":6},"No Change"]
[null,6,"Failure to engage with the regional stakeholders, NHS and businesses including through the Pathfinder implementation (SFC review of coherence and sustainability of the Scottish tertiary sector)","VP RR","DoER","Loss of political and policy influence as well as reputation if SFC perceived to be not engaged.                                                                                                          \n\nRelative disadvantage if funding mechanism adjusted as a consequence.\n\nAberdeen 2040 commitments undermined if excluded from regional partnership relationships.",3,3,"n",{"$f":"IF(K8<4,\"GREEN\",IF(AND(K8>3,K8<7),\"YELLOW\",IF(AND(K8>7,K8<10),\"AMBER\",IF(AND(K8>9,K8<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"G8*H8","v":9},"Treat","Active engagement with Regional Stakeholders and business leaders.         Re-establishment of liaison group with NHS around Foresterhill                               Regular communication with SFC, US, \n\nScottish Planners and other sector bodies;\nDiscussions with regional partners","In development             In place                         In place\n\nIn place",3,3,"n",{"$f":"IF(S8<4,\"GREEN\",IF(AND(S8>3,S8<7),\"YELLOW\",IF(AND(S8>7,S8<10),\"AMBER\",IF(AND(S8>9,S8<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"O8*P8","v":9},"Up"]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]

{"sheet":"AUSA and Other Third Parties","index":17,"n_rows":25,"n_cols":20,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,5],[2,8,2,10],[2,16,2,18]]}
[null,"Strategic Risk Area:",null,"AUSA and Other Third Parties"]
[]
[null,"No.","Risk  (what could happen)","Risk Owner","Risk Manager","Consequences (how would this affect the University)","Likelihood","Impact","Unmitigated Score\n(gross)",null,null,"Response","Mitigations (what is being/has been done to control the risk) ","Status (in place/in progress/under consideration)","Likelihood","Impact","Mitigated Score\n(net)",null,null,"Risk Movement"]
[null,1,"Impact on Rocking Horse Nursery from extended closure, reduced occupancy levels or failure to maintain access to national childcare schemes.","US & COO","Nursery Trustees","Financial impact (e.g. reserves exhausted beyond prudent levels)\n\nInability to pay the University Service Charge\n\nReputational impact and exposure of trustees to personal liability/university as defacto trustee.\nStaff salaries\nStaff and student satisfaction ",4,4,"n",{"$f":"IF(K4<4,\"GREEN\",IF(AND(K4>3,K4<7),\"YELLOW\",IF(AND(K4>7,K4<10),\"AMBER\",IF(AND(K4>9,K4<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"G4*H4","v":16},"Treat","Revision of fees and fees strategy\nRevision of salary strategy\nLiaison with Finance Directorate\nReview of Corporate form.","In pIrogress                   In progress               \nIn place                                                                                               To be initiated",3,3,"n",{"$f":"IF(S4<4,\"GREEN\",IF(AND(S4>3,S4<7),\"YELLOW\",IF(AND(S4>7,S4<10),\"AMBER\",IF(AND(S4>9,S4<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"O4*P4","v":9},"No Change"]
[null,2,"Impact on ASV following a prolonged period of lockdown and actions already taken e.g. restricted opening, reduced staffing, and other adaptations to recover from initial period of closure","US & COO","ASV","Financial impact\n\nReputational impact\n\nStaff and student experience\n\nMembership attrition",4,4,"n",{"$f":"IF(K5<4,\"GREEN\",IF(AND(K5>3,K5<7),\"YELLOW\",IF(AND(K5>7,K5<10),\"AMBER\",IF(AND(K5>9,K5<17),\"RED\",\"ERROR\"))))","v":"RED"},{"$f":"G5*H5","v":16},"Treat","ASV reopened on 26/04/21 after a four month lockdown (during which only elite sport took place).   Furough scheme used as mitigation.\n\nActive redesign of pricing and marketing to support recovery of membership \n\nEmergency use of elements of operational and lifecycle reserve - agreed with shareholders to reduce an anticipated operating deficit in 20/21 and 21/22\n\nRegular discussion with shareholders (UoA and ACC) at ASV Joint Partnership)","Ongoing \n\n\n\nIn place\n\n\n\nIn place\n\n\n\nOn going",3,3,"n",{"$f":"IF(S5<4,\"GREEN\",IF(AND(S5>3,S5<7),\"YELLOW\",IF(AND(S5>7,S5<10),\"AMBER\",IF(AND(S5>9,S5<17),\"RED\",\"ERROR\"))))","v":"AMBER"},{"$f":"O5*P5","v":9},"No Change"]
[null,3,"AUSA sustainability","US & COO","AUSA Chief Exec.","Financial impact - requiring additional support from the University",2,3,"n",{"$f":"IF(K6<4,\"GREEN\",IF(AND(K6>3,K6<7),\"YELLOW\",IF(AND(K6>7,K6<10),\"AMBER\",IF(AND(K6>9,K6<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"G6*H6","v":6},"Treat","Strategic review commissioned by AUSA Board                                                                                                                    Active engagement on planning with UoA.","In progress\n\nIn progress",3,2,"n",{"$f":"IF(S6<4,\"GREEN\",IF(AND(S6>3,S6<7),\"YELLOW\",IF(AND(S6>7,S6<10),\"AMBER\",IF(AND(S6>9,S6<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},{"$f":"O6*P6","v":6},"No Change"]
[null,4,"Extended transition following Covid Pandemic impacts on sustainability of third party catering and other providers on campus (e.g. Kilau, Food Story, Subway, Blackwells, Starbucks etc) ","US & COO","Head of Catering and Commercial Services","Financial impact (rental income >£10k per month)\n\nStaff and student experience (risk of loss of key campus providers)\n\nOther independent traders (e.g. Shelter Coffee, Machar Bar, JG Ross, Newsagent) may close with impact on staff and student amenities",4,4,"n",{"$f":"IF(K7<4,\"GREEN\",IF(AND(K7>3,K7<7),\"YELLOW\",IF(AND(K7>7,K7<10),\"AMBER\",IF(AND(K7>9,K7<17),\"RED\",\"ERROR\"))))","v":"RED"},16,"Treat","Regular contact with Head of Commercial & Catering\n\nReversion to base rent (i.e. Starbucks) rather than top-up rent\n\nSMT agreed policy on how to deal with third party rentals\n\nFurther consideration of additional support options reviewed and determined, on an individual case by case basis","In place\n\n\nIn place\n\n\nIn place\n\n\nUnder consideration",2,3,"n",{"$f":"IF(S7<4,\"GREEN\",IF(AND(S7>3,S7<7),\"YELLOW\",IF(AND(S7>7,S7<10),\"AMBER\",IF(AND(S7>9,S7<17),\"RED\",\"ERROR\"))))","v":"YELLOW"},6,"No Change"]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,"n","GREEN",0]