Microsoft Excel XP/X
Gradebook: Phase 3: Entering the Grades
Once you have your gradebook framework established, you are ready to enter grades. Depending on your working style (and timeframe), you may want to add the formulas and functions for calculating grades before entering them. If that is the case, skip to Calculating Subtotal Points and Percentages and return to Entering the Grades when you are ready to enter grades for individual projects, quizzes, or assignments.
Entering the Grades
Use the following steps to enter students' grades after each grading event in the semester or all at once.
-
Open your gradebook
-
Place your insertion point within the appropriate cell
-
Type the grade for the student
-
Windows: To continue with the next student, press [Enter]
Macintosh: To continue with the next student, press [return]
The default Excel setting is to take you to the cell beneath the current cell. -
OPTIONAL: Repeat steps 1-4 as necessary
NOTE: It is easy to share grade information with your students through personalized emails created with Word's Mail Merge and your gradebook. For more information, refer to Creating an Email Merge.
Using Freeze Panes
If your class is large, you will want the grade headings to remain stationary at the top of the worksheet as you enter grades. If you have many items that you are grading (many columns), you will want to see the student names when you enter grades in the far right columns. Freezing panes will allow you to do both.
Freezing a Row and a Column
-
Place your cursor in the cell below and to the right of the row and column you want to freeze
-
From the Window menu, select Freeze Panes
The row and column above and to the left of the cursor are frozen.
Freezing a Row
-
Within column A, select the row directly below the row you want frozen
-
From the Window menu, select Freeze Panes
The row is frozen.
Freezing a Column
-
Within row 1, select the column directly to the right of the column you want frozen
-
From the Window menu, select Freeze Panes
The column is frozen.
OPTIONAL: If you would like to print frozen columns on every page, refer to Repeating Items on Each Page from Other Excel Printing Options.
Unfreezing Rows and Columns
- From the Window menu, select Unfreeze Panes
