Exercise of Grade Book in Spreadsheet
1. Create the following worksheet with the title SPRING 2003 COSI 118 in A1.
2. Make the title into the center of the first row by the following steps:
a. Highlight cells from A1 to J1.
b. Choose Format Cells.
c. Choose Alignment.
d. Choose Center Across Selection.
3. Enter formula =Now() in cell E2 and format it in current date and in cell F2 in current time.
4. Type in the following data
     
    SPRING 2003 COSI 118
    		  
             =Now() =Now()            
    NAME
    		 S. S. No. 
    HW1
    HW2
    HW3
    		 HW4
    Average HW
    EX1
    EX2
    Final Exam
    Score
    Grade
    Weight          
    30%
    20%
    20%
    30%
    		    
    Pattton, A. 0123
    51
    60
    70
    		 84  
    76
    72
    70
    		    
    Barron, K. 1234
    93
    73
    89
    		    
    85
    82
    90
    		    
    Nichols, T. 7890
    68
    78
    80
    		 52  
    80
    80
    80
    		    
    Brown, R. 0001
    73
    90
    78
    		 99  
    82
    87
    89
    		    
    Lee, M. 8752
    82
    87
    		   78  
    78
    89
    85
    		    
    Daley, F. 3429
    66
    70
    67
    		 65  
    65
    67
    63
    		    
    Hill, B. 5247
    35
    56
    77
    		    
    56
    58
    57
    		    
    King, P. 9763
    37
    70
    80
    		 84  
    72
    90
    80
    		    
    Johnson, E. 3428
    80
    78
    		   75  
    45
    77
    65
    		    
    Johnston, D. 8971
    73
    75
    67
    		 98  
    63
    64
    65
    		    
    Count
    		                      
    Average
    		                      
    Maximum
    		                      
    Minimum
    		                      
5. Compute the average of homework for each student in column E.
6. Compute the final score by the weight system of row 4 for each student in column I.
7. Use formulas to compute the basic statistics for each column.
    For example: =count( ..)
                        =Average( ..)
                        =Max( ..)
                        =Min( ..)
8. Add your name by the following steps.
          Insert a row between Johnston D., and Count
          type your name in the first column
9. Sort sheet according to a descending order of final scores.
10. Assign grades based upon the following distribution:
    Final score: 90 and above A
                      80 and above B
                      70 and above C
                      60 and above D
                      below 60 F
11. Sort sheet according to an ascending order of students' names..