Automated data analysis using AI and Excel macros for sustainable research
Course Overviewวิชา
This course aims to develop skills in research data management and analysis by integrating Artificial Intelligence (AI) with Microsoft Excel Macros to enhance efficiency and reduce repetitive tasks. Learners will explore data preparation, processing, statistical analysis, and automated report generation. The course also emphasizes the application of AI to support data interpretation and effective visualization of research findings. Through practical applications, learners will gain the ability to improve research accuracy, streamline workflows, and save time. Ultimately, the course promotes the effective use of digital technologies to support high-quality, efficient, and sustainable research practices.
Learning Objectives
CLOs1:
Record and edit basic Excel Macros to automate repetitive spreadsheet tasks.
CLOs2:
Utilize AI tools to write, debug, and optimize VBA scripts for custom research functions.
CLOs3:
Build automated data pipelines that import and refine unstructured datasets from various sources.
CLOs4:
Execute automated statistical tests and generate dynamic visualizations using a hybrid AI-Macro approach.
CLOs5:
Standardize reporting procedures to ensure research data is presented professionally and sustainably for peer review.
Course Assessment and Evaluation Criteria
- Length
- Price
- Level
- Target Group
- How To Pass
- Certificate
- Total learning time is 5 hours.
- Free of charge
- Beginner
- students and the general public
- Learners must achieve a total score of at least 60%.
- Available
- Category
Education | SDG4 | SDG9
Instructor
- Dr. Vineeth Vijayan
- Faculty of Engineering
