We would like to share some advanced formulas and strategies that we use to regroup students in Google Sheets. We will be focusing this session on mastering the formulas, VLookup, Countif, Countifs, CountA, Index/Filter, and Unique. These can be intimidating to many, but being able to implement them efficiently will make data disaggregation more effective.
This session will be geared towards Administration and Coaches who deal with / disaggregate student data. We will demonstrate how to use these formulas to compile student data quickly. We will show mock student assessment data from various fake resources and teach attendees how to use these formulas to get all of this data in the same place, and in a way that it can be used to drive decision making.
We want attendees to walk away with some new ways to think about data driven decision making, and the resources to be able to do it.
