Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
9 Hour(s) 44 Minute(s)
Language
English
Taught by
Shams El-Din El-Fouly
Rating
Course Overview
Learn the workings of the most common numerical methods and a step by step process on how to program each of them
Numerical modeling is a very powerful branch of mathematics. It is capable to solve very complex problems using very simple techniques.
It is a branch that can differentiate and integral without the need to use any of the sometimes complex differentiation and integration rules. It can create best fit models with just knowing a data set. It can create functions where the only thing we know is its derivative and a condition. And best of all, it can generate approximations that have such a low percentage error that they are as good as the true value.
But...
There is a limitation to numerical methods. They depend of iterative calculations. If for example you want an approximation with a low error, for example 0.001%, this will require a large amount of calculations which can be sometimes impossible to do by hand not to mention tedious. This is where programming comes in.
In this course I will walk you through not only the workings of each technique but a step by step process on how to program each of these techniques and preform hundreds if not thousands of calculations with a click of a button using one of the most powerful softwares created, EXCEL. And I'll be using excel's inbuilt programming language, VBA.
The great thing about programming languages is they all follow the same programming structure, sequence, repetition and decision making. Meaning, if you know one language you can learn another very easily by just knowing how these structures are defined in the new language.
In this course you'll have a very good grasp of these structure so if you decide to learn another language afterwards it will be very easy.
This project was a means for me to give back and contribute. I hope you find some value in this course.
Thank you and Enjoy!!
Course Content
- 9 section(s)
- 42 lecture(s)
- Section 1 VBA Crash Course
- Section 2 Taylor Series & Functions
- Section 3 Numerical Differentiation
- Section 4 Numerical Integration
- Section 5 Ordinary Differential Equations
- Section 6 Roots of Equations
- Section 7 Optimization
- Section 8 Linear Algebraic Equations
- Section 9 Curve Fitting
What You’ll Learn
- Program using VBA Programming Language, Approximate functions using Taylor series expansions, Approximate derivatives using conventional and high accuracy formulas, Approximate integrals using Trapezoidal rule, Simpson's 1/3 rule and Romberg integration, Find roots of equations using bisection, False position, newton Raphson and secant methods, Find analytically the optimum min and max of a function, Solve Ordinary differential Equations using Runge Kutta Methods (i.e. Euler, Heun's, Midpoint and Ralston Methods in addition to fourth order Runge Kutta Method, Find numerically the optimum min and max using Golden section Search method, newton Raphson Technique and finally the gradient decent/ascent method, Solve Systems of Equations using Gauss elimination, Gauss Jordan and LU Decomposition and generate inverse matrices, Perform curve fitting using regression analysis including linear and polynomial regression in addition to linearization for fitting more complex functions, Perform curve fitting using Cubic Spline
Skills covered in this course
Reviews
-
XXeniya Gvozdeva
I believe, for those who has already some experience working with whatever programming languages, there should be the separation like: the first part - intro "You may skip this part if You already know what are sequence, loops and decision making in programming and go directly to the second part" ; and the second part - implementation of everything in VB. I use a udemy course for the first time, so I'm not sure about whether it is possible at all to create some exercises/tests/exams but even though the material is explained brilliantly and I stop the video to try to write a code by myself, still, I feel the lack of practice. It would be nice to have some extra functions to deal with them by ourselves and then compare the results with the correct ones. Other than this, sometimes when I coded something I encountered the trouble with division by zero or forgot to include something important into my code so that everything just crushed without any chance to recover my excel and my code, and I believe it would be nice to make students beware of it in the beginning and include some precautionary parts of code so that if-then prevents cases when there is division by zero and also when we reach maximum number of iterations, the program can stop. But it's just a suggestion based on my own experience.
-
PPreeda Prakotmak
Very good
-
SSimone Agostinelli
Thank to my theoretical knowledge I had few difficulties in understanding the course. I enjoyed the explanation of each step and loop, especially because it allowed me to understand steps and learn new numerical applications topics which I hadn't during my academic path.
-
WWilliam Dennis
Glad I took it. Very good.
