CLICK HERE TO GET MORE ON THIS ESSAY!!!
1) Be able to use a variety of sources for the collection of data, both
primary and secondary.
2) Understand a range of techniques to analyze data effectively for
business purposes.
3) Be able to produce information in appropriate formats for decision
making in an organizational context.
4) Be able to use software-generated information to make decisions in an
organization.
Essential requirements
It is essential that learners have access to
computers and the internet and specialist packages for statistical analysis and
network planning.
Scenario
Bank DM is a local bank specialising in providing personal financial
and investing services to a range of clients.
The Bank classifies the clients into three grades, namely, Regular,
Preferred, and Elite, according to the average amounts of deposits. The Bank recently has faced fierce
competition, mainly from some international banks and brokerage houses. As a response to the challenge, the Bank endeavours
to deliver exceptional services to clients through strengthening the
capabilities and morale of the staff.
Task 1
The Personal Banking Director of Bank DM is asked by the Executive
Committee of the Bank to prepare a report and present the report in a meeting
to review the following issues:
1) The change in the structure of clients in the last five years
2) The success (or otherwise) in widening and extending the clients base
in the last five years
3) The success (or otherwise) in
attracting deposits and generating service income from various classes
of clients in the last five years
4) The relative values of each class of clients
5) The projection for the amounts of deposits and service income for 2011
The Personal Banking Director has collected the following five-year
summarised data:
Required:
(a) Produce a formal business report in the
capacity of the Personal Banking Director to the Executive Committee of Bank DM
to COMMENT on EACH of the five reviewing issues
with the data collected. (LO 3.4)
3.4 produce a formal business report - Write in a
formal report format with ‘From’, ‘To’, ‘Title’,
‘Executive Summary’, and ‘Conclusion’. Comment
on EACH of the five reviewing issues in the case in the content with
numerical supporting.
(b) The comment must be supported
appropriately by the following analysis:
i.
Create
information for decision making by summarising data using representative
values, i.e. mean, median, mode, and using the results to draw valid
conclusions. (LO 2.1)
2.1 Understand a range of techniques to analyse data effectively for
business purposes:
Create information for decision making by summarizing data using
representative values.
Calculate mean, median, and mode, range variance and standard deviation.
Draw conclusion
with
the calculation.
ii.
Analyse data using measures of dispersion to
inform the Executive Committee for any implication and
potential problem. (LO 2.3)
2.3 analyse data using measures of
dispersion to inform a given business scenario. Calculate relevant measures of dispersion.
Explain the implication or problem in writing.
iii.
Create trend lines in spreadsheet graphs to assist in forecasting
for the amounts of deposits and service income for 2011. You should comment on
the reliability of the trend lines. (LO
3.2)3.2 create trend lines in spreadsheet graphs
to assist in forecasting for specified business information. Use spreadsheet to
extrapolate the trend lines for deposit amount and services income for 2011. Comment
on the reliability of the trend lines drawn.
iv.
Analyse the results to draw valid conclusions on each of the five
reviewing issues in the context of Bank DM. (LO 2.2)2.2 analyse the results to draw
valid conclusions in a business context. Draw
conclusions on EACH of the five reviewing issues
and overall conclusion according to the numerical calculation.
(c) Prepare for the Personal Banking Director a business presentation using suitable software and techniques
to
i.
Disseminate
information about the report effectively in a meeting with
the Executive Committee. You should submit the power point slides with appropriate presentation
notes. (LO 3.3)
3.3 prepare a business presentation using suitable software and techniques
to disseminate information effectively. Submit
a presentation with notes to summarise the report
findings and conclusion.
ii.
Produce suitable line, pie, bar charts and histograms for the
collected data using spreadsheets and draw valid
conclusions based on the information derived. (LO 3.1)3.1 produce graphs using
spreadsheets and draw valid conclusions based on the information derived. Correctly
draw suitable graphs by using the graphing function of spreadsheet software to present ALL the collected data.
No comments:
Post a Comment