School Management Dashboard with Dynamic Top - Student Photos

Practice First: School Management Dashboard Excel Dataset

The main purpose of this blog is to give you the dataset to practice building the School Management Dashboard as an Excel Dashboard. Use this practice Spreadsheet Template to follow the steps below, then customize lists, slicers, and visuals for your school.

How this fits your Dashboard Templates workflow

The structure adapts across Dashboard Templates: you can replicate it as a Google sheets dashboard or a Power BI Dashboard, and present highlights in a PowerPoint Dashboard using your existing Power Point templates.

Unique Features

• Full explanations of database columns and formulas
• Analysis for +20 types of data
• Wide Screen – Full HD
• Preview images included • Free Font & Icons
• Easy Customize • All objects and database are fully editable
• Exclude Logo

Dashboard Contents & Analysis

Workbook structure and what each sheet provides:

Data & Model Sheets

• 1st sheet (Database): master records for students, teachers, schools, parents, activities, and events.
• 2nd sheet (Pivot Tables): pivots driving dashboard values and charts.
• 3rd sheet (Dynamic Images): setup for dynamically changing student photos.

Main Dashboard (4th sheet)

• Total counts of Teachers, Students, Schools, Parents
• Students by educational stage (Primary, Elementary, Preschool)
• Summary for Activities & Events
• Top 3 students (name, photo, percentage) changing dynamically via slicers
• Yearly and monthly slicers

Events & Teachers Views

• 5th sheet (Events): full details of Activities & Events
• 6th sheet (Teachers): teacher photos, names, titles, subjects, and comments

Package Includes

• Excel – XLSX format (2.06 MB)
• Instruction File
• Help & Contents File

Watch the Tutorial

Watch the full School Management Excel Dashboard tutorial on our Other Levels YouTube Channel

Download the Dataset

Download Free Dataset