03/09/2026
The Pensieve Session 5: Making Sense of Quantitative Data: A Guide to Using Pivot Tables
On 1st September 2026, the Institute for Research and Innovation (IRI) conducted the fifth session of the Pensieve Workshop Series 2026 titled “Making Sense of Quantitative Data: A Guide to Using Pivot Tables.” The session was held face-to-face in the Computer Lab (AA T2 401) and was facilitated by Dr. Aminath Waseela, Senior Lecturer at the Faculty of Education, The The Maldives National University.
The session focused on helping participants develop a better understanding of quantitative data and variables, while introducing practical approaches to preparing, organising, and analysing data effectively using Pivot Tables.
Dr. Aminath Waseela guided participants through the process of creating and navigating Pivot Tables, as well as summarizing data using counts, percentages, and descriptive statistics. Participants also explored how to compare groups, identify patterns, and use filtering and grouping techniques to make data analysis more efficient.
In addition, the session covered the creation of Pivot Charts and appropriate data visualisations, enabling participants to present quantitative findings in a clear and meaningful way. Participants also learned how to interpret Pivot Table results and apply them to real-world research questions.
This session aimed to strengthen participants’ data analysis skills and enhance their ability to transform quantitative data into meaningful insights, supporting Villa College’s commitment to advancing research capacity and evidence-based decision-making.
