Can anyone help, I am trying to work out a grade average for students in my class. I have converted the grades to points in a lookup table so that their grade level is traffic lighted according to whether they are below,on or above their target level but I also want to be able to work out their average grade level too.
I am an Excel newbie, have very basic knowledge (I'm a History teacher, I don't use formulae on a regular basis) and have only got this far on my worksheeet by finding other bits and pieces out on the web.
Can someone help me with a formula to work out the average grade???
Thanks
Bookmarks