Welcome all to a new week of Excel for Educators where I’ve tried to take some of the things that I do in my work with the Analytics, Research and Evaluation team here at Discovery Education and frame them in the perspective of the classroom teacher, and then divide them into 15-20 minute segments. This is the fourth post of the series, and this instructional video runs just 9 minutes. It will be beneficial as you view the videos to also have the companion worksheet open so that you can try things in a hands-on environment as you see them (http://linkyy.com/excelforeducators).
In this video we will explore Excel the averageifs tool as well as investigate a great shortcut to quickly convert numbers to percentages in your gradebook.
Segment 1 can be accessed at: https://blog.discoveryeducation.com/blog/2014/02/06/microsoft-excel-for-educators-segment-1/
Segment 2 can be accessed at: https://blog.discoveryeducation.com/blog/2014/02/11/microsoft-excel-for-educators-segment-2/
Segment 3 can be accessed at: https://blog.discoveryeducation.com/blog/2014/02/20/microsoft-excel-for-educators-segment-3/
Please be on the lookout for Segments 5 and 6 of this series where we will explore more….
Please do leave comments, suggestions, questions as you see fit. Please enjoy.