Database Users and Tracking entries

Ok so i’m not even sure what this would be called but I couldn’t find it in the fourms so I’m posting here for help. I want to create a web page where i’m able to track “points” for a school. The idea would be that teachers would enter their email into an entry box on the page and select an event they had attended. The email would be logged and the teacher would receive points for their assigned team. I would need to be able to export the points from this page and show them to the school as needed. The teachers are assigned to “color” teams so I’d also want to change the color of the page to the color of that specific teachers team color once they enter their email.

I’ve found several plugins that allow me to manage a database with simple .csv uploads, but the rest of the functionality is a bit lost on me. I’m assuming i’d need to be able to utilize some type of PHP to talk back and forth through the server as needed but i’m lost really as to how I’d do this. I’m hoping someone has an easy way to do this. Thanks in advance