School Cafeteria Meal Participation Analysis Builder
Analyze school meal participation by campus, grade, menu, eligibility, daypart, waste, staffing, and outreach while protecting student privacy.
Prompt Template
You are a school nutrition data analyst helping a district understand cafeteria meal participation and improve service decisions without exposing student-level privacy. District context: [single school, district, charter network, university dining, summer meals] Meal programs: [breakfast, lunch, after-school snack, summer meals, universal free meals] Time period: [week, month, semester, school year] Data sources: [POS, meal counts, enrollment, attendance, menu calendar, production records, waste logs, surveys] Available fields: [school, date, meal period, grade band, entree, sides, eligibility group, paid/free/reduced, attendance] Operational context: [serving lines, grab-and-go, breakfast in classroom, mobile cart, meal preorders] Menu factors: [new items, cultural meals, vegetarian options, allergies, local foods, promotional days] Known issues: [low breakfast uptake, long lines, waste, staffing gaps, stigma, menu dislikes, weather] Privacy constraints: [FERPA, small cell suppression, eligibility sensitivity, no individual student ranking] Stakeholders: [nutrition director, principals, board, cafeteria managers, families, finance] Tools: [spreadsheet, SQL, Power BI, Tableau, POS export] Decision needed: [menu changes, staffing, outreach, line design, waste reduction, budget planning] Create: 1. Data inventory and quality checks for meal counts, attendance, menus, and production records. 2. Metric definitions for participation rate, average daily participation, capture rate, reimbursable meals, waste, and revenue. 3. Segmentation plan by school, grade band, day of week, meal period, menu item, and program model. 4. Privacy-safe approach for eligibility groups and small populations. 5. Menu performance analysis that separates popularity, availability, serving-line constraints, and attendance effects. 6. Waste and production variance analysis with operational caveats. 7. Dashboard layout for nutrition leaders, campus managers, and board reporting. 8. SQL or spreadsheet calculation outline for core metrics. 9. Recommendation framework for menu tests, outreach, breakfast access, staffing, and line improvements. 10. Executive summary template with assumptions, limitations, and next experiments. Do not expose individual student behavior or sensitive eligibility information. Clearly mark missing data and confounding factors.
Example Output
Meal Participation Readout
Core Metrics
| Metric | Definition | Use |
|---|---|---|
| Lunch participation rate | Reimbursable lunches served / attendance | Compare campuses fairly |
| Breakfast capture rate | Breakfasts served / students present before first bell | Identify access barriers |
| Production variance | Portions prepared minus portions served | Waste and forecasting signal |
Early Finding
Middle school breakfast participation is 18 percent lower on campuses without hallway grab-and-go carts. The gap persists after adjusting for attendance, suggesting access and timing may matter more than menu preference.
Privacy Note
Do not publish eligibility group breakdowns for small grade bands. Roll up to district or suppress cells where counts are low.
Next Test
Pilot a two-week breakfast cart at Campus B, track participation, line length, waste, and student survey comments before expanding.
Tips for Best Results
- 💡Use attendance-adjusted participation rates so absences do not look like menu failure.
- 💡Treat eligibility data as sensitive and suppress small groups.
- 💡Pair meal counts with production and waste records to avoid optimizing participation alone.
- 💡Separate menu preference from access barriers like long lines, late buses, or short meal periods.
Related Prompts
Dataset Summary and Insights
Paste or describe a dataset and get an instant summary of key statistics, patterns, anomalies, and actionable insights.
SQL Query Writer for Business Reports
Generate SQL queries for common business reporting needs — revenue trends, cohort analysis, funnel metrics, and more.
Dashboard KPI Definition Framework
Define the right KPIs for your business dashboard with clear formulas, targets, and data sources.