Our parent organization runs the hot lunch program at our school. Right now we are utilizing Excel to enter and sort the data for the program. We have been told that a database would be more efficient and sensible.
We enter every child's name who participates and whether they ordered the entree for the day "PZ" for Pizza for example, or whether they chose a substitute meal, such as "SJ" sunbutter and jam. Then on the day of the lunch, we print out the data in various ways: lists of the kids with what they ordered, number of entrees that we need to serve at 11:30am, at 12pm, etc. and # of substitutes ordered, etc.
We bought the PTO manager software this year - but as far as we can tell - this software works for our volunteer data, but would not work for the hot lunch data.
Is anyone running the lunch program at their school? How are you working with the data? Anybody else with ideas?