Project Overview: In this project, I developed a web-based exam management system to automate the process of hosting, tracking, and analyzing online exams. This system aimed to provide a secure, efficient, and interactive platform for exam administration, minimizing manual effort while enhancing performance analysis and feedback delivery.
Key Contributions & Approach:
- Web Application Development: Designed and deployed a Shiny web application that enabled seamless hosting of online exams. The system featured secure user authentication and randomized question generation to ensure exam integrity.
- Data Integration & Authentication: Integrated the Google Sheets API for user authentication, data storage, and performance tracking, streamlining exam data management and ensuring real-time access to results.
- Data Processing & ETL: Implemented ETL processes to clean and preprocess large datasets of exam responses, preparing them for efficient storage and analysis.
- Performance Monitoring & Reporting: Created self-service dashboards in Tableau and Power BI to visualize exam scores, track student performance trends, and provide actionable insights for instructors.
- Real-Time Analytics: Incorporated features such as automatic scoring, adaptive question difficulty, and a real-time progress tracker for both students and instructors.
- Impact: By automating the grading process and providing instant feedback, the system greatly improved exam efficiency, reduced manual efforts, and offered valuable insights into student performance.
Technologies & Tools Used:
- R (Shiny, ggplot2, dplyr, tidyverse)
- SQL (Data storage and retrieval)
- Google Sheets API (Data integration)
- Tableau / Power BI (Performance analytics and dashboards)
Skills Utilized:
- Web Application Development
- Data Processing & ETL
- Performance Monitoring & Reporting
- Data Visualization & KPI Reporting
Results & Impact:
- This online exam management system not only improved exam integrity but also enhanced the overall experience for both students and instructors.
- It automated grading, provided real-time feedback, and offered deep insights into performance trends through interactive dashboards, ultimately streamlining the assessment process and improving decision-making for academic staff.