Domain: Educational Administration, Testing & Assessment, Regional Compliance
Development Tools: Microsoft Excel (Advanced Power Pivot Data Model, Logic Automation Engines, Relational Lookups)
During high-stakes testing cycles like the EmSAT, education analysts must handle two major variables: tracking student learning outcomes across distinct academic curricula and monitoring ground-level school compliance risks.
This project establishes a comprehensive data tracking framework that merges these two operational layers. By creating a 200-row student testing engine and an institutional readiness scorecard across 10 school networks, this framework replicates an authentic Ministry workflow.
The finalized interactive Executive KPI Dashboard features automated data tiering, customized conditional formatting alert layers, a backend data model connection, and an elegant row-collapsed user interface. This provides senior leadership with a clear visual diagnostic tool to monitor testing readiness and academic performance in unison.
The system was split across two core operational sheets, both formally converted into dynamic Excel Tables to ensure immediate data scaling and dynamic downstream query updates.
Assessment_Data)
A database containing 200 rows of mock standardized testing records designed to evaluate structural performance trends.
="DXB-2026-" & TEXT(ROW()-1, "000")
(Result: Populated static, sequential IDs from DXB-2026-001 to DXB-2026-200)
Emirate (Dubai, Abu Dhabi, Sharjah, Ajman), School_Type (Public, Private), Curriculum (MoE, CBSE, IGCSE), Subject (Mathematics, Science, English), Raw_Score (values between 40 and 100), and Assessment_Cycle (Term 1 Baseline, Mid-Year Review).Operational_Readiness)
An administrative project management scorecard monitoring 10 physical school networks (SCH-01 to SCH-10) hosting the national examinations across five primary metrics: