play icon for videos
← Academy
SOPACT ACADEMY · CASE INTELLIGENCE · COLLECT

How Do You Design an Intake Form for a Baseline?

Build intake questions that capture a usable starting point, preserve participant context and match later observations. Includes a field worksheet and baseline checks.

<aside class="ci-wizard" aria-label="Case Intelligence course navigator"><div class="ci-wiz-eyebrow">Case Intelligence course</div><p class="ci-wiz-sub">Foundation, participant practice and placement. Includes two shared lessons.</p><p class="ci-progress-label">This is lesson 5 of 13.</p><details><summary>Foundation</summary><ol class="ci-steps"><li class="ci-step"><a href="https://www.sopact.com/academy/what-is-case-intelligence"><span class="ci-num">1</span><span class="ci-step-title">What is Case Intelligence?</span></a></li><li class="ci-step"><a href="https://www.sopact.com/academy/how-to-build-a-theory-of-change"><span class="ci-num">2</span><span class="ci-step-title">Build a theory of change · shared lesson</span></a></li><li class="ci-step"><a href="https://www.sopact.com/academy/theory-of-change-to-data-collection-workflow"><span class="ci-num">3</span><span class="ci-step-title">Turn outcomes into a collection plan</span></a></li></ol></details><details open><summary>Participant practice</summary><ol class="ci-steps"><li class="ci-step"><a href="https://www.sopact.com/academy/review-applications-without-reviewer-bias"><span class="ci-num">4</span><span class="ci-step-title">Application review · optional shared lesson</span></a></li><li class="ci-step is-active"><a href="https://www.sopact.com/academy/intake-form-usable-baseline" aria-current="page"><span class="ci-num">5</span><span class="ci-step-title">Capture a usable baseline</span></a></li><li class="ci-step"><a href="https://www.sopact.com/academy/spot-at-risk-participants-mid-program"><span class="ci-num">6</span><span class="ci-step-title">Review mid-program support needs</span></a></li><li class="ci-step"><a href="https://www.sopact.com/academy/measure-change-at-exit"><span class="ci-num">7</span><span class="ci-step-title">Measure change at exit</span></a></li><li class="ci-step"><a href="https://www.sopact.com/academy/mentor-notes-early-warning"><span class="ci-num">8</span><span class="ci-step-title">Use mentor notes for support review</span></a></li><li class="ci-step"><a href="https://www.sopact.com/academy/calculate-sroi-live"><span class="ci-num">9</span><span class="ci-step-title">Maintain an SROI calculation · optional</span></a></li><li class="ci-step"><a href="https://www.sopact.com/academy/job-training-grant-impact-report"><span class="ci-num">10</span><span class="ci-step-title">Report training outcomes to funders</span></a></li></ol></details><details><summary>Placement practice</summary><ol class="ci-steps"><li class="ci-step"><a href="https://www.sopact.com/academy/job-description-requirements-checklist"><span class="ci-num">11</span><span class="ci-step-title">Clarify employer requirements</span></a></li><li class="ci-step"><a href="https://www.sopact.com/academy/score-candidate-role-matches-without-bias"><span class="ci-num">12</span><span class="ci-step-title">Review candidate–role evidence</span></a></li><li class="ci-step"><a href="https://www.sopact.com/academy/job-placement-investor-impact-report"><span class="ci-num">13</span><span class="ci-step-title">Report placements to investors</span></a></li></ol></details><a class="ci-next" href="https://www.sopact.com/academy/spot-at-risk-participants-mid-program">Continue the course →</a></aside><style>.ci-wizard{box-sizing:border-box;color:#48416A;background:#FFFFFF;border:1px solid #DCCEF4;border-radius:12px;padding:20px;font:16px/1.5 Inter,Arial,sans-serif}.ci-wizard *{box-sizing:border-box}.ci-wiz-eyebrow{font-size:18px;font-weight:700}.ci-wiz-sub,.ci-progress-label{font-size:14px;margin:8px 0 12px}.ci-wizard details{border-top:1px solid #DCCEF4;padding:12px 0}.ci-wizard summary{cursor:pointer;font-weight:700;padding:6px 0}.ci-steps{list-style:none;padding:0;margin:12px 0 0}.ci-step{margin:0 0 8px}.ci-step a{display:flex;gap:10px;padding:10px;border-radius:8px;color:#48416A;text-decoration:none}.ci-step a:hover,.ci-step.is-active a{background:#F6F0FF}.ci-step.is-active a{border-left:3px solid #48416A;font-weight:700}.ci-num{min-width:24px;flex:0 0 24px}.ci-step-title{display:block;font-size:15px;line-height:1.5}.ci-wizard a:focus-visible,.ci-wizard summary:focus-visible{outline:3px solid #8D8AE8;outline-offset:3px}.ci-next{display:block;margin-top:16px;padding:12px;background:#48416A;color:#FFFFFF;text-align:center;border-radius:8px;font-size:15px;text-decoration:none}</style>
Sopact Academy · Course review

Academy / Case intelligence / Deep dive

Practical Academy guide

How Do You Design an Intake Form for a Baseline?

To design an intake form for a usable baseline, start with the outcomes you will check later. Define the starting measures, collect them before the relevant services begin, and link each observation to the right participant and enrollment. Keep question wording, scales, dates and source records so you can judge whether later answers are comparable. Registration details, support needs and baseline measures serve different purposes; your form should make those purposes clear.

Additional course links

By Sopact Academy · Updated September 12, 2026. Figures and participant examples in this lesson are fictional.

This lesson is for training, coaching, fellowship and service teams building intake from an agreed collection plan. Bring the measure-and-source plan from the related lesson, your application form and the proposed follow-up questions. Leave with a field list, a baseline-reuse decision and a check of each planned comparison.

Practical outcome: a short intake form that captures the required starting observations and enough context to plan support. A matched record makes comparison possible; it does not make a causal impact claim true.

Build the baseline in four steps

  1. Define the starting observations required for the outcomes.
  2. Check which application answers can be reused or need updating.
  3. Keep structured answers and narrative context linked to their sources.
  4. Test baseline and follow-up questions together before launch.

This lesson uses a fictional training cohort to connect intake, mid-program check-ins and exit. If your process includes selection, application review is a separate decision. Do not assume the answers used to select a participant are automatically suitable for measuring their starting situation.

You can design and test the form in a document or spreadsheet. A connected platform helps collect repeated submissions, retain source material and apply configured analysis. Review the form with the people who will complete it as well as the staff who will interpret the answers.

What makes an intake answer a usable baseline?

Picture reporting season. The exit survey says confidence averages 7.4. The funder asks the obvious question: up from what? To interpret that number as change, you need a compatible starting measure. Repeating an appropriate question and scale is one way to get it; a justified mapping from another instrument may also work. Registration details alone cannot supply a missing confidence baseline, and a dictionary cannot turn an incompatible measure into one. The program can still report what it observed at exit while stating what change cannot be assessed.

An intake form can capture necessary registration details without measuring a starting outcome. That is a design gap only when the team needs to assess change in that outcome later. Give each field a purpose: enrollment, service planning, outcome measurement, a reporting requirement or another explicit decision.

Registration identifies the enrollment; a baseline records the relevant starting condition. Some characteristics also change and need dated updates. Store a stable participant identifier separately from contact details and the program enrollment. Email addresses can change or be shared; use them for contact or carefully checked matching rather than assuming they are permanent unique identities.

Step 1 — Define the starting observation

For each planned outcome, define the minimum useful starting observations. A skill outcome may need an assessment rather than a confidence score. Employment quality may need employment status, hours, wage and stability. If an established instrument is appropriate, follow its guidance rather than replacing it with a convenient homemade scale. Name the later collection moment and what comparison you expect to make.

Paste this into any AI:

Prompt

Here are the outcomes, population and collection plan: [paste them]. Propose baseline questions only where a starting observation is needed. For each, state the construct, wording, response scale, timing, follow-up question, source and missing-data treatment. Identify existing instruments that require expert review; do not invent validation. Flag questions that may be sensitive or affected by selection. Explain how each answer will inform a decision.

Keep comparisons interpretable. Preserve wording and scales where the same construct is measured, and document justified instrument changes. Choose open questions for the context you need; there is no universal two-question limit. Ask about goals and barriers when they support the program, but avoid requesting sensitive detail without a clear use and appropriate access arrangements.

Step 2 — Decide what to reuse from the application

Review the application before adding another form. Reuse an answer only if it was collected at the right time, remains current, measures the required construct and can be linked correctly. Some answers need confirmation after admission, when the purpose is support planning rather than selection. Keep both dated observations if circumstances changed.

Prompt

Here are my current questions and baseline requirements: [paste both]. Mark each proposed field REUSE, VERIFY or ADD, with reasons covering timing, wording, scale, population and purpose. Identify duplicated questions, but do not remove operational or required fields without an owner checking them. Use a stable internal participant identifier plus an enrollment identifier; do not require an email address as the only way to join records.

A separate intake can confirm changed circumstances and collect information deliberately excluded from selection. If an applicant reported $14 per hour in July and $15 in September, the answers may both be correct. Keep the dates, identify which observation represents the program start, and ask for clarification only when needed.

Step 3 — Keep narrative answers alongside the measures

Keep the original answer when coding narrative text into categories. In a configured Sopact workflow, analysis can prepare themes and source references as submissions arrive. Treat suggested categories as aids for staff review, particularly when wording is ambiguous, translated or sensitive. Confirm any notification or routing behavior during setup; do not treat AI classification as an emergency-response service.

What that looks like for one arriving record:

Fictional example · one intake record prepared for staff review
What arrivedSuggested interpretation to check
"My car finally died and the bus only runs twice a day; daycare runs $180 a week I don't have"Transport one possible theme, childcare and financial as additional possible themes — each pinned to the participant's exact words
Confidence self-rating — 3.6 on 1–10Retain as this person’s starting self-rating with its question and date; repeat a suitable measure only where the comparison needs it
"Support my kids without working two jobs"Possible goal about supporting the family with less pressure from multiple jobs; confirm the participant’s meaning before coding or assessing attainment
Whole recordSuggested staff review SUPPORT DISCUSSION — staff confirm transport and childcare needs before agreeing a referral
Read it: a reported barrier is a reason to ask about support, not a prediction of dropout. Staff confirm the situation and record the agreed action.

The example contains several possible barriers: transport, childcare and affordability. A classification should retain the quote and allow more than one theme. Staff ask what support the person wants and record what was agreed. A barrier is not a prediction that the person will leave the program, and a tag does not mean a referral has happened.

Step 4 — Test the before-and-after pairs

Check the form and planned follow-up instruments together. This can be done manually if the reviewer has the questions and definitions. A software-assisted check is useful only when the relevant versions are available to it. Test identity matching, timing, wording, scales and missing values before collecting a full cohort.

  • "List every baseline measure and the wave that re-asks it" — the pairs your change claims will stand on.
  • "Flag any measure with no later wave" — check whether a later observation is needed for the intended comparison; retain fields with other legitimate uses.
  • "Flag any later measure with no baseline" — identify where a starting observation is required; an exit-only measure may still answer a different question.
  • "Confirm every record carries the persistent ID" — check matching along with timing, definitions and missing answers
The audit · every before-number checked against its later wave
Baseline measureLater waveSame scale?Verdict
Confidence, 1–10Mid and exit, same wordingYesSeparate fictional matched-record example: 4.3 → 7.1 → 7.4; check question, timing and coverage
Hourly wage, $/hrSix-month follow-upYesPotential wage comparison: $9.96 → $25.11; check currency, gross/net basis, work context and observation dates
Public assistance, Y/NSix-month follow-upYesComparable yes/no wording may describe status; retain eligibility and policy context before interpreting change
Skill self-rating, 1–5Exit asks skills as 0–100NoFLAGGED scale drift — no comparable pair
Read it: the FLAGGED row needs a comparability decision. Correct the instrument before collection where possible, and document any limits after collection.

A mismatch found before launch may be straightforward to correct. After collection, changing the scale label does not make different questions equivalent. Preserve the original observations and document whether a defensible comparison is possible. The figures in the example are fictional and do not establish improvement or causation; the audit checks comparability, not program effectiveness.

Common mistakes

Confusing registration with baseline. Keep registration fields that serve a real purpose, then add suitable starting observations where you need to examine change. Not every outcome needs a self-rating, and qualitative baseline information can be useful when collected systematically.

Changing the instrument without a plan. Record versions and assess comparability. A justified change may improve measurement, but do not conceal it or compare raw values as though nothing changed.

Reusing an old answer without checking it. Reduce needless repetition while allowing participants to update changed circumstances. Retain the observation date and distinguish a correction from a new observation.

Collecting narrative answers without a review owner. Decide who reads or checks the classifications, how quickly they should respond, and how an agreed action is recorded.

Relying on email alone. Use a stable participant ID and an enrollment ID. Keep duplicate resolution and correction procedures; an unlinked record may be recoverable, but should not be silently assigned to a guessed person.

What you have now

You now have fields with named purposes, dated starting observations, contextual questions that support decisions and a record-matching plan. Keep an audit of the proposed follow-up questions and assign a reviewer to unresolved mismatches. This supports a later comparison without promising that the comparison alone demonstrates impact.

The one thing to do this week

Test one outcome end to end this week. Ask two colleagues to interpret three de-identified sample records using your definitions. If they select different baseline dates or disagree about missing answers, fix those rules before adding more questions. Then test the form with a representative participant and record where the wording or navigation caused difficulty.

Intake form worksheet: specify each field before building it

This fictional training-program worksheet illustrates the design choices. Adapt the measures to your program; the confidence item is not a validated assessment of skill.

FieldPurpose and questionHandling rule
Participant and enrollment IDsLink this submission to the person and program episodeAssigned by the system or staff; check duplicates without exposing internal identifiers unnecessarily
Observation dateWhen does this answer describe the participant?Distinguish the observation date from the date staff entered it
Current employmentAre you currently doing paid work? Yes / No / Prefer not to answerConfirm the program’s employment definition and record missing or declined answers separately
Hourly wage, if applicableWhat is your usual gross hourly rate in the specified currency?State units; handle salaried or variable work explicitly rather than guessing a rate
Job-search confidenceHow confident do you feel about carrying out the job-search tasks described by this program?Use the same explained scale at follow-up; self-report is distinct from demonstrated competence
Support contextWhat could make participation difficult, and what support would you like to discuss?Explain who reviews it and provide another way to discuss sensitive needs
Contact preferenceHow may the team contact you about this program?Separate contact details from the stable participant ID; allow updates

Make the form usable before asking people to complete it

The W3C forms tutorial recommends clear labels, instructions and feedback, and avoiding unnecessary questions. Show which fields are required in words, explain units and provide helpful error messages. Test keyboard navigation and mobile completion. Do not use a placeholder as the only field label.

Explain what the data will be used for, who can access it and how a person can correct an answer. Decide which sensitive fields can be optional and how staff handle requests for help. A required question with no suitable answer option can force inaccurate data.

Watch how baseline and follow-up records connect

4 minutes 13 seconds · Sopact demonstration using synthetic training records.

▶ Play: Training Program Data

Watch on YouTube · Browse the video library

Frequently asked questions

Can an application form serve as the intake baseline?

Sometimes. Check that the answer was collected before the relevant services, remains appropriate for the starting point and uses comparable wording and scales. Selection incentives and changed circumstances may justify confirmation at intake. Preserve dates rather than automatically replacing one answer with another.

Is an email address a reliable participant identifier?

It is useful contact information, but it may change or be shared. Use a stable internal participant identifier, with separate program enrollments and dated observations. Confirm matching and duplicates rather than treating the same email as proof of the same person.

Must every baseline measure be a number?

No. A structured description, observation or interview can document starting conditions when the method fits the question. Define how it will be collected and compared. A numeric self-rating should not be substituted for evidence of a different construct just because it is easy to chart.

What if the baseline is missing?

Mark it missing and assess whether existing dated records provide a suitable alternative. Do not infer a past answer from a later result. Report the limitations and the number of participants with comparable observations. Plan better collection for the next cycle.

Can we change questions after the program starts?

Yes when there is a reason, but save the original version and explain the change. Determine whether comparisons remain defensible. Adding a new question does not retroactively create a baseline for earlier participants.

Does a matched pre-and-post record prove impact?

It can describe observed change for the matched participants. Other influences, who responded and how outcomes were measured still matter. Use an evaluation design appropriate to any causal claim and report missing follow-up clearly.

Next in the series: How to Spot At-Risk Participants Mid-Program — the baseline you just captured becomes the reference line, and the mid-program wave reads every record against it while the team can still adjust support.

Return to your course →

Put this guide into practice.

Bring your intake form and planned follow-up questions. Check how the records can stay connected with Sopact.

Explore Case Management →
Prepare Data Governance Before Using AI
Prepare your data governance
nonprofit-data-governance-before-ai
Feedback
Foundation
Prepare an evidence register and a tested governance baseline before applying AI to program data.
How to Turn Findings into Action and Check What Changes
The Loop — the method in one read
the-loop
Loop
The method
0
One continuous method for reliable, traceable AI reporting across case, application, grant, and program workflows: collect clean, analyze on arrival, and improve in time.
For growing data collection, connected analysis and recurring reporting
What Is Case Intelligence?
What Is Case Intelligence?
what-is-case-intelligence
Case
Foundation
1
One current, traceable record for each person—connecting intake, services, notes, surveys, documents, outcomes, decisions, and follow-up.
Workforce and training · Youth and mentoring · Case management · Scholarships · Accelerators · Education · Nonprofit programs
What is grant intelligence?
What Is Grant Intelligence?
what-is-grant-intelligence
Grant
Foundation
1
One connected evidence record from application and committee review through the awarded grant, grantee reporting, renewal, and board accountability.
Foundations and grantmakers · Public grant programs · Scholarships and fellowships · Accelerators
Connected Data Intelligence
Understand the approach
connected-data-intelligence
Feedback
Foundation
1
Connect recurring collection, relevant history, AI analysis, and governance in a workflow your team can maintain.
Growing organizations managing recurring data collection without a dedicated data team.
Measurement and Reporting: From Agreement to Evidence-Based Report
Measurement and reporting: from agreement to report
embedded-impact-measurement
Reporting
Start here
1
Turn the onboarding call into a reporting agreement, share one data dictionary, and write reports funders can compare and check.
For funders and the organizations they fund
Connect company context before collecting another return
Connect context
track-investees-impact-agreement-variance
Portfolio
Portfolio intelligence tools
1
Build a repeatable collect, review and improve cycle
Methodology — continuous, not annual
loop-methodology
Loop
The method
1
The continuous collect–analyze–improve cycle, adopted as an experiment: start with the step that already pays and add one data-collection step at a time.
Teams tired of rebuilding spreadsheets and forms who want a measurement system that compounds instead of resetting.
Agree the theory of change and core metrics on the onboarding call
Agree measures
onboard-portfolio-lock-impact-agreement-track-results
Portfolio
Portfolio intelligence tools
2
Test whether an AI-assisted result is repeatable and correct
Reliability — test repeatability and accuracy
loop-reliability
Loop
The method
2
Test repeatability and accuracy using versioned data, defined calculations, known-answer checks and human review of qualitative interpretation.
Teams that need to check recurring AI-assisted analysis before using it in decisions or reports.
Design an application process around the decision, not the form
Design an Application Process
how-to-design-an-application-process
Grant
Foundation
2
How to Structure Stakeholder Data: Four Common Patterns
Choose your record structure
which-shape-is-your-data
Feedback
Foundation
2
Map the people, observations and relationships your workflow needs before collecting data.
Turn the onboarding call into a reporting agreement
Turn the onboarding call into a reporting agreement
onboarding-call-to-reporting-agreement
Reporting
Agree together
2
How to build a theory of change, then show it as a logic model, logframe or results framework
How to build a theory of change, then show it as a logic model, logframe or results framework
how-to-build-a-theory-of-change
Reporting
Agree together
3
How to Build a Logic Model: Steps, Example and AI Prompt
Build a Logic Model You Can Use
how-to-build-a-logic-model
Reporting
Align
3
How do you onboard a grant or RFP program?
Onboard a Grant or RFP Program
how-to-onboard-a-grant-rfp-program
Grant
Foundation
3
Turn your theory of change into a data-collection plan
Turn a Theory of Change into a Data-Collection Workflow
theory-of-change-to-data-collection-workflow
Case
Foundation
3
Run quarterly collection around each company's dictionary
Collect quarterly
collect-investee-reporting-without-burden
Portfolio
Portfolio intelligence tools
3
Keep a clear trail from a finding to its evidence
Traceability & Transparency
loop-traceability
Loop
The method
3
Every figure links back to the exact response, note, or document it came from — a full audit trail from headline result to raw evidence.
Teams whose numbers get scrutinized — by funders, boards, auditors, or standards — and who need to answer where did this come from on the spot.
Build Context: What Your AI Needs to Know
Build context
build-organization-evidence-model
Feedback
Foundation
3
How to Change Survey Questions Without Losing Comparability
Change questions with a clear history
change-questions-without-breaking-the-record
Feedback
Control
3
Create a question-change log and decide how old and new versions should appear in reports.
Programme & MEL leads · Teams whose questionnaire has ossified · Anyone evaluating a platform where configuration is a purchased service
Five Dimensions of Impact: How to Review Your Evidence
Use the Five Dimensions to Test the Evidence
five-dimensions-of-impact
Reporting
Align
4
How do you design a grant rubric and eligibility rules?
Design Your Rubric & Eligibility Rules
grant-rubric-eligibility-rules
Grant
Foundation
4
Review impact and financial evidence before it reaches the dashboard
Review and approve
read-investee-reports-multi-signal
Portfolio
Portfolio intelligence tools
4
Adapt the learning cycle to your workflow
Flexibility — one method, four workflows
loop-flexibility
Loop
The method
4
The same collect–analyze–improve cycle, shaped to four kinds of impact work — case, grant, portfolio, and feedback — each shown end to end.
Anyone deciding where the Loop fits their work, who wants to see the full path from messy input to a report they can defend.
How to Collect Feedback Offline and Keep Records Connected
Collect offline and reconcile the batch
collect-feedback-offline
Feedback
Connect
4
Build a field protocol and reconcile a test batch across devices, visits and delayed uploads.
Field & multi-site programs · Low-connectivity contexts · Nonprofits collecting in person
How Do You Design an Intake Form for a Baseline?
Design an Intake Form That Captures a Usable Baseline
intake-form-usable-baseline
Case
Nonprofit Track
5
Turn a proposed outcome into a reporting definition
Outcomes vs Outputs
frame-outcomes-over-outputs
Grant
Foundation
5
Plan and review your first workflow pilot
Plan and review your first workflow pilot
loop-guarantee
Loop
The method
5
How to Analyze Documents as Evidence: Sources, Context and Review
Read documents as traceable evidence
read-documents-as-evidence
Feedback
Connect
5
Create a document register and reviewed findings with source locations, context and explicit exceptions.
Check each partner report against the agreement
Check each partner report against the agreement
check-partner-reports-against-agreement
Reporting
Funder road
5
Combine compatible metrics and explain every portfolio total
Build rollups
portfolio-impact-rollups
Portfolio
Portfolio intelligence tools
5
How to Clean Open-Ended Survey Responses Without Losing Meaning
Clean responses and define the denominator
clean-open-ended-survey-responses
Feedback
Clean
6
Create a cleaning log, response-status table and reproducible report statement.
How to Review Participant Support Needs Mid-Program
Spot At-Risk Participants Mid-Program
spot-at-risk-participants-mid-program
Case
Nonprofit Track
6
How to Write a Nonprofit Grant Application: Template and Example
Grant Application for Nonprofits
grant-application-for-nonprofit-organizations
Grant
Foundation
6
Personalize quarterly donor and annual LP reports
Report with evidence
portfolio-lp-board-impact-report
Portfolio
Portfolio intelligence tools
6
How to Build a Funder Context Profile: Research to Reporting
Build a Sourced Funder Context Profile
build-funder-context-profile
Reporting
Align
6
Roll up and benchmark portfolio results
Roll up and benchmark portfolio results
roll-up-and-benchmark-portfolio-results
Reporting
Funder road
6
How Do You Measure Change at Exit?
Measure Change at Exit (Not Just Completion)
measure-change-at-exit
Case
Nonprofit Track
7
How do you collect applications clean at the source?
Collect Applications Clean at the Source
collect-applications-clean-at-source
Grant
Collect
7
Turn portfolio findings into action and test the next cycle
Act and improve
portfolio-risk-monitoring-alerts
Portfolio
Portfolio intelligence tools
7
How to Analyze Multilingual Feedback Without Losing Meaning
Analyze and review multilingual feedback
analyze-multilingual-feedback
Feedback
Clean
7
Build a language review sheet and test software on original responses, translations, codes and reporting bases.
Multi-country programs · Multilingual survey data · Global networks & chapters
How to Define Impact Metrics Your Team and Funder Can Use
Define Measures the Organization and Funder Can Both Use
define-impact-metrics-funders-want
Reporting
Align
7
Write the portfolio report for your board or donors
Write the portfolio report for your board or donors
write-the-portfolio-report
Reporting
Funder road
7
Survey Attrition: How to Track Missing Waves in Longitudinal Studies
Track missing waves and matched outcomes
survey-attrition-longitudinal-studies
Feedback
Read
8
Build a wave-status register, compare response groups and report paired change with coverage and limitations.
How to Use Mentor Notes to Review Participant Support
Use mentor notes for support review
mentor-notes-early-warning
Case
Nonprofit Track
8
How do you reduce applicant burden?
Reduce Applicant Burden
reduce-applicant-burden-auto-clarification
Grant
Collect
8
Impact Metric Definitions: A Practical Worksheet and Example
Give Every Number One Definition
one-definition-for-every-number
Reporting
Define
8
Map every funder's ask to one evidence base
Map every funder's ask to one evidence base
turn-reporting-requirements-into-evidence
Reporting
Funded partner road
8
How to Connect Quantitative and Qualitative Survey Data
Connect scores and comments
connect-quantitative-qualitative-survey-data
Feedback
Read
9
Build a linked analysis view and joint display, with clear groups, reporting bases and evidence limits.
How to Calculate SROI as New Evidence Arrives
Calculate SROI — Live, Sourced, and Honest
calculate-sroi-live
Case
Nonprofit Track
9
How to Collect Grantee Reports with Less Burden
Collect Grantee Reports Without Burden
collect-grantee-reporting-without-burden
Grant
Collect
9
Capture each funder's taste, and your own
Capture each funder's taste, and your own
capture-funder-taste
Reporting
Funded partner road
9
How to Analyze Pre, Mid and Post Survey Data
Analyze pre, mid and post surveys
analyze-pre-mid-post-survey-data
Feedback
Read
10
Build a matched pre/mid/post analysis, interpret score movement and retain clear rules for missing waves.
How to Report a Job-Training Program to Grant Funders
Turn a Cohort into a Funder Impact Report
job-training-grant-impact-report
Case
Nonprofit Track
10
How to Follow Up on Missing Grantee Data
Chase Missing Grantee Data
chase-missing-grantee-data
Grant
Collect
10
How to Collect Clean Data Inside Your Workflow
Collect Clean Evidence Inside the Workflow
collect-clean-data-at-the-source
Reporting
Embed
10
Write each funder's report with AI, then check it
Write each funder's report with AI, then check it
assistant-writes-the-funder-report
Reporting
Funded partner road
10
Draft from approved sources, check the claims, and save an accountable report version. Bring the brief from the previous lesson.
Program managers, grant leads and reporting teams
How to Analyze Longitudinal Survey Data
Analyze longitudinal survey data
analyze-longitudinal-survey-data
Feedback
Read
11
Build a continuing analysis record with clear time scales, observed trajectories and limits.
How to Turn a Job Description into a Requirements Checklist
Clarify employer requirements
job-description-requirements-checklist
Case
Social Enterprise Track
11
Review applications without reviewer bias: one rubric, read on arrival, people decide
Review Without Reviewer Bias
review-applications-without-reviewer-bias
Grant
Analyze
11
How to Keep Impact Reporting Numbers Consistent
Get Stable Results From Governed Data
same-numbers-every-time
Reporting
Read
11
Compare your results with outside data: live queries and public datasets
Compare your results with outside data: live queries and public datasets
compare-with-outside-data
Reporting
Toolkit
11
How do you analyze a batch of grant applications?
Analyze a Whole Round
how-to-analyze-a-batch-of-grant-applications
Grant
Analyze
12
How to Measure Outcome Duration and Drop-Off
Measure outcome duration and drop-off
measure-outcome-duration-drop-off
Feedback
Read
12
Build a dated outcome claim, distinguish missingness from outcome loss and test forecast assumptions.
How to Score Candidate–Role Matches with a Clear Rubric
Review candidate–role evidence
score-candidate-role-matches-without-bias
Case
Social Enterprise Track
12
Make every number in your report match its source
Make every number in your report match its source
where-every-number-came-from
Reporting
Toolkit
12
How to Report Job Placements to Impact Investors
Turn a Cohort into a Social-Enterprise Investor Report
job-placement-investor-impact-report
Case
Social Enterprise Track
13
How do you track reviewer conflicts of interest?
Track Reviewer Conflicts of Interest
track-conflicts-of-interest-audit
Grant
Analyze
13
How to Write a Donor Report: Format, Evidence and Example
Design a Report for a Real Funding Decision
donor-report-funders-trust
Reporting
Decide
13
Build a report brief and claim-and-evidence table before drafting. Explain delivery, outcomes, spending, limitations and next actions.
Program managers, grant leads and reporting teams
How to put a credible dollar value on your results
How to put a credible dollar value on your results
credible-dollar-value-on-impact
Reporting
Toolkit
13
Prepare a valuation brief. Decide what the evidence supports, what needs more work, and when an outcome account is enough.
Program, evaluation and investment teams considering social-value estimates
AI Data Access Controls: What Your Assistant May See
Control what the assistant can access
what-the-assistant-may-see
Feedback
Prove
13
Define task-specific access, test synthetic records and verify report-sharing boundaries.
How to calculate the SROI ratio, step by step: value map, financial proxies and adjustments
How to calculate the SROI ratio, step by step: value map, financial proxies and adjustments
how-to-calculate-the-sroi-ratio
Reporting
Toolkit
14
Build a reproducible SROI calculation, test its assumptions and explain the result in a reviewed report.
Evaluation and reporting teams reviewing an SROI calculation
How to Write an Evidence-Based Impact Narrative for a Funder Report
Write a cited impact narrative
impact-narrative-funder-report-cited
Feedback
Prove
14
Build and check a report paragraph using a claim-and-source table, appropriate quotations and clear limitations.
How Do You Read a Grantee Report?
Read a Grantee Report
read-grantee-report-multi-signal
Grant
Analyze
14
How Do You Compute Grantee Variance?
Compute Grantee Variance
how-to-compute-grantee-variance
Grant
Analyze
15
Keep a person’s history connected across programs and staff changes
Follow one person over time
one-person-followed-for-years
Feedback
Shapes
15
Build a participant record that preserves episodes, dates, versions and missingness across repeated collection.
How Do You Build an SROI Value Map?
Build an SROI Value Map
how-to-build-an-sroi-value-map
Reporting
Optional method
16
Build a first value map, keep missing evidence visible, and give each unresolved outcome a next action.
Evaluation, program and investment teams preparing an SROI analysis
How do you track budget, invoices and actual spend for a grant?
Track Budget vs Actual Spend
how-to-track-budget-invoices-actual-spend
Grant
Analyze
16
Multi-Rater Feedback: Connect Perspectives and Protect Context
Connect several perspectives on one person
several-people-describing-one-person
Feedback
Shapes
16
Design subject-rater relationships, reporting rules and a tested multi-perspective feedback record.
How Do You Pick a Financial Proxy for SROI?
Pick a Defensible Financial Proxy
how-to-pick-a-financial-proxy-for-sroi
Reporting
Optional method
17
Compare candidate valuation sources and document why one fits your outcome, stakeholder and reporting period.
Evaluation and reporting teams selecting financial proxies
How Do You Analyze Grantee Reporting Longitudinally?
Analyze Grantee Reporting Over Time
analyze-grantee-reporting-longitudinal
Grant
Analyze
17
Cross-Program Reporting: Combine Results Without Losing Meaning
Combine evidence across programs
many-programs-one-picture
Feedback
Shapes
17
Build a defensible cross-program result with comparable measures, correct denominators and documented exclusions.
How to read Form 990 for a grant review
Read a 990 for Compliance
how-to-read-a-990-for-compliance
Grant
Analyze
18
Pick One Question. Keep Every System You Have.
Run a member-network survey
member-network-survey
Feedback
Shapes
18
Design and test a member reporting cycle with continuing records, coverage checks and authorized results.
Ask your whole grant round anything (Assistant + MCP)
Ask Your Whole Grant Round Anything
ask-your-grant-round-anything
Grant
Analyze
19
How do you build a grant audit trail?
Build a Grant Audit Trail
grant-audit-compliance-trail
Grant
Communicate
20
How do you produce grant compliance and regulatory reports?
Produce Compliance Reports
grant-compliance-regulatory-reports
Grant
Communicate
21
How Do You Roll Grantees Into a Board Report?
Roll Grantees Into a Board Report
roll-grantees-funder-board-report
Grant
Communicate
22
How Do You Build Grant Dashboards and Maps?
Grant Dashboards & Maps
grant-dashboards-geographic-mapping
Grant
Communicate
23