Air safety data analysis
Updated 4 October 2022
© Crown copyright 2022
This publication is licensed under the terms of the Open Government Licence v3.0 except where otherwise stated. To view this licence, visit nationalarchives.gov.uk/doc/open-government-licence/version/3 or write to the Information Policy Team, The National Archives, Kew, London TW9 4DU, or email: psi@nationalarchives.gov.uk.
Where we have identified any third party copyright information you will need to obtain permission from the copyright holders concerned.
This publication is available at https://www.gov.uk/government/publications/air-safety-data-analysis-asda/air-safety-data-analysis
Course aim
This course is aimed at personnel conducting analysis of air safety data. The content is targeted at individuals who are inexperienced in this function and will provide the foundation skills required to extract, transform, understand, and present data from Defence Air Safety Occurrence Reports (DASOR).
The key training aims of this course are to:
- enable delegates to search and extract data from Air Safety Information Management System (ASIMS) and other data sources
- utilise MS Excel to interpret and transform the data, thereby creating meaningful analysis (eg through formulae creation; data aggregation with pivot tables; data joining; creating metrics; linear regression; and charting tools)
- enable delegates to tailor the presentation of analysis to specific audiences using a variety of styles (eg pivot charts, stand-alone charts and aggregate charts)
UK military personnel will be awarded the ASDA JPA training record following successful completion of the course.
Units and Duty Holder organisations can directly purchase this and other Safety Management System training courses.
Applicability
Training is a blend of taught sessions, facilitated discussions and group exercises and is aimed at individuals who will be analysing Aviation data.
Prerequisites
Personnel should have Human Factors and Error Management Foundation level training as a minimum before attending the course. Understanding can be gained from accessing local awareness training at your unit / organisation delivered by Human Factors Qualified Facilitators or Instructors.
Personnel should have a current ASIMS Login.
The course has a heavy focus on the use of MS Excel and ASIMS and personnel will need to be familiar with this software before attending:
- competently orientate around Excel, menu structure, ribbon items etc
- ability to open, save, save as worksheets to various locations
- knowledge of usage of SUM and COUNT functions would be advantageous
- knowledge of relative and absolute references would be advantageous
- knowledge of principles of pivot tables would be advantageous
For those wishing to develop their basic skills prior to attending this course, a variety of E-learning courses are available on ASIMS in addition to MS Excel courses available online (eg the Defence Learning Environment), and Microsoft Support
Duration
3 day
Location
A number of ASDA courses are delivered at the Centre of Air Safety Training (CoAST), Defence Academy, Eisenhower, Shrivenham but may not satisfy overall requirements. Please contact your local STEP point of contact or email dsa-maacourses@mod.gov.uk for more details.