This is an introductory course in computer programming and problem solving for undergraduate students in the Biology/Molecular Science program who have no prior experience in programming in any language. The course covers the fundamentals of computer programming and its underlying principles using the programming language Visual Basic for Applications (VBA). Subroutine and function procedures are created to be run within the Excel environment.
1) Knowledge of fundamental programming concepts and structures in the VBA/Excel environment.
2) Ability to formulate solutions to problems and write programs to be run in VBA/Excel.
Prerequisite or co-requisites: None
Restrictions on who may receive credit for this course: Biology/Molecular Science students
This course will be offered (indicate
campuses & semesters):
“Power Programming with VBA/Excel”, S.C. Chapra, Prentice-Hall, 2003. ISBN: 0-13-047377-4.
Instructor: K. Ming Leung
Office (phone): LC 127 (718-260-3380)
Computer needs: Laptop with Microsoft EXCEL installed.
2.5 hours a week
0.5 hours a week
Two midterm exams and one final exam.
Weekly homework assignments
Coordinated and integrated with lecture material.
ABET Competencies: This course addresses the following ABET competencies :
a) Students learn fundamental computer programming concepts and structures.
e) Students identify, formulate and solve scientific and engineering problems.
Content by Category: Engineering Science = 3 credits (100%)
Lecture topics: (tentative)
Week 1 – The VBA Front-end: Excel
Week 2 – Using Build-in Functions
Week 3 – Macros
Week 4 – VBA Essentials
Week 5 – VBA expressions
Week 6 – Creating custom functions
Week 7 – Objects, Properties and Methods
Week 8 – Working with range objects
Week 9 – Conditional Branching
Week 10 – Looping Mechanisms
Week 11 – Creating and managing arrays
Week 12 – Sorting and searching elements in arrays
Week 13 – Debugging macros and custom functions
Grading Scheme: HW (20%) + 1st Midterm (20%) + 2nd Midterm (20%) + Final Exam (40%)
· 1st Midterm Exam: October 20
· 2nd Midterm Exam: November 24
Link to Lecture Notes and Homework Assignments: