AnsweredAssumed Answered

Correct way to calculate grade by quarter

Question asked by mbond on Nov 6, 2018
Latest reply on Nov 6, 2018 by mbond

I would like to create an average of grades per quarter for each student

 

 

 

                        

Student table--related to grade table
Grade Table
F namedate
L name

quarter

Grade

 

There are 4 quarters each year

 

What would be the best way to calculate the average grades per quarter?

 

I am able to create the average of all the grades.

 

thanks

 

(Maybe I need to redesign the grade table?)

Outcomes