Excel Dashboard for Student Analysis

Create a comprehensive Excel dashboard for analyzing student results with the following specifications:

Student Data (generate sample data for 30 students):

Each student has 4 School Term results (Term 1–4) and 1 final IB result
All subjects scored on a 1–7 point scale
Subject Rules:

Mandatory for all: Maths, Chemistry, Individuals & Societies (I&S)
LL (pick 1): English LL, Chinese LL, or Korean LL
LA (pick 1): Chinese LA or Korean LA — must be a different language from the LL chosen (e.g., Chinese LL → must pick Korean LA, and vice versa; English LL → can pick either)
Science (pick 1): Physics or Biology
Portfolio (pick 1): Arts, Music, or Design
Dashboard Requirements:

Raw Data Sheet — All 30 students with Term 1–4 scores and IB scores per subject
Progress Tracker — Show each student's performance progression across Term 1 → Term 2 → Term 3 → Term 4, with charts
School vs IB Comparison — Compare school term averages against final IB results, overall and subject-wise
Top Students — School — Overall top students (by total/average score) and subject-wise top performers across school terms
Top Students — IB — Overall top IB students and subject-wise top IB performers
Use charts, conditional formatting, and a clean visual layout for the dashboard