4.0 Structured Programming, Recursion, Recording Macro, Flowcharts

Question 1

two approaches to terminate loops

Do/Loop Structure

Answer 1

1. decision loops
   A. Do/If Exit
   * terminated if condition is TRUE
   B. Do While
   * used when repetition is required while a condition is TRUE
   * eg. when calculating summation of terms in infinite series, we want to continue adding
   terms while absolute value of term T is larger than assumed tolerance Tol
   Do While (Abs(T) >= Tol) Statements
   Loop
   while this condition met, statements executed after no longer TRUE, program continues on
2. count-controlled loops
   ▪ pre-set to repeat a fixed number of times
   A. Do/If Exit
   B. For/Next
   -more efficient

Question 1

Do/Loop Structure

Answer 1

want to execute statement or group of statements many times
-infinite loop = a loop that never ends
- two approaches to terminate loops

Question 2

Recursion

Answer 2

recursion process = a process that calls itself
- eg. factorial calculation is a mathematical recursion
- can develop both non-recursive and recursive functions to compute factorials in VBA
* in Excel
▪ can use FACT(number)
* inVBA
▪ can use WorksheetFunction.FACT(number)

Question 3

Recording Macros

Answer 3

use to learn how to write VBA code to plot graphs and diagrams