ICT100 Foundations of Information Systems Assignment

Assignment Help Other Subject

Reference no: EM132418177 , Length: word count:1000

ICT100 Foundations of Information Systems Assignment - King's Own Institute, Australia

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

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

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.

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:

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

B. 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".

Attachment:- Foundations of Information Systems Assignment Files.rar

Reference no: EM132418177

Questions Cloud

How experiences from discussion post impact nursing practice : Reflect on how those experiences from the Discussion Post impact your nursing practice now? Create a community education plan to address ageing bias.

What organizational skills can transfer to the workplace : Based upon a review of your learning this quarter, what can you do now as a student that will help your transition to the workplace? What organizational skills.

How did happenings of the nursing profession impact origin : How did the happenings of the nursing profession impact the origin of this theory? What values, evidence, or existing knowledge did the theorist cite to support

Securing cloud hypervisors in more technical details : Barrowclough & Asif, discussed, securing cloud hypervisors in more technical details, including covering the Cloud Security Alliance top 12 threats

ICT100 Foundations of Information Systems Assignment : ICT100 Foundations of Information Systems Assignment - King's Own Institute, Australia. Data Analysis with Excel and Report

Discuss cost and benefits of energy efficiency in healthcare : Identify two to three articles that discuss the cost and benefits of energy efficiency in healthcare. Identify best practices you can use in your healthcare.

Alternative approaches to forwards and futures for hedging : Problem: You have to buy some asset in the future. You can use a forward contract or a future contact to hedge the price risk.

Describe risk factors or precursors to adolescent pregnancy : Describe various risk factors or precursors to adolescent pregnancy. Research community and state resources devoted in adolescent pregnancy and describe.

Security of communication systems : What are the key technologies that enable the security of communication systems? Explain the role of each one and support your answers with examples.

User Account

All Pages