RSIL TechnologyRSIL Technology
Sign in
← Python for school students

First-year engineering · serious builders

Advanced Python

How real Python applications are built: program structure, files and SQLite, NumPy, pandas, data pipelines, pygame, charts and HTTP APIs — the libraries and habits used in labs, internships and products.

Your progress (this browser)

0%

0 of 9 lessons complete

Level exam

  1. Lesson 1 · 40 min

    Applications, not scripts

    A script is a page of steps you run once. An application is a small machine: a door (main), a config (what changes per school), a domain lay…

    Start

  2. Lesson 2 · 42 min

    Files, CSV and memory that survives

    When a program stops, variables evaporate. Attendance, marks and inventory must live on disk. The simplest professional format is CSV: one h…

    Start

  3. Lesson 3 · 44 min

    SQLite — a database in one file

    CSV is a photograph of a table. A database is a living table: insert a row, query a subset, update one field, survive two programs opening i…

    Start

  4. Lesson 4 · 42 min

    NumPy — whole columns at once

    A Python for-loop over 500,000 temperatures is correct and slow. NumPy stores a typed block of numbers (an ndarray) and runs the same add/mu…

    Start

  5. Lesson 5 · 46 min

    pandas — filter, group, join

    If Excel is the language of offices, pandas is Excel that you can put in git, test, and run every night. A DataFrame is a named table: rows …

    Start

  6. Lesson 6 · 42 min

    Data operations — a pipeline you can trust

    A one-off notebook is not a product. A pipeline is: extract (files, APIs, SQLite), transform (clean, filter, join, aggregate), load (a dashb…

    Start

  7. Lesson 7 · 44 min

    pygame — real-time applications

    A game, a robot dashboard, a lab simulator and a kiosk quiz are the same architecture: a loop that never ends until the user quits. Each pas…

    Start

  8. Lesson 8 · 42 min

    Charts, HTTP and other working libraries

    A principal will not read a list of 1,200 floats. matplotlib (and seaborn) turn columns into a picture. requests (or httpx) pull JSON from a…

    Start

  9. Lesson 9 · 48 min

    Capstone — a small campus application

    Put the pieces in one picture. A lab utilisation tool: SQLite (or CSV) holds seats and occupancy, pandas (or loops) computes percent, a rule…

    Start