29988 OV courses

5-day intensive data protection course, delivered by a specialist.

Course Information A must-have programme for Quality Assurance auditors stepping into or honing their role within a Good Laboratory Practice (GLP) environment, this course offers invaluable, expert guidance for crafting a robust and efficient GLP audit programme. What will I learn? A solid regulatory foundation underpinning quality assurance activities Clarity on the roles of Quality Assurance, management, and study director within the framework of Good Laboratory Practice principles Enhanced efficacy in inspections and audits Heightened compliance with Good Laboratory Practice standards for your facility Unique insights into governmental monitoring activities within the GLP sphere. This course is structured to encourage delegates to Discuss and develop ideas Solve specific problems Examine particular aspects of GLP. Tutors Tutors will be comprised of (click the photos for biographies): Cate Ovington Director, The Knowlogy Group Ltd Jane Elliston Senior Quality Assurance Auditor, Battelle UK Shona Ross Head of QA, Tower Mains Ltd Programme Please note timings may be subject to alteration. Day 1 09:00 Welcome and Introductions 09:15 Good Laboratory Practice Standards and Regulations An insight into the background and history of Good Laboratory Practice. 09:45 Principles of Quality Assurance What is the role and responsibilities of QA in GLP. Maintaining the independence of QA and what is an audit. 10:30 Break 10:45 Standard Operating Procedures GLP requirements and QA involvement. 11:30 Study Plans GLP requirements and QA involvement. 12:05 QA Programme Risk based programme, what are study, process and facility audits. 13:00 Lunch 14:00 Inspections Attitudes, techniques and attributes. 14:40 Workshop 1 - Facility and Process Inspections An exercise in inspection planning and preparation for inspections. 15:15 Break 15:30 Workshop 1 - Feedback 15:45 The Auditor and Audit Conduct Attitudes, attributes and techniques. 16:30 Panel Session An opportunity for delegates to put questions to the panel of speakers. 17:15 Close of Day Day 2 09:00 Workshop 2 - A Mock Audit 10:45 Break 11:00 Workshop 2 - Feedback 11:30 Auditing the Study Report Techniques and methods for the QA audit of the study report. 12:00 Record Keeping and Data The impact of GLP on data and records management. 12:40 Lunch 13:25 Data Integrity A look at the OECD GLP guidance document; the expectations of the regulators and the involvement of QA - Where QA adds value. 14:15 Workshop 3 - Amendments to Study Plan and Deviations from the Plan What are they? What is the difference between them? How are they controlled? 15:00 Workshop 3 - Feedback 15:15 Break 15:30 Regulatory Compliance GLP Monitoring Authority monitoring for compliance with Good Laboratory Practice. 16:15 Panel Session An opportunity for delegates to put questions to the panel of speakers. 16:45 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 Learn

