2004 Election Assignment - Excel

President George W. Bush 2004 Presidential Election U.S. Senator John F. Kerry

This assignment is a reflection of the 2004 Presidential Election. Students will be asked to create an Excel spreadsheet that gives the election results nationally and by state. Students will be asked to utilize the formula wizard, basic functions and charts in Excel.

Students (in groups of two)-

Must use the formulas wizard to-

Provide basic formatting functions for presentation and eye appeal

Use the Charts wizard to show the percentage of the vote on a National scale.

Below are all the necessary resources

 

2004 General Election Results
(C-SPAN.org)
President Of The United States

 

  Name Party Votes Percent % Electoral Votes States Won

Bush Republican 59,651,290 51 286 31
Kerry Democrat 56,158,908 48 252 20
Others 678,167 1 0 0
Nader Independent 404,285 0 0 0

State By State Totals

Key To Abbreviations
Party Affiliation
Major Party Democrat Dem
Republican Rep
Third Party American Independent AIP Other Oth
Alaskan Independence AKI Pacific Green PAG
  American Constitution AmC Personal Choice PCH
Christian Fulangist CC Petition, By PEC
Concerns of People CnP Peace and Freedom PFP
Constitution CST Populist Pop
Dist. Columbia Green DCG Prohibition Pro
Green Grn Protecting Working Families PWF
Independent American IAP Socialist Equality SEP
Independent Ind Socialist Soc
Libertarian Lib Socialist Workers SWP
Liberty Union LUn The Better Life TBL
Nebraskan Neb United Citizens UCz
National Labor NLP Unavailable Una
National NP US Ability UST
Reform RP Workers World WW

 

Alabama   Electoral College Total: 9   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 1,174,348 63 9
  Kerry Dem 691,993 37 0
  Nader Ind 6,778 0 0
  Badnarik Ind 3,532 0 0
  Peroutka Ind 2,007 0 0

 

Alaska   Electoral College Total: 3   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 151,876 62 3
  Kerry Dem 86,064 35 0
  Nader Pop 3,890 2 0
  Peroutka AKI 1,643 1 0
  Badnarik Lib 1,369 1 0
  Cobb Grn 757 0 0

 

Arizona   Electoral College Total: 10   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 908,211 55 10
  Kerry Dem 735,327 44 0
  Badnarik Lib 9,892 1 0

 

Arkansas   Electoral College Total: 6   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 566,678 54 6
  Kerry Dem 464,157 45 0
  Nader Pop 6,031 1 0
  Badnarik Lib 2,330 0 0
  Peroutka CST 2,106 0 0
  Cobb Grn 1,486 0 0

 

California   Electoral College Total: 55   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
  Bush Rep 4,403,495 44 0
Kerry Dem 5,427,055 55 55
  Badnarik Lib 39,793 0 0
  Cobb Grn 31,679 0 0
  Peltier PFP 21,616 0 0
  Peroutka AIP 20,987 0 0

 

Colorado   Electoral College Total: 9   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 1,068,233 52 9
  Kerry Dem 960,666 47 0
  Nader RP 12,179 1 0
  Badnarik Lib 7,397 0 0
  Peroutka AmC 2,483 0 0
  Cobb Grn 1,520 0 0
  Andress Una 763 0 0
  Amondson CnP 363 0 0
  Van Auken SEP 321 0 0
  Harris SWP 235 0 0
  Brown Soc 201 0 0
  Dodge Pro 137 0 0

 

Connecticut   Electoral College Total: 7   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
  Bush Rep 686,923 44 0
Kerry Dem 847,666 54 7
  Nader PEC 12,708 1 0
  Cobb Grn 9,449 1 0
  Badnarik Lib 3,252 0 0
  Peroutka CC 1,505 0 0

 

Delaware   Electoral College Total: 3   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
  Bush Rep 171,531 46 0
Kerry Dem 199,887 53 3
  Nader Ind 2,151 1 0
  Badnarik Lib 585 0 0
  Peroutka CST 292 0 0
  Cobb Grn 250 0 0
  Brown NLP 100 0 0

 

District of Columbia   Electoral College Total: 3   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
  Bush Rep 19,007 9 0
