Teachers: Either print this WWW page and make copies for your class, or use this page directly from the MTSD web site, or both! If you choose to print it out follow these steps, (1)select a laser printer (or ink jet), (2)use the File menu and choose Page Setup...80%, (3)then print and make copies for your class. Note that the eight links at the bottom of this page are live when you use this page from the WWW.

STUDENT'S NAME: _________________________

Super Bowl XXXII Spreadsheet/Charting Activity

January 25, 1998, San Diego CA

The Green Bay Packers are heading to the Super Bowl for the second year in a row! Go Pack Go! This year the Packers will face the Denver Broncos led by John Elway. Is it possible to study game statistics and predict the winner? In this activity you will use the new skills you have learned while studying the ClarisWorks spreadsheet and its charting (graphing) features. Design and build a spreadsheet using the data on this page. Then chart important pieces of spreadsheet data to prove that the Packers (or possibly the Broncos) will win Super Bowl XXXII. See the bottom of this page for a sample.

During the regular season the Packers and Broncos played against four common opponents. Note that both teams were 4-0 against these teams.

--- Common Opponent ---	Packers W/L (Score)	Broncos W/L (Score)
New England Patriots	October 27 - W (28-10)	October 6 - W (34-13)
St. Louis Rams	November 9 - W (17-7)	September 14 - W (35-14)
Carolina Panthers	December 14 - W (31-10)	November 9 - W (34-0)
Buffalo Bills	December 20 - W (31-21)	October 26 - W (23-20)

Let's look at some important quarterback statistics from these games. From this information you could graph various types of data. You could also calculate the passing percentage or each quarterback (passing percentage=attempts/completions). Scroll to the bottom of this page for a sample chart.

Brett Favre (Packers)	Passing (Attempts-Completions)	Total Passing Yards
New England Patriots	34-23	239
St. Louis Rams	37-18	306
Carolina Panthers	34-18	256
Buffalo Bills	18-12	185 (156-Favre)

John Elway (Broncos)	Passing (Attempts-Completions)	Total Passing Yards
New England Patriots	27-13	196
St. Louis Rams	28-16	247
Carolina Panthers	24-15	248
Buffalo Bills	30-16	133

Now, examine the running game (individual leader and team rushing stats):

Dorsey Levens (Packers)	Levens: Rushing (Att-Yards-Ave)	Total Team Rushing Yards
New England Patriots	26-100-3.8	144
St. Louis Rams	21-81-3.9	96
Carolina Panthers	17-73-4.3	218
Buffalo Bills	22-71-3.2	102

Terrell Davis (Broncos)	Davis: Rushing (Att-Yards-Ave)	Total Team Rushing Yards
New England Patriots	32-171-5.3	192
St. Louis Rams	21-103-4.9	144
Carolina Panthers	21-104-5.0	160
Buffalo Bills	42-207-4.9	225

Finally, the team statistics for defense. Note that these statistics list the yards allowed. Therefore, the lower the number the better.

Packers Defense	Rushing Yards Allowed	Passing Yards Allowed	Total Yards Allowed
N. E. Patriots	69	268	337
St. Louis Rams	66	235	301
Carolina Panthers	140	56	196
Buffalo Bills	51	284	335

Broncos Defense	Rushing Yards Allowed	Passing Yards Allowed	Total Yards Allowed
N. E. Patriots	51	234	285
St. Louis Rams	130	217	347
Carolina Panthers	34	141	175
Buffalo Bills	155	212	367

A sample graph which compares some of this information is shown below. Note that the data listed in the tables above need to be rearranged so that the chart makes sense. Hint: the range of numbers for the chart listed below is A1..C5

Now, you choose the data, design and build a spreadsheet, and graph the information to visually see the data. Once you have produced a chart, print it out and write a short paragraph explaining your personal analysis of the data. Be sure to include who has the advantage based on the data you selected.

Finally, if you'd like to visit some WWW sites related to Super Bowl XXXII, click on the following links:

NFL.com/PACKERS	NFL.com	NFL.com/BRONCOS
Packers Official Web Site	Super Bowl XXXII Site	Broncos Official Web Site

Milwaukee Journal Sentinel Online

The Denver Post Online

Can you use these sites to find other important data to chart about your favorite team?