Basketball Statistics Score Sheet - Excel by tyndale

VIEWS: 1,679 PAGES: 4

									                               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
  creating their personalized score sheet based on their favorite or made up team (see ready made
  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
                       MADE     ATT.       MADE       ATT.           MADE       ATT.   POINTS
         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%




2/19/2010                 7854da04-95e9-4d16-b734-480099ad8984.xls                            7:28 AM
                             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
                       MADE     ATT.       MADE      ATT.            MADE      ATT.     POINTS




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




2/19/2010                 7854da04-95e9-4d16-b734-480099ad8984.xls                              7:28 AM
                                             BASKETBALL TEAM STATISTICS
                   FREE THROWS              2 PT SHOT             3 PT SHOT          TOTAL
PLAYER'S NAME
                   MADE    ATT.           MADE     ATT.         MADE     ATT.        POINTS
 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