INFOSYS 110
DIGITAL SYSTEMS
Semester One 2023
Instructions
Instructions:
You must answer ALL parts of ALL questions in this exam, based on information given in the Exam Case.
Type your answers into the answer area(s) of each question. If an answer template is provided, copy and paste it into the answer area and structure your answer accordingly.
You may refer to any paper-based and/or digital resources during the exam and be sure to follow the Academic Integrity declaration.
Manage your time well, and do not forget to submit your exam at the end.
Brad loves Jeeps and he loves off-roading. Years ago, when his two boys were little, he would take a video camera to record the family camping trips they took together. One day, he decided to post one on YouTube to see whether anyone would watch it. It turned out that people liked his video and so he started posting more. Eight years later, half a million people subscribe to his channel, TRAILRECON, to watch Brad and his family build vehicles, test equipment, and go on overlanding adventures in the backcountry.
Along the way, Brad has been able to create a number of income streams:
YouTube ad revenue: Brad earns money when viewers watch advertisements that play before, during and after his videos.
Sponsorships: because of his large following, vehicle accessory manufactures (for example, rooftop tents, recovery equipment etc.) will pay Brad to showcase their products in his videos.
Merchandising: Brad has created a website (trailrecon.com), to sell a number of products from various vehicle accessory manufacturers. Brad will receive a percentage of the profits from any of their products sold on his website.
Brad is also looking to create a new income stream by creating a TRAILRECON membership package. This package will allow members to receive weekly news and updates, to receive a discount on all products on the website, to view videos in advance of the general public, and to attend in person meetups and ride along tours. He currently has data on all of his viewers, sponsors and purchasers of his products in an Excel spreadsheet and hopes that he will be able to use this data to target people to become members.
This case is based on TRAILRECON and more information can be found on trailrecon.com
1 Question 1
TRAILRECON runs its business using digital systems. It:
1. publishes and sells DIGITAL media;
2. promotes and sells vehicle accessories on a DIGITAL platform; and
3. collects and handles DIGITAL customer information.
For each of the three aspects above, suggest one specific example from the case. Describe one non-digital alternative way of doing it, then suggest one advantage and one disadvantage of doing it digitally. (15 marks)
Answer this question using the following template. Copy and paste the following template into the answer area to structure your answer:
1. Publishes and sells DIGITAL media
One specific example from the case:
One non-digital alternative way of doing it:
One advantage of doing it digitally:
One disadvantage of doing it digitally:
2. Promotes and sells vehicle accessories on a DIGITAL platform
One specific example from the case:
One non-digital alternative way of doing it:
One advantage of doing it digitally:
One disadvantage of doing it digitally:
3. Collects and handles DIGITAL customer information
One specific example from the case:
One non-digital alternative way of doing it:
One advantage of doing it digitally:
One disadvantage of doing it digitally:
2 Question 2
TRAILRECON is growing rapidly at the moment. They find that their record keeping with Excel spreadsheets is becoming difficult to manage. Suggest two typical issues about the Quality of Data (covered in INFOSYS110) that TRAILRECON may encounter if they carry on keeping their data on spreadsheets only. How may each of these two typical issues be addressed to minimise the resulting problems? Provide detailed suggestions specific to the case in your answer about how such issues can be addressed. (12 marks)
Answer this question using the following template. Copy and paste the following template into the answer area to structure your answer:
Relevant Quality of Data Issue #1:
Detailed Specific Suggestions to Address Such Issue:
Relevant Quality of Data Issue #2:
Detailed Specific Suggestions to Address Such Issue:
3 Question 3
Brad often showcases products he sells on his website in his videos, and in these videos, he provides direct links to the relevant products he sells for buyers to click on. Brad wants to understand how often viewers of his videos purchase products from his website.
1. What data mining technique could he use to find an answer? (2 marks)
2. What does this data mining technique do? (4 marks)
3. If the data showed that people who purchased tents also purchased chairs, tables and camp lights, what could Brad do to increase revenue? Provide two examples. (10 marks)
Answer this question using the following template. Copy and paste the following template into the answer area to structure your answer:
1. Data mining technique:
2. What this data mining technique does:
3. What Brad could do to increase revenue:
Example 1:
Example 2:
4 Question 4
Brad is putting together a project to create his membership package. In order to go live with this package, Brad will need to do contract developers to create an online portal in his website. This website will allow members to log into and communicate with other members, sign up to member only events, view videos earlier than the public, and access member discounts on products.
Brad has worked out a budget for this project and hopes to have it completed within a month.
It soon becomes clear that this is going to take longer than expected to complete, and Brad does not want to go live unless all of those requirements are met.
1. Explain what effect this will have on each aspect of the project management triangle (7.5 marks),
2. Outline one action that Brad could take to manage such effects (as suggested in part 1) (2.5 marks), and
3. Explain what output effect that action would have on one aspect of the project management triangle (5 marks).
Answer this question using the following template. Copy and paste the following template into the answer area to structure your answer:
1. Effect on aspects of the project management triangle:
Aspect 1:
Aspect 2:
Aspect 3:
2. Action that Brad could take:
3. Output effect on one aspect of the project management triangle:
Aspect:
Explanation:
5 Question 5
Brad is now nearly ready to launch his TRAILRECON membership. He’s trying to find ways to use the data he has on his viewers, sponsors and purchases of products to target people with marketing for his membership package.
Provide one ethical and two security considerations that Brad will need to be aware of in relation to keeping this data and using it to create targeted marketing materials. For each of these considerations, provide a way that Brad can mitigate the risk. (15 marks)
Answer this question using the following template. Copy and paste the following template into the answer area to structure your answer:
Ethical consideration:
Mitigation:
Security consideration (1):
Mitigation:
Security consideration (2):
Mitigation:
6 Question 6
TRAILRECON has grown very quickly and that has substantially increased Brad’s workload. As a result, Brad has been looking at ways to make things easier for him. Like many people, he’s been hearing a lot about ChatGPT over the last few months and he’s keen to understand how he might be able to find some practical ways to use ChatGPT to make things easier for him.
Provide a practical example of one Brad could use ChatGPT to assist him in each of the following areas. For each area you must provide a practical example, as well as one potential issue you see with each use case.
Creating video scripts (5 marks),
Creating website content (5marks),
Create routes and timelines for his off-roading adventure trips (5 marks).
Answer this question using the following template. Copy and paste the following template into the answer area to structure your answer:
Creating video scripts example:
Potential issue / risk:
Creating website content example:
Potential issue / risk:
Creating routes and timelines for off-roading adventure trips example:
Potential issue / risk:
7 Question 7
This question is not direclty based on the exam case.
This visualisation is not good. Critically examine the visualisation against Tuft’s Three Design Principles for Data Visualisation. For any principles that are breached, provide a suggestion to improve the visualisation. (12 marks)
Answer this question using the following template. Copy and paste the following template into the answer area to structure your answer:
Design Principle 1:
Suggestion:
Design Principle 2:
Suggestion:
Design Principle 3:
Suggestion: