play icon for videos
← Academy
SOPACT ACADEMY · CONNECTED DATA INTELLIGENCE · READ

How to Connect Quantitative and Qualitative Survey Data

Link scores and comments, build a joint display and investigate differences without overstating what the evidence proves. A practical course exercise.

Sopact Academy · Course review

Practical Academy guide

How to Connect Quantitative and Qualitative Survey Data

How do you connect quantitative and qualitative survey data?

Link the relevant scores and comments to the same person, group or period, then examine them together using a clear analysis question. A joint display—a table that brings the numerical result, qualitative evidence and interpretation together—helps show where findings agree, add detail or conflict. Comments can suggest explanations, but do not automatically prove why a score changed.

Use this reference when scores and comments must inform the same decision. Build a linked analysis view, compare the evidence and write a conclusion with its limits. For the broader study-design choices, use the mixed-method design guide.

In a fictional tutoring program, some learners improve on an assessment and others do not. Families describe caring tutors, limited session availability and transport difficulties. An overall theme list is useful for understanding the service. To investigate differences in progress, the team also needs to know which feedback belongs to which learner, period and respondent.

Choose the question before choosing the split

Ask something specific: “Do learners with different assessment changes describe different access barriers?” That question supports an outcome-group comparison. “How do families experience tutoring?” may be better answered by an overall qualitative analysis. Neither replaces the other.

Mixed-method integration does not require every project to split outcomes before reading comments. You may use qualitative findings to develop a survey, use interviews to investigate a numerical pattern, or analyze both strands and then bring them together. Fetters, Curry and Creswell’s integration framework describes these different routes.

For a planned group comparison, write the grouping rule before interpreting differences. If exploratory reading suggests a new comparison, keep it and label it exploratory. Do not present a threshold selected after seeing the results as if it were specified beforehand.

Connect the right records, not just matching names

Keep a permitted stable identifier, the measure and question versions, response dates and the period being described. A parent’s comment about a child is not the child’s own account. Preserve the respondent’s role and relationship rather than putting both voices into an unlabeled comment field.

One person may provide several comments, attend several programs or have several assessments. Decide the unit of analysis before joining files. A simple spreadsheet can use one row per learner-period with separate source links; a relational structure may be needed when there are multiple respondents and events.

  • Person or case: whose outcome is being analyzed?
  • Respondent: who supplied the comment, and in what role?
  • Observation: which assessment, question and time period does it concern?
  • Relationship: how is that respondent or source connected to the person?
  • Match status: confirmed, unresolved or not designed for individual linkage?

Do not force uncertain matches to eliminate an unmatched pile. Report the unmatched count and investigate its pattern. Anonymous feedback can be integrated at an appropriate group or theme level without being re-identified; individual linkage is not a requirement for every mixed-method study.

A common spreadsheet mistake is to repeat a learner’s score once for every comment. The most vocal learners then receive more weight in the average. Check the expected row counts after joining and calculate participant outcomes at the participant level.

Define outcome groups without hiding the original scores

Use a meaningful, justified criterion where one exists. In this fictional exercise, the team defines “met the improvement criterion” as an increase of at least five points on its example assessment. This is an invented teaching rule, not a recommendation for any real instrument.

Retain the actual change scores as well as the group label. Grouping can simplify a display while hiding differences near a cutoff. Where there is no established criterion, explain the exploratory rule and assess whether reasonable alternatives change the interpretation.

Keep missing outcomes separate from “did not improve.” A wave-status register identifies who lacks a usable pair; use the linked missing-waves reference if you need to build one. A person with no endline score cannot be classified as unchanged merely because the software requires a group.

Practice: build a joint display

In the fictional cohort, 120 learners have usable paired assessment scores. Seventy meet the improvement criterion and 50 do not. Sixty of the first group and 40 of the second have a linked, substantive family comment. The following counts use one family comment per learner for the exercise.

