TIE 300 - Excel Gradebook -
10 Points 

welcome
about us
professional development
projects
teacher resources
technology resources
search
contact us
 
Create a spreadsheet using Excel that can serve as a grade book for a hypothetical class.
  1. Enter at least 15 student names.

  2. 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)

  1. Give the students grades (use percentages ranging 0 to 100)

  2. 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)

 

 

 

 

 

 

 

Add to Your Favorites

Home | About Us | Services | Projects
Resources
| Links | Search | Contact Us

ŠLT Technologies, Inc. 2005


Links verified weekly by Site Integrity

Click here for the current version of the page.


 Last Updated 04/18/08