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.

.@PhilOnEdTech continues his important analysis of IPEDS vs Babson survey data http://t.co/Cl1HE5oMrG (this is why "open data" matters)

— Audrey Watters (@audreywatters) January 24, 2014

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:

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 IPEDSTOTALS 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 SciencesAR221175384780University 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 CampusCA188583672California Maritime AcademyCA--971971California 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 PointCT2048666734Western 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--967967University 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--832832Kennesaw 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 UniversityGA7965268412Gordon 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--839839Eastern 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--902902Louisiana State University Health Sciences Center-ShreveportLA--5050Southern 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-BaltimoreMD69217436722University 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 KentME175304356835University of Maine at Presque IsleME121534367 1,022 University of Maine at MachiasME102268257627University of MaineME95 1,768 6,365 8,228 University of Maine at FarmingtonME323 1,946 1,972 Maine Maritime AcademyME--968968Central 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-22363385Missouri 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-357621Jackson 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--752752University 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 UniversityND209488260957Mayville State UniversityND162102511775Fort Berthold Community CollegeND159134194Sitting Bull CollegeND-56213269Chadron 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 CenterNE108291423822University 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--776776Thomas Edison State CollegeNJ 19,256 -150 19,406 University of Medicine and Dentistry of New JerseyNJ20249723974New 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 CultureNM668167241Navajo 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 UniversityNY2176117295Buffalo 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--335335United States Merchant Marine AcademyNY--987987United 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 CampusOH44682468996Ohio 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-448390838Wright 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 CenterOK29691151871Langston UniversityOK6199 1,786 1,991 Oklahoma State University Center for Health SciencesOK----University of Science and Arts of OklahomaOK--963963Oregon 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-621825Western Oregon UniversityOR119653 4,548 5,320 University of OregonOR80 1,787 18,597 20,464 Oregon State University-Cascades CampusOR--637637Pennsylvania 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 SchuylkillPA51338418807Kutztown 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-BarrePA16198347561Pennsylvania State University-Penn State Erie-Behrend CollegePA14668 3,177 3,859 Pennsylvania State University-Penn State Lehigh ValleyPA14299474787Edinboro University of PennsylvaniaPA12261 5,719 5,992 Pennsylvania State University-Penn State Mont AltoPA11332665 1,008 Pennsylvania State University-Penn State New KensingtonPA10140500650East Stroudsburg University of PennsylvaniaPA8354 5,927 6,289 Pennsylvania State University-Penn State Fayette- Eberly CampusPA7309502818University of Pittsburgh-BradfordPA7302 1,183 1,492 Pennsylvania State University-Penn State Worthington ScrantonPA5198927 1,130 Pennsylvania State University-Penn State DuboisPA4235341580Pennsylvania State University-Penn State YorkPA4111861976West Chester University of PennsylvaniaPA477 12,972 13,053 Pennsylvania State University-Penn State BerksPA3389 2,185 2,577 Pennsylvania State University-Penn State Greater AlleghenyPA2115479596Pennsylvania State University-Penn State BeaverPA156599656Pennsylvania 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-19465484The 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-50154204South 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-676Sul Ross State UniversityTX75 1,859 13 1,947 The University of Texas Health Science Center at San AntonioTX61120697878The 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--206206The University of Texas at DallasTX- 1,690 10,336 12,026 The University of Texas Health Science Center at HoustonTX--563563The University of Texas M.D. Anderson Cancer CenterTX-290-290University of North Texas Health Science CenterTX----University of Texas Southwestern Medical CenterTX--3333Utah 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 CollegeWA20128482630University 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-16971987University 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 TOTALS 323,687 1,069,072 1,392,759 4,924,789 6,317,548FL 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

TOTALS5%17%22%78%6,317,548FL 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 IPEDSTOTALS 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

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.

The post Open Data: A case study using IPEDS for online education appeared first on e-Literate.