Browsing OU - OER - Ancillary Materials by Title

Now showing items 7-26 of 46

    • 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.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

    • 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

    • 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

    • 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

    • 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

    • 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.4 - Newton Raphson using different guesses 

      Shams El-Din El-Fouly; Siddharth Misra (6/26/18)
      In this lesson you'll learn about the effect of using different educated guesses on the output root of the function

    • 3.5 - Multiple Roots 

      Shams El-Din El-Fouly; Siddharth Misra (6/28/19)
      In this lesson you'll learn about the Modified Newton Raphson Method to deal with Multiple Roots and How to develop a VBA code to implement this technique to any desired approximate error.

    • 3.6 - Right Circular Cone 

      Shams El-Din El-Fouly; Siddharth Misra (6/27/18)
      In this lesson you'll learn about how to apply the Newton Raphson Technique to find the root of a 2D right circular cone function.

    • 3.7 - Goal Seek and Solver 

      Shams El-Din El-Fouly; Siddharth Misra (7/6/18)
      In this lesson you'll learn about how to use Excel's inbuilt root finding functions–goal seek for simple 1D function and Solver for multivariable functions.

    • 4.1 - Vectors, Matrices & Arrays 

      Shams El-Din El-Fouly; Siddharth Misra (6/26/18)
      In this lesson you'll learn about what an array is and the difference between a vector and a matrix. You’ll then create a vector to store ten elements and display it back onto an Excel sheet. Finally, you’ll learn to create ...

    • 4.2 - Addition, Multiplication & Transposition of Matrices 

      Shams El-Din El-Fouly; Siddharth Misra (6/28/18)
      In this lesson you'll learn about addition, multiplication and transposition to two matrices in addition to what a Principle Diagonal, Principal anti-diagonal, identity and unit matrices

    • 4.3 - Gauss Elimination with Partial Pivoting 

      Shams El-Din El-Fouly; Siddharth Misra (7/5/18)
      In this lesson you'll learn about how to solve a system of equations using gauss elimination with Partial Pivoting and how to develop a gauss elimination with Partial Pivoting VBA Code

    • 4.4 - Gauss Jordan 

      Shams El-Din El-Fouly; Siddharth Misra (7/4/18)
      In this lesson you'll learn about how to solve a system of equations using gauss Jordan and how to develop a gauss Jordan VBA Code.

    • 4.5 - LU Decomposition 

      Shams El-Din El-Fouly; Siddharth Misra (7/2/18)
      In this lesson you'll learn about how to solve a system of equations using LU Decomposition and how to develop a LU Decomposition VBA Code

    • 4.6 - LU Decomposition by generating Inverse A 

      Shams El-Din El-Fouly; Siddharth Misra (7/3/18)
      In this lesson you'll learn about how to solve a system of equations using LU Decomposition by generating A inverse and how to develop a LU Decomposition A inverse VBA Code

    • 4.7 - Debugging a Multiplication Code 

      Shams El-Din El-Fouly; Siddharth Misra (7/4/18)
      In this lesson you'll learn about the common debugging issues that arise when programming numerical methods and how to best solve them and avoid them in the future.

    • 5.1 - Introduction to Optimization & Analytical Sol. 

      Shams El-Din El-Fouly; Siddharth Misra (7/9/18)
      In this lesson you'll learn about optimization, minimums, maximums, and a saddle. You’ll learn the difference between a local and global optima, the Second Derivative Test, contour lines, and how to graph a 2D function in Excel.