[Solved] Week 3 Minor Project BUSN 420

Assignment Prompt & Instructions

[>Management homework help](https://www.sweetstudy.com/fields/business-finance-management)

Please see the file: [**Minor Project Instructions**](https://regent.instructure.com/courses/21176/files/5075863?wrap=1 "BUSN420MinorProjectInstructions.pdf") [**Download Minor Project Instructions**](https://regent.instructure.com/courses/21176/files/5075863/download?download_frd=1) for details about your minor project. You will also need the data file, [**T3 Tech Plugin Data**](https://regent.instructure.com/courses/21176/files/5075866?wrap=1 "T3TechPlugInDataFile.xlsx") [Download T3 Tech Plugin Data](https://regent.instructure.com/courses/21176/files/5075866/download?download_frd=1), and the file, [**T3 Jitters Coffee Data**](https://regent.instructure.com/courses/21176/files/5075865?wrap=1 "T3JittersCoffeeDataFile.xlsx") [Download T3 Jitters Coffee Data](https://regent.instructure.com/courses/21176/files/5075865/download?download_frd=1), to complete this project. You will be graded according to the [rubric](https://regent.instructure.com/courses/21176/files/5075864?wrap=1 "BUSN420MinorProjectRubric.pdf") [Download rubric](https://regent.instructure.com/courses/21176/files/5075864/download?download_frd=1).

These exercises will introduce you to the variety of uses of PivotTables. For more information on PivotTables please see the files named, [**Tech Plug-In T3**](https://regent.instructure.com/courses/21176/files/5075867?wrap=1 "Tech_Plug_In_T3.pdf") [Download Tech Plug-In T3](https://regent.instructure.com/courses/21176/files/5075867/download?download_frd=1) **Problem Solving Using Excel**. Please read the information provided and complete each exercise listed below. Once you have completed all 4 of the exercises, submit your Excel and Word documents using the assignment link above.

All 4 sections of the Minor Project should be uploaded in Canvas, including:

1. A Pivot Table illustrating the monthly magazine sales by the sales representative as illustrated in Figure T3.17 of the assignment instructions.

2. A Pivot Table Chart illustrating the monthly magazine sales by the sales representative as illustrated in Figure T3.18 of the assignment instructions.

3. A Pivot Table and Chart illustrating the top 4 selling coffee products.

4. A 300 to 500-word describing the use of pivot tables and charts in a business or ministry setting.

– [\
\
BUSN420MinorProjectInstructions.pdf](https://www.sweetstudy.com/files/busn420minorprojectinstructions-pdf-10169767 "BUSN420MinorProjectInstructions.pdf")
– [\
\
T3TechPlugInDataFile.xlsx](https://www.sweetstudy.com/files/t3techplugindatafile-xlsx-10169769 "T3TechPlugInDataFile.xlsx")
– [\
\
T3JittersCoffeeDataFile.xlsx](https://www.sweetstudy.com/files/t3jitterscoffeedatafile-xlsx-10169771 "T3JittersCoffeeDataFile.xlsx")
– [\
\
BUSN420MinorProjectRubric.pdf](https://www.sweetstudy.com/files/busn420minorprojectrubric-pdf "BUSN420MinorProjectRubric.pdf")
– [\
\
Tech_Plug_In_T3.pdf](https://www.sweetstudy.com/files/tech-plug-in-t3-pdf-10169775 "Tech_Plug_In_T3.pdf")

– 2 years ago