Essential Question: How can I use Microsoft Excel to keep track of my favorite teams?
Objectives:
Learn to create formulas in Microsoft Excel.
Learn how to access commonly used formulas to calculate statistics.
Learn to format cells in Microsoft Excel.
Directions: Create a spreadsheet using statistics from a sports team and use formulas to calculate the statistics.
Resources:
http://www.nba.com/celtics/stats/
http://www.basketball-tips-and-training.com/basketball-statistics.html
Project Directions:
Select 10 players from the statistics page for a basketball team. Type in 5 types of statistics for your players. You need to use the following functions in your table:
=COUNTA( ) This function counts the total text
=AVERAGE( ) This function calculates an average
=SUM( ) This function adds everything up
=MAX( ) This function finds the largest number
=MIN( ) This function finds the smallest number
Requirements:
Create a chart with 10 players.
Provide the numbers for 4 different statistics.
Provide a graph for one of the statistics.
Make the chart pretty using colors and formatting.