Kerry Dem 183,876 90 3
  Nader Ind 1,318 1 0
  Cobb DCG 645 0 0
  Badnarik Lib 442 0 0
  Harris SWP 112 0 0

 

Florida   Electoral College Total: 27   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 3,955,656 52 27
  Kerry Dem 3,574,509 47 0
  Nader RP 32,890 0 0
  Badnarik Lib 11,979 0 0
  Peroutka CST 6,609 0 0
  Cobb Grn 3,907 0 0
  Brown Soc 3,501 0 0
  Harris SWP 2,732 0 0

 

Georgia   Electoral College Total: 15   Precincts Reporting: 99%
  Name Party Vote Percent Electoral
Bush Rep 1,889,832 58 15
  Kerry Dem 1,345,198 41 0
  Badnarik Lib 18,165 1 0

 

Hawaii   Electoral College Total: 4   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
  Bush Rep 194,109 45 0
Kerry Dem 231,318 54 4
  Cobb Grn 1,730 0 0
  Badnarik Lib 1,374 0 0

 

Idaho   Electoral College Total: 4   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 408,254 68 4
  Kerry Dem 180,920 30 0
  Badnarik Lib 3,836 1 0
  Peroutka CST 3,075 1 0

 

Illinois   Electoral College Total: 21   Precincts Reporting: 99%
  Name Party Vote Percent Electoral
  Bush Rep 2,313,415 45 0
Kerry Dem 2,826,757 55 21
  Badnarik Lib 31,863 1 0

 

Indiana   Electoral College Total: 11   Precincts Reporting: 99%
  Name Party Vote Percent Electoral
Bush Rep 1,474,475 60 11
  Kerry Dem 960,899 39 0
  Badnarik Lib 18,617 1 0

 

Iowa   Electoral College Total: 7   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 746,600 50 7
  Kerry Dem 733,102 49 0
  Nader PEC 5,842 0 0
  Badnarik Lib 2,909 0 0
  Peroutka CST 1,335 0 0
  Cobb Grn 1,123 0 0
  Harris SWP 370 0 0
  Van Auken PEC 159 0 0

 

Kansas   Electoral College Total: 6   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 717,507 62 6
  Kerry Dem 420,846 36 0
  Nader RP 9,046 1 0
  Badnarik Lib 3,875 0 0
  Peroutka Ind 2,805 0 0

 

Kentucky   Electoral College Total: 8   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 1,069,403 60 8
  Kerry Dem 712,761 40 0
  Nader Ind 8,859 0 0
  Badnarik Lib 2,630 0 0
  Peroutka CST 2,212 0 0

 

Louisiana   Electoral College Total: 9   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 1,101,296 57 9
  Kerry Dem 818,207 42 0
  Nader TBL 7,014 0 0
  Peroutka CST 5,238 0 0
  Badnarik Lib 2,824 0 0
  Brown PWF 1,790 0 0
  Amondson Pro 1,565 0 0
  Cobb Grn 1,275 0 0
  Harris SWP 976 0 0

 

Maine   Electoral College Total: 4   Precincts Reporting: 99%
  Name Party Vote Percent Electoral
  Bush Rep 330,374 45 0
Kerry Dem 395,391 53 4
  Nader TBL 7,995 1 0
  Cobb Grn 2,941 0 0
  Badnarik Lib 1,961 0 0
  Peroutka CST 1,292 0 0

 

Maryland   Electoral College Total: 10   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
  Bush Rep 951,892 43 0
Kerry Dem 1,223,813 56 10
  Nader Pop 10,772 0 0
  Badnarik Lib 5,630 0 0
  Cobb Grn 3,290 0 0
  Peroutka CST 3,162 0 0

 

Massachusetts   Electoral College Total: 12   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
  Bush Rep 1,067,163 37 0
Kerry Dem 1,793,916 62 12
  Badnarik Lib 15,721 1 0
  Cobb Grn 11,283 0 0

 

Michigan   Electoral College Total: 17   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
  Bush Rep 2,306,331 48 0
Kerry Dem 2,472,007 51 17
  Nader Ind 23,914 0 0
  Badnarik Lib 10,536 0 0
  Cobb Grn 5,305 0 0
  Peroutka UST 4,962 0 0
  Brown NLP 1,446 0 0

 

