Getting Started – Preparing to Automate your CSV Practices
Discuss why CSV is well-suited to automation
Preparing templates for documents and certain types of systems
Determine and execute your testing strategy
Formalize your strategy in a Validation Master Plan
Implement best practices for lean project management
Automation of CSV Document Generation
Breaking down systems into discrete validatable objects
Collecting testable requirements
Automatically create your list of testable objects
Generating Design Specifications directly from source code
Integrating Risk Assessments into the process
Automatic generation, tracking and updating of the Requirements Traceability Matrix
Test Cases and Test Plans
How much testing is enough? Testing based on Risk Assessments
Input testing, Challenge Testing, Unit & Workflow test cases
Automating common test scripts with mini-test cases
Create specific test cases for use with change control
Auto-creation of test scripts from your requirements
Protocol Execution, Documentation and Managing Deviations
Paper vs. Electronic execution
Capturing actual results and screen shots for maximum effectiveness
Generating, processing and closing test and script deviations
Interactive Exercise: Case Studies of CSV Automation Success Stories
Several case studies will be presented to demonstrate how different types of validation projects were automated using the techniques described above. We will also discuss how the FDA is using automation for spreadsheet validation in their own labs.
Presented by Tyson M. Mew, President, Ofni Systems, Inc.
11th Annual Computer and Software Validation
Presented by IVT