gasrasample.blogg.se - Grade book template

#Grade book template how to#
#Grade book template manual#
#Grade book template professional#
#Grade book template download#

Note that the error indicator will not print. It’s a good idea to leave the error indicator as a visual confirmation of the change.

#Grade book template manual#

Note: All students who have manual grade percentage calculation will have an error indicator (green triangle) in the top left corner of the cell. The Undo step is not required for subsequent changes.

If this is the first time a manual change has been made to the percentage entries in the workbook, click Undo to reverse the automatic calculated column.

Replace TotalPoints in the formula with the new numeric entry and press Enter.

The formula will appear as: Points Earned]]/TotalPoints,””)

In the row for the student, select cell under the percentage (%) column.

To manually calculate a student’s grade percentage, do the following: Manually calculate a student’s grade percentage

Right-click the highlighted rows, click Insert and select Table Columns to the Right.

Then drag and drop your cursor to column L. For example, to add 3 new columns to the table, click Assignment name3 to select that cell.

Click the last assignment name in the Excel table to select that cell and then drag your cursor to the right and highlight the columns you want to add.

Right-click the highlighted rows and select Insert.

For example, if you have 26 students in your class drag the cursor from row 7 to row 30.

Drag the cursor down to the row number you want to insert.

Click the row number next to the last student name in the Excel table.

You must keep data in at least one student name row, one assignment name column, and one Total Possible Points cell populated with data to preserve existing formulas. Important: Each assignment has a matching entry in the Total Possible Points table. To add more assignments to the spreadsheet, you’ll want to insert more columns into the Excel table (instructions below).

Fill in assignment information, such as the assignment name, due date, and total possible points.

To add more names to the spreadsheet, you’ll want to insert more rows into the Excel table (instructions below).

Fill in your own data, such as the name of your class, your name, and the names of your students.

Read and then delete the light brown callouts.

To customize the template, you’ll need to: For example, in the screenshot below notice how the letter grade and percentage is calculated based on the total points possible and the individual student’s total points earned. We added the placeholder data to the template to help you see what it should look like.

#Grade book template download#

Note: You can also download this template from Delete placeholder dataĪfter downloading the template, you’ll see three rows of student names, three columns with assignment names and grades, and some helpful tips in light brown callouts.

Click File and then click Save As to save a local copy of this file. The template will open as a new Excel spreadsheet.ħ. Click the Gradebook with printable student progress report template.Ħ. In the Templates search box, type gradebook and then click the search (magnifying glass) button.ĥ. Or, if you prefer to scan through instructions, look below for the step-by-step procedures.Ĥ.

#Grade book template how to#

This short video shows you how to download, use, and customize the template. It even includes a printable student progress report! We built the template in Excel 2010, because of all the new 2010 data visualization features. In fact, all of the grade calculation formulas are taken care of for you. It’s built for teachers with little to no Microsoft Excel experience.

#Grade book template professional#

Earlier in the year I worked with Beth Melton, an Excel Microsoft Most Valuable Professional (MVP), to create a super easy and visual gradebook template in Excel 2010.