For the Final Group Project in Week 7, you will demonstrate advanced Excel skills, problem-solving and decision making skills, and the ability to interpret the provided data in a presentation format using Kaltura. You will develop an effective presentation using the skills learned in this course. Review the final project instructions, the Final Project Rubric Download Final Project Rubric, and the Final Project Checklist (listed below).

In this final project, you will use data on Topt Corns financial activities (an imaginary popcorn business). This will be an exploration of the practical review and presentation of Top't Corn's business raw data, pivot tables, and charts. You will create a Presentation sharing the data and what the data means to you. Review the final project instructions below and review the Excel data workbook. https://wilmu.instructure.com/courses/48594/files/7027630/download?download_frd=1

Project in Week 7, you will demonstrate advanced Excel skills, problem-solving and decision-making skills, and the ability to interpret the provided data in a presentation format using Kaltura. You will develop an effective presentation using the skills learned in this course. Review the final project instructions, final project rubric, and final project checklist below.

In this final project, you will use data on Topt Corns financial activities (an imaginary popcorn business). This will be an exploration of the practical review and presentation of Top't Corn's business raw data, pivot tables, and charts. You will create a Presentation sharing the Excel data workbook and what the data means to you. Review the final project instructions below and the Excel data workbook.

CTA 326 Final Group Project

In this project, you will work with sales data from Topt 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 Tysons store in the mall. The New Truck tab in the Excel file (linked above) 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 and present on all eight (8) Excel spreadsheets (Data, Trucks, New Truck, Tyson Store, Online Sales Table, two PivotTables and a 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 presentation using the visual aid tools learned in your textbook, Integrating Excel into Business Problem Solving. You must record the presentation using the Kaltura screencast function.

DIRECTIONS:

In this final project presentation, you will answer the questions below in your presentation. 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 the information in the Excel data workbook while demonstrating the various Excel functions and features you learned in the course, such as creating a table to demonstrate filtering and/or sorting, conditional formatting, PivotTable(s), and the PivotChart field list pane, slicers, and filtering features. Explain and answer the questions below using the Excel spreadsheets in the data workbook and do not present the information using screen shots or images of the spreadsheet

Do you recommend increasing the price per box of popcorn? Your answer should demonstrate whether the new price will increase the number of days the sales goals will be met