|
|
To make a grade book truly useful, the grades need to be totaled and averaged. Then the teacher and student
will know how well the material has been learned.
Formulas are the mode used to make the grade book come to life. This is how to make that magic happen!
Several changes have happened. A row was inserted ("Insert" "Row") so that the total points per assignment could be entered. ( A teacher might also like to insert a row and put the date the assignment was given.) The data was entered for the point per assignment. Three new headings were added to columns "E" ~ "Student's Total Points", "F" ~ "Student's Grade", and "G" ~ "Percent" and also row "10" ~ "Averages". A teacher might like to know how well the students did on each assignment, therefore the average for each assignment. In Excel you tell the computer what mathematical operation you want to perform by the use of formulas. There is also a shortcut for these frequently used formulas.
The AutoSum icon  when clicked will add the data Excel thinks you want to add. Be sure Excel knows what you want to add.
|
|
| You will need to use the add or "AutoSum" default in Column E3 through E8 to determine the Students' Total Points. |
|
When you want to average numbers, you can pull down the "AutoSum" menu and choose "Average". Excel will enter a formula and suggest what cells it thinks you want to average, as seen in the example. The program thinks you want to average cells B2:(through)B9. You do not need cell B9 included in the average even though in this situation it will not change the results. To have only the exact cells in the formula, you select the cells you want. Then hit "Enter".
|
|
To figure the student's grades, you need to see what percent of points they received out of the total or 40 points in this illustration. So you will need to use a formula that has the students total points (column E3 for Rob) divided by the total points for the assignments (E2). You can see that a formula has been entered to figure the assignments total. (That allows that answer to change as more assignments are added.) Thus when we figure the grade, the number of total points needs to be able to change also. To do this an Absolute cell reference is added. To make a cell reference absolute, a dollar sign is inserted in the formula. See this in the example.
|
|
| For those who hate math and are uncertain how to convert decimals to percents, Excel has a handy help for you! On the Formatting toolbar there is a percent sign, just click on it and the decimals will become percents. |
 |
| If rounding is not your thing, then you can have Excel do that for you also. In cell E10 or F10 you can decrease the decimal clicking on the "Decrease Decimal" button. On the other hand if you needed to have more decimal places showing, you would click on the "Increase Decimal" button to the left of the "Decrease Decimal" button. |
 |
Any cells that you want to automatically be formatted for currency, should be selected and the dollar sign ($) clicked.
Back to top |
|
| |
|
|
