Client cases Case 09

VIC Education: from essay review to admissions readiness, one system for the whole application season

VIC Education essay review and progress system

Professional servicesCustom system

VIC Education essay review and progress system logo
  • Industry

    US college admissions consulting
  • Services

    Workflow interviews, system planning, interface design, development, university data, Google Docs integration, permissions and auditing
  • Type

    Internal system in daily use, 28 pages, on desktop and phone
  • Result

    Essays, admissions progress, parent updates and internal auditing in one system

Background

VIC Education helps Taiwanese students apply to universities in the US, the UK and Canada. Essays take the most time in an application season: the Common App personal statement, four UC Personal Insight Questions, school supplements, and the activities and awards list. One student can have more than ten essays in a season, each revised several times.

In the first phase we brought essay review, deadlines and parent updates into one system. Once it was in use, the consultants raised the next question: essays are only part of an application. How far along each student is with grades, tests and activities, and what is still missing for their target schools, still lived in separate spreadsheets. The second phase extended the system across grades 9 to 12, and added a family portal, spreadsheet import and internal auditing, so the whole season runs in one place.

Blank Design handled both phases end to end, from workflow interviews and system planning to interface design and development. The system is in daily use.

The challenge

We walked through one student's journey with the consultants, from signing up to submitting applications, and found five sticking points:

Sticking point How it was done What went wrong
Essay review Word, shared folders, LINE groups Feedback style depended on the person; versions and approvals weren't recorded
Deadlines Each consultant's own spreadsheet No one could see who was holding how many essays, or which were due soon
Readiness A consultant's experience When parents asked "is my child ready?", answers weren't consistent or easy to explain
Data entry One entry at a time Typing four years of grades and activities for one student took half an hour
Accounts and security Shared logins, forwarded files No record of who saw or changed what; most students are minors

One principle was not negotiable: the system must not write essays for students or replace a consultant's judgment. Readiness is the same. It can say what is missing against published standards, never present itself as a chance of admission.

Site structure

The system has 28 pages built around the essay board. From the board you upload or import essays, open each essay's review page, or move to students, progress, universities, the activity library and team management. Students and parents have a separate portal that shows only their own data.

Site structure28 pagesGetting inSign inJoin by invite onlyOnboarding ×6 stepsEssay board01 Status counts02 Upcoming deadlines03 Workload04 Drag-and-drop board05 Search and filtersUpload› Three essay typesImport› PDF, Excel, photosEssay page› Review› Directions› Version compare› Parent updateDeadlines› School deadlinesStudents› Student profileProgress› Readiness› Records› Plan› Family accessOverview› All students by readinessUniversities› 223, search as you type› Team-added schoolsActivity library› Matched by city and gapsTeam playbook› Coverage, guidesMembers & roles› Three roles, invite onlyAudit log› Filter and exportSettings› Style, deadline rulesStudent & parent portal› Home, records, plan› Suggested activitiesPrivacy and termsPriority set by deadline · Comment-by-comment approval · Any spreadsheet imported · Chinese and English · Mobile bottom bar
Site structure28 pagesGetting inSign inJoin by invite onlyOnboarding ×6 stepsEssay board01 Status counts02 Upcoming deadlines03 Workload04 Drag-and-drop board05 Search and filtersUpload› Three essay typesImport› PDF, Excel, photosEssay page› Review› Directions› Version compare› Parent updateDeadlines› School deadlinesStudents› Student profileProgress› Readiness› Records› Plan› Family accessOverview› All students by readinessUniversities› 223, search as you type› Team-added schoolsActivity library› Matched by city and gapsTeam playbook› Coverage, guidesMembers & roles› Three roles, invite onlyAudit log› Filter and exportSettings› Style, deadline rulesStudent & parent portal› Home, records, plan› Suggested activitiesPrivacy and termsPriority set by deadlineComment-by-comment approvalAny spreadsheet importedChinese and English · Mobile bottom bar
Diagram. Twenty-eight pages built around the essay board

The solution

The system runs along two lines. The first is essays: after upload, the system drafts feedback in the team's style, consultants decide on each comment, and approved work goes to the student in one click while parents get a progress update.

01Upload an essayPrompt and deadline set02Draft in team styleComments and edits03Consultant approvesUnapproved stays out04Student and parentsGoogle Doc + update
01Upload an essayPrompt and deadline set02Draft in team styleComments and edits03Consultant approvesUnapproved stays out04Student and parentsGoogle Doc + update
Diagram. The essay line: from upload to student and parents

