Dynamic Student Performance Tracking Dashboard

Create an advanced Excel dashboard that automatically calculates and visualizes student performance metrics across multiple assessments. The system should dynamically update with conditional formatting to highlight performance trends, calculate weighted averages, and generate predictive learning intervention recommendations. Include pivot tables that segment performance by subject, student demographic, and assessment type, with automatic color-coded heat maps indicating potential at-risk learning zones.