Sharing and collecting data with multiple users of different access levels

[JonesC]

Hi all.

 

I have been tasked with creating a system that will allow heads of department (HoDs) and SLT to add lesson observation details for all staff. They(SLT) then want individual staff to be able to access ONLY their data, HoDs to access data for their department and SLT to see all data.

 

I have thought about sharing an excel file, but this would just be too messy with all the staff (100 staff in total). Would a Database be better with leveled users ( but then how do I stop others from seeing data that was not related to them?)The school has offfice 365 with associated apps, I can't see one that is better for this type of system.

 

Does anyone have any suggestions?

 

TIA,

JonesC

[6Foot2]

File/folder visibility: With the relevant permissions in place, access-based enumeration will allow you to control which files or folders your staff users are able to see and are able to gain access to.

 

Link: Enable access-based enumeration on a namespace