Using the 152-School Dr. G. DB to Build Your Dream List: A Complete Practical Demo (2026)

Every family that comes to Dr. G. for consulting eventually sees one spreadsheet: the 152-school database. This is the result of 8 years of data engineering, covering complete admissions data, tuition, aid, academic rankings, and recruiting target school status for 152 undergraduate and master’s programs across the United States.

But whenever a new family sees a spreadsheet with 152 rows and 40 columns, their first question is always: “With this many schools, how do we actually choose?”

The answer: use a 4-step filtering method to compress 152 schools into 15-25 candidates, then have a consultant manually review fit and finalize a 12-school dream list.

This article uses the profile of a real student (anonymized) to fully demonstrate the 4-step process. You will see how the list moves from 152 → 35 → 18 → 12 schools, including the filtering logic at each step, why certain schools stay or are removed, and what the final 12-school list looks like.

After reading this, you will understand: the Dr. G. DB is a tool, not a verdict. The final decision is still the result of discussion between the consultant and family, but the DB turns “subjective guessing” into “objective, rational decision-making.”

1. What Is the Dr. G. DB? The Data Structure Behind 152 Schools#

The Dr. G. 152-school database (internal code name: Master_Grad_School_Database_2026-04) has been continuously built over 8 years and covers:

Scope:

• US News National Universities Top 100 (all 100 schools)
• US News Liberal Arts College Top 30
• Major public universities (representatives from UCs, SUNYs, Big Ten, ACC, and Pac-12)
• Special schools that are international-student-friendly (USC, NYU, UW Seattle, Northeastern, BU, Tufts, etc.)

Each school records 40 fields, divided into 6 categories:

Category	Fields
Basic information	School name (Chinese and English), state, city, founding year, student population, student-faculty ratio
Rankings	US News National, US News Engineering, US News Business, QS World, THE
Admissions data	Overall acceptance rate, ED acceptance rate, EA acceptance rate, yield, demonstrated interest importance
Academic thresholds	SAT 25th / 50th / 75th, ACT 25th / 50th / 75th, GPA Middle 50%
Tuition / Aid	OOS tuition, room and board, Need-Blind / Need-Aware (international students), Avg Aid, Merit Aid scale
Tracks and geography	STEM Designated, IB / MBB target school, Pre-Med Acceptance Rate, Taiwanese community size, Asian student percentage, direct airport routes

Every year, we update the three most critical fields: (1) acceptance rate, (2) SAT median, and (3) tuition. These three fields change the fastest and have the greatest impact on school-list strategy.

2. Demo Student: Profile#

To make this demo concrete, I will use the profile of a real Dr. G. student (anonymized as “Student X”):

Item	Value
SAT	1500 (Math 780 / R&W 720)
GPA (unweighted)	3.92
Number of APs	7 courses (Calc BC, Physics C, Chem, CSA, Econ, Lit, World History)
TOEFL	112
Spike	Mechanical engineering / robotics: FRC captain for 3 years, completed MIT Beaver Works summer program, 2nd place nationally in Taiwan ROBOCUP
Fields of interest	Robotics, Aerospace Engineering, Mechanical Engineering
Family budget	USD $70K / year (including tuition, room and board, and flights; Merit Aid or Need-Based aid needed)
Geographic preference	West Coast or East Coast NYC / Boston; not deep Midwest (parents explicitly said “Wisconsin / Indiana are not under consideration”)
Special limitations	Not considering Pre-Med or Pre-Law; willing to commit to binding ED; TW community size is important

This is a typical Dr. G. student profile: strong spike, SAT above average but not extreme, budget-sensitive, and clear goals.

3. Step 1: First-Layer Filter — SAT Median ±50 (Finding Reach Candidates)#

Logic: Using the student’s SAT 1500 as the baseline, identify schools where the SAT 50th percentile falls between 1450 and 1550. This becomes the “Reach candidate pool.”

