287 Logic courses in Nottingham delivered Live Online

Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time. Course overview Duration: 1 day (6.5 hours) Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data. This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending. Objectives By the end of the course you will be able to: Use a range of Text functions to manage text data Create and use different types of date and time functions Work with rounding functions Use logical statements Build nested formula Use SUMIF, COUNTIF and AVERAGEIF Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions Use IS functions and IFERROR to test cell values Content Working with text Splitting text into multiple cells Merging data into one cell Extracting data using text functions Tidying data Working with dates and times Formatting dates and times Date and time functions Calculating date and time differences Using functions to round numbers up and down ROUND ROUNDUP ROUNDDOWN CEILING FLOOR Use lookup functions Lookup functions Creating a lookup table Range naming Using VLOOKUP Using HLOOKUP Using INDEX and MATCH Working with logical statements Creating an IF statement Using the AND plus OR functions Nesting functions Calculating values based on given criteria SUMIF(S) COUNTIF(S) AVERAGEIF(S) Using IS and IFERROR and test cell values ISBLANK ISNUMBER ISTEXT ISERROR IFERROR

Data Data Everywhere – For what purpose? Which data is crucial to driving your organisation? How do we Analyse data to drive improvements? Course Overview Organisations generally collect enormous amounts of data. However, what data or information is really needed? How do we present the data that we have collected so that it is openly available and can be understood and used to drive the business? Is the data collected driving change? Structure of the Course This one-day workshop will enable participants to gain the necessary skills to collect, analyse and present data in an understanding and meaningful way and assist the decision-making process. It looks at how to translate data into useful and meaningful information that can contribute towards real problem solving, effective performance indicators, leading to the development of effective KPI’s, among others. Alternatively, if an organisation is in the process of selecting data collection methods and appropriate analysis, then this workshop will also help. Data analysis skills are essential to providing honest and accurate analysis, determining statistical significance, reliability, and validity on which to base their decisions, whether it is to improve quality, profitability, efficiency, or competitiveness. Improper statistical analyses distort findings and can mislead or negatively influence decision-making and the perception of the data collected. The correct analysis of data is a process of systematically applying statistical and / or logical techniques to describe and illustrate, condense, and recap, and evaluate data so that it can be used effectively. This workshop provides essential learning for staff at all levels of the organisation. Course content: 1. Data Types Discrete data Continuous data 2. Data Collection Sheet design Testing, prior to full-scale data collection 3. Data Input into Spreadsheet 4. Determination of Basic Descriptive Statistics Mean Median Mode Minimum and maximum values Range Standard deviation 5. Graphical Analysis Bar charts Line graphs Pie charts Scatter diagrams 6. Determination of Relationships between Factors Relationship between discrete factors Relationship between continuous factors 7. Use of Data in Decision Making 8. Establishment of Key Performance Indicators 9. Determination of Data Reliability 10. Summary Who would benefit from this Approach? Anyone who collects, manages, analyses and uses data to drive business performance. Delivery The course is delivered through virtual, tutor-led classes as structured above. The platform used is Adobe Connect which utilizes e-work rooms, video and streamed trainers. Cost £200 + VAT If you are not yet a member but are already thinking about joining CforC, you can find more information on how to become a member and the benefits by clicking here.

Live online course with study materials and certificate of completion included Adobe Dreamweaver is an industry leading web design and HTML editor software. First-time Dreamweaver users may feel overwhelmed by the amount of options, panels and menus across the interface, but our Dreamweaver course will quickly familiarise you with the layout giving you access to advanced controls over CSS elements, and the ability to view how a webpage will look when displayed on different size device screens. Our one day Adobe Dreamweaver course will enable you to build and manage professional, well designed and standards compliant websites using the software. HTML and CSS concepts are covered. Description Completing this course will enable you to do the following and more: Become familiar with the Adobe Dreamweaver Interface Understand Site management Create a website Work with multiple pages Use and understand Cascading Style Sheets Work with graphics Create hyperlinks Learn how to best organise pages for logical site structure Use best practice and SEO considerations UCreate and use templates Understanding accessibility For the full course content please download the course information pdf listed above. Who is this course for? This workshop is suitable for anyone with basic PC or Mac skills who wishes to learn how to use Adobe Dreamweaver. No previous knowledge or experience of Dreamweaver is necessary. Requirements Attendees should have basic PC or Mac skills. You will need a broadband internet connection to participate in this live online course. Certificates Certificate of completion Digital certificate - Included

