OU - OER - Ancillary Materials

Permanent URI for this collection

https://hdl.handle.net/11244/302094

Browse

Browsing OU - OER - Ancillary Materials by Title

Now showing 1 - 20 of 46
  • Thumbnail Image
    ItemOpen Access
    1.1 - Getting Started with Excel
    (6/1/18) Shams El-Din El-Fouly; Siddharth Misra
    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
  • Thumbnail Image
    ItemOpen Access
    1.2 - Functions & Variables
    (6/4/18) Shams El-Din El-Fouly; Siddharth Misra
    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
  • Thumbnail Image
    ItemOpen Access
    1.3 - ForNext & Dowhile Loops
    (6/5/18) Shams El-Din El-Fouly; Siddharth Misra
    In this lesson you'll learn about the repetition structure in VBA. This will include the ForNext Loop and the DoWhile Loop
  • Thumbnail Image
    ItemOpen Access
    1.4 - Nested Loops
    (6/6/18) Shams El-Din El-Fouly; Siddharth Misra
    In this lesson you'll learn about how created a nested loop where a loop is imbedded within another loop
  • Thumbnail Image
    ItemOpen Access
    1.5 - If-Then-Else
    (6/6/18) Shams El-Din El-Fouly; Siddharth Misra
    In this lesson you'll learn about the decision structure of VBA Programming and that the if-then-else statement.
  • Thumbnail Image
    ItemOpen Access
    1.6 - Factorial
    (6/7/18) Shams El-Din El-Fouly; Siddharth Misra
    In this lesson we'll use what we have learned previously to create a factorial code capable of generating the factorial of any number
  • Thumbnail Image
    ItemOpen Access
    1.7 - Area & Perimeter of a Square
    (6/7/18) Shams El-Din El-Fouly; Siddharth Misra
    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
  • Thumbnail Image
    ItemOpen Access
    1.8 - Inbuilt Functions
    (6/12/18) Shams El-Din El-Fouly; Siddharth Misra
    In this lesson you'll learn about some the most useful and common EXCEL/VBA inbuilt functions used in numerical methods
  • Thumbnail Image
    ItemOpen Access
    2.1 - Taylor Series & Exp(x)
    (6/15/18) Shams El-Din El-Fouly; Siddharth Misra
    In this lesson you'll learn about what Taylor Series are and how to approximate the Exp(x) function using Taylor Series
  • Thumbnail Image
    ItemOpen Access
    2.2 - Taylor Series & f'(x)
    (6/15/18) Shams El-Din El-Fouly; Siddharth Misra
    In this lesson you'll learn about how to approximate derivatives using Taylor Series
  • Thumbnail Image
    ItemOpen Access
    2.3 - Taylor Series of Exp(3x) around 2
    (6/18/18) Shams El-Din El-Fouly; Siddharth Misra
    In this lesson you'll learn about how to develop a VBA code to approximate Exp(3x) around a = 2
  • Thumbnail Image
    ItemOpen Access
    3.1 - Bisection Method
    (6/21/18) Shams El-Din El-Fouly; Siddharth Misra
    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.
  • Thumbnail Image
    ItemOpen Access
    3.2 - False Position & How it Compares to Bisection Method
    (6/21/18) Shams El-Din El-Fouly; Siddharth Misra
    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
  • Thumbnail Image
    ItemOpen Access
    3.3 - Newton Raphson & Secant Methods & How they compare
    (6/21/18) Shams El-Din El-Fouly; Siddharth Misra
    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 False position methods
  • Thumbnail Image
    ItemOpen Access
    3.4 - Newton Raphson using different guesses
    (6/26/18) Shams El-Din El-Fouly; Siddharth Misra
    In this lesson you'll learn about the effect of using different educated guesses on the output root of the function
  • Thumbnail Image
    ItemOpen Access
    3.5 - Multiple Roots
    (6/28/19) Shams El-Din El-Fouly; Siddharth Misra
    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.
  • Thumbnail Image
    ItemOpen Access
    3.6 - Right Circular Cone
    (6/27/18) Shams El-Din El-Fouly; Siddharth Misra
    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.
  • Thumbnail Image
    ItemOpen Access
    3.7 - Goal Seek and Solver
    (7/6/18) Shams El-Din El-Fouly; Siddharth Misra
    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.
  • Thumbnail Image
    ItemOpen Access
    4.1 - Vectors, Matrices & Arrays
    (6/26/18) Shams El-Din El-Fouly; Siddharth Misra
    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 a 3 x 3 matrix to store nine numbers and display it back.
  • Thumbnail Image
    ItemOpen Access
    4.2 - Addition, Multiplication & Transposition of Matrices
    (6/28/18) Shams El-Din El-Fouly; Siddharth Misra
    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