Operation: Run this filter in the DB:

SAT 50th percentile BETWEEN 1450 AND 1550
AND OOS tuition + room and board ≤ $90,000 (not filtered too strictly yet; we narrow it later)

152 schools → 35 Reach candidates:

#	School	SAT 50th	Overall acceptance rate	ED acceptance rate
1	MIT	1545	4.5%	EA only (12%)
2	Stanford	1540	4.0%	REA (8%)
3	Caltech	1545	6.0%	EA (10%)
4	Harvard	1550	3.6%	REA (7%)
5	Yale	1545	4.6%	SCEA (10%)
6	Princeton	1545	4.5%	SCEA (10%)
7	UPenn	1530	5.4%	ED (16%)
8	Duke	1530	5.0%	ED (16%)
9	Brown	1525	5.1%	ED (15%)
10	Northwestern	1520	7.0%	ED (24%)
11	Dartmouth	1520	5.4%	ED (19%)
12	Cornell	1500	7.5%	ED (19%)
13	JHU	1520	6.5%	ED (21%)
14	CMU	1530	11.0%	ED (19%)
15	Columbia	1540	4.0%	ED (12%)
16	UChicago	1535	5.4%	ED (13%)
17	UCLA	1455	9.0%	No ED
18	UC Berkeley	1465	11.0%	No ED
19	Vanderbilt	1520	6.7%	ED (17%)
20	WUSTL	1525	12.0%	ED (35%)
21	Rice	1510	8.0%	ED (15%)
22	Notre Dame	1500	11.0%	REA (19%)
23	Emory	1490	11.5%	ED (32%)
24	UMich	1480	17.0%	EA (30%)
25	USC	1470	12.0%	EA only
26	Georgetown	1475	12.0%	REA
27	Tufts	1490	10.0%	ED (30%)
28	NYU	1510	8.0%	ED (28%)
29	UNC	1450	17.0%	EA (30%)
30	UVA	1470	16.0%	EA (30%)
31	Wake Forest	1450	22.0%	ED (45%)
32	UCSD	1450	24.0%	No ED
33	UC Davis	1340	42.0%	No ED
34	Georgia Tech	1480	17.0%	EA (24%)
35	Boston College	1465	17.0%	ED (35%)

Kept: 35 schools Removed (SAT 50th < 1450 or > 1550): 117 schools

4. Step 2: Second-Layer Filter — SAT 75th < My SAT (Finding Safety Candidates)#

Logic: Identify schools where the SAT 75th percentile is below the student’s SAT (1500). For Student X, their SAT is already above the school’s top 25%, which means the admission odds are higher and the school may be a Match or Safety.

Operation:

SAT 75th percentile < 1500
AND overall acceptance rate > 25%
AND US News overall Top 50 or subject Top 30

From the 152 schools, we identify 28 Match / Safety candidates (to save space, 12 representative schools are listed):

#	School	SAT 75th	Overall acceptance rate	Engineering ranking
36	UIUC	1480	45%	Top 5
37	Purdue	1430	53%	Top 10
38	UT Austin	1490	30%	Top 10
39	UW Seattle	1430	53%	CSE Top 10
40	Penn State	1380	55%	Top 20
41	Ohio State	1430	53%	Top 30
42	Texas A&M	1390	63%	Top 15
43	Virginia Tech	1380	56%	Top 20
44	UMass Amherst	1420	65%	Top 30
45	UC Irvine	1430	21%	Top 30
46	UC Santa Barbara	1450	26%	Top 30
47	UCSD	1450	24%	Top 15

Step 1 + 2 total: 35 + 28 = 63 candidate schools.

5. Step 3: Third-Layer Filter — Need-Aware Status + Budget (Narrowing to Affordable Schools)#

Logic: Student X’s budget is $70K, but the average annual cost at top private universities is $85-90K. We must filter out:

• Need-Aware schools that do not give aid to international students
• Schools where OOS tuition + room and board exceeds $90K and Merit Aid is rare
• Schools that are clearly over budget with no Merit opportunity

Operation:

(Need-Blind for International = TRUE) OR
(OOS tuition + room and board ≤ $85K) OR
(probability of OOS Merit Aid > $20K/year at this school > 30%)

Removal logic:

School	Tuition + room and board	International student aid status	Keep / Remove
MIT	$87K	Need-Blind for Intl	✓ Keep
Stanford	$89K	Need-Aware (but generous)	✓ Keep
Harvard	$86K	Need-Blind for Intl	✓ Keep
Princeton	$84K	Need-Blind for Intl	✓ Keep
Yale	$87K	Need-Blind for Intl	✓ Keep
UPenn	$89K	Need-Aware (generous)	✓ Keep
Duke	$90K	Need-Aware (generous)	✓ Keep
Brown	$87K	Need-Aware (moderate)	△ Keep, but risky
Dartmouth	$86K	Need-Blind for Intl	✓ Keep
Cornell	$86K	Need-Aware (generous)	✓ Keep
Northwestern	$88K	Need-Aware (moderate)	△ Keep
JHU	$86K	Need-Aware (moderate)	△ Keep
WUSTL	$86K	Need-Aware + strong Merit Aid (Danforth $40K/year)	✓ Keep
Vanderbilt	$86K	Need-Aware + strong Merit Aid (Vanderbilt $80K/year)	✓ Keep
Rice	$80K	Need-Aware + lower tuition	✓ Keep
Notre Dame	$87K	Need-Aware (moderate)	△ Keep
Emory	$84K	Need-Aware + Merit Aid (Emory Scholar $40K/year)	✓ Keep
UMich	$85K (OOS)	Need-Aware + limited aid	✗ Remove (over budget)
USC	$90K	Need-Aware + Merit Aid (Presidential $40K/year)	✓ Keep
Tufts	$87K	Need-Aware (moderate)	△ Keep
NYU	$89K	Need-Aware + strong Merit Aid	✓ Keep
UCLA	$69K (OOS)	Need-Aware + limited aid	✓ Keep (just within budget)
UCB	$69K (OOS)	Need-Aware + limited aid	✓ Keep
UCSD	$66K (OOS)	Need-Aware + limited aid	✓ Keep
UC Davis	$66K (OOS)	Need-Aware + limited aid	✓ Keep
UIUC	$54K (OOS)	Limited Merit Aid but lower tuition	✓ Keep
Purdue	$42K (OOS)	More Merit Aid	✓ Keep
UT Austin	$58K (OOS)	Limited aid	✓ Keep
UW Seattle	$55K (OOS)	Limited Merit Aid	✓ Keep
Penn State	$54K (OOS)	More Merit Aid	✓ Keep
Ohio State	$53K (OOS)	More Merit Aid	✓ Keep
UC Irvine	$66K (OOS)	-	✓ Keep

Remaining candidates: about 35 schools (some marked △ are kept with budget-risk notes)

6. Step 4: Fourth-Layer Filter — Engineering Top 30 Subject Ranking#

Logic: Student X plans to major in Mechanical / Robotics / Aerospace. Overall ranking becomes secondary; engineering subject ranking is the real indicator of competitiveness.

Operation:

US News overall Engineering ranking Top 30
OR Mechanical Engineering ranking Top 30
OR Aerospace Engineering ranking Top 30

From the 35 schools, keep:

#	School	Overall Engineering ranking	ME ranking	AE ranking	Engineering friendliness
1	MIT	#1	#1	#1	✓✓✓
2	Stanford	#2	#2	#2	✓✓✓
3	UC Berkeley	#3	#3	#5	✓✓✓
4	Caltech	#4	#4	#3	✓✓✓
5	Georgia Tech	#5	#5	#4	✓✓✓
6	UIUC	#6	#5	#7	✓✓✓
7	UMich	#8	#6	#6	✓✓✓ (removed, budget)
8	Purdue	#9	#8	#8	✓✓✓
9	UT Austin	#10	#9	#9	✓✓✓
10	CMU	#6	#15	N/A	✓✓
11	Cornell	#11	#10	#12	✓✓✓
12	UCLA	#14	#12	#14	✓✓✓
13	UCSD	#15	#18	#18	✓✓
14	USC	#20	#20	#19	✓✓
15	UW Seattle	#25	#25	N/A	✓✓
16	Penn State	#27	#20	#20	✓✓
17	Virginia Tech	#28	#21	#21	✓✓
18	UCSB	#30	#28	#25	✓
19	UC Irvine	#35	N/A	N/A	△
-	NYU	#50	N/A	N/A	✗ Remove (weaker engineering)
-	WUSTL	#45	N/A	N/A	✗ Remove (weaker engineering)
-	Notre Dame	#45	N/A	N/A	✗ Remove

Remaining 18 candidate schools: MIT, Stanford, UCB, Caltech, Georgia Tech, UIUC, Purdue, UT Austin, CMU, Cornell, UCLA, UCSD, USC, UW Seattle, Penn State, Virginia Tech, UCSB, UC Irvine

7. Step 5: Manual Review — The Final Layer of Fit and Family Constraints#

After the DB filters the list down to 18 schools, the final step must be manual. The consultant and family narrow the list to 12 schools based on the following qualitative factors:

Qualitative Review Dimensions#

Dimension	Evaluation method
Geographic fit	Student X does not want the Midwest → remove Purdue (Indiana), UIUC (Illinois, but kept as an exception because engineering is too strong)
Campus culture fit	Student X likes hands-on engineering culture → favor MIT, CMU, Georgia Tech, Stanford
Taiwanese community	UCLA, UCB, USC, UW Seattle, Cornell, and CMU have larger Taiwanese student communities → bonus
ED leverage	Cornell has a strong ED boost → ED is most efficiently used here
Budget flexibility	Student X’s budget is $70K → public UC costs of $66-69K are the upper limit

Final 12-School Dream List#

#	School	Category	Application round	DB filtering logic
1	MIT	High Reach	EA	Engineering #1, Need-Blind
2	Stanford	High Reach	REA → main early application	Engineering #2, Need-Aware generous
3	Caltech	High Reach	EA	Engineering #4, within budget
4	Cornell Engineering	Reach	RD	ED already used on Stanford REA, so RD here
5	Georgia Tech	Reach	EA (10/15)	Engineering #5, EA advantage, tuition-friendly
6	CMU SCS / ECE	Reach	RD	Engineering #6, Need-Aware moderate
7	UC Berkeley	Reach	RD	Engineering #3, large Taiwanese community
8	UCLA	Match	RD	Engineering #14, within budget, TW community
9	Purdue Engineering	Match	EA	Engineering #9, Merit Aid opportunities
10	UIUC Engineering	Match	RD	Engineering #6, tuition $54K
11	UW Seattle CSE / ME	Safety	EA	Engineering Top 25, many Taiwanese students, within budget
12	Penn State Engineering	Safety	RD	Engineering Top 20, high Merit Aid, within budget

Reach / Match / Safety Ratio Check#

• High Reach: 3 schools (MIT, Stanford, Caltech)
• Reach: 4 schools (Cornell, Georgia Tech, CMU, UCB)
• Match: 3 schools (UCLA, Purdue, UIUC)
• Safety: 2 schools (UW Seattle, Penn State)

The 3-4-3-2 ratio matches the formula in The Golden 12-School Reach / Match / Safety Portfolio.

8. Why the DB Cannot Replace a Consultant: 3 Real Limitations#

The DB is powerful, but it has 3 structural limitations:

Limitation 1: The DB Does Not Understand “Essay Fit”#

