Description
Page 1
College of Computing and Informatics
مقيد – Restricted
Assignment 1
Deadline: 14 /07/2024 @ 23:59
[Total Mark for this Assignment is 15]
Student Details:
Name: ###
CRN: ###
ID: ###
Instructions:
• You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on
Blackboard via the allocated folder. These files must not be in compressed format.
• It is your responsibility to check and make sure that you have uploaded both the correct files.
• Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between
words, hide characters, use different character sets, convert text into image or languages other than English
or any kind of manipulation).
• Email submission will not be accepted.
• You are advised to make your work clear and well-presented. This includes filling your information on the cover
page.
• You must use this template, failing which will result in zero mark.
• You MUST show all your work, and text must not be converted into an image, unless specified otherwise by
the question.
• Late submission will result in ZERO mark.
• The work should be your own, copying from students or other resources will result in ZERO mark.
• Use Times New Roman font for all your answers.
Page 2
Pg. 01 Question One
مقيد – Restricted
Question One
Create a comprehensive information dashboard for a retail company using Excel. The
dashboard should visualize the company’s sales data over the past year, including
monthly sales figures, product category performance, and regional sales
distribution. Your dashboard should include the following features:
• At least three different types of charts or graphs (e.g., line chart, bar chart, pie
chart) to represent the data.
• Key performance indicators (KPIs) that are relevant to the retail industry.
• Contextual metadata, such as data sources and last updated date.
• Alerts/exceptions prioritization to highlight critical issues.
• Space for business-user comments to add context to the data.
Ensure your dashboard adheres to best practices in design, including presenting
information in three different levels (monitoring, analysis, management) and validating
the design with usability principles.
Submission Guidelines:
• Submit your Excel file with the completed dashboard.
• Provide a brief (300-500 words) accompanying document explaining your
design choices, the data represented, and how the dashboard can be used to
support decision-making.
Learning
Outcome(s):CLO2
Instructors:
Describe
advanced
Business
Intelligence,
Business
Analytics, Data
Visualization, and
Dashboards.
3 Marks
Page 3
Pg. 02 Question Two
مقيد – Restricted
Question Two
Develop a decision tree to evaluate the expected monetary value (EMV) of three
potential expansion strategies for a retail company under different market conditions.
Use the following decision alternatives and market conditions:
Decision Alternatives:
1. Open a New Store
2. Launch an Online Sales Platform
3. Expand Product Lines in Existing Stores
Market Conditions:
• Strong Growth (probability: 0.4)
• Moderate Growth (probability: 0.4)
• Decline (probability: 0.2)
Expected Monetary Values (EMVs) for Each Strategy:
1. Open a New Store:
o Strong Growth: $500,000
o Moderate Growth: $200,000
o Decline: -$100,000
2. Launch an Online Sales Platform:
o Strong Growth: $300,000
o Moderate Growth: $150,000
o Decline: $0
3. Expand Product Lines in Existing Stores:
o Strong Growth: $250,000
o Moderate Growth: $100,000
o Decline: -$50,000
Calculate the EMV for each strategy under these market conditions and determine the
optimal strategy for the company. Submit a report explaining your analysis and
conclusion.
Learning
Outcome(s):CLO3
Instructors:
Recognize DSS
evolution to the
current state of
analytics and
artificial
intelligent.
3 Marks
Page 4
Pg. 03 Question Three
مقيد – Restricted
Question Three
Explain the significance of deep learning and cognitive computing in modern decision
support systems, highlighting key concepts, differences from traditional methods, and
real-world applications.
Learning
Outcome(s):CLO4
Instructors:
Analyse various
industrial
applications of
DSS and their
limitations.
3 Marks
Page 5
Pg. 04 Question Four
مقيد – Restricted
Question Four
The classical framework of decision support system is usually represented in 3×3
matrix including structured and unstructured decisions, explain only those two
mentioning their types of controls and provide some examples of each.
Learning
Outcome(s):CLO1
Instructors:
Demonstrate an
understanding of
the concepts of
decision analysis
and decision
support systems
(DSS) including
probability,
modelling,
decisions under
uncertainty, and
real-world
problems.
3 Marks
Page 6
Pg. 05 Question Five
مقيد – Restricted
Question Five
Define the term Analytics and explain its types providing some examples of each.
Learning
Outcome(s):CLO2
Instructors:
Describe
advanced
Business
Intelligence,
Business
Analytics, Data
Visualization, and
Dashboards.
3 Marks
Purchase answer to see full
attachment
College of Computing and Informatics
مقيد – Restricted
Assignment 1
Deadline: 14 /07/2024 @ 23:59
[Total Mark for this Assignment is 15]
Student Details:
Name: ###
CRN: ###
ID: ###
Instructions:
• You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on
Blackboard via the allocated folder. These files must not be in compressed format.
• It is your responsibility to check and make sure that you have uploaded both the correct files.
• Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between
words, hide characters, use different character sets, convert text into image or languages other than English
or any kind of manipulation).
• Email submission will not be accepted.
• You are advised to make your work clear and well-presented. This includes filling your information on the cover
page.
• You must use this template, failing which will result in zero mark.
• You MUST show all your work, and text must not be converted into an image, unless specified otherwise by
the question.
• Late submission will result in ZERO mark.
• The work should be your own, copying from students or other resources will result in ZERO mark.
• Use Times New Roman font for all your answers.
Page 2
Pg. 01 Question One
مقيد – Restricted
Question One
Create a comprehensive information dashboard for a retail company using Excel. The
dashboard should visualize the company’s sales data over the past year, including
monthly sales figures, product category performance, and regional sales
distribution. Your dashboard should include the following features:
• At least three different types of charts or graphs (e.g., line chart, bar chart, pie
chart) to represent the data.
• Key performance indicators (KPIs) that are relevant to the retail industry.
• Contextual metadata, such as data sources and last updated date.
• Alerts/exceptions prioritization to highlight critical issues.
• Space for business-user comments to add context to the data.
Ensure your dashboard adheres to best practices in design, including presenting
information in three different levels (monitoring, analysis, management) and validating
the design with usability principles.
Submission Guidelines:
• Submit your Excel file with the completed dashboard.
• Provide a brief (300-500 words) accompanying document explaining your
design choices, the data represented, and how the dashboard can be used to
support decision-making.
Learning
Outcome(s):CLO2
Instructors:
Describe
advanced
Business
Intelligence,
Business
Analytics, Data
Visualization, and
Dashboards.
3 Marks
Page 3
Pg. 02 Question Two
مقيد – Restricted
Question Two
Develop a decision tree to evaluate the expected monetary value (EMV) of three
potential expansion strategies for a retail company under different market conditions.
Use the following decision alternatives and market conditions:
Decision Alternatives:
1. Open a New Store
2. Launch an Online Sales Platform
3. Expand Product Lines in Existing Stores
Market Conditions:
• Strong Growth (probability: 0.4)
• Moderate Growth (probability: 0.4)
• Decline (probability: 0.2)
Expected Monetary Values (EMVs) for Each Strategy:
1. Open a New Store:
o Strong Growth: $500,000
o Moderate Growth: $200,000
o Decline: -$100,000
2. Launch an Online Sales Platform:
o Strong Growth: $300,000
o Moderate Growth: $150,000
o Decline: $0
3. Expand Product Lines in Existing Stores:
o Strong Growth: $250,000
o Moderate Growth: $100,000
o Decline: -$50,000
Calculate the EMV for each strategy under these market conditions and determine the
optimal strategy for the company. Submit a report explaining your analysis and
conclusion.
Learning
Outcome(s):CLO3
Instructors:
Recognize DSS
evolution to the
current state of
analytics and
artificial
intelligent.
3 Marks
Page 4
Pg. 03 Question Three
مقيد – Restricted
Question Three
Explain the significance of deep learning and cognitive computing in modern decision
support systems, highlighting key concepts, differences from traditional methods, and
real-world applications.
Learning
Outcome(s):CLO4
Instructors:
Analyse various
industrial
applications of
DSS and their
limitations.
3 Marks
Page 5
Pg. 04 Question Four
مقيد – Restricted
Question Four
The classical framework of decision support system is usually represented in 3×3
matrix including structured and unstructured decisions, explain only those two
mentioning their types of controls and provide some examples of each.
Learning
Outcome(s):CLO1
Instructors:
Demonstrate an
understanding of
the concepts of
decision analysis
and decision
support systems
(DSS) including
probability,
modelling,
decisions under
uncertainty, and
real-world
problems.
3 Marks
Page 6
Pg. 05 Question Five
مقيد – Restricted
Question Five
Define the term Analytics and explain its types providing some examples of each.
Learning
Outcome(s):CLO2
Instructors:
Describe
advanced
Business
Intelligence,
Business
Analytics, Data
Visualization, and
Dashboards.
3 Marks
Purchase answer to see full
attachment
