Kia ora Alyson and welcome to the community!
Let’s start a discussion thread in the forum ‘Google Sheets & Forms for the Office‘ so we can help you figure this out. I have shared access to the Sheet you are interested in using and will take screenshots as necessary (knowing that I’ll take any names or specifics that Ray your principal wouldn’t want shared out of the screenshot) to illustrate things for you.
This issue is really begging to be turned into a course in itself – I’m thinking something like: ‘Data literacy – analysis and reporting for school leaders’ or such like title.
Looking forward to helping you in here – have a nice day in the beautiful Akaroa!
Rob