High Standards for High Achievement

Legends and Leaders.jpg


Legends and Leaders: MSU Spartans Big Ten Football Challenge!

You are embarking on a season long journey of analyzing statistics and creating graphs of Michigan State Football Games. In a culminating project, you will create a presentation outlining the 2013 Spartan Football Season, so it is very important that you keep up with your weekly graphs and stats! Have fun and I hope you develop a special love for this game! Sparty On, 6th and 7th Graders!


GAME 1: Michigan State Spartans vs Western Michigan Broncos

Using Google Spreadsheets, create a table of the box score from Game 1: MSU vs WMU by going to the MSU Official Football Site and copying the box score into the Google document. Then use your table to create an appropriate graph of the data. Finally, insert a text box on the same Google Spreadsheet and answer the following questions in COMPLETE SENTENCES:

1. What was the mean (average) score for both teams per quarter?

2. What was the mode of the combined scores for both teams? What was the range of the scores?

3. Did MSU score more points in the first half or second half? How Many More?

4. Who won the game?

5. Read this game analysis from MSU's Headlines on their official website entitled, " Defense Produces in Season Opener". How many yards did Drummond return the ball after it was lateraled to him from Jpnes to score the defensive touchdown? (HINT: You have to READ the article and look for key words Jones and Drummond)

GAME 2: Michigan State Spartans vs Southern Florida University


Using Google Spreadsheets, Click on a new sheet and begin your data analysis for Game 2. Create a table of the box score from Game 2: MSU vs SFU by going to the MSU Official Football Site and copying the box score into the Google document. Then use your table to create an appropriate graph of the data. Finally, insert a text box on the same Google Spreadsheet and answer the following questions in COMPLETE SENTENCES:

1. Find the mean, median, mode and range of BOTH teams' scores.

2. Since touchdowns are worth 6 points and MSU made the point after (they never went for two extra points) for each touchdown, and field goals are worth 3 points, how many touchdowns and field goals did MSU score? How many of both did SFU score?

3. Did FSU score more points in the first half or second half? How Many More?

4. Who won the game?

5. Read this game analysis from MSU's Headlines on their official website entitled, Michigan State Shuts Down South Florida". How many quarterbacks did MSU play in the game? How many touchdowns did they account for in the game?
Bonus: Which defensive player scored more touchdowns than all the QB's combined? How many did he score?




GAME 3: Michigan State Spartans vs Youngstown State


This, ladies and gentlemen, was a prime example of an MSU BLOWOUT!!!!

Using Google Spreadsheets, click on a new sheet and begin your data analysis for Game 3. Create a table of the box score from Game 3: MSU vs. YSU by going to the MSU Official Football Site and copying the box score into the Google document. Then use your table to create an appropriate graph of the data. Finally, insert a text box on the same Google Spreadsheet and answer the following questions in COMPLETE SENTENCES:

1. Find the mean, median, mode and range of BOTH teams' scores.

2. MSU's offense finally began to move the ball and score offensive points! How many touchdowns did MSU's offense score throughout the whole game? How many field goals did we score? (Hint: Scroll down and look under the "Scoring Summary" for this week's game)

3. Quarteback Connor Cook was "cooking" all game. He threw for 270 yards and completed 22 out of 32 passes. What was his completion rate for the game? (Hint: Divide his completed passes from his attempts...divide 22 by 32 and approximate the percentage)

4. Our running game also took off against Youngstown. We rushed 49 times for 284 yards. what was the average yards gained per attempt? (HINT: Divide the attempts by the total yardage)

5. We played an exciting game through all four quarters! Read the game analysis from MSU's Headlines entitled, "Spartan Offense Soars in Win Over Penguins". How many yards of TOTAL OFFENSE did MSU have? Who rushed for a career-high 83 yards on nine carries for Michigan State, including a 35-yard touchdown in the third quarter?




GAME 4: Michigan State Spartans vs Notre Dame


We may have managed to beat ourselves in this dreadful loss. This has become our first and hopefully last loss of the season ; )

