Excel Gradebook and Chart Assignment
By
Ima Sample
I. Student Grades (Data)
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
II. Comparing Student Performance
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Critical Thinking/Discussion Section This graph represents (via bars) the scores on 3 midterm quizzes covering the major topics taught in the first seven weeks to section 2 of Technology in the Classroom. Overall the class performed very well, with the average score at 83% and with the vast majority of the class achieving scores in the upper 80th or low 90th percentile. Student Red is a clear anomaly, having achieved a significantly lower score than the average (only 20% correct). Implications: It is necessary that the teacher speak with student Red as soon as possible to determine what caused him/her to achieve such a low score. It is possible that student Red does not understand the material and needs additional help and/or to have the material re-taught.
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
III. Average Student Grades
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Discussion/Critical Thinking sections: This graph shows the average score for all of section 2 on the 3 midterm quizzes given in Technology in the classroom. The overall achievement across the three quizzes is very good. However, the average score on the first quiz is a great deal lower than the average scores for Quizzes 2 and 3 (the average score for quiz 1 was 74%, while the scores for quizzes 2 and 3 were 88% and 87%, respectively). . Implications: There could be a number of causes for the scores for quiz 1 to be lower, with those from quizzes 2 and 3 to be higher. The instructor should consider the following:
The instructor needs to determine the causes for the low score on quiz 1 and correct it quickly. In the future, it might be advisable to check for understanding at the end of each unit, possibly with a mini quiz. Clear instructions of the material to be covered on the midterms would also help students to prepare and therefore increase achievement scores.
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|