Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Numbers and Spreadsheets by zxb18105

VIEWS: 10 PAGES: 4

Numbers and Spreadsheets document sample

More Info
									                               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%




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
                       MADE     ATT.        MADE      ATT.            MADE      ATT.     POINTS




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




5/6/2011                   9b7b875f-0d93-46ac-b04b-837a80fe9bb3.xls                              4:06 PM
                                             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