17404 Other courses in Aberystwyth delivered Online

Overview This comprehensive course on SQL NoSQL Big Data and Hadoop will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This SQL NoSQL Big Data and Hadoop comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this SQL NoSQL Big Data and Hadoop. It is available to all students, of all academic backgrounds. Requirements Our SQL NoSQL Big Data and Hadoop is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 14 sections • 130 lectures • 22:34:00 total length •Introduction: 00:07:00 •Building a Data-driven Organization - Introduction: 00:04:00 •Data Engineering: 00:06:00 •Learning Environment & Course Material: 00:04:00 •Movielens Dataset: 00:03:00 •Introduction to Relational Databases: 00:09:00 •SQL: 00:05:00 •Movielens Relational Model: 00:15:00 •Movielens Relational Model: Normalization vs Denormalization: 00:16:00 •MySQL: 00:05:00 •Movielens in MySQL: Database import: 00:06:00 •OLTP in RDBMS: CRUD Applications: 00:17:00 •Indexes: 00:16:00 •Data Warehousing: 00:15:00 •Analytical Processing: 00:17:00 •Transaction Logs: 00:06:00 •Relational Databases - Wrap Up: 00:03:00 •Distributed Databases: 00:07:00 •CAP Theorem: 00:10:00 •BASE: 00:07:00 •Other Classifications: 00:07:00 •Introduction to KV Stores: 00:02:00 •Redis: 00:04:00 •Install Redis: 00:07:00 •Time Complexity of Algorithm: 00:05:00 •Data Structures in Redis : Key & String: 00:20:00 •Data Structures in Redis II : Hash & List: 00:18:00 •Data structures in Redis III : Set & Sorted Set: 00:21:00 •Data structures in Redis IV : Geo & HyperLogLog: 00:11:00 •Data structures in Redis V : Pubsub & Transaction: 00:08:00 •Modelling Movielens in Redis: 00:11:00 •Redis Example in Application: 00:29:00 •KV Stores: Wrap Up: 00:02:00 •Introduction to Document-Oriented Databases: 00:05:00 •MongoDB: 00:04:00 •MongoDB Installation: 00:02:00 •Movielens in MongoDB: 00:13:00 •Movielens in MongoDB: Normalization vs Denormalization: 00:11:00 •Movielens in MongoDB: Implementation: 00:10:00 •CRUD Operations in MongoDB: 00:13:00 •Indexes: 00:16:00 •MongoDB Aggregation Query - MapReduce function: 00:09:00 •MongoDB Aggregation Query - Aggregation Framework: 00:16:00 •Demo: MySQL vs MongoDB. Modeling with Spark: 00:02:00 •Document Stores: Wrap Up: 00:03:00 •Introduction to Search Engine Stores: 00:05:00 •Elasticsearch: 00:09:00 •Basic Terms Concepts and Description: 00:13:00 •Movielens in Elastisearch: 00:12:00 •CRUD in Elasticsearch: 00:15:00 •Search Queries in Elasticsearch: 00:23:00 •Aggregation Queries in Elasticsearch: 00:23:00 •The Elastic Stack (ELK): 00:12:00 •Use case: UFO Sighting in ElasticSearch: 00:29:00 •Search Engines: Wrap Up: 00:04:00 •Introduction to Columnar databases: 00:06:00 •HBase: 00:07:00 •HBase Architecture: 00:09:00 •HBase Installation: 00:09:00 •Apache Zookeeper: 00:06:00 •Movielens Data in HBase: 00:17:00 •Performing CRUD in HBase: 00:24:00 •SQL on HBase - Apache Phoenix: 00:14:00 •SQL on HBase - Apache Phoenix - Movielens: 00:10:00 •Demo : GeoLife GPS Trajectories: 00:02:00 •Wide Column Store: Wrap Up: 00:05:00 •Introduction to Time Series: 00:09:00 •InfluxDB: 00:03:00 •InfluxDB Installation: 00:07:00 •InfluxDB Data Model: 00:07:00 •Data manipulation in InfluxDB: 00:17:00 •TICK Stack I: 00:12:00 •TICK Stack II: 00:23:00 •Time Series Databases: Wrap Up: 00:04:00 •Introduction to Graph Databases: 00:05:00 •Modelling in Graph: 00:14:00 •Modelling Movielens as a Graph: 00:10:00 •Neo4J: 00:04:00 •Neo4J installation: 00:08:00 •Cypher: 00:12:00 •Cypher II: 00:19:00 •Movielens in Neo4J: Data Import: 00:17:00 •Movielens in Neo4J: Spring Application: 00:12:00 •Data Analysis in Graph Databases: 00:05:00 •Examples of Graph Algorithms in Neo4J: 00:18:00 •Graph Databases: Wrap Up: 00:07:00 •Introduction to Big Data With Apache Hadoop: 00:06:00 •Big Data Storage in Hadoop (HDFS): 00:16:00 •Big Data Processing : YARN: 00:11:00 •Installation: 00:13:00 •Data Processing in Hadoop (MapReduce): 00:14:00 •Examples in MapReduce: 00:25:00 •Data Processing in Hadoop (Pig): 00:12:00 •Examples in Pig: 00:21:00 •Data Processing in Hadoop (Spark): 00:23:00 •Examples in Spark: 00:23:00 •Data Analytics with Apache Spark: 00:09:00 •Data Compression: 00:06:00 •Data serialization and storage formats: 00:20:00 •Hadoop: Wrap Up: 00:07:00 •Introduction Big Data SQL Engines: 00:03:00 •Apache Hive: 00:10:00 •Apache Hive : Demonstration: 00:20:00 •MPP SQL-on-Hadoop: Introduction: 00:03:00 •Impala: 00:06:00 •Impala : Demonstration: 00:18:00 •PrestoDB: 00:13:00 •PrestoDB : Demonstration: 00:14:00 •SQL-on-Hadoop: Wrap Up: 00:02:00 •Data Architectures: 00:05:00 •Introduction to Distributed Commit Logs: 00:07:00 •Apache Kafka: 00:03:00 •Confluent Platform Installation: 00:10:00 •Data Modeling in Kafka I: 00:13:00 •Data Modeling in Kafka II: 00:15:00 •Data Generation for Testing: 00:09:00 •Use case: Toll fee Collection: 00:04:00 •Stream processing: 00:11:00 •Stream Processing II with Stream + Connect APIs: 00:19:00 •Example: Kafka Streams: 00:15:00 •KSQL : Streaming Processing in SQL: 00:04:00 •KSQL: Example: 00:14:00 •Demonstration: NYC Taxi and Fares: 00:01:00 •Streaming: Wrap Up: 00:02:00 •Database Polyglot: 00:04:00 •Extending your knowledge: 00:08:00 •Data Visualization: 00:11:00 •Building a Data-driven Organization - Conclusion: 00:07:00 •Conclusion: 00:03:00 •Assignment -SQL NoSQL Big Data and Hadoop: 00:00:00

