"Group grades" in Calc?
 

Hey all,

So, I have been using OpenOffice's spreadsheet, Calc, to hold (and calculate) grades of students.

Now, generally, I have them work in groups for several activities and get group grades. I have group names to distinguish them.

My question is, for Calc, how would it be possible to give a group a grade so that it will automatically give that grade to each of the students in the same groups (note that each student has a combination of individual and group grades)?