IT Practice Assessment - The IT BCS Rankings
On the sheet named BCS you will find 25 teams with a variety of numbers indicating their points or rankings as given to them
1. Add a column between C and D and calculate the rank of each team according to the Harris Poll (highest points should be r
Title the column "RK" and merge and center "Harris Poll" above its "RK" and "PTS" columns.
2. Repeat the previous instruction for the USA Today numbers.
3. Add a new column to the right of the Computer Rankings and average the computer rankings. Display the results to two de
Title the column "AVG", and merge and center "Computer Rankings" above this column and the other computer ranking colu
4. Calculate a weighted average of the three rankings (Harris, USA, and Computer) by multiplying the Computer AVG by 3, ad
Display the results to two decimal places in a new column titled "IT BCS AVG".
5. Insert a new column at the far left of your spreadsheet and title it "IT BCS RK". In this column rank the "IT BCS AVG" numbe
Add a graph showing both the Harris and USA points for each team. Be sure that the team name shows for each team.
For Above Mastery:
Use the numbers in some creative way to come up with your own ranking system.
Describe your system either in comments or by typing text into cells (as these instructions are written).
Produce an additional graph (or two) that compares your ranking with the BCS ranking.
oints or rankings as given to them by various media outlets and computer programs.
ris Poll (highest points should be ranked #1).
ings. Display the results to two decimal places.
the other computer ranking columns.
plying the Computer AVG by 3, adding the Harris and USA averages, and dividing by 5.
umn rank the "IT BCS AVG" numbers.
ame shows for each team.
re written).
College Football BCS standings - November 22, 2010
BCS Harris USA Today Computer rankings
RK TEAM PTS PTS A&H RB CM KM JS PW
1 Oregon 2793 1459 2 2 5 2 2 2
2 Auburn 2727 1398 1 4 1 1 1 1
3 TCU 2557 1300 3 1 2 4 5 3
4 Boise State 2619 1341 5 3 4 6 7 6
5 LSU 2227 1175 4 5 3 5 3 4
6 Stanford 2209 1112 10 9 6 3 4 5
7 Wisconsin 2295 1211 8 7 12 9 9 10
8 Ohio State 2131 1116 6 10 10 15 11 9
9 Oklahoma State 1805 990 7 8 7 7 10 8
10 Michigan State 1797 927 9 11 11 16 15 11
11 Alabama 1783 885 13 6 14 13 8 12
12 Arkansas 1589 784 14 15 13 8 6 7
13 Oklahoma 1412 733 11 14 9 12 16 15
14 Missouri 1176 585 12 16 8 10 13 13
15 Nebraska 1199 614 15 12 15 14 12 14
16 Virginia Tech 1322 723 18 17 17 22 21 17
17 Texas A&M 936 492 16 19 16 11 14 16
18 South Carolina 1037 577 17 18 19 17 18 20
19 Nevada 894 456 19 21 18 19 22 19
20 Utah 495 228 20 13 20 20 20 18
21 Arizona 471 279 24 20 23 18 19 22
22 Florida State 439 243 21 26 21 26 26 24
23 North Carolina State 330 208 26 25 22 26 26 25
24 Iowa 284 74 22 23 25 23 23 23
25 Mississippi State 178 68 25 22 26 21 17 21