Busi 3100 Collaborative Team Project: Evaluating Basketball Teams Employers consider critical thinking as an important skill when hiring. In this term pr

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

Collaborative Team Project: Evaluating Basketball Teams

Employers consider critical thinking as an important skill when hiring. In this term project, you will demonstrate essential Excel skills and critical thinking approaches.

Prerequisites

You should be familiar with the following skills using Microsoft Excel:

Workbook and worksheet skills: open, close, save, and create

Enter and manipulate data

Enter formulas and functions, such as Sum, Count, Average and calculating ratios

Apply formatting (e.g., color, border, print area)

You should also be familiar with MS Word to create, save, and close a Word document.

Case Scenario

After an exciting college basketball game, you and your friends began debating which basketball team is better. Your best friend is a die-hard fan of one team. Another friend has been supporting their rival team, also an alumnus. Other friends also said their teams have been performing the best. You think that there are different ways to measure the performance, so you suggested that they all analyze which team had the best performance during the most recently completed full season.

Project Requirements

1) If you are not familiar with benchmarking analysis, watch the “What is Benchmarking?” video to learn about this commonly used approach that corporations use to measure and compare performance. The video is available at https://www.youtube.com/watch?v=8mY2YrYAE-U.

2) To collect data on the College Basketball Stats and History: http://www.sports-reference.com/cbb/. Select a college men’s basketball team and locate their latest complete season statistics on the website. Each group member is to select a different team.

3) Working with your group members, run a benchmarking analysis to compare the performance of these teams as follows. For each team that the group members have selected:

a) Collect data from the website:

b) Find the statistics that represents each team’s performance (not the conference performance).

c) At a minimum, include the following performance indicators for each team:

i) Number of games won

ii) Number of games lost

iii) PTS — Total Points

iv) G — Games (i.e., number of games played during the season)

v) FG% — Field Goal Percentage (from any distance)

vi) 3P% — 3-Point Field Goal Percentage (from beyond the 3-point line)

vii) TOV — Total Turnovers

d) Use Excel formulas to calculate the following key performance indicators (KPIs):

i) Win-loss percentage (W-L%) = Number of games won / Total number of games played

ii) Average points per game = Total Points / Total number of games played

iii) Average Turnovers per Game = Total Turnovers / Total number of games played

4) Identify three additional key performance indicators (KPIs) that your group thinks as important to benchmark. These KPIs should be same for every team!

5) All these statistics should be clearly labeled and formatted in the same way for each of team. Use Excel tools such as borders, font size and type, and colors to make it easy to understand for readers of your report.

6) Enter the group number, group members’ names, and report name in the page header of the report.

7) Format your report to print on one page.

8) Save the Excel file, and the team leader uploads it to Canvas.

9) Based on your report, write an executive summary of your findings in Word. Include information and reasoning to answer the following questions:

a) Which basketball team in your group’s selections has the highest Average Points per Game?

b) Which team has the highest Field Goal Percentage (FG%)?

c) Which team has the highest Win-lose percentage (WL%)?

d) Which team has the highest Average Turnovers per Game?

e) Which KPI is the most important based on your data?

f) Which team has the best performance based on the three KPIs you identified as a group?

g) Explain why you selected these three additional KPIs.

h) Which team in your group’s selections performed the best? Explain why.

Place your order now for a similar assignment and have exceptional work written by one of our experts, guaranteeing you an A result.

Need an Essay Written?

This sample is available to anyone. If you want a unique paper order it from one of our professional writers.

Latest Questions

See More »

See More »

See More »

See More »

See More »

See More »