Making your own grade book is an easy way to save money and customize your grading system to how you prefer (percentages, points, or averages). This will give you a template for future use in all your classrooms. Teachers who purchase grading software or download templates online may find these grade books do not meet their needs in terms of functionality and aesthetics. Making one gives you the freedom to put your own personal touches on the grade book.
Things You'll Need
- Microsoft Excel
- Twin Pocket Folder
Using your computer, open up Microsoft Excel and begin working in a new spreadsheet.
In the first cell (A1), type your class and section number (if applicable) as the title. The horizontal, or "x" axis of the spreadsheet, should be equal to the number of students in your classroom. The vertical, or "y" axis, should be equal to the number of days you will be taking grades or to the number of assignments and extra credit. The last cell should be titled "total" for the end grade of the class.
Save this spreadsheet as a template and then begin to input your information in the appropriate places: the students' names on the "x" axis, and the assignment or day of the week on the "y" axis. Make sure to save this document with a different name than the template on your computer and a secondary back up location.
Print your grade book as needed and place in a designated class folder.
- Photo Credit Jupiterimages/Comstock/Getty Images