Student Performance Analytics Dashboard with Dynamic Tracking

Design an advanced Excel dashboard that automatically tracks student performance across multiple metrics, including weighted grade calculations, trend analysis, and predictive performance modeling. The dashboard should include conditional formatting to highlight at-risk students, automatic trend line generation, and the ability to input raw assessment data that dynamically updates all visualizations. Implement VBA macros to generate personalized intervention recommendations based on performance gaps and create a drill-down capability for detailed student analysis.