27949 OV courses delivered Online

Learn how to establish deliberate and creative interactions that allow users to navigate a platform in the ways that makes sense to them.

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

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

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

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

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

Why Learn Vectorworks Spotlight Training Courses? VectorWorks Spotlight Course offers strong 2D drawing tools and lighting skills. while. Spotlight goes beyond fundamentals, offering solution for designing, modeling, and sharing entertainment projects. It's the industry standard for lighting, scenery, sets, corporate events, theater, and exhibits. Click here for more info: Website When can I book this course? 1-on-1 training. Duration: 16 hrs, Flexible scheduling (Mon to Sat, 9 am - 7 pm). Choose your own day and time. Training Course: Vectorworks Spotlight Duration: 16 hours Course Overview: I. Introduction to Vectorworks (1 hour) Overview of Vectorworks software and its diverse applications Familiarization with the user interface and navigation Customizing preferences and settings to optimize workflow II. 2D Drawing Tools (2 hours) Utilizing basic drawing tools for creating lines, rectangles, circles, and polygons Implementing text and dimension tools for annotations Applying modify tools for object editing and transformation Organizing elements using layers and classes III. 3D Modeling Tools (3 hours) Introduction to extrude, revolve, sweep, and loft tools for 3D modeling Creating 3D objects from 2D shapes for spatial representation Modifying and refining 3D models Exploration of the 3D modeling environment IV. Advanced 3D Modeling Tools (2 hours) Utilization of solid modeling tools for complex geometry creation Performing Boolean operations to combine or subtract shapes Creation and use of symbols for efficient workflow V. Introduction to Spotlight (1 hour) Overview of the Spotlight workspace and its features Adding and configuring lighting devices for stage and event design Creation and modification of lighting positions for precise placement VI. Spotlight Tools and Techniques (3 hours) Creation and editing of lighting instruments for customized setups Use of visualization tools for lighting simulations Creation and application of labels and legends for documentation Generation of worksheets and reports for lighting analysis VII. Advanced Spotlight Techniques (2 hours) Utilization of video and projection tools for multimedia presentations Incorporation of audio and sound systems for immersive experiences Understanding rigging and hoisting for stage setup Management of paperwork and documentation for effective planning VIII. Integration with Other Software (1 hour) Importing and exporting files for collaborative work with other software Utilizing Vectorworks in CAD and BIM workflows for seamless interoperability Exploration of plugins and add-ons for expanded functionality IX. Project-based Exercises (1 hour) Application of learned techniques to real-world scenarios Creation of a lighting plan for a concert or theater production Designing a 3D model of a building or interior space Free 30-day BIM & CAD Software Trial Request: Vectorworks After completing Vectorworks 2D | 3D and Spotlight Training Course? Vectorworks Proficiency: Master Vectorworks software, including interface and tools. 2D Drafting: Create precise technical drawings using fundamental 2D tools. 3D Modeling: Develop skills in 3D modeling, modification, and spatial representation. Spotlight Expertise: Learn stage and event design tools, focusing on lighting setups. Advanced Techniques: Explore complex 3D modeling and Spotlight features. Interdisciplinary Integration: Integrate Vectorworks with other software in CAD and BIM workflows. Project Application: Apply skills to real-world scenarios, creating plans and models. Job Opportunities: CAD Technician: Draft detailed plans for architecture and engineering firms. Stage Designer: Plan lighting, sound, and multimedia setups for events. Event Planner: Design event layouts with lighting and audio-visual setups. Architectural Drafter: Create accurate architectural plans and models. Interior Designer: Visualize interior spaces in 2D and 3D for clients. Lighting Designer: Specialize in various lighting applications, from buildings to stages. BIM Specialist: Work with architectural firms on Building Information Modeling projects. Freelance Designer: Offer services in 2D/3D modeling, event planning, or architectural visualization. What is Vectorworks Spotlight? Vectorworks Spotlight is a specialized package tailored for entertainment design professionals, offering both 2D and 3D capabilities. It is the industry-standard CAD software for entertainment design, ideal for lighting, scenery, sets, events, theater, and exhibits. Training Details: Duration: 16 hrs (flexible scheduling) Method: Personalized 1-on-1 training (In-person or Live Online over Zoom) Tailored content, adaptable pace, individual support Differences from Vectorworks Fundamentals: Vectorworks Fundamentals serves general modeling and drawing needs, while Spotlight provides comprehensive solutions for design, modeling, documentation, and collaborative project sharing, catering specifically to industry experts. Applications of Spotlight: Spotlights have diverse uses, including emergency situations and when a powerful light source surpassing a flashlight is required. Interior Designers and Vectorworks: Yes, interior designers use Vectorworks software, particularly Vectorworks Architect, for efficient workflow and effective realization of creative visions. Course Structure: Individualized Instruction (1-2-1) Customized Content Adaptable Learning Pace Flexible Scheduling: Monday to Saturday, 9 am to 7 pm Get Vectorworks: For more information and to download Vectorworks, visit Vectorworks Website. Individualized Training: Get personalized attention and tailored guidance during your training sessions. Flexible Timings: Select your preferred schedule and training days to fit your convenience. Post-Training Assistance: Access complimentary online support even after course completion. Comprehensive Resources: Receive detailed PDF notes and handouts for effective learning. Certification of Completion: Receive a recognition certificate upon successfully finishing the course. Affordable Pricing: Take advantage of budget-friendly training rates. Software Setup Support: Receive assistance in configuring the software on your device. Referral Benefits: Recommend a friend and enjoy discounts on upcoming courses. Group Training Offers: Benefit from special discounts for group training programs. Convenient Hours: Attend sessions from Monday to Sunday, with extended operating hours. Tailored Learning: Experience customized training designed to meet your specific requirements.

