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.

Assessment Strategy

-threshold - (C) Adequate answer to the question, largely based on lecture material. No real development of arguments.

-good - (B) Reasonably comprehensive coverage. Well organised and structured. Good understanding of the material.

-excellent - (A) Comprehensive and accurate coverage of the area clarity of argument and expression. Depth of insight into theoretical issues

Learning Outcomes

• Students will gain an understanding of the central concepts and techniques employed in computer programming, via the language Python.

• Students will learn about coding in Jupyter notebooks, and may be able to submit assignments in this form.

• Students will learn how to handle and manipulate data in computer code for the purposes of data analysis and graphing of results. They will be introduced to Python libraries, e.g., Numpy, Matplotlib, Pandas, which are widely used data analysis and data sciance.

• Students will learn how to visually present data and results programmatically.

• Students will learn how to visually present data using the Microsoft Power BI tool (incorporating Python code).