1637 Courses delivered Online

Duration 1 Days 6 CPD hours This course is intended for Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Overview Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report. In this course, students will compose SQL queries to retrieve desired information from a database. 1 - Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify a Query Execute a Saved Query 2 - Performing a Conditional Search Search Using a Simple Condition Compare Column Values Search Using Multiple Conditions Search for a Range of Values and Null Values Retrieve Data Based on Patterns 3 - Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values 4 - Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators 5 - Retrieving Data from Tables Combine Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Check for Unmatched Records Retrieve Information from a Single Table Using Joins 6 - Presenting Query Results Save the Query Result Generate an XML Report

In this practical workshop session we will explore ways of including young people of all ages who experience anxiety some of whom may well be on the autism spectrum. The session will be values based and practical and will aim to allow the sharing of experiences and good practice as well as promoting innovative approaches to inclusion through the design of best practice. Course Category Autism and Communication Inclusion Parents and Carers Behaviour and Relationships Meeting emotional needs Description In this practical workshop session we will explore ways of including anxious children in mainstream schools and settings. The session will be values based and practical and will aim to allow the sharing of experiences and good practice as well as promoting innovative approaches to inclusion through the design of best practice. Family perspectives and experiences will also be explored. This is not a ‘medical model’ day on anxiety.  Testimonials ‘Really gave me an idea of how people feel and helped me think how to plan to meet their needs.’ ‘Really useful insights’  Learning Objectives Increased confidence and understanding regarding including anxious children Access to a wider range of practical strategies to impact on anxiety Deeper understanding of core values surrounding inclusion New skills and processes to strengthen the inclusion of anxious children Insights and understanding of sensory sensitivities Understanding increased in area of movement differences Who Is It For? Personal Assistants Teachers Heads and deputies Guidance staff Learning support teams SENCOs Primary and secondary teachers Parents Brothers and sisters Local authority support services Community workers and carers Course Content The course answers the questions : What is anxiety? How do we go about including anxious children? Can we understand more deeply what is going on underneath concerning behaviours? Key themes include: Movement differences Supports and Accommodations for Sensory Sensitivities Developing Friendships and Peer Support Learning to Listen

What is Person Centred Planning? How is it different to any other kind of meeting or planning? On this day all will become clear… Give your team the opportunity to pause and reflect on what matters most to them about the work they do. The act of listening to each other creates relationship and strengthens trust and inclusion within the team – in creating a shared vision, groups of people build a sense of commitment together. They develop images of ‘the future we want to create together’, along with the values that will be important in getting there and the goals they want to see achieved along the way. Unfortunately, many people still think ’vision’ is the top leader’s job. In schools, the ‘vision task’ usually falls to the Headteacher and/or the governors or it comes in a glossy document from the local authority or the DfES. But visions based on authority are not sustainable. Making inclusive action plans using full participation and graphic facilitation Drawing on the planning tools MAPS and PATH (Pearpoint, Forest and O’Brien 1997) and other facilitation sources we use both process and graphic facilitation to enable the group to build their picture of what they would love to see happening within their organisation/community in the future and we encourage this to be a positive naming, not just a list of the things they want to avoid. Jack Pearpoint, Marsha Forest and John O’Brien developed these innovative approaches in North America and they are being used successfully in many parts of the UK. The planning can focus on an individual, group or organisation and provides a powerful problem solving opportunity, which is flexible and robust enough for many occasions. Tell the story, find the dream, touch the nightmare, and explore who you are, what are the gifts and strengths of the person or group, what are the needs of those present and what is the action plan for the future? Learning objectives  Participants understand Person Centred Planning and its values and applications Participants have skills and confidence to facilitate PATH/MAP processes Participants learn graphic as well as process facilitation skills Strengthens practitioners inclusive practice Provides additional tools for those involved in inclusive work in schools and the community Further develop problem solving and planning skills Course Content The course answers the questions: Need to find new ways to bring Pathway Planning alive? 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 LA? Inclusive Solutions offer an introductory day to person centred planning or a 3 – 10 session course which is practical as well as values based. Participants will receive direct individualised coaching and training. We will cover: The person being at the centre Family members and friends being full partners Planning reflecting the person’s capacities, what is important to the person and specifying the support they require to make a full contribution to their community Planning building a shared commitment to action that will uphold the person’s rights Planning leading to continual listening, learning and action and helping the person get what they want out of life. Essential Lifestyle Planning, PATH MAPS Personal Futures Planning.

This beginner's level course on Pandas acquaints you to the data analysis fundamentals using Pandas library and working with Pandas primary data structures, Series and DataFrame. Learn all about data input using indexing and filtering, data preprocessing, and handle missing values and duplicate rows to transform your data more efficiently with the help of this hands-on course.

