# Excel 2013 Capstone Project EX-3

| 0

Working with Sales Data

In this project, you will work with sales data from Top’t Corn, a popcorn company with an online store, multiple food trucks, and one store in a local shopping mall.

There are 4 food truck locations and Tyson’s store in the mall. The New Truck tab shows data on whether they can afford a loan.
Notice these calculations in the data:

• Calculated totals
• Pie charts representing total units sold by location
• Column chart that represents sales by popcorn type
• Loan payment calculations for a new truck

Review the Data, PivotTables, and PivotChart. Analyze the data so that you can report it out to an audience such as your work peers and your boss.

You will develop a PowerPoint or Prezi presentation using the tools learned in your textbook, “Integrating Excel into Business Problem Solving”. You will record this presentation using the KalturaBlackboard Tool, or Jing, free download, to capture your screen to record what you are doing and record your narration.

DIRECTIONS:

In this final project presentation, you will answer questions below in a presentation format (PowerPoint, Prezi). You do not have to say the questions out loud, but you must discuss your data in terms of the questions below, as if you are reporting your data to your boss.

Present your raw data, PivotTable(s), and PivotChart(s) by discussing answers to the questions below.

a. What is the company name and what kind of data will you be presenting?

b. What does the raw data show?

c. What data does the PivotChart and/or PivotTables summarize?

d. Why is this summarized data important?

e. Find the top 10 sales dates and the average minimum and maximum sales.

f. Explain some maximum and minimum data on your PivotTable/Chart.

Please select one of the different ways you can submit an audio/visual presentation of this assignment, using Excel, PowerPoint, or Prezi.

g. You can record video and upload it directly to YouTube™. You must have a Google® account that is registered on YouTube. A YouTube channel is required to process and save your webcam videos.

h. You can use Kalturaor Jingto narrate and record your screen.

The goal is to demonstrate Data reporting skills. Make sure that when you demonstrate and explain the data as instructed, please ensure that you are very descriptive, as if explaining to an audience with no prior knowledge of Excel spreadsheets or analysis of data.

Date Quantity Item State

6/30/2014 6 Old Bay MD

6/30/2014 12 Original Blend OH

6/30/2014 4 Original Blend CA

6/30/2014 8 Sea Salt and Caramel MO

6/30/2014 5 Sea Salt and Caramel NJ

6/30/2014 8 Truffle VA

6/30/2014 2 Truffle DC

6/30/2014 2 Original Blend AL

6/30/2014 4 Old Bay MD

6/30/2014 14 Truffle DC

6/30/2014 8 Sea Salt and Caramel MS

6/30/2014 10 Original Blend NC

6/30/2014 2 Original Blend VA

6/30/2014 4 Old Bay NJ

6/30/2014 2 Old Bay NJ

6/30/2014 4 Sea Salt and Caramel NY

7/1/2014 2 Old Bay ID

7/1/2014 2 Sea Salt and Caramel OH

7/1/2014 5 Truffle NY

7/1/2014 10 Original Blend AL

7/1/2014 5 Old Bay MD

7/1/2014 2 Original Blend NC

7/1/2014 2 Sea Salt and Caramel MS

7/1/2014 4 Original Blend VA

7/1/2014 2 Old Bay MD

7/1/2014 4 Old Bay MD

7/1/2014 8 Old Bay VA

7/1/2014 10 Original Blend WV

7/1/2014 6 Sea Salt and Caramel CA

7/1/2014 4 Sea Salt and Caramel MO

7/1/2014 2 Sea Salt and Caramel MS

7/1/2014 6 Truffle NY

7/1/2014 12 Truffle NY

7/1/2014 6 Original Blend OH

7/2/2014 2 Truffle NY

7/2/2014 2 Old Bay MD
7/2/2014 4 Old Bay DC
7/2/2014 6 Sea Salt and Caramel MS
7/2/2014 10 Sea Salt and Caramel AL
7/2/2014 2 Sea Salt and Caramel NC
7/2/2014 2 Original Blend AL
7/2/2014 4 Original Blend DC
7/2/2014 14 Original Blend NY
7/2/2014 12 Original Blend WV
7/2/2014 10 Original Blend OH
7/2/2014 2 Truffle VA
7/2/2014 2 Old Bay VA
7/2/2014 2 Sea Salt and Caramel DC
7/2/2014 4 Old Bay MD
7/2/2014 2 Old Bay WV
7/2/2014 4 Original Blend AL
7/2/2014 4 Original Blend SC
7/2/2014 2 Truffle SC
7/3/2014 4 Original Blend OH
7/3/2014 4 Original Blend NY
7/3/2014 2 Sea Salt and Caramel NJ
7/3/2014 6 Sea Salt and Caramel NJ
7/3/2014 2 Old Bay NY
7/3/2014 2 Truffle NY
7/3/2014 4 Old Bay OH
7/3/2014 2 Truffle DC
7/3/2014 6 Old Bay CA
7/4/2014 6 Original Blend AL
7/4/2014 8 Original Blend MS
7/4/2014 2 Sea Salt and Caramel OH
7/4/2014 2 Old Bay CA
7/4/2014 4 Old Bay DC
7/4/2014 4 Original Blend CA
7/4/2014 8 Truffle VA
7/4/2014 12 Sea Salt and Caramel NJ
7/4/2014 2 Sea Salt and Caramel WV
7/5/2014 2 Old Bay MD
7/5/2014 2 Old Bay DC
7/5/2014 4 Sea Salt and Caramel NJ
7/5/2014 2 Sea Salt and Caramel NY
7/5/2014 6 Original Blend MD
7/5/2014 2 Original Blend AL
7/5/2014 4 Truffle VA
7/5/2014 6 Old Bay MD
7/5/2014 2 Old Bay MD
7/5/2014 4 Old Bay VA
7/5/2014 4 Truffle NY
7/5/2014 2 Original Blend OH
7/5/2014 6 Sea Salt and Caramel CA
7/5/2014 6 Original Blend CA
7/5/2014 8 Truffle CA
7/5/2014 2 Old Bay MD
7/5/2014 2 Original Blend MD
7/5/2014 4 Old Bay VA
7/5/2014 4 Original Blend VA
7/5/2014 2 Sea Salt and Caramel MS
7/5/2014 6 Original Blend NC
7/5/2014 4 Original Blend WV
7/5/2014 2 Old Bay WV
7/5/2014 6 Truffle OH
7/6/2014 2 Old Bay MD
7/6/2014 2 Truffle OH
7/6/2014 4 Original Blend CA
7/6/2014 2 Original Blend MD
7/6/2014 6 Sea Salt and Caramel VA
7/6/2014 2 Truffle MD
7/6/2014 2 Truffle VA
7/6/2014 4 Sea Salt and Caramel AL
7/6/2014 8 Old Bay MD
7/6/2014 10 Old Bay WV
7/6/2014 2 Original Blend WV
7/6/2014 4 Truffle CA
7/6/2014 10 Truffle CA
7/6/2014 4 Truffle MO
7/6/2014 12 Original Blend WV
7/6/2014 2 Sea Salt and Caramel DC
7/6/2014 2 Old Bay DC
7/6/2014 4 Sea Salt and Caramel MD
7/6/2014 2 Sea Salt and Caramel VA
7/6/2014 6 Truffle AL
7/6/2014 10 Sea Salt and Caramel MS
7/6/2014 4 Old Bay NC

Last Updated on December 29, 2019 by EssayPro