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.