The scenario:
All That Glitter Jewelry is considering an expansion of the company website to sell more merchandise. Wanda Delana, US Sales Director, has asked you to complete the proposal. To complete this assignment you will need the following files:
Web_Sales_chart
Web_Sales_Proposal
You will save your files as:
Lastname_Firstname_ Web_Sales_Chart
Lastname_Firstname_Web_Sales_Proposal
Open the provided file, Web_Sales_Chart file, and then save the Excel workbook as Lastname_Firstname_ Web_Sales_Chart. Complete the Excel worksheet
Insert totals in row 10,
Merge and center the titles
Format data for aesthetics
Create a 3-D clustered column chart to display the quarterly low end sales, expected sales, and high end sales on a separate sheet with an appropriate sheet name
Modify the chart style and format appropriate chart elements
Insert the file name in the footer and add appropriate document properties
Open the provided file, Web_Sales_Proposal file, and then save the Word document as Lastname_Firstname_Web_Sales_Proposal
In the Word document include the linked Excel data and chart
Insert the your name in the footer
Upload the completed assignment files in the Assignment area.
Special Instructions: Use the Supporting Materials listed below to complete the project.
Grading: Please review the rubrics for particulars.
Performance Level
Exemplary
Accomplished
Developing
Beginning
Points
Performance Element
You consistently applied the relevant skills.
You sometimes, but not always, applied the relevant skills.
You rarely applied the relevant skills.
You never applied the relevant skills.
10/10
Complete Excel workbook
Worksheet includes totals, merged and centered titles, correctly formatted
Worksheet includes totals, and merged and centered titles, but some elements are incorrect
Worksheet missing totals or merged and centered titles
Worksheet missing totals and missing merged and centered titles
Exemplary 10
Accomplished 7-9
Developing 4-6
Beginning 0-3
Points:
Create column chart
Column chart created on a separate sheet with an appropriate chart style and formatted chart elements
Column chart created, but somewhat formatted correctly
Column chart created, but not formatted correctly
Column chart is not created
Exemplary 10
Accomplished 7-9
Developing 4-6
Beginning 0-3
Points:
Excel data and chart linked to Word document
Excel data and chart correctly linked to Word document
Excel data and chart somewhat correctly linked to Word document
Excel data and chart are incorrectly incorporated in the Word document
The data and chart are not included in the Word document
Exemplary 10
Accomplished 7-9
Developing 4-6
Beginning 0-3
0 comments