Using Google Spreadsheets, click on a new sheet and begin your data analysis for Game 4. Create a table of the box score from Game 4: MSU vs. ND by going to the MSU Official Football Site and copying the box score into the Google document. Then use your table to create an appropriate graph of the data. Finally, insert a text box on the same Google Spreadsheet and answer the following questions in COMPLETE SENTENCES:

1. Find the mean, median, mode and range of BOTH teams' scores.
2. If the game started at 3:43p.m. and ended at 7:11p.m., how much time elapsed?
3. Michigan State converted only 6 of 17 third downs (so they had to give the ball up and punt). What was their third down conversion percentage? (HINT: divide the first number by the second number and convert that decimal to a percent)
4. Which defensive player had the most sacks for MSU? You will need to look under "Defensive Statistics". How many combined tackles did he have? (solo and assisted tackles put together)
5. Read the article from MSU's Headlines that describes the devastating loss to ND entitled, "Michigan State Falls To No. 22 Notre Dame, 17-13". How many total yards were the Spartans penalized during this game? How many total penalties were called against us by Big Ten Officials?



GAME 5: Michigan State Spartans vs IOWA Hawkeyes


This was an exciting win out in Iowa City, Iowa to give us an outstanding first win in the BIG TEN conference.

Using Google Spreadsheets, click on a new sheet and begin your data analysis for Game 5. Create a table of the box score from Game 5: MSU vs. U of I by going to the MSU Official Football Site and copying the box score into the Google document. Then use your table to create an appropriate graph of the data. Finally, insert a text box on the same Google Spreadsheet and answer the following questions in COMPLETE SENTENCES:

1. Find the mean, median, mode and range of BOTH teams' scores.

2.Cook threw for a career high 277 yds and 2 touchdowns. If he threw 25 completions, what is the average yds gained per completion? (HINT: Divide yds by completions)

3. In our last 3rd quarter scoring drive we went 71 yds in 7 plays to score a passing touchdown. What is the average yd per play for this scoring drive? (HINT: Divide the number of yards by the number of plays)

4. What was Connor Cooks longest pass of the day? (HINT:Look Under INDIVIDUAL STATISTICS for Cook)

5. Read the game analysis from MSU's Headlines "Spartans Defeat Hawkeyes in Big Ten Opener" . After the Spartans pulled off a crucial fake punt, what happened on the ensuing drive?




GAME 6: Michigan State Spartans vs Indiana Hoosiers


This was an explosive contest vs. the high octane offense of Indiana and the #1 Defense in the nation of Michigan State. MSU held Indiana to just 28pts, their lowest of the season, to prevail in an exciting victory!

Using Google Spreadsheets, click on a new sheet (SHEET 6) and begin your data analysis for Game 6. Create a table of the box score from Game 6: MSU vs. ISU by going to the MSU Official Football Site and copying the box score into the Google document. Then use your table to create an appropriate graph of the data. Finally, insert a text box on the same Google Spreadsheet and answer the following questions in COMPLETE SENTENCES:

1. Find the mean, median, mode and range of BOTH teams' scores.

2. MSU rushed for a whopping 238 yards in 47 attempts and scored 4 rushing touchdowns. What was their average rushing yards per attempt vs ISU? (Hint: you need to divide the total yards by attempts)

3. In the first quarter, MSU came up empty and didn't score any points. However, in the second quarter they had a scoring drive of 83 yds, 60 yds and 75 yds. They didn't stop there...in the third quarter they had a scoring drive of 75 yds and 65 yds that resulted in 2 more touchdowns! They continued to score in the 4th quarter had scoring drive of 73 yds. How many total yards did they have on scoring drives? (HINT: ADD Them all up) What percent is this of the total yds they had in the game? (They had 473 total offense yards- DIVIDE total yds from the scoring drives by the total offense yds)

