Pay just $2 more to get my PowerPoint lesson and my instructional video version of this lesson. Now you will have both options...teaching the lesson yourself, or assigning the video to your students. *Please note that the only difference between the two downloads is that one is a PowerPoint lesson and one is a video lesson. The instructional content is the same; only the format of the lesson is different.*

Step-by-step directions on how to use formulas to make calculations using football statistics. The lesson includes:

• basic formatting skills such as word wrapping text in a cell and drawing boxes around cells,
• how to sort data,
• writing formulas to determine net receiving yards, average number of carries per game, average number of yards gained per game, and the percentage of total yards that each player contributed to the season.
• using the formula builder to quickly calculate the sum totals and the overall averages for this data. They also calculate the standard deviation for their averages.
• practicing writing formulas with a new sheet of data.
• TEST where students are given a new set of data and directions for what sort of calculations they must program the sheet to make (directions and grading rubric included).

Click here to just purchase PowerPoint version.

Click here to just purchase video version.