6th Grade Vacation or Favorite Team
Locate the following data on the internet:
Your favorite sports team from 2010 - 2020
The weather in a spot you have always wanted to visit for 2 weeks.
1. In cell A1 type in a heading that relates to either the sports team, or your place to visit.
2. In cell A2 type in a subheading Merge and Center as needed to align with your data. Cell A3 the name of your team.
3. For the sports team you need to record the last 10 years in column A (A4-A14) 2020-2010, etc.
Then in Column B Wins for each year.
Column D using a formula determine the number of wins to losses. =B4-C4 percentage of wins =wins/total games in a season
NFL teams play 16 games if the team won 8 games the formula would be =8/16 Enter then use the Fill Handle to populate the rest of the cells!
4. Then make a chart indicate wins and losses but not the difference. Color the background
4. For the place to visit, pick 2 weeks you would like to visit for Column A then should have Day 1 - Day 14 starting in Cell A4
Column B the temperature average for every day in separate cells.
Column C the High temperature for each day
Column D the Low temperature for each day
Column E using a FORMULA indicate the difference between the the low temperature and the high temperature. =high-low
The formula for figuring average is =(high+low)/2
Then make a chart indicate lows and highs but not the difference. Color the background