Analytics

My analytics work is focused on extracting practical insights from Moodle data to support decision-making and intervention. I work primarily with SQL and Excel to uncover patterns in attendance, engagement, and performance across courses.

Site-Wide SQL Reporting

Moodle’s default reporting is limited to course-level. I built custom SQL reports to provide site-wide overviews, including average attendance calculations and engagement summaries. These reports are used to support programme reviews and cross-cohort comparisons.

Attendance and Engagement

I created a reporting method that calculates average attendance per course by dividing the number of ‘present’ marks by total attendance sessions. I also developed engagement tracking using custom site-wide scales, allowing for broader analysis across teaching teams.

Year-on-Year Trends

I analysed performance across academic years, including a marked increase in failure rates in 2023–24. This was the first year back to paper exams after Covid and highlighted the impact of format shifts and disrupted learning habits.

Visual Analysis

To quickly assess data properties, I used Excel for visual inspection of distribution (to check for normality) and conditional formatting to highlight trends. This made it easier for non-specialists to interpret the data without needing statistical training.