For the Final 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 Top’t Corn’s financial activities (an imaginary popcorn business). This will be an exploration of the practical review and presentation of Top’t Corn’s raw business 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. (link will be below)
¬CTA 326 Final Project
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 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 can record the presentation using the Kaltura screencast media, Vimeo the video-sharing website or Quicktime Recorder for the MAC or Windows Media Player for the PC. You must record and demonstrate the eight (8) Excel spreadsheets. Do not present using a PowerPoint presentation.
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 screenshots or images of the spreadsheets.
1. What is the company name and what kind of data will you be presenting?
2. What does the raw data spreadsheet show?
3. What data do the PivotChart and PivotTables summarize?
4. Why is this summarized data important?
5. Find the top 10 sales dates and discuss the average minimum and maximum sales in relationship to the daily sales goal.
6. 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.
7. Explain some maximum and minimum data on your PivotTable/Chart.
8. Explain the data on the Online Sales Table worksheet.
9. Do you recommend buying a new truck? Explain your decision based on the dollar amount of money the company will gain or lose if they purchase a new truck.
In your presentation, you should utilize Tips for Effective Presentations listed on page 95 of your textbook (Figure A8-1) and insert the following.
1. A title introduction project overview worksheet with a list of group members’ names who participated in the project.
2. A closing worksheet with a summary of the presentation.
3. Using the skills you learned in Excel Chapter 5, include images and/or screenshots on the overview and summary sheets.
4. Optional: List each member’s contributions to the presentation, i.e. student name and topics developed.
You will create a screencast video where you will present your Excel data workbook.
1. Use KalturaLinks to an external site. to narrate and record your screen.
2. Review the rubric as your guide on how you will be graded by your instructor. This will ensure your project meets the requirements.
The goal of the presentation is to demonstrate your knowledge of Excel and data analysis reporting skills. Make sure that when you demonstrate and explain the data as instructed, you are very descriptive, as if explaining to an audience with no prior knowledge of Excel spreadsheets or analysis of data. Remember, you do not have to explain or teach the audience how Excel formulas and functions are created.
Resources for the assignment:
• Excel data workbookDownload Excel data workbook
• Kaltura Media Help and TutorialsLinks to an external site.
o Kaltura for Students VideoLinks to an external site. (includes how to record a screencast video)
o Submitting Assignments in Kaltura Download Submitting Assignments in Kaltura[PDF]
• Rubric (scroll to the bottom of this page)
• Final Project Checklist
For the Final 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.
nts VideoLinks to an external site. (includes how to record a screencast video)
o Submitting Assignments in Kaltura Download Submitting Assignments in Kaltura[PDF]
• Rubric (scroll to the bottom of this page)
• Final Project Checklist
IF ANY QUESTIONS OR RESSOURCES NEEDED LET ME KNOW.
ALSO I WONT BE USING YOUR VOICE, I WILL RECORD IT OVER AGAIN WITH MY OWN VOICE IF THAT MAKES SENSE