Spreadsheet Engineering - The Application of Excel's Macro Programming Language, (Visual Basic for Applications) to Core Courses within Chemical Engineering

Project Title

Spreadsheet Engineering - The Application of Excel's Macro Programming Language, (Visual Basic for Applications) to Core Courses within Chemical Engineering

Project Leader

Prof John Barford

School / Dept

SENG / CENG

Project Duration

Jan 2007 - May 2008

Project Description

The project made major changes to the curricula by structuring teaching of Excel - Visual Basic Application (VBA) in an introductory first year course; and the application of VBA throughout our major core courses during the remainder of the UG degree courses.

Project Outcome

• An industrial training module in using Excel VBA to solve simple chemical engineering problems "A case study on Fed-Batch Bioreactor" and Excel VBA Training Manual was developed.

•  Demonstration of the applications of Excel VBA in solving chemical engineering problems were demonstrated to students in 2 courses.

Status

Completed

Project Documents
(Only accessible by HKUST users)

• Project Plan
• Progress Report: First | Second | Third |
• Final Report

Adaptation

Full Project