Browse
Recent Submissions
Item Open Access 7.1 - Trapezoidal Rule(7/19/18) Shams El-Din El-Fouly; Siddharth MisraIn this lesson you'll learn about how to approximate an area under the curve using the Trapezoidal rule and how to develop a VBA code to implement this technique to any desired approximate error.Item Open Access 7.4 - Conv. Forward Vs. Conv. Centered (1st & 2nd Derivative)(7/23/18) Shams El-Din El-Fouly; Siddharth MisraIn this lesson you'll learn about how to approximate derivatives using the conventional forward and centered finite difference approximationsItem Open Access 1.2 - Functions & Variables(6/4/18) Shams El-Din El-Fouly; Siddharth MisraIn this lesson you'll learn about the two possible programs written in VBA, functions and subroutines in addition to the use of variables in a VBA programItem Open Access 7.5 - High Accuracy Vs. Conv. Centered (1st & 2nd Derivatives)(7/23/18) Shams El-Din El-Fouly; Siddharth MisraIn this lesson you'll learn about how to approximate derivatives using the High Accuracy centered finite difference approximations and how it compares to the conventional finite approximationsItem Open Access 7.2 - Simpson's 13 Rule(7/20/18) Shams El-Din El-Fouly;In this lesson you'll learn about how to approximate an area under the curve using the Simpson's 1/3 Rule and how to develop a VBA code to implement this technique to any desired approximate error in addition to how the Simpson's 1/3 Rule compares to theItem Open Access 7.3 - Romberg Integration(7/26/18) Shams El-Din El-Fouly; Siddharth MisraIn this lesson you'll learn about how to approximate an area under the curve using Romberg Integration, how to develop a VBA code to implement this technique to any desired approximate error in addition to how Romberg Integration Compares to Simpson's 1/3Item Open Access 1.1 - Getting Started with Excel(6/1/18) Shams El-Din El-Fouly; Siddharth MisraIn this lesson you'll learn how to setup Excel for VBA programming, explain the most common features of the interface and how to save an Excel sheet with a macro programItem Open Access 1.6 - Factorial(6/7/18) Shams El-Din El-Fouly; Siddharth MisraIn this lesson we'll use what we have learned previously to create a factorial code capable of generating the factorial of any numberItem Open Access 1.3 - ForNext & Dowhile Loops(6/5/18) Shams El-Din El-Fouly; Siddharth MisraIn this lesson you'll learn about the repetition structure in VBA. This will include the ForNext Loop and the DoWhile LoopItem Open Access 8.1 - Euler's Method(7/27/18) Shams El-Din El-Fouly; Siddharth MisraIn this lesson you'll learn about the concept behind applying Euler's Method to solve Ordinary Differential Equations and learn how to write a VBA code to apply Euler's MethodItem Open Access 1.8 - Inbuilt Functions(6/12/18) Shams El-Din El-Fouly; Siddharth MisraIn this lesson you'll learn about some the most useful and common EXCEL/VBA inbuilt functions used in numerical methodsItem Open Access 1.5 - If-Then-Else(6/6/18) Shams El-Din El-Fouly; Siddharth MisraIn this lesson you'll learn about the decision structure of VBA Programming and that the if-then-else statement.Item Open Access 1.7 - Area & Perimeter of a Square(6/7/18) Shams El-Din El-Fouly; Siddharth MisraIn this lesson we'll use what we have learned previously to create a code to find which of 7 squares of different side length has magnitude of area equal to magnitude of perimeterItem Open Access 1.4 - Nested Loops(6/6/18) Shams El-Din El-Fouly; Siddharth MisraIn this lesson you'll learn about how created a nested loop where a loop is imbedded within another loopItem Open Access 3.2 - False Position & How it Compares to Bisection Method(6/21/18) Shams El-Din El-Fouly; Siddharth MisraIn this lesson you'll learn about the False Position method, how to develop a VBA code to implement this technique to any desired approximate error and how the False Position compares to the Bisection MethodItem Open Access 3.1 - Bisection Method(6/21/18) Shams El-Din El-Fouly; Siddharth MisraIn this lesson you'll learn about the different types of Root of Equations techniques, the bisection method and how to develop a VBA code to implement this technique to any desired approximate error.Item Open Access 3.3 - Newton Raphson & Secant Methods & How they compare(6/21/18) Shams El-Din El-Fouly; Siddharth MisraIn this lesson you'll learn about the Newton Raphson and secant Techniques, how to develop a VBA code to implement these techniques to any desired approximate error and how the open methods compares to both bisection and False position methodsItem Open Access 2.2 - Taylor Series & f'(x)(6/15/18) Shams El-Din El-Fouly; Siddharth MisraIn this lesson you'll learn about how to approximate derivatives using Taylor SeriesItem Open Access 2.1 - Taylor Series & Exp(x)(6/15/18) Shams El-Din El-Fouly; Siddharth MisraIn this lesson you'll learn about what Taylor Series are and how to approximate the Exp(x) function using Taylor SeriesItem Open Access 2.3 - Taylor Series of Exp(3x) around 2(6/18/18) Shams El-Din El-Fouly; Siddharth MisraIn this lesson you'll learn about how to develop a VBA code to approximate Exp(3x) around a = 2
- «
- 1 (current)
- 2
- 3
- »