Course Information Our extensively proven course delves into the essential stages of process and system auditing. Gain invaluable insights and direction in auditing systems and processes, spanning across global and local organisational levels. This course will assist delegates with: A practical approach for the development and conduct of process and system audits An enhanced understanding of key system audit principles, preparation, design and conduct Increased expertise, efficiency and confidence. This course is structured to encourage delegates to: Discuss and develop ideas Solve specific problems Share knowledge and experiences. By the end of the course delegates will be better able to: Design and plan more effectively to achieve their process and systems audit objectives and add value to their organisation Improve the effectiveness, focus and credibility of the audit programme Understand the key system audit principles, preparation, design and conduct Develop system audit tools to ensure more effective audit conduct and outcome Create audit strategies utilising risk management principles Prepare for inspections. Tutors Tutors will be comprised of (click the photos for biographies): Allison Jack Executive Director, Bristol Myers Squibb Rocio Castellanos Director, Pfizer Ltd Guy Houben G(C)LP Auditor, Janssen Pharmaceutical Companies of Johnson & Johnson Programme Please note timings may be subject to alteration. Day 1 08:50 Registration 09:00 Welcome and Introductions, Expectations/Challenges/Experiences A discussion to explore the range of approaches to the conduct of systems audit. 09:30 Introducing Systems Audit What is a system? Why conduct system audits? Advantages, disadvantages and challenges. 10:20 Break 10:35 Systems Audit Design and Planning Identifying the customer, setting objectives, development of the audit plan and audit tools, plans for the audit report. 12:00 Designing System Audit Tools 12:45 Lunch 13:30 System Audit Plan - Exercise 14:00 Introduction to Case Studies The objectives of the case studies are defined and process and outputs described. 14:15 Case Studies - Session 1 A first opportunity for work on case studies. Defining objectives and scope and understanding the requirements of the audit client. 15:00 Break 15:20 Case Studies - Session 1 continued 16:30 Case Studies - Feedback 17:00 Close of Day 1 Day 2 09:00 Simple System Audit Example - Introduction The objectives of the case studies are defined and process and outputs described. 09:10 Case Studies - Session 2 - A Simple System Audit Example An example of system audit applied to a simple system. 10:30 Break 10:45 A Simple System Audit Example - Case Study Feedback 11:30 Strategy Audit programme planning. 12:15 Lunch 13:00 Case Studies - Session 3 Work on delegate's case studies. 14:30 Break 14:45 Case Studies - Session 3 - Feedback 15:15 Closing remarks 15:30 Close of course Extra Information Face-to-face course Course Material Course material will be available in PDF format for delegates attending this course. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course. The material will be emailed in advance of the course and RQA will not be providing any printed copies of the course notes during the training itself. Delegates wishing to have a hard copy of the notes should print these in advance to bring with them. Alternatively delegates are welcome to bring along their own portable devices to view the material during the training sessions. Remote course Course Material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking. You will need a stable internet connection, a microphone and a webcam. CPD Points 14 Points Development Level Develop
Price £750 inc VAT Finance options In Company training - £750 for groups of up to 8 delegates. Discounts for Nonprofits/Charities... Study method On-site Duration 2 days, Full-time Qualification No formal qualification Certificates Certificate of completion - Free Additional info Tutor is available to students Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Description Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements General knowledge of the Windows OS Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills
Sustainable, Corporate Christmas Wreath Making Workshops in London, Oxford and Oxfordshire. Craft eco-friendly Christmas Wreaths , a perfect Christmas team building activity
Course Information Our comprehensive course is used as a gateway to those stepping into the world of auditing clinical studies. Tailored for those already acquainted with Good Clinical Practice (GCP) and those transitioning from other audit disciplines, this programme stands as a pivotal guide. Pre-existing knowledge of GCP will significantly enhance your learning experience in auditing against these guidelines. How is this course run? Engage in immersive workshops providing hands-on practice with auditing techniques in a GCP context. Our seasoned tutors, boasting extensive audit experience, intertwine theory with practical insights drawn from their own professional journeys. What will I learn? A comprehensive understanding of the historical backdrop and objectives driving Good Clinical Practice, incorporating the latest industry developments Solid grounding in quality assurance activities aligned with regulatory standards Insight into potential pitfalls within clinical trials and the pivotal role of auditors in addressing these issues Clarity on the roles and responsibilities inherent to clinical trials auditing Exposure to a diverse range of audit techniques complemented by illustrative examples and supportive documents A nuanced understanding of regulatory inspectors' activities Expanded professional networks to propel your auditing career forward. Benefits include: A clear understanding of the role of the auditor under Good Clinical Practice improved audits Improved Good Clinical Practice compliance for your clinical trials. This course is structured to encourage delegates to: Discuss and develop ideas Solve specific problems Examine particular aspects of Good Clinical Practice. Tutors Tutors will be comprised of (click the photos for biographies): Rosemarie Corrigan EVP Global Quality, Worldwide Clinical Trials Cathy Dove Director and Owner, Dove Quality Solutions Julie Kelly Associate Director, Clinical Quality Assurance, Corcept Therapeutics Susana Tavares Director of Research Quality Assurance, - Programme Please note timings may be subject to alteration. Day 1 12:30 Registration 13:00 Welcome and Objectives for the first day of the course 13:30 Laying the Foundations Introduction to the clinical development process, the concepts of quality assurance, quality control and audit. 14:30 Break 15:00 Patient Protection Requirements for informed consent and ethics committee. Access to source documentation. Including a patient protection exercise. 16:05 Workshop 1 - Case Study on Informed Consent 16:45 End of Day Questions and Answers 17:00 Close of Day Day 2 08:50 Questions and Answers from Day 1 09:00 Effective Site Audits The procedures involved in selecting and setting up audits at investigator sites. 09:40 Workshop 1 - Planning the Effective Audit 10:30 Break 10:45 Source Data Verification The need for and purpose of verifying data. 11:25 Workshop 2 - Source Data Verification 12:30 Lunch 13:30 IMP Management The requirements surrounding the distribution of investigational medicinal products. Accountability from release to destruction. 14:15 Critical Document Audits The conduct of other study specific audits including protocols, databases and reports. 15:00 Break 15:15 Non-compliance Determining the acceptability of data. 16:00 Fraud - Fact or Fiction? How to identify fraud and its consequences 16:45 End of Day Questions and Answers 17:00 Close of Day Day 3 08:50 Questions and Answers from Days 1 and 2 09:00 Auditing Third Parties A review of audits of contract research organisations. 10:00 System Audits The concept of auditing processes across many clinical trials, including a practical exercise in process mapping. 10:45 Break 11:00 Workshop 3 - Process Mapping 11:45 Effective Audits Where theory meets reality. 12:30 Lunch 13:20 Audit Reports - Closing the Loop An examination of the processes which follow the evidence gathering phase of the audit. 14:20 Workshop 4 - Audit Reports Audit reports, corrective and preventive action. 15:00 Break 15:10 Regulatory Inspection Auditors and regulatory inspections -how the QA team can help the organisation to perform during a regulatory inspection. 15:55 Final Questions and Answers 16:10 Close of Course Extra Information Face-to-face course Course Material Course material will be available in PDF format for delegates attending this course. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course. The material will be emailed in advance of the course and RQA will not be providing any printed copies of the course notes during the training itself. Delegates wishing to have a hard copy of the notes should print these in advance to bring with them. Alternatively delegates are welcome to bring along their own portable devices to view the material during the training sessions. Remote course Course Material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking. You will need a stable internet connection, a microphone and a webcam. CPD Points 17 Points Development Level Develop
This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print
This one-day workshop focuses on building a professional presentation from scratch, giving you essential hints and tips on how to utilise the key features of PowerPoint, including speaker notes, inserting charts, diagrams and pictures, and utilising slide transitions and animation. You will also learn about PowerPoint templates and themes to ensure your presentations have the best impact. This course will help participants: Using Slide Master Create a presentation using a template Insert slides and change the layout Manage slides and control formats Enhance slides using animation, pictures, charts and graphics Work with tables, rows, cells and columns Create and control paragraph lists Insert titles and labels Effectively use slide show controls and presenter view Print slides, handouts and notes 1 Introduction to PowerPoint Navigating the features Creating a simple presentation Inserting new slides and changing layouts Creating speaker notes 2 Using Layouts in Slide Master Editing templates in slide master Adding a design theme Adding transitions, pictures and logos Using Slide Show View 3 Drawing shapes and SmartArt Using Drawing Tool Formats Creating shapes Aligning shapes and stacking order Creating a cycle graphic Creating an organisation chart 4 Animation Visually enhancing slides with animation Using text and object animation Adding animation to lists Making animation work for you 5 Presenting Confidently running a presentation Using presenter view Using the slide show controls
COBOL training course description A hands on training course providing an introduction to COBOL. What will you learn Write COBOL programs Debug COBOL programs Examine existing code and determine its function. COBOL training course details Who will benefit: Programmers working with COBOL. Prerequisites: None although experience in another high level language would be useful. A 10 day version of this course would be more applicable for those new to programming. Duration 5 days COBOL training course contents Introduction to COBOL Compilation, linkage editor. Compile errors, compiler options. Divisions, syntax and format, COBOL character set, program structure. COBOL statement structure COBOL words, format of statements. Divisions Identification entries, Environment entries, Data division: FD, record descriptions, hierarchy and level numbers, description-string entry. File and Working-Storage Sections Literals, figurative constants, redefines clause, data representation, Usage clause, synchronization, sign clause. Procedure Division File status codes; Open, Read, Write, Close, Stop, Goback; Accept, display; Move, Justified, data name qualification, reference modification. Perform statement Out-of-line, With test ... Until, ... Times, in-line statement; Go to statement. Program design Design techniques, design considerations, procedure names, program structure. Printing Printed output, Write, advancing option, editing characters; Initialize. Condition testing Conditional statements: IF, class, sign and relation conditions, condition-name conditionals, Set, compound conditions, logical operators. Evaluate, Continue. Arithmetic Rounded option, On Size Error option, Add, Subtract, Multiply, Divide, Compute. Non-sequential files File access modes, Select. Indexed and relative files. Open, Close, creating / reading sequential access files, Write, Read, Invalid key clause, reading, writing / updating Random access files, Rewrite, Delete, Start. Declarative routines Clauses. Subroutines Call, Using clause - calling program/called program, Linkage Section, returning control. Table handling Subscripted tables: One/two/three dimensional tables, Perform, variable length tables. Indexed tables: Set, using an index; Search. Copy code: Copy, Suppress, Replacing. Data Manipulation Inspect, String, Unstring. COBOL/370 LE/370 and Intrinsic Functions.
This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report
Supporting Windows 10 course description This course is designed to provide students with the knowledge and skills required to support and troubleshoot Windows 10 PCs and devices in a Windows Server domain environment. These skills include understanding of Windows 10 features, how they can be used in an Active Directory environment and how to troubleshoot them. What will you learn Troubleshoot startup issues and operating system services on a Windows 10 PC. Troubleshoot issues related to network connectivity. Troubleshoot client configuration failures and GPO application issues. Troubleshoot issues related to application installation and operation. Recover a PC running Windows 10. Supporting Windows 10 course details Who will benefit: Anyone supporting users running Windows 10 personal computers within a medium to large enterprise. Prerequisites: None. Duration 5 days Supporting Windows 10 course contents Implementing a Troubleshooting Methodology Overview of Windows 10, Introduction to the EDST Job Role, Overview of the Troubleshooting Steps & Tools. Hands on Implementing a Troubleshooting Methodology. Hands on Using Troubleshooting Tools for Windows 10. Troubleshooting Startup Issues Overview of the Windows 10 Startup Recovery Environment, Troubleshooting Startup Settings & Operating System Services Issues, Recovering BitLocker-Protected Drives. Hands on Troubleshooting Startup Issues. Hands on Recovering BitLocker-Encrypted Drives, Creating a New BitLocker Password. Troubleshooting Hardware and Device Drivers Troubleshooting Device Driver Failures & Physical Failures, Overview of Hardware Troubleshooting, Monitoring Reliability, Configuring the Registry. Hands on Troubleshooting Device Driver Issues, Resolving Hardware Issues, Adding a Missing Device Driver to a Driver Store, Reverting a Problematic Device Driver. Hands on Troubleshooting Hardware Issues, Diagnosing Memory, Troubleshooting and Repairing Failed Disk Redundancy Synchronizing Settings, Accessing Data on a Foreign Volume. Troubleshooting Remote Computers Using Remote Desktop and Remote Assistance, Remoting with Windows PowerShell Hands on Troubleshooting Remote Computer by using Remote Desktop and Remote Assistance. Hands on Troubleshooting Remote Computer by using Windows PowerShell. Resolving Network Connectivity Issues Determining Network Settings, Troubleshooting Network Connectivity Issues, Troubleshooting Name Resolution. Hands on Resolving Network Connectivity Issues. Hands onResolving Name Resolution Issues. Troubleshooting Group Policy Overview of Group Policy Application, Resolving Client Configuration Failures and GPO Application Issues. Hands on Troubleshooting Group Policy Application Issues. Hands on Resolving Group Policy Issues. Hands on Installing and Sharing a Printer. Troubleshooting User Settings Troubleshooting Sign In Issues, Troubleshooting the Application of User Settings. Hands on Troubleshooting Sign in Problems. Hands on Troubleshooting the Application of User Settings, Resolving Folder Redirection Problem, Resolving Roaming User Profile Problem. Troubleshooting Remote Connectivity Troubleshooting VPN Connectivity Issues & DirectAccess. Hands on Troubleshooting VPN Connectivity Lab : Configuring and Troubleshooting DirectAccess Configuring and Verifying, DirectAccess Client-Side Settings, Troubleshooting DirectAccess. Troubleshooting Resource Access Within a Domain & File Permissions Issues, Recovering Files Encrypted by EFS, Troubleshooting Printer Access Issues. Lab : Troubleshooting File Access Issues Lab : Troubleshooting Access to Encrypted Files. Hands on Troubleshooting Printer Access Issues Troubleshooting Resource Access for Non Domain Member Clients Configuring and Troubleshooting Device Registration, Configuring and Troubleshooting Work Folders, Configuring and Troubleshooting OneDrive Access. Hands on Troubleshooting Resource Access for Clients that are not Domain Members. Troubleshooting Device Registration, Work Folders and OneDrive for Business. Troubleshooting Applications Troubleshooting Desktop App Installation Issues, Desktop Apps, Managing Windows Store Apps, Troubleshooting Access to Company Web Applications. Hands on Troubleshooting Desktop Apps, AppLocker Policy Application & Application Compatibility issue. Hands on Troubleshooting Access to Company Web Applications, Internet Explorer Issue & Microsoft Edge. Maintaining Windows 10 Managing & Troubleshooting Windows Activation, Troubleshooting Performance, Applying Applications. Hands on Monitoring and Troubleshooting Performance. Recovering Data and Operating System File Recovery in Windows 10, Recovering an OS. Hands on Recovering Data, Recovering Data from Azure Backup, Recovering Deleted File by Using File History. Hands on Provisioning Computer to Comply with Company Standards, Provision Computer to Comply with Company Standards.
Complete C programming training course description A hands-on introduction to programming in the ANSI C programming language. The course initially moves at a fast pace in order to spend as much time as possible on the subject of pointers - the area which cause the most bugs in C programs. What will you learn Write ANSI C programs Use the C libraries Debug C programs Examine existing code and determine its function. Complete C programming training course details Who will benefit: Programmers wishing to learn C. Programmers wishing to learn C++ or Java. Prerequisites: None, although experience in another high level language would be useful. Duration 5 days Complete C programming training course contents Getting started The compilation process, comments, main(), statement blocks, printf(). C data types and operators char, int, float and double, qualifiers, arithmetic and assignment operators, precedence, Associativity. Basic I/O C libraries, stdin and stdout, getchar(), putchar(), printf() formatting. Flow control if else, dangling elses, else if, while and for loops. switch statements, the null statement, break, continue and gotos. Functions Function calls, arguments and return types, function declarations (prototypes), function definitions, scope of variables. The preprocessor Preprocessor actions, macros, #include. Libraries and their relationship with header files. Conditional compilation. More data types and operators Logical, bitwise and other operators, type conversion, casting, typedefs and access modifiers. Arrays Declaring and handling arrays, common gotchas, multidimensional arrays. Pointers What are pointers? Why they are so important, declaring and using pointers,The three uses of the *,pointer example - scanf, pointers as arguments. More pointers Golden rules of pointers and arrays, pointers to arrays, pointer arithmetic, arrays of pointers, multiple indirection. Character/string manipulation Arrays of characters, string definition, working with strings, String library. Program arguments argc and argv, example uses,char *argv[] versus char ** argv. Program structure and storage classes Globals (externals), multi source programs, the look of a C program. Structures Declaration, the . and - operators, unions and bitfields. Library functions File handling, fopen and fclose, reading from and writing to files, fseek().calloc() and malloc()