Discover effective new ways to: find out what the problem is, communicate with reluctant teens, discover their hidden strengths, promote positive behaviour change, improve their mental health – and much more… Accredited CPD Certificate: 6 hours Length: 1 day (9.15am - 4.00pm GMT) The best live online I have attended so far and I’ve done eight! Everything was relevant – completely spot onTEACHER / TUTOR Live Online – Join Richard Brook on Tuesday 19th March for this live online training event via Zoom. Simply book your place and we will email you details of how to join the Zoom workshop the day before. BONUS RECORDING – the training is recorded, in case anyone experiences technical difficulties on the day, so you will also get a recording for a limited time afterwards to maximise your learning. Why take this course This live online training event gives you the essential knowledge, tips and practical skills you need to help troubled teenagers unlock their potential and begin to build lives for themselves that work well. Tutor Richard Brook has a wealth of hands-on practical experience in adolescent mental health and social work which he draws on throughout the day – you will have plenty of time to ask questions and discuss how you can implement the skills and techniques in your own work or with the teens you care for.   The programme is varied and intensive, yet lively with a strong focus on gaining skills. It clarifies what healthy teenage development looks like, why things can go wrong and the best ways to help young people overcome obstacles and begin to create lives for themselves that work well. Richard also shows how, by working with the ‘givens’ of human nature, and ensuring that sound knowledge of how people really function is applied intelligently to teenagers, you can speed up progress, reduce anti-social behaviour and teen depression, and bring young people real benefits. At the end of the day you will find yourself more empowered to respond effectively to each individual’s needs and temperament, whilst avoiding yourself the emotional pitfalls of working in stressful situations. Such a realistic and logical approach – it's given me lots of ideas for working with a variety of people, not just teenagers!PROBATION OFFICER What will you learn An increased understanding of what drives most problematic behaviour, including anti-social behaviour Essential knowledge and skills to deliver effective interventions to young people, both individually and in groups A deeper understanding of the causes of adolescent mental health problems Simple yet effective techniques for engaging uncommunicative young people, building rapport and promoting behavioural changes Constructive ways to help prevent teenage depression, anxiety and stress Four vital guiding principles that ensure your work with young people is relevant and effective Ways to motivate young people and help them set achievable goals How to discover and build upon a young person’s strengths and engage them in practical problem-solving Knowledge of how the insights from the human givens approach can dramatically improve interventions and their outcomes The opportunity to discuss how you could implement these in your own work with a highly knowledgeable tutor who has years of hands-on experience Also covered: The common misconceptions about adolescence What healthy teenage development looks like – this may bring you some surprises! A clear and logical foundation upon which to structure creative and effective interventions Ways to respond effectively to each individual’s needs, temperament and learning style How to avoid the emotional pitfalls of working in stressful situations An expanded repertoire of skills and a refined understanding of what works and – most importantly – why Course Programme The ‘How to help troubled and troublesome teenagers’ course starts at 9.15am and runs until 4.00pm. 9.15am Join the Zoom meeting 9.30am What’s the trouble? 11.00am Comfort break and discussion 11.30am How to communicate with teenagers 1.00pm Lunch break 1.45pm Practical problem solving 2.45pm Comfort break and discussion 3.00pm How to help them create a life that works well 4.00pm Day ends This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

Basic Python syntax and principles of Object Orientated Programming. Most attendees are in-work IT Professional. Private individuals are also very welcome. Evening courses also running. Our Style: Hands-on, Practical Location: Online, Instructor-led Download: anaconda.com Duration: 6 weeks, 1 evening per week, 6pm - 8pm Times: arrange a time for your time zone

Course summary This Python Programming course has become essential to all professional who would like to do code using Python. Learn evenings, work while studying. Work and study Python Part Time. It is a Python beginners course and teaches Python coding from scratch to intermediate. Hands-on, practical. We code some real life examples in this course.

GLA Tutors: Empowering Young Minds in Computer Coding At GLA Tutors, we are passionate about equipping children with the essential skills needed to thrive in today's digital world. Our tutoring website offers a comprehensive and engaging learning experience for children who are eager to explore the exciting world of computer coding. With our online tutoring services, we strive to make coding education accessible and convenient for children of all ages. Our team of expert tutors are highly skilled in teaching computer coding concepts in a fun and interactive manner. They have a deep understanding of various programming languages and frameworks, ensuring that students receive top-notch instruction tailored to their individual needs and skill levels. Our provision for tutoring computer coding to children is designed to foster creativity, problem-solving skills, and logical thinking. Through our carefully curated curriculum, we introduce young learners to the fundamentals of coding, including algorithms, variables, loops, conditionals, and more. We believe in a hands-on approach, allowing students to actively apply what they learn through practical coding exercises and projects. At GLA Tutors, we understand that each child has their own unique learning style and pace. That's why our tutors provide personalized attention to every student, offering guidance and support every step of the way. Whether your child is a beginner or has some coding experience, we have tailored programs to suit their specific needs and help them progress confidently.

