Scribd
Upload
5 views21 pages

DSS Assessment and Progress Report Memo

The document outlines the assessment tasks for CIS5100, focusing on creating a Decision Support System (DSS) and includes a progress report memo by student Sapna Kumari. It details various tasks such as data validation, calculations, and report generation, emphasizing the importance of decision-making processes supported by intelligent systems. The memo also highlights the structure of DSS, including inputs, processes, outputs, and feedback, along with the use of formulas and visual aids for management understanding.

Uploaded by

FarhanAshraf
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views21 pages

DSS Assessment and Progress Report Memo

The document outlines the assessment tasks for CIS5100, focusing on creating a Decision Support System (DSS) and includes a progress report memo by student Sapna Kumari. It details various tasks such as data validation, calculations, and report generation, emphasizing the importance of decision-making processes supported by intelligent systems. The memo also highlights the structure of DSS, including inputs, processes, outputs, and feedback, along with the use of formulas and visual aids for management understanding.

Uploaded by

FarhanAshraf
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Assessment Task Information

Course Details: CIS5100 Practical Skills for Information


Systems
Problem Solving Assessment 1
Decision Support System (DSS) and Progress Report Memo

Student Name: Sapna Kumari


Student ID: U1156960
Task 1: Create and Import
File Naming

Data Import
Task 2: Data Validation Check
Task 3: Editing Table Data
Task 4: Index Worksheet

Task 5: Data Input Worksheet Template

Task 6: Calculations Worksheet Template


Task 7: Name Ranges
Task 8: Report Worksheet Headings
Task 9: Report Worksheet Cell Reference
Task 10: Report Worksheet VLOOKUP
Task 11: Modify Data Input Worksheet
Task 12: Report Worksheet Cost Price (AU) Nested IF
Task 13: Report Worksheet Selling Price Nested IF

Task 14: Report Worksheet IF / AND: Item Discount

 If the Selling Price for that item is greater than $100.00 AND the Order Qty is greater than or
equal to three (3) of the same item in any single order then the Item Discount is calculated at
7.125% of the Selling Price for that item, otherwise the Item Discount is zero.
 Ensure that you include rounding (to 2 decimal places) into the calculation in your IF / AND
function.
 Test the IF function: Once you have completed the Item Discount IF / AND function, review the
values to ensure that it is working correctly in the following situations:
o Selling Price is less than or equal to $100.00 and Order Qty is less than three (3), should
result in $0.00 Item Discount.
o Selling Price is greater than $100.00 and Order Qty is less than three (3), should result
in $0.00 Item Discount.
o Selling Price is less than or equal to $100.00 and Order Qty is greater than or equal to
three (3), should result in $0.00 Item Discount.
o Selling Price is greater than $100.00 and Order Qty is greater than or equal to three (3),
should result in an Item Discount.

Task 15: Report Worksheet Purchases, Sales and Order Discount Formulas
Task 16: Report Worksheet Freight Cost Nested IF

Task 17: Modify Data Input Worksheet


Task 18: Calculations Worksheet Formulas

Task 19: Data Input Cell References


Task 20: Scenarios
Task 21: Scenario Summary Analysis

Task 22: Documentation Worksheet


Task 23: Visualisation of the DSS Data

Task 24: Progress Report Memo

Documentation worksheet

DATE: 16-04-2023
TO: All members
FROM: Sapna Kumari
SUBJECT: Report Overview

Purpose:
The purpose of this memo report is the provide the overview of decision based systems output
and to provide visual effects in front of management to decide on the basis of results.
Decision based support systems are programs that are used to improve the company’s decision
making processes on the basis of these intelligent systems. DSS are the computer based system
which will be used in decision making for companies and advance forecasting.

 Inputs are the set of start of processes from process will be started.
 Processes are the procedure which will be used for processing on the basis of inputs.
 Output is the result which is calculated on the basis of inputs and processing
 Feedback is used for the review after processing of system.

Different formulas a rules are used for the processing on the inputs and generates results.
These results will be displayed in the form of charts and graphs which are easier for
understanding of management.
Best Regards,
Sapna Kumari

You might also like