|
- 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 grades.
(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:
http://www.education-world.com/a_tech/techtorial/techtorial064.pdf
http://spider.georgetowncollege.edu/t3/Tutorials/gradebook.htm
http://storywind.net/education/mccarthy/lessons/exceltutorial.html (this one is the most detailed regarding the formula you will need)
http://www.shuntington.k12.ny.us/tutorials/SimpleGradebook.pdf
http://www.microsoft.com/Education/Excel97Tutorial.aspx (very comprehensive resource, for Excel 97 but most of it should still work, especially the stuff about formulas)
Home | About Us | Services | Projects |
Resources | Links | Search | Contact Us
ŠLT Technologies, Inc. 2005
Links verified weekly by 
Click here for the current version of the page.
Last Updated 04/18/08