P901 - Management and control of building hot and cold water services is there to provide background and an overview of the risk of Legionella infection and how it can be controlled in domestic type hot and cold water systems. (This course is also a pre-requirement before undertaking course P903 - Management and Control of Evaporative Cooling Systems and other High Risk Industrial Systems or P904 - Management and Control in Leisure, Display, Therapy and other Non-Industrial Systems.)

P901 - Management and control of building hot and cold water services is there to provide background and an overview of the risk of Legionella infection and how it can be controlled in domestic type hot and cold water systems. (This course is also a pre-requirement before undertaking course P903 - Management and Control of Evaporative Cooling Systems and other High Risk Industrial Systems or P904 - Management and Control in Leisure, Display, Therapy and other Non-Industrial Systems.)

Highlights of the Course Course Type: Self-Paced Online Learning Guided Learning Hours: 360 Teaching Practice Hours: 100 Accreditation: NCFE Qualification: Nationally Recognised Qualification Study Materials: High-Quality E-Learning Study Materials Certificate: Certificate upon passing the official exam Access: Lifetime Access Tutor Support- Personalised feedback on your all assignments Customer Support: 24/7 live chat available What you will learn from this course? Upon successful completion of this Level 5 Diploma in Education and Training, you will be able to: Include learning strategies, concepts, and models in the design of inclusive classroom instruction and learning Create and maintain a safe, pleasant teaching and learning environment by utilising behaviour control techniques Deliver inclusive instruction and learning utilizing communication and learning theories, ideas, and models Use assessment theories, models, and principles to illustrate how to evaluate learning in training and education Utilise theories and techniques for reflection and assessment, and evaluate one's own approach to planning, executing, and evaluating inclusive teaching and learning Learn how to conduct an initial and diagnostic assessment to determine an individual's earning goals as well as the relationships, roles, and processes that are part of education and training Establish and maintain a safe environment for teaching and learning, as well as how to plan for and carry out inclusive teaching Use theories and models of curriculum creation in your area of expertise and how to use those theories to assess your own methods Recognise professionalism and the influence it has on education and training, as well as the impact of accountability to stakeholders and outside organisations Understand how education and training are governed by policy and support your organisation's attempts to improve quality Level 5 Diploma in Education & Training Online | L5 Diploma This Level 5 Diploma in Education and Training is accredited by NCFE and regulated by Ofqual, making it a nationally recognised credential that will improve your CV and set you apart from the competition. This is the ideal approach for teachers who have already finished levels 3 and 4 or aiming to achieve Qualified Teacher Status (QTLS). This course will help you gain advanced knowledge and skills to lead learning sessions, organise lesson plans, and create teaching and learning strategies. Towards the end of this course, you'll acquire an extensive range of teaching abilities and expertise you need to establish a successful career in the education sector, as well as gain the status to start working as a teacher. Who is this Course for? The following individuals may benefit from this Level 5 Diploma in Education and Training: all types of trainers aspirant teachers teachers of all levels teacher trainers teachers wishing to achieve Qualified Teacher Status (QTLS) teachers wishing to improve their instructional abilities teachers wishing to enhance their employment prospects Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Eligibility Requirements This Level 5 Diploma in Education and Training has no academic prerequisites and is open to students from all academic disciplines.  Assessment Procedure Upon successful completion of this Level 5 Diploma in Education and Training, you will be evaluated by a series of assignments that the instructors of the course will internally construct and grade. This strategy will give students more confidence to ace the exam because it precisely represents the content taught in class and fits the teaching methodology being used. "Pass" represents the qualification's overall grade Each item included in the qualification framework must be completed by the student For a student to pass a unit, they must demonstrate their understanding of each unit by achieving all of the listed learning outcomes and meeting all of the evaluation criteria Assignment Submission For each portion of the diploma, you are required to submit a number of assignments each weighing about 1000-2000 words. Product evidence requirements, such as lesson plans, teaching resources, and other pertinent paperwork, must also be accompanied by some of these assignments. Assignments should incorporate theory and establish connections to actual workplace or classroom circumstances in order to convey pertinent arguments. These assignments will aid in your exploration and application of the entire teaching and learning cycle. If more work is needed, your instructor will offer feedback and the chance to resubmit assignments. Practical Teaching Assessment There must be a minimum of 8 observations, each lasting at least 8 hours. This excludes any observed practice that was completed as a component of the Level 3 Award in Education and Training. A minimum of 30 minutes must pass between each observation. This witness evidence must be given by a teacher who possesses the necessary qualifications. In extraordinary circumstances, we may also set up a video link with your tutor to finish these observations. The eight observations must relate to the following essential units: Education and training teaching, learning, and evaluation (level 4) Enhancing education and training through teaching, learning, and assessment (level 5) No previous experience is required to enrol into this course. However, you must complete 100 hours of in-class teaching experience throughout the course of the program to receive your completion certificate. Your practical teaching demonstration will need to be observed by an expert witness who has a level 5 diploma in education and training. For an extra charge of £250 + VAT for 8 hours, if you'd prefer, we can assist you by providing an expert witness.  Advance Your Career This Level 5 Diploma in Education and Training will provide you with significant opportunities to enter the relevant job market and select your desired career path. Additionally, by showcasing these skills on your resume, you will be able to develop your career, face more competitors in your chosen sector, and increase your level of competition. This course will also allow you to acquire the required skills to work towards achieving the Qualified Teacher Status and progress to Bachelor of Arts (BA) or Bachelor of Science (BSc).  If you are looking for a Level 4 Certificate in Education and Training, enrol into our affordable and highly informative course, which will open your door towards a wide range of opportunities within your chosen sector.  This Level 5 Diploma in Education and Training is accredited by NCFE and regulated by Ofqual. The National Council for Educational Awarding (NCFE) is a national educational awarding body that is well-known and respected throughout the world, which will improve your prospects of finding employment and showcase your professional growth. Course Curriculum Course Overview Course Overview - Level 5 Diploma in Education and Training 00:00:00 Sample Useful Documents Observation Recording Requirements. 00:15:00 Session Plan Pro-Forma 00:15:00 Sample Portfolio Building Record Sheets 00:15:00 Sample Graded Observation Pro-Forma 00:15:00 Lesson 1: Roles Responsibilities of Teachers in Education Learning Lesson 1: Roles Responsibilities of Teachers in Education Learning 00:45:00 Lesson 2 : Pedagogical Principles Theory and Practice Lesson 2 : Pedagogical Principles Theory and Practice 00:40:00 Lesson 3 : Functional Skills and the Minimum Core Lesson 3 : Functional Skills and the Minimum Core 00:40:00 Lesson 4 : Planning in Education and Learning Lesson 4 : Planning in Education and Learning 00:30:00 Lesson 5 : Selecting, Creating and Using Resources Lesson 5 : Selecting, Creating and Using Resources 00:30:00 Lesson 6 : Augmenting Communication through Teaching Strategies Lesson 6 : Augmenting Communication through Teaching Strategies 00:30:00 Lesson 7 : The Assessment Process Lesson 7 : The Assessment Process 00:30:00 Lesson 8 : Managing Learners Lesson 8 : Managing Learners 00:30:00 Lesson 9 : Professionalism and Continued Professional Development Lesson 9 : Professionalism and Continued Professional Development 00:25:00 Lesson 10 : Developing Designing Curriculum Lesson 10 : Developing Designing Curriculum 00:28:00 Lesson 11 : The Professional Practice Quality Management Lesson 11 : The Professional Practice Quality Management 00:26:00 Lesson 12 - Developing, Using and Organising Resources in a Specialist Area Lesson 12 - Developing, Using and Organising Resources in a Specialist Area 00:30:00 Additional Resource Additional Resource - Level 5 Diploma in Education and Training 04:00:00 Assignment - Mandatory Units Assignment 1: Developing Teaching, Learning and Assessment in Education and Training Assignment 1 - Developing Teaching, Learning and Assessment in Education and Training 00:00:00 Assignment 2: Teaching, Learning and Assessment in Education and Training Assignment 2 - Teaching, Learning and Assessment in Education and Training 00:00:00 Assignment 3: Theories, Principles and Models in Education and Training Assignment 3 - Theories, Principles and Models in Education and Training 00:00:00 Assignment 4: Wider Professional Practice and Development in Education and Training Assignment 4 - Wider Professional Practice and Development in Education and Training 00:00:00 Assignment 5: Develop Learning and Development Programmes Assignment 5 - Develop Learning and Development Programmes 00:00:00 Assignment 6: Identify the Learning Needs of Organisations Assignment 6 - Identify the Learning Needs of Organisations 00:00:00 Assignment 7: Internally Assure the Quality of Assessment Assignment 7 - Internally Assure the Quality of Assessment 00:00:00 Assignment 8: Understanding and Managing Behaviours in a Learning Environment Assignment 8 - Understanding and Managing Behaviours in a Learning Environment 00:00:00 Assignment 9: Understanding the Principles and Practices of Internally Assuring the Quality of Assessment Assignment 9 - Understanding the Principles and Practices of Internally Assuring the Quality of Assessments 00:00:00 Assignment 10: Working with Individual Learners Assignment 10 - Working with Individual Learners 00:00:00 Feedback Feedback 00:00:00