Business Decision-Making Assignment: Microsoft Productivity Tools, Excel Analysis & PowerPoint Presentation

Assignment Tasks

Task 1

You have joined the technical support team at a small firm with 100 employees planning for rapid expansion. The company currently relies heavily on paper-based systems. A small core team is IT-literate, but the majority lack knowledge about productivity tools and their benefits.

Requirement:

Prepare a report explaining the benefits of using Microsoft productivity tools and the necessary skills expected of working professionals, university, or college graduates.

Report Guidelines:

• Format: Use Microsoft Word to create the report with the following features:
  • Table of Contents (TOC) with auto page numbers.
  • Proper use of headings.
  • Tables and figures as needed.
  • Manage Sources for references.
• Content: Include the following:
  • Explanation of Microsoft productivity tools (e.g., Word, Excel, PowerPoint, Teams).
  • Benefits for the workplace.
  • Importance of IT skills for employability.
  • Support arguments with references to relevant literature.
• Word Count: 900 words.
• Marks: 30 Marks.
• Learning Outcomes: LOs 1, 2, 3 & 4.

Task 2

Scenario:
You are provided with sales data by your tutor. The data is not in an easily usable format and needs to be organized and analyzed using Microsoft Excel.

Requirements:

1. Create a Spreadsheet:
   • Organize the sales data with proper formatting.
   • Include headings and appropriate column widths.
   • Create properly named worksheets (tabs).
2. Perform Calculations:
   • Add a new column called Profit and calculate the profit for each sale.
   • Add a column called Predicted Profit 10% to calculate the profit with a 10% selling price increase.
   • Calculate total profit across all sales.
3. Use COUNTIF Function:
   • Count the number of instances of the London district in the data.
   • Count the number of instances of the Envelopes product.
4. Create and Format Charts:
   • Use Pivot Tables to generate data for charts.
   • Create separate charts for:
     • Sum of quantities sold per salesperson.
     • Sum of quantities sold per district.
     • Sum of quantities sold per product.
   • Place each chart on a separate worksheet (tab) and label them appropriately.

Guidelines:

• Ensure formulas are efficient, scalable, and compact.
• Avoid adding unnecessary calculations or columns.
• Word count equivalent: 1200 words.
• Marks: 40 Marks.
• Learning Outcomes: LOs 2, 3 & 4.

Task 3

Scenario:
You are tasked with creating a PowerPoint presentation for managers to facilitate business decision-making based on sales performance data.

Requirements:

1. Include Charts from Task 2:
   • Add the charts created in Task 2 (as images).
2. Create Additional Charts:
   • Analyze sales performance in terms of profits and create new charts for:
     • Best-performing products, salespersons, and districts.
     • Worst-performing products, salespersons, and districts.
3. Prepare the Presentation:
   • Include a Title Slide and a Summary Slide.
   • Create at least 8 slides in total.
   • Explain insights from each chart to aid decision-making.
4. Design Guidelines:
   • Use effective slide design, color schemes, and typefaces.
   • Incorporate media elements to enhance presentation quality.

Guidelines:

• Word count equivalent: 900 words.
• Marks: 30 Marks.
• Learning Outcomes: LOs 2, 3 & 4.

Submission Instructions:

• Submit 3 separate files in the correct format:
  1. Microsoft Word file for Task 1.
  2. Microsoft Excel file for Task 2.
  3. Microsoft PowerPoint file for Task 3.
• Use the provided sales data file for Task 2.

please note; 3 sperate files must be submitted. 1 for each task in the correct format.i have attached a file which contain figures for task 2 excel spreadsheet please use these figures to complete task 2.

Answer

Request Answer of this Assignment