How can I manage my students' grades?

Hello there !

I’m an IT teacher, and I come from Notion.
I’m trying my best to to configure Obsidian for the upcoming back-to-school and I’m getting nice results with pandoc and latex for my course sheets.
I’m trying to figure out if I also could keep in Obsidian the grades of my students. My ultimate goal would include few things :

  • I’d like to keep an up-to-date list of my students, per class
  • each time they will take an exam, I’d like to link the exam (md file) to a list of the grades obtained by my students for this exam
  • I’d like to be able to extract all the grades for a student, for a class, all the grades for an exam, automate average / median stats for each exam, student, class, somme nerdy charts as well.

My feeling is I may be trying to ask too much to Obsidian. Is it your feeling as well ?
I tried some things with dataview, with tracker… Nothing interesting came out.
Actually I don’t even know how I should organize my md files, nor which plugin could help.

Thanks !