ICT100 Foundations of Information Systems

T3 2019: ICT100 Foundations of Information Systems Assessment 2 Case Study Assignment: Individual case study assessment composed of two submissions in Moodle: Part 1- Excel…

T3
2019: ICT100 Foundations of Information Systems

Assessment
2

Case
Study Assignment: Individual
case study assessment composed of two submissions in Moodle: Part 1-
Excel sheet and Part 2- Report (1,000 words).

Assessment
topic:
Data Analysis with Excel and Report about modern information systems.

Submission:
On the submission link in Moodle, there are two tabs: Part 1 and Part
2. Submit the Excel spreadsheet in Part 1 and the Report (Word
format) in Part 2 on
or before Sunday 15 December 2019 by 11:55pm (Week 6).
Do not compress the files as a zip folder.

Purpose:
In this assessment students are to critically analyse a given case
study. Students will use an Excel spread sheet and its different
functionalities to analyse the case study. This assessment
contributes to learning outcomes b and d.

Value:
15%

Assessment
Details:

FIRST
BANK is aggressive in its strategy to grow its customer base by
offering tailored financial solutions. To ensure the bank is
prepared to address the potential surge in transactions, the bank is
evaluating different systems to replace its legacy core banking
application. The I.T. team is evaluating six systems (CB1 to CB6)
that were presented to them by independent software vendors. The
given file Assessment2-Datafile.xlx contains testing results
for these core banking systems (XX is the last two digits of
your student ID). The assignment requires students to analyse
the given case study and provide their recommendation for selection
of the best system for the company. The assignment has two main
parts:

Data
Analysis with Excel:
Analyse the given data in Assessment2-Datafile.xlx
after completing the tasks given. Analysis is based on the use of
various excel formulas and graphs learned in class.

Report:
Write a report for First Bank that must include the following
sections:

Introduction:
Discuss the importance of competitive advantage associated with the
use of modern information systems.

Information
System Selection:
Justify the selection of core banking system based on the results
generated in the excel sheet. The justification must be based on
the two
graphs.

Importance
of Data representation: Discuss
the importance of correctly representing data for easy decision
making.

Conclusion:
Must summarise the important parts of the report and should include
recommendations for using information systems for competitive
advantage.

Reference
List:
At least two references from academic journals. In addition,
proper in-text referencing is to be followed.

Details
of Data Analysis with Excel:

Download
the file Assessment2-Datafile.xlx
and complete the following tasks:

1.
In the row labeled “Total Transactions”, calculate net
transactions after deducting “Re-Entry Required due to system
errors” from “Transactions”.

2.
In the row labeled “Transaction Block”, calculate the transaction
block by dividing Total Transactions by 50.

3.
In the row labeled “Transactions per module (6 modules)”,
calculate the transactions for each module by dividing Transaction
Block by 6.

4.
In column H use the Sum function to give totals (for all systems –
CB1 to CB6) for each of the rows (rows 4 to 8).

5.
In column I determine the lowest value (for all systems – CB1 to
CB6) for each of the rows (rows 4 to 8).

6.
In column J determine the highest value (for all systems– CB1 to
CB6) for each of the rows (rows 4 to 8).

7.
In column K determine the arithmetic mean (for all systems – CB1 to
CB6) for each of the rows (rows 4 to 8).

8.
The forecasted Daily Revenue gained from each system is based on
transactions per module that is used in analysis for sales and
marketing campaigns. There is a total of 6 modules. Use a lookup
table with revenue that changes according to the number of
Transactions per module. You will use the range B8 to G8
(Transactions per Module) for the formulas to calculate daily
revenue. There is a table on the spreadsheet showing the Daily
Revenue. Use either the Lookup function or VLookup function to find
the daily revenue for each of the systems CB1 to CB6 (make sure to
use absolute referencing in your formula for the array field).

9.
Create a Clustered Column chart for the Total Transactions. Remember
to select the correct ranges and ensure the title of the chart is
“Total Transactions”.

10.
Create a Pie chart showing the column “Re-entry required due to
system errors”. Remember to select the correct ranges and ensure
the title of the chart is “System Errors”.

Marking
Criteria: The assessment will be
marked based on the following criteria:

1. Correct
use of Excel formulas and graphs

2. Well-written
and directly answers the question

3. Provides
supported argument with at least two references (from academic
journals and books)

4. Demonstrates
knowledge of the subject matter

5. Draws
a conclusion based on argument

Refer
to the Subject Outline for a detailed breakdown of this criteria.
Let’s block ads! (Why?)

Do you need any assistance with this question?
Send us your paper details now
We’ll find the best professional writer for you!

 



error: Content is protected !!