21 Threshold courses

Platelet-rich Plasma (PRP) treatments Nationally Recognised Qualification No previous experience or qualifications needed Open College Network Accreditation Level 4 (as required for minimally invasive procedures) Covers standards set by HEE Employed (salon) or Self-Employed opportunities Basic understanding of English language required OPEN TO ALL APPLICANTS

To facilitate a group, family, team or organisation in thinking together around a given challenge or issue here is an opportunity to experience for real the person centred, futures planning tool – MAP (Pearpoint, Forest et. al. 1989). This is a process not a training day. Let us facilitate your planning and refocus your story whilst strengthening you and your group. This tool uses both process and graphic facilitation to help any group develop a shared vision and then to make a start on working out what they will need to do together to move towards that vision. MAPS are great for threshold moments. Is your team stuck? Want to move on, haunted by the past cannot get any useful dialogue about the future? Facing a challenging transition into a new school or setting? Leaving school? Bored with annual reviews, transition plans and review meetings? Want to find a way of making meetings and planning feel more real and engaging? Need an approach, which engages a young person respectfully together with his or her family and friends? Want the ultimate visual record of the process of a meeting, which will help everyone, keep track? Want to problem solve and plan for the future of a small or large group, service or organisation up to the size of an LEA Learning Objectives To create a shared vision To talk through the story so far and reflect upon it To name the worse nightmares that will block progress To strengthen the group by focussing on gifts and capacity To detail needs To specify an Action Plan To create a visual graphic record of the whole event Course Content The MAP process has 6 Steps: The story so far. The group is required to think back over the years to describe their collective experience of changes and events over time within their settings. Stories and events are recorded on the graphic. Building Shared Dreams. The group thinks together about what they would love to see happening for children, families and practitioners in their settings if they could have it all. If there were no constraints on time, money, resources, people or anything else what do they see happening in their imaginations? The various ideas that the group comes up with are then recorded in key words, images and colours on the MAP graphic. The purpose of this Step is to give the group a sense of direction, their North Star, an image of the place they want to work towards. Nightmare. In this Step, the group imagines the worst scenarios. What is the opposite of their dreams? How bad could it get? This is a shorter but powerful process that can give some groups more energy than dreaming together. Gifts and Capacity. In this Step the group is asked to take explicit stock of their capacities and what they already have going for them as they begin working towards the vision. This is a strong reminder for any group of the wealth of knowledge and experience that is already and always in the room. Needs. In this Step the group is invited to begin to name some of the needs they will have if they are to move forward to wards the dream and away from the nightmare. Actions. This is the final Step in the MAP and calls for individuals within the group to name a range of very specific actions (however small) that they will take within a definite time scale. This is not a time for declaring good intentions or suggesting good ideas for someone else to do. The purpose of this Step is to end the MAP process with a range of clearly understood actions that carry this planning process forward into the real world.

This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 The query editor Split by row delimiter AddDays to determine deadlines Advanced query editor 2 Fuzzy matching joins Matching inconsistencies by percentage Matching with transformation table 3 Logical column functions Logical functions IF, AND, OR Using multiple conditions Including FIND in functions 4 Editing DAX measures Make DAX easier to read Add comments to a measure Using quick measures 5 The anatomy of CALCULATE Understanding CALCULATE context filters Adding context to CALCULATE with FILTER Using CALCULATE with a threshold 6 The ALL measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentage 7 DAX iterators Anatomy of iterators A closer look at SUMX Using RELATED in SUMX Create a RANKX RANKX with ALL 8 Date and time functions Overview of functions Create a DATEDIFF function 9 Time intelligent measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 10 Visualisations in-depth Utilising report themes Create a heatmap Comparing proportions View trends with sparklines Group numbers using bins Setting up a histogram 11 Comparing variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint 12 User level security Setting up row level security Testing user security

