📅 2024-07-08 — Session: Utilized VLOOKUP and Analyzed Course Specializations
🕒 22:00–00:00
🏷️ Labels: VLOOKUP, Google Sheets, Excel, Python, Data Analysis, Curriculum
📂 Project: Teaching
⭐ Priority: MEDIUM
Session Goal
The session aimed to enhance data retrieval techniques using VLOOKUP in Google Sheets and Excel, and to analyze student specialization patterns in course selections.
Key Activities
- Google Sheets VLOOKUP: A step-by-step guide was followed to use VLOOKUP for retrieving course names based on IDs.
- VLOOKUP Formula Correction: Addressed localization issues and provided troubleshooting steps for VLOOKUP in Google Sheets.
- Excel IFERROR with VLOOKUP: Implemented IFERROR with VLOOKUP in Excel to improve error handling.
- Python Data Processing: Developed a Python script to group data by ‘CODIGO’ and output it in markdown format.
- Student Specialization Analysis: Analyzed and categorized students’ specialization patterns in course selection, identifying key themes and tracks.
- Curriculum Categorization: Categorized courses within Data Science and Computing curricula to clarify specialization paths.
Achievements
- Improved understanding and application of VLOOKUP in both Google Sheets and Excel.
- Developed a Python script for data grouping and markdown integration.
- Gained insights into student specialization patterns and curriculum categorization.
Pending Tasks
- Further refine the analysis of specialization patterns for more detailed insights.
- Explore additional error handling techniques in Excel and Google Sheets.