2. On the same worksheet, you will add a diet recommendation for each player which takes into account the player's BMI.Using the following scale and results, recommend a diet to the player (Note the diet name should be in the column for each player)

BMI Weight Status Diet

Below 18.5 Underweight Terrell Brown Diet

18.5 - 24.9 Normal or Healthy Weight Drew Brees Diet

25.0 - 29.9 Overweight Wes Welker Diet

30.0 and Above Obese Cairo Santos Diet

3. On a separate worksheet named Bears2, perform the following:

a. First, calculate the final grade (Note: there is a raw final grade in col Q - RFG) for each student by using our attendance policy (First 3 absences are free, one letter grade reduction for each one thereafter) and put the result in column S.

b. Now, calculate the letter grade each student should receive in the class using a standard 10 point scale and their final grade in column S.

i. A standard ten point scale operates as follows: 1. A = 90-100 2. B = 80-89 3. C = 70-79

4. D = 60-69 5. F =

c. Highlight in gold the entire row for all students receiving lower than a 70

4. On a separate worksheet named Bears3, calculate the grade distribution of the bears team.(the number of As, Bs, Cs, etc) and show a line graph of the distribution in the same worksheet.

5. On a separate worksheet named Bears4, in column C, determine if the student should have received a mandatory midterm conference by determining whether ALL of the following conditions were true (from Bears2 worksheet):

a. Is the students' average homework grade for homeworks #1 through #3 lower than 70?

b. Is the students' test #1 lower than a 70?

6. On a separate worksheet named Bears4, in column E, determine if the student should have received a mandatory endterm conference by determining whether any of the following conditions were true (from Bears2 worksheet):

a. Is the students' average homework grade for homeworks #1 through #4 lower than 70?

b. Is the students' average exam score (test #1& test #2) lower than a 70?

c. Has the student missed more than the allowed minimum?

