3895 Courses delivered Live Online

This day is relevant to anyone involved in the task of developing an Inclusion Policy. How to create a real policy built around shared vision with true community commitment. Participate in this very practical workshop to take your first very real steps forward. The day gives those present opportunities to reflect on their attitudes and practice in relation to the inclusion of pupils who are different and the policy and practice which currently exist. Course Category Strategic Work Description This day is relevant to anyone involved in the task of developing an Inclusion Policy. How to create a real policy built around shared vision with true community commitment. Participate in this very practical workshop to take your first very real steps forward. The day gives those present opportunities to reflect on their attitudes and practice in relation to the inclusion of pupils who are different and the policy and practice which currently exist. Testimonials Be the first… Learning Objectives Increased confidence regarding developing an inclusion policy Understanding of essential steps to be taken to make inclusion policy a reality Deeper understanding of core values surrounding inclusion of disabled children Who Is It For? Anyone needing to create an inclusion policy Course Content The course answers the questions: Why an inclusion policy? What is the scope of an inclusion policy? How can an inclusion policy become a reality? How do I roll this out? We will cover: Legal and ethical background Local requirements Vision and Values Aims and Objectives Scope Evaluation and monitoring Complaints procedures Community involvement Consultation Implementation Practical steps If you like this you may like: KEYS TO INCLUSION

Many leaders and managers working on the front line of inclusion lack emotional support from Local Authority staff or anyone else despite the challenging nature of their work. There is a massive need for active listening, containment and opportunities to problem solve and reflect confidentially with someone trusted. Course Category Peer Support Meeting emotional needs Strategic Work Early Years Description We can tailor make and deliver personalised 1:1 or group support and supervision sessions with a particular focus on emotional support. Many leaders and managers working on the front line of inclusion lack emotional support from Local Authority staff or anyone else despite the challenging nature of their work. There is a massive need for active listening, containment and opportunities to problem solve and reflect confidentially with someone trusted. Some leaders may prefer a group setting for mutual support. We can provide this numbers permitting. Book a set of 3/10/20 sessions or why not set up monthly meetings with a psychologist, head teacher or other suitable practitioner to meet your needs. Testimonials Be the first… Learning Objectives Emotional support in a confidential space To listen and offer practical support Joint problem solving around hard issues To build a trusting relationship Who Is It For ? Headteachers Children Centre Managers Heads of Service Directors Early Years Mangers Course Content Active and supportive listening and exploration of named issues Supportive and safe problem solving Consultation processes In groups to use processes such as Circle of Adults If you liked this you may like: STORY TELLING: STRENGTHENING SKILLS AND KNOWLEDGE OF COMMUNITIES

In this workshop we explore how to understand movement differences of those with ADHD/Autism, Tourettes or Cerebral Palsy in a non-medical way. Online course coming soon Online Course now available via Teachable Platform – Understanding Movement Differences Learn at your own pace… lots of text and video support Course Category Inclusion Autism and Communication Behaviour and Relationships Description In this workshop we explore how to understand movement differences of those with ADHD/Autism, Tourettes or Cerebral Palsy in a non-medical way. Learning Objectives To understand movement differences using a respectful model that helps us all empathise For participants to understand the underlying rationale and ethos of this way of working To explore ways of maximising an individual’s inclusion and connection with the wider community through useful strategies around their movement challenges To explore ways of helping with movement accommodations Who Is It For? Anyone interested in mobilising the community to make it more inclusive around disabled or challenging individuals. Course Content • Understanding movement differences: stopping/starting/executing/switching and combining • Inclusion strategies • Building relationships • Frameworks of support

