Grades Spreadsheet

OK, time for your Excel project!

You are going to produce a spreadsheet for calculating the final grades for a set of students.
The assignment needs to include:

• Your sheet should include 15 students listed with both first and last names in separate columns.
• You will also need to include at least ten different assignments.
• Each assignment will need to include a spot for the name of the assignment, and another cell to put the maximum score possible for that assignment.
• For each student you need to calculate the total points earned, and the final percentage.

I will be teaching how to do these later:

• We will also be working on having Excel incorporate the school's grading scale to give a letter grade for the assignment.
• Highlight low or missing grades.

This will be due on February 8, 2005.