Automated Student Performance Tracking Dashboard

Create a Google Sheets script using Google Apps Script that automatically generates a dynamic performance dashboard pulling real-time grade data from multiple source spreadsheets. The script should calculate weighted averages, generate color-coded performance tiers, and automatically email personalized progress reports to students and parents. Include error handling for missing data and implement a modular design that can adapt to different grading systems across multiple school departments.