Recent Submissions

  • 7.1 - Trapezoidal Rule 

    Shams El-Din El-Fouly; Siddharth Misra (7/19/18)
    In 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.
  • 7.2 - Simpson's 13 Rule 

    Shams El-Din El-Fouly; (7/20/18)
    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 ...
  • 1.2 - Functions & Variables 

    Shams El-Din El-Fouly; Siddharth Misra (6/4/18)
    In 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 program
  • 1.1 - Getting Started with Excel 

    Shams El-Din El-Fouly; Siddharth Misra (6/1/18)
    In 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 program
  • 7.3 - Romberg Integration 

    Shams El-Din El-Fouly; Siddharth Misra (7/26/18)
    In 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 ...
  • 7.5 - High Accuracy Vs. Conv. Centered (1st & 2nd Derivatives) 

    Shams El-Din El-Fouly; Siddharth Misra (7/23/18)
    In 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 approximations
  • 7.4 - Conv. Forward Vs. Conv. Centered (1st & 2nd Derivative) 

    Shams El-Din El-Fouly; Siddharth Misra (7/23/18)
    In this lesson you'll learn about how to approximate derivatives using the conventional forward and centered finite difference approximations
  • 1.8 - Inbuilt Functions 

    Shams El-Din El-Fouly; Siddharth Misra (6/12/18)
    In this lesson you'll learn about some the most useful and common EXCEL/VBA inbuilt functions used in numerical methods
  • 8.1 - Euler's Method 

    Shams El-Din El-Fouly; Siddharth Misra (7/27/18)
    In 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 Method
  • 1.3 - ForNext & Dowhile Loops 

    Shams El-Din El-Fouly; Siddharth Misra (6/5/18)
    In this lesson you'll learn about the repetition structure in VBA. This will include the ForNext Loop and the DoWhile Loop
  • 1.5 - If-Then-Else 

    Shams El-Din El-Fouly; Siddharth Misra (6/6/18)
    In this lesson you'll learn about the decision structure of VBA Programming and that the if-then-else statement.
  • 1.6 - Factorial 

    Shams El-Din El-Fouly; Siddharth Misra (6/7/18)
    In this lesson we'll use what we have learned previously to create a factorial code capable of generating the factorial of any number
  • 1.7 - Area & Perimeter of a Square 

    Shams El-Din El-Fouly; Siddharth Misra (6/7/18)
    In 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 perimeter
  • 1.4 - Nested Loops 

    Shams El-Din El-Fouly; Siddharth Misra (6/6/18)
    In this lesson you'll learn about how created a nested loop where a loop is imbedded within another loop
  • 2.1 - Taylor Series & Exp(x) 

    Shams El-Din El-Fouly; Siddharth Misra (6/15/18)
    In this lesson you'll learn about what Taylor Series are and how to approximate the Exp(x) function using Taylor Series
  • 3.3 - Newton Raphson & Secant Methods & How they compare 

    Shams El-Din El-Fouly; Siddharth Misra (6/21/18)
    In 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 ...
  • 3.1 - Bisection Method 

    Shams El-Din El-Fouly; Siddharth Misra (6/21/18)
    In 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.
  • 3.2 - False Position & How it Compares to Bisection Method 

    Shams El-Din El-Fouly; Siddharth Misra (6/21/18)
    In 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 Method
  • 2.3 - Taylor Series of Exp(3x) around 2 

    Shams El-Din El-Fouly; Siddharth Misra (6/18/18)
    In this lesson you'll learn about how to develop a VBA code to approximate Exp(3x) around a = 2
  • 2.2 - Taylor Series & f'(x) 

    Shams El-Din El-Fouly; Siddharth Misra (6/15/18)
    In this lesson you'll learn about how to approximate derivatives using Taylor Series

View more