Fictional joint display: outcomes, comments and the next question
ThemeMet criterion: 60 commentsDid not meet: 40 commentsInterpretation to investigate
Tutor described as caring36/60 = 60%24/40 = 60%Shared service experience; may matter even without a group difference
Requested more sessions18/60 = 30%16/40 = 40%Explore need, expectations and session access
Bus timing conflicts with session end3/60 = 5%12/40 = 30%Check schedules, attendance and site differences before claiming a cause

Transport timing appears more often in the comments from learners who did not meet the criterion: 30% versus 5%, a 25 percentage-point difference among these commenters. It is a lead for investigation. It does not prove that transport caused the assessment difference.

The comment coverage is also different: 60/70 = 85.7% of learners meeting the criterion, and 40/50 = 80% of those not meeting it. Report those bases. Theme percentages describe the available comments, not necessarily every learner or family in either outcome group.

The theme categories can overlap, so their percentages need not add to 100%. Count learners, responses or passages consistently. Do not mix a count of mentions in one group with a count of people in the other.

Guetterman, Fetters and Creswell’s study of joint displays shows how bringing findings together can support interpretation. The display should contain an analytical connection, not merely a numerical table placed beside an unrelated quotation.

Read shared themes and contradictions as evidence

A theme present in both groups is not worthless. Caring tutors may support participation, matter to families in ways the assessment misses, or be too similar across groups to explain this particular contrast. The data do not justify dismissing it as “explaining nothing.”

Likewise, a negative comment from someone whose score improved is not an error to remove. The score and comment may concern different aspects of the experience. Check the question, timing and context before deciding that the measure failed or the comment contradicts it.

If no theme differs between groups, report that result. It may reflect similar experiences, an insensitive question, limited sample size, coarse coding or other factors. It does not prove participants cannot explain the difference. Consider whether another question, source or method is needed.

Review both supportive and disconfirming examples. Do not select only the most vivid quotes for a preferred explanation. A quotation illustrates an account; it does not establish how common the account is.

Choose a coding process that limits expectation bias

Develop or refine the codebook on a varied set of responses. Use clear inclusion and exclusion rules, preserve source passages and record changes. The response-cleaning lesson explains why valid “none” answers and missingness should remain distinct.

Reading by group can help explore a pattern, but it can also prime the reviewer to see what they expect. Depending on the purpose, code comments without showing outcome labels first, then compare the coded results. Another option is to review a subset independently and discuss differences before completing the analysis.

If you code with AI, inspect the assigned themes and supporting text rather than judging the summary’s fluency. Review ambiguous responses, rare themes and exceptions. Changing the prompt or rubric may change the outputs; record the version and decide whether earlier responses need reprocessing.

For multilingual material, use the language-review workflow. An apparent group difference may partly reflect translation or interpretation quality. Do not attribute it to the participants without checking that possibility.

Investigate the explanation with additional evidence

For the bus example, check whether affected learners attend the same site or session, whether the timetable actually overlaps, and whether attendance records show missed learning time. Keep the period consistent: a later timetable change does not explain an earlier assessment result.

Site, starting ability, program exposure and other factors may relate to both the feedback and the outcome. A simple table does not separate those influences. If the decision requires a causal claim, use a design and analysis capable of supporting it; do not promote an observational association into proof.

A practical next step may still be justified without proving the entire causal pathway. For example, verify and address a documented scheduling conflict, then collect follow-up evidence about access and outcomes. State that the team is testing an explanation, not that the first table has settled it.

A customer context: the King Center

Group gathered outdoors beside a statue, pictured in the King Center customer story
The King Center’s published story describes working with quantitative and qualitative program evidence.

The King Center customer story describes pre- and post-survey evidence and qualitative feedback across seven programs. It provides a relevant setting for connecting different kinds of evidence. The tutoring figures above are fictional and are not results from that customer.

Plan the recurring coding and reporting work

The joint display is useful only while its codes, ratings and record relationships stay current. Plan a codebook revision as part of the workflow so the next comparison does not require another manual coding and joining project.

