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 second post of the series. It will be beneficial as you view the 15-20 minute 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).
This second video focuses on Excel’s formatting and conditional formatting features. The ability to use these tools can help us build a set of student data that we can wrap our head around, and also allows us to get some factual information from the data very quickly.
Segment 1 can be accessed at: https://blog.discoveryeducation.com/blog/2014/02/06/microsoft-excel-for-educators-segment-1/
Please be on the lookout for Segments 3 and 4 of this series where we will explore the following:
The “IF” functions (Sumif, Averageif, Countif)
The “IFS” functions (Averageifs, Countifs)
And we’ll keep it going from there. Please do leave comments, suggestions, questions as you see fit. Please enjoy.