Thursday, February 4, 2016

Numbers 1.1

New apps and websites are helping teachers be more efficient in the classroom. Promethean boards, game apps, and websites keep students engaged with learning by making curriculums more interactive. There are older technologies that teachers still need to rely upon to perform their jobs. Grading homework, tests, and projects over the course of a school year is demanding and requires attention to detail. A miscalculated average could be the difference between an A and a C for a student. For managing a grade book, Excel still offers efficient and simple ability to tool sets.


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