DMP Gradebook
Spreadsheet Templates
Guided
Excel Spreedsheet (up to 45 students):
Step-by-step instructions on how to setup
and use this spreadsheet are included in
the file. Setup by inputing your assignment
names and percentages, then just input letter
grades for each assignment -- spreadsheet
converts to numeric and calculates final
grade for you. Optional calculation of class
averages by assignment or class.
Guided
Excel Spreedsheet (up to 25 students):
Same as above, only smaller for lower-enrollment
courses.
Guided
Excel Spreedsheet with Writer's Notebook
/ Reader Response / Quiz Tracking (up to
45 students): Same grade sheet as above
only adds a section to track up to 15 Writer's
Notebook, Reader Response, or Quiz grades.
Give point grades for each individual assignment,
which are totaled and assigned a single
letter grade for the entire project. Single
letter grade is then inserted into your
gradebook and averaged based on your assigned
percentages.
Guided
Excel Spreedsheet with Writer's Notebook
/ Reader Response / Quiz Tracking (up to
25 students): Same as above, only smaller
for lower-enrollment courses.
|
