Assessment 4: Reflective Report
Assessment 4: Reflective Report
Intent:
In this final assessment, we ask you to reflect on the activities in the form of key lessons learned. This assessment consists of two parts as follows:
Part1: This part allows you to apply your understanding of IS concepts to a specific selected business.
Part 2: In this part, we asked you to design a data dashboard that helps its users make more informed decisions.
Due Date: 17th Nov 2023
Weighting:30%
Tasks instructions:
Part 1: Tutorial Reflection (Weight: 10%)
In this part of the assignment, you can consider a business of your choice. The selected business could be the company you work for or another company. The best option could be a business you are passionate about or have some background knowledge of, and you can find publicly available information for that.After selecting a business, go through the below scenario and answer the questions in Table1.
Scenario: Imagine that the businesss technical leadership team is considering an extensive investment program to prepare the business for a digital future. In this program, advanced information systems will become a critical pillar for the business. As a first step, the executives have asked you to conduct an initial exploration of possible applications for IS across the business. For this purpose, they provided you with some questions in Table 1. We expect a report addressing the following questions in the table for this part.
Table1: List of questions by Executive
# Question Maximum word Mark%
1 Introduce the business you choose and some of its main activities 100 1
2 What is the overall benefit of IS for your business? 150 2
3 Choose one of the introduced tools in Tutorial week 4 and apply the tool for your case. You should (1) run them for an example relevant to your business and (2) explain how it benefit your business. See Table 2. 250 3.5
4 Choose one of the introduced tools in Tutorial week 8 and apply the tool for your case. You should (1) run them for an example relevant to your business and (2) explain how it benefits your business. See Table 2. 250 3.5
Referencing:APA 7th Edition
Length: 750 words (+/- 10%)
Weight: 10%
Table 2. Tools discussed in the Tutorial week 4 & 8.
Week 4 Week 8
Pivot Table, (2) Word Clouds,
(3) Text Analytics Demo, (4) Scatter Plot (1) Google trend, (2) Computer Vision (3) Conversational bot, (4) Google lens
Part 2: Making informed decisions using pivot table (Weight: 20%)
In this part, the R & D department in your selected company in part1 would like to investigate how other companies (based on their type, size, and sector) use data science in their business environment. For this purpose, the R & D team will use real-world data named Australia Data Science Jobs to decide on the programming/software skills applied in the other companies. Using this data, you should create a pivot table that helps the R&D team decide on preparing a comprehensive report for the Executive committee.
In this section, you need to describe the structure of the pivot table, including the below information:
The variables which you assigned to the four areas of the pivot table, including Report Filter, Column Labels, Row Labels, and Values (8%)
The function you choose for the value area, including sum, average, min, max, count & product (2%).
Justify your selection (10%).
You need to present your results to the R &D team. You may use the screenshots and some statistics to support your justification and report.
Tips:
The excel data is uploaded to Canvas> Assignment 4.
You can find the name of programming languages and technologies from Column Z to Column BA. The values of these variables are binary. For example, in the sixth row, for the job title data scientist in the ANZ banking group, python, R, and SQL are used.
Features such as Job Title, company sector, Company Industry, and programming languages and technologies can help you find your pivot table's structure.
How to make the Pivot table? Please review the tutorial of Week 7.
Referencing:APA 7th Edition
Length: 750 words (+/- 10%)
Weight: 20%