Nurse Prescribing: Nurse Prescribing Course Online This Nurse Prescribing: Nurse Prescribing Course is designed for those who work in nursing and want to learn more about Nursing & Prescribing procedures or how to work with a prescriber. This Nurse Prescribing: Nurse Prescribing Course is also appropriate for pharmacists and other healthcare professionals interested in learning about independent prescribing. With this Nurse Prescribing: Nurse Prescribing Course, you will learn how to write prescriptions, keep records, label drugs, administer controlled substances, and provide palliative care and manage medicines in nursing homes. By the end of this Nurse Prescribing: Nurse Prescribing Course, you will know everything a world-class nurse knows. Our Nurse Prescribing: Nurse Prescribing Course can help you achieve your goals and prepare you for a rewarding career. So, enrol in this Nurse Prescribing: Nurse Prescribing Course today and arm yourself with the necessary skills to set yourself up for success! Why choose this Nurse Prescribing: Nurse Prescribing Course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Nurse Prescribing: Nurse Prescribing Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Nurse Prescribing: Nurse Prescribing Course. Main Course: Nurse Prescribing Course Free Courses: Course 01: Nursery Nurse Course Course 02: Level 3 Phlebotomy Training [ Note: Free PDF certificate as soon as completing the Early Years: Early Years Course] Nurse Prescribing: Nurse Prescribing Course Online Course Curriculum of Nurse Prescribing: Nurse Prescribing Course Module 01: An Overview of Nurse Prescribing Module 02: How to Prescribe Controlled Drugs Module 03: Neuropathic Pain in Adults: Pharmacological Management Module 04: Coping with Generalised Anxiety Disorder and Panic Disorder in Adults Module 05: Diagnosis and Management of Headaches in Over 12s Module 06: Understanding Depression in Adults Module 07: Palliative Care for Adults Module 08: Prescribing Antibiotics in Respiratory Tract Infections Module 09: Prescribing and Managing Medicines in Care Homes Module 10: Antimicrobial Prescribing for Hospital Acquired Pneumonia Module 11: Antimicrobial Prescribing for Acute Prostatitis and Sinusitis Module 12: Drug Misuse in Over 16s: Opioid Detoxification Module 13: Future Challenges for Nurse Prescribers Assessment Method of Nurse Prescribing: Nurse Prescribing Course After completing Nurse Prescribing: Nurse Prescribing Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Nurse Prescribing: Nurse Prescribing Course After completing the Nurse Prescribing: Nurse Prescribing Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Nurse Prescribing: Nurse Prescribing Course Online This Nurse Prescribing: Nurse Prescribing Course is ideal for aspiring nurses, prescribers, pharmacists, and those working in other fields where medicine is administered and prescribed. Requirements Nurse Prescribing: Nurse Prescribing Course Online To enrol in this Nurse Prescribing: Nurse Prescribing Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Nurse Prescribing: Nurse Prescribing Course. Be energetic and self-motivated to complete our Nurse Prescribing: Nurse Prescribing Course. Basic computer Skill is required to complete our Nurse Prescribing: Nurse Prescribing Course. If you want to enrol in our Nurse Prescribing: Nurse Prescribing Course, you must be at least 15 years old. Career path Nurse Prescribing: Nurse Prescribing Course Online This Nurse Prescribing: Nurse Prescribing Course will provide you with all of the fundamental skills needed to prescribe, as well as the opportunity to work in a variety of professions, including: Nurses Healthcare professionals Pharmacists

