{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","Process summary","Risk Assessment","Risk Review","Action Plan"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":7,"comments":2,"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":"Introduction","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[11,0,11,14],[9,0,9,3],[10,0,10,3],[1,0,1,14],[2,0,2,3],[3,2,3,4],[3,0,3,1]]}
[]
["School security risk assessment guide"]
["As part of the DoE School security procedure, principals must conduct a security risk assessment of their school at least annually, in preparation of any major events, or in response to a critical incident.  It is important to acknowledge security risks at schools, as risks to the safety of staff and students, to material assets and school reputation, cannot be eliminated entirely, but can be prepared for and managed.  Whilst this document identifies some common security risks at schools, it is important to consider the attributes that make a school unique when assessing risk, including location, neighbours, linked associations, surrounding landscapes, the community environment, the proximity to emergency services, and security facilities at the school."]
["School details:",null,"About this document:"]
["School name:",null,"Tab 2: Process summary","This provides an outline of the risk assessment method, as per the DoE Enterprise risk management framework."]
["Centre number:",null,"Tab 3: Risk assessment","This is where you input your data of what risks have been identified, how likely there are to occur and what the consequence might be, to calculate the overall level of risk."]
["Completed by:",null,"Tab 4: Risk review","This is where you review the strategies and controls already in place, and determine what additional or new strategies will be part of your action plan."]
["Date completed:",null,"Tab 5: Action plan","This is where you determine what action plans for the future will look like and how they will be prioritised."]
[]
["This guide shold be used in conjunction with School security procedure Fact sheet 1: Conducting a security risk assessment"]
["For more information about school security, including details for your School Security Advisor, visit the School Security Management page on OnePortal"]

{"sheet":"Process summary","index":1,"n_rows":113,"n_cols":6,"rows_kept":113,"cut":false,"hidden":false,"merged":[[59,0,59,2],[36,2,36,5],[37,2,37,5],[47,0,47,5],[49,0,50,0],[49,1,49,5],[57,0,57,5],[40,2,40,5],[41,2,41,5],[42,2,42,5],[43,2,43,5],[44,2,44,5],[45,2,45,5],[39,0,39,5],[31,0,31,5],[32,2,32,5],[33,2,33,5],[34,2,34,5],[35,2,35,5],[25,2,25,5],[26,2,26,5],[27,2,27,5],[28,2,28,5],[29,2,29,5],[19,2,19,5],[20,2,20,5],[21,2,21,5],[23,0,23,5],[24,2,24,5],[13,0,13,5],[15,0,15,5],[16,2,16,5],[17,2,17,5],[18,2,18,5],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[3,0,3,5],[4,0,4,5],[6,2,6,3],[0,0,0,5],[1,2,1,5],[2,0,2,5]]}
["Risk assessment process summary"]
[null,null,"A risk assessment is a structured process with the aim of determining and contextualising any threats to a school’s objectives. \n\nA security risk assessment means this process is specific to security related risks. The department’s approach to managing risk is based on AS/NZS ISO 31000:2018: Risk management-Principles and guidelines, and is outlined in the Enterprise risk management procedure.\n\n1. Establishing the context of the risk assessment is ensures that once risks are identified, mitigation measures can be applied which are both proportionate and appropriate.  \n2. Identifying security related risks.\n3. Analysing and assessing the identified risks.\n4. Evaluating the overall level of each identified risk.\n5. Treating the identified risks."]
["More information is available in the School security procedure Fact sheet 1: Conducting a security risk assessment:"]
["https://ppr.qed.qld.gov.au/attachment/fact-sheet-1-conducting-a-security-risk-assessment.pdf"]
["Examples of Calculating the Likelihood of an Event"]
[]
["Level","Descriptor","Description",null,"Example for Vandalism","Example for Break and Enter"]
["A","Almost Certain","Expected to occur in most circumstances",null,"More than once per month","More than 7 times in one year"]
["B","Likely","Willprobably occur in most circumstances",null,"Once per month","5-6 times per year"]
["C","Possible","Might occur at some time",null,"Once per one-two months","3-4 times per year"]
["D","Unlikely","Could occur at some time",null,"A few times per year","1-2 times per year"]
["E","Rare","May occur in exceptional circumstances",null,"Once per year","Almost never"]
[]
["Types of Consequence Descriptors and Possible Harm"]
[]
["Example of Consequence Descriptiors for Financial Harm"]
["Level","Descriptor","Description (Example Only)"]
[5,"Catastrophic","No possible funding recovery for function"]
[4,"Major","Critical impact on budget/external recovery funding"]
[3,"Moderate","Serious impact on budget/resource reallocation"]
[2,"Minor","Minor impact on budget/some resources diverted"]
[1,"Insignificant","Managed within functional budget"]
[]
["Example of Consequence Descriptiors for Personal Harm"]
["Level","Descriptor","Description (Example Only)"]
[5,"Catastrophic","Death"]
[4,"Major","Extensive injuries/hospitalisation"]
[3,"Moderate","Medical treatment required"]
[2,"Minor","First aid treatment"]
[1,"Insignificant","No injuries"]
[]
["Example of consequence descriptiors for harm to reputation"]
["Level","Descriptor","Description (Example Only)"]
[5,"Catastrophic","Total loss of confidence, long term recovery needed"]
[4,"Major","Public confidence shaken but not totally lost"]
[3,"Moderate","Damage control plan required to be implemented"]
[2,"Minor","Some media attention, reputation questioned"]
[1,"Insignificant","No outward impact"]
[]
["Example of consequence descriptors for occupational violence"]
["Level","Descriptor","Description (example only)"]
[5,"Catastrophic","Physical or Psychological abuse with ongoing or terminal impact"]
[4,"Major","Physical abuse, e.g. hitting, spitting, kicking, throwing objects"]
[3,"Moderate","Psychological abuse e.g. intimidating language, threats to inflict harm, sexual harassment"]
[2,"Minor","Harassment or aggressive behaviour that creates a fear of violence e.g. threats, abuse"]
[1,"Insignificant","Non-targeted verbal abuse, e.g. shouting, swearing, insults, condescending language"]
[]
["Overall Levels of Risk"]
[]
["Likelihood","Consequence"]
[null,"Insignificant","Minor","Moderate","Major ","Critical"]
["Almost Certain","Medium","Medium","High","Extreme","Extreme"]
["Likely","Low","Medium","High","High","Extreme"]
["Possible","Low","Medium","Medium","High","High"]
["Unlikely","Low","Low","Medium","Medium","High"]
["Rare","Low","Low","Low","Low","Medium"]
[]
["The data below is used by this document to calculate risk levels - DO NOT EDIT"]
[]
["Possible Combinations"]
["A1","Almost CertainInsignificant","Medium"]
["A2","Almost CertainMinor","Medium"]
["A3","Almost CertainModerate","High"]
["A4","Almost CertainMajor","Extreme"]
["A5","Almost CertainCritical","Extreme"]
["B1","LikelyInsignificant","Low"]
["B2","LikelyMinor","Medium"]
["B3","LikelyModerate","High"]
["B4","LikelyMajor","High"]
["B5","LikelyCritical","Extreme"]
["C1","PossibleInsignificant","Low"]
["C2","PossibleMinor","Medium"]
["C3","PossibleModerate","Medium"]
["C4","PossibleMajor","High"]
["C5","PossibleCritical","High"]
["D1","UnlikelyInsignificant","Low"]
["D2","UnlikelyMinor","Low"]
["D3","UnlikelyModerate","Medium"]
["D4","UnlikelyMajor","Medium"]
["D5","UnlikelyCritical","High"]
["E1","RareInsignificant","Low"]
["E2","RareMinor","Low"]
["E3","RareModerate","Low"]
["E4","RareMajor","Low"]
["E5","RareCritical","Medium"]
[]
[]
["Rare","Insignificant"]
["Unlikely","Minor"]
["Possible","Moderate"]
["Likely","Major"]
["Almost Certain","Critical"]
[]
["Yes"]
["No"]
[]
["School process/policy"]
["Security installation"]
["System upgrade"]
["Training/awareness action"]
["Grounds works"]
["Building works"]
["Personal management plan"]
["Inter-agency initiative"]
["Other"]
[]
["Highly effective in reducing the risk"]
["Effective, but with more work to do on existing strategies"]
["Effective, but action required on new strategies"]
["Effective, but the overall level of the risk has changed"]
["Not effective at reducing the risk"]
["Unknown"]
["N/A"]

{"sheet":"Risk Assessment","index":2,"n_rows":104,"n_cols":9,"rows_kept":104,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,1],[2,0,7,0],[2,6,7,6],[2,2,7,2],[2,3,7,3],[33,0,42,0],[2,1,7,1],[2,5,3,5],[2,8,7,8],[32,0,32,8],[9,0,19,0],[20,0,26,0],[27,0,31,0],[2,7,7,7]]}
["Security risk assessment"]
["Security risks can typically be categorised as being related to people, property and information",null,"Consider the controls and factors","Consider how factors will effect the consequence"]
["Risk categories","Risks","Likelihood","Consequence","Risk Combination","Overall risk","Identified in previous assessment/action plan?","Is further review of the risk required?","Is the risk a priority?"]
[]
[null,null,null,null,null,"Extreme"]
[null,null,null,null,null,"High"]
[null,null,null,null,null,"Medium"]
[null,null,null,null,null,"Low"]
["Risk category type","Common risks types outlined below\nAlso add any risks specific to your school","Enter Likelihood","Enter Consequence",null,"This will calculate based on Likelihood and Consequence","Y/N","If yes, review current strategies and identify new actions in the Risk Review tab","Is the risk newly identified, or has it increased in severity?"]
["People","Unauthorised persons on grounds outside school hours",null,null,{"$f":"CONCATENATE(C10,D10)","v":""},{"$f":"IF(E10=\"\",\"Not Rated\",VLOOKUP(E10,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,{"$f":"IF(F10=\"Not Rated\",\"\",IF(OR(F10=\"Extreme\", F10=\"High\", F10=\"Moderate\"), \"Yes\",\"No\"))","v":""}]
[null,"Unauthorised persons on grounds during school hours",null,null,"",{"$f":"IF(E11=\"\",\"Not Rated\",VLOOKUP(E11,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,"Unauthorised vehicle on site",null,null,"",{"$f":"IF(E12=\"\",\"Not Rated\",VLOOKUP(E12,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,"Assault on staff",null,null,"",{"$f":"IF(E13=\"\",\"Not Rated\",VLOOKUP(E13,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,"Assault on student",null,null,"",{"$f":"IF(E14=\"\",\"Not Rated\",VLOOKUP(E14,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,"Verbal threats to staff",null,null,"",{"$f":"IF(E15=\"\",\"Not Rated\",VLOOKUP(E15,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,"Aggressive behaviour in Administration",null,null,"",{"$f":"IF(E16=\"\",\"Not Rated\",VLOOKUP(E16,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,"Indecent behaviour on school grounds",null,null,"",{"$f":"IF(E17=\"\",\"Not Rated\",VLOOKUP(E17,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,"Protest/civil unrest",null,null,"",{"$f":"IF(E18=\"\",\"Not Rated\",VLOOKUP(E18,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,"Bomb threat",null,null,"",{"$f":"IF(E19=\"\",\"Not Rated\",VLOOKUP(E19,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,"Online threat",null,null,"",{"$f":"IF(E20=\"\",\"Not Rated\",VLOOKUP(E20,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
["Property","Suspicious items on site",null,null,{"$f":"CONCATENATE(C21,D21)","v":""},{"$f":"IF(E21=\"\",\"Not Rated\",VLOOKUP(E21,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,"Graffiti",null,null,"",{"$f":"IF(E22=\"\",\"Not Rated\",VLOOKUP(E22,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,"Vandalism",null,null,"",{"$f":"IF(E23=\"\",\"Not Rated\",VLOOKUP(E23,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,"Break and enter",null,null,"",{"$f":"IF(E24=\"\",\"Not Rated\",VLOOKUP(E24,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,"Arson",null,null,"",{"$f":"IF(E25=\"\",\"Not Rated\",VLOOKUP(E25,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,"Burnt items on the grounds",null,null,"",{"$f":"IF(E26=\"\",\"Not Rated\",VLOOKUP(E26,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,"Theft",null,null,"",{"$f":"IF(E27=\"\",\"Not Rated\",VLOOKUP(E27,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
["Information","Unauthorised access to physical records",null,null,"",{"$f":"IF(E28=\"\",\"Not Rated\",VLOOKUP(E28,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,"Unauthorised access to CCTV footage",null,null,"",{"$f":"IF(E29=\"\",\"Not Rated\",VLOOKUP(E29,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,"Extortion",null,null,"",{"$f":"IF(E30=\"\",\"Not Rated\",VLOOKUP(E30,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,{"$f":"IF(F30=\"Not Rated\",\"\",IF(OR(F30=\"Extreme\", F30=\"High\", F30=\"Moderate\"), \"Yes\",\"No\"))","v":""}]
[null,"Cybersecurity leak",null,null,"",{"$f":"IF(E31=\"\",\"Not Rated\",VLOOKUP(E31,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,{"$f":"IF(F31=\"Not Rated\",\"\",IF(OR(F31=\"Extreme\", F31=\"High\", F31=\"Moderate\"), \"Yes\",\"No\"))","v":""}]
[null,"Unwanted media attention",null,null,"",{"$f":"IF(E32=\"\",\"Not Rated\",VLOOKUP(E32,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
["Risks specific to my school "]
["My School",null,null,null,{"$f":"CONCATENATE(C34,D34)","v":""},{"$f":"IF(E34=\"\",\"Not Rated\",VLOOKUP(E34,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,{"$f":"IF(F34=\"Not Rated\",\"\",IF(OR(F34=\"Extreme\", F34=\"High\", F34=\"Moderate\"), \"Yes\",\"No\"))","v":""}]
[null,null,null,null,"",{"$f":"IF(E35=\"\",\"Not Rated\",VLOOKUP(E35,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,{"$f":"IF(F35=\"Not Rated\",\"\",IF(OR(F35=\"Extreme\", F35=\"High\", F35=\"Moderate\"), \"Yes\",\"No\"))","v":""}]
[null,null,null,null,"",{"$f":"IF(E36=\"\",\"Not Rated\",VLOOKUP(E36,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,null,null,null,"",{"$f":"IF(E37=\"\",\"Not Rated\",VLOOKUP(E37,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,null,null,null,"",{"$f":"IF(E38=\"\",\"Not Rated\",VLOOKUP(E38,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,null,null,null,"",{"$f":"IF(E39=\"\",\"Not Rated\",VLOOKUP(E39,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,null,null,null,"",{"$f":"IF(E40=\"\",\"Not Rated\",VLOOKUP(E40,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,null,null,null,"",{"$f":"IF(E41=\"\",\"Not Rated\",VLOOKUP(E41,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,{"$f":"IF(F41=\"Not Rated\",\"\",IF(OR(F41=\"Extreme\", F41=\"High\", F41=\"Moderate\"), \"Yes\",\"No\"))","v":""}]
[null,null,null,null,"",{"$f":"IF(E42=\"\",\"Not Rated\",VLOOKUP(E42,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,null,null,null,"",{"$f":"IF(E43=\"\",\"Not Rated\",VLOOKUP(E43,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"},null,""]
[null,null,null,null,"",{"$f":"IF(E44=\"\",\"Not Rated\",VLOOKUP(E44,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E45=\"\",\"Not Rated\",VLOOKUP(E45,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E46=\"\",\"Not Rated\",VLOOKUP(E46,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E47=\"\",\"Not Rated\",VLOOKUP(E47,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E48=\"\",\"Not Rated\",VLOOKUP(E48,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E49=\"\",\"Not Rated\",VLOOKUP(E49,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E50=\"\",\"Not Rated\",VLOOKUP(E50,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E51=\"\",\"Not Rated\",VLOOKUP(E51,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E52=\"\",\"Not Rated\",VLOOKUP(E52,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E53=\"\",\"Not Rated\",VLOOKUP(E53,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E54=\"\",\"Not Rated\",VLOOKUP(E54,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E55=\"\",\"Not Rated\",VLOOKUP(E55,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E56=\"\",\"Not Rated\",VLOOKUP(E56,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E57=\"\",\"Not Rated\",VLOOKUP(E57,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E58=\"\",\"Not Rated\",VLOOKUP(E58,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E59=\"\",\"Not Rated\",VLOOKUP(E59,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E60=\"\",\"Not Rated\",VLOOKUP(E60,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E61=\"\",\"Not Rated\",VLOOKUP(E61,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E62=\"\",\"Not Rated\",VLOOKUP(E62,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E63=\"\",\"Not Rated\",VLOOKUP(E63,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E64=\"\",\"Not Rated\",VLOOKUP(E64,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E65=\"\",\"Not Rated\",VLOOKUP(E65,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,{"$f":"CONCATENATE(C66,D66)","v":""},{"$f":"IF(E66=\"\",\"Not Rated\",VLOOKUP(E66,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E67=\"\",\"Not Rated\",VLOOKUP(E67,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E68=\"\",\"Not Rated\",VLOOKUP(E68,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E69=\"\",\"Not Rated\",VLOOKUP(E69,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E70=\"\",\"Not Rated\",VLOOKUP(E70,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E71=\"\",\"Not Rated\",VLOOKUP(E71,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E72=\"\",\"Not Rated\",VLOOKUP(E72,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E73=\"\",\"Not Rated\",VLOOKUP(E73,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E74=\"\",\"Not Rated\",VLOOKUP(E74,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E75=\"\",\"Not Rated\",VLOOKUP(E75,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E76=\"\",\"Not Rated\",VLOOKUP(E76,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E77=\"\",\"Not Rated\",VLOOKUP(E77,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E78=\"\",\"Not Rated\",VLOOKUP(E78,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E79=\"\",\"Not Rated\",VLOOKUP(E79,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E80=\"\",\"Not Rated\",VLOOKUP(E80,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E81=\"\",\"Not Rated\",VLOOKUP(E81,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E82=\"\",\"Not Rated\",VLOOKUP(E82,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E83=\"\",\"Not Rated\",VLOOKUP(E83,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E84=\"\",\"Not Rated\",VLOOKUP(E84,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E85=\"\",\"Not Rated\",VLOOKUP(E85,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E86=\"\",\"Not Rated\",VLOOKUP(E86,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E87=\"\",\"Not Rated\",VLOOKUP(E87,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E88=\"\",\"Not Rated\",VLOOKUP(E88,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E89=\"\",\"Not Rated\",VLOOKUP(E89,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E90=\"\",\"Not Rated\",VLOOKUP(E90,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E91=\"\",\"Not Rated\",VLOOKUP(E91,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E92=\"\",\"Not Rated\",VLOOKUP(E92,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E93=\"\",\"Not Rated\",VLOOKUP(E93,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E94=\"\",\"Not Rated\",VLOOKUP(E94,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E95=\"\",\"Not Rated\",VLOOKUP(E95,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E96=\"\",\"Not Rated\",VLOOKUP(E96,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,"",{"$f":"IF(E97=\"\",\"Not Rated\",VLOOKUP(E97,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,{"$f":"CONCATENATE(C98,D98)","v":""},{"$f":"IF(E98=\"\",\"Not Rated\",VLOOKUP(E98,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,{"$f":"CONCATENATE(C99,D99)","v":""},{"$f":"IF(E99=\"\",\"Not Rated\",VLOOKUP(E99,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,{"$f":"CONCATENATE(C100,D100)","v":""},{"$f":"IF(E100=\"\",\"Not Rated\",VLOOKUP(E100,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,{"$f":"CONCATENATE(C101,D101)","v":""},{"$f":"IF(E101=\"\",\"Not Rated\",VLOOKUP(E101,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,{"$f":"CONCATENATE(C102,D102)","v":""},{"$f":"IF(E102=\"\",\"Not Rated\",VLOOKUP(E102,'Process summary'!$B$61:$C$85,2,FALSE))","v":"Not Rated"}]
[null,null,null,null,null,"Not Rated"]
[null,null,null,null,null,"Not Rated"]

{"sheet":"Risk Review","index":3,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,9],[17,0,23,0],[24,0,28,0],[30,0,39,0],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,5,4,6],[6,0,16,0],[29,0,29,9]]}
["Risk review"]
["For more information about strategies to mitigate security risks, refer to:"]
["• Your School Security Advisor in Infrastructure Services"]
["• The School security management pages on OnePortal"]
["Risk category type","Risk","Overall risk","Identified for further review?","Existing controls and strategies","Effectiveness of strategies to address existing risks",null,"Identified as a priority?","Action required?","Action plan strategies "]
["Risk category type","Common risks types outlined below\nAlso add any risks specific to your school","As per the risk assessment","If yes, review current strategies and controls →","What are the existing controls and strategies currently in place that apply to the identified risk?","Identified in previous risk assessment?","If yes, how effective have existing strategies been in managing the risk?","Is the risk a priority?","Is more action required to reasonably address this risk?","Contact your School Security Advisor for more information about what strategies are most commonly effective in mitigating specific security risks"]
["People","Unauthorised persons on grounds outside school hours",{"$f":"'Risk Assessment'!F10","v":"Not Rated"},{"$f":"'Risk Assessment'!H10","v":""},null,{"$f":"'Risk Assessment'!G10","v":0},null,{"$f":"'Risk Assessment'!I10","v":0},{"$f":"IF(D7=\"\",\"\",IF(D7=\"No\",\"No\",IF(AND(F7=\"Yes\",G7=\"Highly effective in reducing the risk\",H7=\"No\"),\"No\",IF(AND(F7=\"Yes\",G7=\"Highly effective in reducing the risk\",H7=\"Yes\"),\"Monitor\",\"Yes\"))))","v":""}]
[null,"Unauthorised persons on grounds during school hours",{"$f":"'Risk Assessment'!F11","v":"Not Rated"},{"$f":"'Risk Assessment'!H11","v":""},null,{"$f":"'Risk Assessment'!G11","v":0},null,{"$f":"'Risk Assessment'!I11","v":0},{"$f":"IF(D8=\"\",\"\",IF(D8=\"No\",\"No\",IF(AND(F8=\"Yes\",G8=\"Highly effective in reducing the risk\",H8=\"No\"),\"No\",IF(AND(F8=\"Yes\",G8=\"Highly effective in reducing the risk\",H8=\"Yes\"),\"Monitor\",\"Yes\"))))","v":""}]
[null,"Unauthorised vehicle on site",{"$f":"'Risk Assessment'!F12","v":"Not Rated"},{"$f":"'Risk Assessment'!H12","v":""},null,{"$f":"'Risk Assessment'!G12","v":0},null,{"$f":"'Risk Assessment'!I12","v":0},""]
[null,"Assault on staff",{"$f":"'Risk Assessment'!F13","v":"Not Rated"},{"$f":"'Risk Assessment'!H13","v":""},null,{"$f":"'Risk Assessment'!G13","v":0},null,{"$f":"'Risk Assessment'!I13","v":0},""]
[null,"Assault on student",{"$f":"'Risk Assessment'!F14","v":"Not Rated"},{"$f":"'Risk Assessment'!H14","v":""},null,{"$f":"'Risk Assessment'!G14","v":0},null,{"$f":"'Risk Assessment'!I14","v":0},""]
[null,"Verbal threats to staff",{"$f":"'Risk Assessment'!F15","v":"Not Rated"},{"$f":"'Risk Assessment'!H15","v":""},null,{"$f":"'Risk Assessment'!G15","v":0},null,{"$f":"'Risk Assessment'!I15","v":0},""]
[null,"Aggressive behaviour in Administration",{"$f":"'Risk Assessment'!F16","v":"Not Rated"},{"$f":"'Risk Assessment'!H16","v":""},null,{"$f":"'Risk Assessment'!G16","v":0},null,{"$f":"'Risk Assessment'!I16","v":0},""]
[null,"Indecent behaviour on school grounds",{"$f":"'Risk Assessment'!F17","v":"Not Rated"},{"$f":"'Risk Assessment'!H17","v":""},null,{"$f":"'Risk Assessment'!G17","v":0},null,{"$f":"'Risk Assessment'!I17","v":0},""]
[null,"Protest/civil unrest",{"$f":"'Risk Assessment'!F18","v":"Not Rated"},{"$f":"'Risk Assessment'!H18","v":""},null,{"$f":"'Risk Assessment'!G18","v":0},null,{"$f":"'Risk Assessment'!I18","v":0},""]
[null,"Bomb threat",{"$f":"'Risk Assessment'!F19","v":"Not Rated"},{"$f":"'Risk Assessment'!H19","v":""},null,{"$f":"'Risk Assessment'!G19","v":0},null,{"$f":"'Risk Assessment'!I19","v":0},""]
[null,"Online threat",{"$f":"'Risk Assessment'!F20","v":"Not Rated"},{"$f":"'Risk Assessment'!H20","v":""},null,{"$f":"'Risk Assessment'!G20","v":0},null,{"$f":"'Risk Assessment'!I20","v":0},""]
["Property","Suspicious items on site",{"$f":"'Risk Assessment'!F21","v":"Not Rated"},{"$f":"'Risk Assessment'!H21","v":""},null,{"$f":"'Risk Assessment'!G21","v":0},null,{"$f":"'Risk Assessment'!I21","v":0},""]
[null,"Graffiti",{"$f":"'Risk Assessment'!F22","v":"Not Rated"},{"$f":"'Risk Assessment'!H22","v":""},null,{"$f":"'Risk Assessment'!G22","v":0},null,{"$f":"'Risk Assessment'!I22","v":0},""]
[null,"Vandalism",{"$f":"'Risk Assessment'!F23","v":"Not Rated"},{"$f":"'Risk Assessment'!H23","v":""},null,{"$f":"'Risk Assessment'!G23","v":0},null,{"$f":"'Risk Assessment'!I23","v":0},""]
[null,"Break and enter",{"$f":"'Risk Assessment'!F24","v":"Not Rated"},{"$f":"'Risk Assessment'!H24","v":""},null,{"$f":"'Risk Assessment'!G24","v":0},null,{"$f":"'Risk Assessment'!I24","v":0},""]
[null,"Arson",{"$f":"'Risk Assessment'!F25","v":"Not Rated"},{"$f":"'Risk Assessment'!H25","v":""},null,{"$f":"'Risk Assessment'!G25","v":0},null,{"$f":"'Risk Assessment'!I25","v":0},""]
[null,"Burnt items on the grounds",{"$f":"'Risk Assessment'!F26","v":"Not Rated"},{"$f":"'Risk Assessment'!H26","v":""},null,{"$f":"'Risk Assessment'!G26","v":0},null,{"$f":"'Risk Assessment'!I26","v":0},""]
[null,"Theft",{"$f":"'Risk Assessment'!F27","v":"Not Rated"},{"$f":"'Risk Assessment'!H27","v":""},null,{"$f":"'Risk Assessment'!G27","v":0},null,{"$f":"'Risk Assessment'!I27","v":0},""]
["Information","Unauthorised access to physical records",{"$f":"'Risk Assessment'!F28","v":"Not Rated"},{"$f":"'Risk Assessment'!H28","v":""},null,{"$f":"'Risk Assessment'!G28","v":0},null,{"$f":"'Risk Assessment'!I28","v":0},""]
[null,"Unauthorised access to CCTV footage",{"$f":"'Risk Assessment'!F29","v":"Not Rated"},{"$f":"'Risk Assessment'!H29","v":""},null,{"$f":"'Risk Assessment'!G29","v":0},null,{"$f":"'Risk Assessment'!I29","v":0},""]
[null,"Extortion",{"$f":"'Risk Assessment'!F30","v":"Not Rated"},{"$f":"'Risk Assessment'!H30","v":""},null,{"$f":"'Risk Assessment'!G30","v":0},null,{"$f":"'Risk Assessment'!I30","v":0},""]
[null,"Cybersecurity leak",{"$f":"'Risk Assessment'!F31","v":"Not Rated"},{"$f":"'Risk Assessment'!H31","v":""},null,{"$f":"'Risk Assessment'!G31","v":0},null,{"$f":"'Risk Assessment'!I31","v":0},""]
[null,"Unwanted media attention",{"$f":"'Risk Assessment'!F32","v":"Not Rated"},{"$f":"'Risk Assessment'!H32","v":""},null,{"$f":"'Risk Assessment'!G32","v":0},null,{"$f":"'Risk Assessment'!I32","v":0},""]
["Risks specific to my school "]
["My School",{"$f":"'Risk Assessment'!B34","v":0},{"$f":"'Risk Assessment'!F34","v":"Not Rated"},{"$f":"'Risk Assessment'!H34","v":""},null,{"$f":"'Risk Assessment'!G34","v":0},null,{"$f":"'Risk Assessment'!I34","v":0},{"$f":"IF(D31=\"\",\"\",IF(D31=\"No\",\"No\",IF(AND(F31=\"Yes\",G31=\"Highly effective in reducing the risk\",H31=\"No\"),\"No\",IF(AND(F31=\"Yes\",G31=\"Highly effective in reducing the risk\",H31=\"Yes\"),\"Monitor\",\"Yes\"))))","v":""}]
[null,{"$f":"'Risk Assessment'!B35","v":0},{"$f":"'Risk Assessment'!F35","v":"Not Rated"},{"$f":"'Risk Assessment'!H35","v":""},null,{"$f":"'Risk Assessment'!G35","v":0},null,{"$f":"'Risk Assessment'!I35","v":0},{"$f":"IF(D32=\"\",\"\",IF(D32=\"No\",\"No\",IF(AND(F32=\"Yes\",G32=\"Highly effective in reducing the risk\",H32=\"No\"),\"No\",IF(AND(F32=\"Yes\",G32=\"Highly effective in reducing the risk\",H32=\"Yes\"),\"Monitor\",\"Yes\"))))","v":""}]
[null,{"$f":"'Risk Assessment'!B36","v":0},{"$f":"'Risk Assessment'!F36","v":"Not Rated"},{"$f":"'Risk Assessment'!H36","v":""},null,{"$f":"'Risk Assessment'!G36","v":0},null,{"$f":"'Risk Assessment'!I36","v":0},""]
[null,{"$f":"'Risk Assessment'!B37","v":0},{"$f":"'Risk Assessment'!F37","v":"Not Rated"},{"$f":"'Risk Assessment'!H37","v":""},null,{"$f":"'Risk Assessment'!G37","v":0},null,{"$f":"'Risk Assessment'!I37","v":0},""]
[null,{"$f":"'Risk Assessment'!B38","v":0},{"$f":"'Risk Assessment'!F38","v":"Not Rated"},{"$f":"'Risk Assessment'!H38","v":""},null,{"$f":"'Risk Assessment'!G38","v":0},null,{"$f":"'Risk Assessment'!I38","v":0},""]
[null,{"$f":"'Risk Assessment'!B39","v":0},{"$f":"'Risk Assessment'!F39","v":"Not Rated"},{"$f":"'Risk Assessment'!H39","v":""},null,{"$f":"'Risk Assessment'!G39","v":0},null,{"$f":"'Risk Assessment'!I39","v":0},""]
[null,{"$f":"'Risk Assessment'!B40","v":0},{"$f":"'Risk Assessment'!F40","v":"Not Rated"},{"$f":"'Risk Assessment'!H40","v":""},null,{"$f":"'Risk Assessment'!G40","v":0},null,{"$f":"'Risk Assessment'!I40","v":0},""]
[null,{"$f":"'Risk Assessment'!B41","v":0},{"$f":"'Risk Assessment'!F41","v":"Not Rated"},{"$f":"'Risk Assessment'!H41","v":""},null,{"$f":"'Risk Assessment'!G41","v":0},null,{"$f":"'Risk Assessment'!I41","v":0},""]
[null,{"$f":"'Risk Assessment'!B42","v":0},{"$f":"'Risk Assessment'!F42","v":"Not Rated"},{"$f":"'Risk Assessment'!H42","v":""},null,{"$f":"'Risk Assessment'!G42","v":0},null,{"$f":"'Risk Assessment'!I42","v":0},""]
[null,{"$f":"'Risk Assessment'!B43","v":0},{"$f":"'Risk Assessment'!F43","v":"Not Rated"},{"$f":"'Risk Assessment'!H43","v":""},null,{"$f":"'Risk Assessment'!G43","v":0},null,{"$f":"'Risk Assessment'!I43","v":0},""]

{"sheet":"Action Plan","index":4,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,2]]}
["Action plan"]
["For more information about strategies to mitigate security risks, refer to:"]
["• Your School Security Advisor in Infrastructure Services"]
["• The School security management pages on OnePortal"]
["Identified strategy/control","Type","Risk","Actions to implement","Resources required","Responsible officer","Progression update/review required by:"]
["What is the strategy/process/control that has been identified to implement/expand/develop?","What category does the measure qualify as?","What risks and risk categories are expected to be mitigated with the strategy/control?","What actions are requried to implement the strategy/control?","What funding/resources are required to implement the strategy/control?","Who will manage actions for the strategy/control?","Date"]