Open Data: A case study using IPEDS for online education

At e-Literate we’re planning to do more data journalism posts. Think of this along the lines of Harper Reed’s keynote last year as described in the Chronicle.

Harper Reed, who served as chief technology officer in President Obama’s 2012 campaign, offered those people what he jokingly called “an intervention.”

“Big Data is bullshit,” Mr. Reed said in a keynote speech on Tuesday.

His point is not that there is no value in the large amounts of data available to the community, but that data analysis is getting democratized and doesn’t require huge investments.

“The exciting thing is you can get a lot of this stuff done just in Excel,” he said. “You don’t need these big platforms. You don’t need all this big fancy stuff. If anyone says ‘big’ in front of it, you should look at them very skeptically … You can tell charlatans when they say ‘big’ in front of everything.”

I would add one other aspect along with the democratization of data analysis – open data. Inspired by Audrey Watters and even her recent tweet, we are looking for ways to not only explore the open data available to the education community but also to share the data we use in our analyses.

I’m currently working on a blog post on the new University of Florida Online (UF Online) program that starts this spring. In preparation for this post I wanted to explore the current state of exclusively online education (where students take all their courses online) for public 4-year institutions based on the new data from IPEDS. This data gives an opportunity to look at one example of exploring and sharing open data.

Basic Institutional Data for Public 4-year Institutions from IPEDS

The first task is to narrow down the IPEDS distance education data (which is roughly equivalent to online courses, which just a few exceptions) to just the public 4-year institutions in the US. What I did was the following:

  • Go to the IPEDS Data Center and selected the ‘Compare Individual Institutions’ option.
  • Once there I used ‘Provisional Release Data’ and filtered the institutions By Groups.
    • For the groups, I selected ‘First Look Universe’ and ‘US Only’; and
    • Under ‘Sector’ I selected ‘Public, 4-year or above’.
  • This led to 690 institutions.
  • For the variables to download, I selected ‘Fall Enrollment’ > ‘Distance education’ and then selected ‘Fall 2012′ and ‘Degree/certificate-seeking total’.
  • Under this option I selected the following variables:

IPEDS_Data_Center

I then downloaded a CSV file and cleaned up the data by replacing blanks with zeros.

The next challenge is to display on WordPress allowing user access to the data. For this I chose two methods:

  • Upload to Google GDrive for direct sharing or download of the spreadsheet data; and
  • Use TablePress plugin to display tables in an interactive format.

The TablePress plugin required the DataTables Sorting plugin Extension to allow it to handle a , thousands separator. Here is the result of the institutional data analysis:

