2027 A School Attendance and Respiratory Illness Data Linkage Protocol: A Graduate Public Health Portfolio Project
Audited and Verified:
Our Editorial and Data Verification Process
Research.com uses government datasets, official education statistics and primary institutional information to support its career and degree guides. Our review process checks factual accuracy, occupational definitions, source dates and the requirements associated with the credentials discussed.
How This Article Was Fact-Checked
Our editorial team verifies salary estimates, employment projections, education requirements and program information against original data providers and official organizations. Salary figures are checked against the relevant occupational definitions and reporting periods. Information about licensure, accreditation and required in-person training is reviewed separately.
Fact-checked and verified on:
Co-Founder and Chief Data Scientist
A school attendance dataset may reveal when students were absent, but it rarely establishes why. Linking it to respiratory illness information could support more useful surveillance - if the records are compatible, the analysis is carefully defined, and students' privacy is protected.
This guide is for graduate public health students designing a portfolio project, not claiming to have completed an authorized study. It explains what a credible linkage protocol contains, how to choose a feasible data-access route, and how to turn the work into evidence of applied skills without exposing confidential records.
Key Things You Should Know
- A strong protocol specifies the population, observation period, linkage unit, illness measure, attendance measure, data owner, and intended decision before analysis begins.
- One row per student-week may support a proposed restricted-data design; public, aggregate counts support a different design and cannot establish which absent students were ill.
- The safest portfolio artifact is usually a reviewed protocol, synthetic-data demonstration, and redacted documentation - not student-level school or clinical records.
What Is a School Attendance and Respiratory Illness Data Linkage Project?
It is a plan to examine how patterns of absence relate to respiratory illness indicators over a defined period. Data linkage means combining records through a permitted common identifier, or aligning separate datasets by shared characteristics such as school and week. Those approaches answer different questions: aligning weekly totals does not identify which students had an illness.
The table distinguishes three possible inputs. It helps a student select a design that matches the available permissions rather than promising a more precise analysis than the data allow.
| Potential input | Possible unit | Important limitation |
| School attendance records | Student-day or school-week | Absence codes may be incomplete or may not identify respiratory symptoms. |
| School-reported illness information | Student encounter or school-week | Reports depend on local collection practices and are not necessarily confirmed diagnoses. |
| Public respiratory surveillance | County-week or another published area and period | Population and geography may not match the school; no student-level link exists. |
A graduate portfolio deliverable should be a linkage protocol, not an invented results report. Its core is a short decision statement - for example, whether a district could assess the usefulness of respiratory-related absence counts for situational awareness - followed by a data dictionary, linkage specification, analysis plan, governance requirements, and limitations. A student without access to restricted records can demonstrate the workflow with clearly labeled synthetic data. Someone still building foundational preparation may first consider public health bachelor's degree planning online rather than treating this graduate-level protocol as an admissions prerequisite.
How Does This Portfolio Project Prepare Students for Public Health Careers?
The project demonstrates a specific professional task: translating a surveillance question into definitions that a school partner, epidemiologist, and privacy officer can review. An employer can assess whether the student distinguished absences from confirmed illness, identified who controls each dataset, and communicated what the proposed analysis cannot show. A polished graphic without those decisions is weaker evidence of readiness.
An MPH student may use the protocol to demonstrate practice-oriented surveillance planning and partner communication. A method-intensive MS student might add a reproducible linkage test and sensitivity analysis using synthetic records. Neither version proves competence to independently manage a district's identifiable records. Advanced research or leadership ambitions may eventually prompt a comparison of doctoral public health study formats, but a doctorate is unnecessary to build this portfolio artifact or pursue many supervised analyst roles.
For portfolio presentation, include the decision brief, variable definitions, a diagram of proposed data flow, annotated synthetic code if relevant, and a limitations statement. Label the work as proposed or simulated wherever no partner has authorized implementation.
What Skills Are Needed to Link School Attendance and Respiratory Illness Data?
The first skill is specifying what is being compared. A useful protocol defines the eligible schools and dates, the attendance denominator, how partial days count, what qualifies as a respiratory illness indicator, and whether the unit is a student-day, student-week, or school-week. It also specifies whether the objective is descriptive monitoring or an association; an observed increase in absences cannot by itself establish that respiratory illness caused it.
Technical skills include data dictionaries, date and school-code standardization, duplicate detection, missing-data assessment, version control, and reproducible analysis. If authorized student-level records are proposed, the protocol must address changing enrollment and the possibility of false or missed matches. With aggregate records, the challenge shifts to mismatched geographies and reporting periods. Small numbers, holidays, changing attendance policies, and differences in who gets tested can distort either approach.
Students who need deeper modeling or data-management instruction can compare career-compatible online biostatistics study with a targeted methods course. A second degree is rarely the most direct way to learn the specific linkage and documentation skills needed for one project.
Epidemiology supports case definitions, surveillance interpretation, and bias assessment. Biostatistics supports denominators, uncertainty, and comparisons across time or schools. Data management or informatics covers record structure, quality checks, and reproducibility. Public health ethics and policy help students understand why a technically possible linkage may not be permissible or useful. A practicum or capstone can provide supervision and a real decision-maker, but only if the program and site approve the work.
Course choice should follow the student's starting point. Someone comfortable coding but unfamiliar with school health should prioritize surveillance and governance; someone with school or community experience but limited quantitative training should begin with data management and introductory biostatistics before attempting record linkage. For a student who has not yet completed undergraduate preparation, inexpensive public health bachelor's education is an option to compare with individual prerequisite courses - not an automatic requirement for graduate admission.
Privacy rules depend on who holds each record, what it contains, and why it is being used. Student attendance and school-maintained health records may be education records governed by the Family Educational Rights and Privacy Act (FERPA). Records held by an outside healthcare provider may instead be subject to the Health Insurance Portability and Accountability Act (HIPAA), depending on the provider and disclosure. Neither label alone grants a graduate student access. District policy, agreements, state law, and institutional requirements may impose additional conditions.
Before seeking records, the student and faculty supervisor should identify the data owners, the minimum fields needed, the legal basis for any disclosure, approved storage and access controls, retention and destruction terms, and whether institutional review board review or another determination is required. A data-use agreement, school permission, and research-ethics review serve different purposes; one should not be presented as a substitute for another. Published aggregates also need disclosure checks when small cells could make individuals recognizable.
If permissions or secure infrastructure are unavailable, use synthetic records and publicly released aggregates for a demonstration, explicitly stating that they do not constitute student-level linkage. Restricted-data research can also carry storage and extended-enrollment costs; those belong in budget planning for a public health PhD when a student is considering a larger doctoral study. Funding a project does not confer permission to use the records.
Either format can support a credible protocol: faculty meetings, partner interviews, data-dictionary review, and synthetic-data demonstrations can occur remotely. Actual access to identifiable records is a separate issue determined by the data owner and approved security arrangements. An online student should not assume that downloading records to a personal device is allowed; a campus student should not assume physical proximity grants access.
Before committing to a project, confirm the sequence of responsibilities with the course lead and any proposed partner. The following checkpoints keep an academic timeline from depending on unapproved data:
- Confirm the assessed deliverable and whether a real site or dataset is required.
- Agree on the question, unit of analysis, and minimum variables with faculty supervision.
- Ask the data owner and relevant review offices what permissions would be necessary; set a decision date for switching to a synthetic-data version.
- Schedule feedback on the draft protocol and reserve time to revise its definitions and limitations.
For students balancing work or caregiving, check live meetings, group-work schedules, field-site hours, and any campus visits rather than relying on an "online" label. Affordable shorter online public health degrees may reduce time in coursework, but a shorter program is a poor fit if it cannot accommodate the project's supervision and approval sequence.
For this project, relevant choices commonly include a practice-oriented MPH and a more research- or methods-focused MS. Admissions rules are set by each program: applicants should check accepted undergraduate degrees, any required statistics or quantitative preparation, application materials, and whether research or practice experience is expected. A non-public-health major does not automatically rule out admission; readiness for this protocol depends more directly on quantitative foundations, careful writing, and the ability to work within data-governance rules.
Applicants should separate admission eligibility from project feasibility. An offer of admission does not establish that a district will share records or that a capstone supervisor can support this topic. Ask the program whether a protocol-only or synthetic-data project meets its assessment rules, and whether a site agreement is needed. When comparing accessible online public health master's options, check those requirements alongside admissions criteria; apparent ease of entry says little about the support available for a specialized portfolio project.
The closest early-career applications include surveillance or data analyst support, school-health program evaluation, and research coordination in public agencies, districts, health systems, or academic teams. Duties may include checking data quality, preparing summaries, documenting definitions, and explaining limitations to partners. Epidemiologist roles generally call for more substantial graduate methods preparation; a portfolio protocol alone does not establish eligibility or replace supervised experience.
The US Bureau of Labor Statistics reported a $83,980 median annual wage for epidemiologists in May 2024. That occupation-wide figure is not an expected starting salary for a school-health analyst or a return promised by an MPH. Compare local job postings' required methods, education, and experience with the evidence your portfolio actually demonstrates before weighing an inexpensive online MPH study pathway against employer training or a shorter course.
How Should Students Choose an Accredited Public Health Program?
Begin with the deliverable: will the program accept a linkage protocol, provide appropriate methods supervision, and allow a synthetic-data contingency if records cannot be shared? Then check scheduling, capstone or practicum rules, partner-site approval, and access to secure computing if the project might use restricted data. Ask to see the requirements that apply to your intended entry term.
Check institutional accreditation separately from accreditation by the Council on Education for Public Health (CEPH). CEPH accreditation has a defined school, unit, or program scope; do not infer that every degree at an institution is covered. When choosing an MPH with CEPH accreditation, verify the exact degree and current status directly with the school and accreditor. The strongest fit is the program that can supervise an ethical, feasible version of this project - not necessarily the one promising access to the largest dataset.
Other Things You Should Know About Public Health
The protocol should specify whether that student contributes time to each school, how enrollment dates are checked, and how transfers affect denominators. Otherwise, a move can look like an unexplained change in attendance.
No. Days when attendance was not expected should not be treated as zero-absence school days. Calendar differences also matter when comparing schools or weeks.
Record the original and revised definitions, when each applied, and whether the periods remain comparable. Do not silently combine categories that were collected under different rules.
Yes. Its value may be in showing that definitions are usable, identifying gaps in reporting, or establishing that the available data cannot answer the intended question. A protocol should not promise a detectable trend.
- Respiratory Disease Data - Virginia Department of Health https://www.vdh.virginia.gov/epidemiology/respiratory-diseases-in-virginia/data/
- Attendance Questions and Answers: CR 104.1 | New York State Education Department https://www.nysed.gov/student-support-services/attendance-questions-and-answers
- Assessing data linkage quality in cohort studies - PMC - NIH https://pmc.ncbi.nlm.nih.gov/articles/PMC7261400/
- Case Definitions for Public Health Surveillance | cdc.gov https://www.cdc.gov/mmwr/preview/mmwrhtml/00025629.htm
- Developing standard tools for data linkage: February 2021 | Office for National Statistics https://www.ons.gov.uk/methodology/methodologicalpublications/generalmethodology/onsworkingpaperseries/developingstandardtoolsfordatalinkagefebruary2021
- WHO COVID-19 dashboard data https://data.who.int/dashboards/covid19/data
- Data Security Guidelines | Research Ethics & Compliance https://research-compliance.umich.edu/data-security-guidelines%20
- De-identification and Confidentiality of Research Data | ucsf.edu https://irb.ucsf.edu/content/de-identification-and-confidentiality-of-research-data
- guide to evaluating linkage quality for the analysis of linked data | oup.com https://academic.oup.com/ije/article/46/5/1699/4107250
- Hospitalization Data: Viral Respiratory Illness in Minnesota | state.mn.us https://www.health.state.mn.us/diseases/respiratory/stats/hosp.html