This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 The Query Editor Grouping rows in a table Split row by delimiter Add days to determine deadlines The query editor 2 Fuzzy Matching Joins Matching inconsistencies by percentage Matching with transformation table 3 The Query Editor M Functions Adding custom columns Creating an IF function Nested AND logics in an IF function 4 DAX New Columns Functions Including TRUE with SWITCH Using multiple conditions The FIND DAX function The IF DAX function Logical functions IF, AND, OR 5 Editing DAX Measures Making DAX easier to read Add comments to a measure Using quick measures 6 The Anatomy of CALCULATE Understanding CALCULATE filters Add context to CALCULATE with FILTER Using CALCULATE with a threshold 7 The ALL Measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentages 8 DAX Iterators Anatomy of iterators A closer look at SUMX Using RELATED with SUMX Create a RANKX RANKX with ALL 9 Date and Time Functions Overview of functions Create a DATEDIFF function 10 Time Intelligent Measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 11 Visualisations In-Depth Utilising report themes Applying static filters Group data using lists Group numbers using bins Creating heatmaps Comparing proportions View trends with sparklines 12 Comparing Variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint

Giving your child the gift of music while they are still young can be one of the most meaningful investments you could make in their life, and our London piano lessons for kids are structured to support the musical goals you have for your children. Your child’s or grandchild’s life will be permanently enriched from music lessons, whether they continue with music as a career, enjoy it as a serious amateur pursuit, or play casually for their own benefit and that of their friends and family.

Working with an experienced local crafter, you'll design and create your wooden chopping board, rolling pin and set of utensils to take pride of place in your kitchen.

Woodworking Course: Raised Panel Door. Get to grips with routing at this woodworking class in Birmingham. This three-day workshop will give you an introduction to woodworking on a router table as you create a pair of handsome raised panel cabinet doors.