Clinical Psychology: Clinical Psychology Online Are you looking to develop or establish a career in psychology or counselling? Then this Clinical Psychology: Clinical Psychology course is perfect for you. Our Clinical Psychology: Clinical Psychology course is divided into several manageable modules ideal for aspiring professionals, allowing our students to easily grasp each concept. The Clinical Psychology: Clinical Psychology course covers a wide range of mental health disorders and provides practical and theoretical knowledge on various forms of psychology and their approaches and applications. It examines the main characteristics of good mental health and then introduces some key statistics about mental health in the United Kingdom. Through this Clinical Psychology: Clinical Psychology course, you will learn about psychiatric disorders in adults, children, and adolescents and the symptoms and treatment of schizophrenia, anorexia nervosa, depression, and other conditions. By the end of the Clinical Psychology: Clinical Psychology course, you will have the professional skills, knowledge, and credentials to pursue a broad range of careers in this field, such as child psychology, CBT therapy, and behavioural therapy. Our comprehensive Clinical Psychology: Clinical Psychology course is the perfect way to kickstart your career in the field of psychology. The Clinical Psychology: Clinical Psychology course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. Main Course: Diploma in Clinical Psychology Free Courses included with Clinical Psychology: Clinical Psychology Course Course 01: Mental Health Care Course Course 02: Introduction to Psychology Course 03: Diploma in Counselling and Psychology [Note: Free PDF certificate as soon as completing the Clinical Psychology: Clinical Psychology course] Clinical Psychology: Clinical Psychology Online This Clinical Psychology: Clinical Psychology course consists of 12 modules. Course Curriculum of Clinical Psychology: Clinical Psychology Course Module 01: An Overview of Mental Health Module 02: Different Viewpoints in Psychology Module 03: Social Psychology Module 04: Utilising Cognitive Psychology Module 05: Understanding Childhood and Adolescent Psychiatric Disorders Module 06: Understanding Stress and Anxiety Disorders Module 07: Understanding Schizophrenia Module 08: Understanding Personality Disorders Module 09: Understanding Mood Disorders Module 10: Understanding Eating & Sleeping Disorders Module 11: Understanding Self-Harm and Suicide Module 12: Treating Mental Illness: Medication and Therapy Assessment Method of Clinical Psychology: Clinical Psychology After completing Clinical Psychology: Clinical Psychology Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Clinical Psychology: Clinical Psychology After completing the Clinical Psychology: Clinical Psychology course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Clinical Psychology: Clinical Psychology Online This Clinical Psychology: Clinical Psychology course is ideal for anyone looking to start a career in the field of psychology or counselling, which includes the following related professions: Child Psychologist CBT Therapist Counsellor Requirements Clinical Psychology: Clinical Psychology Online To enrol in this Clinical Psychology Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Clinical Psychology: Clinical Psychology Course. Be energetic and self-motivated to complete our Clinical Psychology: Clinical Psychology Course. Basic computer Skill is required to complete our Clinical Psychology: Clinical Psychology Course. If you want to enrol in our Clinical Psychology: Clinical Psychology Course, you must be at least 15 years old. Career path Clinical Psychology: Clinical Psychology Online This Clinical Psychology course will prepare you for a variety of career paths, including the following: Psychology Assistant - £20,000 to £30,000 per annum Psychologist - £35,000 to £45,000 per annum Psychiatrist - £45,000 to £60,000 per annum Clinical Counselling Psychologist- £45,000 to £50,000 per annum