Listing of US public 4-year institutions and summary of Fall 2012 online education enrollment, from IPEDS
Institution
State
Exclusively Online Students
Students w some but not all online
Students w no online
All Students
TOTALS 323,687 1,069,072 4,924,789 6,317,548
University of Alaska AnchorageAK 1,026 2,956 9,218 13,200
University of Alaska FairbanksAK823 1,202 3,731 5,756
University of Alaska SoutheastAK575314647 1,536
Troy UniversityAL 2,498 9,553 5,714 17,765
The University of AlabamaAL 1,213 4,138 22,013 27,364
Athens State UniversityAL 1,152 2,001 97 3,250
Jacksonville State UniversityAL977 6,677 - 7,654
University of Alabama at BirminghamAL748 3,505 6,761 11,014
University of North AlabamaAL339 1,631 3,753 5,723
University of South AlabamaAL284 2,451 8,319 11,054
University of West AlabamaAL22123 1,845 2,089
Auburn University at MontgomeryAL151841 3,127 4,119
University of Alabama in HuntsvilleAL42132 5,529 5,703
Auburn UniversityAL29 1,117 19,029 20,175
Alabama A & M UniversityAL-221 3,860 4,081
Alabama State UniversityAL- 1,620 3,503 5,123
University of MontevalloAL-88 2,500 2,588
University of Arkansas at Little RockAR 1,442 2,701 4,711 8,854
Arkansas Tech UniversityAR 1,223 2,322 5,098 8,643
University of Arkansas-Fort SmithAR246 1,315 5,116 6,677
University of Arkansas for Medical SciencesAR221175384780
University of ArkansasAR214 2,507 17,257 19,978
University of Arkansas at MonticelloAR98811 2,277 3,186
Southern Arkansas University Main CampusAR80731 1,789 2,600
University of Central ArkansasAR68935 8,025 9,028
University of Arkansas at Pine BluffAR62670 1,975 2,707
Arkansas State University-Main CampusAR58 3,346 6,092 9,496
Henderson State UniversityAR53 1,070 2,231 3,354
Arizona State UniversityAZ 4,992 27,259 26,932 59,183
Northern Arizona UniversityAZ 4,697 4,677 12,253 21,627
University of ArizonaAZ278 8,846 22,093 31,217
Dine CollegeAZ117 1,176 614 1,907
California State University-East BayCA627 3,621 7,258 11,506
California State University-FullertonCA346 6,941 24,991 32,278
California State University-ChicoCA164 4,159 10,833 15,156
California State University-FresnoCA40 2,602 16,729 19,371
San Diego State University-Imperial Valley CampusCA188583672
California Maritime AcademyCA--971971
California Polytechnic State University-San Luis ObispoCA-- 17,599 17,599
California State Polytechnic University-PomonaCA- 2,995 17,466 20,461
California State University-BakersfieldCA- 2,891 4,329 7,220
California State University-Channel IslandsCA-590 4,136 4,726
California State University-Dominguez HillsCA- 3,434 7,507 10,941
California State University-Long BeachCA-- 30,918 30,918
California State University-Los AngelesCA-635 17,420 18,055
California State University-Monterey BayCA-531 4,577 5,108
California State University-NorthridgeCA- 6,120 25,117 31,237
California State University-SacramentoCA- 4,759 20,781 25,540
California State University-San BernardinoCA- 2,176 13,601 15,777
California State University-San MarcosCA- 1,470 8,415 9,885
California State University-StanislausCA- 1,894 5,725 7,619
Humboldt State UniversityCA- 1,872 5,708 7,580
San Diego State UniversityCA- 4,553 21,193 25,746
San Francisco State UniversityCA- 6,092 19,701 25,793
San Jose State UniversityCA- 2,699 22,347 25,046
Sonoma State UniversityCA-75 8,009 8,084
University of California Hastings College of LawCA----
University of California-BerkeleyCA-137 25,637 25,774
University of California-DavisCA-- 25,588 25,588
University of California-IrvineCA-765 21,445 22,210
University of California-Los AngelesCA-215 27,726 27,941
University of California-MercedCA-- 5,431 5,431
University of California-RiversideCA-56 18,481 18,537
University of California-San DiegoCA-- 22,650 22,650
University of California-San FranciscoCA----
University of California-Santa BarbaraCA-101 18,873 18,974
University of California-Santa CruzCA-14 15,964 15,978
Colorado State University-Global CampusCO 3,686 -- 3,686
Metropolitan State University of DenverCO 1,208 5,103 16,062 22,373
University of Colorado DenverCO485 2,319 7,754 10,558
Colorado Mesa UniversityCO397 1,505 6,603 8,505
Adams State UniversityCO350146 1,886 2,382
Colorado Mountain CollegeCO343580 2,544 3,467
University of Northern ColoradoCO252 1,808 7,874 9,934
University of Colorado BoulderCO164822 24,231 25,217
University of Colorado Colorado SpringsCO135 1,094 6,889 8,118
Colorado State University-Fort CollinsCO121856 21,447 22,424
Colorado State University-PuebloCO2124 4,485 4,611
Western State Colorado UniversityCO177 1,869 1,947
Colorado School of MinesCO-35 4,027 4,062
Fort Lewis CollegeCO-- 3,719 3,719
United States Air Force AcademyCO-- 4,120 4,120
Charter Oak State CollegeCT 1,465 75 1,477
University of ConnecticutCT38 1,328 15,804 17,170
Southern Connecticut State UniversityCT35804 7,686 8,525
Eastern Connecticut State UniversityCT30488 4,472 4,990
University of Connecticut-Tri-CampusCT30188 2,275 2,493
University of Connecticut-Avery PointCT2048666734
Western Connecticut State UniversityCT16410 4,852 5,278
University of Connecticut-StamfordCT8106 1,114 1,228
Central Connecticut State UniversityCT5192 9,433 9,630
United States Coast Guard AcademyCT--967967
University of the District of ColumbiaDC-132 4,581 4,713
University of the District of Columbia David A Clarke School of LawDC----
University of DelawareDE171950 16,363 17,484
Delaware State UniversityDE3160 3,473 3,636
St Petersburg CollegeFL 8,243 6,801 12,530 27,574
Florida State College at JacksonvilleFL 4,105 6,231 16,298 26,634
University of Central FloridaFL 3,901 15,030 31,690 50,621
Valencia CollegeFL 3,111 8,837 23,780 35,728
Miami Dade CollegeFL 2,806 5,663 53,581 62,050
Florida International UniversityFL 2,473 15,890 17,881 36,244
Daytona State CollegeFL 2,188 3,627 7,575 13,390
Broward CollegeFL 2,094 5,821 29,707 37,622
University of South Florida-Main CampusFL 2,011 11,175 17,282 30,468
Palm Beach State CollegeFL 1,766 3,775 20,979 26,520
Seminole State College of FloridaFL 1,650 3,897 12,263 17,810
Santa Fe CollegeFL 1,589 2,933 9,571 14,093
Indian River State CollegeFL 1,429 3,379 9,530 14,338
The University of West FloridaFL 1,295 2,919 5,735 9,949
Edison State CollegeFL 1,121 2,538 9,474 13,133
State College of Florida-Manatee-SarasotaFL 1,067 2,553 6,099 9,719
University of FloridaFL 1,005 15,597 15,421 32,023
Polk State CollegeFL911 2,260 6,242 9,413
Florida Atlantic UniversityFL750 3,048 20,258 24,056
Pensacola State CollegeFL748 1,977 6,777 9,502
College of Central FloridaFL644 2,669 4,106 7,419
Saint Johns River State CollegeFL621 1,234 3,392 5,247
Florida State UniversityFL435 5,293 25,924 31,652
Northwest Florida State CollegeFL434 1,629 3,749 5,812
University of South Florida Sarasota-ManateeFL426752535 1,713
Gulf Coast State CollegeFL424852 2,135 3,411
Florida Gulf Coast UniversityFL395 4,366 7,325 12,086
Florida Gateway CollegeFL319713 1,122 2,154
University of South Florida-St. Petersburg CampusFL253 1,976 1,777 4,006
University of North FloridaFL225 2,796 11,103 14,124
Lake-Sumter Community CollegeFL156626 2,925 3,707
South Florida State CollegeFL84398 1,591 2,073
Chipola CollegeFL67397 1,268 1,732
Florida Agricultural and Mechanical UniversityFL-56 9,885 9,941
New College of FloridaFL--832832
Kennesaw State UniversityGA680 3,690 18,018 22,388
Georgia Southwestern State UniversityGA611794 1,289 2,694
Georgia Southern UniversityGA586 3,061 13,492 17,139
University of West GeorgiaGA530 3,471 5,785 9,786
Clayton State UniversityGA487 2,429 3,592 6,508
Columbus State UniversityGA435 4,958 1,522 6,915
Macon State CollegeGA347 1,509 3,682 5,538
Middle Georgia CollegeGA335990 1,573 2,898
Southern Polytechnic State UniversityGA318 1,083 3,923 5,324
Valdosta State UniversityGA265 1,238 8,700 10,203
Albany State UniversityGA253947 2,555 3,755
Atlanta Metropolitan State CollegeGA234800 1,770 2,804
Armstrong Atlantic State UniversityGA208 1,188 5,154 6,550
Fort Valley State UniversityGA148343 2,741 3,232
Georgia State UniversityGA131 2,670 21,156 23,957
East Georgia State CollegeGA130711 2,063 2,904
Gainesville State CollegeGA118692 7,515 8,325
Dalton State CollegeGA80920 3,934 4,934
Georgia Health Sciences UniversityGA7965268412
Gordon State CollegeGA43390 3,648 4,081
College of Coastal GeorgiaGA30397 2,568 2,995
University of GeorgiaGA27172 25,861 26,060
South Georgia CollegeGA13418 1,738 2,169
Augusta State UniversityGA11605 5,004 5,620
Abraham Baldwin Agricultural CollegeGA-267 2,751 3,018
Georgia College & State UniversityGA-343 5,144 5,487
Georgia Gwinnett CollegeGA-- 9,045 9,045
Georgia Institute of Technology-Main CampusGA-- 13,954 13,954
North Georgia College & State UniversityGA- 1,026 4,802 5,828
Savannah State UniversityGA-491 3,762 4,253
University of Hawaii-West OahuHI480710760 1,950
University of Hawaii Maui CollegeHI247864 2,751 3,862
University of Hawaii at ManoaHI234 1,275 12,770 14,279
University of Hawaii at HiloHI141628 2,635 3,404
University of IowaIA512 2,743 18,065 21,320
Iowa State UniversityIA126 2,505 22,427 25,058
University of Northern IowaIA52 1,670 8,791 10,513
Boise State UniversityID859 3,527 12,523 16,909
Idaho State UniversityID623 3,894 5,469 9,986
Lewis-Clark State CollegeID467 1,382 1,489 3,338
University of IdahoID262 2,039 6,484 8,785
University of Illinois at SpringfieldIL828880 1,268 2,976
Western Illinois UniversityIL470 1,281 8,512 10,263
Eastern Illinois UniversityIL422798 7,641 8,861
Governors State UniversityIL344 1,005 1,782 3,131
University of Illinois at ChicagoIL197 3,551 12,845 16,593
Chicago State UniversityIL191997 3,405 4,593
Northern Illinois UniversityIL119 1,309 15,094 16,522
Southern Illinois University EdwardsvilleIL82440 10,768 11,290
Illinois State UniversityIL72 1,427 16,680 18,179
Northeastern Illinois UniversityIL64610 8,357 9,031
University of Illinois at Urbana-ChampaignIL52 6,620 24,588 31,260
Southern Illinois University CarbondaleIL- 1,305 12,772 14,077
Indiana University-Purdue University-IndianapolisIN 1,353 6,474 13,552 21,379
Purdue University-Calumet CampusIN 1,349 1,679 4,989 8,017
Vincennes UniversityIN 1,002 1,203 5,993 8,198
Indiana State UniversityIN927 1,656 7,233 9,816
Indiana University-EastIN834 1,028 1,124 2,986
University of Southern IndianaIN653 2,130 6,539 9,322
Indiana University-Purdue University-Fort WayneIN607 2,759 7,235 10,601
Ball State UniversityIN375 3,437 12,732 16,544
Purdue University-Main CampusIN304 3,404 27,347 31,055
Purdue University-North Central CampusIN123 1,065 2,304 3,492
Indiana University-NorthwestIN110903 3,804 4,817
Indiana University-KokomoIN94771 1,789 2,654
Indiana University-South BendIN92 1,274 4,579 5,945
Indiana University-SoutheastIN81440 5,225 5,746
Indiana University-BloomingtonIN33 1,347 30,547 31,927
Fort Hays State UniversityKS 6,942 1,094 3,039 11,075
Kansas State UniversityKS 2,000 1 17,375 19,376
Washburn UniversityKS478 1,380 3,768 5,626
Wichita State UniversityKS231 8,336 2,576 11,143
Emporia State UniversityKS229315 3,110 3,654
University of KansasKS142 1,072 17,598 18,812
Pittsburg State UniversityKS52706 5,221 5,979
Haskell Indian Nations UniversityKS--839839
Eastern Kentucky UniversityKY 1,371 3,578 8,490 13,439
Western Kentucky UniversityKY 1,245 4,171 10,935 16,351
Morehead State UniversityKY 1,001 2,524 3,627 7,152
Northern Kentucky UniversityKY841 3,154 8,230 12,225
University of LouisvilleKY688 1,548 12,618 14,854
Murray State UniversityKY516 1,136 6,197 7,849
Kentucky State UniversityKY111660 1,313 2,084
University of KentuckyKY76 2,451 17,909 20,436
Northwestern State University of LouisianaLA 1,999 2,609 2,975 7,583
University of Louisiana-MonroeLA597 2,082 3,250 5,929
Southern University and A & M CollegeLA544136 4,491 5,171
McNeese State UniversityLA307 2,127 4,632 7,066
Southeastern Louisiana UniversityLA274 3,585 8,429 12,288
University of Louisiana at LafayetteLA214 1,688 12,488 14,390
Southern University at New OrleansLA155855 1,114 2,124
University of New OrleansLA151 1,861 5,352 7,364
Nicholls State UniversityLA126 1,927 3,732 5,785
Louisiana Tech UniversityLA106215 6,669 6,990
Louisiana State University-AlexandriaLA86652 1,302 2,040
Louisiana State University-ShreveportLA71803 2,075 2,949
Louisiana State University and Agricultural & Mechanical CollegeLA14 1,204 22,654 23,872
Grambling State UniversityLA-620 3,729 4,349
Louisiana State University Health Sciences Center-New OrleansLA--902902
Louisiana State University Health Sciences Center-ShreveportLA--5050
Southern University Law CenterLA----
University of Massachusetts-LowellMA 1,725 999 8,746 11,470
University of Massachusetts-BostonMA755915 9,787 11,457
University of Massachusetts AmherstMA727 2,972 17,749 21,448
University of Massachusetts-DartmouthMA210169 6,947 7,326
Westfield State UniversityMA198 1,302 3,691 5,191
Fitchburg State UniversityMA115636 3,314 4,065
Salem State UniversityMA114 1,361 5,668 7,143
Worcester State UniversityMA83934 3,791 4,808
Framingham State UniversityMA82268 3,797 4,147
Bridgewater State UniversityMA67 1,616 7,868 9,551
Massachusetts College of Liberal ArtsMA27124 1,402 1,553
Massachusetts College of Art and DesignMA-17 1,807 1,824
Massachusetts Maritime AcademyMA-- 1,303 1,303
University of Massachusetts Medical School WorcesterMA----
University of Maryland-University CollegeMD 22,611 4,850 1 27,462
University of BaltimoreMD143960 2,296 3,399
Frostburg State UniversityMD112369 4,041 4,522
Towson UniversityMD70 1,607 16,008 17,685
University of Maryland-BaltimoreMD69217436722
University of Maryland Eastern ShoreMD29766 2,886 3,681
Coppin State UniversityMD24872 2,159 3,055
Bowie State UniversityMD18 1,261 2,968 4,247
Morgan State UniversityMD1029 6,528 6,567
University of Maryland-Baltimore CountyMD5376 10,457 10,838
Salisbury UniversityMD4533 7,177 7,714
University of Maryland-College ParkMD3570 25,258 25,831
St Mary's College of MarylandMD-- 1,863 1,863
United States Naval AcademyMD-- 4,536 4,536
University of Maine at AugustaME 1,457 1,407 1,659 4,523
University of Southern MaineME267 1,531 4,684 6,482
University of Maine at Fort KentME175304356835
University of Maine at Presque IsleME121534367 1,022
University of Maine at MachiasME102268257627
University of MaineME95 1,768 6,365 8,228
University of Maine at FarmingtonME323 1,946 1,972
Maine Maritime AcademyME--968968
Central Michigan UniversityMI 1,712 1,230 17,906 20,848
Ferris State UniversityMI974 1,871 9,855 12,700
University of Michigan-FlintMI826 2,528 3,323 6,677
Eastern Michigan UniversityMI686 3,118 14,579 18,383
Oakland UniversityMI539 2,275 12,913 15,727
Western Michigan UniversityMI474 2,562 16,008 19,044
Wayne State UniversityMI279 3,203 15,049 18,531
Michigan State UniversityMI178 5,642 31,156 36,976
Northern Michigan UniversityMI122 1,042 7,035 8,199
University of Michigan-DearbornMI52768 6,163 6,983
Lake Superior State UniversityMI2589 2,310 2,424
Grand Valley State UniversityMI20405 20,802 21,227
Saginaw Valley State UniversityMI18344 8,463 8,825
University of Michigan-Ann ArborMI16117 27,664 27,797
Michigan Technological UniversityMI12115 5,405 5,532
Metropolitan State UniversityMN881 1,811 4,589 7,281
University of Minnesota-CrookstonMN696238868 1,802
Bemidji State UniversityMN636703 3,038 4,377
Saint Cloud State UniversityMN423 2,789 9,064 12,276
Minnesota State University-MankatoMN419 2,371 9,756 12,546
Minnesota State University MoorheadMN329 2,191 3,550 6,070
Southwest Minnesota State UniversityMN254407 1,855 2,516
University of Minnesota-Twin CitiesMN164 7,327 22,884 30,375
Winona State UniversityMN65859 7,291 8,215
University of Minnesota-DuluthMN58 1,145 8,249 9,452
University of Minnesota-MorrisMN38 1,777 1,788
University of Minnesota-RochesterMN-22363385
Missouri Southern State UniversityMO709 1,349 2,918 4,976
University of Missouri-St LouisMO522 3,106 5,353 8,981
University of Missouri-Kansas CityMO480 1,746 6,221 8,447
Southeast Missouri State UniversityMO446 2,591 6,462 9,499
University of Missouri-ColumbiaMO442 5,862 20,285 26,589
University of Central MissouriMO378 2,818 5,849 9,045
Missouri State University-SpringfieldMO239 2,547 12,557 15,343
Missouri Western State UniversityMO185 1,442 3,528 5,155
Northwest Missouri State UniversityMO158777 4,713 5,648
Lincoln UniversityMO77422 1,895 2,394
Missouri University of Science and TechnologyMO31 1,071 4,650 5,752
Harris-Stowe State UniversityMO28395 1,031 1,454
Truman Medical Center School of Nurse AnesthesiaMO----
Truman State UniversityMO-407 5,045 5,452
Mississippi State UniversityMS770 1,156 14,464 16,390
Mississippi University for WomenMS752779788 2,319
University of Southern MississippiMS489 2,791 9,851 13,131
University of Mississippi Medical CenterMS264-357621
Jackson State UniversityMS249 1,839 4,587 6,675
Delta State UniversityMS21039 2,430 2,679
Alcorn State UniversityMS123 1,182 1,903 3,208
University of MississippiMS111 1,082 14,598 15,791
Mississippi Valley State UniversityMS-10 2,006 2,016
Montana State University BillingsMT728 1,266 2,360 4,354
The University of MontanaMT321 1,937 9,879 12,137
Montana State University-NorthernMT149423620 1,192
Montana State UniversityMT89 1,172 11,272 12,533
The University of Montana-WesternMT21- 1,446 1,467
Montana Tech of the University of MontanaMT19206 1,610 1,835
East Carolina UniversityNC 1,766 3,949 14,731 20,446
Western Carolina UniversityNC856607 6,333 7,796
Fayetteville State UniversityNC690 1,038 3,284 5,012
University of North Carolina at GreensboroNC675 3,275 10,644 14,594
University of North Carolina at PembrokeNC488 1,399 3,423 5,310
North Carolina State University at RaleighNC438 7,151 15,702 23,291
University of North Carolina at CharlotteNC394 2,278 18,413 21,085
Winston-Salem State UniversityNC334 1,327 3,522 5,183
University of North Carolina WilmingtonNC315 2,001 9,744 12,060
North Carolina Central UniversityNC309 1,459 4,508 6,276
North Carolina A & T State UniversityNC233 1,394 6,999 8,626
Elizabeth City State UniversityNC95996 1,601 2,692
University of North Carolina at Chapel HillNC85700 17,133 17,918
Appalachian State UniversityNC71700 14,756 15,527
University of North Carolina at AshevilleNC-- 3,259 3,259
University of North Carolina School of the ArtsNC--752752
University of North DakotaND 1,223 1,357 8,892 11,472
Bismarck State CollegeND 1,087 710 1,478 3,275
Minot State UniversityND532490 1,755 2,777
Dickinson State UniversityND423196930 1,549
North Dakota State University-Main CampusND334 2,834 8,516 11,684
Valley City State UniversityND209488260957
Mayville State UniversityND162102511775
Fort Berthold Community CollegeND159134194
Sitting Bull CollegeND-56213269
Chadron State CollegeNE599894619 2,112
Peru State CollegeNE555488467 1,510
University of Nebraska at OmahaNE458 2,960 8,453 11,871
University of Nebraska at KearneyNE172 1,037 4,175 5,384
University of Nebraska Medical CenterNE108291423822
University of Nebraska-LincolnNE85 3,845 15,173 19,103
Wayne State CollegeNE32499 2,436 2,967
Granite State CollegeNH938238468 1,644
Plymouth State UniversityNH75711 3,341 4,127
University of New Hampshire-Main CampusNH6164 12,395 12,565
Keene State CollegeNH-234 4,546 4,780
University of New Hampshire at ManchesterNH--776776
Thomas Edison State CollegeNJ 19,256 -150 19,406
University of Medicine and Dentistry of New JerseyNJ20249723974
New Jersey City UniversityNJ124 2,673 3,753 6,550
William Paterson University of New JerseyNJ108 1,972 7,893 9,973
Rowan UniversityNJ97355 10,081 10,533
Rutgers University-New BrunswickNJ87 3,149 27,990 31,226
The Richard Stockton College of New JerseyNJ86 2,229 5,021 7,336
Ramapo College of New JerseyNJ65331 4,994 5,390
Rutgers University-CamdenNJ57638 3,961 4,656
Kean UniversityNJ47 1,124 11,372 12,543
Rutgers University-NewarkNJ47428 6,766 7,241
New Jersey Institute of TechnologyNJ34948 5,172 6,154
Montclair State UniversityNJ- 1,629 12,593 14,222
The College of New JerseyNJ-- 6,381 6,381
New Mexico State University-Main CampusNM 1,188 4,113 8,098 13,399
Eastern New Mexico University-Main CampusNM 1,138 1,113 1,667 3,918
University of New Mexico-Main CampusNM 1,061 4,535 15,415 21,011
Western New Mexico UniversityNM346438 1,357 2,141
New Mexico Highlands UniversityNM142353 1,794 2,289
Northern New Mexico CollegeNM75368924 1,367
Institute of American Indian and Alaska Native CultureNM668167241
Navajo Technical CollegeNM-330 1,253 1,583
New Mexico Institute of Mining and TechnologyNM-5 1,420 1,425
College of Southern NevadaNV 4,584 7,283 18,920 30,787
University of Nevada-Las VegasNV 1,026 6,284 14,725 22,035
Great Basin CollegeNV950788743 2,481
Nevada State CollegeNV640 1,326 994 2,960
Western Nevada CollegeNV396766 2,401 3,563
University of Nevada-RenoNV201 2,005 12,469 14,675
SUNY Empire State CollegeNY 4,656 1,245 4,134 10,035
CUNY John Jay College of Criminal JusticeNY 1,213 446 11,175 12,834
CUNY Graduate School and University CenterNY950-127 1,077
SUNY College of Technology at CantonNY764 1,349 1,515 3,628
SUNY College of Technology at DelhiNY578424 2,114 3,116
CUNY Brooklyn CollegeNY434 2,612 9,079 12,125
CUNY New York City College of TechnologyNY369 2,100 12,834 15,303
SUNY College of Technology at AlfredNY298329 2,834 3,461
CUNY Medgar Evers CollegeNY283535 5,401 6,219
CUNY College of Staten IslandNY260834 11,883 12,977
CUNY Bernard M Baruch CollegeNY255 1,434 11,895 13,584
CUNY Queens CollegeNY167957 14,133 15,257
Stony Brook UniversityNY157- 15,461 15,618
SUNY College at PlattsburghNY150 1,091 4,382 5,623
CUNY York CollegeNY144 1,077 6,377 7,598
SUNY College at OswegoNY130611 6,373 7,114
CUNY City CollegeNY126380 11,666 12,172
CUNY Hunter CollegeNY114193 15,482 15,789
Fashion Institute of TechnologyNY110 1,394 6,508 8,012
Farmingdale State CollegeNY101 1,050 6,106 7,257
SUNY Institute of Technology at Utica-RomeNY89417 1,049 1,555
SUNY at BinghamtonNY24362 11,910 12,296
SUNY College at BrockportNY21 6,199 825 7,045
SUNY at AlbanyNY15212 12,408 12,635
Morrisville State CollegeNY8519 2,377 2,904
SUNY College at PotsdamNY8734 3,108 3,850
SUNY College at CortlandNY5213 6,110 6,328
State University of New York at New PaltzNY478 6,357 6,439
SUNY College at Old WestburyNY2167 3,908 4,077
SUNY Maritime CollegeNY2285 1,291 1,578
Upstate Medical UniversityNY2176117295
Buffalo State SUNYNY-- 9,561 9,561
CUNY Lehman CollegeNY- 2,759 6,094 8,853
CUNY School of Law at Queens CollegeNY----
SUNY at FredoniaNY-460 4,711 5,171
SUNY at Purchase CollegeNY-- 3,900 3,900
SUNY College at GeneseoNY-- 5,339 5,339
SUNY College at OneontaNY-- 5,804 5,804
SUNY College of Agriculture and Technology at CobleskillNY-93 2,356 2,449
SUNY College of Environmental Science and ForestryNY-56 1,641 1,697
SUNY College of OptometryNY----
SUNY Downstate Medical CenterNY--335335
United States Merchant Marine AcademyNY--987987
United States Military AcademyNY-- 4,592 4,592
University at BuffaloNY-669 18,425 19,094
Ohio University-Main CampusOH 5,952 2,040 14,581 22,573
University of Cincinnati-Main CampusOH 1,716 4,061 16,921 22,698
Kent State University at KentOH 1,554 6,059 13,975 21,588
Kent State University at TrumbullOH 1,002 426 1,571 2,999
University of ToledoOH998 4,510 10,626 16,134
Kent State University at GeaugaOH991325 1,035 2,351
Kent State University at AshtabulaOH563397 1,432 2,392
Kent State University at East LiverpoolOH548198589 1,335
Ohio University-Southern CampusOH474162 1,320 1,956
Ohio University-Eastern CampusOH44682468996
Ohio University-Zanesville CampusOH429228 1,224 1,881
Kent State University at TuscarawasOH405418 1,461 2,284
Kent State University at StarkOH398686 3,552 4,636
Ohio University-Lancaster CampusOH367310 1,629 2,306
Bowling Green State University-Main CampusOH314 1,030 13,170 14,514
Cleveland State UniversityOH277 2,656 8,229 11,162
Ohio University-Chillicothe CampusOH267185 1,736 2,188
Kent State University at SalemOH264193 1,242 1,699
Ohio State University-Main CampusOH255 5,946 35,676 41,877
University of Cincinnati-Clermont CollegeOH252770 2,159 3,181
Youngstown State UniversityOH208 1,030 10,971 12,209
University of Akron Main CampusOH115943 19,666 20,724
University of Cincinnati-Blue Ash CollegeOH113 1,037 3,515 4,665
Miami University-HamiltonOH104385 2,937 3,426
Miami University-MiddletownOH61278 1,439 1,778
Shawnee State UniversityOH46489 3,876 4,411
Miami University-OxfordOH28281 14,675 14,984
Ohio State University-Mansfield CampusOH998 1,048 1,155
Ohio State University-Marion CampusOH3359831 1,193
Ohio State University-Newark CampusOH3189 2,038 2,230
Central State UniversityOH-328 1,778 2,106
Northeast Ohio Medical UniversityOH----
Ohio State University-Lima CampusOH-103918 1,021
Wright State University-Lake CampusOH-448390838
Wright State University-Main CampusOH- 1,615 10,987 12,602
Oklahoma State University-Oklahoma CityOK 1,479 2,133 3,007 6,619
University of Oklahoma Norman CampusOK 1,234 3,736 15,731 20,701
Rogers State UniversityOK788 1,765 1,718 4,271
Southeastern Oklahoma State UniversityOK582 1,579 1,426 3,587
Northeastern State UniversityOK496 2,033 4,815 7,344
University of Central OklahomaOK428 2,751 11,997 15,176
Cameron UniversityOK335 1,883 3,050 5,268
Oklahoma State University-Main CampusOK306 4,245 15,552 20,103
Southwestern Oklahoma State UniversityOK285795 3,044 4,124
Northwestern Oklahoma State UniversityOK200900886 1,986
East Central UniversityOK186990 2,625 3,801
Oklahoma State University Institute of Technology-OkmulgeeOK166577 2,174 2,917
Oklahoma Panhandle State UniversityOK154391742 1,287
University of Oklahoma Health Sciences CenterOK29691151871
Langston UniversityOK6199 1,786 1,991
Oklahoma State University Center for Health SciencesOK----
University of Science and Arts of OklahomaOK--963963
Oregon State UniversityOR 2,152 2,971 15,973 21,096
Eastern Oregon UniversityOR 1,299 945 1,352 3,596
Portland State UniversityOR913 2,459 16,779 20,151
Oregon Institute of TechnologyOR385488 2,453 3,326
Southern Oregon UniversityOR316647 3,676 4,639
Oregon Health & Science UniversityOR204-621825
Western Oregon UniversityOR119653 4,548 5,320
University of OregonOR80 1,787 18,597 20,464
Oregon State University-Cascades CampusOR--637637
Pennsylvania State University-World CampusPA 4,266 -- 4,266
California University of PennsylvaniaPA645 2,066 3,935 6,646
Clarion University of PennsylvaniaPA502901 3,934 5,337
Pennsylvania College of TechnologyPA235431 4,933 5,599
Slippery Rock University of PennsylvaniaPA226422 7,124 7,772
Mansfield University of PennsylvaniaPA118722 1,903 2,743
Temple UniversityPA112 25,664 1,300 27,076
Pennsylvania State University-Penn State AbingtonPA111441 2,526 3,078
Indiana University of Pennsylvania-Main CampusPA89 1,660 11,278 13,027
Lock Haven UniversityPA77991 3,809 4,877
Pennsylvania State University-Penn State HarrisburgPA64523 2,668 3,255
Pennsylvania State University-Penn State SchuylkillPA51338418807
Kutztown University of PennsylvaniaPA49373 8,494 8,916
Pennsylvania State University-Main CampusPA41 12,650 25,856 38,547
University of Pittsburgh-Pittsburgh CampusPA41883 17,181 18,105
Pennsylvania State University-Penn State AltoonaPA27149 3,612 3,788
Millersville University of PennsylvaniaPA19906 6,400 7,325
Pennsylvania State University-Penn State Wilkes-BarrePA16198347561
Pennsylvania State University-Penn State Erie-Behrend CollegePA14668 3,177 3,859
Pennsylvania State University-Penn State Lehigh ValleyPA14299474787
Edinboro University of PennsylvaniaPA12261 5,719 5,992
Pennsylvania State University-Penn State Mont AltoPA11332665 1,008
Pennsylvania State University-Penn State New KensingtonPA10140500650
East Stroudsburg University of PennsylvaniaPA8354 5,927 6,289
Pennsylvania State University-Penn State Fayette- Eberly CampusPA7309502818
University of Pittsburgh-BradfordPA7302 1,183 1,492
Pennsylvania State University-Penn State Worthington ScrantonPA5198927 1,130
Pennsylvania State University-Penn State DuboisPA4235341580
Pennsylvania State University-Penn State YorkPA4111861976
West Chester University of PennsylvaniaPA477 12,972 13,053
Pennsylvania State University-Penn State BerksPA3389 2,185 2,577
Pennsylvania State University-Penn State Greater AlleghenyPA2115479596
Pennsylvania State University-Penn State BeaverPA156599656
Pennsylvania State University-Penn State BrandywinePA1176 1,226 1,403
Shippensburg University of PennsylvaniaPA1- 6,653 6,654
Bloomsburg University of PennsylvaniaPA-143 8,901 9,044
Cheyney University of PennsylvaniaPA-- 1,210 1,210
Lincoln University of PennsylvaniaPA-- 1,669 1,669
Pennsylvania State University-College of MedicinePA----
Pennsylvania State University-Penn State Great ValleyPA----
Pennsylvania State University-Penn State HazletonPA-63974 1,037
Pennsylvania State University-Penn State ShenangoPA-19465484
The Dickinson School of Law of the Pennsylvania State UniversityPA----
University of Pittsburgh-GreensburgPA-- 1,722 1,722
University of Pittsburgh-JohnstownPA-- 2,930 2,930
University of Rhode IslandRI113 6,347 6,667 13,127
Rhode Island CollegeRI299 7,160 7,261
Coastal Carolina UniversitySC62 1,544 6,860 8,466
Lander UniversitySC51498 2,355 2,904
Clemson UniversitySC27 2,634 13,764 16,425
Francis Marion UniversitySC152 3,439 3,456
Citadel Military College of South CarolinaSC1455 2,486 2,555
Winthrop UniversitySC4673 4,070 4,747
College of CharlestonSC172 10,133 10,206
Medical University of South CarolinaSC-50154204
South Carolina State UniversitySC-378 2,852 3,230
University of South Carolina-AikenSC-322 2,555 2,877
University of South Carolina-BeaufortSC-13 1,726 1,739
University of South Carolina-ColumbiaSC- 3,006 20,022 23,028
University of South Carolina-UpstateSC- 1,698 3,382 5,080
University of South DakotaSD 1,775 871 3,770 6,416
South Dakota State UniversitySD438 2,316 7,289 10,043
Dakota State UniversitySD351471906 1,728
Black Hills State UniversitySD177533 2,471 3,181
Northern State UniversitySD123334 1,312 1,769
Oglala Lakota CollegeSD1394 1,421 1,528
South Dakota School of Mines and TechnologySD4120 1,815 1,939
Austin Peay State UniversityTN 1,411 3,258 4,806 9,475
University of MemphisTN 1,258 3,288 12,202 16,748
East Tennessee State UniversityTN616 3,459 7,753 11,828
The University of Tennessee-MartinTN357328 6,012 6,697
Tennessee Technological UniversityTN256 5,550 3,823 9,629
Middle Tennessee State UniversityTN- 9,862 12,259 22,121
Tennessee State UniversityTN-6 6,596 6,602
The University of TennesseeTN-- 20,699 20,699
The University of Tennessee at ChattanoogaTN- 1,546 8,470 10,016
The University of Texas at ArlingtonTX 4,063 3,314 18,110 25,487
South Texas CollegeTX 2,519 2,605 13,566 18,690
Texas Woman's UniversityTX 1,281 2,494 4,761 8,536
Lamar UniversityTX 1,159 2,257 6,040 9,456
University of Houston-DowntownTX 1,135 3,362 9,052 13,549
Texas A & M University-CommerceTX 1,065 2,336 3,436 6,837
University of Houston-VictoriaTX 1,018 1,021 612 2,651
Tarleton State UniversityTX941703 8,824 10,468
University of North TexasTX909 7,780 21,904 30,593
University of HoustonTX801 9,310 21,205 31,316
Texas Tech UniversityTX723 2,938 22,615 26,276
Midwestern State UniversityTX680960 3,598 5,238
Texas A & M University-KingsvilleTX620 2,315 5,968 8,903
Sam Houston State UniversityTX612 3,739 11,260 15,611
Stephen F Austin State UniversityTX611 2,487 7,927 11,025
West Texas A & M UniversityTX610 2,193 3,732 6,535
The University of Texas at El PasoTX562 4,823 13,693 19,078
The University of Texas at BrownsvilleTX530 3,236 7,157 10,923
Midland CollegeTX363982 2,217 3,562
University of Houston-Clear LakeTX327 1,349 2,855 4,531
Texas Tech University Health Sciences CenterTX287536482 1,305
Texas State University-San MarcosTX266 1,950 27,242 29,458
Angelo State UniversityTX263 1,450 4,156 5,869
The University of Texas at TylerTX258 1,694 3,274 5,226
The University of Texas of the Permian BasinTX243 1,016 1,445 2,704
The University of Texas-Pan AmericanTX240 3,564 12,741 16,545
Brazosport CollegeTX232624 2,229 3,085
Texas A & M University-Corpus ChristiTX206724 7,801 8,731
Texas A & M University-TexarkanaTX200616623 1,439
Texas A & M International UniversityTX192693 5,470 6,355
The University of Texas Medical BranchTX186490-676
Sul Ross State UniversityTX75 1,859 13 1,947
The University of Texas Health Science Center at San AntonioTX61120697878
The University of Texas at San AntonioTX39 2,009 23,297 25,345
Prairie View A & M UniversityTX32734 6,054 6,820
Texas Southern UniversityTX22459 6,540 7,021
The University of Texas at AustinTX9804 38,402 39,215
Texas A & M University-College StationTX164 39,885 39,950
Texas A & M University-GalvestonTX-- 1,905 1,905
Texas A&M Health Science CenterTX--206206
The University of Texas at DallasTX- 1,690 10,336 12,026
The University of Texas Health Science Center at HoustonTX--563563
The University of Texas M.D. Anderson Cancer CenterTX-290-290
University of North Texas Health Science CenterTX----
University of Texas Southwestern Medical CenterTX--3333
Utah State UniversityUT 3,315 4,234 13,580 21,129
Utah Valley UniversityUT 2,570 5,767 17,569 25,906
Weber State UniversityUT 1,894 5,130 11,799 18,823
University of UtahUT733 5,840 17,399 23,972
Dixie State College of UtahUT295 2,339 5,025 7,659
Snow CollegeUT137444 2,607 3,188
Southern Utah UniversityUT115 1,304 4,348 5,767
Old Dominion UniversityVA 2,302 2,921 14,080 19,303
George Mason UniversityVA257 3,118 16,692 20,067
Virginia Commonwealth UniversityVA221 4,009 17,973 22,203
Norfolk State UniversityVA148 2,293 3,871 6,312
Virginia Polytechnic Institute and State UniversityVA50 5,564 18,209 23,823
Radford UniversityVA49 1,038 7,488 8,575
James Madison UniversityVA43 1,796 16,035 17,874
University of Virginia-Main CampusVA32237 14,400 14,669
The University of Virginia's College at WiseVA28314 1,276 1,618
Longwood UniversityVA16132 4,037 4,185
University of Mary WashingtonVA1131 4,246 4,378
Christopher Newport UniversityVA-- 5,036 5,036
College of William and MaryVA-- 6,129 6,129
Eastern Virginia Medical SchoolVA----
Virginia Military InstituteVA-- 1,664 1,664
Virginia State UniversityVA-- 5,309 5,309
Johnson State CollegeVT172248 1,070 1,490
University of VermontVT58657 9,477 10,192
Vermont Technical CollegeVT22155 1,298 1,475
Castleton State CollegeVT-- 2,015 2,015
Lyndon State CollegeVT-18 1,356 1,374
Washington State UniversityWA 1,839 1,038 19,937 22,814
Bellevue CollegeWA 1,132 1,167 3,362 5,661
Central Washington UniversityWA811 1,509 7,970 10,290
Olympic CollegeWA563 1,456 3,188 5,207
Columbia Basin CollegeWA494 1,177 3,109 4,780
Peninsula CollegeWA333428487 1,248
Eastern Washington UniversityWA249695 10,392 11,336
Seattle Community College-South CampusWA213325 1,553 2,091
Seattle Community College-Central CampusWA173362 3,074 3,609
Centralia CollegeWA108290979 1,377
Lake Washington Institute of TechnologyWA68289 1,918 2,275
Western Washington UniversityWA68318 13,415 13,801
University of Washington-Seattle CampusWA61 1,463 26,464 27,988
Northwest Indian CollegeWA20128482630
University of Washington-Tacoma CampusWA12212 3,035 3,259
University of Washington-Bothell CampusWA446 3,436 3,486
The Evergreen State CollegeWA-- 4,121 4,121
University of Wisconsin-Green BayWI 1,109 1,199 3,788 6,096
Madison Area Technical CollegeWI 1,004 2,570 9,601 13,175
University of Wisconsin-StoutWI820 2,074 5,215 8,109
University of Wisconsin-MilwaukeeWI806 5,378 16,521 22,705
University of Wisconsin-OshkoshWI553 1,259 8,977 10,789
University of Wisconsin-PlattevilleWI47786 7,161 7,724
University of Wisconsin-SuperiorWI441173 1,851 2,465
University of Wisconsin-MadisonWI107 1,993 27,027 29,127
University of Wisconsin-Eau ClaireWI105 1,307 8,955 10,367
University of Wisconsin-WhitewaterWI93 1,411 8,937 10,441
University of Wisconsin-River FallsWI63897 4,914 5,874
University of Wisconsin-Stevens PointWI58884 8,222 9,164
University of Wisconsin-ParksideWI29170 4,116 4,315
University of Wisconsin-La CrosseWI11564 8,580 9,155
West Virginia UniversityWV791 1,157 20,344 22,292
Marshall UniversityWV448 2,291 6,626 9,365
West Virginia University at ParkersburgWV332 1,180 1,844 3,356
Bluefield State CollegeWV199 1,046 644 1,889
Glenville State CollegeWV126403984 1,513
Concord UniversityWV108555 1,919 2,582
Fairmont State UniversityWV85 2,885 1,026 3,996
West Liberty UniversityWV37734 1,716 2,487
Potomac State College of West Virginia UniversityWV3283 1,424 1,539
West Virginia State UniversityWV19453 1,663 2,135
Shepherd UniversityWV5122 3,725 3,852
West Virginia School of Osteopathic MedicineWV----
West Virginia University Institute of TechnologyWV-16971987
University of WyomingWY 1,028 1,611 7,390 10,029

Here is the data table on GDrive for sharing / downloading.

Summary by State

The next task was to summarize the data by each state. I created the summaries mostly by the SUMIF() function in MS Excel.

=SUMIF($B$2:$B$691,”=”&$K2,$F$2:$F$691)

where column B is the state code of each institution, column K is the state code in the summary table (one row per state), and column F is the data for each time of enrollment.

Once this was done, I saved a csv file with the data only (no formulas) as well as the percentages, uploaded to GDrive and published using TablePress:

Summary of US public 4-year institutions and online education enrollment by state for Fall 2012, from IPEDS
State
# exclusive online courses
# some but not all online courses
# at least one online course
# no online courses
Total Enrollment
TOTALS 323,687 1,069,072 1,392,759 4,924,789 6,317,548
FL 48,746 147,708 196,454 410,342 606,796
TX 23,341 81,590 104,931 381,926 486,857
MD 23,098 12,410 35,508 86,614 122,122
NJ 20,210 15,525 35,735 106,850 142,585
OH 18,162 38,265 56,427 207,665 264,092
NY 11,439 31,460 42,899 272,684 315,583
AZ 10,084 41,958 52,042 61,892 113,934
KS 10,074 12,904 22,978 53,526 76,504
UT 9,059 25,058 34,117 72,327 106,444
IN 7,937 29,570 37,507 134,992 172,499
NV 7,797 18,452 26,249 50,252 76,501
AL 7,654 33,998 41,652 86,050 127,702
CO 7,144 14,469 21,613 113,510 135,123
PA 6,797 53,565 60,362 167,979 228,341
NC 6,749 28,274 35,023 134,804 169,827
OK 6,674 24,668 31,342 69,667 101,009
WA 6,148 10,903 17,051 106,922 123,973
GA 6,099 35,668 41,767 187,009 228,776
MI 5,933 25,309 31,242 198,631 229,873
KY 5,849 19,222 25,071 69,319 94,390
WI 5,676 19,965 25,641 123,865 149,506
OR 5,468 9,950 15,418 64,636 80,054
LA 4,644 20,364 25,008 83,844 108,852
MA 4,103 11,313 15,416 75,870 91,286
ND 3,971 6,292 10,263 22,689 32,952
NM 3,956 11,323 15,279 32,095 47,374
MN 3,928 19,871 23,799 73,284 97,083
TN 3,898 27,297 31,195 82,620 113,815
AR 3,765 16,583 20,348 54,955 75,303
MO 3,695 24,533 28,228 80,507 108,735
VA 3,147 21,553 24,700 136,445 161,145
MS 2,968 8,878 11,846 50,984 62,830
SD 2,881 4,739 7,620 18,984 26,604
IL 2,841 20,223 23,064 123,712 146,776
AK 2,424 4,472 6,896 13,596 20,492
ME 2,220 5,835 8,055 16,602 24,657
ID 2,211 10,842 13,053 25,965 39,018
WV 2,182 10,925 13,107 42,886 55,993
NE 2,009 10,014 12,023 31,746 43,769
CT 1,647 3,571 5,218 47,274 52,492
MT 1,327 5,004 6,331 27,187 33,518
CA 1,178 61,485 62,663 497,709 560,372
HI 1,102 3,477 4,579 18,916 23,495
WY 1,028 1,611 2,639 7,390 10,029
NH 1,019 1,347 2,366 21,526 23,892
IA690 6,918 7,608 49,283 56,891
VT252 1,078 1,330 15,216 16,546
SC174 10,945 11,119 73,798 84,917
DE174 1,110 1,284 19,836 21,120
RI115 6,446 6,561 13,827 20,388
DC-132132 4,581 4,713

