Description:
Spreadsheets such as Excel, are available for creating a wide range of end user applications, including widespread use in the laboratory, creating customized statistical analyses, the creation of local databases, data mining, and multivariate analysis. These may be used for GxP regulated activities, and they present particular compliance challenges, as Excel and other spreadsheets are not originally designed for the regulated environment.
GxP records generated by spreadsheet calculations are electronic records and should comply with FDA's 21 CFR Part 11 and the European Annex 11. For critical records Part 11 controls, such as data accuracy and data integrity, should be implemented. Currently there are no specific industry FDA guidelines on using spreadsheets in regulated environments. However, the flexibility and power of the spreadsheet allows users to create tools that range from performing simple calculations to sophisticated analysis of a major clinical study, or laboratory or manufacturing data.
This makes spreadsheets a very powerful and useful tool in the GxP environment especially when coupled with the fact that it is easy to build spreadsheet applications without much training. However, this has resulted in spreadsheets being among the most under-documented systems used in GxP environments because:
users regard them as part of the desktop
the ease with which applications can be built without much training
the data processing power that they can have
lack of knowledge that spreadsheets need to be validated
lack of knowledge on how to validate spreadsheets
Consequently, Spreadsheets have become "low hanging fruit" during FDA or other regulatory inspections and many warning letters have been issued.
Areas Covered in the Session:
Part 11 / Annex 11 Computer Systems Validation (CSV) is be implemented in order to increase the integrity, accountability and security of the spreadsheets and achieve GxP Compliance. CSV enables the level and rigor of specification and verification applied to spreadsheets to be based on spreadsheet risk, complexity, and novelty. This hands-on seminar will provide the attendees with the tools for successful computer systems validation for Excel Spreadsheets. It will address the following topics:
Types and Uses of Excel Spreadsheets (e.g. disposable spreadsheets, spreadsheets used as documents, etc.)
Risk Based Approach and Controls to Excel Spreadsheets (incl. Excel specific risks)
Computer Systems Validation for Excel (will cover 21 CFR 11, Annex 11)
The FDA's Perspective and Use of Spreadsheets
Examples of Typical Approaches for Excel Validation
How to tailor your risk based methodology to Excel to determine the level of validation required
483s and Warning Letters for Excel and other Spreadsheets
Quiz: Test your understanding of Computer Systems Validation for Excel
Who will benefit:
VP of IT
Director of IT
Quality Managers
Project Managers (for CSV / IT)
Validation Specialists
Database Administrators
System Administrators
Directors / Senior Directors of Discovery
Directors / Senior Directors of Development
Directors / Senior Directors of Commercialization
Document Managers
Training Managers
Regulators
Agenda:
Day 1 Schedule
Lecture 1: Types of Spreadsheets
Introductions / Participants' Understanding / Participants’ Objectives for the Course (Please come prepared to discuss)
Types of Excel Spreadsheets
Uses of Excel Spreadsheets
Lecture 2: Excel Validation at a High Level
21 CFR 11 / Annex 11 & CSV - Basic Concepts
CSV components and deliverables
Lecture 3: FDA Use of Excel Spreadsheets
GxP Compliance for Excel - an FDA Perspective
FDA Use of Compliant Excel Spreadsheets - an FDA Case Study
Lecture 4: Excel Validation Master Plan (VaMP)
Validation Inventory
Determining need for GxP Compliance
Excel Validation Master Plan Standards
Exercise to create Excel Validation Master Plan
Day 2 Schedule
Lecture 1: Excel Risk Assessment & Requirements
Risk Assessment
Tailoring Risk Methodology to Excel
Validation Plan
Requirements Specifications
Exercise on how to create Excel requirements
Lecture 2: Excel Functional & Design Specification
Functional & Design Specifications
Software Configuration and Build
Exercise on how to create Excel Design Specifications
Lecture 3: Verification & Testing for Excel CSV
Traceability Matrix
Verification and Testing
Exercise Creating Excel Validation Scripts
Validation Report
Validation Registry
SOPs
Lecture 4: Quality Assurance for Excel CSV
How to audit Excel CSV projects
Excel 483s and Warning Letters
Excel Validation Jeopardy !!!
Speaker:
Angela Bazigos
CEO, Touchstone Technologies Silicon Valley
Seasoned Executive with 40 years of experience in the Life Sciences & Healthcare Industries. Positions include Chief Compliance Officer. Experience combines Quality Assurance, Regulatory Compliance, Business Administration, Information Technology, Project Management, Clinical Lab Science, Turnarounds and Business Development. Past employers / clients include Roche, Novartis, Genentech & PriceWaterhouseCoopers. Co-authored & prototyped 21 CFR 11 guidance with FDA.
Location: Salt Lake City, UT Date: November 15th & 16th, 2018 and Time: 9:00 AM to 6:00 PM
Venue: Hilton Garden Inn Salt Lake City Airport 4975 Wiley Post Way, Salt Lake City, Utah, 84116, USA
Price:
Until October 10, Early Bird Price: $1,295.00 Price: $1,295.00 (Seminar Fee for One Delegate)
From October 11 to November 14, Regular Price: $1,495.00
Register for 5 attendees Price: $3,885.00 $6,475.00 You Save: $2,590.00 (40%)*
Register for 10 attendees Price: $7,122.00 $12,950.00 You Save: $5,828.00 (45%)*
Register now and save $200. (Early Bird)
Sponsorship Program benefits for seminar
For More Information- https://www.globalcompliancepanel.com/control/sponsorship
Contact us today!
NetZealous LLC DBA GlobalCompliancePanel
Toll free: +1-800-447-9407
Phone: +1-510-584-9661
Website: http://www.globalcompliancepanel.com
Registration Link - https://www.globalcompliancepanel.com/control/globalseminars/~product_id=901888SEMINAR?seo
Follow us on LinkedIn: https://www.linkedin.com/company/globalcompliancepanel/
Like us our Facebook page: https://www.facebook.com/TrainingsAtGlobalCompliancePanel/
Follow us on Twitter: https://twitter.com/GCPanel