Utilized VLOOKUP and Analyzed Course Specializations

2 min read

Utilized VLOOKUP and Analyzed Course Specializations

  • Day: 2024-07-08
  • Time: 22:00 to 00:00
  • Project: Teaching
  • Workspace: WP 2: Operational
  • Status: Completed
  • Priority: MEDIUM
  • Assignee: Matías Nehuen Iglesias
  • Tags: VLOOKUP, Google Sheets, Excel, Python, Data Analysis, Curriculum

Description

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.

Evidence

  • source_file=2024-07-08.sessions.jsonl, line_number=1, event_count=0, session_id=2e6b7de186412137dc798d5e7be83b56116e5a4dfabdaa84912e5e35eab25353
  • event_ids: []

Graph View

Backlinks