RBSE SS Computer Science study plan
RBSE SS Computer Science · Give each week a clear focus.
8 weeks · About 6 hours per week
Computer Fundamentals and Number Systems & Python Programming
Convert between binary, octal, decimal, and hexadecimal by hand for 20 numbers and verify each with Python's bin(), oct(), hex(), and int(x, base)
Compute 2's complement representations for signed 8-bit integers and explain overflow with two worked examples
Write Python expressions using arithmetic, comparison, and logical operators, then predict the output before running each one
Trace a 15-line Python program containing if/elif/else and a for loop on paper, recording variable values line by line
Your checkpoint
A handwritten-plus-Python notebook page showing 20 base conversions, 5 two's complement problems, and 3 traced programs with predicted vs actual output
Python Programming
Write and debug 8 short programs using for, while, and nested loops, including one that prints a pattern and one that sums a series
Define and call functions with default arguments and return values, then refactor two earlier loop programs into functions
Manipulate strings and lists using slicing, split(), join(), append(), and list comprehensions
Handle input validation with try/except for ValueError on numeric input
Your checkpoint
A single Python file with 8 working programs, each with a comment stating its input, logic, and expected output
Programming Fundamentals and Problem Solving & Python Programming
Decompose 5 word problems into algorithm steps written as pseudocode before coding
Implement the pseudocode for 3 of those problems in Python and test each with at least 3 input cases including an edge case
Explain the difference between syntax errors, runtime errors, and logic errors using one example of each from your own code
Draw flowcharts for a conditional and a loop using standard symbols (terminal, process, decision, input/output)
Your checkpoint
An algorithm notebook with 5 pseudocode solutions, 3 tested Python implementations, and 2 flowcharts
Data Structures and Algorithms
Implement linear search and binary search in Python and count comparisons for a 16-element list
Implement bubble sort and selection sort and compare their pass-by-pass output on the same list
Perform stack operations (push, pop, peek) using a Python list and trace an underflow case
Perform queue operations using collections.deque and explain why a plain list is inefficient for dequeue
State the time complexity of each implemented algorithm in Big-O terms
Your checkpoint
A data structures script with 5 algorithms, printed comparison counts, and a one-page Big-O summary table
Database Management Systems and SQL
Design an ER diagram for a small library or school system showing entities, attributes, primary keys, and one-to-many relationships
Write CREATE TABLE statements with primary key, foreign key, NOT NULL, and UNIQUE constraints
Write and run 10 SELECT queries covering WHERE, ORDER BY, GROUP BY, HAVING, and aggregate functions
Write INSERT, UPDATE, and DELETE statements and verify each change with a follow-up SELECT
Join two tables with INNER JOIN and explain the result rows in writing
Your checkpoint
A SQL script that builds and populates 2 related tables plus a query log of 12 queries with their outputs
Database Management Systems and SQL & Computer Networks and Internet
Normalize a sample table to 1NF, 2NF, and 3NF and justify each step in one sentence
Distinguish DDL, DML, and DCL commands and classify 9 given SQL statements
Label the layers of the OSI and TCP/IP models and match 6 protocols (HTTP, FTP, SMTP, TCP, UDP, IP) to their layers
Convert between IP address and binary form for 5 addresses and identify the network and host portions of a given subnet mask
Explain the roles of DNS, DHCP, and a router in loading one web page
Your checkpoint
A two-part sheet: a normalization walkthrough with final 3NF tables, and a networking diagram with 10 labeled protocol/device facts
Cyber Security and Emerging Technologies & Computer Networks and Internet
Describe 5 common attack types (phishing, malware, SQL injection, brute force, man-in-the-middle) and one concrete defense for each
Explain symmetric vs asymmetric encryption and hashing with one everyday use case per concept
Define cloud computing, IoT, AI, and blockchain and give one realistic application of each
List 6 personal cyber-hygiene practices and connect each to a specific threat it reduces
Your checkpoint
A one-page threat-and-defense reference table with 5 attacks, 5 defenses, and 4 emerging-technology definitions
Practical Work and Project & Computer Fundamentals and Number Systems & Programming Fundamentals and Problem Solving & Python Programming & Data Structures and Algorithms & Database Management Systems and SQL & Computer Networks and Internet & Cyber Security and Emerging Technologies
Build a small capstone program (for example, a student record manager using a list of dictionaries and a SQLite table) with input validation and at least 4 functions
Write a project report covering problem statement, algorithm, code listing, test cases, and limitations
Complete 40 mixed-topic practice questions under timed conditions and log every wrong answer with its correct reasoning
Re-derive the 5 facts you missed most often until you can state each without notes
Your checkpoint
A submitted capstone project folder (code, report, test output) plus a completed error log of 40 practice questions
Milestones
Week 2: You can write a working Python function with a loop and conditional from scratch in under 10 minutes and correctly predict its output before running it
Week 4: You can implement binary search and bubble sort from memory and state their Big-O complexity without referring to notes
Week 6: You can write a multi-table SQL query with GROUP BY and a JOIN that runs without error, and you can label all 7 OSI layers in order
Week 8: You score at least 70% on the 40-question timed mixed practice set, and your capstone program runs all listed test cases without failure