Using Excel - Averaging a Row of Grades
Use this guide when you want to get an average score for a set of student
grades. This activity assumes that you have entered your student names, some
assignment categories, and some grades.
Set up the first student's average
- First, you need to have an empty column where you want your added or averaged
numbers to go. If you don't already have one, go to insert and column.
This will insert a column before the column you have your cursor on (for
example, if your cursor is in B, a new B will be created and your cursor will be
in C).
- Put your cursor in the cell where you
want your first student's grade added/averaged.
- Click on the Paste Function
button (it looks like a cursive F and X).
- Choose
the function you want (sum or average or any of the other stuff there - it
all works the same way) then click OK.
- A box pops up in the upper corner of your screen. Minimize
the box by clicking
on the red arrow to the left of the first entry box.
- Highlight the
grades you want to add/average.
- Select multiple contiguous cells by holding
the mouse button down and dragging the cursor across the cells you want.
- Select non-contiguous cells by pressing the Control (Ctrl)
key on your keyboard and selecting as many cells as you wish.
This is useful if you only want an average of quizzes, for
instance.
- Return to your Paste Function box. You'll see a little red arrow
towards the top center of the row of letters. Click on it to maximize the Paste
Function box.
- The cells you selected now appear in the Number box. All you
need to do now is click OK and the added/averaged grades should appear in the
original cell that you selected.
Set up every student's average
You
will probably want to do this for all the students in the class. Once you've set
it up for one student, you can copy this function to the rest of the
class.
- Highlight the cell where the first added/averaged grade
is.
- Move your cursor to the lower right of the cell. The cursor
should change to a thin cross.
- Click on your mouse and drag the cursor
down the column, selecting as many cells as needed to include all the
students.
- Release your mouse. The formula will automatically copy to
the other cells.
Last updated:
January 23, 2007
|
