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 10 minute segments. This is the fifth post of the series, and this instructional video runs less than 10 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 “Grouping” tool as well as investigate some great formulas that will help you instantly locate the largest and smallest values in your student data, as well as the median, and any other percentile.
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/
Segment 4 can be accessed at: https://blog.discoveryeducation.com/blog/2014/03/12/microsoft-excel-for-educators-segment-4/
Please be on the lookout for Segment 6 of this series where we will explore more….
Please do leave comments, suggestions, questions as you see fit. Please enjoy.