A Solution Circle is a 30 minute creative Problem Solving Process for getting unstuck…Ideal for busy people! lt was designed by Marsha Forest & Jack Pearpoint. This is a short and powerful tool. It is effective in getting “unstuck” from a problem in life or work. Solution Circles are tools of “community capacity”. It assumes and demonstrates that nearby people – in any community or work place have the capacity to help – if asked. It requires a person to ASK – not an easy thing in our culture of privacy and “do it alone”. This tool puts all the values we espouse into practice and demonstrates that TOGETHER WE’RE BETTER. Course Category Problem Solving Description A Solution Circle is a 30 minute creative Problem Solving Process for getting unstuck…Ideal for busy people! lt was designed by Marsha Forest & Jack Pearpoint. This is a short and powerful tool. It is effective in getting “unstuck” from a problem in life or work. Solution Circles are tools of “community capacity”. It assumes and demonstrates that nearby people – in any community or work place have the capacity to help – if asked. It requires a person to ASK – not an easy thing in our culture of privacy and “do it alone”. This tool puts all the values we espouse into practice and demonstrates that TOGETHER WE’RE BETTER. In this training you will learn how to set up and facilitate Solution Circles  Learning Objectives For participants to learn how to facilitate a Solution Circle For participants to understand the underlying rationale and ethos of this way of working For participants to learn the power of team work and problem solving when including challenging individuals Who Is It For? Team Around the Child agencies Parents and Professional working together Families Multi Agency Teams Social workers CAMHS teams Year Managers Primary and secondary staff teams Early Years and School based Practitioners Heads and Deputies SENDCOs Advanced Skills Teachers Primary and secondary teachers Local Authority Support Services Course Content This can be introduced in a twilight, half day or even a full day workshop with individualised coaching. We will provide background context for this approach and will directly model the process with real live issues facing participants. So bring your most challenging concerns to this training. The course answers the questions: What to when you are stuck Can we find an alternative to permanent exclusion or special unit or school placement? Struggling with a child for whom praise is ineffective? Feeling isolated in your responses to a child’s needs? Worried about where your instinctive reactions are leading you? Cannot seem to get any consensus view of a young person’s behaviour/needs amongst all the family and professionals involved – is everyone pulling in different directions? We will cover: Setting the tone Background and detailed teaching of process Inclusion values underpinning this work Graphic and process facilitation skills Processes modelled and opportunities to try process out with coaching Practical setting up of insights and solutions circles Lessons learned

So you appreciated a Keys to Inclusion day? Wondering what next? The Next Set follows on from our lead workshop/training day and is both values driven and a practical guide to successful strategies for further developing inclusive practice in educational settings for children and young people of all ages. Course Category Inclusion Description So you appreciated a Keys to Inclusion day? Wondering what next? The Next Set follows on from our lead workshop/training day and is both values driven and a practical guide to successful strategies for further developing inclusive practice in educational settings for children and young people of all ages. On this day we explore processes and ideas ranging from the individual practitioner’s imagination through to the creating of a community gathering to strengthen inclusion of disabled and disempowered adults and children. This too is a ‘hearts and minds’ day in which you can expect participants to both laugh and cry in equal measure! The day gives those present lots of opportunities to reflect on their attitudes and practice in relation to the inclusion of pupils who are different and most challenging. Testimonials I have learned such a lot. I have learned so much. Keep an Open Mind. Really inspired! I can’t wait to share the day Learning Objectives Increased confidence regarding developing inclusive practice in mainstream schools Access to a wider range of practical strategies to impact on behaviour problems Deeper understanding of core values surrounding inclusion of disabled children Opportunity to reflect on professional attitudes and behaviour towards parents and pupils New skills and processes to make inclusion successful Who Is It For ? Early Years and School based Practitioners Heads and Deputies SENCOs Advanced Skills Teachers Primary and secondary teachers Parents Local Authority Support Services Course Content The course answers the questions : What next after a Keys day? How do we take people with us? What else can we do to go about including high profile children or young people? What does inclusion really have to do with me? Best delivered over the course of a full day, ‘Keys to Inclusion’ introduces participants to 6 guiding Ideas that underpin inclusive practice. The power of imagination Determination and persistence Growing Relationships How to help not hinder Communicating honestly and directly Creating Community Circles If you liked this course you may well like: KEYS TO INCLUSION Or: INCLUSION: IT DOESN’T JUST HAPPEN