Duration 5 Days 30 CPD hours This course is intended for Experienced VMware administrators, automation and orchestration specialists, system integrators, and private cloud and public cloud administrators Overview By the end of the course, you should be able to meet the following objectives: Describe the features and benefits of integrating vRealize Orchestrator and vRealize Automation Describe the role of vRealize Orchestrator workflows and content elements in automation Use the vRealize Orchestrator client to access and navigate the vRealize Orchestrator platform Use the vRealize Orchestrator client to import and run vRealize Orchestrator library workflows Design, develop, and run custom reusable vRealize Orchestrator workflows Integrate vRealize Automation with vRealize Orchestrator to deliver custom IT services Use the vRealize Automation event broker service to trigger specific vRealize Orchestrator workflows or ABX Actions Leverage the event broker to extend IaaS (Infrastructure-as-a-Service) machine lifecycle processes Use XaaS to extend vRealize Automation into other enterprise systems Use VMware APIs to run vRealize Orchestrator workflows Use the vSphere Client Code Capture feature During this five-day course, you focus on using VMware vRealize© Orchestrator? to extend the functionality of VMware vRealize© Automation?. You learn how to provide XaaS (Anything as a Service) and implement Machine Lifecycle Extensibility using the VMware vRealize© Automation? Event Broker. You also learn how to create vRealize Orchestrator workflows and vRealize Automation ABX actions. You learn about various features, including basic scripting implementation along with logic processing to implement a variety of functions to use in your environment. This course teaches implementing debugging, loops, conditions, and user interactions in vRealize Orchestrator. The course introduces the new vRealize Orchestrator HTML 5 interface, along with API calls and REST functions, to give you the groundwork to implement a variety of plugins and scripts. This course is designed to give you the tools to craft custom solutions in the product. Course Introduction Introductions and course logistics Course objectives Overview of vRealize Automation and vRealize Orchestrator Define the purpose of vRealize Automation Outline the purpose of vRealize Orchestrator Describe the main components of vRealize Automation Describe the main components of vRealize Orchestrator Creating Schema Elements Invoking JavaScript from a vRealize Orchestrator workflow Invoking a vRealize Orchestrator Workflow from a vRealize Orchestrator workflow Invoking an action from a vRealize Orchestrator workflow Using vRealize Orchestrator workflows both synchronously and asynchronously Working with Variables Defining inputs, outputs, and variables in vRealize Orchestrator workflows Binding variables in vRealize Orchestrator workflows Wrapping vRealize Orchestrator workflows Using APIs and the API Explorer Creating actions in vRealize Orchestrator Using vRealize Orchestrator input forms Handling user interactions in vRealize Orchestrator Handling Exceptions, Logging, and Debugging Handling exceptions in vRealize Orchestrator workflows Using logs in vRealize Orchestrator workflows Debugging vRealize Orchestrator workflows Branching and Looping Using branching in vRealize Orchestrator workflows Using loops in vRealize Orchestrator workflows Working with Assets Using configuration elements in vRealize Orchestrator Using resources in vRealize Orchestrator Using packages in vRealize Orchestrator Working with Plug-Ins Downloading and installing Plug-Ins Using the SSH plug-In in vRealize Orchestrator Using the REST plug-in in vRealize Orchestrator Using the vRealize Automation plug-in in vRealize Orchestrator Using the PowerShell plug-in in vRealize Orchestrator Working with Versioning and Git Using versioning in vRealize Orchestrator Using Git in vRealize Orchestrator Scheduling, Sleeping, and Waiting Using scheduling in vRealize Orchestrator Using sleeping in vRealize Orchestrator Using waiting in vRealize Orchestrator Introduction to vRealize Automation Extensibility Introduction to extensibility Using ABX actions Using Python Using Nodejs Using PowerShell Using vRealize Automation Lifecycle Extending vRealize Automation with Event Broker Overview of vRealize Automation Event Broker Creating vRealize Automation subscriptions Data exchange between vRealize Automation and vRealize Orchestrator Using ABX Actions Overview of Action Based Extensibility (ABX) Comparison of vRealize Orchestrator and ABX Creating ABX Actions scripts, REST, and flows Using Day-2 Actions in vRealize Automation Describe the visualization capabilities of NSX Network Detection and Response Working with Services, Custom Resources, and Resource Actions Using vRealize Orchestrator as a content source in vRealize Automation Creating custom resources in vRealize Automation Creating resource actions in vRealize Automation Using Day-2 Actions in vRealize Automation Using vSphere Client Code Capture Enabling vSphere Client code capture Using vSphere Client code capture to capture code in vRO, Javascript, PowerCLI or other languages. Using the captured code in vRealize Orchestrator workflows or actions.

