EXCEL ASSIGNMENT for Data Processing Class

1.  Figure out the final grades for my speaking class!

 NAME 	  ATTENDANCE     NOTE 1 NOTE 2  TEST 	FINAL GRADE
 PERFECT 	30 	 60 	140 	100 
	
 tm 	        26 	 46 	138 	 74 	
 nr 	        22 	 49 	134 	 74 	
 nm 	        30 	 51 	137 	 81 	
 nn 	         0 	 44 	 60 	 74 	
 nk 	        26 	 25 	118 	 70 	
 hk 	        30 	 53 	126 	 77 	
 bk 	        22 	 59 	140 	 81 	
 hk 	        18 	 47 	 95 	 62 	
 totals 					
 averages 					


  Use formula = ATTENDANCE + (NOTE 1+ NOTE 2) /10 + TEST /2  


2.  Figure out the averages for each assignment and for the final grades.

NOTE: You will need to make the totals first.

   Use sigma and copy right for totals.

   Use = total / number of students  and copy right for averages.

3.  Tell the average to me or an assistant to find out if you are right!