CurlingGal
New Member
- Joined
- Sep 26, 2004
- Messages
- 13
I have a gradebook I have written.
Assigments are designated as C, H, and T.
I want to determine averages by the assignment type.
C H T C C C H H H C T <----Type
20 15 100 20 20 20 15 15 25 20 100 <----- Max Value
16 15 88 20 15 16 10 15 22 20 93 <---- Student Score
The student has 4 'grade columns'; one for each type, one for total.
They are to read in percentages.
How do I get Excel to compile the Assignment Type grades?
I am keeping all data on one tab, for ease of use in my pda.
Assigments are designated as C, H, and T.
I want to determine averages by the assignment type.
C H T C C C H H H C T <----Type
20 15 100 20 20 20 15 15 25 20 100 <----- Max Value
16 15 88 20 15 16 10 15 22 20 93 <---- Student Score
The student has 4 'grade columns'; one for each type, one for total.
They are to read in percentages.
How do I get Excel to compile the Assignment Type grades?
I am keeping all data on one tab, for ease of use in my pda.