Skip to main content
EDU-03 · Education

Student Services Navigator

Outcome​

Give the student advisor a grounded view of a student's academic standing, degree progress, holds, financial aid deadlines and support referrals so intervention conversations start from verified policy and record rather than from memory.

Portfolio attributeValue
Primary personaStudent advisor
Primary aggregateStudentSupportCase
Cosmos DB containers2
Grounding datarecords, policies, services, cases, deadlines
Development estimateUSD 60-220 monthly dev estimate
Runtime optionsPython FastAPI and C# ASP.NET Core

Productivity hypothesis​

These measures reflect the workflow, evidence, decision boundary, and industry risk for this use case.

Impact typeMeasureConservative internal assumptionCustomer measurement
ProductivityCase navigation time10-18% reduction(baseline median case-navigation minutes - assisted median minutes) / baseline median minutes * 100
Quality or riskRework rate3-8% reduction(baseline reopened or corrected case rate - assisted rate) / baseline rate * 100

Important: Conservative internal pilot assumptions only; not public benchmarks, commitments, or expected customer results. Validate against a comparable baseline or matched control cohort with mandatory human review.

Rationale: Policies, services, records, cases, and deadlines can be assembled faster into reviewable next steps.

Pilot guardrail: Eligibility, case determinations, record updates, and consequential actions remain staff-owned.

Customer validation plan​

  1. Baseline the current workflow with representative users and tasks.
  2. Run the accelerator on the same task mix with human review retained.
  3. Measure case navigation time and rework rate with the documented formulas.
  4. Replace internal assumptions with customer-observed results before a business case.

Why Azure Cosmos DB​

This AI solution needs an operational data plane, not only a vector index:

  • Hybrid vector and full-text retrieval combines semantic recall with exact identifiers, codes, names, and domain language.
  • Hierarchical partition keys and metadata predicates keep tenant and domain boundaries in the normal query path.
  • Operational JSON, source chunks, workflow and agent state, feedback, and audit records remain together for low-latency reads and governed writes.
  • Change feed reacts to source and operational updates without polling.
  • Autoscale throughput, configurable consistency, and multi-region distribution support variable demand and enterprise availability.

Domain workflow​

Domain workflow

StageActorInput → outputApproval
1. Risk signal aggregationEarly-alert aggregatorStudentRecord → riskProfilePolicy controlled
2. Degree progress reconciliationDegree audit connectorDegreeRequirement → progressGapSetPolicy controlled
3. Policy and deadline groundingStudent services navigatorprogressGapSet → PolicyChunkPolicy controlled
4. Intervention plan draftingStudent services navigatorPolicyChunk → InterventionPlanPolicy controlled
5. Advisor confirmation and referral releaseStudent advisorInterventionPlan → confirmedReferralHuman required

Technical architecture​

Technical architecture

Cosmos DB data model​

ContainerHierarchical partition keyDocumentsSearch paths
studentSupportCases/tenantId, /studentIdStudentRecord, DegreeRequirement, AdvisingInteraction, InterventionPlan/rationaleVectorEmbedding, /rationaleVector
academicCatalogLibrary/tenantId, /catalogYearPolicyChunk/chunkVectorEmbedding, /chunkVector

Query contract​

QueryContainerScopePurpose
AdvisorCaseloadAtRiskstudentSupportCasescross-partition-boundedList students on the advisor's caseload whose standing or holds indicate immediate outreach. Intentional cross-partition advisor worklist: bounded by the tenantId prefix, one advisor's assignment and the at-risk academic standings.
UnsatisfiedDegreeRequirementsstudentSupportCasessingle-partitionShow which requirement groups still block graduation for the student's catalog year.
CatalogYearPolicyRetrievalacademicCatalogLibrarysingle-partitionRetrieve only the policy text governing this student's catalog year and question.
AdvisingHistoryForHandoffstudentSupportCasessingle-partitionReturn the cited advising history when a case transfers to another advisor or an appeal is filed.

Python and C# services route each document type to its declared container and hierarchical partition key. ETag-based writes protect mutable aggregates, while append-only records and bounded cross-partition queries preserve scale.

Azure deployment​

Azure deployment

Clone the source repository, authenticate with Azure, and run:

Set-Location accelerators/education/student-services-navigator
az login
./Deploy.ps1 -Runtime python -Location eastus2

Change python to csharp to deploy the .NET implementation.

Explore the implementation​

Return to all accelerators