This repository contains the full course materials and sample projects for Introduction to Data Science with Python & Flask, designed for junior high school students who have already completed an introductory Python course.
📘 Deskripsi Kursus
This course introduces students to the world of data science through Python, SQL, and Flask. Learners gain hands-on experience with database management, data analysis, and web development. The program concludes with a final project where students build a simple data-driven web application.
🎯 Tujuan Pembelajaran
- Refresh and apply core Python programming concepts
- Understand and interact with databases using SQL
- Analyze data using SQL and Python with Pandas
- Create basic visualizations using Matplotlib
- Build a simple web app using Flask and connect it to a database
- Plan, implement, and present a complete data project
🗂️ Struktur Kursus (8 Sesi – 3 Jam/Sesi)
| Sesi | Topik | Fokus Utama |
|---|---|---|
| 1 | Python Basics Refresher | Logic games, debugging, review challenges |
| 2 | Introduction to DBMS & SQL (Part 1) | SQLite, SELECT, INSERT using Python |
| 3 | Querying & Analyzing Data (Part 2) | SQL conditions, Pandas, Matplotlib |
| 4 | Flask Web Development (Part 1) | Hello World, routing, returning HTML |
| 5 | Flask with Database & User Interaction | Forms, templates, dynamic queries |
| 6 | Review + Final Project Planning | Recap, idea generation, proposal review |
| 7 | Final Project Implementation | Building and polishing the app |
| 8 | Final Project Presentation | Demo, peer feedback, reflection |
🧪 Contoh Proyek
- Book Search App: Search books by author or genre using a web form.
- Pokémon Stats Explorer: Filter Pokémon by type and view average stats.
- Student Grades Analyzer: Analyze scores and visualize grade distributions.
- Weather Data Summary: Analyze and display trends in temperature data.
🛠 Tools & Software Requirements
- Python 3.x
- SQLite3 (built-in with Python)
- Flask (pip install flask)
- Pandas (pip install pandas)
- Matplotlib (pip install matplotlib)
- VS Code (or any preferred editor)
- Optional: Jupyter Notebook, DB Browser for SQLite
📚 Referensi
- Beginning Programming with Python (2nd Ed) – John Paul Mueller
- Starting Out with Python (4th Ed) – Tony Gaddis
- Python 3 for Absolute Beginner – Tim Hall & J. P. Stacey
- Flask Documentation
- SQLite Tutorial
- Pandas Documentation
- Matplotlib Documentation
🧮 Skema Penilaian
| Component | Weight |
|---|---|
| Attendance & Participation | 20% |
| Assignments & Activities | 20% |
| Final Project – Implementation | 30% |
| Final Project – Presentation | 30% |
📌 Prasyarat
Completion of the Introduction to Python Programming course