The second is admissions progress: once grades, tests and activities come in, they are scored against each target university's published standards, the gaps are listed, and the work goes into the application plan, which the student updates and parents can check at any time.

01Records come inBy hand, file, or student02Scored per schoolFixed rules, not odds03What is missingGaps ranked, ideas offered04Into the planStudents edit, parents view
01Records come inBy hand, file, or student02Scored per schoolFixed rules, not odds03What is missingGaps ranked, ideas offered04Into the planStudents edit, parents view
Diagram. The progress line: from records to the application plan

Under those two lines, every feature falls into one of these themes:

Theme Problem it solves Main features
Essay review Inconsistent feedback, mixed-up versions Three essay types, comment-by-comment approval, Google Docs export, parent updates, team playbook
Deadlines and board No overall view of progress Drag-and-drop board, internal deadlines worked out automatically, workload
Progress and readiness Not knowing what is missing Grades and GPA, tests, activities, readiness and gaps per university
Application plan Scattered to-dos, unclear owners Five tracks, owner, due date, overdue flags
Universities and activity library Hours spent looking things up 223 US, Canadian and UK universities, search as you type, team-uploaded schools, a team-built activity library with suggestions
Spreadsheet import Typing entries one by one Any Excel or CSV, columns and categories recognised, sheets sorted automatically, row-by-row preview
Student and parent portal Parents asking for updates Invite-only accounts, students update their own record, parents read only
Internal monitoring and security No record of who did what Audit log, members and roles

Desktop

The first screen after signing in is the essay board. At the top are counts for uploaded, in progress, done, past internal deadline and awaiting review; in the middle, upcoming internal deadlines and each consultant's workload; below, a three-column board. Drag a card from Uploaded to In progress to Done and the status and counts update at once. The side menu is grouped into essays, admissions and management, so a manager can see progress without asking around.

Essay board with five status counts, upcoming internal deadlines and consultant workload
Essay board on a phone, status counts in two columns and a fixed bottom bar
Essay board: status counts, upcoming deadlines and workload on one screen

Phone

Consultants check progress on the go, and students and parents use almost nothing but their phones, so every screen was laid out again for the phone rather than shrunk. Navigation moves to a fixed bottom bar with a "+" in the middle for uploading; comments, readiness and to-dos become cards with buttons within thumb reach; the upload window slides up from the bottom.

Key design decisions

Theme 1. Essay review: the system drafts, the consultant decides

An upload starts with one of three types: Common App, UC PIQ, or activities and awards. The prompt, word limit and the school's official deadline fill in automatically; a new version of the same prompt for the same student is numbered V1, V2 and so on.

Upload page with three type cards: Common App, UC PIQ, activities and awards
Upload page on a phone, type cards stacked
Upload: each type brings its own prompts, word limits and deadlines

The system drafts in the review style the team wrote down: questioning inline comments, edits that only touch the student's own sentences, an overall comment, and notes in Chinese for the consultant only. Each item must be approved, edited then approved, or deleted. Nothing unapproved reaches the student, and the reviewer and time are recorded. When review is done, one click creates a Google Doc with every comment and suggestion in place.

Review screen with the essay preview on the left and comments with approve buttons on the right
Review screen on a phone, comment cards and approve buttons stacked
Review: the essay on the left, each comment approved, edited or removed on the right

Internal deadlines aren't typed in. They are worked back from each school's official deadline, leaving time for revisions. Overdue items show in red and safe ones in green, and official deadlines can be looked up alongside.

Deadlines page with internal deadlines by month and an official deadline lookup
Deadlines page on a phone
Deadlines: internal dates worked back from official ones, overdue and safe at a glance

Theme 2. Progress and readiness: published standards, plain answers

Every student has a grade 9 to 12 record. School grades can be entered as letters (A-), percentages (93) or on a 4.0 scale; the system works out unweighted and weighted GPA, the average and the number of advanced courses. Tests cover SAT, ACT, TOEFL, IELTS (with all four bands), Duolingo, AP and IB. Activities record category, role, level, grades and hours.

Student record: unweighted and weighted GPA, average and advanced courses, with grades listed by year
Student record on a phone
Record: GPA and advanced courses calculated as grades go in