This is a practical ‘non-medical’ day for front line practitioners working with children and young people who have experienced serious trauma in their life. We work to strengthen understanding of children who have faced issues of trauma emerging from abuse, violence, loss and family breakdown. Online Course now available via Teachable Platform – Impact of Trauma Learn at your own pace… lots of text and video support Course Category Meeting emotional needs Behaviour and Relationships Inclusion Teaching and Learning Description This is a practical ‘non-medical’ day for front line practitioners working with children and young people with serious issues arising from trauma. Drawing from the international research and literature and our own experience over many years as educational psychologists of the challenges of children with major social and emotional needs, we will explore together what the best practice can and could look like. We explore the language and key concepts of trauma and outline very practical classroom strategies. We look at what Psychology may help us in our understanding of children who have faced trauma. We explore the themes of: Hyperarousal Intrusive thoughts Constricted lives We look at triggers, self-regulation and unpack a range of strategies.  We explore what young people with these difficulties really need from us. We also spend time looking at the emotional impact on practitioners working with children with such needs and what helps at a personal and team level. We can all do something – we do not have to wait for expert therapists to arrive!  Testimonials I had no idea… It had a huge impact Belonging and feelings are so important Excellent! Learning Objectives Increased confidence regarding developing inclusive practice for traumatised children in mainstream schools Simple understandable explanation trauma understood Access to a wider range of practical strategies to impact on social and behavioural needs Deeper understanding of core values surrounding inclusion of emotionally disabled children Opportunity to reflect on professional attitudes and behaviour towards parents and pupils with complex emotional needs New skills, scripts and processes to make inclusion successful Who Is It For? Practitioners working in schools and other settings with children and young people of all ages Key workers Teaching Assistants with support roles Heads and deputies SENCOs Advanced skills teachers Primary and secondary classroom teachers Parents Local authority support services Course Content The course explores the questions:What does it take for a child to:Feel safe and secureMourn the past traumaReconnect with ordinary relationships with children and adults?How can we start to develop an understanding of traumatised children?What is the true impact of trauma?What else can we do to go about including high profile children or young people with challenging emotional needs?What useful psychological constructs can we use to guide us?This course also explores practical strategies, concepts and language for key adults rebuilding relationships with individual pupils.This is a participative day that aims to be explorative and practical. Opportunities to develop empathy with the children of concern will be created.If you liked this course you may well like:FRESH APPROACHES TO BEHAVIOUR AND RELATIONSHIPS

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our 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. Tailored training courses: In, in company training, 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction course. Career path Career path Excel 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 Certificates Certificates Certificate of completion Digital certificate - Included

Course description Figma is an industry leading web-based design tool that allows you to create user interfaces for any screen type or size, collaborate on those designs in real-time and build interactive prototypes suitable for user testing. Figma is a visual design tool so there’s no coding involved. Design is achieved by adding, combining and styling shapes, text and images on a canvas or ‘Frame’.  We run 2 consecutive Figma training days, the second day building on the practical activities from the first.  You can attend just the first day. Attending just the second day is only recommended if you’re already very comfortable with the Figma interface.  Day 1: Basic Figma design and collaboration For beginners with no prior experience with Figma who want to understand the basics, be able to create their own designs, share, collaborate and even iterate on the designs of others. You will learn: How to navigate the Figma interface. How to create your own designs by: Setting up a design file. Setting up the screen type you want to design and add grids and guides. Adding and modifying basic shapes and text to create user interface elements. How to save text and colour styles for reuse. How to create reusable components. How to use the ‘auto layout’ feature to promote tidy, consistent and usable design. How to collaborate on designs by sharing screens and commenting on designs. A brief introduction to prototyping: What’s possible. What’s not. Day 2: Component variants, design systems and prototyping  This session will cover the more sophisticated aspects of Figma use such as: How to use component variants to create: Interaction styles such as hover and mouse down states ‘Flavours’ of a widget such as primary and secondary button styles. Toggleable elements within a widget such as buttons or bullets within a product card. How to turn a collection of components into a basic design system. Prototyping fundamentals: How to make journeys clickable. How to introduce animations. Tips and tricks for effective user testing. The limitations of Figma prototyping Is it for you? With no experience of Figma necessary, this course is suitable if: If you’re involved with creating or curating digital experiences. if you want to turn your design ideas into something tangible. If you work with Figma designers and want to understand the ‘art of the possible’. If you want to collaborate with your team on Figma projects. Learning objectives After completing day 1 you will be able to: Understand the Figma user interface. Create mobile and desktop interface designs. Effectively collaborate remotely. Share designs and gather feedback. Use auto layout to promote consistent and usable designs. Understand Figma’s role in user experience design, and its limitations. After day 2 you will be able to: Understand how design systems are set up and used. Create component variants for use in your own design system. Use that design system to efficiently create a user journey. Create a prototype suitable for user testing.

