2027 Building an Outreach Attendance Tracker With Synthetic Data

Imed Bouchrika, PhD

by Imed Bouchrika, PhD

Co-Founder and Chief Data Scientist

What is an outreach attendance tracker with synthetic data?

An outreach attendance tracker is a spreadsheet, database, or simple dashboard that records planned community outreach sessions and participation. Its audience might be a health educator checking turnout, a nonprofit coordinator planning staffing, or an evaluator preparing a process report. Synthetic data are invented records designed to resemble the structure of a possible dataset; they are not observations from actual participants.

The first design choice is the unit of a record. One row per session supports event-level counts without any participant identifiers. One row per attendance instance - one person at one session - can demonstrate repeat visits, but requires a consistent invented person ID. Neither structure, by itself, shows whether someone learned from an event or changed a health behavior.

These measures answer different questions, so a dashboard should name its denominator rather than display an unexplained "attendance rate."

MeasureWhat it countsImportant limitation
RegistrationsPeople signed up for a sessionNot everyone registered attends
VisitsAttendance instances across sessionsA returning person can be counted more than once
Unique attendeesDistinct people within a defined periodRequires a consistent person ID and a stated time window

For an introductory project, a session-level tracker is often enough. A student taking intensive online public health bachelor's classes could keep the scope to session counts and a documented summary rather than build unnecessary participant-level features.

Table of contents

How can public health students build an outreach attendance tracker?

Build the tracker backward from a decision, such as whether turnout differed across session times. A spreadsheet is sufficient for a small class exercise; use a database or scripted workflow only if the learning objective calls for one. The following sequence produces an adaptable template, not a completed evaluation of a real organization.

  1. Write the question and scope. Specify the intended user, reporting period, types of outreach sessions, and whether the tool counts sessions, visits, or unique people.
  2. Define fields. For a session-level sheet, consider session ID, date, location category, topic, planned capacity, registrations, attendees, and data-entry status. Define each field's allowed values in a data dictionary.
  3. Create clearly invented records. Use fictional session IDs and plausible values; do not copy a partner's actual schedule, participant characteristics, or small-cell patterns and merely change names.
  4. Build checks and calculations. Flag duplicate session IDs, impossible dates, missing counts, and attendance above capacity for review. Calculate a registration-to-attendance rate only where registrations exist and explain how walk-ins are handled.
  5. Test the output. Recalculate a few rows by hand, document whether canceled sessions are excluded, and ask a classmate or supervisor whether the labels are understandable.
  6. Package the deliverable. Include the blank template, synthetic sample, data dictionary, calculation notes, quality checks, and a brief limitations statement.

For example, hypothetical counts of 18 attendees and 24 registrants yield 18 ÷ 24 = 75%. That figure describes only the invented example. If walk-ins are included among attendees but not registrants, the ratio needs a different label or denominator; it should not be presented as a conventional attendance rate without explanation.

A project can demonstrate preparation for further study, but it does not waive admissions conditions. Students exploring public health master's conditional admission options should verify outstanding requirements with each program separately.

The median annual wage for health education specialists in the United States.

Why use synthetic data for public health outreach analysis?

Synthetic records let students test a tracker's layout, formulas, and explanations without obtaining access to identifiable attendance lists. That is useful when a course project does not require a community partner or when an organization cannot authorize use of its records. Invented data also make it possible to test edge cases deliberately, such as a canceled session, missing registration count, or duplicate ID.

They are not a privacy guarantee for data derived from real people. Calling a dataset synthetic does not make it safe if its rows closely reproduce sensitive source records or recognizable combinations. For coursework, generating records independently is simpler. If a project later uses actual outreach data, check the organization's permissions, data-use rules, storage requirements, and any institutional review or community approval that applies before receiving or publishing anything.

Synthetic data can validate whether a formula works; they cannot establish actual turnout, disparities in reach, program effectiveness, or community preferences. In a portfolio, label screenshots and charts "synthetic demonstration" and describe what would require real, authorized evidence. This can show practical readiness to applicants considering public health master's options after a weak GPA, without implying that a portfolio replaces academic requirements.

What salaries and job outlook apply to public health data careers?

There is no reliable salary or growth figure for "outreach attendance tracker builder" because it is a task, not a defined occupation. For US comparisons, use the Bureau of Labor Statistics Occupational Outlook Handbook entry that matches the job's principal duties - such as community health worker, health education specialist, or epidemiologist - and check its wage reference year, projection period, education description, and work setting. An epidemiologist's occupation-wide median, for example, should not be presented as the expected pay for a new outreach assistant.

Pay and opportunity also vary by employer, region, experience, and scope of work. Use career salary ranges for MPH degree holders as context, then compare current local postings for the specific role you want. A useful next decision is whether those postings ask for a degree, demonstrated evaluation skills, community experience, or a combination - and whether a short supervised project would close the gap more directly than further formal study.

Other Things You Should Know About Public Health

Can I share my tracker as a downloadable portfolio file?

Yes, if you created the content and it contains only independently invented records. Include a visible synthetic-data label and remove any confidential organization materials or identifying file metadata before sharing.

Which software should I use first?

Use a spreadsheet if it can meet your course objectives and you can explain its formulas. Move to a database or code when the assignment or scale calls for it, not simply to make the project look more advanced.

Should the tracker include a sign-in form?

Only if the project's purpose requires one. For a synthetic exercise, a mock form can illustrate how fields would be collected, but a real form needs site approval, an appropriate explanation to participants, and secure handling.

How can I get useful feedback without a field-site partner?

Ask an instructor or peer to follow your data dictionary, reproduce one calculation, and identify any confusing chart labels. That tests clarity without implying community endorsement.