facebook
FavouritesAdd to Wish List
FavouritesAdd to Wish List
from30.00EUR/ h

Programming and Numerical Methods - Visual Basic for Applications (VBA)

In this class, you will be learning how to use Visual Basic for Applications (VBA) to program and solve engineering problems. The type of class can be adapted to your needs, from a beginner (VBA basics) to an experienced user (advanced numerical methods).

Complete Program:

Programming
-Introduction to Visual Basic for Applications (VBA)
-Subroutines basics: variables and syntax
-Indexed variables and input data
-Communication Excel/VBA: read and write to/from the worksheet
-Loops and conditional statements
-External Functions

Numerical Methods
-Introduction to numerical methods: linear, non-linear equations and convergence criteria
-Errors and approximations
-Solving non-linear equations – Bracketing methods: Bisection and False Position
-Solving non-linear equations – Iterative methods: Newton, Secant and Fixed Point
-Solving systems of linear equations – Direct methods (n < 1000): Gauss Elimination and LU Decomposition
-Solving systems of linear equations – Direct methods (n < 3): Substitution method and Crame Rule
-Solving systems of linear equations – Direct methods (Tridiagonal matrices): Thomas algorithm
-Solving systems of linear equations – Iterative methods (large matrices): Jacobi, Gauss-Seidel
-Solving systems of linear equations – Gauss-Seidel convergence and relaxations
-Solving systems of non-linear equations – Newton and Fixed-point
-Differentiation: Taylor series and approximations
-Differentiation: first and second order differences: centred, forward and backward
-Integration: Lagrange interpolating polynomials
-Integration: Trapezoidal, Simpson’s 1/3, Simpson’s 3/8 Rules
-Integration: Composite rules

Advanced Numerical Methods
-Introduction to ODE’s and PDE’s
-Solving ODE’s – Initial Value Problems: Euler and Runge-Kutta
-Solving ODE’s – Boundary Value Problems: Shooting Method, Finite Differences
-Solving ODE’s – Finite Differences for linear BVP: Gauss and Thomas
-Solving ODE’s – Finite Differences for non-linear BVP: Newton-Raphson, Gauss-Seidel
-Solving PDE’s – Discretization and transformation into SODE
-Solving PDE’s – Application to Elliptic and Navier-Stokes
-Solving PDE’s – SEDO’s Stiff problems: Runge-Kutta and Predictor/Corrector methods.

Extra information

Not required, but better to have access to a computer with Excel.

Location

Online via webcam

General info

Age:
Teenagers (13-17 years old)
Adults (18-64 years old)
Seniors (65+ years old)
Student level:
Beginner
Intermediate
Advanced
Duration:
60 minutes
The class is taught in:English, French, Portuguese

About Me

Doctor in Chemical Engineering
Specialised in programming, modelling and numerical methods

2022 – present | Senior CFD Researcher | University of Porto
Chaotic Flow Analysis for New Technology Development

2019 – 2022 | CFD Researcher | University of Porto
Mixing and Controlled Combustion

2017 – 2019 | CFD Researcher| University of Porto
Novel Lagrangian Algorithms for Flow Analysis

2016 – 2017 | Researcher | University of Porto
Evolutionary Algorithms for Process Optimisation

Education

Ph. D. Degree
2022 Ph. D. in Chemical and Biological Engineering
Faculdade de Engenharia da Universidade do Porto, Portugal

M. S. Degree
2017 M. S. in Chemical Engineering – Process and Product
Faculdade de Engenharia da Universidade do Porto, Portugal

Internship Program
2016 Algorithm Development for the Production of Carbon Nanofibers
École Nationale supérieure des Industries Chimiques, Nancy, France

Experience / Qualifications

8 years of experience:

Chaotic Flows: Strange Attractors & Poincaré Maps
Heat Transfer Analysis
Lagrangian Programming
Reactor Design
High-Performance Computing
Lean Controlled Combustion
Hydrogen Combustion
Particles Swarm Optimisation
Process Simulation
Cyclic Adsorption Modelling

