I'm in the process of setting up tracking grids to use as Transition Matrices for our KS3 pupils. I was hoping that once I had set them up (I am the administrator) then they would be available for other staff to view, much as marksheets are available for them to view once I've set them up.
I discovered to my dismay that this doesn't seem to be the case - if a member of staff logs onto SIMS they can see the tracking grid templates but not the grids that I've set up. Does anyone know anything about this?

Also, does anyone know how to make Tracking grids more user friendly from WITHIN SIMS eg. adding a key for colours that I've put on the template? I can do this in EXcel but it's very time consuming. I'm trying to learn how to automate the procedure using a macro but I'm not there yet!!