OIM3640 - Problem Solving and Software Design

2025 Spring

Session 23 (4/17)

contain

Today's Agenda

Welcome/News/Announcements

  • Assignments/Project:
    • Assignment 3 (Web App): due 4/25
    • Project: I will schedule meeting with project groups.
  • Remaining Sessions:
    • 4/22: No in-person class, work on your project
    • 4/24: Web Scraping and Data Analysis
    • 4/29: Semester Wrap-up and Final Project Demo (not mandatory)

What we have learned so far...

  • Fundamental Concepts
    • Variables, Expressions, Statements, Functions
    • Pseudo-code, Error Handling, Debugging
  • Data Types: int, float, string, boolean, Nonetype, string, list, dictionary, tuple, set
  • Control Flows: Conditionals, Iterations
  • Advanced Programming Concepts
    • APIs
  • Applications
    • Building Web Application using Flask
      • HTML & CSS
      • Routing, Templates, Forms

I/O Programming

  • File I/O
    • Reading and Writing Files
    • Working with CSV, JSON, Excel files
  • Database
    • SQLite3
    • CRUD Operations

Front End/Back End/Full Stack Web Development

Flask Resources

Working on Assignment 3 & Project

  • Read project instructions
  • Work in groups or individually:
    • Discuss your approach
    • Define project scope
    • Ask any questions
    • Write code

- Please download the following files from GitHub (*resources/code*) and save to ***session21*** folder - *sed.py* - *db_demo.py* - *sqlite3_demo.py*