Ask a question

Send a message explaining your needs and Joana will reply soon:
The more detail, the better.
Ex. "Hi, when are you available to meet for a lesson?"

Availability of a typical week

(GMT -05:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3              
4              
5              
6              
7  Monday at 7:00  Tuesday at 7:00  Wednesday at 7:00  Thursday at 7:00  Friday at 7:00  Saturday at 7:00  Sunday at 7:00
8  Monday at 8:00  Tuesday at 8:00  Wednesday at 8:00  Thursday at 8:00  Friday at 8:00  Saturday at 8:00  Sunday at 8:00
9  Monday at 9:00  Tuesday at 9:00  Wednesday at 9:00  Thursday at 9:00  Friday at 9:00  Saturday at 9:00  Sunday at 9:00
10  Monday at 10:00  Tuesday at 10:00  Wednesday at 10:00  Thursday at 10:00  Friday at 10:00  Saturday at 10:00  Sunday at 10:00
11  Monday at 11:00  Tuesday at 11:00  Wednesday at 11:00  Thursday at 11:00  Friday at 11:00  Saturday at 11:00  Sunday at 11:00
12  Monday at 12:00  Tuesday at 12:00  Wednesday at 12:00  Thursday at 12:00  Friday at 12:00  Saturday at 12:00  Sunday at 12:00
13  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00  Friday at 13:00  Saturday at 13:00  Sunday at 13:00
14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00  Friday at 14:00  Saturday at 14:00  Sunday at 14:00
15              
16              
17              
18              
19              
20              
21              
22              
23              
from 30€Online via webcam

Good-fit Instructor Guarantee


If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.

Online reputation

  • Instructor since July 2023
  • Google connected

Availability of a typical week

(GMT -05:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3              
4              
5              
6              
7  Monday at 7:00  Tuesday at 7:00  Wednesday at 7:00  Thursday at 7:00  Friday at 7:00  Saturday at 7:00  Sunday at 7:00
8  Monday at 8:00  Tuesday at 8:00  Wednesday at 8:00  Thursday at 8:00  Friday at 8:00  Saturday at 8:00  Sunday at 8:00
9  Monday at 9:00  Tuesday at 9:00  Wednesday at 9:00  Thursday at 9:00  Friday at 9:00  Saturday at 9:00  Sunday at 9:00
10  Monday at 10:00  Tuesday at 10:00  Wednesday at 10:00  Thursday at 10:00  Friday at 10:00  Saturday at 10:00  Sunday at 10:00
11  Monday at 11:00  Tuesday at 11:00  Wednesday at 11:00  Thursday at 11:00  Friday at 11:00  Saturday at 11:00  Sunday at 11:00
12  Monday at 12:00  Tuesday at 12:00  Wednesday at 12:00  Thursday at 12:00  Friday at 12:00  Saturday at 12:00  Sunday at 12:00
13  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00  Friday at 13:00  Saturday at 13:00  Sunday at 13:00
14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00  Friday at 14:00  Saturday at 14:00  Sunday at 14:00
15              
16              
17              
18              
19              
20              
21              
22              
23              
from 30€Online via webcam

Good-fit Instructor Guarantee


If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.

Share

You are here


Matías
Experienced teacher offers courses in mathematics, physics and engineering
Do you aspire to master mathematics, physics and engineering at a university level? Do you want to exceed your limits and excel in these demanding fields? Do not search anymore ! Our tailor-made private lessons are there for you. Why choose our courses? Unparalleled Expertise: Our professors are experts in their field, with extensive experience in university teaching. They are ready to guide you towards success. Personalized Program: We tailor each course to your specific needs, from understanding fundamental concepts to solving complex problems. Total Flexibility: Choose the schedule that suits you best. Whether you are an active student or a professional, we adapt to your schedule. Constant Support: You will benefit from continuous monitoring between classes to answer all your questions and concerns. Quality Teaching Materials: We provide high-quality learning resources to support your progress. Who can benefit from our courses? High school students preparing for their baccalaureate or entrance exams to engineering schools. University students pursuing a degree in mathematics, physics or engineering. Professionals looking to acquire or deepen technical skills. Join us today! Excellence doesn't wait. Contact us now to book your first lesson. Together we will build a bright future based on a solid understanding of mathematics, physics and engineering.

Ayoub
Specialized Courses for Higher Education Students - CPGE, INSA, INP, ECE...
This preparation session is dedicated to students aiming for preparatory classes for scientific Grandes Ecoles (CPGE), with a particular focus on the subjects of Physics and Engineering Sciences. The goal is to strengthen the foundations and deepen the knowledge to succeed. 1. Mechanics: Kinematics: Study of rectilinear and circular movements, position vectors, speed and acceleration. Dynamics: Newton's laws, work and energy, kinetic energy theorem. 2. Electromagnetism / Electrokinetics: Electrostatics: Electric charges and fields, electric potential, capacitance. Magnetostatics: Magnetic fields, Lorentz forces, electromagnetic induction. Alternating Currents: RLC circuits, resonance, impedance. 3. Thermodynamics: Principles of thermodynamics: Internal energy, heat, work, first and second principles. Ideal and real gases: Equations of state, thermodynamic transformations. 4. Industrial sciences: Automatic Linear, Kinematic, Static. For more information and to register for the preparation session, please contact me. Good preparation and success in your studies! .

Marcos
Preparation for TU Delft Aerospace Engineering entrance exam
TU Delft is Europe's most prestigious university for aerospace studies, preparing some of the best engineers. However the selection procedure is tough and demanding, and only those prepared have a chance to succeed. As a TU Delft student, I know from first hand how stressfull this process is, and can therefore help you succeed in the preparation of these exams. I have previous experience as a tutor back in high school, helping students improve their grades from Cs to As. Moreover, I have an extensive knowledge on the subjects tested on these exams, having taken them myself and having completed the courses at university with excellent grades. Throughout the class, I will use a presentation to explain the main concepts of each exam (Maths, Physics and Aerospace Engineering), focusing on those subjects the student is struggling with most. After this, I will help the student complete some practice excercises, and then assign extra practice to complete on their own time. These exercises will then be reviewed in the following class to ensure the topics have been understood. I am looking forward to help you in your journey as an aerospace engineer!

Roland
Aerospace Engineering TU Delft - Selection Exam Preparation
The TU Delft Aerospace Engineering Bachelor is one of the most prestigious bachelor programmes the Netherlands has to offer. With it being highly sought-after by students all around the globe, there is a highly competitive selection procedure which needs to be completed to get admitted to this popular degree. A massive part of this admission procedure is the selection exam, consisting of three different tests: Mathematics, Physics and First-Year Material. As a cum laude graduated Aerospace Engineer at TU Delft, who has also been tutoring since 2017, I have a lot of valuable experience and knowledge of the program to help you out with the right preparation to get in. Moreover, after having successfully helped two international students get a spot last year, I have decided to continue preparing an additional custom lesson plan for each student, with the admission syllabus as its basis. With my calm and stepwise explanation, weaker topics will be addressed and your solution procedures will be polished. Each lesson will either be theory, exercise-based or an opportunity to talk about the admission, what to expect from the study and whether it is a right fit for you.

Abdeer
Mechanical Engineering and Mechanical Construction for CPGE, INSA, INP, ECE...
Graduated from the external aggregation of Industrial Sciences, I offer courses in: * Course of the mechanical modules of solids. * Rational mechanics course. For schools and technical faculties * RDM and MMC courses * Mechanical construction course * Course of industrial computing modules

Youssef
Math, Physics and Engineering Private tutoring Classes.
I am a 24 year old mechatronics engineer with years of teaching experience. I am to teaching any Math, Physics or any engineering related univeristy course. Bringing forth a deep passion for explaining and making my knowledge easily understanble to everyone.

Anh
Engineering Tutoring with Mentoring: Easy and Effective! - Aerospace/Mechanical/Electrical Engineering
In these Engineering Classes, I guide, mentor, and facilitate your growth and intuitive technical understanding. I share my experiences with Aerospace/Aeronautical/Mechanical/Electrical Engineering, helping you develop your skills and techniques to tackle any problem, whilst adapting our lessons to your natural method of learning. Contact me here to introduce yourself and tell me more about the topics that you would like additional support with. This could be, for example, Aero/ Flight Dynamics, Control Systems, Dynamic Structures, Business Data Analysis, or any other topics. Whatever university you are studying at, I am certain that you will leave our sessions fulfilled, inspired, and driven to take on any challenge that may come your way. Contact me now for my availability, so that we can organize your first session as soon as possible. I look forward to meeting you! __________________________________________________________________________________ Previously supported students from top universities such as: UK: - Imperial College London (+ Business School) (ICL) - University College London (UCL) - King's College London (KCL) NL: - Delft University of Technology (TUDelft) - University of Amsterdam - University of Groningen SW - ETH Zurich - Swiss Federal Institute of Technology AU - Queensland University of Technology - University of Queensland - Griffith University __________________________________________________________________________________ A little about myself: My name is Anh; I was born and raised in the U.K. and I have over 8 years of international experience, tutoring Middle School to University Level Maths, Sciences, and Engineering, with 4 years of working experience in the Aerospace and Maritime industry. I have a fun, ambitious, and outgoing personality with a passion for music, cooking, and trying new things. Whilst teaching and mentoring, I am patient and adaptable to the needs of each of my students. I am working as an Engineering Specialist/Consultant, holding: - a degree as a Master of Aeronautical Engineering from Imperial College London, - A*A*A* A-Level Further Maths and Physics, with, - straight A*s in (GCSE) Maths, Physics, Chemistry, Biology, English, Geography. I was also previously mentored and tutored myself and having been through the problems and achievements first-hand, I want to help others do so as well.

Paloma
Rendering of your designs, with sketchup and lumion consult
The amount of time required to book on the platform for rendering your ideas depends on the scale and level of detail of the render -------------------------------------------------- ----------- Depending on the needs of the student, the number of hours that must be booked by the platform to carry out the renderings and 3d modeling is calculated.

Kirill
Lean Six Sigma & Kaizen: Trainings & Tools for Champions, Problem Solving Tools, 5S Basic training.
You will learn the DMAIC cycle, a proven method that helps solve problems by first identifying the causes before devising and implementing solutions. You will receive a set of practical recommendations, methodological materials, forms, and templates to integrate into your organization. As a result, you'll observe the outcomes and effectiveness of the approach, which you can adapt as needed during its application.

Jeremy
Physics & Maths Lessons! - Experience with Belgian and EU Baccalaureate, IB, CCVX, University Applications & Learning Disabilities
Hi, My name is Jeremy and I have a Master's in Physics with honors from the University of Leicester (which was featured as a top 5 Physics university in the UK by The Guardian) and a - french - European School diploma in which I achieved 90% in Physics and 85% in Maths. Helping others understand difficult topics and skills is something that I am very passionate about as an empathetic person. I have experience teaching Physics and Maths to kids from unprivileged backgrounds at the homework school in Saint-Gilles (CASG du Service Social Juif asbl) as well as 4 years of private teaching. In my classes, I aim to: - help students achieve better grades in exams/tests in all branches of Physics & Maths - clearly explain and break down topics - give context and or example applications of topics (to improve understanding and memorization) - help with ADHD & other learning disabilities - give practical advice for university applications (eg. UCAS in the UK) and discuss the exciting Physics research/work and projects you can work on later in life Physics has a plethora of useful and fascinating applications, from the detection of Gravitational Waves and Gamma-Ray Bursts to the development of novel Medical Imaging techniques and Nano-technology (eg: smartphones). It is a subject that I am very passionate about and I hope to make use of my years of experience and extensive knowledge to help you understand and love the subject! My lessons will always be tailored to the individual needs of the student, so please do not hesitate to contact me if you have questions!

Dosumu
Science and Engineering for college and university students
Dive into the dynamic world of engineering and science with this comprehensive course designed for aspiring engineers and scientists. This course is structured to provide you with a robust foundation in key principles and practices that are essential in these fields. You'll explore fundamental concepts in physics, chemistry, and mathematics, and learn how to apply these principles to solve real-world problems. The course covers critical topics such as mechanics, thermodynamics, materials science, and electrical circuits. In addition to theoretical knowledge, you'll engage in hands-on projects and experiments that illustrate practical applications. You'll develop skills in data analysis, experimental design, and technical communication, preparing you for advanced study or a career in engineering and science. Join us to unlock the potential of engineering and science, and start your journey towards innovation and discovery.

Nezhla
Mathematics and Physics and engineering in all levels
I have a Phd and I am postdoc researcher in in the field of Mathematics and Physic. I have several teaching experiences at university , high schools and in Africa, I can teach math and physics in a very differnt way that you never forget it. because I did several years of research which gives different perspective than being only a teacher.

Leo
Photorealistic 3D computer graphics and modeling for amateurs, hobbyists or professionals
In this course, you will learn how to create photorealistic renderings using Blender software. This free and open-source software has seen its notoriety skyrocket in recent years, as it offers tools and results similar to what is done on standard and paid software such as 3d Studio Max or Maya, all in one interface. intuitive and ergonomic workflow. In this course, you will be able to learn: -The basics of 3D modeling and 3D in general -Materials (shaders) -The highlighting -Renderings -Post production Gradually, we will solidify these skills to learn how to create entire scenes, representing environments, objects, and buildings. It is also possible to present your projects to me and to obtain personalized help on them.

Nicolas
Aerospace Engineering TU Delft - entrance exam preparation
As a second-year student in the BSc Aerospace Engineering program at the Technical University of Delft (TU Delft), I have experience with the university entrance process as well as being qualified to explain the curriculum and requirements in depth. necessary. In addition to offering guidance on the essential topics for your entrance exam, I can provide you with personalized classes for in-depth preparation. These classes would include a detailed review of key concepts, intensive practice with relevant exercises, and specific tips to effectively approach the exam. My goal is to help you acquire the confidence and skills necessary to be successful in the admissions process in addition to the first year material that may seem a little more difficult or unknown. Additionally, I will be happy to discuss with you the study program itself, as well as explore the various opportunities available in Delft to complement your academic experience.

Youssef
engineering sciences, electrical circuit, electrical engineering, programming, electronics, automation, physics
===================Satisfied or refunded======================= Hello, I am a doctoral student in electrical engineering and associate professor in engineering sciences, experienced in the field of electrical engineering, I offer courses in engineering sciences (Electronics, automatics, electrical engineering, automation, programming). Computational Sciences and Technology SNT IS engineering sciences Numerical and computer science SNI Digital electronics Analog electronic electromagnetism Signal processing and data acquisition Automatic (discrete, continuous) electrical engineering (transformers, electrical machines, switching power supply) C/C++ Programming, Assembler, ARM, STM32 renewable energy (wind, PV-solar) RDM - strength of materials mechanics of solids Python and SYSML PIC microcontroller Microprocessor MATLAB, proteus Preparation for competitions Supervision of graduation projects CAPLP Electrotechnical and Electronic Electrical Engineering CAPLP and BTS subjects and answers Correction caplp 2017 CAPLP 2018 CAPLP 2019 CAPLP 2020 CORRECTION OF BTS TESTS