Readiness compares that record with the published standards of every university the student tracks, and gives a percentage from 0 to 100 with one of three bands: on target, close, or still building. We deliberately did not use machine learning to predict admission. Fixed rules mean consultants can follow every point and explain it to parents; each score can be expanded, and the screen states plainly that it is not a chance of admission.

Readiness: one card per university with a percentage, a band and what is missing
Readiness on a phone
Readiness: a percentage for each university, and exactly what is missing

US, UK and Canadian admissions work differently, so the rules are separate:

Country Compared against Special handling
US GPA and course rigor, SAT/ACT middle 50%, English minimum, activities and awards Each school's test policy (required, optional, test-blind) decides whether scores count
UK Each university's AP, SAT or GPA entry routes Checked route by route as the university publishes them
Canada Grade 11 and 12 average against the minimum Where no figure is published, a guideline by selectivity is used

English scores are compared on each test's own scale rather than converted, and IELTS band minimums are checked separately. When there is too little data (say fewer than four courses, or no English score), the percentage is capped at 60% with a note that the record is incomplete, so parents don't get false comfort.

Theme 3. Application plan: an owner and a date for everything

Based on each student's gaps, consultants plan work in five tracks: academics, testing, activities, school list and essays. Every item has an owner (student, consultant or parent) and a due date. Overdue items show in red; students tick off their own items in the portal and the team sees it straight away.

Application plan: each item shows its track, owner, status and due date
Application plan on a phone
Plan: five tracks, each item with an owner and a due date

Theme 4. Universities and the activity library: less time looking things up

The university database covers 223 universities in the US, Canada and the UK: admit rate, SAT middle 50%, English minimum, test policy, deadlines and programs, each with its source. With nothing typed, schools are listed alphabetically; keep scrolling to load every one.

Data Source Updated
US admit rates, SAT/ACT, programs US Department of Education College Scorecard Each new application cycle
US test policies Each university's admissions pages Source link kept for every entry
UK entry routes, Canadian averages Each university's admissions pages Source link kept for every entry

Search is what consultants do most, so we redesigned how it works:

  • Results as you type. No search button; results update with every letter.
  • Abbreviations and short names. UCLA, UC Davis, NYU, MIT, UBC and UCL all work; type "uc" and the nine University of California campuses come first.
  • Names before programs. The best matches on English name, Chinese name and abbreviation come first, then the rest alphabetically. Program names only count from three letters on, so "uc" doesn't pull in every Education degree.
  • Partial Chinese names work too, such as 加州大學洛杉磯.
Typed Found
uc The nine University of California campuses first
UCLA, UC Davis That campus, first
NYU, MIT, UBC New York University, MIT, University of British Columbia
加州大學洛杉磯 UCLA
computer Schools with computing programs
University database: after typing "uc", the University of California campuses come first
University database on a phone
Universities: results as you type, with abbreviations like UCLA and NYU

For schools beyond the built-in data, such as art schools or less common choices, owners and admins can upload their own from Excel or CSV: name, country, admit rate, SAT, test policy, English minimum, deadline and programs. Uploaded schools are visible only to that company, marked "Added by your team", and work like built-in ones for search, tracking and readiness; names that match a built-in school are skipped.

Uploading universities: a row-by-row preview, existing schools skipped and an out-of-range admit rate flagged
Uploading universities on a phone
University upload: the team adds schools beyond the built-in list

Each university has its own page with its standards and sources, and can be added to a student's readiness tracking from there.

University page: admit rate, SAT middle 50%, English minimum and deadlines, with a button to track it for a student
University page on a phone
University page: standards, deadlines and sources together, tracked for a student in one click

The activity library is built by the team: volunteering, competitions, camps and research opportunities, each with city, the areas it helps, suitable grades and sign-up deadline. The system suggests activities by the student's city and readiness gaps; a student short on leadership sees activities with leadership roles first. Suggestions use fixed rules and call no outside service, so they add no cost.

Activity library: each activity with organizer, city, areas it helps and sign-up deadline
Activity library on a phone
Activity library: built by the team, matched to each student's city and gaps

Theme 5. Spreadsheet import: no more typing one entry at a time

Grades, tests, activities, the application plan, the activity library and universities can all be uploaded as Excel, CSV or tab-separated files, with no need to reformat them to a template first. A transcript from a parent or a consultant's own activity list goes in as it is: each column is recognised by its name and contents, and a missing category is worked out from the row. After upload every row is previewed: rows ready to import show in green, and problem rows say which column, which value, and what is accepted. Nothing is saved until you confirm.