Minnesota   Electoral College Total: 10   Precincts Reporting: 99%
  Name Party Vote Percent Electoral
  Bush Rep 1,345,168 48 0
Kerry Dem 1,443,564 51 10
  Nader TBL 18,537 1 0
  Cobb Grn 4,808 0 0
  Badnarik Lib 4,599 0 0
  Peroutka CST 3,121 0 0
  Harens Oth 2,395 0 0
  Van Auken SEP 537 0 0
  Calero SWP 426 0 0

 

Mississippi   Electoral College Total: 6   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 671,027 60 6
  Kerry Dem 445,596 40 0
  Nader RP 3,064 0 0
  Badnarik Lib 1,709 0 0
  Peroutka CST 1,592 0 0
  Harris Ind 1,214 0 0
  Cobb Grn 1,037 0 0

 

Missouri   Electoral College Total: 11   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 1,452,715 53 11
  Kerry Dem 1,253,879 46 0
  Badnarik Lib 9,792 0 0
  Peroutka CST 5,344 0 0

 

Montana   Electoral College Total: 3   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 265,473 59 3
  Kerry Dem 173,363 39 0
  Nader Ind 6,143 1 0
  Peroutka CST 1,762 0 0
  Badnarik Lib 1,726 0 0
  Cobb Grn 999 0 0

 

Nebraska   Electoral College Total: 5   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 485,766 67 5
  Kerry Dem 234,236 32 0
  Nader PEC 5,292 1 0
  Badnarik Lib 1,905 0 0
  Peroutka Neb 1,242 0 0
  Cobb Grn 878 0 0
  Calero PEC 73 0 0

 

Nevada   Electoral College Total: 5   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 414,939 50 5
  Kerry Dem 393,372 48 0
  Nader Ind 4,785 1 0
  None of These Candidates Una 3,646 0 0
  Badnarik Lib 3,149 0 0
  Peroutka IAP 1,138 0 0
  Cobb Grn 837 0 0

 

New Hampshire   Electoral College Total: 4   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
  Bush Rep 330,848 49 0
Kerry Dem 340,019 50 4
  Nader Ind 4,447 1 0

 

New Jersey   Electoral College Total: 15   Precincts Reporting: 99%
  Name Party Vote Percent Electoral
  Bush Rep 1,587,494 46 0
Kerry Dem 1,799,320 53 15
  Nader Ind 18,614 1 0
  Badnarik Ind 4,310 0 0
  Peroutka Ind 2,904 0 0
  Cobb Ind 1,707 0 0
  Van Auken Ind 972 0 0
  Brown Ind 665 0 0
  Calero Ind 500 0 0

 

New Mexico   Electoral College Total: 5   Precincts Reporting: 99%
  Name Party Vote Percent Electoral
Bush Rep 372,215 50 5
  Kerry Dem 363,627 49 0
  Nader Ind 3,999 1 0
  Badnarik Lib 2,345 0 0
  Cobb Grn 1,244 0 0
  Peroutka CST 817 0 0

 

New York   Electoral College Total: 31   Precincts Reporting: 99%
  Name Party Vote Percent Electoral
  Bush Rep 2,793,930 40 0
Kerry Dem 3,986,366 58 31
  Nader Inp 104,243 2 0
  Badnarik Lib 12,878 0 0
  Calero SWP 4,020 0 0

 

North Carolina   Electoral College Total: 15   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 1,910,936 56 15
  Kerry Dem 1,484,158 44 0
  Badnarik Lib 12,375 0 0

 

North Dakota   Electoral College Total: 3   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 195,998 63 3
  Kerry Dem 110,662 35 0
  Nader Ind 3,741 1 0
  Badnarik Lib 852 0 0
  Peroutka CST 515 0 0

 

Ohio   Electoral College Total: 20   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 2,796,147 51 20
  Kerry Dem 2,659,664 49 0
  Badnarik NP 14,331 0 0
  Peroutka NP 11,614 0 0

 

Oklahoma   Electoral College Total: 7   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 959,655 66 7
  Kerry Dem 504,077 34 0

 

