COURSES >>>

CB2022 - Business Programming with Spreadsheet

Offering Academic Unit
Department of Information Systems
Credit Units
3
Course Duration
One Semester
Exclusive Courses:
Course Offering Term*:
Semester A 2019/20, Semester B 2019/20
Semester A 2020/21 (Tentative), Semester B 2020/21 (Tentative)

* The offering term is subject to change without prior notice
 
Course Aims

Business programming with Spreadsheet is among the necessary skills for professionals in all business sectors, e.g. in accounting and financial services. Mastering knowledge and skills of data management using spreadsheet gives students competitive advantages in job application and career advancement.

Upon completion of this course, students should be able to use spreadsheet to solve business problems and design their own spreadsheet applications to support business operations and decision making (e.g. critical skills for business analysts in banks).

This course aims to:

  • Introduce the concepts, methods and techniques of simple data management using spreadsheet (basic functions such as formula, chart, conditional formatting, pivot table, etc) for accounting and financial services, and other business sectors.
  • Equip students with the advanced spreadsheet techniques, such as web query, macro and programming abilities to support smart business decision making.

Assessment (Indicative only, please check the detailed course information)

Continuous Assessment: 60%
Examination: 40%
Examination Duration: 2 hours
 
Detailed Course Information

CB2022.pdf

Useful Links

Department of Information Systems