Summary of US public 4-year institutions and online education enrollment percentages by state for Fall 2012, from IPEDS

State
% exclusive online courses
% some but not all online courses
% at least one online course
% no online courses
Total Enrollment
TOTALS5%17%22%78%6,317,548
FL 8%24%32%68% 606,796
TX5%17%22%78% 486,857
MD19%10%29%71% 122,122
NJ14%11%25%75% 142,585
OH7%14%21%79% 264,092
NY4%10%14%86% 315,583
AZ9%37%46%54% 113,934
KS13%17%30%70% 76,504
UT9%24%32%68% 106,444
IN5%17%22%78% 172,499
NV10%24%34%66% 76,501
AL6%27%33%67% 127,702
CO5%11%16%84% 135,123
PA3%23%26%74% 228,341
NC4%17%21%79% 169,827
OK7%24%31%69% 101,009
WA5%9%14%86% 123,973
GA3%16%18%82% 228,776
MI3%11%14%86% 229,873
KY6%20%27%73% 94,390
WI4%13%17%83% 149,506
OR7%12%19%81% 80,054
LA4%19%23%77% 108,852
MA4%12%17%83% 91,286
ND12%19%31%69% 32,952
NM8%24%32%68% 47,374
MN4%20%25%75% 97,083
TN3%24%27%73% 113,815
AR5%22%27%73% 75,303
MO3%23%26%74% 108,735
VA2%13%15%85% 161,145
MS5%14%19%81% 62,830
SD11%18%29%71% 26,604
IL2%14%16%84% 146,776
AK12%22%34%66% 20,492
ME9%24%33%67% 24,657
ID6%28%33%67% 39,018
WV4%20%23%77% 55,993
NE5%23%27%73% 43,769
CT3%7%10%90% 52,492
MT4%15%19%81% 33,518
CA0%11%11%89% 560,372
HI5%15%19%81% 23,495
WY10%16%26%74% 10,029
NH4%6%10%90% 23,892
IA1%12%13%87% 56,891
VT2%7%8%92% 16,546
SC0%13%13%87% 84,917
DE1%5%6%94% 21,120
RI1%32%32%68% 20,388
DC0%3%3%97% 4,713

