Cell2 · Extract
Application · Custom scoring rubric + thematic
Score one application essay and surface what it reveals
You are scoring ONE application essay against a frozen rubric. Rubric (score each 1-5; 1=no/contradicted evidence, 3=present but generic, 5=specific, vivid and verifiable): writing_quality, evidence_of_resilience, motivation_clarity, program_fit. Then extract up to 4 themes. Use only the essay text for {program_name}. Do not reward length or eloquence over evidence.
Schema: {writing_quality:1-5, evidence_of_resilience:1-5, motivation_clarity:1-5, program_fit:1-5, themes:[string], rationale_per_criterion:string}
Cell2 · Extract
Application · Custom rubric
Pre-screen an essay for integrity / red flags
Review ONE essay for evidence-based concerns only: internal contradictions, claims that cannot be supported by the rest of the application, and signals of possible non-authentic authorship. Report observations, not verdicts. Recommend human review where uncertain.
Schema: {concerns:[{type, observation, evidence_quote, confidence:low|med|high}], recommend_human_review:boolean}
Cell2 · Extract
Application · Extraction schema
Turn a resume into structured fields
Extract structured experience from ONE resume. Normalise dates to YYYY-MM. Do not infer titles or skills not stated. Mark gaps over 6 months.
Schema: {roles:[{title, org, start, end, summary}], education:[{credential, institution, year}], skills:[string], gaps:[string]}
Row3 · Score
Application · Custom multi-criteria rubric
Whole-record applicant fit assessment
Read the ENTIRE record for {applicant_id} and produce one fit score against the program rubric. Criteria & weights: academic_readiness {w}, demonstrated_need {w}, program_fit {w}, leadership_potential {w}, resilience {w}. Weight, combine, and explain how each field contributed. You validate evidence; you do not invent scores beyond what the record supports.
Schema: {fit_score:0-5, criteria:[{name, score, weight, citation}], reasoning_trace:string, reviewer_override:null}
Row3 · Score
Application · Rules checklist
Eligibility & completeness gate
Check record {applicant_id} against eligibility rules: {rule_list}. Return pass/fail per rule and an overall completeness status. List any missing required documents.
Schema: {eligible:boolean, rules:[{rule, status:pass|fail|unclear, evidence}], missing_docs:[string]}
Column4 · Theme
Application · Thematic
What motivates and blocks our applicants
Across ALL responses to {question} for cohort {cohort}, identify recurring themes. Name each theme, define it, count responses, attach 2 representative quotes, and keep an other bucket. Report prevalence as count and %.
Schema: {themes:[{name, definition, count, pct, quotes:[string]}], other_count:int, n_total:int}
Grid5 · Compare
Application · Comparative
Cohort-over-cohort applicant quality & mix
Compare cohorts {cohort_a} vs {cohort_b} on: mean fit_score, score distribution, demographic mix ({dimensions}), and top motivation themes. Report deltas and flag any shift that may signal an access or outreach issue.
Schema: {by_cohort:[{cohort, n, mean_fit, distribution, demographics, top_themes}], deltas:{...}, flags:[string]}
Row3 · Score
Scholarship · Custom rubric
Need + merit composite award score
Score applicant {id} on a frozen need+merit rubric. Merit criteria (1-5): academic_merit, leadership, essay_strength. Need criteria (1-5): financial_need, barrier_severity, first_gen_status. Combine using weights {merit_w}/{need_w}. Explain each.
Schema: {merit:{...}, need:{...}, composite:0-5, citations:[...], reviewer_override:null}
Cell2 · Extract
Scholarship · Extraction
Structure a financial-need narrative
From ONE need narrative, extract structured need indicators: household_dependents, income_band (as stated), disruptions, prior_aid, unmet_need_signals. Do not estimate income not stated.
Schema: {household_dependents:int|null, income_band:string|null, disruptions:[string], prior_aid:string|null, unmet_need_signals:[string]}
Column4 · Theme
Scholarship · Thematic
Aspiration & field-of-study landscape
Across all {question} responses, cluster intended fields and aspirations. Name clusters, count, attach quotes, and note any underrepresented field worth targeted recruitment.
Schema: {clusters:[{name, count, pct, quotes}], underrepresented:[string], n_total:int}
Grid5 · Compare
Scholarship · Comparative
Award equity audit
Compare applicant pool vs awarded pool across {dimensions}. Report selection rate by subgroup and flag disparities over {threshold} for human review. Describe, do not adjudicate.
Schema: {by_subgroup:[{group, applied_n, awarded_n, rate}], disparities:[{group, gap, flag}], note:string}
Grid5 · Compare
Scholarship · Longitudinal
Alumni outcome tracking by award cohort
For award cohort {cohort}, link alumni follow-up to original records by stakeholder ID. Report completion, employment/further-study status, and confidence change pre to alumni. Note non-respondents.
Schema: {n_awarded:int, n_responded:int, completion_rate, outcome_breakdown, confidence_delta, nonrespondents:int}
Cell2 · Extract
Essay & Proposal · Custom rubric
Score a long essay with section anchors
Score ONE long essay against frozen criteria (1-5 each): thesis_clarity, argument_evidence, structure, originality, mechanics. Score the WHOLE piece, not the first page. Give a section-level note for intro / body / conclusion.
Schema: {scores:{...}, section_notes:{intro, body, conclusion}, overall:0-5}
Cell2 · Extract
Essay & Proposal · Theory of Change
Extract a Theory of Change from a large proposal
From ONE proposal, extract ToC components: problem, target_population, inputs, activities, outputs, short/medium/long_outcomes, assumptions, external_factors. Mark each MISSING / WEAK / STRONG and flag any activity with no linked outcome.
Schema: {components:[{name, strength:MISSING|WEAK|STRONG, evidence}], logic_gaps:[string]}
Row3 · Score
Essay & Proposal · Custom rubric
Whole-proposal quality assessment
Assess proposal {id} across: problem_significance, approach_feasibility, evidence_base, budget_realism, expected_impact, team_capacity (1-5, weighted {weights}). Produce one quality score + a 5-line reviewer brief.
Schema: {criteria:[{name, score, weight, citation}], quality_score:0-5, reviewer_brief:string}
Cell6 · Report
Essay & Proposal · Summarisation w/ citations
One-page reviewer brief from a long proposal
Condense ONE proposal into a one-page brief: ask, problem, approach, outcomes claimed, budget, 3 strengths, 3 risks. Every line cites its source page.
Schema: {ask, problem, approach, outcomes_claimed, budget, strengths:[3], risks:[3]} with page refs
Column4 · Theme
Essay & Proposal · Thematic
Strengths & weaknesses across a proposal pool
Across all proposals in round {round}, identify the most common strengths and weaknesses. Name, count, quote. Separate fixable in resubmission from fundamental.
Schema: {strengths:[{name,count,quote}], weaknesses:[{name,count,quote,fixable:boolean}], n:int}
Cell2 · Extract
Training & Vocational · Kirkpatrick L1
Code Level-1 reaction feedback
From ONE learner post-course feedback, extract Kirkpatrick Level-1 signals: satisfaction (1-5 if stated/derivable), perceived_relevance, perceived_difficulty, and improvement_suggestions. Do not infer satisfaction if absent.
Schema: {satisfaction:1-5|null, relevance:string, difficulty:string, suggestions:[string]}
Column4 · Theme
Training & Vocational · Kirkpatrick L1 + thematic
Level-1 drivers across a cohort
Across all learners in {cohort}, find the top drivers of satisfaction and dissatisfaction. Name, count, quote. Tie suggestions to specific course modules where named.
Schema: {drivers_pos:[{theme,count,quote}], drivers_neg:[{theme,count,quote}], module_flags:[string], n:int}
Grid5 · Compare
Training & Vocational · Kirkpatrick L2
Level-2 learning: pre/post knowledge change
For cohort {cohort}, compute knowledge/confidence change per learner by joining pre and post on stakeholder ID. Report per-learner delta, cohort mean delta, and % who improved. Flag learners with no post record.
Schema: {per_learner:[{id, pre, post, delta}], mean_delta, pct_improved, missing_post:[id]}
Grid5 · Compare
Training & Vocational · Kirkpatrick L3
Level-3 behavior: on-the-job application
For cohort {cohort}, assess behavior change from the 90-day follow-up: self-reported application + manager-observed application of {skills}. Triangulate the two sources and report agreement. Flag skills not being applied.
Schema: {by_skill:[{skill, self_score, manager_score, agreement, applied:boolean}], barriers:[string]}
Grid5 · Compare
Training & Vocational · Kirkpatrick L4
Level-4 results: link behavior to outcomes
For cohort {cohort}, relate L3 behavior to outcome metric {metric} (e.g. placement, wage gain, productivity). Report the association descriptively, state the counterfactual limit, and avoid causal claims without a comparison group.
Schema: {behavior_summary, outcome_summary, association:string, counterfactual_note, confidence:low|med|high}
Row3 · Score
Training & Vocational · Vocational competency framework
Competency alignment to a skills standard
Assess trainee {id} against the {standard} competency framework. For each competency, rate not_yet / emerging / proficient with evidence from assessments, projects, or mentor notes. Identify the gap to proficient.
Schema: {competencies:[{name, level, evidence}], gaps:[string], overall_readiness:string}
Cell1 · Define
Training & Vocational · Kirkpatrick
Map a survey to Kirkpatrick levels
Tag each question in {survey} with the Kirkpatrick level it measures (L1-L4) or none. Flag levels with no coverage and propose one question to fill each gap.
Schema: {questions:[{q, level:L1-L4|none}], uncovered_levels:[string], proposed:[{level, question}]}
Cell2 · Extract
Mentorship & LMS · Extraction + thematic
Structure a mentor session note
From ONE session note, extract: topics_discussed, mentee_goals_progress, blockers, action_items, relationship_quality_signal (positive/neutral/strained with evidence). Do not infer emotion not expressed.
Schema: {topics:[string], progress:string, blockers:[string], actions:[string], relationship_signal:{value, evidence}}
Grid5 · Compare
Mentorship & LMS · Longitudinal
Mentee growth trajectory across sessions
For mentee {id}, trace progress across all sessions in date order. Summarise trajectory on {goal_areas}, note momentum (improving/flat/declining), and surface unresolved blockers carried 3+ sessions.
Schema: {timeline:[{date, summary}], trajectory_by_goal:{...}, momentum:string, stale_blockers:[string]}
Cell2 · Extract
Mentorship & LMS · Competency tagging
Extract learning evidence from an LMS reflection
From ONE reflection, identify demonstrated learning and tag to {competency_set}. Rate evidence depth (surface/applied/transfer). Flag misconceptions.
Schema: {demonstrated:[{competency, depth, quote}], misconceptions:[string]}
Grid5 · Compare
Mentorship & LMS · Mixed quant+qual
Engagement-to-outcome patterns in an LMS
Across cohort {cohort}, relate engagement signals ({signals}: logins, completion, time-on-task) to learning outcomes. Describe patterns (e.g. which behavior precedes mastery) without claiming causation. Identify at-risk profiles.
Schema: {patterns:[string], at_risk_profile:string, outcome_by_engagement_band:[{band, outcome}]}
Row3 · Score
Mentorship & LMS · Custom rubric
Mentor-mentee fit / risk read
For pair {pair_id}, assess fit and risk from all notes: meeting_consistency, goal_alignment, rapport, escalation_flags. Recommend continue / re-match / human review.
Schema: {fit_score:1-5, factors:[{name, value, evidence}], escalations:[string], recommendation:enum}
Cell2 · Extract
Case Intelligence · Extraction
Structure one case-manager note
From ONE case note for {client_id}, extract: presenting_needs, progress_since_last, services_provided, risks_or_concerns, next_steps, stage_of_change (precontemplation to maintenance, if derivable). Describe only what is written.
Schema: {needs:[string], progress:string, services:[string], risks:[string], next_steps:[string], stage_of_change:string|null}
Cell2 · Extract
Case Intelligence · Risk triage
Surface a safeguarding / risk flag
Scan ONE note for explicit risk indicators ({indicators}: harm, crisis, disclosure). If present, quote it, rate urgency (monitor / follow-up / urgent), and mark recommend_human_review=true. If none, say so.
Schema: {flags:[{indicator, quote, urgency}], recommend_human_review:boolean}
Row3 · Score
Case Intelligence · Stage-of-change / domains
Holistic client status across the record
For client {id}, synthesise current status across {life_domains} (e.g. housing, employment, wellbeing, education). Rate each domain (at-risk / stabilising / thriving) with evidence and date, and note the single most pressing need.
Schema: {domains:[{name, status, evidence, as_of}], top_priority:string}