1489 Courses delivered Live Online

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

This one-day workshop is designed to give participants an understanding of the fundamentals of Microsoft Word and its commands, with quick ways to enter text, control formatting and edit paragraphs. This course will help participants: Create, manage and save documents, files and folders Create paragraph lists, bulleted and numbered paragraphs Edit, modify and format paragraphs Create and format tables Use shortcuts to navigate documents Format the layout of documents Manage page headers and footers Insert and managing pictures and diagrams within a document Learn time saving tips and tricks to obtain a professional finish to documents Use printing options 1 Creating documents Getting help Creating and saving documents Accessing recently used documents Managing files and folders 2 Entering and editing text Inserting and editing paragraph text Cutting, copying and pasting text Using tool tips to manage content Applying and removing text formatting Correcting spelling and grammar 3 Creating paragraph lists Creating bulleted paragraphs Creating numbered paragraphs Managing bulleted and numbered lists 4 Modifying paragraphs Changing paragraph alignment Indenting a paragraph Adding borders and shading to paragraphs Formatting paragraphs using styles 5 Navigating documents Using shortcuts for navigating documents Using 'Go To' to navigate documents Finding and replacing text Changing to read view 6 Document layout Inserting page breaks Changing page orientation Adjusting page margins Adding borders to pages 7 Page headers and footers Inserting page headers and footers Using header and footer commands Inserting page numbers Using different first page 8 Inserting pictures and diagrams Inserting pictures from your computer Inserting online pictures Flowing text around a picture Changing a picture Inserting SmartArt diagrams Entering text into SmartArt 9 Inserting tables Using tabs to create tables Resizing and repositioning tables Inserting and deleting rows and columns Using a table's commands Changing a tables text direction Formatting tables 10 Printing documents Previewing and printing documents Using the printing tools Printing parts of a document

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

See how the NADIS parasite and vaccination planners can help you deliver the Animal Health and Welfare Pathway for flocks and herds under your care