Here is the data table on GDrive for sharing / downloading.

Listing of Florida Public Institutions

At this point it seemed useful to filter down to the specific Florida public 4-year institutions, and share both the raw enrollment data as well as the percentages:

Listing of Florida public 4-year institutions and summary of Fall 2012 online education enrollment, from IPEDS
Florida Public 4-year Institution
# exclusive online courses
# some but not all online courses
# at least one online course
# no online courses
Total Enrollment
TOTALS 48,746 147,708 196,454 410,342 606,796
St Petersburg College 8,243 6,801 15,044 12,530 27,574
Florida State College at Jacksonville 4,105 6,231 10,336 16,298 26,634
University of Central Florida 3,901 15,030 18,931 31,690 50,621
Valencia College 3,111 8,837 11,948 23,780 35,728
Miami Dade College 2,806 5,663 8,469 53,581 62,050
Florida International University 2,473 15,890 18,363 17,881 36,244
Daytona State College 2,188 3,627 5,815 7,575 13,390
Broward College 2,094 5,821 7,915 29,707 37,622
University of South Florida-Main Campus 2,011 11,175 13,186 17,282 30,468
Palm Beach State College 1,766 3,775 5,541 20,979 26,520
Seminole State College of Florida 1,650 3,897 5,547 12,263 17,810
Santa Fe College 1,589 2,933 4,522 9,571 14,093
Indian River State College 1,429 3,379 4,808 9,530 14,338
The University of West Florida 1,295 2,919 4,214 5,735 9,949
Edison State College 1,121 2,538 3,659 9,474 13,133
State College of Florida-Manatee-Sarasota 1,067 2,553 3,620 6,099 9,719
University of Florida 1,005 15,597 16,602 15,421 32,023
Polk State College911 2,260 3,171 6,242 9,413
Florida Atlantic University750 3,048 3,798 20,258 24,056
Pensacola State College748 1,977 2,725 6,777 9,502
College of Central Florida644 2,669 3,313 4,106 7,419
Saint Johns River State College621 1,234 1,855 3,392 5,247
Florida State University435 5,293 5,728 25,924 31,652
Northwest Florida State College434 1,629 2,063 3,749 5,812
University of South Florida Sarasota-Manatee426752 1,178 535 1,713
Gulf Coast State College424852 1,276 2,135 3,411
Florida Gulf Coast University395 4,366 4,761 7,325 12,086
Florida Gateway College319713 1,032 1,122 2,154
University of South Florida-St. Petersburg Campus253 1,976 2,229 1,777 4,006
University of North Florida225 2,796 3,021 11,103 14,124
Lake-Sumter Community College156626782 2,925 3,707
South Florida State College84398482 1,591 2,073
Chipola College67397464 1,268 1,732
Florida Agricultural and Mechanical University-5656 9,885 9,941
New College of Florida---832832