Scrum Master Workshop: In-House Training A Scrum Master helps project teams properly use the Scrum framework, increasing the likelihood of the project's overall success. Scrum Masters understand Scrum values, practices, and applications and provide a level of knowledge and expertise above and beyond that of typical project managers. Scrum Masters act as 'servant leaders', helping the rest of the Scrum Team work together and learn the Scrum framework. Scrum Masters also protect the team from both internal and external distractions. What you will Learn You'll learn how to: Comprehend the Agile Manifesto and mindset Explain the fundamental principles of Scrum Guide the Scrum team in their responsibilities Write requirements in the form of user stories Define Ready and Done Estimate using planning poker and prioritize using MoSCoW Facilitate the team through the 5 Sprint events Fulfill the role of Scrum Master in a Scrum project Create Information Radiators to enable transparency Define the structure of the retrospective Foundation Concepts Agile History, Values, and Mindset Introduction to Scrum Scrum events Scrum artifacts Scrum Roles and Responsibilities Product Owner responsibilities Scrum Master responsibilities The Team responsibilities Cross-functional Teams Building Effective Teams The Product Backlog and User Stories The Product Backlog User Stories Definition of Done Backlog grooming Estimating User Stories Story points, planning poker Prioritizing User Stories The Sprint Team capacity and velocity The Sprint Planning Meeting The Sprint Backlog The Sprint Learning to self-manage, self-organize, self-improve Sprint Review and Retrospective Project Progress and Completion The Daily Scrum The Task Board and The Burndown Chart Information Radiators Closing a Scrum Project Summary and Next Steps Review of course goals, objectives, and content

Work with Rachel to enhance your well-being and improve your quality of life. Reduce anxiety and stress, develop time management strategies, set goals, explore your purpose and values, improve confidence and self-worth, work on self-care and self-compassion, explore your limiting beliefs, regulate your emotions, manage chronic fatigue, improve your resilience, and much more.

This training is aimed at developing Person Centred Planning – for Local Authority, School or Multi Academy Trust professional teams. Parents and carers can also participate in this training. One day introduction to underlying values and practicalities of approach in schools – 100 people 2 Day skill training for 30 participants to learn PATH planning skills 1 day follow up after 3 months to problem solve issues and celebrate what achieved. Person Centred Planning (PCP) is a way of expressing a set of inclusive values through a unique range of tools and techniques. The most commonly used person centred tool with children is a PATH – and it shows these values in action. Why now? The Children and Families Act 2014 sets out clear principles for supporting and involving children and young people in all aspects of the support and planning of their special educational need. The Special Educational Needs and Disability Code of Practice: 0 – 25 years provides the statutory guidance relating to part 3 of the Children and Families Act 2014. Embedded in its principles is the need for a stronger focus on the participation of children, young people and their parents/carers in decision making at both individual and strategic levels. The use of Person Centred Approaches provides the opportunity to fulfil those principles. Working in this way ensures the CYP and their parents/carers are at the centre of all decision making and future planning. It provides an opportunity to engage directly with children and young people to discuss their needs, and plan how they can achieve the best possible outcomes. This should be integral to all planning for children and young people with Special Educational Need and Disability (SEND) throughout their lives. Education Health Care Planning processes are required to be truly person centred at every stage, including annual reviews, so understanding this way of working has never been more essential. Is this different to what we do already? This person-centred way of working offers a radical new approach to visualising planning, empowering and directly involving children and those that care about them throughout planning meetings and allowing for inclusive, creative methodology which builds on and challenges existing practice in schools. Core principles The focus of inclusive, person-centred working is first and foremost on ordinary needs and not solely on special needs. – Being somebody – Contributing by sharing gifts and capacities – Knowing people and having relationships – Having choice and control – Sharing ordinary places – being present in local spaces and having a valued role there The training is delivered by Inclusive Solutions who are Educational Psychologists with a national reputation for training and person centred planning with schools over the last 16 years. In this training, you will learn how to facilitate with a child, family, team or an organisation to think together around their preferred future or about a challenge or issue. Here is an opportunity to experience first-hand the person centred, futures planning tool – PATH (Pearpoint, Forest et. al. 1989). This course will provide participants with a practical introduction to person centred planning and approaches, including examples of best practice in using person centred approaches in schools. The course will explore the underlying values of person centred approaches, provide an introduction to the person centred planning tools and link this to national policy and guidance. Participants will gain: 1 Knowledge of person centred planning and approaches 2 An understanding of how person centred approaches can be used in schools 3 A basic knowledge of the person centred review process and where to find out more information 4 The skills to gather information about what is important to and for the children and young people they support 5 An understanding of PATH and situations in which this process could be used in school The course answers these questions: • What are person centred approaches? • How can we use person centred approaches in our school? • What is person centred thinking and how can it be used in schools? • How can we learn about what is important to and for the child or young person and share this information? • How can we make sure that the child is at the centre of their annual/transition review?

Leadership and Management development, Leadership training, management training, Leadership development