User Rating: 0 / 5
1. COURSE OBJECTIVES
Information technology (IT) is the backbone of Banking and Finance activities. Therefore, Finance - Banking has always been one of the leading industries in the application of information technology in operation and management. Technology is applied in most of the banking services such as payment, transaction, money transfer... as well as used in investment analysis, automated advice, and risk management of the bank and companies in the financial sector in general.
The course is designed to equip students with basic IT knowledge in the field of Finance - Banking. In the first part of the course, basic IT applications in Finance - Banking will be introduced including Financial Technology (Fintech), Machine Learning, and Big Data. In the second part, students will learn how to use Excel to solve financial problems and learn how to analyze data using Excel tools and functions. Finally, students will be familiar with Excel VBA and use it to solve some problems in the field of Finance - Banking.
2. COURSE CONTENT
No
Content
Allocation
Contribute to CLO
Hour(s) on the class
Essays, exercise, assignments
Self-study with the teacher’s tutorials
Lecture
Practice, Seminar
1
Chapter 1. Overview of Information Technology in Finance - Banking
3
0
3
11
1
2
Chapter 2. Financial Technology (Fintech) Overview
3
0
1.5
5.5
1, 2
3
Chapter 3: Application of Financial Technology (Fintech) in Finance - Banking
2
1
1.5
5.5
1, 2
4
Chapter 4: Machine Learning
2
1
1.5
5.5
1, 3
5
Chapter 4: Machine Learning (Continue)
2
1
1.5
5.5
1, 3
6
Chapter 4: Machine Learning (Continue)
2
1
1.5
5.5
1, 3
7
Chapter 5: Big Data
2
1
1.5
5.5
1, 4
8
Chapter 5: Big Data (Continue)
2
1
1.5
5.5
1, 4
9
Mid-term exam
10
Chapter 6: Reviewing basic tasks and financial functions in Excel
2
1.5
1.5
5.5
5, 7, 8
11
Chapter 7: Reviewing advanced tasks and financial functions in Excel
2
1.5
1.5
5.5
5, 7, 8
12
Chapter 8: Data Analysis Using Excel
2
1.5
1.5
5.5
5, 6, 7, 8
13
Chapter 8: Data Analysis Using Excel (Continue)
2
1.5
1.5
5.5
5, 6, 7, 8
14
Chapter 9: Getting Started with Excel VBA
2
1.5
1.5
5.5
5, 6, 7, 8
15
Chapter 9: Getting Started with Excel VBA (Continue)
2
1.5
1.5
5.5
5, 6, 7, 8
Total
30
15
22.5
82.5
3. COURSE ASSESSMENT
Form
Content
Criteria
CLO
Proportion
Formative
Attendance
Attendance check
1 – 5, 9
10%
Summative
Mid – term test
Chapters 1-5
Group presentation/ Case study Report/ Written exam (MCQ &/or problem-solving questions)
Written exam (MCQ &/or problem-solving questions
(60 minutes)
1 – 5, 9
30%
Final exam
The whole course
Multiple – choice questions and present steps and results from practice in computer
1 – 8
60%
Total:
100%
- Grading rubrics for individual’s/group’s written assignment/report
Criteria
CLO
Weighted average
Levels of Assessment
Grade
A
B
C
D
F
8,5-10
7-8,4
5,5-6,9
4,0-5,4
<4
Format
1 – 5, 9
20%
All assignment format’s requirements are met with a professional look. No spelling & grammar errors; well-presented tables & graphs; and sources are adequately cited.
Assignment format has professional look but may have some format and spelling errors
Assignment has format, spelling and grammar errors. Sources are not adequately cited.
Assignment is sparsely written with many errors of format, spacing, spelling and grammar.
Assignment is carelessly written with many format errors; and fails to meet format’s requirements.
Writing style
1 – 5, 9
20%
Writing is very clear, coherent, logically organized and interesting. Main ideas are well developed and supported throughout the paper.
Writing is good with clear ideas, but some parts are not logical.
Writing is unclear with some incoherent and vague ideas
Substandard writing which lacks logical organization. Ideas are vague with little evidence of critical thinking
Poor writing with mainly “copy and paste” ideas.
Content
1 – 5, 9
50%
Content meets assignment requirements very well, and indicates the synthesis, expansion and in-depth analysis of ideas. No sign of plagiarism
Content meets assignment requirements without sign of plagiarism. However, content does not indicate the expansion of ideas.
Content basically meets assignment requirements without sign of plagiarism. But some parts of content are inadequate
Content just meets the minimum requirement of assignment, without sign of plagiarism. But the analysis is underdeveloped and unoriginal.
Content strays from the main topic; or plagiarism is over 20%
Reference
1 – 5, 9
10%
A variety of sources are adequately and correctly cited.
A variety of sources are included, but there are some format errors and incorrect citations.
Sources are reasonable but lack diversity. There are quite a few format errors and incorrect citation.
Sources lack of diversity. There are many format errors and incorrect citations.
The writing does not use adequate research reference. There are many format errors and incorrect citation.
Member contribution
1 – 5, 9
Based on peer review
Active and adequate participation. Proactively working to meet deadline set by group.
Quite active and adequate participation. However, there is a delay in meeting group deadlines.
Not really proactive when participating. There is a delay in meeting group deadlines.
Just participate in a small part of group work. Not proactive when participating
Little or no participation. Shows no responsibility with work and often fails to meet deadlines.
Note:
The lecturer instructs group members to conduct peer review on a scale of 1 to 10, based upon the contribution of each member to group work. The grade of each member will be adjusted according to the peer review which reflects this member’s contribution and participation.
- Grading rubrics for individual/group presentation
Criteria
CLO
Weighted Average
Levels of Assessment
Grade
A
B
C
D
F
8,5-10
7-8,4
5,5-6,9
4,0-5,4
<4
Presentation Organization
1 – 5, 9
10%
Clear and coherent organization which is easy and pleasant to follow
Quite clear organization which is easy to follow
Presentation organization is not clear and difficult to follow
Presentation organization is unclear and incoherent
Presentation organization is unclear, incoherent and difficult to follow.
Presentation Content
1 – 5, 9
50%
The content is very clear, coherent, and interesting. Main ideas are well developed and supported throughout the presentation
Content is good with clear ideas, but some parts are not logical
Content is unclear with some incoherent and vague main ideas
Substandard content which lacks logical organization. Ideas are vague with little evidence of critical thinking
Poor content with “copy and paste”, incoherent ideas
Presentation skills
1 – 5, 9
10%
Good and clear presentation, using body language to effectively attract and interact with audience
Clear presentation with body language, but inadequate interaction with audience
Mediocre presentation without body language and inadequate interaction with audience
Substandard presentation without body language and inadequate interaction with audience
Poor presentation without body language and inadequate interaction with audience
Q & A
1 – 5, 9
10%
Fluently answer all questions from audience
Answer about 2/3 questions from audience
Answer about 1/2 questions from audience
Answer about 1/3 questions from audience
Unable to answer any questions from audience
Use of media
1 – 5, 9
10%
PPT is clear, relevant, and well-designed. Handouts are provided to audience
PPT is well-designed and easy to follow
PPT is simple
PPT is poorly designed and hard to follow
None
Presentation time
1 – 5, 9
5%
Stay on time
Over ¼ time limit
Over 1/3 time limit
Over ½ time limit
Double time limit
Dress code
1 – 5, 9
5%
Formal and professional dress code
Formal and neat dress code
Casual and informal dress code
Casual dress code
Unsuitable and impolite dress code.