Oregon   Electoral College Total: 7   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
  Bush Rep 823,210 48 0
Kerry Dem 890,698 51 7
  Badnarik Lib 6,824 0 0
  Cobb PAG 4,952 0 0
  Peroutka CST 4,945 0 0

 

Pennsylvania   Electoral College Total: 21   Precincts Reporting: 99%
  Name Party Vote Percent Electoral
  Bush Rep 2,756,361 49 0
Kerry Dem 2,883,833 51 21
  Badnarik Lib 20,830 0 0
  Peroutka CST 6,464 0 0
  Cobb Grn 6,234 0 0

 

Rhode Island   Electoral College Total: 4   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
  Bush Rep 161,654 39 0
Kerry Dem 247,407 60 4
  Nader RP 3,990 1 0
  Cobb Grn 1,094 0 0
  Badnarik Lib 864 0 0
  Peroutka CST 306 0 0
  Parker WW 245 0 0

 

South Carolina   Electoral College Total: 8   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 924,170 58 8
  Kerry Dem 650,350 41 0
  Nader Ind 5,431 0 0
  Peroutka CST 5,295 0 0
  Badnarik Lib 3,643 0 0
  Brown UCz 2,109 0 0
  Cobb Grn 1,401 0 0

 

South Dakota   Electoral College Total: 3   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 232,545 60 3
  Kerry Dem 149,225 38 0
  Nader Ind 4,317 1 0
  Peroutka CST 1,106 0 0
  Badnarik Lib 964 0 0

 

Tennessee   Electoral College Total: 11   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 1,381,937 57 11
  Kerry Dem 1,033,176 42 0
  Nader Ind 8,832 0 0
  Badnarik Ind 4,823 0 0
  Peroutka Ind 2,523 0 0

 

Texas   Electoral College Total: 34   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 4,519,023 61 34
  Kerry Dem 2,827,756 38 0
  Badnarik Lib 38,723 1 0

 

Utah   Electoral College Total: 5   Precincts Reporting: 99%
  Name Party Vote Percent Electoral
Bush Rep 612,623 71 5
  Kerry Dem 227,286 26 0
  Nader Una 10,840 1 0
  Peroutka CST 6,524 1 0
  Badnarik Lib 3,204 0 0
  Jay PCH 880 0 0
  Harris SWP 375 0 0

 

Vermont   Electoral College Total: 3   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
  Bush Rep 120,710 39 0
Kerry Dem 183,621 59 3
  Nader Ind 4,426 1 0
  Badnarik Lib 1,219 0 0
  Calero SWP 268 0 0
  Parker LUn 255 0 0

 

Virginia   Electoral College Total: 13   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 1,667,198 54 13
  Kerry Dem 1,400,254 45 0
  Badnarik Lib 11,805 0 0
  Peroutka CST 8,740 0 0

 

Washington   Electoral Collge Total: 11   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
  Bush Rep 1,130,537 46 0
Kerry Dem 1,305,868 53 11
  Nader Ind 19,188 1 0
  Badnarik Lib 10,032 0 0
  Peroutka CST 3,199 0 0
  Cobb Grn 2,364 0 0
  Parker WW 886 0 0
  Harris SWP 465 0 0
  Van Auken SEP 190 0 0

 

West Virginia   Electoral College Total: 5   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 418,151 56 5
  Kerry Dem 321,641 43 0
  Nader Ind 3,951 1 0
  Badnarik Lib 1,351 0 0

 

Wisconsin   Electoral College Total: 10   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
  Bush Rep 1,477,122 49 0
Kerry Dem 1,488,935 50 10
  Nader Ind 16,324 1 0
  Badnarik Lib 6,456 0 0
  Cobb Grn 2,674 0 0
  Brown Ind 465 0 0
  Harris Ind 414 0 0

 

Wyoming   Electoral College Total: 3   Precincts Reporting: 100%
  Name Party Vote Percent Electoral
Bush Rep 167,129 69 3
  Kerry Dem 70,620 29 0
  Nader Ind 2,734 1 0
  Badnarik Lib 1,193 0 0
  Peroutka Ind 633 0 0

Assessment- 20 Points