IS 201 VBA

Big Quiz #3 (15.4 Programming) Focused Study Guide

SDLC - 6 questions

·       What are the unique benefits of the different SDLC methodologies?

o   Waterfall

o   Agile

o   Commercial off-the-shelf (pre-built)?

·       Understand the trade-off between quality constraints.

·       Understand what happens in each step in the SDLC cycle.

·       Understand each of the implementation conversions.

Flowcharts - 6 questions

·       Know the flowchart symbols. What is each symbol used for (MyEducator 10.4)?

·       Know the flowchart guidelines (MyEducator 10.5). Pay extra attention to the rules about how many flows can flow in and out of a symbol.

·       Understand the general purpose of flowcharts. What are the benefits of using them?

·       How does flowcharting relate to the SDLC?

·       Understand value assignments (MyEducator 10.6) 

Programming Principles - 13 questions

·       What is the purpose of the Locals Window?

·       What is a syntax error? 

·       What is a logic error? 

·       What is Option Explicit and why would we use it?

·       Understand what a variable is and how it stores values.

·       Understand the following data types:

o   Integers

o   String

o   Long

o   Variant

o   Range

o   Double

·       Understand how to declare variable data types.

·       Understand how the Input-Processing-Output model applies in VBA code.

·       Understand the purpose of a macro recorder.

·       Understand the purpose of custom functions and how they work.

·       Understand the types of inputs in VBA.

·       Understand the MsgBox function (MyEducator 11.3).

·       Understand the purpose and how to write comments in VBA.

·       Understand the purpose and how to use the following methods:

o   .Select

o   .Activate

o   .Offset()

·       Understand the purpose and how to use the following properties:

o   .Value

·       Understand the syntax and the purpose of the following conditionals:

o   If - Else - End If

o   If - ElseIf - End If.

·       Understand the purpose and how to use the ActiveCell.

·       Understand how to use:

o   .End(xldown)

o   .End(xlup)

o   .End(xlright)

o   .End(xlleft).

·       Understand what "hard coding" is and its pros and cons. 

·       Understand the purpose and how to increment a counter in a loop.

·       Understands the syntax and purpose of the following loops:

o   For...Next

o   For Each...Next

o   Do...Loop (Do While … Loop and Do Until …. Loop)

·       Understand the purpose of DoEvents.