Getting Started This course is designed for those learners who have completed or are planning to pursue their CMI Level 7 Diploma in Strategic Management and Leadership and wish to proceed with an MBA at Anglia Ruskin University. Since there is no direct pathway to Anglia Ruskin University's MBA Top Up program after the CMI Level 7 Diploma in Strategic Management and Leadership, we have introduced a Bridge module (Strategic Leadership and Organisational Transformation), which will be delivered at the School of Business and Technology London. The programme CMI Level 7 Diploma in Strategic Management and Leadership and the Bridge Module are delivered by the School of Business and Technology. The MBA Top Up is delivered and awarded online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, PC or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. The duration of the whole program is 12-15 months. School of Business and Technology London partners with Chestnut Education Group to promote this programme. How it works? Once a learner successfully completes CMI Level 7 Management and Leadership and the Bridge Module - Strategic Leadership and Organisational Transformation, we will transfer the credits to Qualifi, an ofqual.gov.uk regulated awarding body for the programme Qualifi Level 7 Strategic Management and Leadership. Upon credit transfer, learners will receive a certificate and transcript from Qualifi for Level 7 Diploma in Strategic Management and Leadership with 120 credits, which will be used as a pathway for MBA Top Up. Key Benefits The qualification aims to improve your strategic management skills and techniques. The knowledge gained through the qualification will assist you in your role as a strategic manager in your workplace. You will be enabled to apply theories and models in your practical work scenarios, enhancing your problem-solving skills that can be applied to your working environment. It is a nationally accredited qualification, and the credits gained through this course can be transferred to other universities or other awarding bodies. You will be able to manage problems in your workplace more effectively, boosting the career prospectus. About Awarding Body Chartered Management Institute established over 60 years ago as the British Institute of Management back then; it has developed the UK's very first diploma in management studies. In the years that followed CMI has consistently been at the forefront of all aspects of management and leadership. Today CMI is the only chartered professional awarding body committed to offering the highest standards in management and leadership excellence. Presently over 100,000 managers use its unique services daily. CMI qualifications aim for managers and leaders at any level, and it remains the only Awarding Body which can award Chartered Manager status - the ultimate management accolade. Employers highly value the qualifications awarded by CMI, and boost your career prospects. Anglia Ruskin University began in 1858 as the Cambridge School of Art founded by William Beaumont. It was then merged with the Cambridge shire College of Arts and Technology and the Essex Institute of Higher Education and was renamed Anglia Polytechnic. It was then given university status in 1992 and renamed Anglia Ruskin University in 2005. The university has campuses in the UK (Cambridge, Chelmsford, London and Peterborough), as well as they are partnered with institutions around the world including Berlin, Budapest, Trinidad, Singapore and Kuala Lumpur. Entry Requirements Learners from age 21 and over. The learners should possess 3 Years of middle management experience or two years of senior management experience. The learner should have the ability to complete the Level 7 Qualification 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 Stage 1 - CMI Level 7 Diploma in Strategic Management and Leadership This is the first stage of this whole program. CMI Diploma qualification is designed for individuals wishing to develop strategic management and leadership practices who will have the knowledge, skills and behaviours to drive business activities in a senior, regional, specialist, director or CEO management and leadership role. The qualification contains a breadth of units, which reflect the tasks and activities required by managers in roles such as senior managers, regional management and specialist managers who are accountable to a senior manager or business owner. The CMI Level 7 Diploma in Strategic Management and Leadership is delivered by School of Business and Technology London and awarded by CMI.  The qualifications have been designed for practising or aspiring managers in roles such as: Senior Manager Regional Manager Specialist Manager (with expertise in a specific business or technical function such as quality, finance, risk, marketing, sales IT, human resources etc.) Director CEO Module Structure UNIT1- Strategic Risk Management This unit aims for leaders to develop an in-depth understanding of strategic risk management. Leaders will critically appraise strategic risk within an organisational context. They will assess strategies for risk management and the leadership skills to lead risk initiatives successfully. Ultimately, leaders will be allowed to develop a framework to deliver a risk strategy in an organisational context. UNIT2- Strategic Leadership This unit aims to equip leaders with an in-depth understanding of strategic leadership within an organisational context. Leaders will explore the complexities of the role and the theoretical perspectives, approaches, behaviours and skills which can enhance their professional practice. The unit focuses on the leader's ability to respond creatively to complex organisational challenges and understand how to set and deliver sustainable strategic goals. UNIT3- Collaboration and Partnerships The unit aims for leaders to understand collaborative and partnership arrangements. Leaders will critically assess the scope and value of these and evaluate the impact of organisational and legal frameworks on how these arrangements are delivered. The unit culminates in the requirement for the leader to present a rationale for collaboration or partnerships to further an organisation's success. UNIT4- Developing Organisational Strategy The aim of this unit is to enable leaders to know how to develop and influence an organisation's strategic direction through the development of a meaningful strategy. To support this outcome, leaders will critique the factors driving organisational strategy development and appraise approaches to successfully develop strategy. The unit culminates in leaders developing an organisational strategy to achieve a business goal. To complement this activity, leaders will propose an approach to implement and monitor the strategy developed to ensure its sustained success. UNIT5- Entrepreneurial Practice This unit aims to enable leaders to explore the principles of entrepreneurial practice, understand the different contexts in which entrepreneurship can flourish, and the characteristics of entrepreneurial leadership. Assessment Learners are required to submit time-constrained, scenario-based assignments for each unit of the level 7 diploma. There will not be any examinations.   Stage 2 - Bridge Module - Strategic Leadership and Organisational Transformation Now the second stage is to complete the Bridge Module. This module is about leadership at strategic level and the role of transformational leaders as catalysts for change in their organisations and whole industries. The module, therefore, focuses on two but clearly intertwined elements of strategic leadership and organisational transformation. Effective strategic leadership is a facilitator for organisational success. Leaders have to be knowledgeable, creative, agile and resilient to respond to organisational need in the contemporary workplace. This unit aims to equip leaders with an in-depth understanding of strategic leadership within an organisational context. Leaders will explore the complexities of the role and the theoretical perspectives, approaches, behaviours and skills which can enhance their professional practice. The unit focuses on the leader's ability to respond creatively to complex organisational challenges and understand how to set and deliver sustainable strategic goals. By studying this module, you should better understand their own leadership, or of the leadership in places of work and the changes that could take place to create a more effective leadership. Aim of the Unit Students are expected to develop many management/leadership skills that can be transferrable for use in other modules on the course and are essential in the workplace. Students are advised to refer to some leadership theories, which enables them to undertake the tasks given throughout the module. The notes formulated in response to these tasks will lead to you gaining formative feedback for your individual development.   Assessment As an individual, you will electronically submit a 5000-word assignment, which consists of a two-part report comprising of (i) a critical review of academic material (2,500 words) and (ii) a critical appraisal, evaluation and justification of change within an International organisation (2,500 words).   Stage 3 - MBA - Top Up The final stage is enrolling for the Top Up programme delivered online by Anglia Ruskin University. This professional qualification improves the chances of progression in a career path. This qualification helps the learner to oversee, supervise and allocate the operations in a business firm. The program aims to make the candidate capable of understanding the functional aspects of a company and acquiring the skills for communication and decision making. This programme from the renowned UK university is well acknowledged and globally respected as it dominates critical thinking and research. MBA can also help you specialise in a new industry you want to move to or in your current sector. Assessment The course requires you to submit a final Consultancy Project Report, which is treated as an assessment and would be scrutinised and reviewed by the verifiers externally. Delivery Methods The program comprises three stages; the first is Stage 1 - CMI Level 7 Diploma in Strategic Management and Leadership awarded by CMI and delivered by School of Business and Technology London. The second stage is the Bridge Module - Strategic Leadership and Organisational Transformation delivered by 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 program 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 third stage is the MBA Top Up, delivered and awarded online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, PC or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. School of Business and Technology London partners with Chestnut Education Group to promote this programme. 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.

