​​Size isn’t everything. Yet, when it comes to higher education, some universities stand out for their considerable enrollment numbers.

Among the 69 largest universities on our list, Indira Gandhi National Open University is the largest, with over seven million students enrolled. Beyond size, we’ll also look at the oldest among these large institutions and whether the largest are more likely to be public or private.

Top 10 Largest Universities by Country

View Largest Universities in a full screen map

Each of the 69 universities depicted on the map is the largest in its country. However, the top 10 have significantly higher enrollment figures than the smallest.

University	Enrollment
Indira Gandhi National Open University	7,140,000
National University, Bangladesh	2,097,182
Anadolu University	1,969,733
Universitas Terbuka	1,045,665
Islamic Azad University	1,000,000
Tribhuvan University	604,437
Ramkhamhaeng University	525,000
National Autonomous University of Mexico	349,515
University of South Africa	328,179
Spiru Haret University	311,928

Indira Gandhi National Open University (IGNOU) in India leads the list with a staggering 7,140,000 enrolled students. The National University in Bangladesh follows IGNOU with 2,097,182 students. Next is Anadolu University in Turkey, with 1,969,733 students, and Universitas Terbuka in Indonesia, with 1,045,665 students. Iran’s Islamic Azad University and Pakistan’s Allama Iqbal Open University also have enrollment numbers that break the million mark.

Six of the top ten universities are in Asia, though the count extends to seven if we include Turkey’s Anadolu University.

As for the US, the largest university is Texas A&M. This institution doesn’t even rank among the largest 30 across the globe; however, spread across 5,115 acres, it ranks ninth in terms of the largest US campuses. Founded in 1876, it’s not anywhere near the oldest, though, which we’ll examine next.

10 Oldest Large Universities

While we’ve just highlighted the top 10 largest universities, most were relatively recently established in the 20th century. However, there are far older large universities:

• University of Lisbon: founded in 1288
• Sapienza University of Rome: 1303
• University of Vienna: 1365
• KU Leuven: 1425
• Universidad Autónoma de Santo Domingo: 1538
• National University of San Marcos: 1551
• National Autonomous University of Mexico: 1551
• University of Amsterdam: 1632
• University of Helsinki: 1640
• Lund University: 1666

The largest university in Portugal, the University of Lisbon, was established more than seven centuries ago, in 1288. We could argue that the current university was established much later — in 1911, 1930, or even in 2013. Successive mergers aside, the institution can trace its roots back to the original University of Coimbra in 1288.

Following the University of Lisbon are two more public universities: Sapienza University of Rome and the University of Vienna, both founded during the 14th century. Speaking of public universities, let’s dive into the types of large universities.

Are the Largest Universities More Likely to Be Public or Private?

The largest university in the US, Texas A&M, is a public university. This designation means the state owns the university, or the government provides a significant amount of its funding. While the majority of large universities are public, there are other types too:

• Public: 59 of the largest universities
• Private: 7
• Semi-private: 1
• Public (formerly private): 1
• Private, state-funded: 1

So, 59 of the 69 universities we’re looking at are public or publicly funded institutions.
Private universities, or institutions that are not operated, owned, or institutionally funded by governments, follow, with a count of seven. The largest is Spiru Haret University in Romania, the only private university in the top ten. Additionally, there is a single semi-private university (Islamic Azad University).

One university also transitioned from private to public status (University College Dublin), while the other is private but state-funded (Belgium’s KU Leuven).

Explore More Top University Stats

Although large universities have their appeal, we know that the biggest doesn’t always mean the best. Explore our Map of Top Colleges in the US for a different perspective.

Nuclear testing is a controversial practice historically undertaken by nine countries around the world: Russia, the US, China, France, the UK, Pakistan, India, North Korea, and Israel. Just five of these countries have deployed 93 of the most potent bomb tests — exceeding the equivalent of 1.4 megatons of TNT each.

So, let’s delve into these bomb tests’ yields, deployment methods, and when they took place.

View Most powerful nuclear weapons tests in a full screen map

Yields of the Most Powerful Bomb Tests

We can’t discuss bomb testing without exploring the most formidable explosions. In this, the 93 tests range from 1 to 50 megatons. Yet only ten have had yields above ten megatons, which we’ll highlight now.

Name or Number	Country	Yield (megatons)
Tsar Bomba, Test #130	Soviet Union	50
Test #219	Soviet Union	24.2
Test #147	Soviet Union	21.1
Test #174	Soviet Union	20
Test #173	Soviet Union	19.1
Castle Bravo	USA	15
Castle Yankee	USA	13.5
Test #123	Soviet Union	12.5
Castle Romeo	USA	11
Ivy Mike	USA	10.4

Only the Soviet Union and the US are among the top 10 most powerful bomb tests. Also called Test #130, the Tsar Bomba stands out as the most potent, with a staggering yield of 50 megatons, making it the most powerful nuclear explosion in history. The Soviet Union tested it in 1961 at Novaya Zemlya. Following this are four additional significant Soviet tests, including Test #219 with a yield of 24.2 megatons and Test #147 with 21.1 megatons—all also tested at Novaya Zemlya.

The US has also conducted significant tests, with the 1954 Castle Bravo registering a yield of 15 megatons at Bikini Atoll, marking it as the most powerful American test. It’s worth noting that most of these tests involve air drops, so let’s take a closer look at deployment methods next.

How the Most Powerful Bomb Tests Were Deployed

From conventional air drops to cutting-edge missile warheads, the spectrum of testing types is broad:

• Air drop: 40 bomb tests
• Barge: 13
• Underground shaft: 9
• Tunnel: 7
• Parachuted: 6
• High alt rocket: 5
• Space rocket: 3
• Ground: 2
• Free air drop: 2
• Dry surface: 2
• Balloon: 2
• Parachute air drop: 1
• Missile warhead: 1

The majority of tests were through air drops (40), 75% of which were conducted by the Soviet Union. Air drops were also the most popular (4) among the 10 most powerful tests.

Barge tests (13) and underground shaft tests (9) were also notable as were tunnel (7) and parachute (6) tests. Check out the rest of the deployment methods on the map because we’re moving on to the years of these tests.

The 24-Year Span of the Most Powerful Tests

The end of nuclear bomb testing came on August 5, 1963, when the US, UK, and Soviet Union signed the Limited Test Ban Treaty.

Before the parties came to the table, the world saw 24 years of nuclear bomb tests, from 1952 to 1976. The most active years included 1962, during which 27 bomb tests were deployed. Of those, 17 tests were conducted by the Soviet Union, all at Novaya Zemlya, while 10 were from the US, albeit at multiple test sites (including at Kiritimati and Johnston Atoll).

Other notable years during this testing era included 1958 (15 tests), 1961 (11), and 1956 and 1968 (6 each).

You can also check out Locations of Nuclear Weapons in the United States and Worldwide on the BatchGeo blog.

If you own a business or your job has anything to do with sales, you likely have all sorts of information about your customers or leads. But are you making the most of this data?

If you store this information in Excel or another tool that can export a CSV file, you may be overlooking key metrics that could help improve your company, such as dates. For example:

• First purchase date
• Last purchase date

You can make more of the data you have by going from this…

…to this!

When you separate dates in Excel, you can sort your data by year, month, and day, making it easier to find patterns. You can also use Excel to compare dates, determining the duration of the engagement you’re measuring.

We used the following tips to split data of the birthdates and tenures of 115 US Supreme Court Justices, which is why the customer names in our examples may sound familiar. So, let’s get started with Excel’s formulas and features.

Split Dates into Sortable Days, Months, and Years

Say you have a cell that contains year, month, and day — this may not be the best format if you’re trying to isolate the most common months.

There are many ways of separating dates into unique columns in Excel, but perhaps the easiest is using “Text to Column.” Google Sheets has a similar feature. Here’s how to do it in Excel:

• Select the cells you’d like to separate.
• Navigate to the “Data” tab.
• Select “Text to Columns…”.
• Choose whether your data is currently separated by Delimited characters such as commas or colons or Fixed width with spaces between each field (we usually opt for the first).
• Click “Next” and either check off the delimiters your data contains (tabs, semicolons, commas, spaces, or you can customize any other delimiter, such as backspaces or hyphens) or set the column breaks.
• Select “Next” and choose where you want your separated data to end up.
• Click “Finish,” and you’re done!

Now that you’ve separated days from months and years, you can sort the individual columns or use pivot tables to count and summarize. You can also use an Excel formula to compare dates.

Calculate the Time Between Two Dates

You have two dates split into individual columns in Excel. Some data analysis requires you to calculate how many years, months, or days are between them. Below is the simple Excel formula that allows you to do this:

=DATEDIF(Start_date, End_date, Unit)

• In a new column, start by typing “=DATEDIF(“
• Follow up by either clicking the cell with your start date or typing in its corresponding letter and number (i.e., D2) followed by a comma.
• Now, click your end date or enter it in (i.e., E2), again followed by a comma.
• Next, in quotations, specify whether you want the time between the two dates to be in days, months, years, or some combination.
• “d” is used for the difference in days
• “m” means the difference in complete months
• “y” is for the difference in complete years
• Close your parentheses.

Note: There are also ways to exclude data, such as:

• “md”: Difference in days, excludes months and years
• “ym” : Difference in months, excludes years
• “yd”: Difference in days, excludes years

For our purposes, we want only the years and days between our two dates so we used two formulas in two columns, “Years,” and “Days.”

=DATEDIF(D2,E2,“y”)

and

=DATEDIF(D2,E2,“yd”)

Drag it down all your rows, and you’ll automatically calculate the difference!

Map Your Data and Dates

With your data organized and some Excel math under your belt, let’s see how you can get the most out of your spreadsheet. Plotting your points on a custom map is the natural next step if your data contains locations, such as addresses, cities, or states.

There are quite a few ways to do this, from desktop GIS software like ArcGIS or a Google Maps API, as explained in Introduction to Map Making on the Web. But the easiest method is to use Batchgeo, a dedicated tool that geocodes your location data. Here’s how to make a map with our free geocoder:

• Open your spreadsheet.
• Select (Ctrl+A or Cmd+A) and copy (Ctrl+C or Cmd+C) your data.
• Open your web browser and navigate to batchgeo.com.
• Click on the location data box with the example data, then paste (Ctrl+V or Cmd+V) your data.
• Ensure you have the proper location data columns by clicking “Validate and Set Options.”
• Select the proper location column from each dropdown.
• Click “Make Map” and watch as the geocoder performs its process.

Thanks to splitting our data and our date math, our map looks like this:

View Sales Data with Dates (After) in a full screen map

Otherwise, it would have looked something like this:

View Sales Data with Dates (Before) in a full screen map

Check out our other Excel tips to upgrade your spreadsheet game even further:

• How to Find Duplicates in Excel
• Excel Data Visualization Examples
• Simplify Complicated Data in Excel Spreadsheets

Or get mapping today for free at batchgeo.com.