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

Published on May 14, 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:

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"):

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:

152 schools → 35 Reach candidates:

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:

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

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:

Removal logic:

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:

From the 35 schools, keep:

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

Final 12-School Dream List

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