THE LATEST ADVANCEMENT IN PERMANENT MAKEUP, HYPER-REALISM BROWS ARE THE MOST REALISTIC BROW STYLE YET. LEARN HYPER-REALISM BROWS FROM AWARD-WINNING WORLD MASTER ARTIST MIRIAM BEGANOVA (@LIMITLESSPMU).

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience. Overview In this course, you will connect to a database to extract data and present it as a report. You will: Identify the elements of the Crystal Reports interface. Create and modify a basic report. Use formulas to calculate and filter data. Build a parameterized report. Group report data. Enhance a report. Create a report using data from an Excel workbook. Distribute data. In this course, students will create a basic report by connecting to a database and modifying the report's presentation. 1 - EXPLORING THE CRYSTAL REPORTS INTERFACE Topic A: Explore Crystal Reports Topic B: Use Crystal Reports Help Topic C: Customize Report Settings 2 - WORKING WITH REPORTS Topic A: Create a Report Topic B: Modify a Report Topic C: Display Specific Report Data Topic D: Work with Report Sections 3 - USING FORMULAS IN REPORTS Topic A: Create a Formula Topic B: Edit a Formula Topic C: Filter Data by Using a Formula Topic D: Work with Advanced Formulas and Functions Topic E: Handle Null Values 4 - BUILDING PARAMETERIZED REPORTS Topic A: Create a Parameter Field Topic B: Use a Range Parameter in a Report Topic C: Create a Prompt 5 - GROUPING REPORT DATA Topic A: Group Report Data Topic B: Modify a Group Report Topic C: Group by Using Parameters Topic D: Create a Parameterized Top N Report 6 - ENHANCING A REPORT Topic A: Format a Report Topic B: Insert Objects in a Report Topic C: Suppress Report Sections Topic D: Use Report Templates 7 - CREATING A REPORT FROM EXCEL DATA Topic A: Create a Report Based on Excel Data Topic B: Modify a Report Generated from Excel Data Topic C: Update Data in a Report Based on Excel Data 8 - DISTRIBUTING DATA Topic A: Export Data Topic B: Create Mailing Labels 9 - APPENDIX Appendix A: Setting Up and Configuring Data Sources Appendix B: Using Report Processing Techniques Appendix C: Using Functions in Formulas

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience. Overview In this course, you will create complex reports using tools in Crystal Reports 2016. You will: Create automatic and manual running totals. Work with cross-tab reports. Add subreports. Create drill-downs in a report. Use SQL statements in report processing. Create complex formulas. Add charts to reports. Enhance report functionality. In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency. 1 - CREATING RUNNING TOTALS Topic A: Create a Running Total Field Topic B: Modify a Running Total Field Topic C: Create a Manual Running Total 2 - WORKING WITH CROSS-TABS Topic A: Create a Cross-Tab Report Topic B: Format a Cross-Tab Report Topic C: Create Groups in Cross-Tab Reports 3 - ADDING SUBREPORTS Topic A: Insert a Subreport Topic B: Edit a Subreport Topic C: Share Variables 4 - CREATING DRILL-DOWNS IN A REPORT Topic A: Create a Drill-Down Topic B: Create Headings for Drill-Down Data 5 - USING SQL STATEMENTS IN REPORT PROCESSING Topic A: Create a Report Using SQL Queries Topic B: Summarize Report Data Topic C: Create Joins Using SQL Topic D: Create Subqueries Topic E: Create an SQL Expression Field 6 - CREATING COMPLEX FORMULAS Topic A: Work with Loops Topic B: Work with Arrays 7 - ADDING CHARTS TO REPORTS Topic A: Create Charts Topic B: Create a Chart with Drill-Down Topic C: Create a Top N Chart Topic D: Create a Cross-Tab Chart Topic E: Create Charts for Grouped Data Topic F: Format a Chart Topic G: Create a Chart Template 8 - ENHANCING REPORT FUNCTIONALITY Topic A: Organize Data Based on a Hierarchy Topic B: Create a Dynamic Image Topic C: Create a Report Alert Topic D: Create a Geographic Map 9 - APPENDIX Appendix A: Managing Reports Appendix B: Processing Data on the Server Appendix C: Detecting and Fixing Problems

Overview The OTHM Level 3 Technical Certificate in Occupational Health and Safety qualification has been developed to enable learners to gain an understanding of health and safety practices within a working environment. The qualification is suitable for those wishing to work in health and safety positions in a variety of sectors and will provide the real-world knowledge and skills that organisations and employer’s demand. Individuals successfully completing the qualification will be eligible to apply fo IOSH for an appropriate level of membership. This tutor supported distance learning course gives learners an insight into how to manage workplace issues and covers the areas they would encounter in a health and safety role. The qualification is suitable for those wishing to work in health and safety positions in a variety of sectors and will provide the real-world knowledge and skills that organisations and employer’s demand. Entry requirements Learners must be over 16 to complete this course. There are no formal entry requirements for this qualification, However, it is important that learners are able to understand and articulate the concepts contained in the syllabus in the language that the course delivery and assessment will be completed in. Some working knowledge of health and safety in the work environment would be advantageous. Delivery This distance learning course is flexible in its delivery and designed for part-time learning. Learners receive a core textbook and access to our learning management system (LMS) where they can access range of learning resources to support them in their studies. Learners are allocated a tutor to support them in their studies and assess their assignment submissions. Assessment All units within this qualification are internally assessed by the centre and externally verified by OTHM. The qualifications are criterion referenced, based on the achievement of all the specified learning outcomes. To achieve a ‘pass’ for a unit, learners must provide evidence to demonstrate that they have fulfilled all the learning outcomes and meet the standards specified by all assessment criteria.

Study abroad is about stepping out of your comfort zone, embracing a new culture and way of life, and coming home with unforgettable memories

Group Course (Max 6 Delegates)

An intermediate sewing workshop - making your own knickers, pants, undies. Create underwear to suit you and for your comfort. Join us for an afternoon making with pattern included and all the help you need to create your perfect pants.

Gain robust techniques for obtaining feedback from end users throughout product design, and learn how to identify new opportunities for design improvement.