Conflict Resolution Skills (Virtual) Many organizations have assumed that workplace conflict is always destructive. So, they have often believed that conflict is best dealt with by managers or even via policies and procedures. After all, conflict creates workplace stress and leads to many performance problems, generating very real organizational costs! However, savvy organizations have embraced the fact that when conflict is understood and harnessed, it can be leveraged to add value to teams and even enhance performance. With the right knowledge, skills, training, and practice, conflict can be productive and make organizations better! In this highly interactive course, learners will discover the connection between individual conflict response and team-empowering conflict resolution skills. Participants will explore conflict's visceral dynamics and the nuanced behaviors we individually engage in to communicate and respond to conflict. Learners will apply techniques for transforming unproductive conflict responses into productive ones. Additionally, learners will use a systematic method that prepares them to objectively dissect real-world conflict, while practicing many strategies for resolving it. They will also develop proactive conflict approach plans, which they can transfer back to their own workplaces. What you will Learn At the end of this program, you will be able to: Recognize the organizational costs of conflict Explain our physical and mental responses to conflict Communicate proactively and effectively with different types of people during conflict Replace unproductive conflict responses with productive ones Use the Conflict Resolution Diagram (CRD) process and conflict resolution approaches Relate team stages of development to shifts in conflict Develop a proactive conflict approach for your organization Create a conflict resolution plan for a real-world scenario Getting Started Introductions and social agreements Course goal and objectives Opening activities Conflict Facilitation Readiness Conflict responses and perceptions Conflict basics Conflict and organizations Dynamics of conflict Conflict Styles and Communication A look at the color energies model Conflict through the color energies and DiSC® lens Communication with opposite color energies Individual Response to Conflict The anatomy of conflict Recognizing unproductive conflict responses 4 steps to productive conflict Choosing productive conflict responses Team Performance and Conflict High-performing team relationships Conflict and project team performance Conflict Resolution Diagram (CRD) and process Conflict Facilitation - Preparation Recognizing context and stakeholder needs Using team conflict resolution approaches Preparing for Crucial Conversations® Conflict Facilitation - Clarity Exposing assumptions and biases Defining the conflict and using the CRD Conflict Facilitation - Action Proactive conflict management Conflict facilitation practice Summary and Next Steps Review Personal action plans

OVERVIEW This official Microsoft Power BI training course will teach you how to connect to data from many sources, clean and transform it using Power Query, create a data model consisting of multiple tables connected with relationships and build visualisations and reports to show the patterns in the data. The course will explore formulas created using the DAX language, including the use of advanced date intelligence calculations. Additional visualisation features including interactivity between the elements of a report page are covered as well as parameters and row-level security, which allows a report to be tailored according to who is viewing it. The course will also show how to publish reports and dashboards to a workspace on the Power BI Service. COURSE BENEFITS: Learn how to clean, transform, and load data from many sources Use database queries in Power Query to combine tables using append and merge Create and manage a data model in Power BI consisting of multiple tables connected with relationships Build Measures and other calculations in the DAX language to plot in reports Manage advanced time calculations using date tables Optimise report calculations using the Performance Analyzer Manage and share report assets to the Power BI Service Prepare for the official Microsoft PL-300 exam using Microsoft Official Courseware WHO IS THE COURSE FOR? Data Analysts with little or no experience of Power BI who wish to upgrade their knowledge to include Business Intelligence Management Consultants who need to conduct rapid analysis of their clients’ data to answer specific business questions Analysts who need to upgrade their organisation from a simple Excel or SQL-based management reporting system to a dynamic BI system Data Analysts who wish to develop organisation-wide reporting in the form of web reports or phone apps Marketers in data-intensive organisations who wish to build visually appealing, dynamic charts for their stakeholders to use COURSE OUTLINE Module 1 Getting Started With Microsoft Data Analytics Data analytics and Microsoft Getting Started with Power BI Module 2 Get Data In Power BI Get data from various data sources Optimize performance Resolve data errors Lab: Prepare Data in Power BI Desktop Module 3 Clean, Transform And Load Data In Power BI Data shaping Data profiling Enhance the data structure Lab: Load Data in Power BI Desktop Module 4 Design A Data Model In Power BI Introduction to data modelling Working with Tables Dimensions and Hierarchies Lab: Model Data in Power BI Desktop Module 5 Create Model Calculations Using DAX In Power BI Introduction to DAX Real-time Dashboards Advanced DAX Lab 1: Create DAX Calculations in Power BI Desktop, Part 1 Lab 2: Create DAX Calculations in Power BI Desktop, Part 2 Module 6 Optimize Model Performance Optimize the data model for performance Optimize DirectQuery models Module 7 Create Reports Design a Report Enhance the Report Lab 1: Design a Report in Power BI Desktop, Part 1 Lab 2: Design a Report in Power BI Desktop, Part 2 Module 8 Create Dashboards Create a Dashboard Real-time Dashboards Enhance a Dashboard Lab: Create a Power BI Dashboard Module 9 Perform Advanced Analytics Advanced analytics Data Insights through AI Visuals Lab: Perform Data Analysis in Power BI Desktop Module 10 Create And Manage Workspaces Creating Workspaces Sharing and managing assets Module 11 Manage Datasets In Power BI Parameters Datasets Module 12 Row-Level Security Security in Power BI Lab: Enforce Row-Level Security

BOHS P304 is designed to give practical guidance on assessing the health risks caused by hazardous substances, in order to meet the requirements of the Control of Substances Hazardous to Health (COSHH) Regulations 2002 for a 'suitable and sufficient' risk assessment.