We are a school in Kenya ([url removed, login to view]) with 200 children. Keeping track of the numbers of children we have in each year is very important, particularly looking into the future as to how many children we have starting up to 36 months from now.
Our class sizes are limited and we have to be very careful that we don't accept a child for a place right now when we may already have someone signed up for that place 18 months from now.
We keep this 'register' through Zoho Creator and have already done 95% of the work. However, the one bit that we haven't been able to crack is a simple way of summarising information in a nice clear report.
I have attached an example table. This simply shows the total number of children in the school, split by year group. We apply a probability to each child to show the likelihood of them joining us and so there are two columns: one assuming everyone at 100% coming and one at a probability. The key for me is that we need to be able to filter/update the table to show:
a) Different time periods. We have three terms in a year starting September (Michaelmas), January (Lent) and April (Trinity). We need to see school/class size at the start of each term for different calendar years.
b) Filtered data sets, e.g. by ethnicity, residence, gender
One other area we have had a problem is how to account for a child that repeats an academic year. For example this year we have a child that should be leaving but is staying on and repeating their final year.
Please let me know if you have the skills to be able to sort out this reporting.