Developed Curriculum for Data Science and SQL Classes

  • Day: 2024-04-10
  • Time: 03:00 to 04:40
  • Project: Teaching
  • Workspace: WP 2: Operational
  • Status: In Progress
  • Priority: MEDIUM
  • Assignee: Matías Nehuen Iglesias
  • Tags: Data Science, SQL, Education, Curriculum Design, Python, Pandas

Description

Session Goal:

The session aimed to develop and outline curricula for various data science classes, focusing specifically on Python, Pandas, and SQL.

Key Activities:

  • Designed a slide structure for a data science class using Python and Pandas, detailing objectives, content, and teaching methodology.
  • Outlined strategies for contextualizing a data management class, emphasizing the relevance of data skills and their interdisciplinary nature.
  • Created a theoretical class design focused on efficient interaction, suggesting specific pedagogical approaches.
  • Proposed a detailed structure for a theoretical SQL class, highlighting its importance in data science and providing a comprehensive content scheme.
  • Developed an introductory script for a presentation on SQL, covering its history, relevance, and comparisons with NoSQL.
  • Compiled potential interview questions for database programmers, including guidance on topics like entity-relationship models, relational algebra, normalization, and SQL vs NoSQL.
  • Explained the transformation of entity-relationship models to relational models in database design, focusing on primary keys, foreign keys, and normalization.

Achievements:

  • Completed the design and structure for multiple data science and SQL classes.
  • Developed comprehensive guides and scripts for teaching and presentation purposes.

Pending Tasks:

  • Finalize the presentation slides for each class.
  • Review and integrate feedback from peers or educational experts to refine the curricula.

Evidence

  • source_file=2024-04-10.sessions.jsonl, line_number=0, event_count=0, session_id=33280ae577b91a70d3502463452bbe0fef0b15e7933e807f52b0bbeba4b86fba
  • event_ids: []