Formula Help!
I am trying to get better at Excel and am having trouble with formulas.
I would like to calculate the average grade for the homework assignments as well as calculate the current final grade for every student in the class.
The formulas need to take into account that there will be blank cells, as grades are given throughout the semester and I would like the current average and final grades to update with every additional grade.
The "Current Final Grade" cell needs to take into account the weighted grade scale and return a letter grade in R2.
The weighted scale is:
Quizzes 10% (column O)
Discussion 30% (column N)
Assignments 35% (columns C through M )
Midterm 10% (column G)
Final 15% (column M)
Spreadsheet attached.
Thanks in advance!
| Attachment | Size |
|---|---|
| grade_sheet_problem.xlsx | 10.46 KB |
Frequency Distribution?
Have you tried FREQUENCY function?
what values to take for grade as its given in range ?
what values to take for grade as its given in range ?
for example if one students gets grade B than waht value should i take for that grade as it is given in range 86-83 and what values to quizzes if he gets b grade.
yes i can make this table if above mention things are clear