A Grade Book in Excel
Technology in the Classroom
Fall 2006
I. Student Data
|
|
Quiz1: |
Quiz2: |
Quiz3: Troubleshooting |
Student totals |
Student percentage |
|
Student_A |
6.67 |
8.33 |
6.4 |
21.4 |
71% |
|
Student_B |
6.67 |
3.33 |
6.4 |
16.4 |
55% |
|
Student_C |
8.33 |
8.33 |
7.6 |
24.26 |
81% |
|
Student_D |
8.33 |
10 |
7.6 |
25.93 |
86% |
|
Student_E |
8.33 |
8.33 |
10 |
26.66 |
89% |
|
Student_F |
6.67 |
8.33 |
8.8 |
23.8 |
79% |
|
Student_G |
10 |
10 |
8.8 |
28.8 |
96% |
|
Student_H |
10 |
6.67 |
10 |
26.67 |
89% |
|
Student_I |
6.67 |
6.67 |
5.6 |
18.94 |
63% |
|
Student_J |
5 |
5 |
7.6 |
17.6 |
59% |
|
Student_K |
8.33 |
8.33 |
10 |
26.66 |
89% |
|
Student_L |
8.33 |
8.33 |
10 |
26.66 |
89% |
|
Student_M |
6.67 |
8.33 |
8.8 |
23.8 |
79% |
|
Student_N |
6.67 |
8.33 |
10 |
25 |
83% |
|
Student_O |
6.67 |
8.33 |
8.8 |
23.8 |
79% |
|
Student_P |
8.33 |
8.33 |
7.6 |
24.26 |
81% |
|
|
|
|
|
|
|
|
possible pts. |
10 |
10 |
10 |
30 |
|
|
sum |
121.67 |
124.97 |
134 |
|
|
|
quiz avg. |
7.6 |
7.8 |
8.4 |
|
|
This is the raw data, with student names on the left, their scores in the fields in the middle, and an average on the right. Summaries are below the main fields.
II. Comparing Student Data
This chart is a visual representation of the scores for three quizzes, broken down by student and score. Each line represents a different quiz, (refer to the legend below the chart) and the student’s scores are shown directly above their name.
III. Average Student Grade
The Average Student Grade chart visualizes the average score for each quiz. This shows at a glance how the class fared for each quiz, revealing differences in the students’ wealth of knowledge, or perhaps a divergence in the difficulty level of each quiz.