Sports Step #1-  Research/Spreadsheet

I.  Excel Spreadsheet  10 Points                                                                                   

•        4 Statistical columns in the spreadsheet (Games and 3 other statistics/numbers)                                                                           
•         1 Calculations column  (Variety Ex. Averages you divide, Totals you multiply)                                                                                

Researching

1) The first part of this is to select a sport and a position within that sport. Ex. NBA basketball Point Guards, NFL football Linebacker

2) Research 7 players from that position and record them into Excel.

• Use www.espn.com. Go to the website> lclick on your sport on the black my ESPN bar.

• A white/gray bar will appear under the black bar. Click on Players.

• Where it says Search By: change from Last Name to Position.

• A new drop-down arrow will show up. Change the position to what you are researching and hit Go.

• Select a player from the list.

• When the player's page appears, click on the STATS button. . You want to go to the stats tab and get the last complete season/year a player has played. and use the same season/year for all players. If not your player's statistics may be inaccurate because they are going to change daily or have only been collected for a few games.

• You are required to use GAMES PLAYED, but the other statistics you look for were your choice.

2) Go to Start>Programs>Microsoft Office>Microsoft Excel.

3) Row 1 of your spreadsheet should be your column headings. Column Headings are titles and should be capitalized. In cell A1, type Players. In cell B1, type in Games. And so on.

4) In column A, type in your 7 players. Make sure you properly capitalize the names.

5) Fill in the data for your 7 player in columns B-E. B should be games.

6) Column F is going to be where we calculate a statistic. For sports, it can vary. Most will figure one of the following:

• A Total Season- Multiply the number of games played by an average and that would give me the total. (shown above is Points)

• An Average - Divide a Total by the number of games per season.

Excel can complete Mathematical Equations.

In cell F1, type what it is you are figuring.

Do the following in cell F2 to enter a mathematical formula like shown on right:

• type =

• click on the 1st cell (it will show box coordinates in formula)

• type -

• click on 2nd cell (it will show box coordinates in formula)

• hit Enter. (the answer should appear.)

7) Complete columns F by using mathematical formulas.

8) Shade column F yellow by using the Paint Bucket (shown on right) so your teacher's know that is your calculated column.  

9) On the tab at the bottom, rename the tab Spreadsheet . Right-click on the tab at bottom of page (Sheet 1) and go to rename. Type in Spreadsheet. (Shown on right)

Now, return to the HomePage and go to the next step.