Advanced spreadsheets, relational databases, and algorithmic thinking.
Designed for offline delivery on shared lab computers — no theory-only sessions, every week ends with something the student made, built, typed, or designed. Select a term to see its full breakdown.
Formula audit tools, cell dependencies.
Writing IF statements: =IF(cell >= value, "Pass", "Fail").
Constructing nested IF statements for grading.
Dynamic cell highlighting based on conditions.
Input restrictions, dropdown lists, numeric ranges.
VLOOKUP syntax, lookup values, table arrays, column indices.
CONCATENATE, LEFT, RIGHT, UPPER, date math.
Construct an automated 'School Inventory & Sales Ledger'.
Construct an automated 'School Inventory & Sales Ledger'.
Relational databases, tables, keys.
Entities, attributes, primary/foreign keys.
Field properties, data types, input constraints.
Designing user-friendly form layouts.
Building parameter queries to filter records.
Connecting foreign keys to pull combined data.
Formatting query output into printable PDF reports.
Create a 'Library Management Database' with forms and queries.
Create a 'Library Management Database' with forms and queries.
Step-by-step instructions, deterministic logic.
Structured START, INPUT, IF/ELSE, WHILE, END logic.
Oval, Parallelogram, Rectangle, Diamond symbols.
Mapping algorithms to Scratch code.
Loops and conditional blocks in code.
Sorting numbers, string processing logic.
Stepping through variables manually to find bugs.
Design a flowchart and Scratch script for a GPA Calculator.
Design a flowchart and Scratch script for a GPA Calculator.