34437 OV courses

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

In2Drama is a specialised Academy for young aspiring performers wishing to carve out a career in the performing arts, or simply to explore a new hobby. Our action-packed 5 day course includes over 35 hours of masterclasses taught by industry professionals with connections to UK drama schools, as well as professional film, TV and theatre contacts for anyone looking to take the next step in their learning journey.

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)

Become a certified UI designer Learn how to create beautiful, pixel-perfect user interfaces Accelerate your career with an in-demand skillset Get a professional qualification in just 12 weeks Manage your own schedule with our flexible, self-paced online course Expand your career options UI skills are needed worldwide, and demand is growing. With a globally recognised qualification, you’ll become a more valuable, sought-after professional. Design with confidence You’ll understand the ‘why’ of good UI design by knowing the principles behind it. You’ll be able to defend your decisions and design with confidence. Work in a creative, rewarding job UI designers add personality and visual appeal to user interfaces. It’s an enjoyable career that rewards creativity: the perfect entry into tech for visually-minded people. A flexible, university-backed curriculum Our curriculum is university credit-rated and approved by the industry. Over 12 weeks, you’ll learn the principles and skills you need to become a confident UI designer. Study method Online, self-paced Duration 12 weeks Access to content 12 months Qualification Professional Certificate in UI Design Awarded by Scottish Qualifications Authority trading as SQA Additional info Exam(s) / assessment(s) is included in price Tutor is available to students Description During this 12 week, online course you will learn: Introduction to UI Design Brand and Personality Layout Design Principles Interactivity Typography Colour, shapes and effects Iconography and imagery Design process Presenting ideas UI design tools You will also work on a project and your portfolio with access to weekly mentor sessions, an active student community, and support from our student success team. Who is this course for? Graphic designers and digital designers who want to upskill to UI design UI designers who want to strengthen their knowledge and craft UX professionals who want to become more rounded product designers Anybody with a design background looking for a creative job in tech Requirements You don’t need experience in design or technology to enrol in our courses, although having one or both is a definite bonus. Our students come from a diverse mix of backgrounds, including project management, development, graphic design, product management, business analysis and so on. You need to be motivated and committed. We set a high bar. Studying for one of our professional qualifications requires a certain amount of time, energy and focus. You need to be comfortable learning in English. All video lessons, course materials, webinars, correspondence and the final exam are delivered in English. Career path Students typically graduate into UI Designer jobs. The average UI Designer salary in the UK with 3-5 years experience is £62,500. This is based on data from Payscale, Totaljobs, Indeed, Talent, and Glassdoor

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

Course Information Embark on our GLP course offering extensive guidance and pragmatic support tailored for individuals serving as Study Directors or Principal Investigators overseeing non-clinical safety studies on pharmaceuticals, agricultural, and industrial chemicals within the realm of Good Laboratory Practice (GLP). This comprehensive programme extends its benefits to study staff and management operating in GLP-compliant environments. The course extensively covers the current OECD GLP Principles and UK GLP legislation, while also referencing international standards, regulations, and guidelines pertinent to the field. Benefits of this course: Practical help and guidance on the interpretation and application of GLP An opportunity to update your knowledge of GLP with the current interpretation of requirements Access to an experienced panel of speakers Information on how other organisations address GLP issues An opportunity to improve your understanding of the GLP requirements as they are applied in different situations. This course is structured to encourage delegates to: Discuss and develop ideas Solve specific problems Examine particular aspects of GLP Learn from the experience of others. Tutors Tutors will be comprised of (click the photos for biographies): Tim Stiles Consultant, Qualogy Ltd Tony Woodall Head of Quality Assurance, Alderley Analytical Gill Armour Study Monitor Team Leader, AstraZeneca Jane Elliston Senior Quality Assurance Auditor, Battelle UK Vanessa Grant -, - Jeanet Logsted CEO, Scantox Programme Please note timings may be subject to alteration. Day 1 09:00 Registration 09:15 Welcome and Introductions 09:35 Development of Good Laboratory Practice A review of the history of GLP, its current scope and application, with a synopsis of current European and international standards. 10:05 Roles and Responsibilities The responsibilities of study director, test facility, management and study staff in the conduct of a GLP study. 10:45 Break 11:00 The Roles and Responsibilities of the Study Director and Test Facility Management The role of the study director in the management and control of a study, as defined by GLP, and management's roles are explored. 11:45 Multi-site Studies What is a multi-site study and when should such concepts be applied on a study. The role of the study director and principal investigator in the planning, conduct and reporting of multi-site study are explored. 12:30 Study Plan (Protocols) GLP requirements for the preparation of a study plan, content, authorisation, amendments and deviations are discussed. 13:00 Lunch 13:45 Workshop 1 - The Study Plan Some practical problems with study plans and amendments explored. 14:45 Workshop 1 - Feedback 15:00 Standard Operating Procedures The control, content and authorisation of SOPs and the principles behind the practice. 15:30 Break 15:45 Workshop 2 - Practical Study Conduct Problems Dealing with practical problems encountered during the conduct of studies. 16:40 Workshop 2 - Feedback 17:15 Close of Day Day 2 09:00 Questions and Answers Discussion of issues raised by course delegates. 09:20 Quality Assurance The interactions between QA, management, study director and principal Investigator are discussed as is QAs role when conducting a multi-site study. 10:00 The Final Report The content of the final report and the role of those involved in its preparation and approval. Specific reporting requirements when conducting a multi-site study are also explained. 10:30 Break 10:45 Workshop 3 - Final Report Problems Practical problems of report preparation including compliance statements. 11:30 Workshop 3 - Feedback 12:00 Management of Raw Data and Records A view on how records and materials are managed and archived in compliance with GLP. 12:45 Lunch 13:30 Workshop 4 - Data and Sample Management Issues Dealing with data and sample management issues. 14:15 Workshop 4 - Feedback 14:45 Regulatory Inspection Government monitoring for compliance with Good Laboratory Practice. 15:15 Panel Session This panel session will address any outstanding issues raised by delegates. 15: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 Develop

Learn all the skills you need to be a highly successful investor or professional analyst. In just 12 months.

The course is relevant to anyone requiring an understanding of the use of Agile or looking to adopt it. This includes, but is not limited to, organisational leaders and managers, marketing executives and managers, and/or all professionals working in an Agile environment, including software sesters, developers, business analysts, UX designers, project management office (PMO), project support and project coordinators.

Fibre splicing training course description A short, concise hands on fibre optic cable splicing course providing comprehensive coverage of fibre splicing. Over 50% of the course is practical based. What will you learn Prepare cable for splicing. Splice fibre optic cable. Fibre splicing training course details Who will benefit: Those wishing to be able to splice fibre. Prerequisites: None. Duration 1 day Fibre splicing training course contents Fibre optic essential review Fibre cable types. SMF, MMF. Safe working practices. Cable handling issues. Hands on: Handling fibre optic cable. Preparing fibre for splicing Cutting and stripping tools, cleaving methods, fibre cleaning materials. Hands on: Fibre preparation. Splicing Joining fibres, splicers, fusion splicing, mechanical splicing, splicing procedure. cleaving, splicing parameters. Splicing vs. connectors. Which splice? Hands on: Splicing fibre. Splice loss mechanisms End gap, concentricity, end angle, NA mismatch, finish and dirt, coaxiality, Axial run out, core mismatch, back reflection. Testing Testing successful fibre splicing. Hands on: Testing spliced fibre.