AMS1360 Excel in Daily Money Management – Common Core Curriculum Office (CCCO)

Department

Mathematics Statistics and Insurance

Semester

AY2015/16 Sem 2, AY2016/17 Sem 1, AY2016/17 Sem 2, AY2016/17 Summer Sem, AY2017/18 Sem 1, AY2017/18 Sem 2, AY2017/18 Summer Sem, AY2018/19 Sem 1, AY2018/19 Sem 2, AY2018/19 Summer Sem, AY2019/20 Sem 1, AY2019/20 Sem 2, AY2020/21 Sem 1, AY2020/21 Sem 2, AY2021/22 Sem 1, AY2021/22 Sem 2, AY2022/23 Sem 1, AY2022/23 Sem 2, AY2023/24 Sem 1, AY2023/24 Sem 2, AY2024/25 Sem 1

Method

Laboratory 3 hours

Cluster

3 (Science and Technology)

Prerequisite

GEN1000 Perspectives on General Education or with the Module Coordinator’s permission
and upon endorsement of the relevant Head

Exclusion

Nil

Module Description

This module aims to help students taking control of their daily money issues under various real-life financial situations. Students are expected to know the history, development and importance of money and its related technology in human civilization, investigate the social implication of the connections between money-related technology and money, acquire knowledge of basic financial concept, like Time Value of Money and forecasting, and develop a scientific methodology for analyzing financial products and solving monetary problems with the help of technology. Future development of technology and its impact on money will also be discussed.

Module Intended Learning Outcomes (MILO)

Upon completion of this module, students should be able to:
a. Describe the history, development and importance of money and its related technology in human civilization
b. Evaluate and solve financial challenges faced in daily life with scientific methodologies
c. Apply money-related technology to solve financial and social problems

Module Content

1. Introduction

1.1 History and development of money and its related technology in human civilization
1.2 Evolution and impact of technology and spreadsheet software
1.3 Social implication of the connections between money-related technology and money
1.4 Interest and basic financial terminologies

2. Analysis of financial products in the modern world with the help of technology

2.1 How technology improves decision making in lending, borrowing and savings (e.g. Personal loan, student loan, car loan, mortgage and credit card, savings plan and insurance)
2.2 Forecasting the future of the financial market
2.3 Future development of technology and its impact on money management

Assessment Methods

1. Participation (10%)
2. Quizzes (40%)
3. Report (50%)

Texts & References

1. Ling, L. (2011). Manage Your Money without Formulas. HKMS Texts in General Education, Vol. 2. Pearson Education Asia Limited. *
2. Rentz, W.F., Kahl, A. (2017). Financial Mathematics with MS Excel 2016: Time Value of Money. CreateSpace Independent Publishing Platform.
3. Walkenbach, J. (2015). Microsoft Excel 2016 Bible. Wiley.
4. Davies, G. (2016). A History of Money (4th edition). University of Wales Press.
5. Ferguson, N. (2009). The Ascent of Money: A Financial History of the World. Penguin Books.
6. Latter, T. (2007). Hong Kong’s Money: The History, Logic and Operation of the Currency Peg. Hong Kong University Press.
7. Antonopoulos, A. (2016). The Internet of Money. Merkle Bloom LLC.
8. Frasca, R.R. (2008). Personal Finance: An Integrated Planning Approach (8th Edition). Pearson Education (US).