How do a I use a spread sheet to track grades?
Nicole
To get an average use the AVERAGE function as in =AVERAGE(A1:A50)
To convert scores to letter grades use a Lookup table and VLOOKUP functions.
OR a Lookup formula without a table
Assuming scores are in column A starting at A1.
In B1 enter this formula then drag/copy down column B
=LOOKUP(A1,{0,31,41,51,61,71,81,91,101},{"E","D"," C-","C","C+","B","B+","A"})
Example only. Adapt for your scores and grades.
Note the curly braces internally.
Gord Dibben MS Excel MVP
On Tue, 10 Jan 2006 16:16:03 -0800, "NicoleLT06"
wrote:
I'm trying to use Excel, which I know is possible, to set up a grade book
without using a template. I can enter students and points, I just don't know
how to get it to average and give a letter grade. I don't want to download a
template because I know there's a way to do it without one.
|