Duration 2 Days 12 CPD hours This course is intended for This course has been expressly designed for the Business Analyst, Business System Analyst, System Analyst, and/or Requirements Engineer. The Designer, Developer and Tester who are actively involved in utilizing use cases may also benefit from this workshop. Overview Employ use cases to elicit requirements, at a business, system or subsystem levelEmploy use cases to document the scope of a projectWrite use cases in a clear and unambiguous way.Model use cases with workflow diagramsPlan and divide up the project work based on your use casesManage a use case as it evolves over time and goes through many changes This course provides a strong foundation in the mechanics of use case diagramming and writing textual descriptions of use cases. In this highly interactive workshop, you will learn how to enhance and refine your use case skills, how to involve your stakeholders in the use case process, and how to develop use cases that provide valuable information to the designers and testers. Use cases that meet the needs of designers can be too technical and too detailed for other stakeholders. Use cases that satisfy business users are usually not very helpful to designers and testers. How do you satisfy these two disparate interests? And how do you handle the details like business rules, data validations and user interface specifications? Introduction Course objectives Understanding of business analysis Knowledge areas of BABOK© Guide Overview of Use Cases Describe the purpose and value of a use case approach Use case terminology Introducing a use case approach Needs Assessment Purpose of Needs Assessment Needs Assessment and use cases Defining and understanding the strategic goals and objectives Understanding the business process Identifying actors Identifying business information Analyzing locations and operations Drawing the business use case diagram Building the business architecture Defining solution options Defining System Scope Product scope/project scope System actors versus business actors Analyzing the business process model Analyzing business use cases Identifying candidate use cases Identifying scenarios Diagramming use cases Draw a use case diagram Create a use case catalog Evaluating, Prioritizing, and Packaging Use Cases Iterative nature of this work Evaluating use cases Use case priority Use case risk Use case complexity Use case dependencies Evaluate and Prioritize use cases Dividing work up between releases Packaging A process for how to perform packaging Writing the Main Success Scenario Use case descriptions Primary and secondary goals Assumptions Pre-conditions Triggers Post-conditions Scenario example Main success scenario Conditional execution Use cases and requirements Best practices for writing a use case description Writing the Other Scenarios Scenarios and flows Alternate scenarios and flows Alternate vs. basic flow Guidelines for alternate flows Exception flows Failed post conditions Write alternate and exception flows Process Modeling to Describe Use Case Flows UML© Activity Diagram Notation Sequencing activities Developing an activity diagram Facilitated sessions Draw a UML© Activity Diagram Using Advanced Diagramming Techniques Commonality Dependency Relationships Identify relationships Comparing the different relationships Developing a Requirements Specification Requirements and use cases Detailed requirements Common approaches to specifications Non-functional requirements Write non-functional requirements User interface requirements UI data descriptions Business rules Decision tables and inference rules How to document simple calculations Reporting requirements Data requirements Data accessibility requirements Traceability Course Summary Wrap-up Finding more information Additional course details: Nexus Humans BA28 - Requirements Analysis and Use Cases training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the BA28 - Requirements Analysis and Use Cases course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Getting Started With highly experienced tutors guiding the completion of an MBA, this programme fosters personal and managerial development, encouraging students to make unique contributions. The MBA programme has earned an excellent reputation among employers in private, public and voluntary sectors, enabling graduates to pursue senior positions within organisations or even continue their academic journey with a Doctor of Business Administration (DBA) degree. For those seeking to specialise, the Research Specialisation Certificate is an optional add-on, allowing students to choose a management area of interest, such as finance, marketing, human resources, or operations and conduct in-depth research. Successful completion of the MBA Dissertation module earns students this exclusive certificate, recognised by the University and emphasises their commitment to academic research and specialised knowledge. The programme comprises two phases; the first is the Qualifi Level 7 Diploma in Strategic Management and Leadership, awarded by Qualifi and delivered by the School of Business and Technology London. The second phase is the MBA Top Up, awarded and delivered by the University of Central Lancashire through distance learning. This programme offers the same high-quality education as its on-campus counterparts, with access to video lectures, interactive assessments and online discussion forums. Students also benefit from comprehensive support services, including academic and technical assistance and access to online resources. School of Business and Technology London partners with Chestnut Education Group to promote this programme.  About Awarding Body Founded in 1828, the University of Central Lancashire is a public university based in Preston, Lancashire, England. Today, UCLAN is one of the largest in the United Kingdom, with a student and staff community of nearly 38,000. At present, the University has academic partners in all regions of the globe, and it is on a world stage that the first-class quality of its education was first recognised. In 2010, UCLAN became the first UK modern Higher Education institution to appear in the QS World University Rankings. In 2018, the Centre for World University Rankings estimated Central Lancashire to be in the top 3.7 per cent of all global universities, highlighting the growth the University has made in offering students real-world learning experiences and reflecting the University's extensive pool of academic talent. Ranked in the top 7% of universities worldwide. Student Communities from more than 100 countries WES Recognised Qualifi is a UK Government (Ofqual.gov.uk) regulated awarding organisation and has developed a reputation for supporting relevant skills in a range of job roles and industries, including Leadership, Enterprise and Management, Hospitality and catering, Health and Social Care, Business Process Outsourcing and Public Services. Qualifi is also a signatory to BIS international commitments of quality. The following are the key facts about Qualifi. Regulated by Ofqual.gov.uk World Education Services (WES) Recognised Assessment Assignments and Project No examinations Entry Requirements Applicants should normally have a good first degree or equivalent and be working in or have recently worked within business management area. If English is not your first language, you will be expected to demonstrate a certificated level of proficiency of at least IELTS 6.5 (Academic level) or equivalent English Language qualification. Progression An MBA graduate can pursue a fruitful career in many industries. MBA can open career opportunities in various sectors such as banking and financial services, investment banking, management consulting, insurance, hospitality, media, information technology (IT) and marketing. An MBA is often a pathway to promotion or a career change as you will gain a professional reputation and develop essential skills in the sector you choose to pursue. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. Structure Phase 1 - Qualifi Level 7 Diploma in Strategic Management and Leadership Programme Structure To attain 120 credits, learners must complete the six compulsory units and select at least two optional units. Mandatory Units Unit 702: Manage Team Performance to Support Strategy Unit code: Y/506/9067 TQT : 150 Credit: 15 This unit's objective is to enable learners to delve into the evaluation and enhancement of team performance to achieve strategic goals. Additionally, learners will be introduced to various management models, concepts, and ideas that can assist in establishing objectives for departments, projects, teams, and individual performance. Unit 704: Information Management and Strategic Decision Taking Unit code: H/506/9068 TQT : 150 Credit: 15 This unit aims to tackle the abundance and intricacy of data and information accessible to organisations and to teach how to analyse, apply, and ascertain its value in shaping strategic decisions. Unit 705: Leading a Strategic Management Project Unit code: L/506/9065 TQT : 150 Credit: 15 This unit will engage the learner in crafting research and methodologies to bolster a strategic management project. They will need to assess options and data sources critically before presenting the outcomes of the project. Unit 706: Strategic Direction Unit code: D/506/9068 TQT : 150 Credit: 15 The purpose of this unit is to delve into the strategic aims and objectives of an organisation and to understand their importance in defining direction, as well as gauging success and progress for the organisation. Additionally, the unit will examine how various strategic options may lead the organisation to alter its course. Unit 711: Strategic Planning Unit code: Y/506/9070 TQT : 150 Credit: 15 This unit focuses on the significance of the strategic planning process in crafting suitable strategies and creating a plan that garners support from stakeholders and other organizational leaders. Learners will also engage in a critical evaluation of the program and its subsequent success. Unit 724: Development as a Strategic Manager Unit code: J/506/9064 TQT : 150 Credit: 15 This unit aims to foster organizational and self-awareness in learners. It lays the groundwork for a self-critical and reflective approach to personal development, which is essential when operating strategically. Additionally, it considers broader contextual factors within the organization and the environment, recognizing their role in contributing to the overall strategic success of both the individual and the organization.   Optional Units Unit 703: Finance for Managers Unit code: D/506/9071 TQT : 150 Credit: 15 The purpose of this unit is to assist learners in comprehending and applying financial information and data. This unit holds significance for learners as it aids in making informed financial decisions. Unit 708: Strategic Marketing Unit code: M/506/9074 TQT : 150 Credit: 15 This unit will explore the foundational models, techniques, and theories that form the basis of marketing and can contribute to achieving strategic objectives. It will also give learners a critical comprehension of the marketing function within intricate organizations. Unit 710: Organisational Change Strategies Unit code: K/506/9073 TQT : 150 Credit: 15 The primary objective of this unit is to equip learners with the knowledge and skills to understand, plan, and execute organizational change effectively. While prevailing wisdom in the business world often emphasizes the need for fast, large-scale, and transformative change for corporate survival, there is evidence to suggest that many successful organizations adopt a slower and more cautious approach. Moreover, change initiatives have a reported failure rate of around 70%. This underscores the complexity of managing organizational change, making it a critical skill for successful leaders and organizations. This unit will scrutinize the evolving nature of organizations and the associated challenges they encounter. It will explore the key approaches to change management and demonstrate how these align with the various types of changes organizations undergo, particularly concerning individual, group, and organizational behaviour. Unit 712: Human Resource Planning Unit code: H/506/9072 TQT : 150 Credit: 15 This unit will cover key considerations in planning for and acquiring a workforce capable of achieving strategic objectives. It will also examine the limitations and external factors that impact an organization's HR practices.   Phase 2 - MBA Top-Up Programme Structure Dissertation Module Delivery Methods The programme comprises two phases; the first is the Level 7 Diploma in Strategic Management and Leadership awarded by Qualifi and delivered by the School of Business and Technology London. The School of Business and Technology London offers flexible learning methods, including online and blended learning, allowing students to choose the mode of study that suits their preferences and schedules. The programme is self-paced and facilitated through an advanced Learning Management System. Students can easily interact with tutors through the SBTL Support Desk Portal System for course material discussions, guidance, assistance, and assessment feedback on assignments. School of Business and Technology London provides exceptional support and infrastructure for online and blended learning. Students benefit from dedicated tutors who guide and support them throughout their learning journey, ensuring a high level of assistance. The second phase is the MBA Top Up, awarded and delivered by the University of Central Lancashire through distance learning. The University of Central Lancashire (UCLan) offers a range of distance learning options for students who require the flexibility to study remotely. These options include online courses, blended learning, and supported distance learning. UCLan's distance learning courses are designed to provide students with the same high-quality education as on-campus courses, with access to resources such as video lectures, online discussion forums, and interactive assessments. The University also provides a range of support services for distance learning students, including academic support, technical support, and access to the University's library and online resources. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