Essential skill for all mental health professionals This 2-day workshop gives you the opportunity to see demonstrated, experience, and practice the steps of this powerful technique in a small group under the careful guidance of our expert tutor… Accredited CPD Certificate : 12 hours Length 2 days (9:30am - 4:00pm) Excellent course. A brilliantly encouraging and supportive environment in which to learnHARRIET, WORKSHOP PARTICIPANT Life-changing! A great weight has been lifted off my shoulders.NURSE (PREVIOUSLY TRAUMATISED BY A CAR ACCIDENT) Why take this course We have over 20 years of experience in teaching the rewind technique to health and welfare professionals – we’ve drawn on that experience to develop a course which gives you enough time to thorough absorb and practice the technique, understand why it works and to experience it yourself, so that you leave confident in your ability to use the rewind safely and effectively. The Rewind Technique* is an effective psychological intervention for successfully treating trauma and phobias and one of the most important skills you need to master to be able to work successfully with any anxiety disorder or condition which may have developed as a result of unresolved trauma. Even the most severe phobic and post-traumatic stress (PTSD) symptoms can be successfully addressed using the the rewind technique taught on this 2-day course, which has been refined* in line with understandings from neuroscience to make it as safe and reliably effective as possible. An essential therapeutic technique to have in your therapeutic ‘toolkit’, it is important to learn and practice it under the careful guidance of our expert tutor – you will leave the course knowing how to use the rewind technique safely and effectively having watched live demonstrations, had plenty of time to practice the steps involved with fellow students, the opportunity to experience the technique yourself and more. Our workshop has limited numbers so you will have plenty of opportunities for asking questions and the tutor, who has extensive clinical experience. Using the rewind technique you can, often surprisingly quickly, detraumatise bad memories, stop flashbacks and other PTSD symptoms, cure phobias, banish nightmares and reduce anxiety so you can help the victims of abuse, rape, violence, car accidents, fire, terrorism and panic attacks, heart attacks and other life-threatening experiences. Another key benefit of this technique is non disclosure – there is no need for people to repeatedly revisit or talk about specific details of the events that have traumatised them. This helps avoid embedding the trauma further and making the situation worse – as can sometimes inadvertently happen in other therapeutic approaches to treating trauma – and helps prevent the therapist or counsellor being vicariously traumatised by what they might hear. It is also invaluable when working therapeutically with people who have suffered persistent physical or sexual abuse, and people with OCD. People suffering from other conditions, such as depression, addictions or uncontrollable anger, may have experienced a traumatic event, which needs to be successfully detraumatised in order for them to move on with their lives. As a result of our training in the rewind technique – which we have been delivering for over 20 years – our graduates have brought relief to literally thousands of people (eg. case history / PTSD Resolution). Please note This is a powerful technique, which needs to be implemented with care – we recommend you take the time to learn it in person in a small group with a skilled and highly experienced tutor who can guide you through the important steps involved, oversee you as you practise them, answer your questions and give you crucial direct feedback. The version of the rewind technique* you will learn on this course has been refined in line with understandings from neuroscience to make it as safe and reliably effective as possible. The course is taught over two days to ensure you have enough time to thoroughly absorb and practice the steps involved so that you are confident in using it and know how to do so safely and effectively with clients. You will also learn when it is NOT appropriate to use this technique and how to ensure you avoid embedding any trauma further, or making a phobia worse. Guided imagery and visualisation skills form an essential part of the rewind technique, which is why they are a requirement for attending this course. This has huge potential to change people's lives for the better. I can't wait to put what I've learnt here to good usePSYCHIATRIC SUPPORT WORKER What will you learn How to detraumatise people quickly and safely The necessary skills to treat even severe phobias Why this version of the rewind technique is so effective, and how it works Under careful guidance from the tutor, you will: revisit key skills for relaxing clients in order to successfully work using the technique walk and talk through a step-by-step breakdown of the rewind technique see a live demonstration of working with a phobia or trauma practice each stage of the rewind technique in pairs practice the entire process, with other course participants, under supervision You will also gain: Vital tools for psycho-education – both adding to your own understanding and to pass on to clients A clear understanding of the fear response and how PTSD and phobias develop The detrimental impact traumas and phobias can have on a person’s life The crucial role of the pattern-matching processes in the brain in triggering phobic responses and post traumatic stress symptoms How the main treatment techniques for treating post traumatic stress disorder (PTSD), sub-threshold trauma and phobias (including EMDR, EFT and CBT) work – their advantages and disadvantages Why the rewind technique draws on the innate ability we all have to recover from trauma Pre-disposing factors for suffering a problematic post-traumatic response (or developing a phobia) Why critical incident debriefing increases the incidence of PTSD How this version of the rewind technique has been modified to make it safer and more reliable Trauma-focused rewinding: the psycho-biological reason why this refined rewind technique works so consistently well A step-by-step breakdown of the essential stages of the rewind technique The chance to see a live demonstration of working with a phobia or trauma You will leave with: The confidence to begin using the technique ethically and safely A clear understanding of the advantages of using a non-intrusive psychological technique to treat trauma, PTSD and phobias (where the client does not have to go into details about or repeatedly ‘revisit’ what has traumatised them) What to do if a client as an abreaction Important information about when not to use this technique – and what can be done instead An understanding of how the rewind technique can be used to work with Complex Trauma and cases involving ‘freeze’, shutdown or dissociative responses How you can carefully apply this technique to relieve a huge range of anxiety disorders Greater confidence in dealing with anxiety disorders and distress caused by trauma, phobias and flashbacks An understanding of how rapidly transformative this technique can be; on the last afternoon we view a filmed therapy session (and follow up) in which Joe Griffin uses the rewind technique to relieve a young man of his severe shark phobia There is also plenty of opportunity for you to ask questions and to experience and practice, under careful guidance, the various stages of the rewind technique yourself. Who is this course suitable for? Anyone working with distressed, phobic or traumatised people, who has already taken our Guided Imagery and Visualisation workshop (and ideally the Therapeutic Power of Language workshop too) as these skills are essential components of the rewind technique. If you help traumatised people (including children) or people suffering from any form of phobia or anxiety disorder – this includes: psychotherapists, counsellors, mental health nurses, OTs, health visitors, social workers, psychiatrists, GPs, clinical psychologists, midwives, welfare officers, youth workers, hypnotherapists and those working with traumatised members of public services, such as: firefighters, police, paramedics and military personnel – you will find the rewind technique and associated skills hugely helpful. Course requirements Guided imagery, relaxation and visualisation are an integral component of the Rewind Technique – if you don’t already have experience in using these skills therapeutically with others you must complete our Guided Imagery and Visualisation for Therapeutic Change workshop before attending this course (this is always run the day before our rewind technique training). This is to ensure you get the most out of this 2-day course and also have the necessary skills for practising the rewind technique safely and effectively. You would also find it useful to attend the Therapeutic Power of Language workshop beforehand if you can. All 3 workshops count towards Part 1 of the HG Diploma. Ros Townsend’s live online training Trauma: Patterns of the past is also useful for anyone working with or supporting someone suffering from unresolved trauma, or who would like to understand their own experiences of trauma better. She also runs a workshop on working with Complex Trauma. *About the Rewind Technique The Rewind Technique originated from one developed by Richard Bandler, one of the founders of NLP, when it was called the Visual/Kinaesthetic Dissociation protocol. A variant of this was developed by Dr David Muss, who called it the Rewind Technique. The version of the Rewind Technique you will learn on this 2-day course was refined by Joe Griffin and Ivan Tyrrell, co-founders of the human givens approach, to make it as reliably effective and safe as is possible by aligning the method with their insights into how trauma and phobias are processed in the brain. HG Therapists now follow a specific Rewind Protocol which follows the essential steps of the process that Griffin and Tyrrell set out. Course format This intense 2-day training proceeds through a blend of talks, live demonstrations, skill-developing exercises, practice sessions (under careful guidance) and deconstruction of filmed examples of the technique being used, including one with a severely traumatised young woman. There is also plenty of opportunity for networking and discussion during the breaks. The course was previously entitled: The fast phobia and trauma (PTSD) cure – a 2-day workshop in the rewind technique This course has been independently accredited by the internationally recognised CPD Standards Office for 12 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

