Swinburne University INF10003 - Assignment 2 Outline Individual © Swinburne University 2017 Essential Resources Please make sure that you download the following files from the unit website. Required files:  INDAGINE SURVEYORS.Pdf (case study)  INDAGINE DATA.xlsx  Process model.pptx Approx. 2000-2300 words Weighting: 30% Due date: See Unit Schedule Assignment 2 submission details  All pages should include your name and student number in the document footer  All references should be appropriately cited using the Harvard style  Submit your assignment as either file format: PDF or Microsoft Word document as well as Excel spreadsheet.  Save your files as follows: [student number_A2.filetype] e.g. 1234567_A2.pdf or 1234567_A2.doc  Submit your assignment via the Blackboard link > Assessment > Assignment 2 Assignment Specifications The primary aim of this assessment is to understand the effect and impact that business processes, competing and/or complimentary technologies and information systems have on an organisation. This means that you need to discuss how the case study organisation may use your proposed solutions. There is an expectation that your submission will be analytical, and will draw on theory to frame responses to tasks. Overview: (read the case study) Mr Martin Krowski would like to have a clearer understanding before these changes are implemented so he has asked you to submit a business report (with academic references) with the following information: - Two (2) graphs created in Microsoft Excel that show department statistics (refer Task A) - Two (2) process models depicting ‘As-Is’ and ‘To-Be’ processes (refer Task B) - Answering a series of general questions regarding the business and its journey towards a more technological business environment. (refer Task C) Task A: EXCEL for Business Intelligence Martin wants to evaluate the 2015 statistics from permit applications. Martin knows enough about Excel to realise it could be a useful tool so he has asked you to create a Microsoft Excel prototype which lists the type of permits received in 2015 and the revenue collected. The data for the spreadsheet is available in the essential resources spreadsheet as well as a suggested layout and hints for formula to be used. Graphs: You are also required to create two (2) graphs. 1. Column chart: Show total revenue by department (see case study). 2. Pie chart: Show number of applications by department as percentages (see case study). (Partly completed spreadsheets will be provided) Task B: BUSINESS PROCESS MODELS Produce two (2) process models (not hand drawn) using Swim Lane format from the details provided in the Background section (clearly state any assumptions made): 1. The first Swim Lane diagram must represent the ‘As-Is’ application processes at IND 2. The second Swim Lane diagram must represent the ‘To-Be’ application processes at IND. (Partly completed templates will be provided)Swinburne University INF10003 - Assignment 2 Outline Individual © Swinburne University 2017 Task C: General Questions. 1. What is the role of business process modelling for organisations such as IND? What are the benefits of providing an As-Is model and a To-Be model to the General Manager, Mr Martin Krowski? Include your Swim Lane Diagrams (from Task B) as part of your explanation 2. Broadly explain the importance of information in organisations like IND and provide an example of how Information Technology can be a useful tool for attracting new customers and gathering information. 3. As the company does not have the expertise to develop mobile apps it will need to look elsewhere for this service. Discuss outsourcing and identify 3 benefits and 3 disadvantages. 4. Discuss the differences between Web analytics, Social Network Analysis and Customer Relationship Management, including outlining the environment from which the information is collect from, the type of information it collects and the benefit from the information collected. 5. Discuss the importance of mobile apps in the modern business environment. 6. As IND will be collecting information from people, outline the privacy laws and cybersecurity measures that the company will need to consider to assure the customer that their information is safe and secure.Swinburne University INF10003 - Assignment 2 Outline Individual © Swinburne University 2017 Main Submission Requirements/Structure The structure of your report should include the following:  Executive Summary *  Table of Contents *  Introduction Evaluations of the business:  Business review (Review how the business processes will change (refer to your BPM models), as well as discussing the importance of business intelligence (BI) can have on business outcomes (refer to Excel spreadsheet). Body of the report must include:  Two (2) process models addressing the requirements in Task B plus any assumptions  Two (2) graphs representing the requirements in Task A plus short descriptions for each  Sub-headings with responses to the questions in Task C plus in-text references Other report components.  Conclusion/Summary (provide brief summary and any additional recommendations)  Include an appendix *(optional)  Reference List *(mandatory - 6+ refs minimum) Additional Resources: The following resources (as listed below) can be used as additional guides to assist you with your analysis and design.  https://exceljet.net/excel-functions/excel-vlookup-function  https://exceljet.net/excel-functions/excel-countif-function  https://exceljet.net/excel-functions/excel-sum-function  http://www.gcflearnfree.org/excel2013/charts/2/  https://www.smartdraw.com/swim-lane-diagram/ Submission Requirements The submission must be your own work, that is, it must be the result of your own readings, thoughts and discussion, and the expression of the ideas must be yours. Editorial assistance is permitted, but should be limited to such matters as assistance with grammar and syntax, and suggestions for improving clarity of expression. ***IMPORTANT: Plagiarism – the action or practice of taking and using as one’s own, the thoughts, writings or other work of someone else – is not condoned by the University and severe penalties will be imposed where plagiarism is detected. Examples of plagiarism range from copying a passage from a book or another person’s assignment without appropriate acknowledgement, using another student’s computer program, or submitting identical assignments. Submission Assistance Assistance can be obtained from the Helpdesk (03) 9214 5000 for any technical issues with submitting your assessment into Blackboard. If it is after hours, you may email the assessment directly to the convenor so as to avoid late penalties. For further information and additional resources regarding plagiarism and other issues, please go to the “Other Materials” section of the subject website. Report Expectations  The word expectation for this assessment is to be within the 2000-2300 word range.  This assignment is an individual assessment item only.  Report items marked with a “ * ” do not count towards the final word count.  An assessment cover sheet is provided in the Blackboard site and must be used.  Assignments without a cover sheet will have their marks withheld. 