Listing of Florida public 4-year institutions and percentage of Fall 2012 online education enrollment, from IPEDS

Florida Public 4-year Institution
% exclusive online courses
% some but not all online courses
% at least one online course
% no online courses
Total Enrollment
TOTALS8%24%32%68% 606,796
St Petersburg College30%25%55%45% 27,574
Florida State College at Jacksonville15%23%39%61% 26,634
University of Central Florida8%30%37%63% 50,621
Valencia College9%25%33%67% 35,728
Miami Dade College5%9%14%86% 62,050
Florida International University7%44%51%49% 36,244
Daytona State College16%27%43%57% 13,390
Broward College6%15%21%79% 37,622
University of South Florida-Main Campus7%37%43%57% 30,468
Palm Beach State College7%14%21%79% 26,520
Seminole State College of Florida9%22%31%69% 17,810
Santa Fe College11%21%32%68% 14,093
Indian River State College10%24%34%66% 14,338
The University of West Florida13%29%42%58% 9,949
Edison State College9%19%28%72% 13,133
State College of Florida-Manatee-Sarasota11%26%37%63% 9,719
University of Florida3%49%52%48% 32,023
Polk State College10%24%34%66% 9,413
Florida Atlantic University3%13%16%84% 24,056
Pensacola State College8%21%29%71% 9,502
College of Central Florida9%36%45%55% 7,419
Saint Johns River State College12%24%35%65% 5,247
Florida State University1%17%18%82% 31,652
Northwest Florida State College7%28%35%65% 5,812
University of South Florida Sarasota-Manatee25%44%69%31% 1,713
Gulf Coast State College12%25%37%63% 3,411
Florida Gulf Coast University3%36%39%61% 12,086
Florida Gateway College15%33%48%52% 2,154
University of South Florida-St. Petersburg Campus6%49%56%44% 4,006
University of North Florida2%20%21%79% 14,124
Lake-Sumter Community College4%17%21%79% 3,707
South Florida State College4%19%23%77% 2,073
Chipola College4%23%27%73% 1,732
Florida Agricultural and Mechanical University0%1%1%99% 9,941
New College of Florida0%0%0%100%832

Here is the data table on GDrive for sharing / downloading.

Feedback

As I mentioned, we plan on doing more open data exploration on e-Literate, so let me know if you have any problems accessing, viewing or downloading the data, or if you have any suggestions.

Update: I highlighted the Florida and University of Florida rows based on the story on UF Online.

Share Button

Google+ Comments

About Phil Hill

Phil is a consultant and industry analyst covering the educational technology market primarily for higher education. He has written for e-Literate since Aug 2011. For a more complete biography, view his profile page.
This entry was posted in Higher Education, Openness, Tools, Toys, and Technology (Oh my!) and tagged , , , , , , , , , , , . Bookmark the permalink.

One Response to Open Data: A case study using IPEDS for online education

  1. Pingback: on pinboard for February 9th, 2014 | Morgan's Log

Leave a Reply