4. Connor Cook once again had a stellar day. He threw for 235 yds and 2 touchdowns. He also completed 22 out of 31 passes.
What was his percentage of completed passes?

5. This was our HOMECOMING game in East Lansing. Read the article, "Spartans Pull Away for 42-28 Win Over Indiana" . After a phenomenal 69 yd punt from Mike Sadler, where was Indaina pinned on the field in the 4th quarter?



GAME 7: Michigan State Spartans vs Purdue

Spartans Shut Out Purdue and allow ZERO points to be scored the entire game! MSU stands first in our division with an overall 6-1 Record, and a 3-0 record in our conference!!! Sparty On!

Using Google Spreadsheets, click on a new sheet (SHEET 7) and begin your data analysis for Game 7. Create a table of the box score from Game 7: MSU vs. PU by going to the MSU Official Football Site and copying the box score into the Google document. Then use your table to create an appropriate graph of the data. Finally, insert a text box on the same Google Spreadsheet and answer the following questions in COMPLETE SENTENCES:

1. Find the mean, median, mode and range of BOTH teams' scores.

2. MSU Rushers once again had an outstanding rushing day! Langford led the pack and ran 24 times for 140 yds. What was his average yards per carry?

3. Connor Cook also rushed for 29 yds, but only completed 13 passes out of 26 attempts. What was his percentage of completed passes?

4. The game started at 12:01 pm and ended at 2:58 pm. How much time elapsed during the game?

5. Read the article, "Spartans Shut Out Purdue, 14-0" and answer the following question: Which MSU receiver threw a 5-yard touchdown pass to Andrew Gleichert on a trick play to finally create a scoring chance late in the 4th quarter?




GAME 8: Michigan State Spartans vs Illinois


MSU controlled every step of this game to become ranked #1 in both their conference and their division to move 7-1 on the season. Hopefully they can carry this momentum on to next week when we play a tough Wolverine team back at home in East Lansing. Go Green!!!

Using Google Spreadsheets, click on a new sheet (SHEET 8) and begin your data analysis for Game 8. Create a table of the box score from Game 8: MSU vs. Illinois by going to the MSU Official Football Site and copying the box score into the Google document. Then use your table to create an appropriate graph of the data. Finally, insert a text box on the same Google Spreadsheet and answer the following questions in COMPLETE SENTENCES:

1. Find the mean, median, mode and range of BOTH teams' scores.

2. The Defense came up huge and allowed only 3 points scored. Look at the Defensive Statistics. How many TOTAL tackles did the Defense have all together?

3. Cook had a near perfect day and threw 15 completions in 16 attempts. What is his percentage of completed passes?

4. On a scoring drive, MSU started out at their own 25 yard line. They were flagged for a false start and lost 5 yards. How would we write this as an integer? What yard line were they backed up to? After the penalty, Connor Cook threw a 15 yd pass for a first down. What yard line were the Spartans on after the pass?

5. Read the Article, "Michigan State Stifles Illinois in 42-3 Win" The Michigan State defense came into the game ranked first in the nation in total defense at 228 yards a game, and looked even better on Saturday. How many yards did they hold Illinois to ? How many of those yards were on the ground?



GAME 9: Michigan State Spartans vs University of Michigan

A Game for the History Books! Michigan State's Defense Toppled the Wolverines as State leads the Division in a 29-6 VICTORY over U of M!!!

Using Google Spreadsheets, click on a new sheet (SHEET 9) and begin your data analysis for Game 9. Create a table of the box score from Game 9: MSU vs. U Of M by going to the MSU Official Football Site and copying the box score into the Google document. Then use your table to create an appropriate graph of the data. Finally, insert a text box on the same Google Spreadsheet and answer the following questions in COMPLETE SENTENCES:

