{"id":17165,"date":"2023-04-25T16:26:08","date_gmt":"2023-04-25T16:26:08","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/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-k-2\/"},"modified":"2023-04-25T16:26:08","modified_gmt":"2023-04-25T16:26:08","slug":"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-k-2","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/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-k-2\/","title":{"rendered":"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."},"content":{"rendered":"

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.<\/p>\n

<\/div>\n
In this final project, you will use data on Top\u2019t Corn\u2019s 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.<\/div>\n
<\/div>\n
\u00adCTA 326 Final Project<\/div>\n
<\/div>\n
In this project, you will work with sales data from Top\u2019t Corn, a popcorn company with an online store, multiple food trucks, and one store in a local shopping mall.<\/div>\n
<\/div>\n
There are 4 food truck locations and Tyson\u2019s store in the mall. The New Truck tab in the Excel file (linked above) shows data on whether they can afford a loan.<\/div>\n
<\/div>\n
Notice these calculations in the data:<\/div>\n
<\/div>\n
Calculated totals<\/div>\n
Pie charts representing total units sold by location<\/div>\n
Column chart that represents sales by popcorn type<\/div>\n
Loan payment calculations for a new truck<\/div>\n
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.<\/div>\n
<\/div>\n
DIRECTIONS:<\/div>\n
<\/div>\n
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.<\/div>\n
<\/div>\n
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.<\/div>\n
<\/div>\n
What is the company name and what kind of data will you be presenting?<\/div>\n
What does the raw data spreadsheet show?<\/div>\n
What data do the PivotChart and PivotTables summarize?<\/div>\n
Why is this summarized data important?<\/div>\n
Analyze the top sales dates for the TysonStore and discuss the average daily sales, identifying the minimum and maximum sales in relationship to the daily sales goal.<\/div>\n
Based on analyzing the Tyson Store – 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.<\/div>\n
Explain some maximum and minimum data on your PivotTable\/Chart.<\/div>\n
Explain the data on the Online Sales Table worksheet.<\/div>\n
Do you recommend buying a new truck? Based on the average sales by truck location. If you buy a new truck, where would you put the Truck?  <\/div>\n
In your presentation, you should utilize Tips for Effective Presentations listed on page 95 of your textbook (Figure A8-1) and insert the following.<\/div>\n
<\/div>\n
A title introduction project overview worksheet with a list of group members’ names who participated in the project.<\/div>\n
A closing worksheet with a summary of the presentation.<\/div>\n
Using the skills you learned in Excel Chapter 5, include images and\/or screenshots on the overview and summary sheets.<\/div>\n
You will create a screencast video where you will present your Excel data workbook. (just the voice for you, because I will have to re-record it in order to submit)<\/div>\n
<\/div>\n
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.<\/div>\n
<\/div>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[759],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/17165"}],"collection":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/comments?post=17165"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/17165\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=17165"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=17165"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=17165"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=17165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}