Student Performance Cohort Analysis with Dynamic Segmentation

Design an advanced Excel workbook that tracks student performance cohorts across multiple academic years using dynamic pivot tables and array formulas. Create a system that automatically segments students into performance quartiles (top 25%, upper-middle, lower-middle, bottom 25%) based on cumulative GPA, standardized test scores, and extracurricular engagement. The solution must include conditional formatting to visually highlight performance trends, with the ability to drill down into individual student metrics and compare cohort progression over time.