This photo shows a list of students and their quiz grades over the course of time. By using Excel, a teacher can easily and correctly calculate the averages for each student.
The next image shows an additional column with each students scores averaged for all the quiz scores represented. Using Excel can mitigate the human risk factor for making an error. The grades need to be entered correctly to start, but calculating the scores can become more automated.
Teachers can also use Excel to compare overall performance on the assignments. This link will show some additional calculations that were included from the original set of test scores. Being able to see high performance and low performance can help a teacher respond to the students that need the most help. They can also see the average score for the class and figure out if the class as a whole needs more review.
A teachers primary role is to ensure students are comprehending the subject matter. Reviewing results in an aggregate and singular manner will help to show if the material is being understood.
No comments:
Post a Comment