QCE Digital Solutions Unit 4: Reading external data from files and databases
Students read and write text, CSV and binary files and run SQL from Python using sqlite3.
One content description from the full QCE Digital Solutions Unit 4 — Prototype Digital Data Exchanges journey. All 11 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (11)
1
File Operations – Open
2
Plain text (TXT) files: structure
3
File Operations – Read
4
File Operations – Write
5
Files – Error Handling (try/except)
6
Splitting a line into fields with .split()
7
Reading a CSV file into an array of records
8
Writing records to a CSV file
9
Reading and writing binary files
10
Connecting to a SQLite database with sqlite3
11
Running SQL from Python: execute, fetchall and commit
For Teachers
Add this journey to your class and track every student in real time.
Create a free teacher account →No credit card. No setup fee. Make a class and invite students in under three minutes.
For Students
Start this journey on Cloodit — track progress, earn badges, and play live sprints with your class.
Start Learning Free →