Legends+and+Leaders

High Standards for High Achievement



**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?

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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? <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">Bonus: Which defensive player scored more touchdowns than all the QB's combined? How many did he score?

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">GAME 3: Michigan State Spartans vs Youngstown State
<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">This, ladies and gentlemen, was a prime example of an MSU BLOWOUT!!!!

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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 <span class="wiki_link_ext">[|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:

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">1. Find the mean, median, mode and range of BOTH teams' scores.

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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)

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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)

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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)

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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?

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">GAME 4: Michigan State Spartans vs Notre Dame
<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">We may have managed to beat ourselves in this dreadful loss. This has become our first and hopefully last loss of the season ; )

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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 <span class="wiki_link_ext" style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 19.2px;">[|MSU Official Football Site] <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;"> 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:

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">1. Find the mean, median, mode and range of BOTH teams' scores. <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">2. If the game started at 3:43p.m. and ended at 7:11p.m., how much time elapsed? <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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) <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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) <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">5. Read the article from [|MSU's Headlines] that describes the devastating loss to ND entitled, **<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">"Michigan State Falls To No. 22 Notre Dame, 17-13". **<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">How many total yards were the Spartans penalized during this game? How many total penalties were called against us by Big Ten Officials?

=**<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">GAME 5: Michigan State Spartans vs IOWA Hawkeyes **=

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">This was an exciting win out in Iowa City, Iowa to give us an outstanding first win in the BIG TEN conference.

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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 <span class="wiki_link_ext" style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 19.2px;">[|MSU Official Football Site] <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;"> 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:

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">1. Find the mean, median, mode and range of BOTH teams' scores.

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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)

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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)

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">4. What was Connor Cooks longest pass of the day? (HINT:Look Under INDIVIDUAL STATISTICS for Cook)

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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?

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 160%;">GAME 6: Michigan State Spartans vs Indiana Hoosiers
<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 130%;">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!

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 130%;">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:

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">1. Find the mean, median, mode and range of BOTH teams' scores.

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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)

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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)

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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. <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">What was his percentage of completed passes?

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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?

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 160%;">GAME 7: Michigan State Spartans vs Purdue
<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 130%;">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!

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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:

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">1. Find the mean, median, mode and range of BOTH teams' scores.

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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?

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">3. Connor Cook also rushed for 29 yds, but only completed 13 passes out of 26 attempts. What was his percentage of completed passes?

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">4. The game started at 12:01 pm and ended at 2:58 pm. How much time elapsed during the game?

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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?

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 160%;">GAME 8: Michigan State Spartans vs Illinois
<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 130%;">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!!!

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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:

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">1. Find the mean, median, mode and range of BOTH teams' scores.

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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?

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">3. Cook had a near perfect day and threw 15 completions in 16 attempts. What is his percentage of completed passes?

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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?

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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?


 * <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 160%;">GAME 9: Michigan State Spartans vs University of Michigan **

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 130%;">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!!!

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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:

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">1. Find the mean, median, mode and range of BOTH teams' scores. <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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.) <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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. <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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? <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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?


 * <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 160%;">GAME 10: Michigan State Spartans vs University of Nebraska **

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 130%;">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!

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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:

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">1. Find the mean, median, mode and range of BOTH teams' scores. <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">2. Using the Defensive Statistics, name the FIVE DIFFERENT players who either had a Fumble Recovery (FR-YD) or Interception (INTC) in the game. <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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) <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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) <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">5. To recap the game, read the article, [|"] <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">[|Spartans Force Five Turnovers, Beat Nebraska, 41-28"]. <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">Michigan State converted Nebraska's five turnovers into how many of their 41 points on an afternoon that the Spartans' defense proved fallible?

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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?

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 130%;">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!!!
 * <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 160%;">GAME 11: Michigan State Spartans vs Northwestern University **

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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 <span class="wiki_link_ext">[|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:

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">1. Find the mean, median, mode and range of BOTH teams' scores. <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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) <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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? <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">4. Connor Cook threw 16 times for 293 yards and 2 touchdowns. What is his average yards per pass throughout the game? <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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?


 * <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 160%;">GAME 12: Michigan State Spartans vs Minnesota University **

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 130%;">**PERFECT IN THE BIG TEN!!!** Next week Big Ten Championship against 3rd ranked Ohio State who struggled defensively against Michigan on Saturday!

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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 <span class="wiki_link_ext" style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 19.2px;">[|MSU Official Football Site] <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;"> 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:

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">1. Find the mean, median, mode and range of BOTH teams' scores. <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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? <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">3. Our offense gained 348 yards on 51 total offense plays. What was our average yards gained per play on offense? <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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? <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">5. Check out this article that chronicles our perfect Big 10 season with the win against Minnesota. <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">[|No. 11 MSU Tops Minnesota, Finishes Perfect in Big Ten.] <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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?


 * <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 160%;">GAME 13: Big Ten Championship-Michigan State Spartans vs State **


 * <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 160%;">HUGE Upset! MSU Topples OSU for the championship 34-24!!! Start smelling the roses!!! **

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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 <span class="wiki_link_ext" style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 19.2px;">[|MSU Official Football Site] <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;"> 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:

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">1. Find the mean, median, mode and range of BOTH teams' scores. <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">2. Create THREE analysis Questions of your own and answer them for questions 2-4. <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">5. We are going to the Rose Bowl to play on New Years Day! Answer the following questions about the Rose Bowl: <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">a. How long has it been since MSU played in the rose bowl? <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">b. Where is the Rose Bowl located? What stadium will we play in? <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">c. Who will our opponent be? What is their record?

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 160%;">


 * <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 25.6px;">GAME 14: Rose Bowl Championship- Michigan State vs. Stanford **
 * <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 25.6px;">Michigan State Spartans WIN the 100th Rose Bowl In Pasadena!!! **

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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 <span class="wiki_link_ext" style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 19.2px;">[|MSU Official Football Site] <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;"> 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:

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">1. Find the mean, median, mode and range of BOTH teams' scores. <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">2. Read this article, [|Rose Bowl Champions: No. 4 MSU Beats No. 5 Stanford, 24-20] <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">and choose FIVE statistics about the Michigan State Spartans and/or ROSE BOWL that are legendary. <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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? <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">4. Connor Cook went for 22-36-1 for the game. What do each of these numbers mean? <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">5. Read the article from ESPN [|Michigan State stops Stanford to win 100th Rose Bowl] <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">Answer the following questions found in the article:

<span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">a. Who flipped the coin at the Rose Bowl? <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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) <span style="color: #008000; font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif; font-size: 120%;">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?