Instructions:   Be sur to save backup copies of your grades, just in case.
1. Fill in your school name, class info, student names, and student IDs (optional).  
2. Adjust the Grade & GPA table below to match the typical scoring system you use.
3. Fill in the assignment or test names starting in cell F16, along with the percentage that each is worth (e.g. "Final" and "50%").
4. Fill in the scores for each student on each assignment or test. The "Score", "Ltr Grade" and "GPA" columns are automatically calculated, but you can override them if you wish. The way the grades are computed, the average and final grade are incomplete until all scores (adding up to 100%) are in.
Note: Use the "Print Area" command on the File menu if you want to change what area prints.
 
   
   
   
   
   
   
   
 
    GRADE & GPA TABLE                        
  Score 0% 60% 63% 67% 70% 73% 77% 80% 83% 87% 90% 93% 97%  
  Ltr Grade F D- D D+ C- C C+ B- B B+ A- A A+  
  GPA 0.00 0.67 1.00 1.33 1.67 2.00 2.33 2.67 3.00 3.33 3.67 4.00 4.00  
Metro Christian Academy
Enter each assignment or test and its percentage of the total grade into the table below.
   
Michelle Stone  
3rd Grade Spelling       Assignment or Test Name Lesson 1 Lesson 2 Lesson 3 Lesson 4 Lesson 5 Lesson 6 Lesson 7 Lesson 8 Lesson 9 Lesson 10                                    
2004-2005 School Year       Percentage (100% total) 10% 10% 10% 10% 10% 10% 10% 10% 10% 10%                                    
Score, Ltr Grade and GPA are not valid until 100% of tests & assignments are complete.
STUDENT NAME STUDENT ID Score[1] Ltr Grade[2] GPA Lesson 1 Lesson 2 Lesson 3 Lesson 4 Lesson 5 Lesson 6 Lesson 7 Lesson 8 Lesson 9 Lesson 10                                  [3]
Casey Beck 21564 95.70 A 4 100 95 100 92 89 96 91 100 98 96                                  
Beau Berry 37582 95.20 A 4 95 90 95 96 98 98 95 92 97 96                                  
Leah Boegh 57483 93.10 A 4 95 100 93 91 88 91 86 95 93 99                                  
Emily Bynum 58694 98.00 A+ 4 100 95 97 100 98 97 98 95 100 100                                  
Link Canady 57125 84.10 B 3 80 85 83 90 82 84 83 86 80 88                                  
Jacob Chapman 35412 74.20 C 2 65 75 80 80 68 76 80 73 75 70                                  
Brian DeLaughter 95643 92.30 A- 3.67 90 95 98 90 90 92 94 92 88 94                                  
Katie Duncan 76354 93.40 A 4 90 100 96 92 90 95 93 96 92 90                                  
Andrew Gray 86854 81.10 B- 2.67 85 65 70 82 80 84 85 85 87 88                                  
Hannah Jackson 37521 96.60 A 4 95 100 97 90 100 100 95 94 97 98                                  
Madison Lane 23474 96.20 A 4 100 95 93 96 96 96 97 96 95 98                                  
Josh Lee 49284 91.60 A- 3.67 90 95 93 90 90 88 94 94 92 90                                  
Jacob Longa 47584 94.20 A 4 95 95 90 95 98 94 93 95 97 90                                  
Lydia Olsen 36452 93.80 A 4 100 90 94 98 93 93 91 90 95 94                                  
Rachel Row 47583 68.20 D+ 1.33 50 65 80 60 75 85 60 64 68 75                                  
Hannah Schmitz 42323 80.70 B- 2.67 80 75 80 78 80 85 83 81 85 80                                  
Meredythe Schooley 12132 94.50 A 4 90 95 93 96 96 95 97 96 90 97                                  
Tommy Seidel 34528 95.80 A 4 100 100 95 96 96 93 94 92 96 96                                  
Reid Strickland 38978 93.40 A 4 95 95 93 90 92 92 94 93 95 95                                  
Carl Zoellner 27384 92.30 A- 3.67 100 90 93 95 93 91 90 90 90 91                                  
                                                               
                                                               
                                                               
                                                               
                                                               
                                                               
 [4]                                                              
     
 CLASS SUMMARY   Score Ltr Grade GPA Lesson 1 Lesson 2 Lesson 3 Lesson 4 Lesson 5 Lesson 6 Lesson 7 Lesson 8 Lesson 9 Lesson 10                                  
 Average   90.22 A- 3.53 90 90 91 90 90 91 90 90 91 91                                  
 Highest Score   98.00 A+ 4.00 100 100 100 100 100 100 98 100 100 100                                  
 Lowest Score   68.20 D+ 1.33 50 65 70 60 68 76 60 64 68 70                                  
 
[1]
Cumulative score equals the sum of each individual score times its percentage weight. The cumulative score and grade aren't valid until 100% of scores are in.
[2]
Note that the GradeTable referred to in the formula in this column is the table of grades found at the top of this sheet.
[3]
INSERT NEW COLUMNS TO THE LEFT TO ADD MORE ASSIGNMENTS OR TESTS.
[4]
INSERT NEW ROWS ABOVE THIS ROW TO ADD STUDENTS.
Hosted by www.Geocities.ws

1