Create a spreadsheet using Excel that can
serve as a grade book for a hypothetical class.
- Enter at least 15 student names.
- Use the following assignments:
Vocab quiz 1 (10% of grade)
Vocab quiz 2 (10% of grade)
Vocab quiz 3 (10% of grade)
Chapter test 1 (15% of grade)
Chatper test 2 (15% of grade)
Final presentation (20% of grade)
Final exam (20% of grade)
- Give the students grades (use
percentages ranging 0 to 100)
- Use a formula to compute the final grade
for each student and class averages for each assignment and for the final
(Hint, the formula must weigh each
assignment appropriately. You cannot just take an average of all the grades. For
example, if the total number of points were 20, and one assignment was worth 5
points and the other was worth 15 points, the formula to compute the final grade
(given scores as percentages) would be (score1*5 + score2*15)/20).
These resources may prove helpful:
(this one is the most detailed regarding the formula you will need)
(very comprehensive resource, for Excel 97 but most of it should still work,
especially the stuff about formulas)
Add to Your Favorites
Home | About
Us | Services | Projects
Resources | Links | Search | Contact
ŠLT Technologies, Inc. 2005
Links verified weekly by
for the current version of the page.
Last Updated 04/18/08