聯系方式

您當前位置:首頁 >> Java編程Java編程

日期:2019-07-23 10:52

AY2019/2020 April Semester

BPA (CFI2C11) 2019 Page 1

Diploma in Financial Business Informatics

Banking Processes and Automation (CFI2C11)

Project

Table of Contents

1.0 Learning Objectives .................................................................................................... 2

2.0 Assessment ................................................................................................................... 2

3.0 Deadline ........................................................................................................................ 2

4.0 Deliverables.................................................................................................................. 2

5.0 Project Information..................................................................................................... 3

6.0 Requirements and Guidelines.................................................................................. 5

Appendix 1:.............................................................................................................................. 6

Appendix 2:.............................................................................................................................. 7

AY2019/2020 April Semester

Banking Processes and Automation (CFI2C11)

Project

BPA (CFI2C11) 2019 Page 2

1.0 Learning Objectives

This project has four parts and enables you to apply the concepts learnt in the

subject. At the end of this project, you should be able to demonstrate your ability to:

explain the main processes in retail banking

document the processes using swim lane diagrams

implement the process automation using VBA programming language

2.0 Assessment

The project contributes 80% to the total assessment marks for the subject. It has

group and individual parts. Each group may consists of 4 – 5 members. Following

are the assessments for the project.

Part No Description Group Individual

1 Processes in Retail Banking 20%

2 Processes (Swim Lane Diagram) 15%

3 VBA Application 25%

4 Presentation 20%

Total 20% 60%

3.0 Deadline

See below table for the respective deadline and additional information.

Part No Description Deadline

1 Processes in Retail Banking Week 5 (13 May, 5 pm)

2 Swim Lane Diagram of selected process Week 15(26 Jul, 5 pm)

3 VBA Application Week 15(26 Jul, 5 pm)

4 Presentation Week 16(Time-tabled lesson)

4.0 Deliverables

Study the Project Information in Section 5 and submit your deliverables via

SafeAssign at LMS.

AY2019/2020 April Semester

Banking Processes and Automation (CFI2C11)

Project

BPA (CFI2C11) 2019 Page 3

5.0 Project Information

Part 1 – Processes in Retail Banking (Group)

In groups of four or five students, research on retail banking processes. Typical

products/services offered in retail banking include current account, savings account,

fixed deposit, ATM, GIRO, online banking, phone banking, various card services,

loan etc. To help you jumpstart your research, you may consider the following

processes.

A. Student Loan Application

B. Mortgage Loan Application

C. Bank Account Opening / Registration

D. Credit Card Application

E. Cheque Processing

The research is expected to include but not limited to the following. Keep to EIGHT

to TEN (8 – 10) A4 single-sided pages per group.

1. What is retail banking?

2. Key Functions and Processes in Retail Banking

3. Common problems encountered in Retail Banking

4. What is Robotic Process Automation (RPA) in retail banking?

5. How RPA is used to help solve the common problems mentioned in Point 3

Part 2 – Swim Lane Diagram (Individual)

Each student is to select one retail banking process, research and submit the

following. You may select the processes from Part 1.

1. Description of the selected process covering the purpose of the process, the

roles, data, activities / steps involved etc. (One process per student and no

duplicate process within the team)

AY2019/2020 April Semester

Banking Processes and Automation (CFI2C11)

Project

BPA (CFI2C11) 2019 Page 4

2. Draw a business process modeling diagram to represent the roles, activities

and the flow carried out in the selected process.

Part 3 – VBA Application (Individual)

Using VBA programming language, implement the process you have selected in Part

2. Implement form(s) and develop code to perform at least the following:

a) add, update, delete and retrieve data fields

b) perform validation of data fields at entry. A typical example of validation

could be a non-zero value for salary in Mortgage Loan Processing.

c) perform at least one complex function. Some examples of complex functions

are:

In Mortgage Loan Processing, the function could be checking that the

monthly repayment should be less than the monthly salary of the

applicant

Email the spreadsheet to assigned personnel

Save the spreadsheet as a PDF report etc.

You are encouraged to use Function or Subroutine for this part.

d) display a message to indicate the end of the process, such as “Application

Approved”.

Part 4 – Presentation & Demo (Individual)

Students are to present the following:

Part 2 (maximum 2 slides)

Demo on Part 3

Please look out for more details from your tutor nearer the presentation date.

AY2019/2020 April Semester

Banking Processes and Automation (CFI2C11)

Project

BPA (CFI2C11) 2019 Page 5

6.0 Requirements and Guidelines

You are required to comply to the following format and structure strictly.

6.1 Format of Project Report

You are to submit your individual report using the stated format:

Font

Font : Times New Roman

Font Size : 12

Spacing

Line Spacing : Single line spacing within a paragraph and double line

spacing between paragraphs

Margin Width : 2.5 cm all round

Header and Footers

Number every page for the main body of the report.

Labeling

For each individual submission, print your name and admission number on every

page.

Page Cover

Do not number the cover page. Refer to cover page template in Appendix 2.

Content Page

The report must be accompanied by a content page. The various sections in the

report shall be listed in the content page with their corresponding page numbers.

Bibliography

Please include your references. Use APA format

AY2019/2020 April Semester

Banking Processes and Automation (CFI2C11)

Project

BPA (CFI2C11) 2019 Page 6

Appendix 1:

Diploma in Financial Business Informatics

Banking Processes and Automation (CFI2C11)

AY2019/2020 April Semester

Project Work


Practical Class: PXX

Group : GYY

Submitted by: <Matric Number> <Full Name of member #1>

<Matric Number> <Full Name of member #2>

<Matric Number> <Full Name of member #3>

<Matric Number> <Full Name of member #4>

<Matric Number> <Full Name of member #5>

Date: dd /mm/yyyy

“By submitting this work, I am / we are declaring that I am / we are the originator(s) of this work

and that all other original sources used in this work has been appropriately acknowledged.

I / We understand that plagiarism is the act of taking and using the whole or any part of another

person’s work and presenting it as my/ our own without proper acknowledgement.

I / We also understand that plagiarism is an academic offence and that disciplinary action will be

taken for plagiarism.”

NAME AND SIGNATURE OF STUDENT: ……………………………………

NAME AND SIGNATURE OF STUDENT: …………………………………...

NAME AND SIGNATURE OF STUDENT: ……………………………………

NAME AND SIGNATURE OF STUDENT: ……………………………………

NAME AND SIGNATURE OF STUDENT: ……………………………………

*Where PXX is the practical class number & GYY is the project team number that your lab instructor

will assign each team.

AY2019/2020 April Semester

Banking Processes and Automation (CFI2C11)

Project

BPA (CFI2C11) 2019 Page 7

Appendix 2:

Diploma in Financial Business Informatics

Banking Processes and Automation (CFI2C11)

AY2019/2020 April Semester

Submission of Banking Processes and Automation Project

Class: ________________________________

Tutor: ________________________________

Student name Admission number

-- END –


版權所有:編程輔導網 2018 All Rights Reserved 聯系方式:QQ:99515681 電子信箱:[email protected]
免責聲明:本站部分內容從網絡整理而來,只供參考!如有版權問題可聯系本站刪除。

黑龙江体彩22选5