This Tableau Desktop Training intermediate course is designed for the professional who has a solid foundation with Tableau and is looking to take it to the next level. For Private options, online or in-person, please send us details of your requirements: This Tableau Desktop training intermediate course is designed for the professional who has a solid foundation with Tableau and is looking to take it to the next level. Attendees should have a good understanding of the fundamental concepts of building Tableau worksheets and dashboards typically achieved from having attended our Tableau Desktop Foundation Course. At the end of this course you will be able to communicate insights more effectively, enabling your organisation to make better decisions, quickly. The Tableau Desktop Analyst training course is aimed at people who are used to working with MS Excel or other Business Intelligence tools and who have preferably been using Tableau already for basic reporting. The course is split into 3 phases and 9 modules: Phase 1: AMPLIFY MODULE 1: CHECK ABILITIES Revision – What I Should Know What is possibleHow does Tableau deal with dataKnow your way aroundHow do we format chartsHow Tableau deals with datesCharts that compare multiple measuresCreating Tables MODULE 2: COMBINE DATA Relationships Joining Tables – Join Types, Joining tables within the same database, cross database joins, join calculations Blending – How to create a blend with common fields, Custom defined Field relationships and mismatched element names, Calculated fields in blended data sources Unions – Manual Unions and mismatched columns, Wildcard unions Data Extracts – Creating & Editing Data extracts MODULE 3: ADVANCED CALCULATIONS Row Level v Aggregations Aggregating dimensions in calculations Changing the Level of Detail (LOD) of calculations – What, Why, How Adding Table Calculations Phase 2: ANALYSE MODULE 4: EXPAND APPLICATION Making things dynamic with parameters Sets Trend Lines How do we format charts Forecasting MODULE 5: ADVANCED MAPPING Using your own images for spatial analysis Mapping with Spatial files MODULE 6: DATA COMPARISONS Advanced Charts Bar in Bar charts Bullet graphs Creating Bins and Histograms Creating a Box & Whisker plot Phase 3: ACT MODULE 7: ADVANCED DASHBOARDS Using the dashboard interface and Device layout Dashboard Actions and Viz In tooltips Horizontal & Vertical containers Navigate between dashboards MODULE 8: PRESENT STORIES Telling data driven stories MODULE 9: ENABLE DECISIONS What is Tableau Server Publishing & Permissions How can your users engage with content This training course includes over 25 hands-on exercises and quizzes to help participants “learn by doing” and to assist group discussions around real-life use cases. Each attendee receives a login to our extensive training portal which covers the theory, practical applications and use cases, exercises, solutions and quizzes in both written and video format. Students must bring their own laptop with an active version of Tableau Desktop 2018.2 (or later) pre-installed. What People Are Saying About This Course “Course was fantastic, and completely relevant to the work I am doing with Tableau. I particularly liked Steve’s method of teaching and how he applied the course material to ‘real-life’ use-cases.”Richard W., Dashboard Consulting Ltd “This course was extremely useful and excellent value. It helped me formalise my learning and I have taken a lot of useful tips away which will help me in everyday work.” Lauren M., Baillie Gifford “I would definitely recommend taking this course if you have a working knowledge of Tableau. Even the little tips Steve explains will make using Tableau a lot easier. Looking forward to putting what I’ve learned into practice.”Aron F., Grove & Dean “Steve is an excellent teacher and has a vast knowledge of Tableau. I learned a huge amount over the two days that I can immediately apply at work.”John B., Mporium “Steve not only provided a comprehensive explanation of the content of the course, but also allowed time for discussing particular business issues that participants may be facing. That was really useful as part of my learning process.”Juan C., Financial Conduct Authority “Course was fantastic, and completely relevant to the work I am doing with Tableau. I particularly liked Steve’s method of teaching and how he applied the course material to ‘real-life’ use-cases.”Richard W., Dashboard Consulting Ltd “This course was extremely useful and excellent value. It helped me formalise my learning and I have taken a lot of useful tips away which will help me in everyday work.” Lauren M., Baillie Gifford “I would definitely recommend taking this course if you have a working knowledge of Tableau. Even the little tips Steve explains will make using Tableau a lot easier. Looking forward to putting what I’ve learned into practice.”Aron F., Grove & Dean “Steve is an excellent teacher and has a vast knowledge of Tableau. I learned a huge amount over the two days that I can immediately apply at work.”John B., Mporium

