Grade 12 — CS Boards + Capstone 🚀
Students master functions, files, data structures, SQL and networks, apply Pandas/NumPy (IP 065 track), build an app with the scho
1 Week 1
Functions & Parameters
Define functions with positional and default parameters and return values.
▶ Start now
2 Week 2
Scope & Return Values
Distinguish local vs global scope and use multiple return values.
▶ Start now
3 Week 3
Recursion
Solve problems recursively and identify base and recursive cases.
▶ Start now
4 Week 4
Exception Handling
Handle runtime errors with try, except, else and finally.
▶ Start now
5 Week 5
Text Files: read & write
Open, read, write and append text files using with-blocks.
▶ Start now
6 Week 6
File Pointers: seek & tell
Use seek() and tell() to navigate within a file.
▶ Start now
7 Week 7
CSV Files
Read and write CSV data using Python's csv module.
▶ Start now
8 Week 8
Binary Files & Pickle
Serialise and retrieve Python objects with binary files and pickle.
▶ Start now
9 Week 9
Board Practice: Functions, Exceptions & Files
Consolidate functions, exception handling and file I/O through exam-style problems.
▶ Start now
10 Week 10
Term 1 Checkpoint
Demonstrate functions, exceptions and file handling mastery.
▶ Start now
11 Week 11
Stacks with Lists
Implement a LIFO stack using lists with push and pop.
▶ Start now
12 Week 12
Queues & Applications
Describe FIFO queues and contrast them with stacks.
▶ Start now
13 Week 13
Linear & Binary Search
Implement linear and binary search and compare their efficiency.
▶ Start now
14 Week 14
Bubble & Insertion Sort
Trace and code bubble and insertion sort on a list.
▶ Start now
15 Week 15
DBMS & Relational Model
Explain DBMS concepts, relations, tuples, attributes and keys.
▶ Start now
16 Week 16
SQL CRUD & WHERE
Create tables and run INSERT, SELECT, UPDATE, DELETE with WHERE.
▶ Start now
17 Week 17
ORDER BY, GROUP BY & Aggregates
Summarise data with ORDER BY, GROUP BY, COUNT, SUM, AVG, MIN, MAX.
▶ Start now
18 Week 18
Mid-Year Checkpoint
Consolidate data structures and core SQL skills.
▶ Start now
19 Week 19
Basic Joins
Combine two related tables using an equi-join.
▶ Start now
20 Week 20
Board Practice: SQL, Joins & Python–DB Connectivity
Revise CRUD, aggregates, joins and connect/cursor/execute/fetch through board-style questions.
▶ Start now
21 Week 21
Network Types & Topologies
Differentiate PAN, LAN, MAN, WAN and common topologies.
▶ Start now
22 Week 22
Devices & Transmission Media
Identify hubs, switches, routers and wired/wireless media.
▶ Start now
23 Week 23
IP, DNS & Internet Services
Explain IPv4/IPv6, DNS and common internet services.
▶ Start now
24 Week 24
Cyber Safety & Security
Apply safe networking practices and identify common threats.
▶ Start now
25 Week 25
NumPy Arrays in Browser (IP 065 track)
Create and operate on NumPy arrays for fast numeric work.
▶ Start now
26 Week 26
Pandas Series & DataFrames (IP 065 track)
Load and inspect tabular data with Pandas Series and DataFrames.
▶ Start now
27 Week 27
Pandas Filtering & Grouping (IP 065 track)
Filter, sort and group DataFrame rows to answer questions.
▶ Start now
28 Week 28
Prompt Engineering & LLM Literacy
Write effective prompts for the school-provided AI assistant and recognise hallucination and bias.
▶ Start now
29 Week 29
Designing an AI-Assisted App
Plan an AI-assisted app concept around the school-provided AI assistant (no student logins).
▶ Start now
30 Week 30
Term 3 Review
Revise networks, data science and AI-app concepts.
▶ Start now
31 Week 31
Capstone Engineering Plan
Scope a multi-module project integrating Python, files and SQL.
▶ Start now
32 Week 32
Capstone Build & Integrate
Implement and connect functions, file/CSV and SQL modules.
▶ Start now
33 Week 33
Portfolio & ZIO/ICO Prep
Publish a project portfolio and practise olympiad-style reasoning.
▶ Start now
34 Week 34
Board Revision & Showcase
Revise the full 083 syllabus and present the capstone.
▶ Start now
CodeShaala · TechWave Academy Labs — real coding for every Indian school.