A spreadsheet activity calculating passing statistics for Tony Romo of the Dallas Cowboys. Any NFL QB could be used by going to the ESPN stats page for that player.
Students use the following functions: SUM, AVG, and MAX. The hefty task of calculating the QB Rating is broken down into steps and a nested IF statement is required. Some explanation for the teacher is given.
There are four worksheets in the workbook. Answers included.
I have used this lesson many times with 7th and 8th. It is a challenge for them. I considered the logical portion of the QB Rating extra credit.