Advanced Student Performance Predictive Analytics Model

Develop a sophisticated Excel predictive model using multiple regression analysis that forecasts student academic performance across different subjects. The model should incorporate weighted variables including prior grades, attendance rates, extracurricular engagement, and socioeconomic indicators. Create dynamic VBA macros to automatically update predictions quarterly, with built-in confidence interval calculations and visual risk assessment dashboards. Include conditional formatting to highlight students at high risk of academic underperformance and potential intervention strategies.