Assignment:
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 thatthey 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 useto measure and compare performance. The video is available athttps://www.youtube.com/watch?v=8mY2YrYAE-U.
2) To collect data on the College Basketball Stats and History: https://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 analysisto 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) Identifythree 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.
10) Save your Word document, and the team leader uploads it to Canvas.
Attachment:- Collaborative Team Project.rar