

Create a spreadsheet using Excel that can
serve as a grade book for a hypothetical class.
(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.educationworld.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
 ŠLT Technologies, Inc. 2005 Click here for the current version of the page.
