Grade Distribution Insights

Exploring the DP Overview Page: Grade Distribution Insights 📊

The Grade Distribution Table at the bottom of the DP Overview page in SpotLight provides a detailed look at how student grades are spread across subjects, terms, and classes. This guide explains how to read the table, apply filters, and export the data for further analysis.

1. Overview of Grade Data Table

The table summarizes grades for students across subjects and terms. It includes multiple metrics per class, such as the number of students, average grade, and the distribution of grades achieved.

• Rows: Represent individual classes within the selected filters. Scroll down to view all rows, and adjust how many rows per page.
• Columns: Include class name, number of students, average grade, and breakdown of grades. Scroll across for all columns.
• Grade Distribution: Shows how many students achieved each DP grade level within the class.

Full Grade Distribution table showing multiple classes, student counts, average grades, and grade breakdowns.

Tip: Scroll horizontally to view all columns, especially if your school has multiple metrics displayed.

2. Filtering the Table

Filters on the left-hand panel allow you to focus on specific subjects, academic years, or terms. The table updates dynamically to reflect the selected filters.

1. Select an Academic Year (e.g., 2024–2025).
2. Choose a Semester or Term (e.g., Semester 1).
3. Select a Subject (e.g., Mathematics).
4. The table will update to show only the relevant classes and their grade distributions.

Example: Applying the filters for a five year period, all terms, Mathematics Analysis and Approaches displays 10 classes, each with the number of students, average grade, and distribution of grades.

Filter panel with Academic Year, Term, and Subject selected, updating the table dynamically.

3. Understanding Each Column

• Class Name: Identifies the class or group within the subject.
• Number of Students: Total students in that class.
• Average Grade: Mean grade achieved by the class.
• Grade Distribution: Number of students achieving each DP grade (1–7) or unassigned.

Hover over or click on the distribution numbers to quickly see which grades are most common in a class.

Understanding the Data

Below is a transposed view of a Grade Distribution export. Each row explains the meaning of a column in the export using an example.

Column	Example	Explanation
TERM	June 2016-June 2017 - Trimester One	The academic period for the report or exam.
EXAM DATE	2016/11/21	The date the assessment was completed.
SUBJECT GROUP	Studies in language and literature	The subject category or group.
SUBJECT NAME	English	The specific subject taught.
DIPLOMA LEVEL	DP1	The year or grade level of the student cohort.
CLASS LEVEL	SL	Indicates Standard Level or Higher Level.
TYPE	Term Report	Type of report or assessment.
STUDENT COUNT	33	Number of students in the class.
AVERAGE GRADE	4.88	Mean grade of the students in that class.
COUNT GRADE 1	0 (0.0%)	Number and percentage of students achieving grade 1.
COUNT GRADE 2	0 (0.0%)	Number and percentage of students achieving grade 2.
COUNT GRADE 3	1 (3.0%)	Number and percentage of students achieving grade 3.
COUNT GRADE 4	13 (39.4%)	Number and percentage of students achieving grade 4.
COUNT GRADE 5	10 (30.3%)	Number and percentage of students achieving grade 5.
COUNT GRADE 6	7 (21.2%)	Number and percentage of students achieving grade 6.
COUNT GRADE 7	2 (6.1%)	Number and percentage of students achieving grade 7.

📌 Each row in this table corresponds to a column from the export and explains the data it contains using a concrete example.

4. Exporting Data

You can export the currently filtered data to use in other tools for analysis or reporting.

1. Right-click anywhere on the table.
2. Choose Export and select either CSV or Excel.
3. The exported file will contain all the data currently visible in the filtered table.

Exporting is useful for sharing performance reports with colleagues or performing further analysis outside SpotLight.

Right-click menu displaying options to export the filtered table to CSV or Excel.

Data will be arranged with rows per report and columns per data field.

5. Drilling into Terms

Click on a specific term in the table to navigate to the DP Term Overview. This view provides detailed insights about performance for that period.

Tip: Term-level details allow deeper analysis of trends, supporting targeted interventions for students or classes.

Select a term from the table to drill down deeper.

The DP Term Overview page will open, with detailed performance insights for that term.

6. Video Walkthrough

---

Summary

• Grade Distribution Table: Shows students’ grades per class, subject, and term.
• Filters: Narrow down by Academic Year, Term, or Subject to explore specific data.
• Export: Download filtered results in CSV or Excel for further analysis.
• Drill into Terms: Click on a term to see detailed performance insights.

✨ Explore the table in SpotLight to better understand student performance and identify trends across your school.