Excel Dashboard – Student Scorecard

Excel Dashboard – Student Scorecard

Want to build a student performance dashboard in Excel? This guide shows how to go from raw scores to clean visuals.

🧩 Structure

1. Random Data Generator
2. Cleaned Data Sheet
3. Pivot Table with Avg/Min/Max
4. Charts: Pass/Fail Pie + Score Line Graph
5. Slicer for Gender & Subject

📘 Key Formulas

• =IF(Marks>=40, "Pass", "Fail")
• Data Validation for no duplicate names

Bonus: Use Power BI for advanced visuals with drill-downs and card summaries.