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.

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.

Order ID	Date	Customer ID	Name of Customer	Salesperson	District	Product	Cost Price	Selling Price	Quantity Sold
18	29/12/2018	7	Thomson Group	Gareth Evans	Hull	Labels	60	90	9
8	22/04/2019	9	Tasko	Roger Waters	Bristol	Fasteners	20	30	15
6	15/09/2019	3	Salisburys	Bobby Smith	Hull	Paper	30	50	7
16	02/06/2018	2	Askwith and Jones	Bobby Smith	Coventry	Folders	40	70	5
14	27/12/2018	6	Pearson Group	Frederick Walters	Cardiff	Paper	30	50	6
3	07/08/2019	8	Sparrow Bank	Anne-Marie Jones	Leicester	Envelopes	100	150	7
10	28/04/2019	1	Virago	Anne-Marie Jones	Cardiff	Labels	60	90	10
4	30/11/2019	8	Sparrow Bank	Helen Davidson	Hull	Folders	40	70	9
9	02/04/2018	6	Pearson Group	Alison Smith	Barmouth	Envelopes	100	150	5
5	05/04/2019	8	Sparrow Bank	Hadyn Jones	Liverpool	Labels	60	90	9
13	26/05/2018	5	Booths	Gareth Evans	Liverpool	Envelopes	100	150	13
19	19/10/2019	4	Charkson and May	Alison Smith	Hull	Paper	30	50	2
20	24/12/2018	6	Pearson Group	Frederick Walters	Birmingham	Fasteners	20	30	5
2	21/05/2019	1	Virago	Roger Waters	Coventry	Paper	30	50	15
15	10/03/2018	5	Booths	Anne-Marie Jones	Birmingham	Paper	30	50	9
11	16/10/2019	4	Charkson and May	Helen Davidson	Cardiff	Paper	30	50	11
1	14/07/2018	5	Booths	Alison Smith	Liverpool	Paper	30	50	2
17	05/09/2018	10	Smith Logistics	Gareth Evans	Leeds	Envelopes	100	150	14
12	05/07/2019	3	Salisburys	Anne-Marie Jones	Bristol	Paper	30	50	2
7	31/03/2018	7	Thomson Group	Gareth Evans	Leicester	Fasteners	20	30	3