Finding a Marking Period Average (Use with lesson 1.3)

Who has the highest average in the first marking period?

Test Results

Student	#1	#2	#3	#4	#5	Average
George	75	77	89	73	82
Maria	88	94	72	78	84
Anthony	93	79	82	88	86
Karen	98	84	100	80	90
Suzanne	76	68	74	82	78

Design an Excel spreadsheet that can be used for finding the average of the scores above.

Questions

1. Who has the highest average?___________ What is it? ____________

2. Who can raise his/her average 5 points by changing one grade of the 5 grades?  Explain for each student

• George
• 
  
• Maria
• 
  
• Anthony
• 
  
• Karen
• 
  
• Suzanne       

3. What are the mean, median, and mode of the grades for each student?