Upload window: template downloads at the top, rows marked ready, already on file or with problems below
Upload window on a phone, sliding up from the bottom
Import: a preview first, with a clear reason for every row

Uploads on the student record sort themselves: a workbook with Grades, Tests and Activities sheets has each sheet recognised and imported into the right place in one go.

A workbook with three sheets, recognised as grades, test scores and activities
Sorted automatically on a phone
Sorted automatically: three sheets in one file, read as grades, tests and activities

The activity library works the same way. A list that ignores the template, with columns called Activity, Host, Where and Deadline and categories like Contest or Volunteering that the system doesn't list, is still read correctly; category and focus areas are worked out from the activity's name and marked "worked out from the row" in the preview.

A self-made activity list, with columns recognised and category, focus and city worked out
Recognised automatically on a phone
Recognised automatically: columns by name and contents, missing categories from the activity itself

How files are read:

In the file What the system does
Columns named Event name, Host, Where, 截止日 Mapped to activity, organizer, city and sign-up deadline
No column names, just data Columns recognised by contents: dates, links, cities, grade levels, marks and scores
Dates like 2027/4/1, 15 Apr 2027, 2027年5月2日 All read as the same date format
Grades written 10, G10 or 高二 All read as a grade level
No category, activity called Youth Robotics Challenge Read as a competition, focus STEM
A sheet called Tests holding TOEFL 104 Read as test scores, test TOEFL
A Big5 CSV saved by Excel on Chinese Windows Converted to correct Chinese

What matters in the design:

  • No template needed. Column names in English or Chinese, in any order, with a title row above if you like; the template is still there for anyone who prefers it.
  • The same checks as adding by hand. Score ranges, date formats and required fields are just as strict, so a file is no back door.
  • Repeats are skipped. Uploading the same file twice doesn't double the data.
  • Fixed rules, no outside services. Results are predictable and cost nothing extra; every value the system works out is marked in the preview before anything is saved.

Theme 6. Student and parent portal: parents no longer need to ask

Students and parents each have their own account and a separate portal. Students update their own grades, tests and activities and tick off their own to-dos; parents can only view. Neither sees draft feedback, consultants' notes to each other or internal remarks.

Student portal home: readiness for each target university and what is missing
Student portal on a phone, with Home, Record, Plan and Activities tabs at the bottom
Student portal: their own readiness, record and to-dos, nothing internal

Only owners and admins can open these accounts, and only after parental consent is recorded on the student's profile. Each invite link works once, and a removed account stops working immediately.

Family tab: active accounts and the form for opening one
Family tab on a phone
Family access: opened only by owners and admins, after consent is recorded

The next phase adds automated reminders, so consultants no longer send them one by one. Every day the system checks each student for missing items and for tasks that are due soon or overdue, and turns them into one list. Students get it by email; parents get it on LINE once they follow the agency's official account and link their child. The content follows fixed rules, the same item is never sent twice, and consultants can see who received what, and when.

01Daily checkMissing, due, overdue02One list per studentFixed rules, no repeats03Email to studentsWhat's missing, by when03LINE to parentsFollow and link a child04Logged for the teamWho got what, and when
01Daily checkMissing, due, overdue02One list per studentFixed rules, no repeats03Email to studentsWhat's missing, by when03LINE to parentsFollow and link a child04Logged for the teamWho got what, and when
Automated reminders (next phase): email to students, LINE to parents

Theme 7. Overview: who needs attention, at a glance

All students sorted by their lowest readiness, with the ones who need attention first, alongside overdue to-dos and family account status. A manager looks at this page before a meeting and knows which students to discuss first.

Progress overview: one row per student with lowest and highest readiness, to-dos and family accounts
Progress overview on a phone
Overview: the students who need attention come first

Admin and operations: internal monitoring and security

Most students are minors, and the system holds grades, contact details and essays. Security was designed in from day one rather than added later.

Only invited people get in

There is no public sign-up. Team members can only be invited by an owner or admin; student and parent accounts can only be opened by an owner or admin; new company accounts are limited to designated email addresses. What each role can do:

FullPartialNoneActionOwnerAdminConsultantStudentParentInvite team membersIncl. adminsConsultants onlyNoNoNoOpen family loginsNeeds consentNeeds consentNoNoNoReview and approveAll essaysAll essaysOwn casesNo draftsNo draftsEdit grades, testsAll studentsAll studentsOwn studentsOwn recordRead onlyEdit the planAll studentsAll studentsOwn studentsTick own tasksRead onlySee readinessAll studentsAll studentsOwn studentsOwnTheir childSpreadsheet importAll studentsAll studentsOwn studentsOwn recordNoUpload universitiesWhole companyWhole companyNoNoNoAudit log, exportAllAllNoNoNoDelete studentsYesNoNoNoNo
FullPartialNoneOwnerAdminConsult.StudentParentInvite teammembersOpen familyloginsReview andapproveEdit grades,tests, activitiesEdit theplanSee readinessand suggestionsSpreadsheetimportUploaduniversitiesAudit log,exportDeletestudents
Diagram. Five roles: filled is full access, half-filled is limited, empty is none

Members and roles

Members join through invite links. Managers can change roles, remove members and hand over their cases. Admins can only invite and manage consultants; changes to admins and owners are for owners alone.

Members and roles: member list, roles and the form for adding a member
Members and roles on a phone
Members and roles: owner, admin and consultant, joining by invite

Audit log

Every sign-in, upload, review, export, import, account opening and data change is logged, and can be filtered by member, student, action and date and exported as CSV. No one can edit or delete log entries, owners included.

Audit log: every action by every member in time order, with filters and export above
Audit log on a phone
Audit log: who did what and when, filtered and exported

Other security measures

  • Each company's data is kept apart and every query is limited to it. Student and parent sign-in is fully separate from team sign-in and can never pass a team permission check.
  • The Google connection only gets access to files the system itself creates, nothing else in Drive.
  • All input is validated, uploads have size and row limits, and invites, uploads and imports are rate-limited against abuse.
  • Unit tests and desktop and phone browser tests run before every release, and nothing ships if they fail. After release, front-end errors and slow pages are reported to the admin side.

What Blank Design did

VIC Education needed What Blank Design did
Feedback in one consistent team style Read the consultants' reviewed essays and turned them into review rules; the system drafts by those rules and consultants approve each comment
No essay writing for students Feedback is drafted for consultants only, edits only touch the student's sentences, and nothing unapproved goes out
Parents want to know if their child is ready Transparent readiness rules against each school's published standards, stated plainly as not a chance of admission
Looking up standards takes hours Published data for 223 US, Canadian and UK universities, each with its source, refreshed every year; search as you type, with abbreviations
Schools they apply to aren't in the list Owners and admins upload their own, which get readiness just like built-in schools
Typing entries one by one is slow Any Excel or CSV in its own format, columns and categories recognised automatically, previewed before saving
Only invited people may use it Invite-only access, role permissions, consent records and single-use invite links
Problems must be traceable An audit log no one can alter, with filters and export
Consultants, students and parents all use phones Every screen laid out again for the phone, and every change checked at phone size
No extra running costs Readiness, suggestions and import run on fixed rules and call no paid service

Results

  • Essays, admissions progress, the application plan, parent communication and internal auditing in one 28-page system
  • Feedback drafted first and approved comment by comment, in one team style; nothing unapproved goes out
  • Every student checked against their target universities' published standards, with readiness and concrete gaps
  • Admission standards for 223 US, Canadian and UK universities in one place, each with its source; search as you type, and schools outside the list can be uploaded
  • Grades, tests, activities, the plan, the activity library and universities importable from Excel or CSV
  • A separate portal for students and parents, invite-only access, and every action logged
  • Fully usable on desktop and phone, with a guided tour for new members

Advice for education and consulting businesses

Tutoring centers, admissions consultancies and consulting teams of every kind: your expertise is the most valuable thing you have, and time spent tidying up is the most wasted. Before building a system, ask:

  1. Is the same task repeated every week, with fixed steps? That work suits a system best.
  2. Is your team's method written down? A system can only fix a method in place if the method exists.
  3. Which decisions must stay with people? Draw that line first, and the system helps instead of getting in the way.
  4. Who needs to see what? List what managers, consultants, students and parents each need, and permissions can be right from day one.

To see how we plan and price internal systems, read about custom web design, or the article on how admissions consultancies can track student readiness.

Next caseLijia Accounting & TaxGet a quote