Delve into the intricate world of developmental understanding with the Child Psychology course, a comprehensive programme designed to equip learners with the skills and knowledge to support and understand the psychological development of children. The curriculum embarks with a broad overview of child psychology and child care, laying a strong foundation in ADHD awareness and Applied Behavioural Analysis (ABA). Through an analytical approach, the programme meticulously dissects components of ABA, teaching strategies to enhance motor, language, cognitive, and visuospatial skills among children with diverse developmental needs. Learning Outcomes Comprehend fundamental concepts of child psychology and their application in childcare. Identify characteristics of ADHD and employ ABA techniques to support children with this condition. Develop tailored strategies to bolster language, motor, cognitive, and visuospatial proficiencies in young learners. Understand and implement intervention strategies for children with Autism Spectrum Disorders and ADHD in educational settings. Master the process of fading support to promote independence in children requiring school shadow support. Why choose this Child Psychology course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Child Psychology Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Child Psychology course for? Individuals aspiring to specialize in child psychology and behavioural therapy. Education professionals seeking effective strategies for inclusive education. Parents and guardians desiring a deeper understanding of child psychological development. Support workers aiming to refine their expertise in school shadow support. Healthcare professionals focusing on developmental and behavioural paediatrics. Career path Child Psychologist - £31,000 to £48,000 Behavioural Therapist - £24,000 to £45,000 Special Educational Needs (SEN) Teacher - £25,000 to £40,000 School Shadow Support Worker - £18,000 to £30,000 Child Care Worker - £15,000 to £25,000 Educational Psychologist - £35,000 to £50,000 Prerequisites This Child Psychology does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Child Psychology was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Child Psychology and Child Care Diploma Introduction to Child Psychology 00:28:00 Attachment and Relationship Building in Childhood 00:31:00 Impacts of Separation and Loss on Attachment 00:27:00 Factors That Influence Development 00:36:00 Cognitive Development 00:25:00 Social and Emotional Development 00:43:00 Personality and Intellectual Development in Children 00:36:00 Stages of Language Development 00:27:00 Problems of Adolescence 00:28:00 Problems of Childhood 00:23:00 Problems of Infancy 00:20:00 Understanding Moral Development 00:18:00 ADHD Awareness Course Module 01: Introduction to ADHD 00:05:00 Module 02: ADHD in Young People and Adults 00:10:00 Module 03: ADHD in Family Settings 00:05:00 Module 04: ADHD in Educational Settings and Parent Training 00:10:00 Module 05: ADHD and Learning Difficulties 00:10:00 Module 06: Cognitive Approaches in ADHD 00:05:00 Module 07: The Organisation of Care for ADHD 00:10:00 Applied Behavioural Analysis (ABA) Introduction to ABA Introduction to ABA 00:13:00 ABA Component Breakdown ABA Component Breakdown 00:09:00 Rules when Applying ABA Rules When Applying ABA 00:10:00 Foundation Techniques of ABA Foundation Techniques of ABA 00:14:00 ABA for Motor Skills ABA for Motor Skills 00:10:00 ABA for Language Skills ABA for Language Skills 00:22:00 ABA for Cognitive Skills ABA for Cognitive Skills 00:21:00 ABA for Visuospatial Skills ABA for Visuospatial Skills 00:22:00 Generalization in ABA Theory Generalization in ABA Theory 00:13:00 Autism Awareness Module 01: Introduction to Autism 00:30:00 Module 02: Causes Of Autism 00:24:00 Module 03: Autistic Behaviours 00:54:00 Module 04: Learning Disability 00:33:00 Module 05: Attention Deficit Hyperactivity Disorder ADHD 00:27:00 Module 06: Tourette's Syndrome 00:39:00 Module 07: Epilepsy 00:30:00 Module 08: Developmental Coordination Disorder DCD 00:27:00 Module 09: Obsessive Compulsive Disorder OCD 00:27:00 Module 10: Other Psychological Issues 00:30:00 Module 11: Understanding And Dealing With Autistic Behaviour 01:00:00 Module 12: Repetitive Behaviour 00:51:00 Module 13: Schooling 00:33:00 Module 14: What should teachers do 00:51:00 Module 15: Socialising And Communication 00:57:00 Module 16: Interventions 00:42:00 Module 17: Government Policies On Autism In England 00:39:00 School Shadow Support Worker Course Introduction to School Shadow Support for Children with Special Needs Introduction 00:05:00 Benefits of Inclusive Education System and the Role of a School Shadow Support Benefits of Inclusive Education System and the Role of a School Shadow Support 00:22:00 Educational and Behavioural Implications of Children with Autism Spectrum, ADHD Educational and Behavioural Implications of Children with Autism Spectrum, ADHD 00:33:00 Intervention Strategies and Best Practices to Manage Behaviour Intervention Strategies and Best Practices to Manage Behaviour 00:16:00 Importance of Fading and Promoting Independence Importance of Fading and Promoting Independence 00:39:00