Getting Started The BSc in Early Childhood Studies programme provides a comprehensive education on child development, education, and care. It equips students with the knowledge and skills necessary to work effectively with young children and their families in various educational and childcare settings. This programme establishes a strong foundation for early childhood education and advocacy careers. The BSc (Hons) Early Childhood Studies programme delivers a dynamic educational experience for students aspiring to engage in early childhood education and development. This undergraduate degree programme strongly emphasises comprehending the critical stages of early childhood, spanning from infancy to primary school age. It delves into the multitude of factors that influence a child's growth and learning. Throughout the programme, students are exposed to a wide array of topics, including child psychology, early education pedagogy, child health and well-being, and the socio-cultural influences on early childhood development. The curriculum is thoughtfully crafted to nurture a deep understanding of the unique needs and challenges faced by young children and their families, equipping graduates with the knowledge and skills necessary to impact the field positively. Anglia Ruskin University's BSc (Hons) Early Childhood Studies programme offers a supportive learning environment with experienced faculty and access to cutting-edge research. Graduates from this programme are well-prepared for a diverse range of career opportunities in early childhood education, social services, child advocacy, and more. It serves as a solid foundation for individuals passionate about nurturing and shaping the future of our youngest learners. The programme comprises two phases; the first is the Qualifi Level 4 and 5 Diploma in Early Learning and Childcare, awarded by Qualifi and delivered by the School of Business and Technology London. The second phase is the BSc (Hons) in Early Childhood Studies Top Up, awarded and delivered 100% online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, pc or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. School of Business and Technology London partners with Chestnut Education Group to promote this programme. About Awarding Body Anglia Ruskin University began in 1858 as the Cambridge School of Art founded by William Beaumont. It was then merged with the Cambridge shire College of Arts and Technology and the Essex Institute of Higher Education and was renamed Anglia Polytechnic. It was then given university status in 1992 and renamed Anglia Ruskin University in 2005. The university has campuses in the UK (Cambridge, Chelmsford, London and Peterborough), as well as they are partnered with institutions around the world including Berlin, Budapest, Trinidad, Singapore and Kuala Lumpur. Assessment Assignments and Project No examinations Entry Requirements A Level or Equivalent Minimum 1 Year of experience in Early Learning and Childcare. Further, candidates are also required to demonstrate their English language proficiency. 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 4 and 5 Diploma in Early Learning and Childcare Programme structure Level 4 The Qualifi Level 4 Diploma in Early Learning and Childcare comprises 9 units. To obtain the Diploma, learners must complete all mandatory units, earning 34 credits. Additionally, they should select at least 6 credits from the optional units. A total of 40 credits is necessary for Diploma completion, along with at least 30 hours of teaching practice. Mandatory units:  Child development and enabling children to learn Reference No: J/650/0974 Credit: 9 || TQT: 90 This unit aims to equip learners with a comprehensive understanding of diverse early years pedagogical approaches influencing holistic learning in babies and children aged from birth to five years. It delves into local statutory planning and monitoring requisites. Learners will also explore leadership, mentoring, and managerial skills. The unit emphasises comprehending how babies and young children learn and translating theory into practical application. Additionally, it examines developmental disparities, the potential for developmental delays, the impacts of transitions, and how children learn in various environments. It empowers learners with proficiency in utilising observation, Assessment, and planning to foster children's development. To demonstrate their assimilated knowledge, learners must integrate it into their day-to-day responsibilities with children aged from birth to five years and document practice modifications in their setting via a portfolio. Physical activity and nutrition co-ordination (PANCo) in early years Reference No: K/650/0975 Credit: 6 || TQT: 60  In this unit, learners will grasp the advantages of physical activity and the significance of a balanced diet for the health and well-being of babies, children, and their families. They should consider statutory framework mandates and national, local, and international initiatives, advice, and perspectives relevant to health and well-being.  Supporting children with additional needs Reference No: J/650/0992 Credit: 4 || TQT: 40 This unit endeavours to enhance the leadership and management capabilities of the Special Educational Needs Coordinator (SENCO) in effectively guiding best practices for children with Special Educational Needs and Disabilities (SEND) and their families. Partnership working in early years settings Reference No: L/650/0976 Credit: 6 || TQT: 60 This unit seeks to assist learners in comprehending the legal obligations associated with collaborating with families. It emphasises the positive impact of effective partnerships with other professionals on the well-being and development of babies and children. Learners will also delve into the varied needs of families and strategise ways to surmount potential obstacles to successful partnership working. Implementing and evaluating change through a research project Reference No: M/650/0977 Credit: 6 || TQT: 60 This unit mandates learners to devise, execute, and assess change about a chosen theme, accomplished through a modest research endeavour. Learners will also grasp the ethical considerations integral to research. The chosen theme, subject to agreement with the assessor, enables learners to introspect on their practices, employ current research to propose enhancements within their setting, put these proposals into action, and report on their outcomes. Legal requirements in Childcare Reference No: R/650/0978 Credit: 3 || TQT: 30 This unit encompasses the necessary knowledge and understanding regarding health and safety, equality and inclusion, the Welfare Requirements of the Early Years Foundation Stage, Employment Rights, and Special Educational Needs, including Looked Children. It also addresses the preparations for Ofsted inspections, the formulation of policies and procedures, and the utilisation of information to oversee the quality of the setting's practices. Optional Units Assessing and planning for children's changing developmental needs Reference No: T/650/0979 Credit: 6 || TQT: 60 This unit's objective is to equip learners with the knowledge, comprehension, and skills required to conduct observations for assessing and planning for children's evolving developmental needs over an extended duration, commonly referred to as a longitudinal study. The study is to be conducted over six months. Caring for babies Reference No: D/650/0980 Credit: 6 || TQT: 60 This unit fosters the knowledge, understanding, and skills necessary to care for infants aged 0-18 months. Caring for children through play out of school Reference No: F/650/0981 Credit: 6 || TQT: 60 This unit aims to cultivate the knowledge, understanding, and skills required to provide care for children and young people outside of regular school hours and during school holidays. Level 5 The Qualifi Level 5 Diploma in Early Learning and Childcare comprises 10 units. To attain the diploma, learners must finish all mandatory units for 96 credits. Additionally, they must select a minimum of 24 credits from optional units. In total, a minimum of 120 credits must be achieved, along with 100 hours of teaching practice. Mandatory units: Management of children's care Reference No: H/650/0982 Credit: 20 || TQT: 200 This unit aims to provide learners comprehensive knowledge and comprehension of theories, principles, and models pertinent to early learning and childcare. Learners will apply these concepts, deepening their grasp of communication and Assessment in this context. The unit will additionally encompass the utilisation of theories and models for specialised curriculum development and the application of theories and models for reflective practice. Children's well-being and resilience Reference No: J/650/0983 Credit: 26 || TQT: 260  This unit strives to equip learners with the knowledge, understanding, and skills essential for comprehending and nurturing children's well-being and resilience. This encompasses appreciating each child as an individual and ensuring inclusive treatment for all. Positive behaviour in early years Reference No: K/650/0984 Credit: 20 || TQT: 200 This unit's objective is to give learners the necessary knowledge, understanding, and skills for formulating and executing strategies and policies to promote positive behaviour in children. Child development and communication skills in early years Reference No: L/650/0985 Credit: 30 || TQT: 300 This unit aims to enhance learners' comprehension of the anticipated trajectory of children's development and the factors that impact it. Specifically, it seeks to deepen learners' understanding of how children's communication skills progress from birth to 7 years old.   OPTIONAL UNITS Managing children's holistic development in early years Reference No: M/650/0986 Credit: 16 || TQT: 160 The goal of this unit is to enable learners to effectively strategise and oversee the comprehensive development of children, tailored to their specific requirements. Learners will assess strategies for enhancing literacy and numeracy and implement theoretical approaches in their professional practice. Developing children's literacy skills Reference No: R/650/0987 Credit: 16 || TQT: 160 This unit aims to empower learners to foster children's literacy skills. Developing children's mathematical skills Reference No: T/650/0988 Credit: 8 || TQT: 80 This unit aims to enable learners to enhance children's mathematical skills. Safeguarding in early years Reference No: Y/650/0989 Credit: 16 || TQT: 160 This unit aims to cultivate learners' comprehension of the role and extent of safeguarding in early years education and the policies and procedures for enacting safeguarding protocols. Health and safety in the early years Reference No: F/650/0990 Credit: 8 || TQT: 80 This unit aims to foster learners' knowledge and comprehension of the early years education's pertinent health and safety prerequisites. It further aims to equip them with the capability to implement policies and processes related to health and safety. Special Educational Needs and Disability (SEND) in early years Reference No: H/650/0991 Credit: 8 || TQT: 80 This unit seeks to enhance the learner's knowledge and comprehension of the legislation about children with Special Educational Needs and Disabilities (SEND) and the measures in place to address additional needs in early years education.   Phase 2 - BSc (Hons) in Early Childhood Studies Programme structure Early Childhood Leadership and Management Children's Rights Interdisciplinary Perspectives Leading Change in Early Childhood Contexts Early Childhood Graduate Competencies Undergraduate Major Project Delivery Methods The programme comprises two phases; the first is the Qualifi Level 4 and 5 Diploma in Early Learning and Childcare, 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 BSc (Hons) in Early Childhood Studies Top Up, awarded and delivered 100% online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, pc or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. School of Business and Technology London partners with Chestnut Education Group to promote this programme. 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.

