Head of Year/College Central Spreadsheet

I designed this spreadsheet to track a bunch of the elements I needed to keep an eye on within the Head of Year role. Remember, hide the columns you don’t need and write comments to keep a fuller track of details. A watered-down version of each area is available to see on the top sheet. Also, you can add/modify the menus The areas are as follows:

CONTACT TRACKER: Designed to keep track of meetings and phone calls from class room teacher all the way up to governors.

TARGET TRACKER: Similar to contact tracker but it allows for you to track a set of targets. I’d log the target in a comment and then enter a new target should I need to do so.

OUTSIDE AGENCIES TRACKER: The original reason I set the spreadsheet up. Allows for you to see who has interactions with an agency (e.g. Early Help) and track your contact with them.

BULLYING/INCIDENT TRACKER: Accounts for identification of incident, investigation and follow up. You can then log the action.

TOILET/TIME OUT PASS TRACKER: Allows for you to monitor when a pass was set up and keep a check of how frequent it is used.

You’ll need to copy some of the sections to expand. Not a spreadsheet for the faint hearted, but you’ll only ever need THIS spreadsheet.