Application of Excel VBA to Problem Solving in Core Subjects in Chemical Engineering

Project Title

Application of Excel VBA to Problem Solving in Core Subjects in Chemical Engineering

Project Leader

Prof Gordon McKay

School / Dept

SENG / CENG

Project Duration

Feb 2008 - Jun 2008

Project Description

The project extended the application of Visual VBA to more CENG core course and to teach problem-solving skills using VBA to students.

Project Outcome

• VBA programs and lecture notes to undertake the industrial economic problems of “project evaluation“ were specially designed and developed.

• A demonstration in one lecture was implemented. Students were taught to solve the problems by designed VBA programs and to discover alternative methods. 

Status

Completed

Project Documents
(Only accessible by HKUST users)

• Project Plan
• Progress Report
• Final Report

Adaptation

Adaptation from Spreadsheet Engineering - The Application of Excel’s Macro Programming Language, (Visual Basic for Applications) to Selected Courses Within Chemical Engineering