Course Plan
EDK
RegistrationTop ratings
Get free trial access now Try first, then study!
4.92/5.0 (from 386 Trusted Shops Reviews )
4.9/5.0
- Google reviews
JavaScript basis and deepening
starting at €2.890,- | face-to-face course
» Our Course Packages
Flexible learning - our possible learning options for the course:
Course Fee: from €
2.890,-
Including Exam Fees and Study Materials
Installment Plans Available
No Interest, No Fees
No Interest, No Fees
Information Event
Entry possible at any time
Course Upgrades
Add Another Course
Add Another Course
Academy account forever
learning materials available for life
learning materials available for life
Money-back guarantee
14 days right of withdrawal (according to the Distance Selling Act)
14 days right of withdrawal (according to the Distance Selling Act)
Sound scientific content
Certificate valid worldwide & unlimited in time
Certificate valid worldwide & unlimited in time
Recognized & Certified
Our graduates, partners & friends say
Our team will be happy to advise you at any time by phone, chat or in person
JavaScript - Basics and Advanced: The comprehensive course for all levels
The JavaScript - Fundamentals and Advanced course is a comprehensive course that covers both the basics and advanced techniques of JavaScript programming. This course is ideal for complete career changers as all the important basics are covered from the beginning. At the same time, it also provides in-depth coverage for those who have already gained some experience with JavaScript and want to develop their skills further.
Whether you are new to web development or have already completed a few projects, this course will give you the knowledge and skills you need to work successfully with JavaScript and develop complex web applications.
Would you like to get started right away and delve deeper into JavaScript? Then why not complete the JavaScript Developer course right away? This comprehensive course includes not only JavaScript basics and in-depth knowledge, but also HTML and CSS development to give you a complete understanding of web development. Register now and start your journey into the world of modern web development!
Whether you are new to web development or have already completed a few projects, this course will give you the knowledge and skills you need to work successfully with JavaScript and develop complex web applications.
Would you like to get started right away and delve deeper into JavaScript? Then why not complete the JavaScript Developer course right away? This comprehensive course includes not only JavaScript basics and in-depth knowledge, but also HTML and CSS development to give you a complete understanding of web development. Register now and start your journey into the world of modern web development!
Factsheet on the course
Extent of learning
747 E
3
EQF level
The training is based on EQF level 3 »
Course start
Possible immediately
Learning variant
Classroom Courses
Available
Languages
DE
EN
ES
All course dates
Find your classroom course
JavaScript basis and... -
Half-day weekend course
| 18-01-2025 | starting at 2.890,-
Presence phase from: 15-03-2025
Questions about the course? We are happy to advise you.
Join in at any time!
Questions about the course? We are happy to advise you.
Everything at a glance!
JavaScript basis and deepening
Your path to comprehensive JavaScript knowledge: Basics and in-depth knowledge
Start directly with the course "JavaScript - Basics and Advanced" or build on it?
Are you new to JavaScript and want to acquire comprehensive knowledge? Then we recommend that you start directly with our "JavaScript - Fundamentals and Advanced" course, which not only covers the basics of IT skills, but also includes the "JavaScript - Fundamentals" course.
Have you already successfully completed the "JavaScript -Basics" course? Then you can seamlessly move on to the specialist module "JavaScript Advanced: Advanced course with a practical focus" and deepen your knowledge further.
What can you expect from our training?
In our JavaScript - Basics and Advanced course, you can expect a structured and practice-oriented learning approach that teaches you both the basic and advanced techniques of JavaScript programming.
Comprehensive introductionWe start with a comprehensive introduction to the world of web development and JavaScript. Even if you are a complete newcomer, you will quickly understand the key concepts and syntax of JavaScript through easy-to-understand explanations and clear examples.
Practice-oriented learningOur course places great emphasis on practice-oriented learning. You will work on numerous exercises and projects that will enable you to apply what you have learned immediately. You will not only gain theoretical knowledge, but also practical skills that you can put into practice in real projects.
Modular programming and best practicesYou will learn how to develop modular and maintainable applications. We will teach you best practices and proven methods used in professional web development.
Consolidation and extensionFor those who already have a basic knowledge of JavaScript, we offer an in-depth course that introduces you to advanced techniques. This includes topics such as closures, prototypes, asynchronous programming, DOM manipulation and the use of modern HTML5 and CSS3 APIs
Conditions of participation
- Online or written registration
- Basic IT knowledge is recommended but not required
- Minimum age 18 years (for participants under 18 years, written parental consent is required for registration)
- Access to an internet-enabled device
- Access to a stable internet connection
Certificate of completion
Our certificates are valid worldwide and are issued in different versions. On request, you can receive our certificate in several languages, with country-specific information and with or without printed grades.
All of these variants are available to you free of charge for a lifetime for downloading from your online campus. In addition, depending on the learning package you have purchased, you will receive a certificate of your choice, which will be issued on special high-quality embossed paper.
The following certificate is awarded:
"JavaScript Basics and Advanced"
Do you have specific questions about the training?
We will be happy to help you by phone, e-mail or chat.
Procedure & duration - How your training is structured
The training consists of three modules
You can find the list of modules and subjects by clicking on the "Course content" tab.Duration of the course
As our training courses can be designed very flexibly, the duration of the training depends heavily on your own learning initiative, the amount of time you spend each week and your previous knowledge. Depending on how much time you can invest and how quickly you absorb the required knowledge, it is also possible to complete the training more quickly.Online live training via Zoom
The training is conducted live online via Zoom. The instructors teach in real time and share their screen so that you can follow the lessons from the comfort of your own home. You have access to all dates and the link to the live webinar via the Online Campus, so you can easily take part from home.You will receive the Zoom meeting link by e-mail before the start of the course and it will also be available on our Flexyfit learning platform. Please make sure that you have entered your current e-mail address when registering.
With online distance learning courses, you set the tone
Learn at your own pace, when and where you want. The Academy account accompanies you on your computer, tablet or smartphone and contains everything you need for the course.You decide how you learn
You can choose from a wide range of Full HD learning videos in which our top instructors teach you the training content. You can also read the content in our scripts and presentations.No pain, no gain
Along the way, you will work your way through a variety of compulsory and additional tasks. These include writing a simple program, carrying out a security analysis or using a cloud service. All tasks are explained in a step-by-step guide so that you can apply what you have learned in practice.Last but not least... Exams
You can expect lots of multiple choice online exams to test your knowledge. You can take a test exam before each exam to be optimally prepared.
Detailed Course Contents
Extent of learning
747 E | Volume
EDK
187
IT competence
PL
480
Presence | Self-study
RE
16
Literature research
TE
48
Practical realization
AE
16
Additional tasks & examinations
This training is suitable for educational leave. The individual review and approval is subject to the respective funding agency. For more detailed information on the duration and procedure of educational leave, please contact us directly! Book a consultation appointment now.
Participation in the face-to-face webinars is mandatory for educational leave and must be proven to the AMS. Confirmation of attendance must be requested on the participant's own responsibility. Confirmation of attendance of the face-to-face webinar will only be issued during each webinar if requested by the participant.
Module IT competence
Show all chapters of the subjects
Basic knowledge of EDP
The subject "Basic IT knowledge" teaches basic knowledge and concepts of electronic data processing. It offers a comprehensive introduction to the world of computer technology, operating systems, networks and much more.
A computer is an electronic device that is used to process data. It performs calculations, stores and processes information. There are different types of computers, including personal computers (PCs), servers and embedded systems. Each type has specific applications and functions.
An operating system manages the hardware and software resources of a computer. It enables the execution of applications and ensures communication between hardware and software. The best-known operating systems include Windows, macOS and Linux, although each operating system has its own characteristics and areas of application.
Code can be translated by either compilers or interpreters. Compilers convert the entire code into machine language, while interpreters execute the code line by line. The fetch-decode-execute cycle describes the process by which the processor fetches, decodes and executes instructions.
A process is a program that is being executed. The management of processes includes the allocation of resources and the monitoring of their execution. Multitasking enables the simultaneous execution of several processes, whereby process scheduling determines which processes are executed when and for how long.
Hardware is controlled by special software known as drivers. Drivers enable communication between the operating system and hardware components by forwarding specific commands and data.
This module provides a solid foundation in the basic principles of electronic data processing and prepares students to understand and apply more complex concepts in IT.
A computer is an electronic device that is used to process data. It performs calculations, stores and processes information. There are different types of computers, including personal computers (PCs), servers and embedded systems. Each type has specific applications and functions.
An operating system manages the hardware and software resources of a computer. It enables the execution of applications and ensures communication between hardware and software. The best-known operating systems include Windows, macOS and Linux, although each operating system has its own characteristics and areas of application.
Code can be translated by either compilers or interpreters. Compilers convert the entire code into machine language, while interpreters execute the code line by line. The fetch-decode-execute cycle describes the process by which the processor fetches, decodes and executes instructions.
A process is a program that is being executed. The management of processes includes the allocation of resources and the monitoring of their execution. Multitasking enables the simultaneous execution of several processes, whereby process scheduling determines which processes are executed when and for how long.
Hardware is controlled by special software known as drivers. Drivers enable communication between the operating system and hardware components by forwarding specific commands and data.
This module provides a solid foundation in the basic principles of electronic data processing and prepares students to understand and apply more complex concepts in IT.
- WHAT IS A CALCULATOR?
- Definition and basic concepts
- Different types of computers (PCs, servers, embedded systems)
- WHAT IS AN OPERATING SYSTEM?
- Tasks of an operating system
- Examples of common operating systems (Windows, macOS, Linux)
- HOW IS CODE EXECUTED?
- Translation and execution of code (compiler vs. interpreter)
- Sequence of code execution (fetch-decode-execute cycle)
- WHAT ARE PROCESSES?
- Definition and management of processes
- Multitasking and process scheduling
- HOW IS HARDWARE CONTROLLED?
- Basics of hardware control
- Drivers and their role in the system
- WHAT IS A PROGRAM?
- Definition of a program
- Differences between applications and system software
- NETWORK BASICS
- Basics of network technology
- Network protocols and architectures (TCP/IP, OSI model)
- WHAT IS A SERVER?
- Definition and tasks of a server
- Differences between server and client systems
- Examples and areas of application of servers
- WHAT IS THE CLOUD?
- Definition and basics of cloud technology
- Differences between public, private and hybrid cloud
- Advantages and challenges of using the cloud
- INTERNET OF THINGS (IOT)
- Definition and basics of the IoT
- Examples of IoT applications (smart homes, Industry 4.0)
- Challenges and future of the IoT
- SERVICES
- Definition and importance of IT services
- Different types of services (web services, microservices)
- Examples and areas of application of IT services
Show chapter
Coding
The subject "Coding " teaches basic and advanced concepts of programming and software development. It aims to provide participants with a sound understanding of the various programming languages, principles and techniques. In addition, what has been learned is consolidated through knowledge tests and practical tasks. Here are the main topics covered in this module:
Programming languages and how they work
Participants will learn the basic principles and concepts of programming languages. An overview of high-level and low-level programming languages will be given, with the differences between these types clearly highlighted. High-level languages such as Python and Java are compared to machine-oriented languages such as Assembly.
From Visual Programming to 0 and 1
This section covers the range of programming from visual programming languages to machine-oriented languages. Examples of visual programming languages, such as Scratch, and machine-oriented languages, such as Assembly, are presented. The different levels of programming and their applications are explained.
Fundamentals of programming
The basic concepts of programming are taught here. These include the syntax and semantics of programming languages, the declaration and use of variables and data types (such as integer, float, string, boolean), as well as the use of arithmetic, logical and comparison operators.
Design patterns
Design patterns are proven solution patterns for recurring problems in software development. Participants learn the definition and purpose of design patterns and are given examples of common patterns such as singleton, factory and observer. The application and advantages of design patterns in software development are also discussed.
Control structures
This section covers the basic control structures in programming, including conditions and branching with if, else and elif statements as well as loops such as for and while loops. The importance of loop control using break and continue is also explained.
Functions and modularity
Participants will learn how to define and call functions, including parameters, return values and code reusability. The basic principles of modularity and the division of code into manageable, reusable modules are also covered.
Basic data structures
This section provides a basic understanding of data structures such as lists, arrays, dictionaries, hashmaps, tuples and sets. Students will learn how to create, access and modify these structures.
Simple algorithms and problem solving
Participants are introduced to basic sorting algorithms such as bubble sort and selection sort. They will also learn about search algorithms such as linear and binary search. Systematic problem-solving strategies and debugging methods are discussed.
Object-oriented programming (OOP)
The basic principles of object-oriented programming are taught, including classes, objects, attributes and methods. Concepts such as inheritance, polymorphism and encapsulation are fundamentally explained and illustrated with simple examples.
Simple projects and practical applications
Participants put their knowledge into practice in small, practical projects, such as the development of a calculator, a to-do list or a simple game. Finally, simple techniques for checking and improving your own code through code reviews are covered.
Programming languages and how they work
Participants will learn the basic principles and concepts of programming languages. An overview of high-level and low-level programming languages will be given, with the differences between these types clearly highlighted. High-level languages such as Python and Java are compared to machine-oriented languages such as Assembly.
From Visual Programming to 0 and 1
This section covers the range of programming from visual programming languages to machine-oriented languages. Examples of visual programming languages, such as Scratch, and machine-oriented languages, such as Assembly, are presented. The different levels of programming and their applications are explained.
Fundamentals of programming
The basic concepts of programming are taught here. These include the syntax and semantics of programming languages, the declaration and use of variables and data types (such as integer, float, string, boolean), as well as the use of arithmetic, logical and comparison operators.
Design patterns
Design patterns are proven solution patterns for recurring problems in software development. Participants learn the definition and purpose of design patterns and are given examples of common patterns such as singleton, factory and observer. The application and advantages of design patterns in software development are also discussed.
Control structures
This section covers the basic control structures in programming, including conditions and branching with if, else and elif statements as well as loops such as for and while loops. The importance of loop control using break and continue is also explained.
Functions and modularity
Participants will learn how to define and call functions, including parameters, return values and code reusability. The basic principles of modularity and the division of code into manageable, reusable modules are also covered.
Basic data structures
This section provides a basic understanding of data structures such as lists, arrays, dictionaries, hashmaps, tuples and sets. Students will learn how to create, access and modify these structures.
Simple algorithms and problem solving
Participants are introduced to basic sorting algorithms such as bubble sort and selection sort. They will also learn about search algorithms such as linear and binary search. Systematic problem-solving strategies and debugging methods are discussed.
Object-oriented programming (OOP)
The basic principles of object-oriented programming are taught, including classes, objects, attributes and methods. Concepts such as inheritance, polymorphism and encapsulation are fundamentally explained and illustrated with simple examples.
Simple projects and practical applications
Participants put their knowledge into practice in small, practical projects, such as the development of a calculator, a to-do list or a simple game. Finally, simple techniques for checking and improving your own code through code reviews are covered.
- PROGRAMMING LANGUAGES / TYPES
- Principles and concepts of programming languages
- Differences between high-level and low-level languages
- HOW DO THEY WORK?
- From visual programming to 0 and 1 (machine-oriented languages)
- Different levels of programming
- Examples of visual and machine-oriented programming languages
- BASICS OF PROGRAMMING
- Syntax and semantics: explanation of syntax rules and the meaning of lines of code
- Variables and data types: Different data types (integer, float, string, boolean) and how to declare and use variables
- Operators: Arithmetic, logical and comparison operators
- DESIGN PATTERNS
- Definition and purpose of design patterns
- Examples of common design patterns (singleton, factory, observer)
- Application and advantages of design patterns in software development
- CONTROL STRUCTURES
- Conditions and branches: if, else, and elif statements
- Loops: for and while loops, as well as the meaning of loop control (break, continue)
- FUNCTIONS AND MODULARITY
- Definition and calling of functions: Parameters, return values and the importance of code reusability
- Basic principles of modularity: how to divide code into manageable, reusable modules
- BASIC DATA STRUCTURES
- Lists and arrays: Creating, accessing, and modifying elements
- Dictionaries and hashmaps: Basic understanding and application
- Tuples and sets: use and differences to lists and dictionaries
- SIMPLE ALGORITHMS AND PROBLEM SOLVING
- Sorting algorithms: Introduction to simple sorting methods such as bubble sort and selection sort
- Searching: Linear and binary searches
- Problem solving strategies: Approach methods for systematic problem solving and debugging
- OBJECT-ORIENTED PROGRAMMING (OOP)
- Basic principles of OOP: classes, objects, attributes, methods
- Concepts such as inheritance, polymorphism and encapsulation: basic explanations and simple examples
- SIMPLE PROJECTS AND PRACTICAL APPLICATIONS
- Small projects: Practice-oriented exercises such as a calculator, a to-do list, or a simple game
- Code reviews: Simple techniques for reviewing and improving your own code
Show chapter
Databases
The subject "Databases" provides a basic introduction to the concepts and applications of databases. It aims to provide participants with a sound understanding of the different types of databases, their benefits and the most commonly used database systems. Here are the main topics covered in this module:
What are databases?
A database is a structured collection of data. There are relational databases, which organize data into tables with relationships, and non-relational databases, which are more flexible and are often used for specific applications such as big data.
Why do you need databases?
Databases offer efficient data management, fast queries and increased data security. They are essential for applications such as customer databases, financial systems and warehouse management.
The most commonly used databases:
MySQL: Open source, widely used for web applications.
PostgreSQL: Advanced functions and SQL support.
Oracle Database: Highly scalable, for large companies.
Microsoft SQL Server: Integrated into the Windows environment.
MongoDB: NoSQL database for unstructured data.
SQLite: Lightweight, ideal for mobile applications.
This module provides a solid foundation for understanding and using databases.
What are databases?
A database is a structured collection of data. There are relational databases, which organize data into tables with relationships, and non-relational databases, which are more flexible and are often used for specific applications such as big data.
Why do you need databases?
Databases offer efficient data management, fast queries and increased data security. They are essential for applications such as customer databases, financial systems and warehouse management.
The most commonly used databases:
MySQL: Open source, widely used for web applications.
PostgreSQL: Advanced functions and SQL support.
Oracle Database: Highly scalable, for large companies.
Microsoft SQL Server: Integrated into the Windows environment.
MongoDB: NoSQL database for unstructured data.
SQLite: Lightweight, ideal for mobile applications.
This module provides a solid foundation for understanding and using databases.
- WHAT ARE DATABASES?
- Definition and basic concepts of databases
- Relational vs. non-relational databases
- WHY DO YOU NEED THEM?
- Advantages of using databases
- Examples of database applications
- THE MOST COMMONLY USED DATABASES
- Overview of the most commonly used databases
- Features and areas of application of the most popular database systems
Show chapter
Introduction to electronic data processing (EDP)
The subject "Introduction to electronic data processing (EDP)" teaches basic knowledge and the importance of data processing in various areas of life. Students learn about the historical development and practical applications.
Importance and necessity of data processing
Data processing is indispensable in almost all areas of modern life. It enables the efficient management and analysis of large amounts of data, improves decision-making and optimizes business processes. In today's digital world, the ability to process data is an essential prerequisite for success in many professions and industries.
History of data processing
The history of data processing goes back a long way, from the first mechanical calculating machines to modern computers. Important milestones include the invention of punch card machines, the development of the first computers in the 1940s and the rapid development of technology in the 20th and 21st centuries. This evolution has fundamentally changed the way we process and use data.
Examples from practice
Healthcare: Electronic patient records enable efficient management of patient data and improve the quality of medical care through quick access to relevant information.
Business: Companies use data processing to optimize business processes, customer management and for data-driven marketing strategies.
Science: In research, large amounts of data are analyzed in order to gain scientific knowledge and drive innovation, for example in genome research or climate modelling.
Importance and necessity of data processing
Data processing is indispensable in almost all areas of modern life. It enables the efficient management and analysis of large amounts of data, improves decision-making and optimizes business processes. In today's digital world, the ability to process data is an essential prerequisite for success in many professions and industries.
History of data processing
The history of data processing goes back a long way, from the first mechanical calculating machines to modern computers. Important milestones include the invention of punch card machines, the development of the first computers in the 1940s and the rapid development of technology in the 20th and 21st centuries. This evolution has fundamentally changed the way we process and use data.
Examples from practice
Healthcare: Electronic patient records enable efficient management of patient data and improve the quality of medical care through quick access to relevant information.
Business: Companies use data processing to optimize business processes, customer management and for data-driven marketing strategies.
Science: In research, large amounts of data are analyzed in order to gain scientific knowledge and drive innovation, for example in genome research or climate modelling.
- IMPORTANCE AND NECESSITY OF DATA PROCESSING IN VARIOUS AREAS OF LIFE
- Relevance of data processing in everyday life
- Areas of application of IT in various sectors
- Advantages of IT in modern society
- HISTORY OF DATA PROCESSING
- Development of data processing from its beginnings to the present day
- Milestones and important inventions in data processing
- Evolution of computer technology and its effects
- EXAMPLES FROM PRACTICE (E.G. HEALTHCARE, BUSINESS, SCIENCE)
- Application of EDP in the healthcare sector: Patient management, diagnostic support, research
- Use of IT in business: business processes, accounting, marketing analyses
- Role of IT in science: data analysis, simulations, scientific publications
Show chapter
Security IT competence
The subject "Security" provides basic knowledge in the areas of data protection, authentication and cyber security. It covers the following topics:
Data protection basics
Data protection basics
- Data protection basics: protection of personal data.
- Important laws and regulations: GDPR and its requirements.
- Measures to protect privacy: Techniques for securing privacy.
Authentication basics
- Definition and meaning: identity verification for security.
- Various methods: passwords, biometric procedures, multi-factor authentication.
- Best practices: Secure authentication systems.
Cyber Security & Hacking
- Basics: Protection against digital threats.
- Common threats: Phishing, malware, DDoS attacks.
- Security measures: Use of firewalls and antivirus software.
This module prepares participants for the secure handling of data and systems.
- DATA PROTECTION BASICS
- Basics of data protection
- Important laws and regulations (e.g. GDPR)
- Measures to protect privacy
- AUTHENTICATION BASICS
- Definition and importance of authentication
- Various authentication methods (passwords, biometric methods)
- Best practices for secure authentication
- CYBER SECURITY & HACKING
- Basics of cyber security
- Common threats and attacks (phishing, malware, DDoS)
- Measures to increase security (firewalls, antivirus software)
Show chapter
Software
The subject "Software" provides an overview of the different types of software, their availability on different devices, the production and distribution processes and the communication between software programs.
There are two main categories of software: system software, such as operating systems and drivers, and application software, such as word processing programs and games. Software is available on various devices, including desktop computers, mobile devices and embedded systems. There is both platform-independent software and platform-specific applications.
Software is produced using various development processes such as agile and the waterfall model. Version control and continuous integration/deployment (CI/CD) are crucial for efficient software development. Software can be distributed on-premises, cloud-based or as a mobile app.
Software communicates with each other via interfaces such as APIs and webhooks. These enable the integration of services and real-time notification between different applications.
This module comprehensively prepares participants to understand and use software in practice.
- WHAT TYPES OF SOFTWARE ARE THERE?
- System software vs. application software
- Examples of different software categories
- ON WHICH DEVICES IS IT AVAILABLE?
- Desktop, mobile devices, embedded systems
- Platform independence and platform-specific applications
- HOW IS SOFTWARE PRODUCED AND DISTRIBUTED?
- Development processes (agile, waterfall model)
- Version control and continuous integration/continuous deployment (CI/CD)
- Distribution of software (on-premises, cloud-based, mobile apps)
- HOW DOES SOFTWARE COMMUNICATE WITH SOFTWARE? (INTERFACES)
- Definition and types of interfaces (APIs, webhooks)
- Examples and applications of software communication
Show chapter
Tools
The subject "Tools" offers a comprehensive insight into the various tools and environments used for the development and use of modern software solutions. This includes basic development tools, the use of the command line, version control and an introduction to artificial intelligence (AI). This section is supplemented by knowledge checks and practical tasks.
Understanding the working environment
Students will be introduced to basic development tools, including text editors such as Visual Studio Code and Sublime Text, and integrated development environments (IDEs) such as PyCharm and Eclipse. They will learn the basic command line commands used for navigation and file management. In addition, you will receive an introduction to version control with Git and learn the basic commands for managing code versions.
Artificial intelligence
The basic concepts of artificial intelligence are explained, including definitions and different areas such as machine learning and neural networks. Participants will learn about use cases and examples of the application of AI in everyday life and discuss the benefits and challenges of AI technologies.
This module prepares participants to work effectively with modern development tools and to develop a fundamental understanding of artificial intelligence.
Understanding the working environment
Students will be introduced to basic development tools, including text editors such as Visual Studio Code and Sublime Text, and integrated development environments (IDEs) such as PyCharm and Eclipse. They will learn the basic command line commands used for navigation and file management. In addition, you will receive an introduction to version control with Git and learn the basic commands for managing code versions.
Artificial intelligence
The basic concepts of artificial intelligence are explained, including definitions and different areas such as machine learning and neural networks. Participants will learn about use cases and examples of the application of AI in everyday life and discuss the benefits and challenges of AI technologies.
This module prepares participants to work effectively with modern development tools and to develop a fundamental understanding of artificial intelligence.
- UNDERSTANDING THE WORKING ENVIRONMENT
- Simple development tools: Introduction to text editors (e.g. Visual Studio Code, Sublime Text) and IDEs (e.g. PyCharm, Eclipse)
- Command line/terminal: Basic commands for navigation and file management
- Versioning: Introduction to Git and basic commands for version control
- ARTIFICIAL INTELLIGENCE
- Definition and basic concepts of AI
- Different areas of AI (machine learning, neural networks)
- Use cases and examples of AI in everyday life
- Advantages and challenges of AI technologies
Show chapter
Module MS Excel basics
Show all chapters of the subjects
Data analysis and scenarios
This subject focuses on advanced techniques of data analysis and the use of scenarios in Excel. Students will learn to:
Analyze tables and lists: Students will learn how to use pivot tables and pivot charts to effectively analyze and visualize large amounts of data. They will learn how to create, customize and interpret pivot tables to gain valuable insights into the data.
Filtering and sorting data: This module teaches advanced techniques for filtering and sorting data. Participants will learn how to apply complex filtering criteria and sort data in multiple levels to extract relevant information quickly and accurately.
Create and use scenarios: Participants will learn how to create and use different scenarios to perform hypothetical analysis. This includes creating what-if analyses to explore the impact of different assumptions and decisions on their data and make informed decisions. These two subjects provide participants with valuable skills to increase and execute their productivity, helping them to make informed decisions in their everyday professional lives.
Analyze tables and lists: Students will learn how to use pivot tables and pivot charts to effectively analyze and visualize large amounts of data. They will learn how to create, customize and interpret pivot tables to gain valuable insights into the data.
Filtering and sorting data: This module teaches advanced techniques for filtering and sorting data. Participants will learn how to apply complex filtering criteria and sort data in multiple levels to extract relevant information quickly and accurately.
Create and use scenarios: Participants will learn how to create and use different scenarios to perform hypothetical analysis. This includes creating what-if analyses to explore the impact of different assumptions and decisions on their data and make informed decisions. These two subjects provide participants with valuable skills to increase and execute their productivity, helping them to make informed decisions in their everyday professional lives.
- ANALYZE TABLES AND LISTS:
- Using pivot tables and pivot charts to analyze and visualize large amounts of data
- Creating, customizing and interpreting pivot tables
- FILTERING AND SORTING DATA:
- Applying advanced filtering and sorting techniques
- Complex filter criteria and multi-level sorting for precise extraction of relevant information
- CREATE AND USE SCENARIOS:
- Creating and using scenarios for hypothetical analyses (what-if analyses)
- Investigating the impact of different assumptions and decisions on the data
- MONITORING AND VALIDATING DATA:
- Setting up monitoring rules and using validation and error checking functions
- Ensuring data integrity and accuracy
Show chapter
Introduction to the Excel working environment
In this subject you will get to know the basic working environment of Excel. The focus is on providing you with a solid foundation on which you can build to use Excel efficiently and effectively.
Overview of the user interface: You will receive a detailed overview of the Excel user interface. This includes an explanation of the various elements, such as the ribbon, the quick access toolbar and the workbook. You will learn how to move around in Excel, open and close worksheets and switch between different views.
Menus and tools: We will guide you through the various menus and tools that Excel offers. You will learn how the tabs in the ribbon are structured and which functions are hidden behind the respective tabs. From file operations and data analysis tools to charting and formatting options - you will learn where to find which tools and how to use them.
Customize the status bar: The status bar at the bottom of the Excel window gives you important information at a glance. You will learn how to customize the status bar to display exactly the information you need, e.g. sum, average or number of selected cells. This helps you to work more efficiently and access relevant data quickly.
Important basic functions: We will show you the most important basic functions to help you get started with Excel. This includes basic operations such as creating, saving and opening workbooks. You will learn how to enter data in cells and perform simple calculations. We also explain how to carry out basic formatting to make your data clear and appealing.
This comprehensive introduction to the Excel working environment will lay the foundations for your future work with this powerful tool. You will be able to navigate confidently in Excel, use the most important functions and manage and edit your first data efficiently.
- OVERVIEW OF THE USER INTERFACE
- Menus and tools
- Customize status bar
- Workbooks
- IMPORTANT BASIC FUNCTIONS
- Creating, saving and opening workbooks
- Basic formatting and calculations
Show chapter
Advanced functions and techniques
In this subject, students will learn how to use advanced functions and techniques in Excel to perform complex data analysis and calculations. Here are the key learning points:
Advanced Formatting: Students will learn how to create and apply custom number formats to present data specifically and clearly. This includes the use of custom formatting rules to display currencies, percentages or custom text formats, for example.
Advanced conditional formatting: This module covers the application of complex conditional formatting to automatically highlight data based on specific criteria. Participants will learn how to combine and apply multiple rules to visually support their data analysis.
Application of functions from different categories: Students will learn how to use advanced functions from the logic, statistics, financial math, and math categories.
- ADVANCED FORMATTING
- Creation and application of user-defined number formats for the specific and clear presentation of data
- Use of user-defined formatting rules (e.g. currencies, percentages)
- ADVANCED CONDITIONAL FORMATTING
- Application of complex conditional formatting to visually support data analysis
- Combination and application of multiple conditional formatting rules
- APPLICATION OF FUNCTIONS FROM DIFFERENT CATEGORIES
- Use of advanced functions from the categories of logic, statistics, financial mathematics and mathematics:
- Logic functions: If, And, Or, Not
- Statistical functions: Mean, Median, Mode, Stabw
- Financial mathematical functions: Interest, Rmz, Ikv
- Mathematical functions: Sum, sum-if, sum-product
Show chapter
Consolidation and structuring
In this subject, participants learn how to consolidate data from several worksheets and workbooks and present it in a structured way. The main learning contents are
Consolidation of data:
Participants will learn how to merge data from different sources and worksheets to create a unified database. This includes using consolidation functions and tools in Excel to calculate totals, averages and other aggregated data.
Working with relationships:
Students will learn how to create and manage links between worksheets and workbooks. They will learn how to dynamically link data so that changes in a source are automatically updated in the linked workbook.
Organizing data:
Participants will learn techniques for organizing and structuring data. This includes creating outlines to divide large amounts of data into manageable sections and using grouping functions to organize and present data hierarchically.
Merging and comparing workbooks:
This module covers methods for merging multiple workbooks. Participants will learn how to compare and consolidate data from different workbooks to create consistent and complete data sets.
Consolidation of data:
Participants will learn how to merge data from different sources and worksheets to create a unified database. This includes using consolidation functions and tools in Excel to calculate totals, averages and other aggregated data.
Working with relationships:
Students will learn how to create and manage links between worksheets and workbooks. They will learn how to dynamically link data so that changes in a source are automatically updated in the linked workbook.
Organizing data:
Participants will learn techniques for organizing and structuring data. This includes creating outlines to divide large amounts of data into manageable sections and using grouping functions to organize and present data hierarchically.
Merging and comparing workbooks:
This module covers methods for merging multiple workbooks. Participants will learn how to compare and consolidate data from different workbooks to create consistent and complete data sets.
- CONSOLIDATION OF DATA
- Merging data from different sources and spreadsheets to create a unified database
- Use consolidation functions and tools to calculate totals, averages and other aggregated data
- WORKING WITH LINKS
- Create and manage links between worksheets and workbooks
- Dynamically link data so that changes in a source are automatically updated in the linked workbook
- STRUCTURING DATA
- Create outlines to structure large amounts of data into manageable sections
- Use grouping functions to display and organize data hierarchically
- MERGING AND COMPARING WORKBOOKS
- Methods for merging and consolidating multiple workbooks
- Compare and consolidate data from different workbooks to create consistent data sets
Show chapter
Professional use of diagrams
In this subject, participants learn how to use advanced charting techniques to visualize their data in a professional and appealing way. The main learning contents are:
Advanced charting techniques: Students will learn advanced techniques for designing and customizing charts. This includes adding trend lines, formatting data series and axes, and applying custom chart elements.
Using Chart Templates: Participants will learn how to create and use chart templates to quickly create consistent and professional charts. They will learn how to save custom templates and apply them to different data sets.
Dynamic Charts: This module covers the creation of dynamic charts that automatically adapt to changes in the underlying data. Participants will learn how to define data ranges and create charts that update based on dynamic data.
Data Visualization with Sparklines: Participants will learn how to use sparklines to display data trends and patterns in compact charts embedded in individual cells. This technique enables quick and efficient visualization of data directly in the worksheets.
- CREATING DIAGRAMS
- Basics of creating charts in Excel
- Creation of different chart types (e.g. column, line, pie and bar charts)
- ADVANCED CHARTING TECHNIQUES
- Designing and customizing charts by adding trend lines and formatting data series and axes
- Application of user-defined chart elements for better data visualization
- USE OF CHART TEMPLATES
- Create and use chart templates to create professional charts quickly and consistently
- Save and apply custom templates to different data sets
- DYNAMIC CHARTS
- Create dynamic charts that automatically adapt to changes in the underlying data
- Define data ranges to create and update dynamic charts
- DATA VISUALIZATION WITH SPARKLINES
- Use sparklines to visualize data trends and patterns in compact charts embedded in individual cells
- Quick and efficient visualization of data directly in the worksheets
Show chapter
Module Java Script - Deepening
Show all chapters of the subjects
Development environments and web applications
In this subject, students will be introduced to different development environments used for JavaScript development. Participants will learn how to set up and effectively use different development environments to increase their productivity. Another important aspect is the use of browser developer tools that allow the code to be debugged, tested and optimized. The course also provides an overview of various JavaScript standards, including the latest developments from ES6 and beyond, to bring participants up to speed with the latest technology.
Designing and building a web application
The second part of the course focuses on the basic concepts and structure of a web application. Participants will learn the basic principles of a web application, including the structure and manipulation of the DOM (Document Object Model) tree, which forms the basis for the presentation and interaction of web content. It explains how event handling and event listeners are used to create interactive and responsive applications.
The integration and use of HTML5 will be covered to utilize modern web standards and features. In addition, participants will learn how to use CSS3 for layouts and design to create appealing and user-friendly interfaces.
Designing and building a web application
The second part of the course focuses on the basic concepts and structure of a web application. Participants will learn the basic principles of a web application, including the structure and manipulation of the DOM (Document Object Model) tree, which forms the basis for the presentation and interaction of web content. It explains how event handling and event listeners are used to create interactive and responsive applications.
The integration and use of HTML5 will be covered to utilize modern web standards and features. In addition, participants will learn how to use CSS3 for layouts and design to create appealing and user-friendly interfaces.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Error detection and best practices
In this subject, participants learn techniques for detecting errors and debugging JavaScript code. The course begins with identifying and avoiding common errors in JavaScript programming. Participants will learn how to recognize and prevent typical problems in order to increase the stability and reliability of their applications.
Another important aspect is debugging methods and tools. Participants will learn how to apply effective debugging techniques to quickly identify and fix errors. This includes the use of integrated development environments (IDEs) and browser developer tools that offer special debugging functions. Practical debugging exercises help participants to apply what they have learned in real-life scenarios and improve their debugging skills.
Best Practices
The second part of the course focuses on the application of best practices in JavaScript programming. Participants will learn best practices for code organization and structuring to write clean, maintainable and scalable code. This includes techniques for modularization and meaningful naming of variables and functions.
Another focus is on refactoring code. Participants will learn how to restructure existing code to improve readability and efficiency without changing functionality. These techniques are crucial for the long-term maintenance and extensibility of software projects.
In addition, security aspects in JavaScript will be covered. Participants will learn how to identify and fix security vulnerabilities to protect their applications against common threats such as Cross-Site Scripting (XSS) and Cross-Site Request Forgery (CSRF).
Another important aspect is debugging methods and tools. Participants will learn how to apply effective debugging techniques to quickly identify and fix errors. This includes the use of integrated development environments (IDEs) and browser developer tools that offer special debugging functions. Practical debugging exercises help participants to apply what they have learned in real-life scenarios and improve their debugging skills.
Best Practices
The second part of the course focuses on the application of best practices in JavaScript programming. Participants will learn best practices for code organization and structuring to write clean, maintainable and scalable code. This includes techniques for modularization and meaningful naming of variables and functions.
Another focus is on refactoring code. Participants will learn how to restructure existing code to improve readability and efficiency without changing functionality. These techniques are crucial for the long-term maintenance and extensibility of software projects.
In addition, security aspects in JavaScript will be covered. Participants will learn how to identify and fix security vulnerabilities to protect their applications against common threats such as Cross-Site Scripting (XSS) and Cross-Site Request Forgery (CSRF).
- The detailed chapters on the subject will be available here shortly!
Show chapter
Advanced techniques and optimization
In this class, students will learn about the latest HTML5 JavaScript features that make modern web applications more powerful and versatile. The course begins with an introduction to application caches, which make it possible to make web applications available offline and improve load times. Participants will learn how to use WebWorker to enable parallel processing, which can significantly increase the performance and responsiveness of their applications.
Another important component is the use of Canvas, which is used to create graphical applications and animations. Participants will learn how to use the Canvas API to render complex graphics and interactive content directly in the browser. They will also learn how to use the Geolocation API, which makes it possible to determine a user's geographical location and integrate location-based functions into web applications.
Debugging, profiling and optimization
The second part of the course focuses on techniques for error detection, performance analysis and optimization of JavaScript code. Participants will learn various debugging methods to effectively find and fix errors in code. Profiling techniques will be introduced to analyze the performance of web applications and identify bottlenecks.
Participants will learn how to perform speed optimizations for web applications to reduce load times and improve the user experience. Optimization tools and best practices will be presented to support the entire development process and maximize application efficiency.
Another important component is the use of Canvas, which is used to create graphical applications and animations. Participants will learn how to use the Canvas API to render complex graphics and interactive content directly in the browser. They will also learn how to use the Geolocation API, which makes it possible to determine a user's geographical location and integrate location-based functions into web applications.
Debugging, profiling and optimization
The second part of the course focuses on techniques for error detection, performance analysis and optimization of JavaScript code. Participants will learn various debugging methods to effectively find and fix errors in code. Profiling techniques will be introduced to analyze the performance of web applications and identify bottlenecks.
Participants will learn how to perform speed optimizations for web applications to reduce load times and improve the user experience. Optimization tools and best practices will be presented to support the entire development process and maximize application efficiency.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Complex data structures and design patterns
In this subject, students learn about complex data structures as well as proven design patterns in software development.
Complex data structures
The course begins with an introduction to complex data structures such as maps and sets, which provide advanced data storage and manipulation capabilities. Participants will deepen their understanding of arrays and objects and learn how to use these basic data structures efficiently. An important component is also the use of JSON (JavaScript Object Notation), a widely used format for structuring and transferring data, which is particularly important in web development.
Design patterns
The second part of the course focuses on design patterns, which are recurring solutions to common problems in software development. Participants are introduced to the concepts and principles of design patterns and learn about their importance and possible applications.
Some of the key design patterns that will be covered include:
Complex data structures
The course begins with an introduction to complex data structures such as maps and sets, which provide advanced data storage and manipulation capabilities. Participants will deepen their understanding of arrays and objects and learn how to use these basic data structures efficiently. An important component is also the use of JSON (JavaScript Object Notation), a widely used format for structuring and transferring data, which is particularly important in web development.
Design patterns
The second part of the course focuses on design patterns, which are recurring solutions to common problems in software development. Participants are introduced to the concepts and principles of design patterns and learn about their importance and possible applications.
Some of the key design patterns that will be covered include:
- Singleton Pattern: this pattern ensures that a class has only one instance and provides a global access point to that instance.
- Observer Pattern: This pattern defines a one-to-many dependency between objects so that when an object changes state, all dependent objects are notified and automatically updated.
- Factory pattern: This pattern provides an interface for creating objects, whereby the concrete class names do not have to be specified.
Participants are guided through practical examples and implementation exercises to put theoretical knowledge into practice. These exercises help them to understand the design patterns and apply them in their own projects.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Object-oriented programming (OOP) with JavaScript
In this subject, participants learn the basics of object-oriented programming (OOP) in JavaScript. The course begins with an introduction to OOP concepts and explains how they are implemented in JavaScript. Participants will learn how to create and extend objects to write reusable and modular code. An important component is the understanding of prototypes and inheritance in JavaScript, which forms the basis for the object-oriented structuring of applications.
Advanced OOP concepts
The second part of the course covers advanced concepts of OOP in JavaScript. Participants will learn how to use classes and modules to structure and organize their applications. In addition, mixins and decorators are introduced, which provide flexible ways to add functions and properties to objects.
Practical examples and exercises are an integral part of the course to put theoretical knowledge into practice. Participants will be guided through various scenarios and projects to consolidate their object-oriented programming skills.
The course concludes with an introduction to design patterns in OOP. Participants will learn about various design patterns used in object-oriented programming to solve recurring problems and make code more efficient and maintainable.
Advanced OOP concepts
The second part of the course covers advanced concepts of OOP in JavaScript. Participants will learn how to use classes and modules to structure and organize their applications. In addition, mixins and decorators are introduced, which provide flexible ways to add functions and properties to objects.
Practical examples and exercises are an integral part of the course to put theoretical knowledge into practice. Participants will be guided through various scenarios and projects to consolidate their object-oriented programming skills.
The course concludes with an introduction to design patterns in OOP. Participants will learn about various design patterns used in object-oriented programming to solve recurring problems and make code more efficient and maintainable.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Recognition of our IT training courses
Training certification
There are no uniformly standardized training paths in the field of IT training. However, this does not mean that the quality and recognition of our training programs are compromised. Our training institute is ISO 9001 certified and recognized. This certification confirms our commitment to the highest quality standards and continuous improvement.
Through our ISO 9001 certification, we ensure that our IT training programs - including our PHP programmer, web developer, programmer courses, and more - are developed and delivered according to international quality standards. You benefit from structured, practical curricula, experienced instructors and a high level of support during your training.
Institute certification
As a recognized institution in adult education, we subject our curricula to regular evaluations that are recognized by state authorities and funding bodies. Our ongoing goal is to exceed current quality standards and thus guarantee you first-class training. Convince yourself of our certifications.
Our certification gives you the certainty that you are receiving high-quality, recognized training that will optimally prepare you for your professional future.
Funding & educational leave - how it works
Can I get funding for my training?
At the Flexyfit EDV Academy, you have a wide range of options for funding your training. There are various funding programs at federal state and EU level as well as tax incentives that serve as a basis.
Please note, however, that the decision on the allocation and amount of funding is the sole responsibility of the respective funding body.
We will be happy to help you find a suitable funding body and provide you with all the course information you need to apply for funding. You must submit the application itself to the relevant funding body.
How does the funding work?
Depending on the funding institution, your training will be financed either through direct assumption of costs after confirmation of the funding application (e.g. AMS) or through full or partial reimbursement after successful completion of the training (e.g. Waff). We recommend that you contact the relevant funding institutions in person to find out about individual funding options.Can I take educational leave for the course?
Yes, the majority of our courses are suitable for educational leave.
If you would like to continue your education without terminating your employment, you can arrange educational leave with your employer. You will be released from work for the duration of the training.
Plan your educational leave with us now! We will be happy to clarify your individual training requirements with you in a personal, non-binding consultation .
How does educational leave work?
You can take your educational leave for a maximum of- Educational leave over a period of 12 months in one go
- split up, whereby each part must last at least
2 months . The parts must be taken within4 years . - Educational leave with part-time educational leave extending over
2 years
Please note that this is a general summary and it is advisable to check with the relevant bodies or authorities for further details and conditions.
Your employer's consent is essential for educational leave. You must submit the training plans issued by us, which require 20 hours per week for full-time educational leave or at least 10 hours per week for part-time educational leave.
It is also necessary to provide regular proof of the progress of your training, for example through examinations or attendance certificates issued by us.
Areas of application and possibilities with JavaScript skills
Frontend development:
Add interactivity: Validating forms, creating animations, responding to user actions such as clicks and keystrokes. Responsive web applications: Develop user-friendly and responsive websites together with HTML and CSS.
Backend development:
Server-side applications: Creating server-side logics with Node.js.
Data processing: Processing data, creating APIs and interacting with databases.
Full web applications: Developing web applications that include both the user interface and server-side logic.
Mobile app development:
Cross-platform apps: Developing mobile apps for iOS and Android using frameworks such as React Native or Ionic.
Automation:
Recurring tasks: Automation of development tasks with Node.js and npm scripts.
Build processes: Simplification and automation of complex build processes.
JavaScript offers a wide range of applications in web development, from the creation of interactive and dynamic web content in the frontend and server-side applications in the backend to the development of cross-platform mobile apps and the automation of development tasks. With basic knowledge of JavaScript, you can develop comprehensive and efficient solutions for the web and mobile platforms.
Your path to comprehensive JavaScript knowledge: Basics and in-depth knowledge
Start directly with the course "JavaScript - Basics and Advanced" or build on it?
Are you new to JavaScript and want to acquire comprehensive knowledge? Then we recommend that you start directly with our "JavaScript - Fundamentals and Advanced" course, which not only covers the basics of IT skills, but also includes the "JavaScript - Fundamentals" course.
Have you already successfully completed the "JavaScript -Basics" course? Then you can seamlessly move on to the specialist module "JavaScript Advanced: Advanced course with a practical focus" and deepen your knowledge further.
What can you expect from our training?
In our JavaScript - Basics and Advanced course, you can expect a structured and practice-oriented learning approach that teaches you both the basic and advanced techniques of JavaScript programming.
Comprehensive introductionWe start with a comprehensive introduction to the world of web development and JavaScript. Even if you are a complete newcomer, you will quickly understand the key concepts and syntax of JavaScript through easy-to-understand explanations and clear examples.
Practice-oriented learningOur course places great emphasis on practice-oriented learning. You will work on numerous exercises and projects that will enable you to apply what you have learned immediately. You will not only gain theoretical knowledge, but also practical skills that you can put into practice in real projects.
Modular programming and best practicesYou will learn how to develop modular and maintainable applications. We will teach you best practices and proven methods used in professional web development.
Consolidation and extensionFor those who already have a basic knowledge of JavaScript, we offer an in-depth course that introduces you to advanced techniques. This includes topics such as closures, prototypes, asynchronous programming, DOM manipulation and the use of modern HTML5 and CSS3 APIs
Conditions of participation
- Online or written registration
- Basic IT knowledge is recommended but not required
- Minimum age 18 years (for participants under 18 years, written parental consent is required for registration)
- Access to an internet-enabled device
- Access to a stable internet connection
Certificate of completion
Our certificates are valid worldwide and are issued in different versions. On request, you can receive our certificate in several languages, with country-specific information and with or without printed grades.
All of these variants are available to you free of charge for a lifetime for downloading from your online campus. In addition, depending on the learning package you have purchased, you will receive a certificate of your choice, which will be issued on special high-quality embossed paper.
The following certificate is awarded:
"JavaScript Basics and Advanced"
Do you have specific questions about the training?
We will be happy to help you by phone, e-mail or chat.
Procedure & duration - How your training is structured
The training consists of three modules
You can find the list of modules and subjects by clicking on the "Course content" tab.Duration of the course
As our training courses can be designed very flexibly, the duration of the training depends heavily on your own learning initiative, the amount of time you spend each week and your previous knowledge. Depending on how much time you can invest and how quickly you absorb the required knowledge, it is also possible to complete the training more quickly.Online live training via Zoom
The training is conducted live online via Zoom. The instructors teach in real time and share their screen so that you can follow the lessons from the comfort of your own home. You have access to all dates and the link to the live webinar via the Online Campus, so you can easily take part from home.You will receive the Zoom meeting link by e-mail before the start of the course and it will also be available on our Flexyfit learning platform. Please make sure that you have entered your current e-mail address when registering.
With online distance learning courses, you set the tone
Learn at your own pace, when and where you want. The Academy account accompanies you on your computer, tablet or smartphone and contains everything you need for the course.You decide how you learn
You can choose from a wide range of Full HD learning videos in which our top instructors teach you the training content. You can also read the content in our scripts and presentations.No pain, no gain
Along the way, you will work your way through a variety of compulsory and additional tasks. These include writing a simple program, carrying out a security analysis or using a cloud service. All tasks are explained in a step-by-step guide so that you can apply what you have learned in practice.Last but not least... Exams
You can expect lots of multiple choice online exams to test your knowledge. You can take a test exam before each exam to be optimally prepared.
Detailed Course Contents
Extent of learning
747 E | Volume
EDK
187
IT competence
PL
480
Presence | Self-study
RE
16
Literature research
TE
48
Practical realization
AE
16
Additional tasks & examinations
This training is suitable for educational leave. The individual review and approval is subject to the respective funding agency. For more detailed information on the duration and procedure of educational leave, please contact us directly! Book a consultation appointment now.
Participation in the face-to-face webinars is mandatory for educational leave and must be proven to the AMS. Confirmation of attendance must be requested on the participant's own responsibility. Confirmation of attendance of the face-to-face webinar will only be issued during each webinar if requested by the participant.
Module IT competence
Show all chapters of the subjects
Basic knowledge of EDP
The subject "Basic IT knowledge" teaches basic knowledge and concepts of electronic data processing. It offers a comprehensive introduction to the world of computer technology, operating systems, networks and much more.
A computer is an electronic device that is used to process data. It performs calculations, stores and processes information. There are different types of computers, including personal computers (PCs), servers and embedded systems. Each type has specific applications and functions.
An operating system manages the hardware and software resources of a computer. It enables the execution of applications and ensures communication between hardware and software. The best-known operating systems include Windows, macOS and Linux, although each operating system has its own characteristics and areas of application.
Code can be translated by either compilers or interpreters. Compilers convert the entire code into machine language, while interpreters execute the code line by line. The fetch-decode-execute cycle describes the process by which the processor fetches, decodes and executes instructions.
A process is a program that is being executed. The management of processes includes the allocation of resources and the monitoring of their execution. Multitasking enables the simultaneous execution of several processes, whereby process scheduling determines which processes are executed when and for how long.
Hardware is controlled by special software known as drivers. Drivers enable communication between the operating system and hardware components by forwarding specific commands and data.
This module provides a solid foundation in the basic principles of electronic data processing and prepares students to understand and apply more complex concepts in IT.
A computer is an electronic device that is used to process data. It performs calculations, stores and processes information. There are different types of computers, including personal computers (PCs), servers and embedded systems. Each type has specific applications and functions.
An operating system manages the hardware and software resources of a computer. It enables the execution of applications and ensures communication between hardware and software. The best-known operating systems include Windows, macOS and Linux, although each operating system has its own characteristics and areas of application.
Code can be translated by either compilers or interpreters. Compilers convert the entire code into machine language, while interpreters execute the code line by line. The fetch-decode-execute cycle describes the process by which the processor fetches, decodes and executes instructions.
A process is a program that is being executed. The management of processes includes the allocation of resources and the monitoring of their execution. Multitasking enables the simultaneous execution of several processes, whereby process scheduling determines which processes are executed when and for how long.
Hardware is controlled by special software known as drivers. Drivers enable communication between the operating system and hardware components by forwarding specific commands and data.
This module provides a solid foundation in the basic principles of electronic data processing and prepares students to understand and apply more complex concepts in IT.
- WHAT IS A CALCULATOR?
- Definition and basic concepts
- Different types of computers (PCs, servers, embedded systems)
- WHAT IS AN OPERATING SYSTEM?
- Tasks of an operating system
- Examples of common operating systems (Windows, macOS, Linux)
- HOW IS CODE EXECUTED?
- Translation and execution of code (compiler vs. interpreter)
- Sequence of code execution (fetch-decode-execute cycle)
- WHAT ARE PROCESSES?
- Definition and management of processes
- Multitasking and process scheduling
- HOW IS HARDWARE CONTROLLED?
- Basics of hardware control
- Drivers and their role in the system
- WHAT IS A PROGRAM?
- Definition of a program
- Differences between applications and system software
- NETWORK BASICS
- Basics of network technology
- Network protocols and architectures (TCP/IP, OSI model)
- WHAT IS A SERVER?
- Definition and tasks of a server
- Differences between server and client systems
- Examples and areas of application of servers
- WHAT IS THE CLOUD?
- Definition and basics of cloud technology
- Differences between public, private and hybrid cloud
- Advantages and challenges of using the cloud
- INTERNET OF THINGS (IOT)
- Definition and basics of the IoT
- Examples of IoT applications (smart homes, Industry 4.0)
- Challenges and future of the IoT
- SERVICES
- Definition and importance of IT services
- Different types of services (web services, microservices)
- Examples and areas of application of IT services
Show chapter
Coding
The subject "Coding " teaches basic and advanced concepts of programming and software development. It aims to provide participants with a sound understanding of the various programming languages, principles and techniques. In addition, what has been learned is consolidated through knowledge tests and practical tasks. Here are the main topics covered in this module:
Programming languages and how they work
Participants will learn the basic principles and concepts of programming languages. An overview of high-level and low-level programming languages will be given, with the differences between these types clearly highlighted. High-level languages such as Python and Java are compared to machine-oriented languages such as Assembly.
From Visual Programming to 0 and 1
This section covers the range of programming from visual programming languages to machine-oriented languages. Examples of visual programming languages, such as Scratch, and machine-oriented languages, such as Assembly, are presented. The different levels of programming and their applications are explained.
Fundamentals of programming
The basic concepts of programming are taught here. These include the syntax and semantics of programming languages, the declaration and use of variables and data types (such as integer, float, string, boolean), as well as the use of arithmetic, logical and comparison operators.
Design patterns
Design patterns are proven solution patterns for recurring problems in software development. Participants learn the definition and purpose of design patterns and are given examples of common patterns such as singleton, factory and observer. The application and advantages of design patterns in software development are also discussed.
Control structures
This section covers the basic control structures in programming, including conditions and branching with if, else and elif statements as well as loops such as for and while loops. The importance of loop control using break and continue is also explained.
Functions and modularity
Participants will learn how to define and call functions, including parameters, return values and code reusability. The basic principles of modularity and the division of code into manageable, reusable modules are also covered.
Basic data structures
This section provides a basic understanding of data structures such as lists, arrays, dictionaries, hashmaps, tuples and sets. Students will learn how to create, access and modify these structures.
Simple algorithms and problem solving
Participants are introduced to basic sorting algorithms such as bubble sort and selection sort. They will also learn about search algorithms such as linear and binary search. Systematic problem-solving strategies and debugging methods are discussed.
Object-oriented programming (OOP)
The basic principles of object-oriented programming are taught, including classes, objects, attributes and methods. Concepts such as inheritance, polymorphism and encapsulation are fundamentally explained and illustrated with simple examples.
Simple projects and practical applications
Participants put their knowledge into practice in small, practical projects, such as the development of a calculator, a to-do list or a simple game. Finally, simple techniques for checking and improving your own code through code reviews are covered.
Programming languages and how they work
Participants will learn the basic principles and concepts of programming languages. An overview of high-level and low-level programming languages will be given, with the differences between these types clearly highlighted. High-level languages such as Python and Java are compared to machine-oriented languages such as Assembly.
From Visual Programming to 0 and 1
This section covers the range of programming from visual programming languages to machine-oriented languages. Examples of visual programming languages, such as Scratch, and machine-oriented languages, such as Assembly, are presented. The different levels of programming and their applications are explained.
Fundamentals of programming
The basic concepts of programming are taught here. These include the syntax and semantics of programming languages, the declaration and use of variables and data types (such as integer, float, string, boolean), as well as the use of arithmetic, logical and comparison operators.
Design patterns
Design patterns are proven solution patterns for recurring problems in software development. Participants learn the definition and purpose of design patterns and are given examples of common patterns such as singleton, factory and observer. The application and advantages of design patterns in software development are also discussed.
Control structures
This section covers the basic control structures in programming, including conditions and branching with if, else and elif statements as well as loops such as for and while loops. The importance of loop control using break and continue is also explained.
Functions and modularity
Participants will learn how to define and call functions, including parameters, return values and code reusability. The basic principles of modularity and the division of code into manageable, reusable modules are also covered.
Basic data structures
This section provides a basic understanding of data structures such as lists, arrays, dictionaries, hashmaps, tuples and sets. Students will learn how to create, access and modify these structures.
Simple algorithms and problem solving
Participants are introduced to basic sorting algorithms such as bubble sort and selection sort. They will also learn about search algorithms such as linear and binary search. Systematic problem-solving strategies and debugging methods are discussed.
Object-oriented programming (OOP)
The basic principles of object-oriented programming are taught, including classes, objects, attributes and methods. Concepts such as inheritance, polymorphism and encapsulation are fundamentally explained and illustrated with simple examples.
Simple projects and practical applications
Participants put their knowledge into practice in small, practical projects, such as the development of a calculator, a to-do list or a simple game. Finally, simple techniques for checking and improving your own code through code reviews are covered.
- PROGRAMMING LANGUAGES / TYPES
- Principles and concepts of programming languages
- Differences between high-level and low-level languages
- HOW DO THEY WORK?
- From visual programming to 0 and 1 (machine-oriented languages)
- Different levels of programming
- Examples of visual and machine-oriented programming languages
- BASICS OF PROGRAMMING
- Syntax and semantics: explanation of syntax rules and the meaning of lines of code
- Variables and data types: Different data types (integer, float, string, boolean) and how to declare and use variables
- Operators: Arithmetic, logical and comparison operators
- DESIGN PATTERNS
- Definition and purpose of design patterns
- Examples of common design patterns (singleton, factory, observer)
- Application and advantages of design patterns in software development
- CONTROL STRUCTURES
- Conditions and branches: if, else, and elif statements
- Loops: for and while loops, as well as the meaning of loop control (break, continue)
- FUNCTIONS AND MODULARITY
- Definition and calling of functions: Parameters, return values and the importance of code reusability
- Basic principles of modularity: how to divide code into manageable, reusable modules
- BASIC DATA STRUCTURES
- Lists and arrays: Creating, accessing, and modifying elements
- Dictionaries and hashmaps: Basic understanding and application
- Tuples and sets: use and differences to lists and dictionaries
- SIMPLE ALGORITHMS AND PROBLEM SOLVING
- Sorting algorithms: Introduction to simple sorting methods such as bubble sort and selection sort
- Searching: Linear and binary searches
- Problem solving strategies: Approach methods for systematic problem solving and debugging
- OBJECT-ORIENTED PROGRAMMING (OOP)
- Basic principles of OOP: classes, objects, attributes, methods
- Concepts such as inheritance, polymorphism and encapsulation: basic explanations and simple examples
- SIMPLE PROJECTS AND PRACTICAL APPLICATIONS
- Small projects: Practice-oriented exercises such as a calculator, a to-do list, or a simple game
- Code reviews: Simple techniques for reviewing and improving your own code
Show chapter
Databases
The subject "Databases" provides a basic introduction to the concepts and applications of databases. It aims to provide participants with a sound understanding of the different types of databases, their benefits and the most commonly used database systems. Here are the main topics covered in this module:
What are databases?
A database is a structured collection of data. There are relational databases, which organize data into tables with relationships, and non-relational databases, which are more flexible and are often used for specific applications such as big data.
Why do you need databases?
Databases offer efficient data management, fast queries and increased data security. They are essential for applications such as customer databases, financial systems and warehouse management.
The most commonly used databases:
MySQL: Open source, widely used for web applications.
PostgreSQL: Advanced functions and SQL support.
Oracle Database: Highly scalable, for large companies.
Microsoft SQL Server: Integrated into the Windows environment.
MongoDB: NoSQL database for unstructured data.
SQLite: Lightweight, ideal for mobile applications.
This module provides a solid foundation for understanding and using databases.
What are databases?
A database is a structured collection of data. There are relational databases, which organize data into tables with relationships, and non-relational databases, which are more flexible and are often used for specific applications such as big data.
Why do you need databases?
Databases offer efficient data management, fast queries and increased data security. They are essential for applications such as customer databases, financial systems and warehouse management.
The most commonly used databases:
MySQL: Open source, widely used for web applications.
PostgreSQL: Advanced functions and SQL support.
Oracle Database: Highly scalable, for large companies.
Microsoft SQL Server: Integrated into the Windows environment.
MongoDB: NoSQL database for unstructured data.
SQLite: Lightweight, ideal for mobile applications.
This module provides a solid foundation for understanding and using databases.
- WHAT ARE DATABASES?
- Definition and basic concepts of databases
- Relational vs. non-relational databases
- WHY DO YOU NEED THEM?
- Advantages of using databases
- Examples of database applications
- THE MOST COMMONLY USED DATABASES
- Overview of the most commonly used databases
- Features and areas of application of the most popular database systems
Show chapter
Introduction to electronic data processing (EDP)
The subject "Introduction to electronic data processing (EDP)" teaches basic knowledge and the importance of data processing in various areas of life. Students learn about the historical development and practical applications.
Importance and necessity of data processing
Data processing is indispensable in almost all areas of modern life. It enables the efficient management and analysis of large amounts of data, improves decision-making and optimizes business processes. In today's digital world, the ability to process data is an essential prerequisite for success in many professions and industries.
History of data processing
The history of data processing goes back a long way, from the first mechanical calculating machines to modern computers. Important milestones include the invention of punch card machines, the development of the first computers in the 1940s and the rapid development of technology in the 20th and 21st centuries. This evolution has fundamentally changed the way we process and use data.
Examples from practice
Healthcare: Electronic patient records enable efficient management of patient data and improve the quality of medical care through quick access to relevant information.
Business: Companies use data processing to optimize business processes, customer management and for data-driven marketing strategies.
Science: In research, large amounts of data are analyzed in order to gain scientific knowledge and drive innovation, for example in genome research or climate modelling.
Importance and necessity of data processing
Data processing is indispensable in almost all areas of modern life. It enables the efficient management and analysis of large amounts of data, improves decision-making and optimizes business processes. In today's digital world, the ability to process data is an essential prerequisite for success in many professions and industries.
History of data processing
The history of data processing goes back a long way, from the first mechanical calculating machines to modern computers. Important milestones include the invention of punch card machines, the development of the first computers in the 1940s and the rapid development of technology in the 20th and 21st centuries. This evolution has fundamentally changed the way we process and use data.
Examples from practice
Healthcare: Electronic patient records enable efficient management of patient data and improve the quality of medical care through quick access to relevant information.
Business: Companies use data processing to optimize business processes, customer management and for data-driven marketing strategies.
Science: In research, large amounts of data are analyzed in order to gain scientific knowledge and drive innovation, for example in genome research or climate modelling.
- IMPORTANCE AND NECESSITY OF DATA PROCESSING IN VARIOUS AREAS OF LIFE
- Relevance of data processing in everyday life
- Areas of application of IT in various sectors
- Advantages of IT in modern society
- HISTORY OF DATA PROCESSING
- Development of data processing from its beginnings to the present day
- Milestones and important inventions in data processing
- Evolution of computer technology and its effects
- EXAMPLES FROM PRACTICE (E.G. HEALTHCARE, BUSINESS, SCIENCE)
- Application of EDP in the healthcare sector: Patient management, diagnostic support, research
- Use of IT in business: business processes, accounting, marketing analyses
- Role of IT in science: data analysis, simulations, scientific publications
Show chapter
Security IT competence
The subject "Security" provides basic knowledge in the areas of data protection, authentication and cyber security. It covers the following topics:
Data protection basics
Data protection basics
- Data protection basics: protection of personal data.
- Important laws and regulations: GDPR and its requirements.
- Measures to protect privacy: Techniques for securing privacy.
Authentication basics
- Definition and meaning: identity verification for security.
- Various methods: passwords, biometric procedures, multi-factor authentication.
- Best practices: Secure authentication systems.
Cyber Security & Hacking
- Basics: Protection against digital threats.
- Common threats: Phishing, malware, DDoS attacks.
- Security measures: Use of firewalls and antivirus software.
This module prepares participants for the secure handling of data and systems.
- DATA PROTECTION BASICS
- Basics of data protection
- Important laws and regulations (e.g. GDPR)
- Measures to protect privacy
- AUTHENTICATION BASICS
- Definition and importance of authentication
- Various authentication methods (passwords, biometric methods)
- Best practices for secure authentication
- CYBER SECURITY & HACKING
- Basics of cyber security
- Common threats and attacks (phishing, malware, DDoS)
- Measures to increase security (firewalls, antivirus software)
Show chapter
Software
The subject "Software" provides an overview of the different types of software, their availability on different devices, the production and distribution processes and the communication between software programs.
There are two main categories of software: system software, such as operating systems and drivers, and application software, such as word processing programs and games. Software is available on various devices, including desktop computers, mobile devices and embedded systems. There is both platform-independent software and platform-specific applications.
Software is produced using various development processes such as agile and the waterfall model. Version control and continuous integration/deployment (CI/CD) are crucial for efficient software development. Software can be distributed on-premises, cloud-based or as a mobile app.
Software communicates with each other via interfaces such as APIs and webhooks. These enable the integration of services and real-time notification between different applications.
This module comprehensively prepares participants to understand and use software in practice.
- WHAT TYPES OF SOFTWARE ARE THERE?
- System software vs. application software
- Examples of different software categories
- ON WHICH DEVICES IS IT AVAILABLE?
- Desktop, mobile devices, embedded systems
- Platform independence and platform-specific applications
- HOW IS SOFTWARE PRODUCED AND DISTRIBUTED?
- Development processes (agile, waterfall model)
- Version control and continuous integration/continuous deployment (CI/CD)
- Distribution of software (on-premises, cloud-based, mobile apps)
- HOW DOES SOFTWARE COMMUNICATE WITH SOFTWARE? (INTERFACES)
- Definition and types of interfaces (APIs, webhooks)
- Examples and applications of software communication
Show chapter
Tools
The subject "Tools" offers a comprehensive insight into the various tools and environments used for the development and use of modern software solutions. This includes basic development tools, the use of the command line, version control and an introduction to artificial intelligence (AI). This section is supplemented by knowledge checks and practical tasks.
Understanding the working environment
Students will be introduced to basic development tools, including text editors such as Visual Studio Code and Sublime Text, and integrated development environments (IDEs) such as PyCharm and Eclipse. They will learn the basic command line commands used for navigation and file management. In addition, you will receive an introduction to version control with Git and learn the basic commands for managing code versions.
Artificial intelligence
The basic concepts of artificial intelligence are explained, including definitions and different areas such as machine learning and neural networks. Participants will learn about use cases and examples of the application of AI in everyday life and discuss the benefits and challenges of AI technologies.
This module prepares participants to work effectively with modern development tools and to develop a fundamental understanding of artificial intelligence.
Understanding the working environment
Students will be introduced to basic development tools, including text editors such as Visual Studio Code and Sublime Text, and integrated development environments (IDEs) such as PyCharm and Eclipse. They will learn the basic command line commands used for navigation and file management. In addition, you will receive an introduction to version control with Git and learn the basic commands for managing code versions.
Artificial intelligence
The basic concepts of artificial intelligence are explained, including definitions and different areas such as machine learning and neural networks. Participants will learn about use cases and examples of the application of AI in everyday life and discuss the benefits and challenges of AI technologies.
This module prepares participants to work effectively with modern development tools and to develop a fundamental understanding of artificial intelligence.
- UNDERSTANDING THE WORKING ENVIRONMENT
- Simple development tools: Introduction to text editors (e.g. Visual Studio Code, Sublime Text) and IDEs (e.g. PyCharm, Eclipse)
- Command line/terminal: Basic commands for navigation and file management
- Versioning: Introduction to Git and basic commands for version control
- ARTIFICIAL INTELLIGENCE
- Definition and basic concepts of AI
- Different areas of AI (machine learning, neural networks)
- Use cases and examples of AI in everyday life
- Advantages and challenges of AI technologies
Show chapter
Module MS Excel basics
Show all chapters of the subjects
Data analysis and scenarios
This subject focuses on advanced techniques of data analysis and the use of scenarios in Excel. Students will learn to:
Analyze tables and lists: Students will learn how to use pivot tables and pivot charts to effectively analyze and visualize large amounts of data. They will learn how to create, customize and interpret pivot tables to gain valuable insights into the data.
Filtering and sorting data: This module teaches advanced techniques for filtering and sorting data. Participants will learn how to apply complex filtering criteria and sort data in multiple levels to extract relevant information quickly and accurately.
Create and use scenarios: Participants will learn how to create and use different scenarios to perform hypothetical analysis. This includes creating what-if analyses to explore the impact of different assumptions and decisions on their data and make informed decisions. These two subjects provide participants with valuable skills to increase and execute their productivity, helping them to make informed decisions in their everyday professional lives.
Analyze tables and lists: Students will learn how to use pivot tables and pivot charts to effectively analyze and visualize large amounts of data. They will learn how to create, customize and interpret pivot tables to gain valuable insights into the data.
Filtering and sorting data: This module teaches advanced techniques for filtering and sorting data. Participants will learn how to apply complex filtering criteria and sort data in multiple levels to extract relevant information quickly and accurately.
Create and use scenarios: Participants will learn how to create and use different scenarios to perform hypothetical analysis. This includes creating what-if analyses to explore the impact of different assumptions and decisions on their data and make informed decisions. These two subjects provide participants with valuable skills to increase and execute their productivity, helping them to make informed decisions in their everyday professional lives.
- ANALYZE TABLES AND LISTS:
- Using pivot tables and pivot charts to analyze and visualize large amounts of data
- Creating, customizing and interpreting pivot tables
- FILTERING AND SORTING DATA:
- Applying advanced filtering and sorting techniques
- Complex filter criteria and multi-level sorting for precise extraction of relevant information
- CREATE AND USE SCENARIOS:
- Creating and using scenarios for hypothetical analyses (what-if analyses)
- Investigating the impact of different assumptions and decisions on the data
- MONITORING AND VALIDATING DATA:
- Setting up monitoring rules and using validation and error checking functions
- Ensuring data integrity and accuracy
Show chapter
Introduction to the Excel working environment
In this subject you will get to know the basic working environment of Excel. The focus is on providing you with a solid foundation on which you can build to use Excel efficiently and effectively.
Overview of the user interface: You will receive a detailed overview of the Excel user interface. This includes an explanation of the various elements, such as the ribbon, the quick access toolbar and the workbook. You will learn how to move around in Excel, open and close worksheets and switch between different views.
Menus and tools: We will guide you through the various menus and tools that Excel offers. You will learn how the tabs in the ribbon are structured and which functions are hidden behind the respective tabs. From file operations and data analysis tools to charting and formatting options - you will learn where to find which tools and how to use them.
Customize the status bar: The status bar at the bottom of the Excel window gives you important information at a glance. You will learn how to customize the status bar to display exactly the information you need, e.g. sum, average or number of selected cells. This helps you to work more efficiently and access relevant data quickly.
Important basic functions: We will show you the most important basic functions to help you get started with Excel. This includes basic operations such as creating, saving and opening workbooks. You will learn how to enter data in cells and perform simple calculations. We also explain how to carry out basic formatting to make your data clear and appealing.
This comprehensive introduction to the Excel working environment will lay the foundations for your future work with this powerful tool. You will be able to navigate confidently in Excel, use the most important functions and manage and edit your first data efficiently.
- OVERVIEW OF THE USER INTERFACE
- Menus and tools
- Customize status bar
- Workbooks
- IMPORTANT BASIC FUNCTIONS
- Creating, saving and opening workbooks
- Basic formatting and calculations
Show chapter
Advanced functions and techniques
In this subject, students will learn how to use advanced functions and techniques in Excel to perform complex data analysis and calculations. Here are the key learning points:
Advanced Formatting: Students will learn how to create and apply custom number formats to present data specifically and clearly. This includes the use of custom formatting rules to display currencies, percentages or custom text formats, for example.
Advanced conditional formatting: This module covers the application of complex conditional formatting to automatically highlight data based on specific criteria. Participants will learn how to combine and apply multiple rules to visually support their data analysis.
Application of functions from different categories: Students will learn how to use advanced functions from the logic, statistics, financial math, and math categories.
- ADVANCED FORMATTING
- Creation and application of user-defined number formats for the specific and clear presentation of data
- Use of user-defined formatting rules (e.g. currencies, percentages)
- ADVANCED CONDITIONAL FORMATTING
- Application of complex conditional formatting to visually support data analysis
- Combination and application of multiple conditional formatting rules
- APPLICATION OF FUNCTIONS FROM DIFFERENT CATEGORIES
- Use of advanced functions from the categories of logic, statistics, financial mathematics and mathematics:
- Logic functions: If, And, Or, Not
- Statistical functions: Mean, Median, Mode, Stabw
- Financial mathematical functions: Interest, Rmz, Ikv
- Mathematical functions: Sum, sum-if, sum-product
Show chapter
Consolidation and structuring
In this subject, participants learn how to consolidate data from several worksheets and workbooks and present it in a structured way. The main learning contents are
Consolidation of data:
Participants will learn how to merge data from different sources and worksheets to create a unified database. This includes using consolidation functions and tools in Excel to calculate totals, averages and other aggregated data.
Working with relationships:
Students will learn how to create and manage links between worksheets and workbooks. They will learn how to dynamically link data so that changes in a source are automatically updated in the linked workbook.
Organizing data:
Participants will learn techniques for organizing and structuring data. This includes creating outlines to divide large amounts of data into manageable sections and using grouping functions to organize and present data hierarchically.
Merging and comparing workbooks:
This module covers methods for merging multiple workbooks. Participants will learn how to compare and consolidate data from different workbooks to create consistent and complete data sets.
Consolidation of data:
Participants will learn how to merge data from different sources and worksheets to create a unified database. This includes using consolidation functions and tools in Excel to calculate totals, averages and other aggregated data.
Working with relationships:
Students will learn how to create and manage links between worksheets and workbooks. They will learn how to dynamically link data so that changes in a source are automatically updated in the linked workbook.
Organizing data:
Participants will learn techniques for organizing and structuring data. This includes creating outlines to divide large amounts of data into manageable sections and using grouping functions to organize and present data hierarchically.
Merging and comparing workbooks:
This module covers methods for merging multiple workbooks. Participants will learn how to compare and consolidate data from different workbooks to create consistent and complete data sets.
- CONSOLIDATION OF DATA
- Merging data from different sources and spreadsheets to create a unified database
- Use consolidation functions and tools to calculate totals, averages and other aggregated data
- WORKING WITH LINKS
- Create and manage links between worksheets and workbooks
- Dynamically link data so that changes in a source are automatically updated in the linked workbook
- STRUCTURING DATA
- Create outlines to structure large amounts of data into manageable sections
- Use grouping functions to display and organize data hierarchically
- MERGING AND COMPARING WORKBOOKS
- Methods for merging and consolidating multiple workbooks
- Compare and consolidate data from different workbooks to create consistent data sets
Show chapter
Professional use of diagrams
In this subject, participants learn how to use advanced charting techniques to visualize their data in a professional and appealing way. The main learning contents are:
Advanced charting techniques: Students will learn advanced techniques for designing and customizing charts. This includes adding trend lines, formatting data series and axes, and applying custom chart elements.
Using Chart Templates: Participants will learn how to create and use chart templates to quickly create consistent and professional charts. They will learn how to save custom templates and apply them to different data sets.
Dynamic Charts: This module covers the creation of dynamic charts that automatically adapt to changes in the underlying data. Participants will learn how to define data ranges and create charts that update based on dynamic data.
Data Visualization with Sparklines: Participants will learn how to use sparklines to display data trends and patterns in compact charts embedded in individual cells. This technique enables quick and efficient visualization of data directly in the worksheets.
- CREATING DIAGRAMS
- Basics of creating charts in Excel
- Creation of different chart types (e.g. column, line, pie and bar charts)
- ADVANCED CHARTING TECHNIQUES
- Designing and customizing charts by adding trend lines and formatting data series and axes
- Application of user-defined chart elements for better data visualization
- USE OF CHART TEMPLATES
- Create and use chart templates to create professional charts quickly and consistently
- Save and apply custom templates to different data sets
- DYNAMIC CHARTS
- Create dynamic charts that automatically adapt to changes in the underlying data
- Define data ranges to create and update dynamic charts
- DATA VISUALIZATION WITH SPARKLINES
- Use sparklines to visualize data trends and patterns in compact charts embedded in individual cells
- Quick and efficient visualization of data directly in the worksheets
Show chapter
Module Java Script - Deepening
Show all chapters of the subjects
Development environments and web applications
In this subject, students will be introduced to different development environments used for JavaScript development. Participants will learn how to set up and effectively use different development environments to increase their productivity. Another important aspect is the use of browser developer tools that allow the code to be debugged, tested and optimized. The course also provides an overview of various JavaScript standards, including the latest developments from ES6 and beyond, to bring participants up to speed with the latest technology.
Designing and building a web application
The second part of the course focuses on the basic concepts and structure of a web application. Participants will learn the basic principles of a web application, including the structure and manipulation of the DOM (Document Object Model) tree, which forms the basis for the presentation and interaction of web content. It explains how event handling and event listeners are used to create interactive and responsive applications.
The integration and use of HTML5 will be covered to utilize modern web standards and features. In addition, participants will learn how to use CSS3 for layouts and design to create appealing and user-friendly interfaces.
Designing and building a web application
The second part of the course focuses on the basic concepts and structure of a web application. Participants will learn the basic principles of a web application, including the structure and manipulation of the DOM (Document Object Model) tree, which forms the basis for the presentation and interaction of web content. It explains how event handling and event listeners are used to create interactive and responsive applications.
The integration and use of HTML5 will be covered to utilize modern web standards and features. In addition, participants will learn how to use CSS3 for layouts and design to create appealing and user-friendly interfaces.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Error detection and best practices
In this subject, participants learn techniques for detecting errors and debugging JavaScript code. The course begins with identifying and avoiding common errors in JavaScript programming. Participants will learn how to recognize and prevent typical problems in order to increase the stability and reliability of their applications.
Another important aspect is debugging methods and tools. Participants will learn how to apply effective debugging techniques to quickly identify and fix errors. This includes the use of integrated development environments (IDEs) and browser developer tools that offer special debugging functions. Practical debugging exercises help participants to apply what they have learned in real-life scenarios and improve their debugging skills.
Best Practices
The second part of the course focuses on the application of best practices in JavaScript programming. Participants will learn best practices for code organization and structuring to write clean, maintainable and scalable code. This includes techniques for modularization and meaningful naming of variables and functions.
Another focus is on refactoring code. Participants will learn how to restructure existing code to improve readability and efficiency without changing functionality. These techniques are crucial for the long-term maintenance and extensibility of software projects.
In addition, security aspects in JavaScript will be covered. Participants will learn how to identify and fix security vulnerabilities to protect their applications against common threats such as Cross-Site Scripting (XSS) and Cross-Site Request Forgery (CSRF).
Another important aspect is debugging methods and tools. Participants will learn how to apply effective debugging techniques to quickly identify and fix errors. This includes the use of integrated development environments (IDEs) and browser developer tools that offer special debugging functions. Practical debugging exercises help participants to apply what they have learned in real-life scenarios and improve their debugging skills.
Best Practices
The second part of the course focuses on the application of best practices in JavaScript programming. Participants will learn best practices for code organization and structuring to write clean, maintainable and scalable code. This includes techniques for modularization and meaningful naming of variables and functions.
Another focus is on refactoring code. Participants will learn how to restructure existing code to improve readability and efficiency without changing functionality. These techniques are crucial for the long-term maintenance and extensibility of software projects.
In addition, security aspects in JavaScript will be covered. Participants will learn how to identify and fix security vulnerabilities to protect their applications against common threats such as Cross-Site Scripting (XSS) and Cross-Site Request Forgery (CSRF).
- The detailed chapters on the subject will be available here shortly!
Show chapter
Advanced techniques and optimization
In this class, students will learn about the latest HTML5 JavaScript features that make modern web applications more powerful and versatile. The course begins with an introduction to application caches, which make it possible to make web applications available offline and improve load times. Participants will learn how to use WebWorker to enable parallel processing, which can significantly increase the performance and responsiveness of their applications.
Another important component is the use of Canvas, which is used to create graphical applications and animations. Participants will learn how to use the Canvas API to render complex graphics and interactive content directly in the browser. They will also learn how to use the Geolocation API, which makes it possible to determine a user's geographical location and integrate location-based functions into web applications.
Debugging, profiling and optimization
The second part of the course focuses on techniques for error detection, performance analysis and optimization of JavaScript code. Participants will learn various debugging methods to effectively find and fix errors in code. Profiling techniques will be introduced to analyze the performance of web applications and identify bottlenecks.
Participants will learn how to perform speed optimizations for web applications to reduce load times and improve the user experience. Optimization tools and best practices will be presented to support the entire development process and maximize application efficiency.
Another important component is the use of Canvas, which is used to create graphical applications and animations. Participants will learn how to use the Canvas API to render complex graphics and interactive content directly in the browser. They will also learn how to use the Geolocation API, which makes it possible to determine a user's geographical location and integrate location-based functions into web applications.
Debugging, profiling and optimization
The second part of the course focuses on techniques for error detection, performance analysis and optimization of JavaScript code. Participants will learn various debugging methods to effectively find and fix errors in code. Profiling techniques will be introduced to analyze the performance of web applications and identify bottlenecks.
Participants will learn how to perform speed optimizations for web applications to reduce load times and improve the user experience. Optimization tools and best practices will be presented to support the entire development process and maximize application efficiency.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Complex data structures and design patterns
In this subject, students learn about complex data structures as well as proven design patterns in software development.
Complex data structures
The course begins with an introduction to complex data structures such as maps and sets, which provide advanced data storage and manipulation capabilities. Participants will deepen their understanding of arrays and objects and learn how to use these basic data structures efficiently. An important component is also the use of JSON (JavaScript Object Notation), a widely used format for structuring and transferring data, which is particularly important in web development.
Design patterns
The second part of the course focuses on design patterns, which are recurring solutions to common problems in software development. Participants are introduced to the concepts and principles of design patterns and learn about their importance and possible applications.
Some of the key design patterns that will be covered include:
Complex data structures
The course begins with an introduction to complex data structures such as maps and sets, which provide advanced data storage and manipulation capabilities. Participants will deepen their understanding of arrays and objects and learn how to use these basic data structures efficiently. An important component is also the use of JSON (JavaScript Object Notation), a widely used format for structuring and transferring data, which is particularly important in web development.
Design patterns
The second part of the course focuses on design patterns, which are recurring solutions to common problems in software development. Participants are introduced to the concepts and principles of design patterns and learn about their importance and possible applications.
Some of the key design patterns that will be covered include:
- Singleton Pattern: this pattern ensures that a class has only one instance and provides a global access point to that instance.
- Observer Pattern: This pattern defines a one-to-many dependency between objects so that when an object changes state, all dependent objects are notified and automatically updated.
- Factory pattern: This pattern provides an interface for creating objects, whereby the concrete class names do not have to be specified.
Participants are guided through practical examples and implementation exercises to put theoretical knowledge into practice. These exercises help them to understand the design patterns and apply them in their own projects.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Object-oriented programming (OOP) with JavaScript
In this subject, participants learn the basics of object-oriented programming (OOP) in JavaScript. The course begins with an introduction to OOP concepts and explains how they are implemented in JavaScript. Participants will learn how to create and extend objects to write reusable and modular code. An important component is the understanding of prototypes and inheritance in JavaScript, which forms the basis for the object-oriented structuring of applications.
Advanced OOP concepts
The second part of the course covers advanced concepts of OOP in JavaScript. Participants will learn how to use classes and modules to structure and organize their applications. In addition, mixins and decorators are introduced, which provide flexible ways to add functions and properties to objects.
Practical examples and exercises are an integral part of the course to put theoretical knowledge into practice. Participants will be guided through various scenarios and projects to consolidate their object-oriented programming skills.
The course concludes with an introduction to design patterns in OOP. Participants will learn about various design patterns used in object-oriented programming to solve recurring problems and make code more efficient and maintainable.
Advanced OOP concepts
The second part of the course covers advanced concepts of OOP in JavaScript. Participants will learn how to use classes and modules to structure and organize their applications. In addition, mixins and decorators are introduced, which provide flexible ways to add functions and properties to objects.
Practical examples and exercises are an integral part of the course to put theoretical knowledge into practice. Participants will be guided through various scenarios and projects to consolidate their object-oriented programming skills.
The course concludes with an introduction to design patterns in OOP. Participants will learn about various design patterns used in object-oriented programming to solve recurring problems and make code more efficient and maintainable.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Recognition of our IT training courses
Training certification
There are no uniformly standardized training paths in the field of IT training. However, this does not mean that the quality and recognition of our training programs are compromised. Our training institute is ISO 9001 certified and recognized. This certification confirms our commitment to the highest quality standards and continuous improvement.
Through our ISO 9001 certification, we ensure that our IT training programs - including our PHP programmer, web developer, programmer courses, and more - are developed and delivered according to international quality standards. You benefit from structured, practical curricula, experienced instructors and a high level of support during your training.
Institute certification
As a recognized institution in adult education, we subject our curricula to regular evaluations that are recognized by state authorities and funding bodies. Our ongoing goal is to exceed current quality standards and thus guarantee you first-class training. Convince yourself of our certifications.
Our certification gives you the certainty that you are receiving high-quality, recognized training that will optimally prepare you for your professional future.
Funding & educational leave - how it works
Can I get funding for my training?
At the Flexyfit EDV Academy, you have a wide range of options for funding your training. There are various funding programs at federal state and EU level as well as tax incentives that serve as a basis.
Please note, however, that the decision on the allocation and amount of funding is the sole responsibility of the respective funding body.
We will be happy to help you find a suitable funding body and provide you with all the course information you need to apply for funding. You must submit the application itself to the relevant funding body.
How does the funding work?
Depending on the funding institution, your training will be financed either through direct assumption of costs after confirmation of the funding application (e.g. AMS) or through full or partial reimbursement after successful completion of the training (e.g. Waff). We recommend that you contact the relevant funding institutions in person to find out about individual funding options.Can I take educational leave for the course?
Yes, the majority of our courses are suitable for educational leave.
If you would like to continue your education without terminating your employment, you can arrange educational leave with your employer. You will be released from work for the duration of the training.
Plan your educational leave with us now! We will be happy to clarify your individual training requirements with you in a personal, non-binding consultation .
How does educational leave work?
You can take your educational leave for a maximum of- Educational leave over a period of 12 months in one go
- split up, whereby each part must last at least
2 months . The parts must be taken within4 years . - Educational leave with part-time educational leave extending over
2 years
Please note that this is a general summary and it is advisable to check with the relevant bodies or authorities for further details and conditions.
Your employer's consent is essential for educational leave. You must submit the training plans issued by us, which require 20 hours per week for full-time educational leave or at least 10 hours per week for part-time educational leave.
It is also necessary to provide regular proof of the progress of your training, for example through examinations or attendance certificates issued by us.
Areas of application and possibilities with JavaScript skills
Frontend development:
Add interactivity: Validating forms, creating animations, responding to user actions such as clicks and keystrokes. Responsive web applications: Develop user-friendly and responsive websites together with HTML and CSS.
Backend development:
Server-side applications: Creating server-side logics with Node.js.
Data processing: Processing data, creating APIs and interacting with databases.
Full web applications: Developing web applications that include both the user interface and server-side logic.
Mobile app development:
Cross-platform apps: Developing mobile apps for iOS and Android using frameworks such as React Native or Ionic.
Automation:
Recurring tasks: Automation of development tasks with Node.js and npm scripts.
Build processes: Simplification and automation of complex build processes.
JavaScript offers a wide range of applications in web development, from the creation of interactive and dynamic web content in the frontend and server-side applications in the backend to the development of cross-platform mobile apps and the automation of development tasks. With basic knowledge of JavaScript, you can develop comprehensive and efficient solutions for the web and mobile platforms.
Available course variations
JavaScript basis and deepening
Highlights
Language of Instruction
Course Module
IT competence (presence)
IT competence (online)
EDP competence Full HD learning videos
Learning Type / Learning Method
Course Modality
Study Method
Auditory & Visual Learning Style
Communicative & Kinesthetic Learning Style
Study Timeframe
Study Support (# all-inclusive)
Text & Presentation PDFs
Lectures Bookable as Classroom Units
Support via Online Campus, E-mail, Chat, Tel.
WhatsApp & On-site Support
Test/Dummy Exam
Exam/Completion
EDK Intermediate Examination Online
Final Exam
Certificate in DE, EN or ES
Certificate accepted worldwide & never expires
Academy Account (# all-inclusive)
Lifetime Access to Online Campus
Free Demo Account / Trial Package
Certificate Copy as Downloadable PDF
Certificate with Verification via QR-Code
Financial Aid
Financial Aid/Grant Opportunities
Paid Educational Leave (AT)
Grants for Businesses
Grants for Self-Employed Persons
Course Advising
Cost Estimate for Financial Aid Provider
Benefits
Job Openings Mailing List
Comprehensive Training Opportunities
Absolute Best Price & Service Offer
EN
Classroom course Webinar
Presence
communicative
suitable
recommended
Flexible
Flexible date
up to 100%
non-binding
Basic information on the learning variants:
- The training content is the same for each learning variant
- The examination period, duration of training and examination procedure are independent of the learning variant
- Sie können von der Lernvariante "Fernstudium" auf Präsenz unterricht aufbuchen. Auch einzelne Modulblöcke sind aufbuchbar
- With the "face-to-face course" learning option, you can book and complete individual blocks in private lessons
- The final certificate does not differ, regardless of which learning variant you have completed the course in
- Your Academy account and the learning content will stay with you for the rest of your life
vor 2 Tagen
Auf Vollzeit-Berufstätige wird besonders Rücksicht genommen. Die Aufbereitung der Lernunterlagen (in der Kombination Buchform, Folien und Videos) ist großartig.
Ein wirklich tolles Team, sympathische und professionelle Vortragende, insgesamt ein top Ausbildungsinstitut, das ich jedem nur sehr weiterempfehlen kann. ⭐️⭐️⭐️⭐️⭐️
vor 6 Tagen
Einfach ein Top Team !
vor 15 Tagen
Interessanter und sehr umfangreicher Kursplan, kompetente Betreuung, sehr nettes Team, ganz einfach TOP und jederzeit gerne wieder.
18.11.2023
Schnelle Antwort auf alle Fragen.
11.11.2023
Schnelle Beratung, Top Service
07.11.2023
Sehr gute Unterstützung durch dem Personal, sowohl telefonisch als auch per Mail. Besonderen Dank an Sarah
17.10.2023
Ganz tolles Angebot und Service... jederzeit gerne wieder.
12.10.2023
Nett,
07.10.2023
Schnelle unkomplizierte Anmeldung. Ratenzahlung perfekt und man kann sich das lerntempo selbst anpassen
01.10.2023
Sportkompetenz + Fitnesstrainer B-Lizenz sind ein sehr umfangreicher Kurs, in dem jede Menge Wissen vermittelt wird, welches dem aktuellen wissenschaftlichen Stand entspricht. Man bekommt einen Gegenwert für sein Geld. Der Schwerpunkt liegt auf dem Maschinentraining. Neben bekannten Übungen, werden auch interessante Spezialübungen gezeigt. Was ich etwas vermisst habe sind klassische Hantelübungen (z.B. Kurzhantelüberzüge, Kreuzhebevarianten, Kniebeugen, Bankdrücken, Stirndrücken, SZ-Bizepscurls,... usw.), welche meiner Meinung nach insbesondere für Anfänger etwas besser geeignet sind als einige der gezeigten Kabelzugübungen. Was leider ebenfalls zu kurz kommt, sind Übungen für die Bauchmuskulatur. Hier bitte nachbessern.
Auf Nachrichten wird sehr schnell reagiert. Für das Fachgespräch habe ich innerhalb von 24 Stunden einen Termin bekommen. Ich werde auf jeden Fall weitere Kurse machen. Alles in allem kann ich den Kurs sehr empfehlen.
22.06.2023
Alles 👍
10.05.2023
Alles ist gut vorbereitet, die Kurse, die Mitarbeiter, perfekt.
10.05.2023
Die begleitung in eure Welt war sehr klar und deutig. Die mitarbeitarin hat mich von anfang an begleitet mit telefonate wo sie an alle meine fragen ein antwort gefunden hat. Und auch bei umstellund des Gutschein kauf haben mich die mitarbeiter sofort geholfen
25.04.2023
Aufbau, Unterlagen und Videos sind top, wenn man etwas benötigt reagieren sie schnell.
15.04.2023
Super Team, kompetent, geduldig und immer freundlich
07.04.2023
Kompetente Auskunft, gute Organisation super Kursangebot
01.04.2023
Tolle Academy
10.03.2023
Klasse Ausbildung, qualifiziertes Personal, guter Service
07.03.2023
Die Module sind sehr lehrreich gestaltet. Zudem sind die Videos sehr gut dargestellt und verständlich.
05.03.2023
Vielseitiges Kurs- und Ausbildungsangebot in dem auch verschiedene Richtungen kombiniert werden. Ganz toll!
Rating
Zoe Alina
2 weeks ago
Very well organized team, uncomplicated operation of online lessons, versatile informative script :) All in all top!
[+]
posted on
Susi Sorglos
2 weeks ago
I am very impressed with Flexyfit, always nice and helpful people. Very sympathetic. Thank you very much for your great support.
[+]
posted on
Anna Kober
3 weeks ago
Great training and super nice people. You can tell how much emphasis is placed on conveying the necessary knowledge to the course participants in an understandable way. I was even kindly allowed to take a course completely free of charge after there were somewhat problematic and disruptive participants in my group. I will 100% take more courses with you in the future because learning is extremely fun, especially thanks to the friendly staff!
[+]
posted on
Brigitte Moser
3 weeks ago
The entire flexyfit team is extremely friendly, prompt and helpful. The lecturers are competent and respond to the course participants. All learning materials were provided clearly and in sufficient deta