Thursday, August 22, 2013

How to Use Excel 2007 for Student Grades


1. Type 'Student Name' in cell A1.
2. Type the names of each assignment in Row 1, starting with the first one in cell B1, directly to the right of the Student Name text.
3. Type 'Total' in Row 1, in the column directly to the right of the last assignment.
4. Type each student's name into column A, starting directly below the 'Student Name' text.
5. Type the number of points each student earned on a given assignment in the appropriate cell.
6. Type '=SUM(' in the first cell directly underneath the 'Total' text, then highlight each cell in the row that corresponds to an assignment going back to the first student. To highlight, click the first assignment cell and drag the mouse to the last assignment cell, making sure to select only one row of data. Press 'Enter.' This should display the total number of points this student received from all the assignments, in the Total column.
7. Highlight the 'Total' cell you just created, by clicking on it.
8. Copy the cell by pressing 'Ctrl' and 'C' at the same time.
9. Highlight the cells for each student in the Total column by clicking on the cell directly below the cell you just copied, and dragging the mouse to the very last row that contains a student name. Make sure you select cells only in the Total column.
10. Paste the Total formula by pressing 'Ctrl' and 'V' at the same time. You should see the totals for each student appear in the appropriate row in the Totals column.

Blogger news