Hi,
I have designed a series of assessment trackers in excel for various subjects (History, Geography etc). The trackers will assess pupil levels of progress and calculate their mean grade over the year and tell the subject coordinator if they are over / under achieving or on target.
My question is this ---
How can I get the sheets for the various subjects to pull together so I can generate a report for an individual or groups?
There are approximately 900 pupils and 12 subjects and 70 ish teachers all adding in their data. I'd really like to keep the subjects separate if possible.
Thanks.
I have designed a series of assessment trackers in excel for various subjects (History, Geography etc). The trackers will assess pupil levels of progress and calculate their mean grade over the year and tell the subject coordinator if they are over / under achieving or on target.
My question is this ---
How can I get the sheets for the various subjects to pull together so I can generate a report for an individual or groups?
There are approximately 900 pupils and 12 subjects and 70 ish teachers all adding in their data. I'd really like to keep the subjects separate if possible.
Thanks.
