Reference no: EM132498321

CIS5100 Professional Skills for Information Systems - University of Southern Queensland

LEARNING OBJECTIVES

Objective 1:critique information systems concepts to identify and resolve organisational problems and to develop ethical considerations within a business context

Objective 2:identify the appropriate information systems to develop practical solutions within a business context

Objective 3:communicate information systems concepts to both technical and non-technical audiences within a business context.

Part A: The first computer-based information system that Stan is interested in is a Database Management System (DBMS) utilising Microsoft Access (any version from Access 2007 to current). The DBMS will store all the business's customer details, information about the stock items that the business sells, the suppliers that the business uses and all postal order transactions for the business. It will allow Stan to run several queries on the data, which the business has specified below, and they wish to be able to print out an invoice for each customer at the end of each month.

Part B: The next computer-based information system that the business is interested in is a Decision Support System (DSS) utilising Microsoft Excel (any version from Excel 2007 to current). The DSS will analyse sales trends for the business to determine future courses of action for the business.

Stan would like the information in the Database Management System (DBMS) (Assignment 1 Part A) imported into Microsoft Excel (any version from Excel 2007 to current) so that the information can be summarised as a report and some future analysis of sales trends performed. The suppliers used by the business, source items from either Belgium (BE) or Canada (CA). They allow the business to select from either of these two regions on an ad hoc basic depending on the most favourable exchange rate at the time.

Stan has noted that several the business's competitors are providing a discount to customers who place large orders. The business would like to see what affect adopting a similar policy would have on the business. The business has also noted a growing number of online businesses are starting to provide free freight delivery as a way of encouraging more online business; the business would like to run a number of scenarios based on potential Mark-up and Freight options to ascertain the best combination for the business if they were to adopt this policy too.

Part C:Stan also has several questions relating to the two computer-based information systems in Part A & Part B that he would like you to answer, prepare an Essay to answer these questions he has listed.

Assignment 1: Part A (Database Management System)

Your firm's Systems Analyst has developed a database structure that has been determined to be suitable to create a database to store Stan's customer, item, supplier and order data for the business, which has been provided as follows:

Stan has provided to us a partial list of the business's customers, stock items, and suppliers and a partial list of the business's postal orders placed between January and June 2019 to use as test data in four comma delimited text files, which can be found on your firm's Intranet (CIS5100 Study Desk).
Dr ZatannaZatara, your manager, has set up the following tasks for you to complete for this phase of the project:
1. Create a Database and import the four (4) Text files into four (4) Tables
2. Modify Table Design
3. Set Primary Keys
4. Create Relationships between the Tables
5. Edit Customers Table
6. Create Data and Update Queries
7. Create an Invoice Report

Problem 1: Create and Import
Create a new blank Access Database (using any version from Access 2007 to current) and name it [lastname] [initial] _ [student number] _ [course code] _ assign1_(part_a).accdb
eg.genrichr_0050051005_cis5100_assign1_(part_a).accdb.
Import the four sets of data from your firm's Intranet (CIS5100 Study Desk).

The easiest and quickest way to import data into Access is by using the Import Text Wizard. The following steps must be followed carefully to ensure the data is imported correctly:
Importing Tab Delimited Text files into Access (any version from Access 2007 to current) using the Wizard
1) On the External Data tab, in the Import & Link group, click the Text File data source icon.
2) In the Get External Data - Text Filewizard popup, browse to find the ‘Assignment01 Text File Customers.txt' text file and select the Import the source data into a new table in the current database option - then click OK.
3) Select the Delimited - Characters such as commas or tab separate each field option on the first page of the wizard - then click Next.
4) Select the Tab option on the second page of the wizard and turn on the First Row Contains Field Namescheck box - then click Next.
5) Set the following for each field on the third page of the wizard:
• Field Name - keep the field name as it appears when imported
Note: Changing Field Names rather than using Captions will result in loss of marks.
• Data Type - giving each an appropriate data type (students will be marked on their logical choice of data types, based on the sample data provided).

