CTA 226 Final Project Instruction SPR2017 PDF

Preview

Summary

final project...

Description

CTA 226 – Excel 2016 Capstone Project EX-3 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 present your data using the tools learned in your textbook, “Integrating Excel into Business Problem Solving”. You will record this presentation using the Kaltura, Blackboard Tool, or Screencast-O-Matic, free download, to capture your Excel screen and record what you are doing with it (example: Sort, Filter, Slicers) and record your narration. DIRECTIONS: In this final project presentation, you will answer questions below while interacting with your Excel spreadsheet. 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. Upload your video using the Blackboard Assignment link. Make sure to use Kaltura or Screencast-OMatic to narrate and record your screen. Also, as another option, you can record a 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. Review the rubric as your guide to how you will be graded. I am grading to see how many skills are displayed from each chapter, especially, sorting, filtering, and PivotTable and PivotChart features. Most importantly, 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.

The points are a total of 12.50 for each section, not 25 points. The total amount of point for the project are 50....