WhatsUp Gold training course description A hands on course focusing on network management using WhatsUp Gold. What will you learn Discover devices using WhatsUp Gold. Use WhatsUp Gold. Poll and monitor devices using WhatsUp Gold. Create Alarms, alerts and reports. Diagnose faults using WhatsUp Gold. Administrate a WhatsUp Gold system. WhatsUp Gold training course details Who will benefit: Technical staff working with WhatsUp Gold. Prerequisites: None. Duration 2 days WhatsUp Gold for engineers Getting started with WhatsUp Gold Starting WhatsUp Gold, manual discovery, automatic discovery, controlling IP discovery, mapping network devices. Hands on Using WhatsUp Gold. Agents Configuring Cisco devices for SNMP support, communities, traps, syslog. MIBs. Hands on Device discovery. Adding devices. Customising maps. Using WhatsUp Gold Polling, obtaining MIB information, MIB walking, Active monitors, critical monitors, passive monitors. Hands on Monitoring devices. Groups. MIB walking. SNMP trap monitor. Syslog monitor. Alarms Actions, Alert centre, thresholds, actions on events. Hands on Using the alert centre. Web tools. Reports Creating reports, automatic reports, customising reports. Hands on Performance reports. Graphs. Administration Users, backups, the database. Hands on Adding a user. Backups.

SNMPc training course description A hands on course providing a solid foundation on network management using SolarWinds. The course specifically focusses on SolarWinds Orion Network Performance Monitor. The course starts with configuring agents and device discovery, onto exploiting SNMP with SolarWinds and then Alerts, reports and customisation of menus, views and maps. What will you learn Discover devices using Solarwinds. Use Solarwinds. Poll and monitor devices using Solarwinds. Create Alarms and reports. Diagnose faults using Solarwinds. SNMPc training course details Who will benefit: Technical staff working with Solarwinds. Prerequisites: None. Duration 2 days SNMPc training course content Getting started with SNMPc Manual discovery, automatic discovery, controlling IP discovery, mapping network devices. Hands on Using SNMPc. Agents Configuring Cisco devices for SNMP support, communities, traps, syslog. MIBs. Hands on Device discovery. Adding devices. Customising maps. Using SNMPc Polling, obtaining MIB information, MIB walking. Compiling MIBs. Hands on Monitoring devices. Groups. MIB walking. SNMP traps. Alarms Events and alarms, thresholds, event actions. Hands on Automatic alarms. Reports Creating reports, trend reports, customising reports. Hands on Performance reports. Graphs. Administration Users, customised views, backups, the database. Hands on Adding a user. Backups.