CSCI 112 --- Application Programming

You can find the lecture notes as PDF files here.

The corresponding recorded lecture presentations will be posted on VIU Learn.

Lectures:

• Introduction - Computer
• Introduction - Data
• Introduction - Models
• Introduction - Excel
• Advanced Excel
• Excel Model Building
• VBA - Basics (I)
• VBA - Basics (II)
• VBA - Decision (I)
• VBA - Decision (II)
• Decision Application Examples
• VBA - Repetition (I)
• VBA - Repetition (II)
• VBA - Repetition (III)
• VBA - Repetition (IV)
• VBA - Array
• VBA - Procedures
• VBA - Typical Array Operations
• VBA - Classes and Objects
• VBA - Userform and Controls
• VBA - Userform Programming
• CSCI 112 Final Review

Some lecture example files:

• Excel Model Building examples
• VBA programming examples
• VBA conditional statement examples
• VBA conditional statement examples(2)
• VBA loop examples (1)
• VBA loop examples (2)
• VBA loop examples (3) (nested loop)
• VBA loop examples (4) (typical applications)
• VBA Array examples
• VBA Procedure examples
• VBA objects examples
• VBA Userform examples
• VBA Userform Programming examples