1. Find the mean, median, mode and range of BOTH teams' scores.
2. MSU's defense came up HUGE with 7 sacks throughout the game. How many TOTAL yards did they set Michigan back? Write your answer as an integer. (HINT: Look in Defensive Stats under total yds.)
3. Again, MSU's defense made history by keeping the Michigan offense to a total of -48 yards rushing. This has NEVER been done throughout the Wolverine's valiant history. They tried to run the ball 29 times. What was their rushing percentage? Write your answer as an integer.
4. Although our offense missed several opportunities to score, we finally came up with a devastating touchdown that U of M could not answer right before the half. We ran 10 plays for 75 yards on this scoring drive. What was the average yards per play on this touchdown drive?
5. Solidifying the top spot for our Defense, MSU pounded the Wolverines. Read the article, "No. 24 Michigan State Batters No. 23 Michigan, 29-6". Michigan State (8-1, 5-0 Big Ten) has won five of the last six meetings with the Wolverines (6-2, 2-2), and this was the Spartans' most lopsided win in the series since what year?



GAME 10: Michigan State Spartans vs University of Nebraska

Michigan State's Defense once again rolled over the Nebraska Cornhuskers as they forced FIVE turnovers to ensure a win AND a piece of the Legends Division Title. One more win and we could be going to the Big Ten Championship Game!

Using Google Spreadsheets, click on a new sheet (SHEET 10) and begin your data analysis for Game . Create a table of the box score from Game 10: MSU vs. U Of N by going to the MSU Official Football Site and copying the box score into the Google document. Then use your table to create an appropriate graph of the data. Finally, insert a text box on the same Google Spreadsheet and answer the following questions in COMPLETE SENTENCES:

1. Find the mean, median, mode and range of BOTH teams' scores.
2. Using the Defensive Statistics, name the FIVE DIFFERENT players who either had a Fumble Recovery (FR-YD) or Interception (INTC) in the game.
3. Langsford rushed for a whopping 151 yards in 32 attempts and scored TWO touchdowns in an outstanding performance on Saturday. What was his average gain in yards per rushing attempt? (HINT: Divide total yards by attempts)
4. We played this game on the road at the University of Nebraska. What city is this university located in and what is the name of their stadium? (HINT- READ the first paragraph before the Scoring Summary)
5. To recap the game, read the article, "Spartans Force Five Turnovers, Beat Nebraska, 41-28". Michigan State converted Nebraska's five turnovers into how many of their 41 points on an afternoon that the Spartans' defense proved fallible?

The defense was fallible because The Spartans gave up 182 yards rushing and 392 total, both season highs. They had come into the game allowing an average of 43 yards rushing and 210 total. How many more yards of both (rushing and total yds) did they give up to Nebraska compared to their season averages?





GAME 11: Michigan State Spartans vs Northwestern University
With the win against Northwestern, MSU clinched a Legends Conference Title outright and a bid to play Ohio State for the Big Ten Championship on December 7th! GO GREEN!!!


msu legends.jpg
Using Google Spreadsheets, click on a new sheet (SHEET 11) and begin your data analysis for Game . Create a table of the box score from Game 11: MSU vs. NU by going to the MSU Official Football Site and copying the box score into the Google document. Then use your table to create an appropriate graph of the data. Finally, insert a text box on the same Google Spreadsheet and answer the following questions in COMPLETE SENTENCES:

1. Find the mean, median, mode and range of BOTH teams' scores.
2. MSU had 64 offense plays that went for a total of 464 yards. What was our average yards gained on offense? (HINT: Divide the number of plays by the total yards)
3. The Spartans were 3 for 5 in the Red Zone (within 20 yards of scoring a touchdown). What was their scoring percentage in the Red Zone?
4. Connor Cook threw 16 times for 293 yards and 2 touchdowns. What is his average yards per pass throughout the game?
5. Read the article that chronicles our historic win, MSU Heads to Big Ten Title Game with 30-6 Win Over Cats How many conference championships have we had in the past three years? What Bowl game might we go to if we can win the Big Ten Championship?


GAME 12: Michigan State Spartans vs Minnesota University

PERFECT IN THE BIG TEN!!! Next week Big Ten Championship against 3rd ranked Ohio State who struggled defensively against Michigan on Saturday!

