SpreadSheet Exercise #2

Spreadsheet Exercise #2 by (your)(name)              
Names Hw1 Hw2 Hw3 Hw4 Hw5 Hw Avg. Ex1 Ex2 Ex3 Exam Avg. Final Grade totals  
Koffan, Stevan 33 55 69 76 65   87 96 59     540  
Davis, Rolland 67 78 76 54 23   99 87 65     549  
Bunch, Donnie 67 65 57 89 95   65 55 64     557  
Moon, Angelica 88 78 67 56 54   87 55 77     562  
Morros, Karen 67 65 49 87 83   76 88 87     602  
Long, Dustie 78 76 74 54 67   78 99 88     614  
Fletcher, Julia 89 87 67 68 79   56 89 87     622  
Wilson, Patsy 68 76 57 83 76   88 99 83     630  
Hudsun, Dwane 77 66 59 97 78   94 93 92     656  
Striclan, Ginger 85 90 87 82 81   94 92 96     707  
                        6039  
totals 719 736 662 746 701   824 853 798     6039  
                           
Formula for Final Grade = HwAv. is 40% & ExAv. is 60%.          
Column Width of A should be 16, while G & K & L & M should be 6.
 
    
Column Width of others should be 4.                  
Row Heighth of 1 should be 24 & row 2 should be 32, while all others should be 16.    
Numbers should be aligned center horizontally.              
Be sure that all cells are Times New Roman and font size 12.          
Rows 13 & 14 and Column M are for informational purposes only.
 
    
Finished product will be A1 to M14, inclusive.              
                           

Last Updated on 9/23/99
By Dr. Bruce Lewis
Email: rblewis@fhu.edu