• When you are sure that each field has the appropriate data type, click Next.
6) Select No Primary Key option on the fourth page of the wizard - these will be set in Problem 2 - then click Next.
7) Name the table tblCustomers on the final page of the wizard and click Finish.

Problem 2: Modify Table Design
Modify the four imported tables' structures using the given Table Specifications, from the section above, in Microsoft Access using Table Design View:

• Use the above table specifications, checking that you have the correct table names and field names.
• Check that all fields have the appropriate Data Typefrom the following:
o Text, Number, Date/Time, Currency, Yes/No, Hyperlink.
• Add appropriate Field Descriptionsto ALL data fields with a well-structured description, eg. for CustID an appropriate description would be:
Customer Identification | Data Type: Short Text: 3 Characters
• Ensure that you also set properties for each field where appropriate. You MUST set the following:
o Field Size- set appropriate logical fields sizes for all Text and Number data types (numbers without decimal places should be set to be either binary, integer or long integer; and numbers with decimal places should be set to be single or double).
o Caption- set an appropriate English caption for all fields where the field name is not in English (eg. Customer ID for CustID).
o Format- set an appropriate format for all: Yes/No and Date data fields; Text data fields that should be stored in Upper-Case (State); Hyperlinks data fields that should be stored in lower-case (EmailAddress); and numbers that contain currency or percentages.
• BE is the country code for Belgium - should be formatted in Euros;
• CA is the country code for Canada - should be formatted in Dollars.
o Decimals- set an appropriate number of decimal places for any single or double numbers
o Default Value- set an appropriate default value for all Yes / No data Fields
o Required- set any data Fields that must contain data to Required and leave any Fields where data is optional as unchecked.
o Validation Ruleand Validation Text- include appropriate Validation Rules for each of the following data Fields: Title; State; and Item Type. This ensures that only limited value options can be entered for these data Fields.

Problem 3: Set Primary Keys
Set the Primary Keys for the four (4) Tables as per the following table specifications in Microsoft Access using Table Design View:

Problem 4: Create Relationships between the Tables
Create the following relationships between the four (4) tables:

Problem 5: Edit Customers Table
Edit Customer ID 112 in the Customers Table as per the following instructions in Microsoft Access using Table Datasheet View:
1. Change the Title, Given Names and Family Name to your own details.
2. Change the Address, City, State and Postcode to your own details.
3. Using www.whereis.com.au look up the distance between your current address and Toowoomba QLD 4350(to the nearest kilometre) - change the Freight Distance to this new value.
4. Change the Mobile Number to your student ID eg. 0061 099999
› Do not use the u1099999 version.
5. Change the Email Address to your own details.
6. Select that you would like to be on the Business's Mail List.

Problem 6: Create Data and Update Queries
Create the following Three (3) queries using the Query Design View. Use the names given for each query to avoid confusion for the client (make sure you submit them in the order given below).
› You must create the Queries using Access Design View, if you create the Queries using SQL this will result in ZERO marks for the Query.
› Query names must conform to the Leszynski Naming Convention (LNC), as per the Naming Convention for Access Database Objects document in the Practical Appendixes found on the Study Schedule and Module Materials - including the Query Number and Two Meaningful Words to describe the query eg.qry1XxxxxxXxxxxx.
› Not all queries will require the inclusion of all four tables; you must decide which tables are appropriate for the generation of each query's output. Only tables needed should be included in the query design as extraneous tables could cause problems with the query results
Problem 7: Create an Invoice Report
Stan has provided you with the following sample Invoice. The client requires you to develop a similar invoice for their business.

Assignment 1: Part B (Decision Support System)

Dr ZatannaZatara, your manager, has set up the following tasks for you to complete for this phase of the
project:

