54190 Courses in Manchester delivered Online

Duration 1 Days 6 CPD hours This course is intended for This course is designed for Microsoft© Windows© and Microsoft Office users who are transitioning to a SharePoint environment, and who need to access information from and collaborate with team members within Microsoft SharePoint. Overview Launch a SharePoint site and navigate among the pages and resources provided by the site. Use SharePoint lists to track and view information. Use document libraries to store and organize documents. Find, share, and archive content stored in SharePoint. Author documents as a member of a SharePoint team site. Use SharePoint workflow automation tools. In many professional environments, people work collaboratively in teams. Information technology and applications facilitate this by enabling people to easily share, access, edit, and save information. Microsoft© SharePoint© is a platform specifically designed to facilitate communication and collaboration, enabling people to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. In this course, you will use SharePoint to access, store, share, and collaborate with information and documents. Prerequisites To ensure your success in this course, you should have basic end-user skills with a current version of Microsoft Windows. Lesson 1: Navigating SharePoint Sites Topic A: Launch SharePoint Topic B: Gain Access to a Site You Didn't Create Topic C: Navigate Within a SharePoint Site Topic D: Access SharePoint from Your Mobile Device Lesson 2: Using Lists to Track Information Topic A: Add and Populate Lists Topic B: Change View Options Topic C: Create a Custom View Lesson 3: Using Document Libraries to Share and Organize Documents Topic A: Store Files in a Document Library Topic B: Create and Use Document Templates Lesson 4: Finding, Sharing, and Archiving Content Topic A: Search for Items in Lists or Libraries Topic B: Share Through Links Topic C: Move Files Offline Lesson 5: Authoring Documents as a Team Topic A: Work Together on Documents Topic B: Manage File Versions and Document Recovery Lesson 6: Automating Business Processes Topic A: Use Rule-Based Automation Topic B: Use Power Automate to Automate a Workflow

Duration 1 Days 6 CPD hours This course is intended for Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology. Overview Upon successful completion of this course, students will be able to: - Use subqueries to generate query output. - Manipulate table data by inserting, updating, and deleting records in a table. - Manipulate the table structure. - Create views, manipulate data through views, modify the view structure, and drop views. - Create indices on table columns and drop inefficient indices. - Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction. In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process. Prerequisites SQL Querying Fundamentals - Part 1 1 - Using Subqueries to Perform Advanced Querying Search Based on Unknown Values Compare a Value with Unknown Values Search Based on the Existence of Records Generate Output Using Correlated Subqueries Filter Grouped Data Within Subqueries Perform Multiple-Level Subqueries 2 - Manipulating Table Data Insert Data Modify and Delete Data 3 - Manipulating the Table Structure Create a Simple Table Create a Table with Constraints Add or Drop Table Columns Add or Drop Constraints Modify the Column Definition Back Up Tables Delete Tables 4 - Working with Views Create a View Manipulate Data in Views Create Aliases Modify and Drop Views 5 - Indexing Data Create Indices Drop Indices 6 - Managing Transactions Create Transactions Commit Transactions

Banish those presentation gremlins and communicate with confidence and clarity!

Most trainers are self-taught or have attended short courses and don't have the time to take their skills to the next level. Give staff the skills to understand how and what to train, and to use our special learner-centred techniques to boost the effectiveness and impact of their training courses.. This course includes: Assessing your learners’ skills and abilities Understanding how people learn Learning and training theories Planning and timing an effective session Essential training techniques Assessment and evaluation of learning

This Dementia Train the Trainer course is run over 2 days, you will learn about the subject and know how to teach About this event Understanding dementia Common types of dementia How the brain is affected Causes and symptoms Person centred care Communication Learning about the persons past Care planning The role of friends and relatives Building relationships Equality and diversity in dementia Recognise and help prevent abuse Non-verbal communication Event lasts 1 day 7 hours Understanding dementia Common types of dementia How the brain is affected Causes and symptoms Person centred care Communication Learning about the persons past Care planning The role of friends and relatives Building relationships Equality and diversity in dementia Recognise and help prevent abuse Non-verbal communication

Definition of Safeguarding Legislation & agreed ways of working Definition of Safeguarding Legislation & agreed ways of working Every child matters guidance Myths and statistics Effects on young people Leadership/worker skills Common indicators of abuse Reporting of abuse and potential abuse Barriers to reporting abuse Understanding the types of abuse Recognising acts, signs and symptoms of abuse Who is vulnerable / at risk The role of dignity in safeguarding Legislation and policies and procedure What to do should you have a concern Overview of prevent How to respond to an individual should they disclose a concern

The course is run over 2 days you will learn about and how to teach and assess the following key areas: Policies. Legislation. CQC The course is run over 2 days you will learn about and how to teach and assess the following key areas: Policies. Legislation. CQC Medication. Routes. Formulation. Types. Absorption. MDT. Roles and Responsibilities. Levels of support. Boundaries and agreed ways of working. Order. Receive. Store. Record. Transfer. Dispose. 7 R’s. Sources of info. Practical session including MAR charts. Risk assessments. Person Centred Care. Review. Covert. Consent. Refuse. Errors and action. Infection Control and Technique.

About this event Definition of epilepsy Various types of seizures Classification and management of seizures Ethical and legal responsibilities Recognising triggers and precipitants Person centred care Documentation and record keeping The impact of rescue medication and anti-epileptic drug therapy Rescue medications: what it is, it’s uses for epilepsy and side effects Emergency care plan and when to call an ambulance Risk assessment/promotion of safeguarding and dignity Epilepsy medication demonstration

