In a project, the task is to create a platform where teachers can enter texts for the school reports of their pupils. Not all teachers should be able to enter text for every pupil. In fact, they should only enter text where their ID is assigned to the subject.
I have got an Excel file which has 9 sheets in total. 8 sheets are containing the data of the pupils, their subjects and corresponding teachers including the ID. Then there is one sheet that has all the names of the teachers and their IDs (for the mapping later on). The pupils can have different teachers for similar subjects (English is taught by two different persons in the same class) and they can have different subjects in general (Sports, Arts etc.). As I already mentioned, the teachers should only be able to edit or see the fields/cells that they are intended to edit.
This is what a list for one class looks like (example)
For now, I was looking on several approaches and systems, but as I am not a backend developer (although I can edit / modify systems to fit my needs). There was nothing that gave me a good solution.
A) Google Docs - Spreadsheet
They offer protected cells, but you have to assign them one by one. Or is there a way to create a script that can lock / unlock a field based on the value of another field? At least, I did not find this and still - how should I find out the ID of the user that is currently signed in?
Maybe there is a CMS that offers the ability to hide text fields from users? I could create the users in the backend/frontend from the excel list and then they need to login to enter the texts. But the texts need to be stored somewhere →
C) individual SIMPLE Database / PHP solution
Is this maybe a really easy task for a simple database / PHP script? The Excel data could be loaded into the database and then be altered via a PHP page. I think that the task is not that complicated - but I really have no idea where to start.