Save time with an electronic grade book
To manage grades, Office Excel 2007 can help you:
- Enter, view, and change data. The basic function of an Office Excel 2007 worksheet is to help you lay out your data so that it is easy to understand and work with.
- Do the math. The worksheet can have columns or rows that contain formulas for efficiently adding or averaging lists of numbers and for displaying grades or percentages. You enter individual test and homework scores, and the final grades can be automatically calculated.
- Manage the data. You can convert the data to an Office Excel 2007 table and then use the useful table tools to help you manage your class’ database. You can even go beyond simply tracking grades to create a master database of student information, including names, quiz scores, averages, phone numbers, seating charts, and more.
Keeping track of grades is easy with Microsoft Office Excel 2007.
You can create a grade book from scratch, download a grade book template from Microsoft Office Online, or create your own grade book that is based on a template that you download. To create a grade book similar to this sample, follow the steps below.
Enter, view, and change data
To create your grade book, think of the rows in the spreadsheet as student records, and think of the columns as fields for holding a grade or score, or a formula for calculating averages. For example, create a field for each graded assignment, test, quiz, and oral report. Also, create fields for any other item that can affect the grade, such as participation or cleaning up after lab. Then, add fields for totals and averages.
Before you add actual student names and grades, save the worksheet as a template. Then, you can use the template to create a new workbook for each of your classes.
- Enter placeholder student names in column A, starting in cell A3.
- In row 2, which is the header row that contains the names for each column or field, enter these names:
- In A2, enter Student Names, or since that is obvious, enter an identifying name for the data, such as the name of the class.
- In B2, enter Total Average. This column will contain formulas for calculating the overall grade percentage.
- In C2 through F2, enter group names for the types of graded work, such as Quiz/Lab, Tests, Homework, and Participation. Except for Participation, these columns will contain formulas for calculating grades of each type. You must enter Participation scores manually because no formula is necessary.
- Starting in G2, enter the names of each item that is graded, such as quizzes, tests, and homework assignments. Group the names, so that items of the same type are in adjacent cells.
- Use Fill Color formatting to color code the item groups. For example, color the homework cells red and quiz/lab cells green.
- To give the names a vertical orientation, select the column names. On the Home tab, in the Cells group, click Format and then click Format Cells. And then, on the Alignment tab, change Orientation to 90 degrees.
- Save the workbook as a template.
When you are ready to set up a grade book for a class, use this master template to start a new workbook, and then replace the name placeholders in column A with actual names.