How to Make a Gradebook in Excel

1. Open a new Microsoft Excel 2010 spreadsheet. Click on cell 'A1' and enter in 'Name,' as this is the column where the student's names will go. Click on cell 'B1' and enter 'Points,' as this is where the student's points will be totaled. Click on cell 'C1' and enter 'Percentage,' as this is where the student's grade percentage will go.
2. Select cell 'D1,' and then progressing down the rest of the spreadsheet's top row, enter the names of the quizzes, homework assignments, tests, projects and anything else the students will be graded on. If you aren't sure how many of these you will have, just type in 'Assignment' as a placeholder, so that you have created enough assignment spaces to fill the entire quarter, semester or year.
3. Click on cell 'A2' and type in 'Points.' This row will be where you enter in the number of points each assignment will be worth. The number that you enter into this row will be for the assignment listed in that same column. Click on cell 'B2' and enter in '=sum(D2:Z2)' where 'Z' is the last column you have used for your assignments. This will give you a total number of points so the spreadsheet can make its calculations.
4. Click on cell 'A3' and type in the name of your first student. Continue to add names down the first column until you have added the entire class.
5. Click on cell 'B3' and enter the following formula: '=sum(D3:Z3)'. Then click on cell C3 and enter the following formula: '=sum(D3:Z3)/$B$2'.
6. Click and hold the mouse button on cell 'B3,' then drag the mouse over to cell 'C3' and release the button. Move your mouse over the fill handle in the lower right corner of 'C3,' then click and hold the mouse button. Drag the mouse down your spreadsheet to copy these formulas down the columns. When you reach the row where your last student is located, release the mouse button.
7. Click on the 'C' above the third column. Click the 'Home' tab at the top of the window. Then click the drop-down box in the Number area of the ribbon. Choose 'Percentage' from the list of choices and your grades will now display as percentages.