Delve into the realm of educational support with our Teaching Assistant Complete Course, designed to sculpt novices into paragons of instructional support. This comprehensive program begins by laying the foundational stones of educational theory, inviting participants to explore the intricate tapestry of teaching methodologies. Across the span of this meticulously crafted curriculum, learners will navigate through the multifaceted landscape of special educational needs and disabilities (SEND), gaining insights into the specialized pedagogies that cater to diverse learning requirements. Advance further into the heart of this didactic expedition, where the exploration of specific learning differences such as Autism, ADHD, and Dyslexia awaits. This segment of the course meticulously deconstructs the challenges and potentials within these areas, empowering aspiring teaching assistants with the knowledge and empathy required to champion the learning journey of every pupil. The final modules are dedicated to refining the approaches and strategies necessary for nurturing an inclusive and supportive educational environment. Learning Outcomes Grasp the essentials of educational support structures. Explore a series of progressive teaching methodologies. Develop strategies to support students with SEND. Understand the educational impact of Autism, ADHD, and Dyslexia. Cultivate an inclusive approach to teaching diverse learners. Why choose this Teaching Assistant Complete Course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Teaching Assistant Complete Course for? Individuals seeking to embark on a career in educational support. Current teaching assistants wishing to augment their expertise. Educators desiring a deeper understanding of SEND. Professionals transitioning into educational roles. Volunteers within schools aiming to contribute more effectively. Career path Teaching Assistant: £12,000 - £20,000 SEN Teaching Assistant: £15,000 - £22,000 Learning Support Assistant: £12,500 - £19,000 Behaviour Support Coordinator: £17,000 - £23,000 Special Educational Needs Coordinator (SENCO): £23,000 - £42,000 Educational Psychologist: £37,000 - £50,000+ Prerequisites This Teaching Assistant Complete Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Teaching Assistant Complete Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 1: Introduction to Teaching Understanding the Development of Children and Young Person 01:00:00 Communication and Professional Relationships with Pupils and Family 01:00:00 Safeguarding the Welfare of Children and Young Person 01:00:00 Module 02: Teaching Methodologies - Part 1 Education - A Group Enterprise 01:00:00 Traits to Develop 01:00:00 Grow the Attention 01:00:00 Learning Good Habits 01:00:00 Importance of Memory 01:00:00 Module 03: Teaching Methodologies - Part 2 Imagination is Important 01:00:00 Breakdown of Thinking Process 00:30:00 Appreciation - An Aesthetic Emotion 00:30:00 Learning Reflexive Activities 01:00:00 Differing Individuals 00:30:00 Module 04: Teaching Methodologies - Part 3 Morality Matters 01:00:00 Different Learning Methods 01:00:00 Different Psychological Exercises 01:00:00 Problems, Situations & Solutions 01:00:00 Measuring the Achievements 01:00:00 Module 05: SEND Teaching Introduction to Special Educational Needs (SEN) 00:30:00 Understand Constructivism in the Classroom and Know Your Role as a Teacher 01:00:00 SEN Code of Practice 01:00:00 Get an Understanding on SENCO 01:00:00 Classroom Management Strategies for Children with Special Needs 01:00:00 Physical Difficulties, Sensory Difficulties, Cognitive Impairments of Pupils 01:00:00 How to Deal with Pupils with Autism 00:30:00 Understanding Learning Difficulties 01:00:00 Anger Management Methods for Pupils With Special Needs 00:30:00 Teaching Children with Down Syndrome 00:30:00 Conclusion SEN 00:30:00 Module 06: Autism Introduction to Autism 00:20:00 Causes and Diagnosis of Autism 00:45:00 Other Conditions Associated with ASD 01:00:00 In-depth Understanding and Dealing with Autistic Behaviour 01:00:00 Socialising and Communication 00:45:00 Choosing Schools 00:45:00 What Should Teachers Do? 00:30:00 Sex Education and Puberty 00:30:00 Interventions: Treatments and Therapies for Autism 00:45:00 Government policies on autism in England 00:30:00 Module 07: ADHD What is ADHD? 00:30:00 Causes of ADHD 00:30:00 Diagnosing ADHD 00:30:00 Treating ADHD 00:30:00 ADHD and Education 00:30:00 Reasonable Adjustments: ADHD 01:00:00 Adults with ADHD 00:30:00 Module 08: Dyslexia What is Dyslexia? 01:00:00 Identifying Dyslexia 00:30:00 Co-occurring Conditions 00:30:00 Diagnosing Dyslexia 00:30:00 Creating Dyslexia Friendly Environment 00:30:00 Solutions for Dyslexia 00:30:00 Mock Exam Mock Exam- Teaching Assistant Complete Course 00:20:00 Final Exam Final Exam- Teaching Assistant Complete Course 00:20:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Legal Secretary and Office Skills Diploma Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Legal Secretary and Office Skills Diploma Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Legal Secretary and Office Skills Diploma Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Legal Secretary and Office Skills Diploma Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Legal Secretary and Office Skills Diploma? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Legal Secretary and Office Skills Diploma there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Legal Secretary and Office Skills Diploma course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Legal Secretary and Office Skills Diploma does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Legal Secretary and Office Skills Diploma was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Legal Secretary and Office Skills Diploma is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Legal Secretary Module 01: Introduction to Legal Secretary 00:25:00 Module 02: English Law & Legal Systems 00:35:00 Module 03: The Legal Workplace & Professionals 00:47:00 Module 04: Law of Contract & Law of Tort 00:31:00 Module 05: Wills, Probate and Estate Law Practice 00:17:00 Module 06: Property Law & Conveyancing Practice 00:21:00 Module 07: Family Law and Insurance Practice 00:26:00 Module 08: Professional Writings and Documents 00:30:00 Module 09: Document Proofreading and Editing 00:07:00 Module 10: Meeting Management & Minute Taking 01:09:00 Module 11: Customer Service and Telephone Handling Skills 00:23:00 Module 12: Data Management and Record-Keeping 00:16:00 Module 14: Other Essential Skills for Secretarial Role 00:22:00 Module 15: Professional Conduct and Ethics 00:24:00 Microsoft Word Essentials New Word Document and Templates 00:02:00 Tabs, Ribbons and Groups 00:03:00 Zoom and Rulers in Word 00:02:00 Editing the Word Document 00:03:00 Insert Pictures with Word 00:05:00 Insert Shape and Text Box in Word 00:02:00 Review Tab in Word 00:03:00 Layout in Word 00:02:00 File Options in Word 00:02:00 Closing and Reopening in Word 00:01:00 Microsoft PowerPoint Essentials New PowerPoint Presentation and Templates 00:02:00 Tabs Ribbons and Groups in PowerPoint 00:03:00 First Slide and Designing the Slide 00:02:00 Home Tab and Updates in PowerPoint 00:02:00 Buttons in PowerPoint 00:01:00 Inserting Pictures in PowerPoint 00:04:00 Presentation Mode 00:01:00 Animations Tab 00:05:00 File Options in Word 00:02:00 Closing and Reopening in Word 00:01:00 Microsoft Outlook Essentials Setting Up Outlook with Accounts 00:03:00 Tabs, Ribbons and Groups in Outlook 00:03:00 Navigation Bar in Outlook 00:01:00 Organizing Outlook with Favorites and Folders 00:03:00 Additional Options inside Outlook Tabs 00:01:00 Reading, Writing and Receiving Emails 00:08:00 Attaching Items in Outlook Mails 00:03:00 The View Tab in Outlook 00:02:00 Create a Rule to move emails to a folder 00:04:00 Insert a screen shot from Excel 00:02:00 Microsoft Excel - Top 50 Keyboard Shortcuts Formatting Excel Keyboard Shortcuts 00:02:00 Table Excel Keyboard Shortcuts 00:02:00 Editing Excel Keyboard Shortcuts 00:05:00 Formula Excel Keyboard Shortcuts 00:03:00 Workbook Excel Keyboard Shortcuts 00:02:00 Handy Excel Shortcuts Keyboard Shortcuts 00:05:00 Assignment Assignment - Legal Secretary and Office Skills Diploma 01:00:00

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type