T1 2019: ICT100 Foundations of Information Systems Assessment 2 Topic: Case Study Assignment Submission: Submit the Report and Excel Sheet on Moodle on Sunday 21 April 2019 by 11:55pm (Week 6)....

.



T1 2019: ICT100 Foundations of Information Systems Assessment 2 Topic: Case Study Assignment Submission: Submit the Report and Excel Sheet on Moodle on Sunday 21 April 2019 by 11:55pm (Week 6). Assessment Details: XYZ Company requires a new Transaction Processing System (TPS) to gain competitive advantage in the market. The company is testing four such systems (TPS1, TPS2, TPS3 and TPS4) at four of its sites. The given file Assignment1-Datafile.xlx contains the testing results for these TPSs (X 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 TPS for the company. The assignment has two main parts: A. Data Analysis with Excel: Analyse the given data in Assignment1-Datafile.xlx after completing the tasks given below. B. Report: Write a report for XYZ Company that must include following sections: · Introduction: Discuss the importance of competitive advantage associated with the use of modern Information Systems. · Transaction Processing System Selection: Justify the selection of TPS based on the results generated in the excel sheet. The justification must be based on the graph “Total Transactions” and chart “System Errors”. · Importance of Data representation: Discuss the importance of correctly representing the data for easy decision making. · Conclusion: Must summarise the most important parts of the report and should include recommendations for using information systems for competitive advantage. 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 each TPS net transactions after deducting “Re-Entry Required due to system errors” from “Transactions”. 2. In the row labeled “Blocks”, calculate each TPS’s blocks (Total Transactions divided by 50). 3. In the row labeled “Blocks per hour (8 hr day)”, calculate each system’s number of Blocks per hour (Record Stacks divided by 8). 4. In column F use the Sum function to give totals (for all systems) for each of the rows (rows 4 to 8). 5. In column G determine the lowest value (for all systems) for each of the rows (rows 4 to 8). 6. In column H determine the highest value (for all systems) for each of the rows (rows 4 to 8). 7. In column Q determine the arithmetic mean (for all systems) for each of the rows (rows 4 to 8). 8. The daily profit gained from each system is based on completed Blocks per hour for that day. Each working day is 8 hours long. Use a lookup table with a profit that changes according to the number of Blocks per hour that a system completes – Up to 4 stacks per hour, the more stacks completed, the higher the profit. You will use the range B8 to D8 (Blocks per hour) for the formulas to calculate daily profit. There is a table on the spreadsheet showing the Daily Profit. Use either the Lookup function or VLookup function to find the daily profit for all the systems (make sure to use referencing). 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 Records Entered”. 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”. ICT100: Assessment 2 Shaleeza Sohail T1 2019