bcom project 4

Effective Business Communication 3360: Project 4

Carr

This project entails creating a Power Point Report that you would hypothetically present to a live audience. The purpose of this assignment is to demonstrate your competence using Excel to create charts and to use Powerpoint to create and design a professional business report.

Scenario and Requirements:

Assume you are working for Apple and your supervisor has asked you to create a Powerpoint report to summarize some key financial and sales data for a presentation to an internal audience of other Apple managers. You need to create charts and graphs to quickly summarize the company’s overall financial performance as well as the performance of individual product groups. You must also analyze and make recommendation(s) to the company’s sales team based on the data you present. Use the attached Excel spreadsheet with select Apple financial data to create at least 2 of the following charts and graphs. The charts/graphs must included in your Power Point.

YOU MUST USE THE ATTACHED SPREADSHEET TO PRESENT AND ANALYZE TWO OF THE FOLLOWING DATA POINTS IN YOUR POWERPOINT. YOU ONLY NEED TO CHOOSE TWO OF THE FOLLOWING OPTIONS:

· Create a line graph to show net sales growth from 2013 to 2017.

· Create a line graph to show unit sales of the top four product groups from 2015 -2017.

· Create a bar graph to show net sales for all product groups from 2015- 2017.

· Create a pie chart to show net sales for all product groups from 2015- 2017.

· Create a bar graph to show unit sales by product groups in 2017.

Required Project Components:

1) A Title slide with student name, company name, and date. (Each slide must also have a title.)

2) A separate slide for two of the graphs/charts listed above. One graph/chart per slide only!

3) A textbox on each slide with one or two sentences (“take away message”) that concisely discusses/analyzes the significance of the data on each slide. For example: What does the data that you are representing on each slide illustrate about Apple’s overall or individual product sales trends? The text must explain the data on each slide. DO NOT just present data (charts/graphs) without analysis.

4) A final slide with overall recommendation(s) for the company based on the data presented.

Grading Criteria:

Grading: Each chart will be graded according to the criteria in our textbook, including

10pts Title descriptiveness (for each slide)

10pts Focal points

10pts Information sufficiency

10pts Ease of processing/conciseness

10pts Take-away message

10pts Spelling/Grammar

20pts Appearance and design of overall document

20pts Proper design of individual charts and graphs

_________________________________________________

100pts Total Points available