Recognizing the brilliance of someone psychological disturbance normalizes their experience and opens the door to transformative change. We aim to explore the lived experiences on irregular perceptions of reality with an open mind. Each Saturday includes: a live dialogue between Prof. Ernesto Spinelli and an International Existential Therapist; a moment to share your thoughts and feelings with the teachers; and a final integration facilitated by Bárbara Godoy. This series of ten dialogues set out to explore the multifaceted dimentions and complexities associated with Existential Therapies. It attempts to engage with various interpretations of insanity through the lens of patients often painful, confounding, and deeply unsettling life experiences. Invention- between Prof. Ernesto Spinelli and Dr. Betty Cannon “When I first saw the topic of this year’s dialogues, I asked myself whether I had anything to contribute. After all, I told myself, I do not usually work with psychoses or other so-called ‘extreme’ or’ irregular’ states of consciousness. This started me thinking about a series of demonstration videos that I have been making with students and supervisees over the last couple of years as part of a book project. Do those videos display ‘extreme states’? To my surprise, the answer is yes. They are filled with experiences that might be described as hallucinations (positive and negative), dissociative states, paranoia, delusions, manic and depressive states, crippling anxiety, schizoid withdrawal, depersonalization and derealization, and body dysmorphic phenomena. Not to mention the so-called normal neurotic trances that Freud called transference, countertransference and defenses, psychedelically induced extreme states, and those nightly hallucinations, our dreams. So why did I not remember at least some of these states as being ‘extreme’? Perhaps the answer lies in my perspective on therapy, which is largely existential-phenomenological. I think that the following quote, from a letter that Sartre wrote to R.D. Laing, captures the essence of this perspective: “Like you, I believe that one cannot understand psychological disturbances from the outside, on the basis of a positivistic determinism or reconstruct them with a combination of concepts that remain outside the experience as lived and experienced. I also believe that one cannot study, let alone cure, a neurosis without a fundamental respect for the person of the patient, without a constant effort to grasp the basic situation and relive it, without an attempt to rediscover the response of the person to that situation and––like you, I think––I regard mental illness as the ‘way out’ that the free organism, in its total unity, invents in order to be able to live through an intolerable situation.”* When a client and I together are able to appreciate the true brilliance of this invention, my experience is that it not only normalizes the client’s experience, it also opens the doorway to change. It allows us to invent something new.” Dr. Betty Cannon. Betty Cannon, PhD, is a licensed psychologist who has taught and practiced in Boulder, Colorado, for over 40 years. She is Professor Emerita of the Colorado School of Mines and president and founder of the Boulder Psychotherapy Institute, which has trained mental health professionals in Applied Existential Psychotherapy since 1989. In addition to existential philosophy, especially the philosophy of Sartre, AEP has roots in Gestalt therapy, classical and contemporary psychoanalysis, humanistic psychology (especially the person-centered therapy of Carl Rogers), and body-oriented psychotherapy. Betty is a member of the editorial boards of the Journal for the Society of Existential Analysis and Sartre Studies International. She is the author of Sartre and Psychoanalysis and numerous articles and chapters on existential therapy. Her mentor was Hazel E. Barnes, who translated Sartre into English and who was the world’s foremost Sartre scholar until her death in 2008. Betty is her literary executor, and her book on Sartre is dedicated to Hazel. Prof. Ernesto Spinelli was Chair of the Society for Existential Analysis between 1993 and 1999 and is a Life Member of the Society. His writings, lectures and seminars focus on the application of existential phenomenology to the arenas of therapy, supervision, psychology, and executive coaching. He is a Fellow of the British Psychological Society (BPS) as well as an APECS accredited executive coach and coaching supervisor. In 2000, he was the Recipient of BPS Division of Counselling Psychology Award for Outstanding Contribution to the Profession. And in 2019, Ernesto received the BPS Award for Distinguished Contribution to Practice. His most recent book, Practising Existential Therapy: The Relational World 2nd edition (Sage, 2015) has been widely praised as a major contribution to the advancement of existential theory and practice. Living up to the existential dictum that life is absurd, Ernesto is also the author of an on-going series of Private Eye novels. Date and Time: Saturday 25 October from 2 pm to 3 pm – (UK time) Individual Dialogue Fee: £70 Venue: Online Zoom FULL PROGRAMME 2025: 25 January “Knots” with Prof. Ernesto Spinelli and Bárbara Godoy 22 February “Healing” with Dr. Michael Guy Thompson and Prof. Ernesto Spinelli 22 March “Difference” with Prof. Tod DuBose and Prof. Ernesto Spinelli 12 April “Polarisation” with Prof. Kirk Schneider and Prof. Ernesto Spinelli 3 May “Character” with Prof. Robert Romanyshyn and Prof. Ernesto Spinelli 21 June “Opening” with Dr. Yaqui Martinez and Prof. Ernesto Spinelli 19 July “Meaning” with Dr. Jan Resnick and Prof. Ernesto Spinelli 25 October “Invention” with Dr. Betty Cannon and Prof. Ernesto Spinelli 15 November “Hallucination” with Prof. Simon du Plock and Prof. Ernesto Spinelli 13 December “Hysteria” with Bárbara Godoy and Prof. Ernesto Spinelli Read the full programme here > Course Organised by:

The main subject areas of the course are: Building construction and the uses of asbestos Survey types Bulk sampling and material assessments Survey reports Quality control