Download the Error Spreadsheet below. Look for an error in it. Are all the letter grades correct based on the scores? (Hint: No) Find out which ones are wrong and correct them. Then post to this forum saying what the problem was and how you corrected it. Also attach your corrected spreadsheet.
You can manually enter the formula for each student or use the copy method to copy the formula all the way down the column to calculate the average for each student.