Using Google Spreadsheets, click on a new sheet (SHEET 12) and begin your data analysis for Game . Create a table of the box score from Game 12: MSU vs. MU by going to the MSU Official Football Site and copying the box score into the Google document. Then use your table to create an appropriate graph of the data. Finally, insert a text box on the same Google Spreadsheet and answer the following questions in COMPLETE SENTENCES:

1. Find the mean, median, mode and range of BOTH teams' scores.
2. Connor Cook had a tough day going only for 10 completions out of 20 attempts and 148 yards. What was his percentage for completions on the day?
3. Our offense gained 348 yards on 51 total offense plays. What was our average yards gained per play on offense?
4. MSU's big D held Minnesota to a goose egg on the score board and only gave up 124 yards in the passing game. Their QB went 9-25-2, which is 9 completions, 25 attempts and 2 interceptions. What was their average percentage of completions?
5. Check out this article that chronicles our perfect Big 10 season with the win against Minnesota. No. 11 MSU Tops Minnesota, Finishes Perfect in Big Ten. Michigan State went 75 yards in eight plays to start the third quarter and led 14-3 after Cook's 12-yard scoring pass to Josiah Price. What was their average yards gained on that scoring drive?



GAME 13: Big Ten Championship-Michigan State Spartans vs State

HUGE Upset! MSU Topples OSU for the championship 34-24!!! Start smelling the roses!!!

Using Google Spreadsheets, click on a new sheet (SHEET 13) and begin your data analysis for Game . Create a table of the box score from Game 13: MSU vs. OSU by going to the MSU Official Football Site and copying the box score into the Google document. Then use your table to create an appropriate graph of the data. Finally, insert a text box on the same Google Spreadsheet and answer the following questions in COMPLETE SENTENCES:

1. Find the mean, median, mode and range of BOTH teams' scores.
2. Create THREE analysis Questions of your own and answer them for questions 2-4.
5. We are going to the Rose Bowl to play on New Years Day! Answer the following questions about the Rose Bowl:
a. How long has it been since MSU played in the rose bowl?
b. Where is the Rose Bowl located? What stadium will we play in?
c. Who will our opponent be? What is their record?



rose bowl.jpg


GAME 14: Rose Bowl Championship- Michigan State vs. Stanford
Michigan State Spartans WIN the 100th Rose Bowl In Pasadena!!!

Using Google Spreadsheets, click on a new sheet (SHEET 14) and begin your data analysis for Game 14: The Rose Bowl Championship . Create a table of the box score from Game 14: MSU vs. SU by going to the MSU Official Football Site and copying the box score into the Google document. Then use your table to create an appropriate graph of the data. Finally, insert a text box on the same Google Spreadsheet and answer the following questions in COMPLETE SENTENCES:

1. Find the mean, median, mode and range of BOTH teams' scores.
2. Read this article, Rose Bowl Champions: No. 4 MSU Beats No. 5 Stanford, 24-20and choose FIVE statistics about the Michigan State Spartans and/or ROSE BOWL that are legendary.
3. TWICE during the game, MSU overcame 10 pt deficits and went on to win the game. On their last scoring drive, Connor Cook threw a 25 yd pass to wide receiver Tony Lippett, who made an amazing catch to take the final lead. This was his 5th catch of the game for a total of 94 yds. What was his average yards per catch during this game?
4. Connor Cook went for 22-36-1 for the game. What do each of these numbers mean?
5. Read the article from ESPN Michigan State stops Stanford to win 100th Rose Bowl
Answer the following questions found in the article:

a. Who flipped the coin at the Rose Bowl?
b. The Spartan Nation fans were a HUGE part of the game. What percentage of Michigan State fans were at the the Rose bowl? (Hint there were 95, 183 total fans in Pasadena)
c. When Kyler Elsworth soared over the pile to deliver the final hit of Michigan State's season, the storybook ending came with a moral. What was the MORAL for MSU for this season?