Personal and Class
Customizing your Grade
Book template is easy. The first thing that you will want to do is
to change the generic labels for your college, name, and class to
reflect your custom information. To change any of these, place your
mouse pointer over the text to be changed and click the left mouse
button. Delete the existing text and replace it with your information.
You can customize the grading
scale included with your Grade Book template by changing the percentage
values in the row labeled "Average." The percent value over
each letter grade represents the lowest possible percentage of total
points that a student can earn and receive that grade in the course.
The same system applies to the values for the GPA.
To change the default values
in the Grade Book template, click in the table cell that contains
the value to be edited. Delete the current value and enter the lowest
percentage value that would earn a student the corresponding letter
If you do not grade on a +/- scale, you can delete these letter grades
and their corresponding "Averages and GPA's." However, this
must be done with care. This table is used to automatically calculate
letter grades and GPA's in the student table. If you do not delete
columns properly, the Grade Book template may not be able to correctly
calculate letter grades or GPA's.
To eliminate a letter grade,
use your mouse to select the three cells containing the letter grade
and its corresponding average and GPA. You can do this by holding
down the Shift key on your keyboard and then clicking
each of these cells. Next, open the Edit menu at
the top of the window and select Delete. In the Delete
window that opens, make sure that you click the button next to "Shift
cells left." Then click on the OK button. The
grade that you delete should disappear and all of the cells to the
left of it in the "Grade & GPA" table should shift left
to fill in that space.
For this assignment you
will be adding ten assignments to your Grade Book For each assignment,
you will need to enter a name and a grade value. The grade value reflects
the assignment's value relative to the final grade. What these values
are will depend on the method you have chosen to calculate your final
to the Roster
To add students to your
roster, click in the first empty cell in the "Student Name"
column, then, enter the student's name (if you enter it last name
first, you will be able to sort your roster alphabetically once all
of the students are entered). Next, enter the student's ID number
in the cell next to his/her name. You can enter up to forty students
on the roster for this assignment your roster will include 14 students.
When you are done entering
students on your roster, you will be able to sort the list by student
name or ID number.
While you will not be using
this function for today's assignment, it may be useful to you when
you use this Grade Book in your classroom. There are several entries
in the Grade Book template that are calculated automatically for you
(average or score, letter grade, and GPA). Occasionally, it may be
necessary for your to override the automatic calculation; for instance,
you might choose to change the letter grade of a student who worked
exceptionally hard but missed the next highest grade by a narrow margin.
To override a value in
any automatically calculated cell, simply click on that cell, delete
the current contents, and enter the value that you wish to have displayed.
Keep in mind that once you have done this, the formula that was contained
in the cell will be erased.