VIEWS: 10 PAGES: 4

• pg 1
```									                               Basketball Statistics Scoresheet
Directions for the lesson and for creating the spreadsheet

This lesson can be used as a lesson in formatting spreadsheets or it can be used in
conjunction with a math lesson on calculating multiple sets of numbers or for complex
equations

1 The class will discuss how a basketball game is scored (ie. How many points for a foul shot, for a field
goal, and for a shot made from behind the three point line - 1pt, 2pts, 3pts, respectively)
2 The class will then discuss how we could make a spreadsheet to automatically update the score of the
game by entering a made shot into a specific category
3 The class will discuss how the points can be calculated mathematically
4 The teacher will then discuss the formula needed for the spreadsheet to calculate the points
5 The teacher can have the students enter the data into a pre-created spreadsheet with the borders,
row and column headings and formatting already in place or the class can complete the exercise
together building the spreadsheet as directed by the teacher
6 Once the spreadsheet is ready for the names and point data to be inputted, the class can begin
spreadsheet tab at the bottom of the page)
7 See the formulas tab / sheet to see example formulas
8 The students can use canned graphics from any graphics program or if you have Internet access they
can go to the official web page for the team and copy the logo from there (www.nba.com)
9 The spreadsheet can be customized in may different ways - let the students show their creativity!
Team Name Score Sheet

Belmar Eagles
FREE THOWS             2 PT SHOT                 3 PT SHOT      TOTAL
PLAYER'S NAME
FIRST NAME     5       10           3          4              2          4      17
SECOND NAME     1        2           6          8              1          2      16

TOTALS        6         12          9         12             3         6       33
FREE THROW            2 POINT SHOT             3 POINT SHOT
AVERAGE               AVERAGE                  AVERAGE
50%                   75%                      50%

5/6/2011                     9b7b875f-0d93-46ac-b04b-837a80fe9bb3.xls                            4:06 PM
Team Name Score Sheet

Graphic                                                                         Graphic
or Team
Logo             Team Name                                                     or Team
Logo

FREE THOWS            2 PT SHOT                 3 PT SHOT        TOTAL
PLAYER'S NAME

TOTALS
FREE THROW            2 POINT SHOT             3 POINT SHOT
AVERAGE               AVERAGE                  AVERAGE

5/6/2011                   9b7b875f-0d93-46ac-b04b-837a80fe9bb3.xls                              4:06 PM
FREE THROWS              2 PT SHOT             3 PT SHOT          TOTAL
PLAYER'S NAME
FIRST NAME           5          10         3            4         3          4         20        FORMULA FOR TOTAL PTS
SECOND NAME           1          2          6            8         1          2         16            BY EACH PLAYER
=SUM(B4*1)+(D4*2)+(F4*3)
THIRD NAME           0          1          2            2         1          1          7

TOTALS             6          13         11           14        5          7         43
FREE THROW AVERAGE 2 PT SHOT AVERAGE          3 PT SHOT AVERAGE
46%                      79%                 71%
FORMULA
FORMULA FOR AVERAGES
FOR TOTAL TEAM POINTS
=B14/C14
=SUM(H3:H13)
Then format for percentages

Click in the cells to see each formula (only from the spreadsheet program - save the page first)
These formulas for TOTAL POINTS BY EACH PLAYER can be entered once then copied to the rest of the cells in the column
This sheet is protected so that the formulas can not be deleted - to unprotect the sheet go to Tools, Protection, Unprotect
You will not be able to enter any data into this sheet until the protection is removed - no password required

```
To top