ICT100 - Data Analysis with Excel - Information Systems - Case Study Help

Assignment Task :

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 assignment requires students to analyze the given case study and provide their recommendations for the selection of the best system for the company.

Report: Write a report for First Bank that must include the following section:(ICT100)

• 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.

Details of Data Analysis with Excel:

 Complete the following tasks: (ICT100)

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. 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”.
4. 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”.

This ICT100 - Case Study has been solved by our Case Study Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.