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.
Do You Need Assignment of This Question
Order Non Plagiarized Assignment
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:
Create a Spreadsheet:
Organize the sales data with proper formatting.
Include headings and appropriate column widths.
Create properly named worksheets (tabs).
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.
Use COUNTIF Function:
Count the number of instances of the London district in the data.
Count the number of instances of the Envelopes product.
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:
Include Charts from Task 2:
Add the charts created in Task 2 (as images).
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.
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.
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.
Buy Answer of This Assessment & Raise Your Grades
Request to Buy Answer
Submission Instructions:
Submit 3 separate files in the correct format:
Microsoft Word file for Task 1.
Microsoft Excel file for Task 2.
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