Nowadays not only do we rely on our commercial and sales staff to hit that bottom line but we expect our engineers and project teams to play their part too - not only through their engineering and management skills but by behaving in a commercially minded way in their dealings with their counterparts in customer or supplier organisations. This means understanding, amongst other things, the issues surrounding the commencement of work ahead of contract, having a clear contract baseline, recognising the broader implications of contract change, the need for timeliness and the consequences of failing to meet the contracted timetable. This practical one-day programme has been designed specifically to give engineers, project staff and others just that understanding. The course is designed principally to provide engineers and project staff with an appreciation of contractual obligations, liabilities, rights and remedies so that they understand the implications of their actions. It is also suitable for business development staff who are negotiating contracts on behalf of the business. The main focus of the day is on creating an awareness of when a situation may have commercial implications that would harm an organisation's business interests if not recognised and handled appropriately and how taking a positive but more commercial approach to those situations can lead to a more positive outcome for the business. As well as providing an understanding of the commercial imperatives the day also focuses on specific areas affecting engineers and project staff, such as the recognition and management of change, the risks when working outside the contract and managing delays in contracts. The course identifies the different remedies that may apply according to the reasons for the delay and provides some thoughts on pushing back should such situations arise. On completion of this programme the participants will: appreciate the need for contractual controls and will have a better understanding of their relevance and how they can be applied, particularly the issues of starting work ahead of contract, implementing changes and inadvertently creating a binding contract by their behaviour; have gained an understanding of the terminology and procedural issues pertaining to contracting within a programme; and be more commercially aware and better equipped for their roles. 1 Basic contract law - bidding and contract formation Purpose of a contract Contract formation - the key elements required to create a legally binding agreement Completeness and enforceability Express and implied terms Conditions v warranties The use of, and issues arising from, standard forms of sale and purchase Use of 'subject to contract' Letters of intent Authority to commit 2 Change management Recognising changes to a contracted requirement Pricing change Implementation and management of change 3 Key contracting terms and conditions By the end of this module participants will be able to identify the key principles associated with: Pricing Getting paid and retaining payment Cashflow Delivery and acceptance Programme delaysExamining some reasons for non-performance...Customer failureContractor's failureNo fault delays ... and the consequences of non-performance: Damages claimsLiquidated damagesForce majeureContinued performance Waiver clauses and recent case law Use of best/reasonable endeavours Contract termination 4 Warranties, indemnities and liability Express and implied warranties Limiting liability 5 Protection of information Forms of intellectual property Background/foreground intellectual property Marking intellectual property Intellectual property rights Copyright Software Confidentiality agreements Internet

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups