BUS2206 Information Systems Management

Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

BUS2206 Information Systems Management

Excel Assignment(7%)

Case 7: The Very Big Bank Stress Test

· Imagine that we are still in year 2015.

· Read "The Very Big Bank Stress Test" in pages 135-144 of

"Problem-Solving Cases in Microsoft Access and Excel", 13th Edition, 2016.

· The book is available on reserve in the library.

· Download “Assignment1 2025T2.xlsx”.

· Finish Assignment 1 in pages 137-142.

· Finish Assignment 2 in pages 142-143 (you don't need to work on Assignment 2B);

· Your Excel file should contain two sheets: (1) your Excel DSS model that deals with Assignment 1; (2) the Scenarios Manager summary sheet that summarizes results of 4 scenarios in Assignment 2.