Using the 152-School Dr. G. DB to Build Your Dream List: A Complete Practical Demo (2026)
Published on May 14, 2026
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:
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 |
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 |
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:
unknown node152 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 |
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:
unknown nodeFrom 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 |
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:
unknown nodeRemoval 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 |
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:
unknown nodeFrom the 35 schools, keep:
# | School | Overall Engineering ranking | ME ranking | AE ranking | Engineering friendliness |
|---|---|---|---|---|---|
1 | MIT | #1 | #1 | #1 | ✓✓✓ |
2 | Stanford | #2 | #2 | #2 | ✓✓✓ |
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 |
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:
- Step one: Enter your child's profile into a table (SAT, GPA, budget, spike, geographic preference, family limitations)
- Step two: Use SAT 50th ±50 to filter Reach candidates (25-35 schools)
- Step three: Use SAT 75th < my SAT to filter Safety candidates (20-30 schools)
- Step four: Remove schools that exceed the budget and offer no Aid opportunities (leaving 30-40 schools)
- Step five: Use subject ranking Top 30 to narrow the list to 15-20 schools
- 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