The DB can tell you that “Stanford likes students with spikes,” but what kind of spike does Stanford like? In 2024, Stanford favored students who crossed humanities × tech (last year it admitted many “coded an app for refugee crisis” types). In 2025, the trend may shift toward “pure research depth.” This kind of year-to-year preference change is something only a consultant knows. The DB cannot capture it.

Limitation 2: The DB Does Not Understand “Hidden Family Conditions”#

Parents may say their “budget is $70K,” but the real budget may be $65K or $75K, depending on the RMB exchange rate and whether the parents are willing to touch retirement savings. The DB calculates “average numbers”; the consultant asks for the family’s real bottom line.

Limitation 3: The DB Does Not Understand “A Child’s Psychological Stability”#

The DB may tell you that Wisconsin Madison is a “structurally good Safety,” but Student X grew up in Kaohsiung, is afraid of cold weather, and fears isolation. The psychological cost of spending 4 years in Wisconsin cannot be calculated by the DB. That can only be judged through conversations among the consultant, student, and parents.

9. DB Usage SOP for Parents#

If you want to try using DB logic yourself (it does not have to be Dr. G.’s; you can build your own Excel), the SOP is:

1. Step one: Enter your child’s profile into a table (SAT, GPA, budget, spike, geographic preference, family limitations)
2. Step two: Use SAT 50th ±50 to filter Reach candidates (25-35 schools)
3. Step three: Use SAT 75th < my SAT to filter Safety candidates (20-30 schools)
4. Step four: Remove schools that exceed the budget and offer no Aid opportunities (leaving 30-40 schools)
5. Step five: Use subject ranking Top 30 to narrow the list to 15-20 schools
6. Step six: Manually review fit, family limitations, ED strategy, and psychological stability to finalize 12 schools

This SOP is 5 times more rational than “scrolling through US News rankings + reading popular College Confidential recommendations.”

But step six always requires a person. AI, DBs, and Excel cannot replace the judgment of “someone who understands your child.”

10. Conclusion: The DB Is a Tool; Final Judgment Belongs to People#

I have used the 152-school DB for 8 years. It has made school-listing 5 times more efficient, shortened family indecision from 4 months to 4 weeks, and reduced the risk of “full rejection” from 15% to under 2%.

But the DB will not tell you which school to choose in the end. It only narrows 152 options down to 12 reasonable ones. Among those 12, which school to choose for ED, how many schools to push for in RD, and where to enroll in the end are all outcomes of conversations among the consultant, family, and student.

My final line to every Dr. G. family is: “The DB is a map, not a guide.” The map shows you the terrain; the guide tells you which path fits you. No matter how accurate the map is, without a guide you can still take the wrong route. No matter how capable the guide is, without a map they can only rely on intuition.

You need both. That is the essence of Dr. G.’s consulting service: a 152-school DB plus a consultant who has seen 600 students.

As for Student X’s eventual enrollment outcome: he was rejected from Stanford REA in ED (reasonable, since Stanford REA offers limited advantage), admitted to Cornell Engineering in RD (with a late-RD hidden advantage because he had previously exchanged emails with a Cornell professor to show demonstrated interest), and ultimately enrolled in Cornell ME in April with $15K in Merit Aid. He applied to all 12 schools, was admitted to 5, and ultimately landed at his #1 fit school.

For the specific ratio logic behind DB filtering, pair this article with The Golden 12-School Reach / Match / Safety Portfolio. For school-selection logic by track, see Special School-Selection Logic for Engineering, Business Schools, and Pre-Med. For how ED is applied in DB filtering, see How to Choose Between ED vs EA vs RD.

Further reading:

• How to Allocate U.S. Reach / Match / Safety Schools
• How to Choose Between ED vs EA vs RD
• Should My Child Aim for the Ivy League?
• Special School-Selection Logic for Engineering Schools, Business Schools, and Pre-Med
• Why Schools Recommended on CC May Not Fit Taiwanese Families
• Complete Cornell Profile
• Complete UC Berkeley Profile