Overview

We will cover (at least) the following:

General elements of programming (exemplified in Visual Basic):

1. Planning your program: What is the problem? How am I going to solve it? How can I break the solution down into steps?
2. Variables and Data types: How to declare, use and manipulate numbers, strings, arrays, lists, and (VB) objects.
3. Assigning values: How to give a variable a value.
4. Scope of variables: local and global variables.
5. Arithmetic operations: how to add, subtract, multiply etc
6. Simple string manipulations, e.g., concatenation. How to handle and manipulate file names.
7. Collections of data: Creating and processing Lists and Arrays.
8. Subroutines and functions: What they are for, and the difference between them. Passing arguments to and returning values from functions.
9. If... then ...else .. End if statements. How to make a conditional statement.
10. Loops: doing something repeatedly: a. For ... Next loops: doing the thing some number of times b. Do Until ... Loop, Do While ... Loop: doing the thing until (or while) some condition is fulfilled.
11. Basics of “Object-oriented” programming. Object hierarchies. Object.Method, Object.Property.

Visual interface programming

1. Use of the VB programming environment,.
2. Graphical user interface (GUI) design.
3. Controls: what are they? Controls as objects.
4. VB Forms, placing controls on forms, naming controls. Changing properties of controls.
5. The object.method and object.property syntax.
6. How to manipulate common VB controls: Command buttons, text boxes, list boxes, labels, frames, option (radio) buttons, check boxes, data tables, progress bars etc.
7. Standard methods for the common controls. Linking controls to the underlying program.
8. File input/output; reading data from a file. Using file dialogs to Open and Save files.

Visual Basic for Applications (VBA): Use in Excel

1. Starting VBA in Excel: The programming interface
2. Linking VBA to the Excel worksheet.
3. The Excel object model: Workbooks, Worksheets, Ranges, Cells.
4. VBA program modules, and the VBA UserForm.
5. Programming data manipulation in Excel with VB.

Learning Outcomes

• Design and program a Windows-type user interface, using a variety of common controls (found in Visual Basic)

• Learn to automate data analyses and other operations in Excel, using Visual Basic for Applications.

• Students will gain an understanding of the central constructs and techniques employed in most computer programming; they will learn to employ these techniques to handle and manipulate data. Students will also acquire skills in visual interface design, allowing other people to easily use their programs.