I tried calculations but it only seems to be affecting the course total (Advisory), not the category total (Science for example) I'm trying to alter. But perhaps I'm going about this the wrong way.
My school has mixed-grade "advisories". One teacher is responsible for all the subject grades for students in multiple grade levels. Integrated assignments are weighted differently into four to six seperate courses. I am trying to set up a system where the teacher does not have to enter the same grade for the same student in multiple course gradebooks.
In other words, certain grades in the Advisory course need to be pushed into the student's Science course, some of the same gades (and a few different ones) need to be pushed into their Social Studies course etc. To complicate it even further, not all students in the same advisory are in the same courses. For example one student could be in Math 9 while another could be in Math 11 while another studnt may not even have a Math course.
Right now we do all this with an excel system that I set up to generate class grades and report cards. Then our registrar has to go back and manually create credit checks for each student.