1. Create a Spreadsheet and import the four (4) Access Tables into four (4) Worksheets
2. Data Validation Check
3. Create an Index Worksheet
4. Create a Data Input Worksheet Template for later use
5. Create a Calculations Worksheet Template for later use
6. Create Name Ranges for the Customers, Items, and Suppliers data
7. Create a Report Worksheet and set up the column headings
8. Modify the Report Worksheet by Cell Referencing all the Orders Table data
9. Modify the Report Worksheet by using VLOOKUP to get Customer, Item and Supplier data
10. Modify the Data Input Worksheet to include extra data needed for later tasks
11. Modify the Report Worksheet by using a Nested IF to calculate Cost Price (AU)
12. Modify the Report Worksheet by using a Nested IF to calculate Selling Price
13. Modify the Report Worksheet by using a Nested IF to calculate Freight Cost
14. Modify the Report Worksheet by using a AND / IF to calculate Item Discount
15. Modify the Report Worksheet by using simple formulas to find Purchases and Sales, and Modify the Report Worksheet by using a formula to calculate the Order Discount
16. Modify the Data Input Worksheet to include extra data needed for later tasks
17. Modify the Calculations Worksheet by using simple formulas
18. Modify the Data Input Worksheet by Cell Referencing all the Calculations data
19. Create eight (8) Scenarios on the Data Input Worksheet
20. Create a Scenario Summary of the eight (8) Scenarios
21. Create a Documentation Worksheet
22. Create an Analytical Essay to describe the findings made using the Spreadsheet
Problem 1: Create and Import
Open a single new Excel (any version from Excel 2007 to current) spreadsheet and name the file - ‘[lastname] [initial] _ [student number] _ [course code] _ [assignment number]_(part_b)'
eg.genrichr_0050051005_cis5100_assign1_(part_b).xlsx.
Import the following four (4) database tables from your Assignment 1 Microsoft Access (any version from Access 2007 to current) Database File and into Microsoft Excel (any version from Excel 2007 to current) (tblCustomers, tblItems, tblSuppliers, tblOrders). The easiest and quickest way to import data from Access (any version from Access 2007 to current) into Excel (any version from Excel 2007 to current) is by using the "Import From Access" Wizard. The following steps will assist you with this process:
8) Select the first unused tab at the bottom of the Spreadsheet, right click on it and rename it "CustomersTable".

9) Put a heading at the top of the worksheet in cell A1 called "Customers Table".
10) Go to the DataIcon Ribbon (see below)

11) Click on the From Access option in the Get External Dataicon area.
12) In the Get External Data - From Accesswizard popup, browse to find your Assignment 1 Access Database file and select the - then click Open.
13) In the Select Tablewizard popup, select tblCustomers - click OK.
14) In the Import Datawizard popup, select Tableand Existing Worksheet$A$3 as the location to Import the place to put the data.
15) Select the Table Style you wish to apply to this table.
› Note: You should consider the colours from a professional perspective.
16) Left click anywhere on the imported data in worksheet then go to the DesignIcon Ribbon and select Convert to Range then click OK.
› Note: If you use Excel Tables to change the background colours of a worksheet anywhere in your Spreadsheet, you must perform this Convert to Range otherwise marks will be deducted.
17) Check that the data has correctly been imported correctly into this worksheet.
18) Modify the layout of the data to a professional level of presentation, making sure that the headings are in English (Customer ID not CustID).

Problem 2: Data Validation Check
Check the imported data in the CustomersTable, ItemsTable, SuppliersTable and OrdersTable to ensure that:
1. The column headings are displayed correctly
2. The content of each column displays in a format that appears valid for that type of data (apply appropriate formatting if required).
3. The content of each column contains complete and accurate data values (eg. Phone numbers are not truncated).
4. The content of each column contains reasonable data values for the use of this business.

Problem 3: Index Worksheet
Add a worksheet labelled Index before the four tables from Problem 1. Put a heading at the top of the worksheet in cell A1 called Index Worksheet. Ensure that it contains all the recommended data for this worksheet listed in the Practical Appendixes found on the Study Schedule and Module Materials - Spreadsheet design considerations.