Name Acho, Sam Allen, Jared Amos, Adrian Ball, Alan Bellamy, Joshua Bennett, Martellus Bostic, Jonathan Bushrod, Jermon Callahan, Bryce Carey, Ka'Deem Clausen, Jimmy Cutler, Jay Ducasse, Vladimir Fabuluje, Tayo Fales, David Ferguson, Ego Forte, Matt Fuller, Kyle Gafford, Thomas Goldman, Eddie Gould, Robbie Grasu, Hroniss Houston, Lamarr Hurst, Demontre Jeffery, Alshon Jenkins, Jarvis Jones-Quartey, Harold Jones, Christian Langford, Jeremy Lee, Khari Leno, Charles Long, Kyle Mariani, Marc McClellin, Shea McManis, Sherrick McPhee, Pernell Meredith, Cameron Miller, Zach Mitchell, Terrance Montgomery, Will O'Donnell, Pat Omameh, Patrick Porter, Tracy Rodgers, Jacquizz Rolle, Antrel Royal, Eddie Slauson, Matt Pos. LB LB FS CB WR TE LB T CB RB QB QB G OT QB DL RB CB LS DL K C LB CB WR DL DB LB RB TE T G WR/KR LB CB LB WR TE CB C P G CB RB S WR G Ht. 75 78 73 74 73 78 73 77 70 70 74 75 77 78 73 74 74 73 74 76 73 75 75 70 75 76 71 75 73 76 75 78 73 75 73 75 75 77 71 75 76 76 71 66 73 70 77 Wt. 257 255 218 195 208 273 246 315 185 210 210 220 325 342 219 309 218 194 244 332 185 300 270 183 216 300 215 248 208 235 302 328 187 245 197 275 200 240 190 304 220 305 190 199 206 185 320 Age Exp. College 27 5 Texas 33 12 Idaho State 22 0 Penn State 30 8 Illinois 26 1 Louisville 28 8 Texas A&M 24 3 Florida 31 9 Towson 23 0 Rice 22 2 Arizona 27 6 Notre Dame 32 10 Vanderbilt 27 6 Massachusetts 24 0 Texas Christian 24 1 San Jose State 24 2 LSU 29 8 Tulane 23 2 Virginia Tech 32 8 Houston 21 0 Florida State 33 11 Penn State 24 0 Oregon 28 6 Texas 24 2 Oklahoma 25 4 South Carolina 27 5 Clemson 22 0 Findlay 24 2 Florida State 23 0 Michigan State 23 0 Bowie State 23 2 Boise State 26 3 Oregon 28 6 Montana 26 4 Boise State 27 6 Northwestern 26 5 Mississippi State 22 0 Illinois State 30 6 Nebraska-Omaha 23 2 Oregon 32 10 Virginia Tech 24 2 Miami (Fla.) 25 3 Michigan 29 8 Indiana 25 5 Oregon State 32 11 Miami (Fla.) 29 8 Virginia Tech 29 7 Nebraska Sutton, Will Timu, John Vereen, Brock Washington, Cornelius Wilson, Marquess Young, Willie DL LB S DL WR LB 73 73 71 76 76 76 315 247 202 285 199 251 23 23 23 25 22 29 2 0 2 3 3 6 Arizona State Washington Minnesota Georgia Washington State North Carolina State Name Acho, Sam Allen, Jared Amos, Adrian Ball, Alan Bellamy, Joshua Bennett, Martellus Bostic, Jonathan Bushrod, Jermon Callahan, Bryce Carey, Ka'Deem Clausen, Jimmy Cutler, Jay Ducasse, Vladimir Fabuluje, Tayo Fales, David Ferguson, Ego Forte, Matt Fuller, Kyle Gafford, Thomas Goldman, Eddie Gould, Robbie Grasu, Hroniss Houston, Lamarr Hurst, Demontre Jeffery, Alshon Jenkins, Jarvis Jones-Quartey, Harold Jones, Christian Langford, Jeremy Lee, Khari Leno, Charles Long, Kyle Mariani, Marc McClellin, Shea McManis, Sherrick McPhee, Pernell Meredith, Cameron Miller, Zach Mitchell, Terrance Montgomery, Will O'Donnell, Pat Omameh, Patrick Porter, Tracy Rodgers, Jacquizz Rolle, Antrel Royal, Eddie Absences 5 4 2 2 3 4 1 1 1 4 2 2 1 4 2 0 5 2 3 0 1 1 4 4 4 1 4 1 3 3 2 0 2 5 2 0 3 4 1 4 2 3 1 4 2 4 Homeworks #1 83 53 87 91 89 71 61 98 67 76 93 93 84 77 96 79 63 71 85 100 81 96 76 98 99 69 51 57 84 82 56 76 88 60 90 72 87 60 73 88 94 71 97 91 68 99 #2 76 60 86 80 72 58 79 51 90 86 55 88 89 100 86 55 80 50 59 86 98 89 78 96 74 88 60 64 61 69 73 78 89 62 65 59 55 85 79 98 53 58 76 72 72 65 #3 60 59 58 86 63 62 64 64 69 94 75 66 69 99 68 55 67 87 54 90 93 76 83 70 80 51 56 79 83 69 67 95 74 50 95 94 55 60 64 56 52 82 90 66 93 50 #4 94 57 88 54 87 72 51 97 69 65 62 87 84 89 69 61 70 85 61 99 52 87 76 58 69 56 73 53 52 86 79 91 81 53 73 60 69 69 50 74 91 72 69 87 70 64 #5 67 51 90 100 51 90 70 95 50 61 73 83 56 63 77 100 71 91 50 60 70 87 71 97 69 54 73 65 93 93 84 88 83 58 77 86 97 51 73 96 51 66 54 59 58 82 Slauson, Matt Sutton, Will Timu, John Vereen, Brock Washington, Cornelius Wilson, Marquess Young, Willie 4 1 1 2 2 3 4 89 85 56 53 91 76 91 94 51 90 95 61 72 83 98 65 55 94 90 53 78 93 95 65 86 79 93 72 88 66 81 58 75 56 71 AVG 75.4 56 81.8 82.2 72.4 70.6 65 81 69 76.4 71.6 83.4 76.4 85.6 79.2 70 70.2 76.8 61.8 87 78.8 87 76.8 83.8 78.2 63.6 62.6 63.6 74.6 79.8 71.8 85.6 83 56.6 80 74.2 72.6 65 67.8 82.4 68.2 69.8 77.2 75 72.2 72 Exams #1 56 81 91 93 60 76 67 96 68 64 91 94 92 90 92 75 72 99 94 51 96 67 62 51 81 74 61 59 95 97 62 76 92 67 95 99 99 58 78 88 87 67 94 65 91 63 #2 52 63 53 81 99 70 66 77 73 92 73 69 55 61 89 61 52 91 80 81 51 73 55 81 61 78 95 82 67 66 100 55 94 98 64 82 84 85 53 99 98 62 65 70 83 53 FE 90 99 64 81 54 76 60 83 71 73 70 100 83 55 69 83 99 86 79 73 92 71 71 78 65 80 70 64 62 95 92 71 64 65 52 74 57 91 96 83 62 90 93 52 79 78 RFG 70 73 73 84 71 73 64 84 70 76 75 87 77 74 81 72 74 86 76 75 80 76 68 75 72 73 71 66 74 84 81 74 82 69 73 81 76 74 74 87 76 73 82 66 80 68 FG FLG 92.4 72.4 69.4 77.2 79.2 70 79 63 85 89 98 75 50 72 85 98 95 64 56 78 50 78 85 79 97 59 63 75 81 83 81 84 69 66 71 Conference? Grade Distribution for Bears2 A B C D F Name Acho, Sam Allen, Jared Amos, Adrian Ball, Alan Bellamy, Joshua Bennett, Martellus Bostic, Jonathan Bushrod, Jermon Callahan, Bryce Carey, Ka'Deem Clausen, Jimmy Cutler, Jay Ducasse, Vladimir Fabuluje, Tayo Fales, David Ferguson, Ego Forte, Matt Fuller, Kyle Gafford, Thomas Goldman, Eddie Gould, Robbie Grasu, Hroniss Houston, Lamarr Hurst, Demontre Jeffery, Alshon Jenkins, Jarvis Jones-Quartey, Harold Jones, Christian Langford, Jeremy Lee, Khari Leno, Charles Long, Kyle Mariani, Marc McClellin, Shea McManis, Sherrick McPhee, Pernell Meredith, Cameron Miller, Zach Mitchell, Terrance Montgomery, Will O'Donnell, Pat Omameh, Patrick Porter, Tracy Rodgers, Jacquizz Rolle, Antrel Royal, Eddie Mandatory Midterm? Mandatory Endterm? Slauson, Matt Sutton, Will Timu, John Vereen, Brock Washington, Cornelius Wilson, Marquess Young, Willie