Draft Course Description

Central to any SMS are the data and information collected and displayed. The demands for data and information are great and, for the most part, there are few "tools" available that meet the requirements and those few that come close are complicated to use.  Moreover, many organizations have stand alone databases that can't communicate with each other. In some instances, safety professionals are new to job with little background in information systems and in some cases have no staff and there is less than a year before being rotated on to other positions.   How then is an SMS information system to be created and maintained that meets the requirements of SMS?  For those organizations that have large safety departments and large databases, what is the most cost-effective way to discover and track hazards, and support risk management decisions to control them?  Without the necessary information system to support the needs of a Safety Management System for identifying and controlling risk,  it is unlikely that any organization can fully and effectively meet the standards for an SMS.  This course is designed to address all these issues and demonstrate through hands on experience how to harness the power of an SMS database as part of your Safety Management System.

Who Should Attend

• Any safety professional who is responsible for or uses data and information in a SMS
• Managers, supervisors, and safety professionals who have responsibility creating and maintaining data and information to support a SMS

How You will Benefit

• You will be introduced to the current challenges and solutions to collecting and using data and information in safety management systems

• You will learn how to use a state of the art database management system/decision support system in an SMS by entering data and displaying information in hands on exercises

• You will learn through hands on exercises how data and information can be gathered, stored, and used in an SMS

• You will learn and practice using hands on exercises how to develop and implement an SMS database within your organization that fully supports your SMS

• You will learn how to use expert systems help you if your are new to safety and gathering data and displaying information

• You will learn data mining techniques in safety

• You will learn how to effectively search very large databases for data that are important to your operation

• You learn how different safety databases can be linked together 

• This course is one of the elective courses in the SCSI certificate in Safety Management Systems

• This course is accepted by the Board of Certified Safety Professionals for Continuance of Certification Credit.

• SCSI will award 3.6 CEUs to each participant who successfully completes this course.

Draft of Course Topics

• Role of Information and Data in SMS
• Industry Safety Databases
• SMS Information and Data Requirements
• Capturing data and Displaying Information
• Database Management Systems/Decision Support Systems
• Illustration of DBMS using Excel and Access
• Introduction to SMSPRO DBMS/DSS
• Creating an Operational Risk Profile in SMSPRO
• Creating a Hazard Reporting and Information System in SMSPRO
• Creating Safety Planning and Performance Criteria
• Managing Risk with SMSPRO
• Internal Evaluation with SMSPRO
• Analyzing Safety Data in SMSPRO™; Incidents, Accidents, Occurences 
• Managing SMS Meetings in SMSPRO
• Managing Costs and ROI in SMSPRO™
• In Basket Class Exercises, examples, data input exercises
• Briefing Managers using the output of SMSPRO
• Using Expert Systems in Safety
• Using Expert Systems with SMSPRO
• Safety Data Mining
• Linking Different Safety Databases
• OLAP
• Management Briefing Exercise
• Group Briefings to Management Exercise

 

Draft Course Schedule
2008	Monday	TUESDAY	WEDNESDAY	THURSDAY	FRIDAY
0800 - 0850	1. Administration Student Introductions Course Introduction Peter Gardiner	9. Creating an Operational Risk Profile in SMSPRO Examples and Data Input Exercises	17. In-basket class exercises using SMSPRO.	21.  Using Expert Systems in Safety Examples Class Exercises in Rule Definition  Tony Leal	28. Group Briefings to Management   Group Briefings and Critiques of Presentations   GRADUATION   Peter Gardiner   Brendan McCormack
0900 - 0950	2. Recap of Safety Management Systems Role of Information and Data in SMS Industry Safety Databases (ASRS, NTSB, CADORS) Brendan McCormack	10. Creating a Hazard Reporting and Information Systems in SMSPRO. Examples and Data Input Exercises		22. Using Expert Systems with SMSPRO. Rule Finalization and Class Exercise Tony Leal
1000 - 1050	3. SMS   Information and Data Requirements What data?  How displayed? Brendan McCormack	11. Creating Safety Planning and Performance Criteria In SMSPRO Examples and Data Input Exercises		23.  Safety Data Mining Examples and Cass Exercises   Tony Leal
1100 - 1150	4.  SMS Information and Data Functional Requirements Capturing data and displaying information  Brendan McCormack	12. Managing Risk with SMSPRO Examples and Data Input Exercises		24.   Linking Different Safety Databases. Examples and Cass Exercises Tony Leal
1200 - 1300                                                     LUNCH

1300 - 1350	5. Using MS Excel (capabilities and limitations, examples) Brendan McCormack	13. Internal Evaluation in SMSPRO Examples and Data Input Exercises	18. In-basket class exercises using SMSPRO.	25.  Linking Different Safety Databases (continued) Examples and Class Exercises Tony Leal
1400 - 1450	6. Using MS Access (capabilities and limitations and examples) Brendan McCormack	14.  Analyzing Safety Data in SMSPRO™; Incidents, Accidents, Occurences.  Examples and Data Input Exercises Brendan McCormack		26. OLAP Examples and Class Exercises Tony Leal
1500 - 1550	7.  Introduction and Demonstration of SMSPRO Brendan McCormack	15.Managing SMS Meetings in SMSPRO. Examples and Data Input Exercises Brendan McCormack	19  Briefing Managers.  What managers want to know? Questions Managers will Ask	27. Group Preparation for Management Briefing Exercise Brendan McCormack
1600 - 1650	8.  Introduction and demonstration of SMSPRO (continued) Brendan McCormack	16.  Managing Costs and ROI in SMSPRO™ Examples and Data Input Exercises Brendan McCormack	20. Briefing Managers using the output of SMSPRO. Brendan McCormack

 

Course Administration

Taught  in Southern California, the SMS Database Essentials Course consists of 4.5 days (36 hours) of classroom instruction. Participants receive lecture outlines, additional reference material, and a Certificate of Completion. Classes begin at 0800 and end at noon on the last day.

SCSI will also arrange for delivery of this course under contract at a location and duration of your choice.

Course Instructors

• Brendan McCormack

• Tony Leal

• Peter C. Gardiner

Typical Comments From Attendees

• This is a new course

Course Schedule, Location and Tuition

• Course Tuition
• See Course Schedule
• Contact SCSI Directly for Information