A workflow with repeated manual work

  1. Define from an initial sampleRead material and agree on the codebook.
  2. Apply it across the datasetCode responses and check the result.
  3. Revise a definitionReturn to affected material and recode it.
  4. Reconnect the numbersReconcile coded results with ratings and context, then rebuild the view.

The Sopact workflow

  1. Your team owns the definitionsDecide what each code means and improve it as you learn.
  2. Apply coding across the eligible dataAutomate application; people review quality and exceptions.
  3. Reprocess after a definition changesReapply the revised definition across the configured scope instead of recoding each response by hand.
  4. Ask across coded text and numbersKeep the response, rating and relevant record context connected; inspect the evidence behind the result.

This compares workflow patterns, not a claim that every research tool requires manual coding or separate files. Some already automate parts of this work; compare the complete cycle.

For this codebook-based workflow, the main saving is repeated application and reconnection—not the removal of human judgment. A changed definition can be reapplied across the configured data while reviewers concentrate on quality, exceptions and interpretation. Coded text stays connected to the relevant ratings and context.

Count the recurring work in ownership cost. Include setup, coding, recoding after revisions, source reconciliation, review and reporting, plus your actual platform and processing expenses. A worked scenario of four cycles of 4,000 responses illustrates 272 fewer annual staff hours; it is an assumption-based example, not a customer benchmark. Existing automation, review needs and implementation effort can substantially change the result.

Adjust the workload assumptions and compare total effort →

A reliable assistant should calculate from the selected records and let a reviewer open the supporting evidence. Check the data scope, definition, denominator and access permissions. Reproducible arithmetic does not make every AI interpretation correct.

Watch: Why Qualitative Analysis Stays Small — And How to Scale It

Watch this 2-minute 58-second explanation of repeated coding, revised definitions and connected analysis. Then estimate the work for your own collection cycle.

Watch this video on YouTube →

Test the workflow in your data system

Start with one cohort, one comparable outcome measure and a relevant open question. Produce the linked-record count, unmatched count, usable outcome pairs and comment coverage before asking for themes. That reconciliation prevents a polished report from concealing who was excluded.

For a configured Sopact workflow, ask the team to demonstrate how an incoming comment stays connected to the appropriate person or relationship, how rubric-based analysis can be reviewed, and how a group comparison links back to the original evidence. Then add a later response and check the effect on the report.

Change the display from outcome group to site and confirm the counts still reconcile. Existing codes may be reusable, but a new research question can require new coding or review. Do not assume every useful comparison can be made without revisiting the source.

A pass does not require discovering a one-sided theme. It requires correct relationships, visible missingness, consistent counting rules and an interpretation that the evidence supports—even when the result is inconclusive.

Write the finding, limitation and next action together

For the fictional display: “Bus-timing conflicts were reported in 12 of 40 comments linked to learners who did not meet the improvement criterion, compared with three of 60 among those who did. This association does not establish a cause. We will check site schedules and attendance before deciding whether a timing change should be tested.”

Add the comment coverage and grouping rule alongside the table. Preserve links to supporting passages for authorized reviewers, with identifying details handled appropriately. If you need a reporting structure, use the impact-report writing guide and report examples.

Watch: keeping qualitative evidence connected

Watch the video · 2 minutes 34 seconds. This companion explains why qualitative evidence needs to stay connected to the records it describes. Browse more videos in the video library.

Frequently asked questions

Must numbers and comments be on the same row?

No. They need a valid relationship appropriate to the analysis. One-row views can help, but multiple respondents or periods may need related records. Aggregate integration is possible when individual linkage is not intended.

Should outcome groups always be defined before coding?

For a planned comparison, define the rule before interpreting results. Exploratory analysis is also legitimate when labeled. Coding without outcome labels can help limit expectation bias.

Are shared themes useful?

Yes. They can describe common experiences or suggest factors worth keeping. They may not explain a particular difference, but that does not make them unimportant.

How do I compare groups of different sizes?

Show counts and percentages using a clearly stated base for each group. Report comment coverage and do not confuse mentions, responses and people.

