This repository contains an interactive Excel dashboard and comprehensive report analyzing the Term 3 2024 student survey results for Arc, the student organization at the University of New South Wales (UNSW). The analysis is based on 2,535 student responses collected from October 10-29, 2024, providing critical insights into student engagement, membership patterns, and program effectiveness.
This dashboard was deliberately developed using just Microsoft Excel (Python for data cleaning) rather than more specialized data visualization tools for a critical reason: stakeholder accessibility. While more advanced visualization platforms were considered, the primary goal was to create an analytical tool that would be actively used by all stakeholders, regardless of their technical expertise.
-Immediate usability without additional training
-Ability for stakeholders to explore the data independently
-Easy sharing and modification within the organization's existing workflows
-Sustainable long-term use without specialized software dependencies
Access to Interactive Dashboard: https://github.com/z5450851HimaMallina/Arc_unsw/blob/main/Dashboard_surveyarc.xlsx
- 95% membership penetration rate among surveyed students
- Membership composition: 77% undergraduate, 23% postgraduate
- Nearly equal domestic (53%) and international (47%) students
- Predominant off-campus population (84%)
- Significant first-year engagement with sharp decline in subsequent years
- Clubs & Societies: Highest engagement program (40% cited as membership reason)
- Volunteering: Strong satisfaction but low awareness (16% unaware of opportunities)
- Social Media: Instagram (59.6%) and Facebook (32%) dominate, with potential missed engagement for international students on other platforms
- Support Services: Legal Help/Advocacy shows high satisfaction but low awareness (35% N/A responses)
- Social connection is the strongest driver (45% of responses)
- Financial pressures identified as primary concern
- Different priority patterns between domestic and international students
The Excel dashboard provides:
- Interactive filtering by study level, domestic/international status, and year of study
- Demographic breakdowns (membership status, study level, living situation)
- Program engagement metrics and satisfaction ratings
- Social media preference analysis
- Priority analysis by student segment
Arc_Dashboard_T3_2024.xlsx- Interactive Excel dashboardSurvey_Report_T3_2024.pdf- Comprehensive analysis report
- Download the Excel dashboard file and survey report
- Open in Desktop Excel (recommended for full functionality)
- Use filter controls in the yellow section to segment data
- Navigate between dashboard tabs for different analysis views
- Develop targeted retention programs for second-year students
- Create "Second-Year Ambassador" leadership volunteer programs
- Connect club membership and volunteering opportunities
- Diversify social media presence beyond Instagram/Facebook
- Enhance awareness of underutilized support services
- Improve accessibility for off-campus and satellite campus students
- Develop food-based integration programs connecting domestic and international students
- Create skills-for-impact programs that address different student priorities
- Strengthen pathways from initial engagement to leadership opportunities
This analysis was conducted by [Your Name], Data Analyst focusing on student experience metrics. Dashboard design and visualization by Hima Mallina.
For inquiries or collaborations, feel free to connect with me on [www.linkedin.com/in/himarohinimallina] or check out more of my work on (https://github.com/z5450851HimaMallina).
Thank you