Problem 4: Data Input Worksheet Template
Add a worksheet labelled DataInput after the Index worksheet from Problem 3 (but before the four tables from Problem 1) that conforms to the Practical Appendixes found on the Study Schedule and Module Materials - Spreadsheet design considerations. Put a heading at the top of the worksheet in cell A1 called Data Input Worksheet and then input the following template in the exact cell shown below onto this worksheet.

Problem 5:Calculations Worksheet Template
Add a worksheet labelled Calculations after the DataInput worksheet from Problem 3 (but before the four tables from Problem 1) that conforms to the Practical Appendixes found on the Study Schedule and Module Materials - Spreadsheet design considerations. Put a heading at the top of the worksheet in cell A1 called Calculations Worksheet and then input the following template in the exact cells shown below onto this worksheet.

Problem 6: Name Ranges
On the CustomersTable, ItemsTable and SuppliersTable worksheets set the following Cell Range Names:
• Cust- on all the data (not headings) in the CustomersTable worksheet
• Itms- on all the data (not headings) in the ItemsTable worksheet
• Supp- on all the data (not headings) in the SuppliersTable worksheet

Problem 7: Report Worksheet Headings
Add a worksheet labelled Report after the Calculations worksheet from Problem 5 (but before the four tables from Problem 1) that conforms to the Practical Appendixes found on the Study Schedule and Module Materials - Spreadsheet design considerations. Put a heading at the top of the worksheet in cell A1 called Report Worksheet and then type the following column headings, starting in cell A3:
• Customer ID, Title, Family Name, Given Names, Address, City, State, Postcode, Distance (km), Item ID, Type, Description, Size, Freight Weight (Kg), Supplier ID, Supplier Name, Supplier Recommended Markup (%), Order Date, Order Qty, Cost Price (BE), Cost Price (CA), Cost Price (AU), Selling Price, Item Discount, Purchases, Sales, Freight Cost, Order Discount.

Problem 8: Report Worksheet Cell Reference
On the Reportworksheet, Use the Cell References formula, to obtain all 2500 rowsof data from the OrdersTableworksheet for the following.
• Customer ID, Item ID, Order Date, Order Qty.
(For example, type =OrdersTable!A4 to reference data in cell A4 of the OrdersTable worksheet.)

Problem 9: Report Worksheet VLOOKUP
On the Reportworksheet use the VLOOKUP function with the Cell Range Names (Problem 6), obtain all 2500 rows of data from the CustomersTable, ItemsTable and SuppliersTable worksheets for the following.

Problem 10: Modify Data Input Worksheet
On the DataInput worksheet perform the following:
• Create the following six (6) extra Range Names for use in Tasks 10 to 15:
• Type StoreMarkup into the cell D4 containing the phrase: [Insert Markup Type here],
• Type 97.5% into the cell D6 containing the phrase: [Insert Store MarkUp % here],
• Type BEinto the cell D7 containing the phrase: [Insert Exchange Rate Type here],
• Type the current Exchange Rate BE to AUinto the cell containing the phrase: [Lookup & Insert BE to AU Exchange Rate here] and replace the "as at xx/xx/xx" with the date you looked up the exchange rate.
• Type the current Exchange Rate CA to AUinto the cell containing the phrase: [Lookup & Insert CA to AU Exchange Rate here] and replace the "as at xx/xx/xx" with the date you looked up the exchange rate.

Problem 11: Report Worksheet Cost Price (AU) Nested IF
On the Report worksheet:

1. Develop an IF function using the new RecommendedExchange Rate Type value (from the DataInput worksheet to calculate the Cost Price (AU) (in the Cost Price (AU) column) using the following criteria:

2. Ensure that you include rounding (to 2 decimal places - BeskeenExcel Chapter 17) into each calculation in your IF function and error checking(Beskeen Excel Chapter 18) to avoid incorrect results due to typing mistakes.

3. Test the IF function: Once you have completed the Cost Price (AU) IF function, perform the following two tests on it to ensure that it is working correctly:
• On the DataInput worksheet, type CA into the Exchange Rate Type cell.
• Go to the Report worksheet and observe whether the Cost Price (AU) have changed.
• On the DataInput worksheet, type GIGO into the Exchange Rate Type cell.
• Go to the Report worksheet and observe whether the Cost Price (AU) now displays an error message.
• On the DataInput worksheet, replace the word GIGO with one of the two valid values for the Exchange Rate Type cell.

Problem 12: Report Worksheet Selling Price Nested IF

1. Develop an IF function using the new RecommendedMarkUp Type value (from the DataInput worksheet) to calculate the Selling Price (in the Selling Price column) using the following criteria:
• If the MarkUp Type is Store Markup then the Selling Price is calculated by increasing Cost Price bythe Store's Recommended MarkUp % from the DataInput worksheet
2. Ensure that you include rounding (to 2 decimal places - BeskeenExcel Chapter 17) into each calculation in your IF function and error checking(Beskeen Excel Chapter 18) to avoid incorrect results due to typing mistakes.

3. Test the IF function: Once you have completed the Selling Price IF function, perform the following two tests on it to ensure that it is working correctly:
• On the DataInput worksheet, type SupplierMarkup into the MarkUp Type cell.
• Go to the Report worksheet and observe whether the Selling Prices have changed.
• On the DataInput worksheet, type GIGO into the MarkUp Type cell.
• Go to the Report worksheet and observe whether the Selling Prices now displays an error message.
• On the DataInput worksheet, replace the word GIGO with one of the two valid values for the MarkUp Type cell.

Problem 13: Report Worksheet IF / AND: Item Discount
1. On the Reportworksheet develop an IF / AND function to calculate the amount of ItemDiscount given to an individual item on an order (in the Item Discount column) using the following criteria:
2. Ensure that you include rounding (to 2 decimal places- BeskeenExcel Chapter 17) into the calculation in your IF / AND function.

3. Test the IF function: Once you have completed the Item Discount IF / AND function and filled it down the column, review the values to ensure that it is working correctly in the following situations:
1. OrderQty is less than three (3) and Selling Price is less than or equal to $100.00, should result in $0.00 ItemDiscount.
2. OrderQty is less than three (3) and SellingPrice is greater than $100.00, should result in $0.00 ItemDiscount.
3. OrderQty is greater than or equal to three (3) and SellingPrice is less than or equal to $100.00, should result in $0.00 ItemDiscount.
4. OrderQty is greater than or equal to three (3) and SellingPrice is greater than $100.00, should result in an ItemDiscount.

Problem 14: Report Worksheet Purchases, Sales and Order Discount Formulas
On the Reportworksheet calculate the following three simple formulas:
1. Purchases by multiplying Order Qty with Cost Price (AU).
Hint:
Cost Price (AU) x Order Qty
2. Sales by multiplying Order Qty by the difference of Selling Price less the Item Discount amount.
Hint:
(Selling Price - Item Discount) x Order Qty
3. Order Discount by multiplying Order Qty with Item Discount.
Hint:
Item Discount x Order Qty

Problem 15: Report Worksheet Freight Cost Nested IF
1. On the DataInput worksheet, type Oswald Chesterfield Cobblepot Freightinto the cell containing the phrase: [Insert Freight Type here].
2. On the Reportworksheet develop an IF function using the new RecommendedFreight Type value (from the DataInput worksheet to calculate the Freight Cost (in the Freight Cost column) using the following criteria:
• If the Freight Type is Oswald Chesterfield Cobblepot Freight, then the Freight Cost is calculated at two dollars and ninety-nine cents ($2.99)per kilogram of the item's freight weight and a quarter of a cent ($0.0025)per kilometre (Distance) if over 250 km (otherwise there is no cost for Distance) per item ordered (Order Qty).
Hint:
($2.99 x Item Weight + IF(Distance >250 km, $0.0025 x Distance, 0)) x OrderQty
• If the Freight Type isNorman Osborn Transport, then the Freight Cost is calculated at one dollars andseventy-fivecents ($1.75) for the firstthree-quarters of a kilogram (0.75 kg)and then at two dollars and seventy-five ($2.75) per kilogram of the item's freight weight over the firstthree-quarters of a kilograms (0.75 kg) per item ordered (Order Qty).

3. Ensure that you include rounding (to 2 decimal places - BeskeenExcel Chapter 17) into each calculation in your IF function and error checking(Beskeen Excel Chapter 18) to avoid incorrect results due to typing mistakes.
4. Test the IF function: Once you have completed the Freight Cost IF function, perform the following three tests on it to ensure that it is working correctly:
• On the DataInput worksheet, type Norman Osborn Transport into the Freight Type cell.
• Go to the Report worksheet and observe whether the Freight Costs have changed.
• On the DataInput worksheet, type GIGO into the Freight Type cell.
• Go to the Report worksheet and observe whether the Freight Costs now displays an error message.
• On the DataInput worksheet, replace the word GIGO with one of the two valid values for the Freight Type cell.

Problem 16: Modify Data Input Worksheet
On the DataInputworksheet:
1. Replace the phrase "[Insert Bank Charges Expenses here]" in cell D15 with $137.77
2. Replace the phrase "[Insert Electricity Expenses here]" in cell D16 with $5,675.62
3. Replace the phrase "[Insert Freight Inwards Expense here] " in cell D17 with $33,343.99
4. Replace the phrase "[Insert Internet Expense here] " in cell D18 with $1,824.06
5. Replace the phrase "[Insert Telephone Expenses here]" in cell D19 with $4,242.40
6. Replace the phrase "[Insert Wages Expenses here]" in cell D20 with $54,142.02

Problem 17: Calculations Worksheet Formulas
On the Calculationsworksheet calculate the following four simple formula.
1. Replace the phrase in D4"[Insert Formula here]" with a function to calculate the Total Sales by adding all the Sales in the Sales column on the Reports worksheet.
2. Replace the phrase in D7 "[Insert Formula here]" with a function to calculate the Total Half Year Fixed Expenses by adding all the Half Year Fixed Expenseson the DataInput worksheet.
3. Replace the phrase in D10 "[Insert Formula here]" with a function to calculate the Total Purchases Expensesby adding all the Purchasesin the Purchases column on the Reports worksheet.
4. Replace the phrase in D11 "[Insert Formula here]" with a function to calculate the Total Freight Outward Expensesby adding all the Freight Costsin the Freight Cost column on the Reports worksheet.
5. Replace the phrase in D12 "[Insert Formula here]" with a formula to calculate the Percentage Freight Outwards of Total Sales bydividing the Total Freight Outward Expenses by the Total Sales.
6. Replace the phrase in D14 "[Insert Formula here]" with a formula to calculate the Total Half Year Fixed & Variable Expenses by adding all the Half Year Fixed Expensesand Half Year Variable Expenseson the Calculations worksheet.
7. Replace the phrase in D16 "[Insert Formula here]" with a formula to calculate the Total Profit by subtracting the Total Half Year Fixed & Variable Expenses from the Total Saleson the Calculations worksheet.
8. Replace the phrase in D18 "[Insert Formula here]" with a function to calculate the Total Discount for Orders by using the SUMIF() functionto add up all cells with an Order Discount greater than 0 in the Order Discount column on the Reports worksheet.
9. Replace the phrase in D19 "[Insert Formula here]" with a function to calculate the Percentage Discount of Total Sales bydividing the Total Discount for Orders by the Total Sales.
10. Replace the phrase in D20 "[Insert Formula here]" with a function to calculate the Number of Orders where a Discount was Applied by using the COUNTIF() functionto count all cells with an Order Discount greater than 0 in the Order Discount column on the Reports worksheet.

Problem 18: Data Input Cell References
On the DataInputworksheet:
1. Replace the phrase "[Insert Cell Reference Here]" in cell D12with a cell reference to the Total Sales amount on the Calculations worksheet.
2. Replace the phrase "[Insert Cell Reference Here]" in cell D22 with a cell reference to the Total Half Year Fixed Expenses amount on the Calculations worksheet.
3. Replace the phrase "[Insert Cell Reference Here]" in cell D25 with a cell reference to the Total Purchases Expenses amount on the Calculations worksheet.
4. Replace the phrase "[Insert Cell Reference Here]" in cell D26 with a cell reference to the Total Freight Outwards Expenses amount on the Calculations worksheet.
5. Replace the phrase "[Insert Cell Reference Here]" in cell D27 with a cell reference to the Percentage Freight Outwards of Total Sales amount on the Calculations worksheet.
6. Replace the phrase "[Insert Cell Reference Here]" in cell D29 with a cell reference to the Total Half Year Fixed and Variable Expenses amount on the Calculations worksheet.
7. Replace the phrase "[Insert Cell Reference Here]" in cell D31 with a cell reference to the Total Profit amount on the Calculations worksheet.
8. Replace the phrase "[Insert Cell Reference Here]" in cell D32 with a cell reference to the Total Discount for Orders amount on the Calculations worksheet.
9. Replace the phrase "[Insert Cell Reference Here]" in cell D33 with a cell reference to the Percentage Discount of Total Sales amount on the Calculations worksheet.
10. Replace the phrase "[Insert Cell Reference Here]" in cell D34 with a cell reference to the No. Orders Discount Applied amount on the Calculations worksheet.

Problem 19: Scenarios
Using the Scenario Manager in Excel create and check the following eight (8) Scenarios using the Changing Cells of D4, D5 and D7 on the DataInput worksheet:
Problem 20: Scenario Summary
Using the Scenario Manager in Excel create a Scenario Summary worksheet from the DataInput worksheet based on the eight (8) Scenarios from Problem 19 and focusing on the Result cells D12, D22, D25, D26, D27, D29, D31, D32, D33 and D34on the DataInput worksheet.

Problem 21: Documentation Worksheet
Add a Documentation worksheet after the four tables from Problem 1. Put a heading at the top of the worksheet in cell A1 called Documentation. Ensure that contains all the recommended information for this worksheet listed in the Practical Appendixes found on the Study Schedule and Module Materials - Spreadsheet design considerations.
The Documentation Worksheet must demonstrate the following:
• A statement outlining the purpose of the Spreadsheet:
• A statement about the protection level that should be used on each Worksheet.
• A statement about how the user can access and use the Worksheets.

Assignment 1: Part C (Analytical Essay)
Dr ZatannaZatara has asked you to develop an analytical essay (between 750 and 1000 words in length) to the client, Stan outlining the major issues that the Decision Support System's results have highlighted. Create a Word Document (using Word 2007 to current) and name it ‘[lastname] [initial] _ [student number] _ [course code] _ [assignment number_(part_c)'
The body of your essay should consider the following issues:
From Part A (Approx. 250 - 350 words):
• Define what a Database Management System is.
• Explain why a Database Management System is the appropriate tool for this project.
From Part B (Approx. 500 - 650 words):
• Define what a Decision Support System is.
• Explain why a Decision Support System is the appropriate tool for this project.
• From the results of the Decision Support System results discuss the following (keeping in mind the information provided in the preamble on page 2):
» Which Mark-up Type would be most appropriate for the business? Why?
(Optimal Scenario, Optimal Total Sales, and Optimal Total Profit)
» What would be the impact on the business's profit if the plan to provide a discount to large orders were implemented? Why?
(Minimum & Maximum Discounts Applied)
» Which Recommended Freight Type would be most appropriate for the business? Why?
(Optimal Scenario, Optimal Total Freight Outward, and Optimal Total Profit)
» Which country would be most appropriate for the business to import from at the moment? Why?
(Optimal Scenario, Optimal Total Sales, and Optimal Total Profit)

Attachment:- Database Management System and Decision Support System.rar