Can comments prove why an outcome changed?

They can support or challenge explanations, but an association alone does not prove causation. Check timing, alternative explanations and additional evidence.

What should I do with unmatched records?

Keep them visible, investigate uncertain relationships and report exclusions. Do not force matches just to produce a complete-looking dataset.

What if no differences appear?

Report the result honestly. Consider the question, coding, sample and other evidence. A sound analysis does not have to discover a difference.

For a three-checkpoint analysis

Carry the linked records, codebook and reporting bases into the pre, mid and post analysis lesson. The next step is to examine the sequence of change while retaining what participants said at each stage.

Reviewed September 12, 2026. Tutoring scenarios and numerical examples are fictional. Customer and research sources are identified separately.

Return to your course →

Put this guide into practice.

Start with data your teams struggle to bring together. Agree shared definitions, keep each source identifiable, and decide who can see what before asking AI for an answer.

Explore Connected Data Intelligence →
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.
Make learning part of the work you already do
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.
Teams running cases, applications, grants, or programs that need AI-assisted reporting they can reproduce, trace to source evidence, and act on before the cycle ends.
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
What Is Portfolio Intelligence?
What Is Portfolio Intelligence?
what-is-portfolio-intelligence
Portfolio
Strategy
1
A source-linked portfolio view that connects each investee or grantee's agreed plan, reporting cadence, evidence, risks, and results.
Impact funds and investors · Foundations with grant portfolios · Family offices · Blended-finance vehicles
What Is Connected Data Intelligence?
What Is Connected Data Intelligence?
connected-data-intelligence
Feedback
Foundation
1
Keep evidence from surveys, files, notes, documents, systems, sites, and reporting periods connected to one continuing record.
Multi-program nonprofits · Member and chapter networks · Research associations · Training and coaching teams · Organizations with scattered evidence
Build an impact report from evidence you can explain
What Is Impact Measurement and Reporting?
embedded-impact-measurement
Reporting
Align
1
Define intended change, align organization and funder context, govern measures, interpret evidence, and produce traceable reports for decisions.
Program and impact teams · MEL leads · Funders and donors · Foundations · Impact funds · Organizations building rigorous impact reports
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.
How to Build a Theory of Change with AI: Prompts and Examples
Build a Theory of Change You Can Test
how-to-build-a-theory-of-change
Reporting
Align
2
How Do You Onboard a Portfolio and Track Results?
Agree the Portfolio Reporting Plan
onboard-portfolio-lock-impact-agreement-track-results
Portfolio
Data Dictionary
2
Test whether an AI-assisted result is repeatable and correct
Reliability — the same answer twice
loop-reliability
Loop
The method
2
Determinism as a feature: the same question over the same data returns the same answer every run — the opposite of a generic AI chat that drifts.
Anyone who has watched a general AI tool give two different numbers for the same question and needs results they can stand behind.
Design application intake around a defensible decision
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.
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
Build a portfolio data dictionary without forcing false comparisons
Map Portfolio Data to Reporting Standards
portfolio-data-dictionary-standards-mapping
Portfolio
Chapters
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.
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
How to Measure Outcomes Across an Investment or Grant Portfolio
Frame Outcomes Over Outputs at Portfolio Level
frame-outcomes-portfolio-level
Portfolio
Chapters
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
Impact Due Diligence: Review Evidence Before Investment
Pre-Investment Due Diligence & Screening
pre-investment-due-diligence-screening
Portfolio
Chapters
5
Plan and review your first workflow pilot
The Guarantee — first workflow in 2 months
loop-guarantee
Loop
The method
5
How to Build an Organization Evidence Model
Build the Organization Evidence Model
build-organization-evidence-model
Reporting
Align
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.
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
Design quarterly portfolio reporting that investees can complete
Collect Investee Reporting Without Repeated Rework
collect-investee-reporting-without-burden
Portfolio
Chapters
6
How to Build a Funder Context Profile: Research to Reporting
Build a Sourced Funder Context Profile
build-funder-context-profile
Reporting
Align
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
How to Follow Up on Missing Investee Data
How to Follow Up on Missing Investee Data
chase-missing-investee-data
Portfolio
Chapters
7
How to Analyze Multilingual Feedback and Evaluate Software
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
Survey Attrition in Longitudinal Studies: Track Missing Waves
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
Find inconsistencies in portfolio returns before reporting
Analyze Investee Reports Across Sources
read-investee-reports-multi-signal
Portfolio
Chapters
8
Impact Metric Definitions: A Practical Worksheet and Example
Give Every Number One Definition
one-definition-for-every-number
Reporting
Define
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
Keep company, investment and reporting history connected
Track Results Against the Impact Agreement
track-investees-impact-agreement-variance
Portfolio
Chapters
9
Turn Reporting Requirements into Evidence: A Practical Mapping Guide
Turn Requirements Into Collectable Evidence
turn-reporting-requirements-into-evidence
Reporting
Define
9
Connect baseline, follow-up and different rater perspectives
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 Build Useful Portfolio Impact Monitoring Alerts
Build Useful Portfolio Impact Alerts
portfolio-risk-monitoring-alerts
Portfolio
Chapters
10
How to Collect Clean Data Inside Your Workflow
Collect Clean Evidence Inside the Workflow
collect-clean-data-at-the-source
Reporting
Embed
10
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 with evidence, clear criteria and human judgment
Review Without Reviewer Bias
review-applications-without-reviewer-bias
Grant
Analyze
11
How to Ask AI Questions About Your Portfolio Data
Ask AI Questions About Portfolio Data
ask-your-portfolio-anything
Portfolio
Chapters
11
How to Keep Impact Reporting Numbers Consistent
Get Stable Results From Governed Data
same-numbers-every-time
Reporting
Read
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
Evidence Traceability: Link Every Report Claim to Its Source
Trace Every Result Back to Its Evidence
where-every-number-came-from
Reporting
Read
12
How Do You Roll Up a Grant Portfolio?
Aggregate Outcomes Across a Grant Portfolio
how-to-roll-up-a-grant-portfolio
Portfolio
Chapters
13
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
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 Write an Evidence-Based Impact Narrative
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 to Use SROI Across a Portfolio Without Double Counting
Use SROI Across a Portfolio
monetize-impact-sroi-across-levels
Portfolio
Chapters
14
How to Write a Funder Report with AI—and Check It
Generate the Audience-Specific Report From Evidence
assistant-writes-the-funder-report
Reporting
Decide
14
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 Do You Compute Grantee Variance?
Compute Grantee Variance
how-to-compute-grantee-variance
Grant
Analyze
15
When Is a Monetary Value on Social Impact Credible?
Add a Credible Dollar Value With SROI
credible-dollar-value-on-impact
Reporting
Optional method
15
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
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 and Actual Spend?
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
How Do You Compare Investees When Each One Defines Its Metrics Differently?
Compare & Benchmark Investees
compare-benchmark-investees
Portfolio
Chapters
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 Do You Calculate the SROI Ratio?
Calculate the SROI Ratio With a Range
how-to-calculate-the-sroi-ratio
Reporting
Optional method
18
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 Read Form 990 for a Grant Review
Read a 990 for Compliance
how-to-read-a-990-for-compliance
Grant
Analyze
18
How Do You Build Dashboards and Compliance Reports?
Build Dashboards and Reviewed Reports
dashboards-sroi-compliance-reports
Portfolio
Chapters
18
Plan evidence collection across your network
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
Produce portfolio reports that trace back to approved evidence
Produce the LP and Board Impact Report
portfolio-lp-board-impact-report
Portfolio
Chapters
19
How Do You Build a Grant Audit Trail?
Build a Grant Audit Trail
grant-audit-compliance-trail
Grant
Communicate
20
How Do You Connect Your Stack Without Lock-In?
Connect Systems and Test Data Portability
portfolio-connect-your-stack
Portfolio
Chapters
20
How Do You Produce Grant Compliance 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