IS 201 VBA

Software Development Life Cycle (SDLC)

A process for planning, creating, testing, and deploying information systems.

Waterfall Methodology

A linear SDLC approach where each phase must be completed before moving to the next.

Agile Methodology

An iterative SDLC approach that emphasizes flexibility and customer feedback.

COTS (Commercial off-the-shelf)

Pre-built software solutions that can be purchased and integrated into an organization.

Trade-off between quality constraints

The balancing act between quality, time, and cost during the SDLC.

Flowchart

A visual representation of a process, showing the steps and flow of control.

Flowchart Symbols

Standard shapes used in flowcharts such as ovals for start/end, rectangles for processes, and diamonds for decisions.

Input-Processing-Output Model

A model that describes the transformation of inputs into outputs through processing.

Locals Window

A feature in programming environments that displays the current values of local variables.

Syntax Error

An error in the code due to incorrect syntax that prevents the program from running.

Logic Error

A runtime error that occurs when the program runs but produces incorrect results.

Option Explicit

A statement in VBA that requires all variables to be declared before use.

Variable

An element in programming used to store data values.

Data Type - Integer

A data type that stores whole numbers.

Data Type - String

A data type that stores sequences of characters.

Data Type - Long

A data type that stores larger whole numbers compared to integers.

Data Type - Variant

A data type that can hold any type of data.

Data Type - Range

A data type that represents a cell or group of cells in Excel.

Data Type - Double

A data type that stores floating-point numbers.

Macro Recorder

A tool that records a sequence of actions in Excel for automation.

MsgBox Function

A function used to display a message box to the user in VBA.

Comment in VBA

Text added to the code that is not executed but explains the code to the reader.

ActiveCell

The currently selected cell in Excel.

DoEvents

A VBA function that allows the operating system to process other events during code execution.

Loop - For...Next

A control structure that repeats a block of code a specific number of times.

Loop - Do...Loop

A control structure that repeats a block of code while a condition is met.

Hard Coding

The practice of embedding fixed values directly into source code.

Increment a Counter in a Loop

To increase the value of a counter variable each time through the loop.