GLA Tutors is your trusted partner in preparing children for the SATs and Eleven Plus exams.  We understand the importance of these exams in shaping a child's academic future, and we are here to provide comprehensive and effective tutoring to ensure their success. Our dedicated team of tutors is well-versed in the style and content of both the SATs and Eleven Plus exams. We are committed to equipping children with the knowledge, skills, and confidence they need to excel in these challenging assessments. For SATs preparation, we offer targeted instruction in key subjects such as English (including Grammar, Reading and Writing), Mathematics, and Science. Our tutors are experienced in teaching the specific curriculum and concepts covered in the SATs, ensuring that children are thoroughly prepared for each section of the exam. From comprehension and grammar in English, to problem-solving and data analysis in Mathematics, our tutors provide tailored guidance to help children tackle every aspect of the SATs with confidence. For the Eleven Plus, we assess a child's aptitude in key areas such as English, Mathematics, Verbal Reasoning, and Non-Verbal Reasoning. Our tutors have in-depth knowledge of the exam format and content, and they employ effective strategies to help children succeed in each section. From improving comprehension and vocabulary skills in English, to developing logical reasoning and problem-solving abilities in Mathematics and Reasoning, we provide comprehensive support to ensure children are well-prepared for the Eleven Plus exams. Successfully passing the SATs or Eleven Plus exams  Success in these exams opens up a world of opportunities for children. After achieving these milestones, children will have various options available to them. They may gain entry into selective secondary schools, including grammar schools, which can provide an academically challenging environment and a strong foundation for future success. Additionally, achieving high scores in these exams can enhance a child's confidence and self-esteem, paving the way for a positive attitude towards learning and academic achievement in the future. There is a direct correlation between success in these exams and the GCSEs. Individual Styles AtGLA Tutors, we understand that every child is unique, and we tailor our tutoring approach to meet their individual needs. Our tutors provide personalised instruction, focusing on areas where each child requires additional support, while also nurturing their strengths and building their overall academic abilities. We are dedicated to fostering a positive and engaging learning environment, where children feel motivated and empowered to reach their full potential. Our tutors not only impart knowledge but also instill important study skills, critical thinking abilities, and effective exam techniques that will serve children well beyond the SATs and Eleven Plus exams. Choose GLA Tutorsas your partner in preparing your child for the SATs and Eleven Plus exams. With our experienced tutors, comprehensive resources, and personalised approach, we are committed to helping children achieve their academic goals and unlock a brighter future.  Invest in your child's success and join us at GLA Tutors today.

Computer Science GCSE Syllabus The GCSE Computer Science Tutor Syllabus is designed to provide tutors in England with a comprehensive framework for teaching the GCSE Computer Science curriculum effectively. This syllabus aims to equip tutors with the necessary knowledge and skills to support students in their understanding and application of core computer science concepts.  Module 1: Introduction to Computer Science - Overview of computer science and its relevance in today's world - Understanding the components of a computer system - Introduction to algorithms and problem-solving techniques - Exploration of programming languages and their uses Module 2: Computer Hardware - Understanding the main components of a computer system, including CPU, memory, and storage devices - Exploring input and output devices and their functionalities - Understanding the role of operating systems and software in computer systems Module 3: Software Development - Introduction to programming concepts and languages (e.g., Python or Java) - Understanding variables, data types, and operators - Building algorithms and logical reasoning skills - Introduction to flowcharts and pseudocode - Implementation of simple programs and debugging techniques Module 4: Data Representation - Understanding binary, hexadecimal, and denary number systems - Representation of text, images, and sound using binary - Introduction to data compression and encryption techniques Module 5: Computer Networks - Understanding the basics of computer networks, including LAN, WAN, and the Internet - Introduction to network topologies, protocols, and security - Exploring the impact of digital communication on society Module 6: Cybersecurity and Ethical Issues - Understanding the importance of cybersecurity and data protection - Introduction to common threats and vulnerabilities - Exploring ethical issues related to computer science, such as privacy and intellectual property rights Module 7: Algorithms and Programming Techniques - Advanced programming concepts, including conditionals, loops, and functions - Introduction to sorting and searching algorithms - Exploring data structures, such as arrays and lists Module 8: System Architecture - Understanding the structure and function of a CPU - Introduction to memory hierarchy and cache - Exploring the Von Neumann architecture and its limitations Module 9: Computational Thinking and Problem Solving - Advanced problem-solving techniques using computational thinking - Introduction to algorithms for complex problems - Exploring algorithmic efficiency and optimization techniques Module 10: Exam Preparation and Revision - Reviewing key concepts covered throughout the syllabus - Practicing past exam questions and providing guidance on exam techniques - Supporting students with exam preparation strategies Please note that the duration and depth of each module can vary depending on the level of expertise required and the specific needs of the learners. Additionally, it's important to adapt the curriculum to the learners' proficiency levels, whether they are A Level/GCSE students or adult learners with different experience levels.