{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Blank Template","Risk Summary Table","Scoring Matrix","Education (UG and PGT)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":20,"n_cols":8,"rows_kept":20,"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(#REF!,31)","v":{"$error":"#REF!"}},{"$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":0},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B5,31)&\"'!$S$4:$S$27\"),\"<10\",INDIRECT(\"'\"&LEFT($B5,31)&\"'!$S$4:$S$27\"),\">6\"),0)","v":0},{"$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":0},{"$f":"G5/G19","v":0}]
[{"$f":"ROW()-4","v":2},{"$f":"LEFT(#REF!,31)","v":{"$error":"#REF!"}},{"$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":0},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B6,31)&\"'!$S$4:$S$27\"),\"<10\",INDIRECT(\"'\"&LEFT($B6,31)&\"'!$S$4:$S$27\"),\">6\"),0)","v":0},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B6,31)&\"'!$S$4:$S$27\"),\"<17\",INDIRECT(\"'\"&LEFT($B6,31)&\"'!$S$4:$S$27\"),\">9\"),0)","v":0},0,{"$f":"G6/G19","v":0}]
[3,{"$f":"LEFT(#REF!,31)","v":{"$error":"#REF!"}},0,0,0,0,0,{"$f":"G7/G19","v":0}]
[4,{"$f":"LEFT('Education (UG and PGT)'!D1,31)","v":"Education (UG and PGT)"},0,7,1,0,8,{"$f":"G8/G19","v":1}]
[5,{"$f":"LEFT(#REF!,31)","v":{"$error":"#REF!"}},0,0,0,0,0,{"$f":"G9/G19","v":0}]
[6,{"$f":"LEFT(#REF!,31)","v":{"$error":"#REF!"}},0,0,0,0,0,{"$f":"G10/G19","v":0}]
[7,{"$f":"LEFT(#REF!,31)","v":{"$error":"#REF!"}},0,0,0,0,0,{"$f":"G11/G19","v":0}]
[8,{"$f":"LEFT(#REF!,31)","v":{"$error":"#REF!"}},0,{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B12,31)&\"'!$S$4:$S$27\"),\"<7\",INDIRECT(\"'\"&LEFT($B12,31)&\"'!$S$4:$S$27\"),\">3\"),0)","v":0},0,0,0,{"$f":"G12/G19","v":0}]
[9,{"$f":"LEFT(#REF!,31)","v":{"$error":"#REF!"}},0,0,0,0,0,{"$f":"G13/G19","v":0}]
[10,{"$f":"LEFT(#REF!,31)","v":{"$error":"#REF!"}},0,0,0,0,0,{"$f":"G14/G19","v":0}]
[11,{"$f":"LEFT(#REF!,31)","v":{"$error":"#REF!"}},0,0,0,0,0,{"$f":"G15/G19","v":0}]
[12,{"$f":"LEFT(#REF!,31)","v":{"$error":"#REF!"}},0,0,0,0,0,{"$f":"G16/G19","v":0}]
[13,{"$f":"LEFT(#REF!,31)","v":{"$error":"#REF!"}},0,0,0,0,0,{"$f":"G17/G19","v":0}]
[]
[{"$f":"COUNTA(RiskTable[[#All],[Column1]])","v":13},"Total",{"$f":"SUM(C5:C17)","v":0},{"$f":"SUM(D5:D18)","v":7},{"$f":"SUM(E5:E18)","v":1},{"$f":"SUM(F5:F17)","v":0},{"$f":"SUM(C19:F19)","v":8}]
[null,"% of Total",{"$f":"C19/G19","v":0},{"$f":"D19/G19","v":0.875},{"$f":"E19/G19","v":0.125},{"$f":"F19/G19","v":0},{"$f":"SUM(C20:F20)","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":"Education (UG and PGT)","index":3,"n_rows":11,"n_cols":21,"rows_kept":11,"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 (actions that are underway or already complete) ","Status (in progress - with completion date/ complete)","Likelihood","Impact","Mitigated Score\n(net)",null,null,"Risk Movement","Future Planned actions"]
[null,1,"Assessment and feedback on assessment is not of a high quality and / or provided within the required timeframes.\n\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\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","Continue with the agreed 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\nContinue with the agreed 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 support 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)\n\n\n","complete\n\n\n\ncomplete\n\n\n\n\ncomplete\n\n\nIn progress (complete in AY23/24)\n\nIn progress (complete in AY23/24)\n\ncomplete\n\n\ncomplete\n\n\ncomplete\n\n\n",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,"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, degree awarding gap, and League Table position\n\nReputational impact\n\n",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","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\n\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","Complete\n\n\nComplete\n\n\n\n\nComplete\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"},4,"No Change","Monthly review of withdrawal data to enable 'real-time' understanding of any trends or concerns"]
[null,3,"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","International TFG is taking 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 progress (this is a long-term and ongoing action)\n\nIn progress (complete in AY23/24)\n\nComplete\n\nComplete\n\n\nComplete",2,2,"n","YELLOW",4,"No Change"]
[null,4,"Quality assurance arrangements are not in place or not adhered to in our TNE (transnational education) partnerships in Qatar, the Joint Institute with South China Normal University, and other TNE provision\n\n","VP E\n","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",3,3,"n","AMBER",9,"Treat","Produce a quality assurance report annually for a specific partnership focused 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","Complete\n\n\n\nComplete\n\n\nComplete\n",2,2,"n","YELLOW",4,"No Change"]
[null,5,"Students are unable to access work placements or go on to employment after graduation \n\n\n","VP E\n\n","Head of Careers and Dean for Employability and Entrepreneurship","Negative impact on graduate outcomes \n\nNegative impact on our graduates\n\nImpact on the achievement of Aberdeen 2040 Commitment 12",4,4,"n","RED",16,"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\nProgress the work that relates to the scaling up of work placements, aiming to prioritise the project where possible (given the requirements for staff in the ciurrent financial context)\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\n\nComplete the work of the Aberdeen 2040 Graduate Attributes and Skills and develop an associated detailed implementation plan","Complete\n\n\nIn progress (actions identified for AY23/23)\n\n\nComplete\n\n\nIn progress (actions in place for AY23/24)\n\n\nComplete\n\n\nIn progress (for approval at Senate in February 2024)",3,3,"n","AMBER",9,"No Change"]
[null,6,"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",{"$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"},{"$f":"G9*H9","v":8},"Treat","Ensure close oversight by Schools of PSRB requirements\n\nQAC oversight of PSRB accreditation reports\n\nPut in place a more robust process of identifying and monitoring accreditation/PSRB requirements and ensure that Schools are alerted to the actions required at least 9 months ahead of time","Complete\n\nComplete\n\nComplete",1,4,"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,7,"Unable to improve the degree awarding gap for Black, Asian and Minority Ethnic students, Widening Access students and mature-age students. ","VP E","Director of Academic Services & Online Education","Negative impact on the individual students\n\nStudent performance and progression is not where it should be\n\nReputational damage",3,4,"n","RED",12,"Treat","Implement a targeted action plan","Complete",2,3,"n","YELLOW",6,"No Change"]
[null,8,"Areas of the Estate not available for teaching or related activities due to emergency situations (e.g., RAAC) or other issues (e.g., estates development).","VP E","Director of Academic Services & Online Education","Unable to provide planned in-person delivery of education with a negative impact on the student learning experience\n\nUnable to deliver specialist teaching if particular areas are not available (e.g. laboratories)\n\nUnable to deliver in-person exams if large spaces are not available. \n",3,3,"n","AMBER",9,"Treat","Where planned building or room closure are knkown, ensure that the timetabling team has the required information. \n\nWhere emergency situations occur, work with timetabling to identify contingency plans so that students are able to access the relevant activities. \n\nWhere a longer-term issue is identified, identify alternative approaches to delivery of education.\n","In place\n\n\n\nIn place\n\n\n\n\nIn place\n",3,2,"n","YELLOW",6,"New Risk"]